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 vote140 views1 answer
Java regex replace all characters before
Java
9 votes134 views2 answers
How to change double to int in java
Java
0 vote163 views1 answer
Error creating bean with name 'org.springframework.cloud.netflix.eureka.server.EurekaServerInitializerConfiguration'
Java Spring
28 votes149 views6 answers
How to get current date in java
Java
6 votes162 views9 answers
E
Java
0 vote185 views1 answer
ClassCastException Casting toArray() method
Java
0 vote267 views1 answer
Intelilj javadoc: error - Malformed locale name: UTF8
Java
0 vote154 views1 answer
There is no client authentication. Try adding an appropriate authentication filter
Java
0 vote152 views1 answer
Register command spigot
Java
0 vote146 views1 answer
Seekbar thumb position
Java