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

25 votes282 views6 answers
Reverse java
Java
0 vote308 views1 answer
Viewresolver in spring boot
Java
0 vote287 views1 answer
Split string 2 characters java
Java
1 vote334 views1 answer
Java take out cn from dn
Java
7 votes295 views3 answers
How to sort a list in java
Java
1 vote288 views1 answer
Arraylist add new element to end
Java
0 vote281 views1 answer
Algorithms - Max value
Java
0 vote300 views4 answers
Convert java to c++
Java
13 votes283 views2 answers
What is junit
Java
0 vote279 views2 answers
Contain Java
Java