I am trying to convert a CSV file to excel using Spire.
I am calling Spire from my c# code.
It works fine for smaller files with 20-30 number of records.
If I run the same code against a csv file with 50000 records i get this error- errorspecified argument was out of the range of valid values.
I am using spire version 7.12.27.
Here is the code I am using to convert csv to excel-
- Code: Select all
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"E:\USer\test.csv", ",", 1, 1);
Worksheet sheet = workbook.Worksheets[0];
sheet.Name = "csv to excel";
workbook.SaveToFile("E:\\USer\\test.xlsx", ExcelVersion.Version2010);
Thanks,
Rooepsh