File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Soft Skills: The software developer's life manual this week in the Jobs Discussion forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Moieen Khatri
Ranch Hand
Posts: 144
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 42966
73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic