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,
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.
There's really just no reasonable way to calculate this. You would have to literally account for everything that will happen during the export process. You would have to account for all the parent rows, all the child rows, all of the spacing, headers, summaries, etc.
Also, it's entirely possible to change the number or position of exported rows using the events of the UltraGridExcelExporter. Of course, if you know you are not doing this, you don't have to worry about it, but it's something to consider for the future of your application.
Maybe what you could do is simply wrap the call to Export in a try...catch and if an exception is raised, handle it at that point.
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...
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 ?
Hi Mike,
thank you for your response!Do you have any suggestions how I can determine this by myself in advance?