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
920
UltraGridExcelExporter - How to add extra columns and rows while exporting grid
posted

Hi

I am exporting grid data to Microsoft Excel and I need to add extra blank columns and rows in the Excel worksheet.  These extra columns and rows do not have data associated with them and are only use to separate the data into blocks.

For example, I have 12 columns of monthly data for a financial quarter so there are 4 columns for January, 4 for February and 4 for March.  I have to separate the January/February and February/March data with blank columns.

The rows are data for several categories.  I have separate each category with a blank row.

I'm not clear which events and methods I can use generate this output while exporting the grid data with UltraGridCellExporter.  I am using version 12.2.

Any help greatly appreciated.

Regards

James O'Doherty, Solution and Database Architect, Landesbank Berlin AG, London

 

 

Parents
  • 48586
    Verified Answer
    posted

    Hello,

     

     In order to insert blank  columns only in the exported Excel file you should handle ExportStarted event of UltraGridExcelExporter and to add needed columns to the exported layout. About the blank rows you could add them to the data source before exporting and to remove them when exporting ends. I have implement my suggestion in a small sample, please run the sample and let me know if this is what you are looking for.

     

    Please let me know if you have any further questions.

    110741.zip
Reply Children