Thanks for the quick response.

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

thanks

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

Managed to fix this myself after a bit of R&D. Posting complete code below (please excuse formatting)

function exportSecondGrid(workbook) {

var headerArr = [];
$.ig.GridExcelExporter.exportGrid($("#grid1"), {
fileName: "igGrid",
worksheetName: "Sheet2"
},
{
headerCellExporting: function(sender, args) {
// We will save all the headers coming to our array for retrieval later on
headerArr.push(args.headerText);
if (args.columnIndex === 0) {
sender._workbook = workbook;
sender._workbook.worksheets().add( sender._worksheet.name());
sender._worksheet = sender._workbook.worksheets(1);
}
},
exportEnding: function(sender, args) {
// Now use the array of headers to be updated
var row = sender._worksheet.rows(0);
for(var ind=0; ind < headerArr.length; ind++) {
row.setCellValue(ind, headerArr[ind]);
}

}
}
);

}

Use this with the original first function and everything will be perfect

Hi,

Is there any way to export two igGrids into single sheet within a workbook.

Thanks

Hi,

The URL talks about exporting 2 iGGrids into  two separate sheets. Is there a way to combine two igGrids into one single sheet.

Thanks

Hi Tufail,

Each grid is exported into a table region in a worksheet, but Excel allows only one table region to be created within a single worksheet, so trying to export second grid into the same sheet will result in an error:

"There in another table in the specified region."