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

2 votes242 views3 answers
Fill a 2d array java
Java
5 votes217 views2 answers
Java create inputstream from string
Java
0 vote239 views1 answer
How to insert a 0 in an array java
Java
5 votes235 views2 answers
How to print to console in java
Java
0 vote243 views2 answers
Java 8 iterating and manipulating list
Java
1 vote213 views3 answers
How to solve Caused by: java.lang.IllegalStateException: You need to use a Theme.AppCompat theme (or descendant) with this activity.
Java
1 vote228 views1 answer
Factorial java
Java
0 vote231 views2 answers
Find min max and average arraylist
Java
-2 votes243 views6 answers
Spring enable cors
Java
0 vote246 views1 answer
Convertir string a char java
Java