Gets the file name which will be used for the exporting operation.
let fileName = this.exportOptions.fileName;
Specifies whether the headers should be exported if there is no data.
let alwaysExportHeaders = this.exportOptions.alwaysExportHeaders;
this.exportOptions.alwaysExportHeaders = false;
Specifies whether the exported data should be formatted as Excel table. (True by default)
let exportAsTable = this.exportOptions.exportAsTable;
this.exportOptions.exportAsTable = false;
Specifies whether the exported data should include column summaries.
let exportSummaries = this.exportOptions.exportSummaries;
this.exportOptions.exportSummaries = true;
Specifies whether the exported data should have frozen headers.
let freezeHeaders = this.exportOptions.freezeHeaders;
this.exportOptions.freezeHeaders = true;
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 whether the exported data should be grouped as in the provided IgxGrid.
let ignoreGrouping = this.exportOptions.ignoreGrouping;
this.exportOptions.ignoreGrouping = true;
Specifies whether the exported data should include multi column headers as in the provided IgxGrid.
let ignoreMultiColumnHeaders = this.exportOptions.ignoreMultiColumnHeaders;
this.exportOptions.ignoreMultiColumnHeaders = 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. When you export grouped data, setting ignoreSorting to true will cause the grouping to fail because it relies on the sorting of the records.
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, the width of the column or the default width of the excel columns 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;
Gets the name of the worksheet in the exported excel file.
let worksheetName = this.exportOptions.worksheetName;
Sets the name of the worksheet in the exported excel file.
this.exportOptions.worksheetName = "Worksheet";
Objects of this class are used to configure the Excel exporting process.