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 vote164 views1 answer
GatewayFilters
Java
0 vote181 views1 answer
How to compare current date and time with another date and time in android
Java
1 vote111 views1 answer
Java botton code
Java
0 vote162 views1 answer
Java convert to roman numerals
Java
2 votes160 views1 answer
Android coding how to open map
Java
0 vote194 views2 answers
@embeddedid
Java
1 vote168 views1 answer
How to open an activity from a fragment
Java
15 votes158 views2 answers
How to crate an array of integers in java
Java
0 vote175 views1 answer
Open website from android activity
Java
0 vote155 views1 answer
What's the output of the following code?
Java