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 vote213 views1 answer
Cancel javafx stage exit request
Java
0 vote221 views1 answer
How to convert line into string java
Java
0 vote208 views1 answer
Android popBackStack to specific fragment
Java
5 votes169 views1 answer
Is a relationship concept java
Java
2 votes187 views1 answer
System.arraycopy
Java
7 votes202 views3 answers
How to copy array in java
Java
2 votes226 views1 answer
Android studio remove notification bar
Java
0 vote197 views1 answer
Java application
Java
0 vote207 views1 answer
Could not get JDBC Connection; nested exception is java.sql.SQLException: Access denied for user 'hac_manager'@'localhost' (using password: YES)
Java
1 vote164 views1 answer
Reverse integer java
Java