Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Erik Vogelsang
520
How to get the number of exported rows
posted

 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 

  • 469350
    Verified Answer
    Offline posted

    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.