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 vote200 views2 answers
Icon hide
Java
-5 votes196 views8 answers
Retrofit
Java
10 votes198 views5 answers
Sort 2d array by column java
Java
0 vote234 views1 answer
Playwright Java
Java
0 vote182 views1 answer
Write a java program to print a number from the user
Java
14 votes276 views1 answer
How to print string from specific index java
Java
0 vote241 views3 answers
Spring boot sql logging
Java Spring
0 vote184 views1 answer
What is assignment in java with example
Java
0 vote194 views2 answers
Loop and save letters in a string java
Java
0 vote192 views4 answers
Findbyname in jpa
Java