Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Tue Jun 03, 2014 10:28 am

Dear all,
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

jagadeesh_21
 
Posts: 1
Joined: Tue Jun 03, 2014 10:12 am

Wed Jun 04, 2014 2:19 am

Dear Jagadeesh,

Thanks for your inquiry.
Would you please share your csv file to help us to do an investigation?
If it is inconvenience to share here, please send your file to support@e-iceblue.com or amy.zhao@e-iceblue.com.

Thanks.
Best wishes,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Return to Spire.XLS