i am new to this forum, i have large csv file,the size of the file is 14 MB(2457600 values),i need to convert this csv file to excel file so i downloaded Spire.Xls.dll and add as a reference to visual studio 2010.At the time of conversion i got the error i,e, {"Specified argument was out of the range of valid values."},so anybody please tell me what is my mistake i am sending my c# code in code block
- Code: Select all
Workbook wb = new Workbook();
wb.LoadFromFile(@"E:\pendrivedata1_5_12\JAGADEESH (G)\25 to 40mm\L3R2A4.CSV",",",1,1); //Eror comes here
Worksheet sheet = wb.Worksheets[0];
wb.SaveToFile(@"E:\pendrivedata1_5_12\JAGADEESH (G)\25 to 40mm\result.xls", ExcelVersion.Version97to2003);
Thanks in advance
with regards,
Jagadeesh