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

6 votes265 views2 answers
Tostring java
Java
0 vote322 views7 answers
Convert python to java online
Java
0 vote350 views1 answer
Search in row and column sorted matrix leetcode
Java
0 vote274 views1 answer
Java variable declared
Java
1 vote378 views1 answer
What is java plug-in
Java
-2 votes341 views2 answers
How to get filename without extension in java
Java
6 votes327 views3 answers
Onclicklistener in android studio
Java
1 vote315 views1 answer
How to compare lists of custom classes without defining equals() and hashCode()?
Java
0 vote325 views1 answer
Bigint is built in object
Java
0 vote344 views1 answer
Java read integer from text file into array scanner
Java