Excel to JSON
The project takes a Excel file as input, it converts some of the columns into a json array and then stores it to a column of another file in the .csv format. It is a springboot project.
ExcelReader.java is a main file.
Following dependencies are added in pom.xml
1.org.apache.poi
2.com.googlecode.json-simple
3.com.opencsv (optional)
4.commons-io (optional)
Following is a sample output json:
[{"question":"Categories","answer":"POINT OFINTEREST"},{"question":"Sub Categories","answer":"Hospital/Polyclinic"},{"question":"Features","answer":"General"},{"question":"NAME","answer":"XYZ"},{"question":"LOCATION NAME","answer":"NA"},{"question":"TYPE","answer":"Hospital/Polyclinic"},{"question":"ADDITIONAL INFORMATION","answer":"NA,520007"},{"question":"SURVEY NO","answer":""}]