Hi! First of all I want to thank You for a great component :)
I wonder what the best apporoach is for importing/exporting dataTables from/to xlsx.
Im relatively new to both programming and VS, so therefore use VB.net not c#.
On the homepage, quote: "The access to cells has been totally rewritten using dictionaries, to gain better performance. You can now load 50 000 cells in seconds."
When saving to xlsx I iterate approx 1000 rows and 400 columns, takes about 30-45 seconds.
Is this the best opproach or im I missing soemthing here?
For instance, is it possible to import and save a whole worksheet, "wsheet.ExtractToDataTable(dataTable, wsheet.Rows[start], wsheet.Columns[start])"
And similar for putting data from a table to a worksheet, setting a cellID as start cell....
I can live with the performance, but if finetunig is possible, its always welcome :)
Keep up the good work :)