Hi everybody,
We are using the UltraGridExcelExporter to Export Data from the UltraGrid to Excel 2003.We can still not use the new UltraGridExcelExporter which works with the 3.0 .NET Framework or higher. So the export to Excel 2007 which has not these limitations of 256 columns and 65536 rows is not interesting at the moment.
Our question is:How can we determine the count of all rows/columns the Excel-Workbook will have by calling the UltraGridExcelExporter's Export function. I mean before the FileLimitBehaviour throws an exception or truncates the data.
Hi,
There is no way to calculate this in advance without going through the actual export process.
Hi Mike,
thank you for your response!Do you have any suggestions how I can determine this by myself in advance?
Hello,
What is your data's architecture ? Is it possible to get the count of the rows and columns of your underling data and to check if they are over 65 536 for rows and 255 for columns ?
the datasource is a DataSet. But the datasource doesn't supports the informations if the displayed data in the UltraGrid is filtered, is grouped by, has summaries etc... Between the Bands there is also a single row spacing. So if you have much bands you must add many extra rows to the total count of rows that are getting exported. It is not possible to get these informations from the underlying data. And turning off the single row spacing behaviour is not a solution because of all the other stuff I have listed before.
Thanks for your support guys till now...
I just wanted to know if you were able to solve your issue based on Mike's suggestions or you still need help? Just let me know.
Thank you.