Convert JSON to Excel XSL/XLSX in Node.js

readme.md

Learn how to export data from JSON to Excel in Node.js: https://blog.aspose.com/2021/09/01/convert-json-to-excel-in-nodejs/

json-to-excel-styles.js

// load JSON data
var jsonInput = '[{"nodeId":1,"reputation":1134},{"nodeId":2,"reputation":547},{"nodeId":3,"reputation":1703},{"nodeId":4,"reputation":-199},{"nodeId":5,"reputation":-306},{"nodeId":6,"reputation":-49},{"nodeId":7,"reputation":1527},{"nodeId":8,"reputation":1223}]'

// create a blank Workbook object
var workbook = aspose.cells.Workbook()

// access default empty worksheet
var worksheet = workbook.getWorksheets().get(0)

// set Styles
var factory = aspose.cells.CellsFactory()
style = factory.createStyle()
style.getFont().setBold(true) 
style.getFont().setColor(aspose.cells.Color.getBlueViolet())

// set JsonLayoutOptions for formatting
var layoutOptions = aspose.cells.JsonLayoutOptions()
layoutOptions.setArrayAsTable(true)
layoutOptions.setTitleStyle(style)

// import JSON data to default worksheet starting at cell A1
aspose.cells.JsonUtility.importData(jsonInput, worksheet.getCells(), 0, 0, layoutOptions)

// save resultant file 
workbook.save("output.xlsx", aspose.cells.SaveFormat.AUTO)

json-to-excel.js

// load JSON data
var jsonInput = '[{"nodeId":1,"reputation":1134},{"nodeId":2,"reputation":547},{"nodeId":3,"reputation":1703},{"nodeId":4,"reputation":-199},{"nodeId":5,"reputation":-306},{"nodeId":6,"reputation":-49},{"nodeId":7,"reputation":1527},{"nodeId":8,"reputation":1223}]'

// create a blank Workbook object
var workbook = aspose.cells.Workbook()

// access default empty worksheet
var worksheet = workbook.getWorksheets().get(0)

// set JsonLayoutOptions for formatting
var layoutOptions = aspose.cells.JsonLayoutOptions()
layoutOptions.setArrayAsTable(true)

// import JSON data to default worksheet starting at cell A1
aspose.cells.JsonUtility.importData(jsonInput, worksheet.getCells(), 0, 0, layoutOptions)

// save resultant file
workbook.save("output.xls", aspose.cells.SaveFormat.AUTO)