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 vote236 views1 answer
Why we can implement more than one interface in java
Java
3 votes233 views1 answer
How to make background image transparent in android studio
Java
6 votes232 views1 answer
How to clear stringbuilder in java
Java
0 vote249 views2 answers
How to use asynx task to make api connection java
Java
0 vote251 views1 answer
Jsp check if request parameter exists
Java
1 vote235 views1 answer
Get value google sheet with app script
Java
0 vote242 views1 answer
How to add an image to a gui in java windowbuilder
Java
0 vote226 views1 answer
Java summe array
Java
0 vote259 views1 answer
Java scanner int to string
Java
0 vote237 views1 answer
The import junit cannot be resolved maven
Java