json2xls
json2xls copied to clipboard
canonically transform json to an excel document
Just use the npm package xlsx, and: ``` import xlsx from "xlsx"; export function saveJsonToSheet(data, path) { console.log("building xlsx for data", data); const workbook = xlsx.utils.book_new(); const worksheet = xlsx.utils.json_to_sheet(data);...
If anybody needs an updated version of this package, or want to update `json2xls` (seems abandoned, but maybe not), I've forked and updated it in [`json-xls-converter`](https://github.com/neverbot/json-xls-converter/) ([github](https://github.com/neverbot/json-xls-converter/), [npm](https://www.npmjs.com/package/json-xls-converter)), with the...
This project seems not maintained and use a deprecated lib (8 years old) Actually, this project works but if you want anything quite custom (formula, etc) or a typescript version...
Hi , I am having a valid json text containing data like “Sr. No.”:1. I am using json2xls for converting it to excel. The excel generated from that json is...
When the key name has a '.' this seems to fool json2xls, e.g. {"lang.contextButtonTitle":"nice", "lang.decimalPoint":"true"} I wouldn't normally use '.' in a key, but these were added automatically by a...
Fixed @sergiyvoytovych 's PR to add headers
Please add a typings file for typescript support. Otherwise this library is excellent! Thanks a lot! :D
It will lose some fields when the first row of JSON doesn't contain all of the fields.
Hi, When parsing an array of object with: `var xls = json2xls(json) ` I stumbled onto this error : ``` if (n in object) { ^ TypeError: Cannot use 'in'...
Hi, For some custom layout, I generated all the data with trivial column names like col1, col2, cole3, etc. Now I want to hide column names on the top row....