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

33 votes188 views2 answers
Allow internet permission android
Java
0 vote227 views1 answer
Current time in long java
Java
0 vote196 views1 answer
Jax-RS PUT annotation
Java
2 votes179 views1 answer
Convert hashset to array
Java
6 votes180 views2 answers
Java string not equal
Java
-1 vote186 views2 answers
Adminlte 3 laravel
Java
0 vote192 views1 answer
Welche Stoffeigenschaften kann man mit den Sinnesorganen wahrnehmen?
Java
23 votes226 views4 answers
Convert a string to int in java
Java
0 vote183 views1 answer
Multiple string java
Java
0 vote178 views1 answer
Java resultset length
Java