.NET: Most Performant Way to Populate Cells From DataTable

Aspose.Cells Product Family
1

Hi:
What’s the most performant way to load values from a .Net datatable to Aspose Worksheet cells. (Time/Memory)?
I’m using Cells.ImportDataTable right now, and I am trying to optimize the performance of my app,
If there is a better way , please let me know.
Thanks.
JS

2

@JsteinbergATBx,

Thanks for providing us details.

Well, as you are already using Cells.ImportDataTable() method to import data from datatable to worksheet cells, so this is most performant approach in general. Do you find any performance issue, kindly elaborate and provide us sample console application (runnable) to show the issue, we will check it soon. Please try using dynamic dataset/datatable in code to remove any inter dependencies for external database or data source, so we could execute your project without any issue.

3

Wow, fast reponse!
I do not have an actual performance problem at this point, I was just looking for best practices.
Should I run into issues, I’ll enter a different question.
Thanks,
JS

4

@JsteinbergATBx,

Thanks for the confirmation.

Please take your time to evaluate the API and in case you find any issue or queries, feel free to contact us any time, we will be happy to assist you soon.