xlsexport

JS library for export array of objects to Excel XLS or CSV

Usage no npm install needed!

<script type="module">
  import xlsexport from 'https://cdn.skypack.dev/xlsexport';
</script>

README

xlsexport

Javascript library for exporting object arrays to Excel XLS and CSV.

Installation

Clone or dowload the Github repo or via bower:

bower install xlsexport

or

npm install xlsexport

Usage

xlsExport is defined as a class, so has to be instantiated with data (objects array) and an optional title.

var xls = new XlsExport([..., Object], String);

Since Chromium(v61) supports ES6 Modules XlsExport is available with 'import' syntax 😎. For older browser I also include an ES5 version inside the package.

Methods:

  • exportToXLS(String fileName): convert data and force download of a Excel XLS file.
  • exportToCSV(String fileName): convert data separate by semi-colons and force download of a CSV file.

fileName parameter is optional, if it's not defined, the file will be named "export.xls".

Example

import XlsExport from './xls-export.js';

var xls = new XlsExport([..., Object], String);
xls.exportToXLS('export2017.xls');
xls.exportToCSV('export2017.xls');

Demo: https://jsfiddle.net/3xvb2g5w/

License: MIT