All the excels have the data in the first column using semi colon as delimiter as seen above.
I can format the excel using the Data -> Text to Column -> Delimited(Selecting Semicolon as the delimiter) and then saving the formatted excel. This procedure puts the semicolon seperated values in different columns as needed.
However,I have a few thousands excel sheets to be formatted.This is not very convenient thing to be performed manually.
I was wondering if this can be done using Java code.
Please can some one help with this issue?
Thanks & Regards
Joined: Mar 22, 2005
That's what libraries such as Apache POI and jExcelAPi do. And even better - they work with Excel files directly, so there's no need for conversion to CSV in between.