How would I know the header values to be inserted here. In sample we are using the hardcoded text but in real we need it to come via grid's own data.

Please post the complete sample

Hi,

Achieving the same with more grids would follow the same approach - returning false in the exportEnding event and executing the same logic with the workbooks in next grid exporting event. Setting the columns name correctly would involve just writing value to the cell in the exportEnding event, like:

worksheet.rows(0).setCellValue(0, "text") - this will write "text" into the the first cell in the first row of the worksheet, which would be the headers row.

Hello,

I am interested in the same thing. Please give an example of how to set the column names correctly on the second worksheet.

Also, how would this be done with 3 or 4 or 5 grids?

Thank you

Hello,

I have prepared a sample demonstrating how you can export two igGrids into the same excel file into different worksheets. Since this is a custom approach it may need a slight modification if you want to export more than two grids. The approach that is taken follows the scenario that:

1) Export first grid and handle the exportEnding event

2) In the exportEnding event call a function that exports the second grid and pass the workbook that contains the first grid as argument to the function

       exportEnding: function(sender, args) {
        exportSecondGrid(args.workbook);
        return false;
       }

3) Handle the headerCellExporting event for the second grid, where you change the default workbook with the workbook we already have. Also we add a new worksheet to this workbook, where the second grid will be exported:

      headerCellExporting: function(sender, args) {
       if (args.columnIndex === 0) {
        sender._workbook = workbook;
        sender._workbook.worksheets().add(sender._worksheet.name());
        sender._worksheet = sender._workbook.worksheets(1)
       }
      },

Please note there is a slight drawback of this scenario: since we add the new worksheet when exporting headers had started, the second worksheet will have default strings applied to column names. This can be corrected for example in headerCellExported event. Please let me now if you would need assistance on how to achieve this.

Thanks for the quick response.

I was asking about exporting the igGrid - the javascript control, not the ASP.NET server control.

thanks