Callback for the exporter events.

• cellExported

  Type:

  function

  Default:

  null

  Set a callback that is fired after the cell is exported.
  Function takes arguments sender and args.
  Use args.columnKey to get the igGrid column key of the cell.
  Use args.columnIndex to get the igGrid column index of the cell.
  Use args.cellValue to get the igGrid cell value.
  Use args.rowId to get key or index of row.
  Use args.xlRow to get reference to the worksheet row.
  Use args.grid to get reference to the igGrid widget.

  Code Sample

   
              //Initialize
              $.ig.GridExcelExporter.exportGrid($(".selector"), {}, {
                cellExported: function(sender, args) {
                  //returns the column key of the grid cell
                  args.columnKey
                  //returns the column index of the grid cell
                  args.columnIndex
                  //returns the value of the grid cell
                  args.cellValue
                  //returns the row's key or index
                  args.rowId
                  //returns reference to the current xlRow
                  args.xlRow
                }
              });
               

• cellExporting

  Type:

  function

  Default:

  null

  Cancel="true" Set a callback that is fired before the cell exporting.
  Function takes arguments sender and args.
  Use args.columnKey to get the igGrid column key of the cell.
  Use args.columnIndex to get the igGrid column index of the cell.
  Use args.cellValue to get or set the igGrid cell value.
  Use args.rowId to get key or index of row.
  Use args.xlRow to get reference to the worksheet row.
  Use args.grid to get reference to the igGrid widget.

  Code Sample

   
              //Initialize
              $.ig.GridExcelExporter.exportGrid($(".selector"), {}, {
              cellExporting: function(sender, args) {
                  //returns the column key of the grid cell
                  args.columnKey
                  //returns the column index of the grid cell
                  args.columnIndex
                  //returns the value of the grid cell
                  args.cellValue
                  //returns the row's key or index
                  args.rowId
                  //returns reference to the current xlRow
                  args.xlRow
              }
              });
               

• error

  Type:

  function

  Default:

  null

  Set a callback that is fired when exporting fails.
  Use error to get the reference of error object.

  Code Sample

   
              //Initialize
              $.ig.GridExcelExporter.exportGrid($(".selector"), {}, {
                error: function(error) {
                  //returns reference to the error object
                  error;
                }
              });
               

• exportEnding

  Type:

  function

  Default:

  null

  Cancel="true" Set a callback that is fired when export is ending, but the document is not saved.
  Function takes arguments sender and args.
  Use args.grid to get reference to the igGrid widget.
  Use args.workbook to get reference to the excel workbook.
  Use args.worksheet to get reference to the excel worksheet.

  Code Sample

   
              //Initialize
              $.ig.GridExcelExporter.exportGrid($(".selector"), {}, {
                exportEnding: function(sender, args) {
                  //returns reference to the grid widget
                  args.grid
                  //returns reference to the excel workbook.
                  args.workbook
                  //returns reference to the excel worksheet.
                  args.worksheet
                  //returns the igGridExcelExporter settings object
                  sender.settings
                }
              });
               

• exportStarting

  Type:

  function

  Default:

  null

  Cancel="true" Set a callback that is fired when the exporting has started.
  Function takes arguments sender and args.
  Use args.grid to get reference to igGrid widget.

  Code Sample

   
              //Initialize
              $.ig.GridExcelExporter.exportGrid($(".selector"), {}, {
                exportStarting: function(sender, args) {
                  //returns reference to the grid widget
                  args.grid
                  //returns the igGridExcelExporter settings object
                  sender.settings
                }
              });
               

• headerCellExported

  Type:

  function

  Default:

  null

  Set a callback that is fired after the header cell is exported.
  Function takes arguments sender and args.
  Use args.headerText to get the igGrid column key of the header cell.
  Use args.columnKey to get the igGrid column key of the header cell.
  Use args.columnIndex to get the igGrid column index of the header cell.

  Code Sample

   
              //Initialize
              $.ig.GridExcelExporter.exportGrid($(".selector"), {}, {
                headerCellExported: function(sender, args) {
                  //returns the header text of the igGrid column
                  args.headerText
                  //returns the column key of the grid cell
                  args.columnKey
                  //returns the column index of the igGrid cell
                  args.columnIndex
                }
              });
               

• headerCellExporting

  Type:

  function

  Default:

  null

  Cancel="true" Set a callback that is fired before the header cell exporting.
  Function takes arguments sender and args.
  Use args.headerText to get or set the igGrid column key of the header cell.
  Use args.columnKey to get the igGrid column key of the header cell.
  Use args.columnIndex to get the igGrid column index of the header cell.

  Code Sample

   
              //Initialize
              $.ig.GridExcelExporter.exportGrid($(".selector"), {}, {
                  headerCellExporting: function(sender, args) {
                  //returns the header text of the igGrid column
                  args.headerText
                  //returns the column key of the grid cell
                  args.columnKey
                  //returns the column index of the igGrid cell
                  args.columnIndex
                  }
              });
               

• rowExported

  Type:

  function

  Default:

  null

  Cancel="true" Set a callback that is fired after the row is exported.
  Function takes arguments sender and args.
  Use args.rowId to get key or index of row.
  Use args.element to get row TR element.
  Use args.xlRow to get reference to the worksheet row.
  Use args.grid to get reference to the igGrid widget.
  Note: When exporting an igHierarchicalGrid this callback is available only for the root grid rows.

  Code Sample

   
              //Initialize
              $.ig.GridExcelExporter.exportGrid($(".selector"), {}, {
                  rowExported: function(sender, args) {
                      //returns igGrid row key or id.
                      args.rowId;
                      //returns the row <tr> element.
                      args.element;
                      //returns reference to the worksheet row.
                      args.xlRow;
                      //returns reference to the grid widget.
                      args.grid
                  }
              });
               

• rowExporting

  Type:

  function

  Default:

  null

  Cancel="true" Set a callback that is fired before the row exporting.
  Function takes arguments sender and args.
  Use args.rowId to get key or index of row.
  Use args.element to get row TR element.
  Use args.xlRow to get reference to the worksheet row.
  Use args.grid to get reference to the igGrid widget.
  Note: When exporting an igHierarchicalGrid this callback is available only for the root grid rows.

  Code Sample

   
              //Initialize
              $.ig.GridExcelExporter.exportGrid($(".selector"), {}, {
                rowExporting: function(sender, args) {
                  //returns igGrid row key or id.
                  args.rowId;
                  //returns the row <tr> element.
                  args.element;
                  //returns reference to the worksheet row.
                  args.xlRow;
                  // returns reference to the grid widget.
                  args.grid
                }
              });
               

• success

  Type:

  function

  Default:

  null

  Set a callback that is fired when exporting is successful.
  Use data to get the reference of saved object.

  Code Sample

   
              //Initialize
              $.ig.GridExcelExporter.exportGrid($(".selector"), {}, {
                success: function(sender, data) {
                  //returns a reference to the igGridExporter class
                  sender
                  //returns exported data
                  data
                }
              });
               

• summaryExported

  Type:

  function

  Default:

  null

  Set a callback that is fired after the summary is exported.
  Function takes arguments sender and args.
  Use args.headerText to get the igGrid column header text.
  Use args.columnKey to get the igGrid column key.
  Use args.columnIndex to get the igGrid column index.
  Use args.summary to get a reference to the summary object.
  Use args.xlRowIndex to get the worksheet row index.

  Code Sample

   
              //Initialize
              $.ig.GridExcelExporter.exportGrid($(".selector"), {}, {
                  summaryExported: function(sender, args) {
                  //returns reference to the igGrid column header text.
                  args.headerText;
                  //returns reference to the igGrid column key.
                  args.columnKey;
                  //returns the the igGrid column index.
                  args.columnIndex;
                  //returns a reference to the summary object.
                  args.summary;
                  //returns a reference to the summary row index.
                  args.summaryRowIndex;
                  //returns the excel row index.
                  args.xlRowIndex
                  }
              });
               

• summaryExporting

  Type:

  function

  Default:

  null

  Cancel="true" Set a callback that is fired before the summary exporting.
  Function takes arguments sender and args.
  Use args.headerText to get the igGrid column header text.
  Use args.columnKey to get the igGrid column key.
  Use args.columnIndex to get the igGrid column index.
  Use args.summary to get a reference to the summary object.
  Use args.xlRowIndex to get reference to worksheet row index.

  Code Sample

   
              //Initialize
              $.ig.GridExcelExporter.exportGrid($(".selector"), {}, {
                summaryExporting: function(sender, args) {
                  //returns reference to the igGrid column header text.
                  args.headerText;
                  //returns reference to the igGrid column key.
                  args.columnKey;
                  //returns the the igGrid column index.
                  args.columnIndex;
                  //returns a reference to the summary object.
                  args.summary;
                  //returns a reference to the summary row index.
                  args.summaryRowIndex;
                  //returns the excel row index.
                  args.xlRowIndex
                }
              });
               

The Infragistics Grid Excel exporter client-side component is implemented as a class, and exports the igGrid control with the columnfixing, filtering, hiding, paging, sorting, and summaries features.

• columnsToSkip

  Type:

  array

  Default:

  []

  Elements Type:

  object

  List of strings containing the keys for the columns that will not be exported.

  Code Sample

   
                  //Set
                  $.ig.GridExcelExporter.exportGrid($(".selector"), {
                    // The keys of the columns that will not be exported
                    columnsToSkip: ["column1", "column2", "column3"]
                  });
                   

• dataExportMode

  Type:

  enumeration

  Default:

  allRows

  Indicates whether all sublevel data will be exported, or only data under expanded rows.

  Members

  • allRows
  • Type:string
  • All sublevel data will be exported.
  • expandedRows
  • Type:string
  • Only data under expanded rows will be exported.

  Code Sample

   
                  //Set
                  $.ig.GridExcelExporter.exportGrid($(".selector"), {
                    //Setting the dataExportMode option
                    dataExportMode: "expandedRows",
                  });
                   

• fileName

  Type:

  string

  Default:

  "document"

  Specifies the name of the excel file that will be generated.

  Code Sample

   
                  //Set
                  $.ig.GridExcelExporter.exportGrid($(".selector"), {
                    //Setting the file name
                    fileName: "Document",
                  });
                   

• gridFeatureOptions

  Type:

  object

  Default:

  {}

  List of export settings which can be used with Grid Excel exporter.

  • columnfixing

    Type:

    enumeration

    Default:

    none

    Indicates whether fixed columns will be applied in the exported table. This is set to none by default, but will change to applied if column fixing feature is defined in the igGrid.

    Members

    • none
    • Type:string
    • No column fixing will be applied in the excel document.
    • applied
    • Type:string
    • Column fixing will be applied in the excel document.

    Code Sample

     
                        //Set
                        $.ig.GridExcelExporter.exportGrid($(".selector"), {
                            gridFeatureOptions: {
                                // Exports without columnFixing enabled in the excel document
                                columnFixing: "none"
                            }
                        });
                         

  • filtering

    Type:

    enumeration

    Default:

    none

    Indicates whether filtering will be applied in the exported table. this is set to none by default, but will change to applied if filtering feature is defined in the igGrid.

    Members

    • none
    • Type:string
    • No filtering will be applied in the excel document.
    • applied
    • Type:string
    • Filtering will be applied in the excel document.
    • filteredRowsOnly
    • Type:string
    • Filtering will be exported in the excel document.

    Code Sample

     
                        //Set
                        $.ig.GridExcelExporter.exportGrid($(".selector"), {
                            gridFeatureOptions: {
                                // Exports without filtering enabled in the excel document
                                filtering: "none"
                            }
                        });
                         

  • hiding

    Type:

    enumeration

    Default:

    none

    Indicates whether hidden columns will be removed from the exported table. This is set to none by default, but will change to applied if hiding feature is defined in the igGrid.

    Members

    • none
    • Type:string
    • All hidden columns will be exported to the excel document.
    • applied
    • Type:string
    • Hidden columns will be exported as hidden in the excel document.
    • visibleColumnsOnly
    • Type:string
    • Only visible columns will be exported.

    Code Sample

     
                        //Set
                        $.ig.GridExcelExporter.exportGrid($(".selector"), {
                            gridFeatureOptions: {
                                // No columns will be hidden in the excel document
                                hiding: "none"
                            }
                        });
                         

  • paging

    Type:

    enumeration

    Default:

    allRows

    Indicates whether the rows on the current page or entire data will exported.

    Members

    • currentPage
    • Type:string
    • Only current page will be exported to the excel document.
    • allRows
    • Type:string
    • All pages will be exported to the excel document.

    Code Sample

     
                        //Set
                        $.ig.GridExcelExporter.exportGrid($(".selector"), {
                            gridFeatureOptions: {
                                // Exports the currentPage in the excel document
                                paging: "currentPage"
                            }
                        });
                         

  • sorting

    Type:

    enumeration

    Default:

    none

    Indicates whether sorting will be applied in the exported table. This is set_ to none by default, but will change to applied if sorting feature is defined in the igGrid.

    Members

    • none
    • Type:string
    • No sorting will be applied in the excel document.
    • applied
    • Type:string
    • Sorting will be applied in the excel document.

    Code Sample

     
                        //Set
                        $.ig.GridExcelExporter.exportGrid($(".selector"), {
                            gridFeatureOptions: {
                                // No sorting will be applied to the excel document
                                sorting: "none"
                            }
                        });
                         

  • summaries

    Type:

    enumeration

    Default:

    none

    Indicates whether summaries will be added in the exported table. This is set to none by default, but will change to applied if summaries feature is defined in the igGrid.

    Members

    • none
    • Type:string
    • No summaries will be exported to the excel document.
    • applied
    • Type:string
    • Summaries will be exported to the excel document.

    Code Sample

     
                        //Set
                        $.ig.GridExcelExporter.exportGrid($(".selector"), {
                            gridFeatureOptions: {
                                // No summaries will be applied to the excel document
                                summaries: "none"
                            }
                        });
                         

• gridStyling

  Type:

  enumeration

  Default:

  applied

  Indicates whether excel table styles will be the same as grid styles. This is set to applied by default. Custom grid themes are not supported.

  Members

  • none
  • Type:string
  • The styles from the grid are not applied to the table region.
  • applied
  • Type:string
  • The styles from the grid are applied to the table region.

  Code Sample

   
                  //Set
                  $.ig.GridExcelExporter.exportGrid($(".selector"), {
                          // Grid style will be exported to the excel table
                          gridStyling: "applied"
                  });
                   

• skipFilteringOn

  Type:

  array

  Default:

  []

  Elements Type:

  object

  List of strings containing the keys for the worksheet columns which will not be applied any filtering.

  Code Sample

   
                  //Set
                  $.ig.GridExcelExporter.exportGrid($(".selector"), {
                      // The keys of columns that filtering will skip
                      skipFilteringOn: ["column1", "column2", "column3"],
                   });
                   

• tableStyle

  Type:

  string

  Default:

  "TableStyleMedium1"

  Specifies the excel table style region.
  You can set the following table style
  TableStyleMedium[1-28]
  TableStyleLight[1-21]
  TableStyleDark[1-11].

  Code Sample

   
                  //Set
                  $.ig.GridExcelExporter.exportGrid($(".selector"), {
                      gridStyling: "none",
                      //Setting the table style to TableStyleDark
                      tableStyle: "TableStyleDark2"
                   });
                   

• worksheetName

  Type:

  string

  Default:

  "Sheet1"

  Specifies the name of workbook where the igGrid will be exported.

  Code Sample

   
                  //Set
                  $.ig.GridExcelExporter.exportGrid($(".selector"), {
                    //Setting the name of the worksheet
                    worksheetName: "Worksheet1",
                  });