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
Rose Anna Smith
485
WinGrid Export to Excel - Headers
posted

I recently upgraded.  Now my export to excel worksheet application doesn't line up the header rows with the data rows.  (How embarrassing for me that my user found the problem!) when using the following call:

      Me.grdExcelExporterSalesMtg.Export(Me.UltraGrid1, ws1, 2, iLastCol + 2)

In between calls to the export, I change the data in the table and add worksheets as necessary. So is there a way to get the "start column" value that maybe I could access in the HeaderRoweExporting event? or an override that automatically keeps the header and data lined up?

This is an example of what is happening:

GroupID Pieces Sales Margin % Margin %
G-1010 1010 393 $xx,xxxx xx G-CUNIT 622 $xx,xxx xx

This is what I want to happen:

GroupID Product Type Pieces Sales Margin % Product Type Pieces Sales Margin %
G-1010 1010 393 $xxx,xxx xx G-CUNIT 622 $xxx,xxx xx

 

We love the grid and the excel export. By using these tools, we have taken a job that took about 5 days each quarter to less than 4 hours each quarter.   

Thanks