How to Optimize when load files!

[The GridLock]

Hi,

I want to ask which settings are necessary when I need to load multiple workbook(xlsio) in a short period of time in order to get the best performance. 

(ex: if I need to synthesize some files, I will need to open and read them.)

[Susmitha Sundar]

Hi khanh dang, 

 

Thank you for using Syncfusion controls. 

 

We suspect that you want to export the SfDataGrid as excel document. If so, we have provided the Exporting option for SfDataGrid. Please refer the below document, 

 

UG link: https://help.syncfusion.com/windowsforms/datagrid/exporttoexcel 

 

You can export the SfDataGrid without any performance issue. 

 

Regards, 

Susmitha S 

[The GridLock]

Hi Susmitha,

I need to get data from excel and create reports from multiple files. If normally I would need to open each file and then close them one by one. What is the optimal way?(for example I see: app.UseFastRecordParsing = True)

[Susmitha Sundar]

Hi khanh dang, 

 

Thank you for the update. 

 

We suspect that you requested query is not related to Syncfusion. How did you create the report from multiple files? Is this related to any Syncfusion control? 

Please provide the details. It will be helpful for us to check on it and provide you the solution at the earliest.   

 

Regards, 

Susmitha S 

[The GridLock]

Hi Susmitha,

it is a combination of xlsio and datagrid, using xlsio to export datatable and display in datagrid, but i will need to customize them before putting in datagrid.

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Khanh Dang, 

We do have support for exporting data from Excel worksheet to DataTable. Please look into the following link to know more about this. 

Help Link: https://help.syncfusion.com/file-formats/xlsio/working-with-data#exporting-from-worksheet-to-data-table  

Also we have different export options under ExcelExportDataTableOptions enumeration . Kindly navigate to below link to know about different export options. 

https://help.syncfusion.com/cr/file-formats/Syncfusion.XlsIO.ExcelExportDataTableOptions.html  

Regards, 

Keerthi. 

[The GridLock]

Hi Konduru,

thanks for the link, i will read it.

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Khanh Dang, 

Thanks for the update. We will wait to hear from you. 

Regards, 

Keerthi.