aspose file tools*
The moose likes Other Open Source Projects and the fly likes excel - how to put the semi colon seperated values in seperate columns Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "excel - how to put the semi colon seperated values in seperate columns" Watch "excel - how to put the semi colon seperated values in seperate columns" New topic
Author

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

Moieen Khatri
Ranch Hand

Joined: Nov 27, 2007
Posts: 144
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
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41574
    
  54
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.


Ping & DNS - my free Android networking tools app
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: excel - how to put the semi colon seperated values in seperate columns