Import JSON Data to Excel on Linux

readme.md

Learn how to import data from JSON to Excel on Linux: https://blog.aspose.com/2021/09/25/import-data-from-json-to-excel-on-linux-java/

json-to-excel.java

// load JSON data
String 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
Workbook workbook = new Workbook();

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

// set JsonLayoutOptions for formatting
JsonLayoutOptions layoutOptions = new JsonLayoutOptions();
layoutOptions.setArrayAsTable(true);

// import JSON data to Excel
JsonUtility.importData(jsonInput, worksheet.getCells(), 0, 0, layoutOptions);

// save Excel file
workbook.save("output.xlsx", SaveFormat.XLSX);