Hi,
I have the problem that i want to export more than one grid to one worksheet. When i export a grid to excel i don't receive the number of exported rows or the "last" position in the worksheet. But this is what i need to be able to place the second grid and some text below the first one and so on. The grids i export are all grouped and contain summary information - so just counting the rows of the grid do not really reflect the number of rows that are exported to excel.
My question is there a way to get the number of exported rows or the last position of the inserted data of the grid?
Thank you for any help
Cheers
Michael
Hi Michael,
I think you will have to handle events of the UltraGridExcepExporter and record the last CurrentRowIndex. This is a property on the event args for lots of the events like RowExported. So you will probably just need to store the row index in a variable and use that.
You might need to handle several events. I think there are separate events for exporting summaries (although I could be wrong), so you will need to track the highest number used in all of the events.
Perfect - thank you for your help!