Hi,
just wondering if 11 years after this is still my only option
I have a grid with 277 rows and 3679 columns (using nested groups)
I'm using these lines to export:
UltraGridExcelExporter excelExporter = new UltraGridExcelExporter();excelExporter.Export(grid, fileName, WorkbookFormat.Excel2007);
So far 40 min running and it didn't finish yet
Any suggestion?
thanks
I'm wondering what is causing the exponential delay...
my first grid had 277 rows and 3679 columns and took 1h46min to run
my second attempt grid had 258 rows and 1345 columns and took 6min to run (still not good, but way faster compared to my first attempt
What version are you testing with? What types of data are you exporting? Do you have a lot of Appearances defined in your grid that are therefore exporting a lot of color and styling to your Excel workbook? It's really tough to say without seeing sample code demonstrating what you are doing. There are a number of optimizations you might be able to make in your code to improve the performance. But we'd have to see the issue and debug it in order to give you any useful advice.That's a lot of data for one Excel sheet, though. Generally, I recommend filtering the data in some way to narrow down how much is in one sheet. No human user could possibly work with such a large set of data all at once.