<Tech>Brunch


Read-Write to Excel - Java Maven Project

Having read-write operation on Excel sheets is quite a frequent requirement. And it is true across different technologies.
I have implemented this functionality in Java, using a maven project.
I have used Apache POI as the dependency which actually does the work of read-write to excel files.

In the project, there is a .json file. This file has all the information which needs to be written to the excel sheet. So data is collected as JsonArray, and then with Apache POI data is written to excel.

For reading the data in excel sheet, I have read the data as plain string, and tested it out by printing them in the console.

Have a look on the code changes at my git repo below:
https://github.com/anshulgammy/exceloperations