How to read 2 columns from excel file (xlsx) and write it to resource properties as key=value pair


February 2019


5 time


I am trying to generate messages_[en/da/bg].properties file from the given set for excel (xlsx) files. Each excel sheet is provided with two columns as key-value pair. I have to read each file and write it to generate file for i18n.

If I have excel sheets with filenames like locales_ENG.xlsx, locales_DAN.xlsx & locales_BGR.xlsx then it should generate files as:

0 answers