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 vote133 views1 answer
Java dateigröße abfragen
Java
0 vote158 views1 answer
How to sprint minecraft java
Java
1 vote126 views1 answer
Jpa validation string only number
Java
0 vote121 views2 answers
Downcasting in java
Java
0 vote147 views1 answer
Spring data sql not utf8
Java Spring
-2 votes213 views1 answer
Java return exception
Java
0 vote328 views1 answer
Java.lang.NoSuchMethodError: org.apache.logging.log4j.spi.LoggerContextFactory.isClassLoaderDependent()Z after log4j update
Java
0 vote140 views1 answer
How to change the tomcat port in spring boot
Java Spring
2 votes76 views1 answer
How to get list from json object in java
Java
9 votes120 views2 answers
Static and final in java
Java