node-spreadsheet

Convert Array of JSON to a table of plain text separated by \t and \n. This plain text format can be copy-pasted to MS Excel and Google SpreadSheet.

sheetToJson(textInput, columns) return array of JSON

• Convert spreadsheet to JSON array.
• Any empty lines or lines starting with '//' are ignored.
• If the first character is \uFEFF, it is removed.
• Columns are json specifying the data types and data names. example: ['columnName:int'] types can be (int|json|float|string)

jsonToSheet(jsonArray, columnOrder, comment1, comment2, ....) return textOutput

• Convert JSON array to spreadsheet.
• Type conversion is dynamic based on what is inside the JSON array.
• Arrays are converted into string separated with comma.