Wrapper over ExtJs's grid to make grid exportable to xlsx format. Supports ExtJs 5 and ExtJs 6. Example can be found on sencha's fiddle. Supports composite headers, summary feature and grouping feature.
This component uses two opensource libraries(FileSaver and jszip), so they should be imported to the project.
- xlsTitle - name of exported file + will be shown in excel as a table header if xlsShowHeader is set to true.
- xlsHeaderColor - backgound color of the headers. RGB without leading #.
- xlsGroupHeaderColor - backgound color of the grouping headers. RGB without leading #.
- xlsSummaryColor - backgound color of the summary section. RGB without leading #.
- xlsShowHeader - just a marker, whether a first row title should be generated.
- exportable -
true/false- defines whether this column should be exported. - exportConverter - function that shoud be applyed to value on export. Returns modified value. If exportConverter is specified, then renderer will be skiped and exportConverter function will be used on export.
- skipRenderer -
true/false- set to true to skip using renderer on export for this column. - exportNumberFormat -
<#,##.00>- valid excel's number format. - summaryConverter - function.If specified it will be used as renderer for summary feature in exported xls.
- groupingSummaryConverter - function.If specified it will be used as renderer for goupingsummary feature in exported xls.
Import jszip and FileSaver libraries into the project. F.e. in index.html
<head>
...
<script type="text/javascript" src="jszip.js"></script>
<script type="text/javascript" src="FileSaver.js"></script>
...
</head>Place ExportableGrid.js into your UX directory, if there is no such then create one. F.e. in the same level with app.js create extjs/ux folder. Tell to the ExtJs where the UX directory is: in app.js add the following snippet:
Ext.Loader.setConfig({
enabled: true,
paths: {
'Ext.ux': 'extjs/ux' //Should be the path to the ux folder.
}
});
Ext.application({
...Use Ext.require('Ext.ux.ExportableGrid') or just add to the requires list of the component, which will use the grid.
As proposed @nbgo to identify exportable type, the type of column could be used. It will be helpful in cases, when appropriate column type is used for data displayment.
The following code snippets should be modified:
Replace
getExportableColumnType: function (type) {
return this.columnTypes[type] ? this.columnTypes[type] : this.defaultType;
}with
getExportableColumnType: function (gridColumn) {
if (Ext.grid.column.Number && gridColumn instanceof Ext.grid.column.Number) {
return this.columnTypes['float'];
}
if (Ext.grid.column.Date && gridColumn instanceof Ext.grid.column.Date) {
return this.columnTypes['date'];
}
if (Ext.grid.column.Boolean && gridColumn instanceof Ext.grid.column.Boolean) {
return this.columnTypes['boolean'];
}
if (Ext.grid.column.Check && gridColumn instanceof Ext.grid.column.Check) {
return this.columnTypes['boolean'];
}
return this.defaultType;
}Replace marked with asterisk line
if (!rec.isSummary && !rec.isGroupingHeader) {
if (param.xtype === 'templatecolumn') {
type = 'template';
} else if (param.exportConverter) {
type = 'converter';
} else if (!param.skipRenderer && param.renderer) {
type = 'renderer';
} else {
* type = this.getExportableColumnType(exportTask.exportableColumns[j]);
}
} else {
type = 's';
}with
type = rec.getField(param.dataIndex) ? this.getExportableColumnType(rec.getField(param.dataIndex).type) : this.defaultType;