Loading CSV File Takes a While

[Administrator]

I have a 6 MB csv file that takes about 60 seconds for the Workbooks.Open method to execute. I only want to display the first 10 rows to the user. Is there a quick and dirty way I can achieve this without loading the entire file into the object?

ExcelEngine excel = new ExcelEngine();
IApplication app = excel.Excel;

IWorkbook workbook = app.Workbooks.Open(pFilePath,",");

Thanks,
Josh

[Geetha M]

Hi Josh,

Thank you for your interest in Syncfusion products.

I am afraid that I am not able to reproduce the problem. I tried opening a csv file of size 6 MB and it took less than 17 seconds in v7.1.0.21. Could you please let me know the version number you are currently using?

Regards,
Geetha