File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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
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: 42946
    
  70
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.
 
wood burning stoves
 
subject: excel - how to put the semi colon seperated values in seperate columns