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

1 vote151 views1 answer
Has integer java
Java
4 votes189 views2 answers
Java go troght loop object
Java
0 vote153 views1 answer
Grepper editor
Java
0 vote149 views1 answer
Processing pi
Java
9 votes355 views2 answers
Change spring port
Java Spring
13 votes106 views1 answer
All string functions in java
Java
1 vote157 views1 answer
Error when making java variable
Java
0 vote165 views1 answer
Javafx polygon
Java
0 vote154 views1 answer
How to add new nod in dynamic treeview using javascipt
Java
0 vote182 views1 answer
Autowired in spring boot error creating bean with name
Java Spring