excel - how to put the semi colon seperated values in seperate columns

Hi All,

I am facing an issue where I need to alter existing excel sheets(a few thousands of them). The format of each excel sheet is similar to the one seen below in bold:

r_object_id;"r_object_type";"r_folder_path";"object_name";"r_full_content_size";"alternate_trial_id"

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

Moieen

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.