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

0 vote132 views1 answer
What is return method in java
Java
0 vote131 views1 answer
Pass a list of string as PathVariable to api spring boot
Java
-1 vote132 views1 answer
Java Calender examokes
Java
7 votes115 views3 answers
Java printf double 2 decimal places
Java
0 vote186 views1 answer
Java string.format system.currenttimemillis
Java
0 vote130 views1 answer
Java to python
Java
26 votes124 views6 answers
String builder vs string buffer
Java
0 vote115 views1 answer
Android remove focus from an element
Java
0 vote160 views3 answers
FlutterFirebaseCorePlugin.java uses or overrides a deprecated API.
Java
7 votes133 views3 answers
Java measure execution time
Java