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

3 votes369 views2 answers
Counting repeated characters in a string in java
Java
0 vote335 views1 answer
Android java shared preferences remove key
Java
0 vote393 views1 answer
Expiry time of otp android
Java
0 vote328 views1 answer
Android studio get id name from view
Java
6 votes360 views2 answers
Android studio set text of textview
Java
0 vote352 views1 answer
Subtract two variables in java
Java
0 vote345 views1 answer
Glide dependency android java
Java
3 votes342 views4 answers
Java empty array
Java
1 vote344 views1 answer
Java par o impar
Java
2 votes340 views1 answer
How to turn off darkmode for my app in android studio
Java