2

I am using igTreeGrid to show data in table and export that data into excel file

Click here For Example

its working perfect for me but i am facing problem to set exported grid columns width and set excel sheet collapsed by default.

I have searched $.ig.GridExcelExporter.exportGrid Documentation but found nothing

is there any way to do this task in $.ig.GridExcelExporter or anything else.... ??

I also find some helpful material in this Link (Click here)

Konstantin Dinev
  • 34,219
  • 14
  • 75
  • 100
zulqarnain jalil
  • 21
  • 2

1 Answers1

5

Infragistics excel client library currently does not support collapsing or expanding the Outline(group) data.

The columns widths can be configured by using the exportEnding callback.

exportEnding: function(sender, args) {
    var worksheet = args.worksheet;
    var columns = worksheet.columns();

    for (var i = 0; i < columns.count(); i++) {
        var column = columns.item(i);

        // This will set all columns to be 44 pixels
        column.setWidth(44, $.ig.excel.WorksheetColumnWidthUnit.pixel);
    }
}
dgeorgiev
  • 51
  • 2