This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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
Rancher

Joined: Mar 22, 2005
Posts: 42958
    
  73
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.
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: excel - how to put the semi colon seperated values in seperate columns
 
It's not a secret anymore!