royalcyber
asked on
converting from properties to excel
I have a simple java properties file : common_en.properties
key1=joe
key2=newman
key3="<tr><td class="main" colspan="2"> My learnin </td></tr>
...
...
..
I want to write a small java program which will read this and save it as a csv or xls so when I open it
in excel I have key1 in ( col1) and value in ( col2)
can some have any sample code which already does this
Thankyou!!!!!!!!!!!!!!!!!! !!!!!!!!!! !!!!!!!!
key1=joe
key2=newman
key3="<tr><td class="main" colspan="2"> My learnin </td></tr>
...
...
..
I want to write a small java program which will read this and save it as a csv or xls so when I open it
in excel I have key1 in ( col1) and value in ( col2)
can some have any sample code which already does this
Thankyou!!!!!!!!!!!!!!!!!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
remember you need to download poi library from the above source and keep it in the classpath
You don't need to use any special library to create a csv file, which you can open in Excel. Of course, a csv file from a properties file can only have one row and is not ordered
http://jakarta.apache.org/poi/