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 vote152 views1 answer
@Bean public ModelMapper modelMapper() { ModelMapper modelMapper = new ModelMapper(); modelMapper.getConfiguration() .setMatchingStrategy(MatchingStrategies.STRICT); }
Java
0 vote151 views1 answer
Difference between compile and execute in java
Java
0 vote151 views1 answer
What is static setter and getter examples in java
Java
0 vote164 views1 answer
Jbutton set on action
Java
0 vote192 views2 answers
Open gallery android
Java
0 vote137 views1 answer
Java konsolenausgabe
Java
2 votes145 views4 answers
Jdbc
Java
0 vote135 views3 answers
Get selected item spinner
Java
4 votes261 views1 answer
Spring load config value in variable
Java Spring
29 votes165 views5 answers
String reverse in java
Java