@chidoan/excel-utils NPM

Excel Utils

Provide the simple way to read and write excel file by JSON at client side.

+ Importer: read content of excel file to JSON
+ Exporter: build excel file and auto download

You can add this dependence to your project by npm

$ npm i @chidoan/excel-utils

or yarn

$ yarn add @chidoan/excel-utils`

Function	Description
readXLSX(file, worksheets, options)	Read sheets from worksheets in source file, and result is map data with sheet name as key. - file: File - worksheets: String[] - options: Object. Support to read binary file with `{ rABS = true }` and base64 as default
readXLSXAllSheet(file, options)	Base on `readXLSX`, this function read all available sheets on source file
correctJsonPropertyName(sheet_data, properties)	The `readXLSX` function use column name as key for json object. This function use to correct key name and data type

Example at Github

Function	Description
Exporter(filename)	Receive STRING as target filename
setFilename(filename)	Set target filename
setConfigurations(options)	Optional for style. - REPLACE_UNKNOWN_TO_EMPTY: Boolean> Auto change NULL and UNDEFINED value to empty string - DECORATE_BORDER: Boolean - DECORATE_HEADER_COLOR: String
addSheet(headers, data, sheetName)	Exporter support to combine to multiple sheet. - headers: Object - data: Array - sheetName: String
exportExcel()	Export and auto download file