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 vote309 views1 answer
Configuration spring boot dependency for freemarker configuration
Java Spring
1 vote277 views1 answer
Setting up javafx in eclipse vm argument
Java
0 vote273 views1 answer
Get all colors in string spigot
Java
0 vote209 views1 answer
Super vs super()
Java
0 vote269 views1 answer
POST method) in spring rest api
Java
1 vote268 views1 answer
How to get color from resource android
Java
1 vote249 views1 answer
Java jtextfield text bold
Java
0 vote327 views1 answer
Spigot hide player
Java
2 votes253 views1 answer
Bucket sort java
Java
13 votes258 views3 answers
How to convert double to int in java
Java