Txt to Json in java

// load XLSX file with an instance of Workbook
Workbook workbook = new Workbook("template.xlsx");
// access CellsCollection of the worksheet containing data to be converted
Cells cells = workbook.getWorksheets().get(0).getCells();
// create & set ExportRangeToJsonOptions for advanced options
ExportRangeToJsonOptions exportOptions = new ExportRangeToJsonOptions();
// create a range of cells containing data to be exported
Range range = cells.createRange(0, 0, cells.getLastCell().getRow() + 1, cells.getLastCell().getColumn() + 1);
// export range as JSON data
String jsonData = JsonUtility.exportRangeToJson(range, exportOptions);
// write data to disc in JSON format
BufferedWriter writer = new BufferedWriter(new FileWriter("output.json"));
writer.write(jsonData);
writer.close();

Source: products.aspose.com

Similar codes

1 vote172 views1 answer
Java run main of another class
Java
0 vote176 views1 answer
Racine carré java
Java
1 vote180 views1 answer
View binding in recyclerview adapter android java
Java
1 vote192 views1 answer
Javafx textarea new line with shift+enter
Java
0 vote184 views1 answer
Distance point to line java
Java
0 vote177 views1 answer
You may test the newly compiled and packaged JAR in maven
Java
0 vote190 views1 answer
Before first in jdbc
Java
0 vote190 views1 answer
XmlRootElement Object to String
Java
3 votes196 views4 answers
Math java
Java
1 vote204 views1 answer
Android application class manifest
Java