File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Beginning Java and the fly likes CSV File Manipulation Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » Beginning Java
Bookmark "CSV File Manipulation" Watch "CSV File Manipulation" New topic
Author

CSV File Manipulation

Azeem Mohammed
Greenhorn

Joined: Jan 15, 2009
Posts: 12
Hi,

Can someone tell me how CSV files are manipulated in Java? And is there a way that new columns can be created in a CSV file with excel formulas using Java ?

Thanks,
Azeem
prem pillai
Ranch Hand

Joined: Nov 02, 2007
Posts: 87

I think we are well aware that CSV file is a plain text file with comma separated values in it. So its just simple plain text; formatting facilities, formulas etc are not available. Spreadsheets like excel allows to view a CSV file in a tabular format. So what ever jazzy facilities you see in excel are not owned by CSV.

Now you know that CSV is a plain text , you know how to handle a plain text file with a comma delimited tokens (CSV file processing can be more complex depending on the type of data you have For example handling embedded commas , quotes etc makes it complex if your data demands for it).

Now if you dont want to create a CSV , but a spredsheet with jazzy features , then go for tools like Apache POI.
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 39547
    
  27
The http://www.coderanch.com/how-to/java/AccessingFileFormats page points to a number of libraries that can be used to manipulate CSV files, but I think they're mostly about reading and writing, not manipulating.


Ping & DNS - updated with new look and Ping home screen widget
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: CSV File Manipulation
 
Similar Threads
CSV to Java
How to download a csv file through java without using input and output streams
csv java example
Problem in reading csv file
xml file to csv file conversion using java