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 vote303 views2 answers
Android Execution failed for task ':app:processReleaseManifest' Could not get unknown property 'manifestOutputDirectory' for task
Java
7 votes315 views2 answers
Print list array
Java
33 votes312 views2 answers
Allow internet permission android
Java
0 vote299 views2 answers
Android volley benefits
Java
0 vote311 views1 answer
Setting a hint on a text field in javafx
Java
0 vote335 views1 answer
How to check my java heap space size
Java
0 vote319 views1 answer
How to take array as an argument in java
Java
1 vote290 views1 answer
Take string until /
Java
56 votes306 views6 answers
String remove last character
Java
2 votes305 views1 answer
Textfield set value flutter
Java