This plugin adds the capability to export from Highcharts to the Excel .xlsx format. This is an updated version of the original export-xlsx plugin. I removed the moment.js and jQuery requirements and switched to using the ExcelJS library for exporting. ExcelJS provides many more options for custom export formatting than SheetJS.
- Latest Highcharts (tested with 8.0.0), but should work with version 7.0.0+.
- Latest Highcharts exporting and export-data modules.
- ExcelJS version 3.5.0+.
- FileSaver.js version 2.0.2+.
- SSF.js version 0.10.2+. (only needed if using auto column width feature)
Notes:
- Plugin does NO verification of ExcelJS options specifications. I recommend google, stackoverflow or the official ExcelJS docs for ExcelJS questions.
- Plugin does not check for correctly specified Excel number/date formats. A description of Excel's number format codes by Microsoft can be found here . There are plenty of other resources available on Excel number formats via a google search or stackoverflow.
- Add
<script>tag pointing toexport-xlsx.jsbelow the required sources listed above.
The latest code is available on github: https://github.com/chris-vecchio/export-xlsx
The plugin adds the following new options to the native Highcharts exporting options under the xlsx key.
Enable/disable auto column width calculation. Default: false
Auto column width calculation requires loading SSF.js before export-xlsx. See the demo for an example of how to load SSF.js.
Excel worksheet name (Excel restricts sheet name length to <= 31 characters) Default: Sheet1
Category column title in Excel. Default: Highcharts default
Category column Excel number format. Default: undefined for non-datetime x-axis, yyyy-mm-dd hh:mm:ss for datetime x-axis.
Column header row font and fill options. See example options for supported attributes Default: {}
Excel workbook file properties. List of available properties. Default: {}
The plugin adds the following new options to individual series options under the xlsx key.
Column title for series in exported Excel file Default: series name
Series column Excel number format. Default: undefined
exporting: {
filename: 'export_xlsx_example',
xlsx: {
worksheet: {
autoFitColumns: true,
sheetName: 'CustomSheetName',
categoryColumn: {
title: 'Date',
numberFormat: 'yyyy-mm'
},
headerStyle: {
font: {
color: '#FFFFFF',
bold: true
},
fill: {
color: '#414b56'
}
}
},
workbook: {
fileProperties: {
creator: "File Author",
company: "File Company",
created: new Date(2017, 11, 31)
}
}
}
},
series: [{
name: 'Less than High School',
xlsx: {
numberFormat: '0.0',
name: 'Less than HS'
},
data: [6.9, 7.3, 6.9, 7.1, 6.6, 6.7, 7.3, 6.5, 7.6, 7.3, 7.7, 7.7, 7.7, 7.4, 8.4, 7.7, 8.1, 8.7, 8.6, 9.7, 9.8, 10.3, 10.8, 11.1, 12.4, 13.2, 14.0, 14.9, 15.2, 15.6, 15.3, 15.6, 14.9, 15.2, 14.7, 15.0, 15.3, 15.8, 14.9, 14.7, 14.6, 14.2, 13.5, 14.1, 15.6, 15.0, 15.4, 15.0, 14.3, 14.0, 14.1, 14.7, 14.5, 14.4, 14.5, 14.1, 14.3, 13.5, 12.8, 13.7, 13.0, 13.1, 12.8, 12.5, 12.9, 12.6, 12.4, 11.8, 11.7, 12.1, 12.0, 11.8, 12.0, 11.3, 11.1, 11.6, 11.0, 10.7, 10.8, 11.1, 10.5, 10.9, 10.7, 9.8, 9.4, 9.8, 9.4, 8.7, 9.2, 9.2, 9.5, 9.2, 8.5, 8.1, 8.6, 8.6, 8.3, 8.2, 8.6, 8.5, 8.7, 8.2, 8.3, 7.9, 7.9, 7.6, 6.8, 6.5, 7.1, 7.0, 7.4, 7.6, 7.5, 7.6, 6.4, 7.4, 8.5, 7.5, 7.8, 7.6, 7.4, 7.6, 6.6, 6.4, 6.3, 6.5, 7.0, 6.1, 6.7, 6.0, 5.2, 6.3, 5.5, 5.6, 5.6, 5.8, 5.5, 5.6, 5.0, 5.7, 5.6, 5.9, 5.6, 5.8, 5.7]
}]Export XLSX now uses ExcelJS instead of SheetJS
- Moment.js and jQuery dependencies
- Now compatible with a custom columnHeaderFormatter function
- Correctly sets column headers for HighCharts combination chart
- Hours, minutes, and seconds date parts are now correctly exported and formatted. Previously, only month, year, and day were exported for a dateTime xAxis.
- Minimum supported Highcharts version updated bumped to 7.0.0 from 6.1.0
- Rows are no longer filtered to visible data for Pie charts Issue #2
- Date/time values are recognized as Excel dates and formatted correctly in the exported file
- Updated docs and added several examples to index.html