Specifies whether the headers should be exported if there is no data.
let alwaysExportHeaders = this.exportOptions.alwaysExportHeaders;
this.exportOptions.alwaysExportHeaders = false;
IgxExporterOptionsBase
Specifies whether the exported data should be formatted as Excel table. (True by default)
let exportAsTable = this.exportOptions.exportAsTable;
this.exportOptions.exportAsTable = false;
IgxExcelExporterOptions
Specifies whether the exported data should include column summaries.
let exportSummaries = this.exportOptions.exportSummaries;
this.exportOptions.exportSummaries = true;
IgxExporterOptionsBase
Specifies whether the exported data should have frozen headers.
let freezeHeaders = this.exportOptions.freezeHeaders;
this.exportOptions.freezeHeaders = true;
IgxExporterOptionsBase
Specifies if the exporter should ignore the current column order in the IgxGrid.
let ignoreColumnsOrder = this.exportOptions.ignoreColumnsOrder;
this.exportOptions.ignoreColumnsOrder = true;
IgxExporterOptionsBase
Specifies whether hidden columns should be exported.
let ignoreColumnsVisibility = this.exportOptions.ignoreColumnsVisibility;
this.exportOptions.ignoreColumnsVisibility = true;
IgxExporterOptionsBase
Specifies whether filtered out rows should be exported.
let ignoreFiltering = this.exportOptions.ignoreFiltering;
this.exportOptions.ignoreFiltering = true;
IgxExporterOptionsBase
Specifies whether the exported data should be grouped as in the provided IgxGrid.
let ignoreGrouping = this.exportOptions.ignoreGrouping;
this.exportOptions.ignoreGrouping = true;
IgxExporterOptionsBase
Specifies whether the exported data should include multi column headers as in the provided IgxGrid.
let ignoreMultiColumnHeaders = this.exportOptions.ignoreMultiColumnHeaders;
this.exportOptions.ignoreMultiColumnHeaders = true;
IgxExporterOptionsBase
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;
IgxExcelExporterOptions
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;
IgxExporterOptionsBase
Gets the width of the columns in the exported excel file.
let width = this.exportOptions.columnWidth;
IgxExcelExporterOptions
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;
IgxExcelExporterOptions
Gets the file name which will be used for the exporting operation.
let fileName = this.exportOptions.fileName;
IgxExporterOptionsBase
Sets the file name which will be used for the exporting operation.
this.exportOptions.fileName = 'exportedData01';
IgxExporterOptionsBase
Gets the height of the rows in the exported excel file.
let height = this.exportOptions.rowHeight;
IgxExcelExporterOptions
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;
IgxExcelExporterOptions
Gets the name of the worksheet in the exported excel file.
let worksheetName = this.exportOptions.worksheetName;
IgxExcelExporterOptions
Sets the name of the worksheet in the exported excel file.
this.exportOptions.worksheetName = "Worksheet";
IgxExcelExporterOptions
Objects of this class are used to configure the Excel exporting process.