Specifies whether the exported data should be formatted as Excel table. (True by default)
let exportAsTable = this.exportOptions.exportAsTable;
this.exportOptions.exportAsTable = false;Specifies if the exporter should ignore the current column order in the IgxGrid.
let ignoreColumnsOrder = this.exportOptions.ignoreColumnsOrder;
this.exportOptions.ignoreColumnsOrder = true;Specifies whether hidden columns should be exported.
let ignoreColumnsVisibility = this.exportOptions.ignoreColumnsVisibility;
this.exportOptions.ignoreColumnsVisibility = true;Specifies whether filtered out rows should be exported.
let ignoreFiltering = this.exportOptions.ignoreFiltering;
this.exportOptions.ignoreFiltering = true;Specifies if column pinning should be ignored. If ignoreColumnsOrder is set to true, this option will always be considered as set to true.
let ignorePinning = this.exportOptions.ignorePinning;
this.exportOptions.ignorePinning = true;Specifies whether the exported data should be sorted as in the provided IgxGrid.
let ignoreSorting = this.exportOptions.ignoreSorting;
this.exportOptions.ignoreSorting = true;Gets the width of the columns in the exported excel file.
let width = this.exportOptions.columnWidth;Sets the width of the columns in the exported excel file. If left unspecified or 0, the width of the largest string in the column will be used.
this.exportOptions.columnWidth = 55;Gets the file name which will be used for the exporting operation.
let fileName = this.exportOptions.fileName;Sets the file name which will be used for the exporting operation.
this.exportOptions.fileName = 'exportedData01';Gets the height of the rows in the exported excel file.
let height = this.exportOptions.rowHeight;Sets the height of the rows in the exported excel file. If left unspecified or 0, the default height of the excel rows will be used.
this.exportOptions.rowHeight = 25;
Objects of this class are used to configure the Excel exporting process.