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 vote318 views1 answer
Junit.jupiter create test
Java
0 vote333 views1 answer
How to convert arraylist to iterable in java
Java
2 votes304 views1 answer
Listview refresh android adapter
Java
1 vote342 views1 answer
How to give square in java
Java
0 vote317 views1 answer
Convert python to java translator online
Java
0 vote323 views1 answer
Which of the following is an example of a Method reference?
Java
2 votes335 views1 answer
Read int from keyboard java
Java
0 vote320 views1 answer
Javafx choicebox get index
Java
5 votes337 views3 answers
Random float in java
Java
2 votes329 views1 answer
Naming a package java
Java