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

Refresh

February 2019

Views

5 time

0

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 messages_en.properties 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: messages_en.properties messages_da.properties messages_bg.properties

0 answers