This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
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 Java 8 in Action this week in the Java 8 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: 39576
    
  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
Problem in reading csv file
csv java example
How to download a csv file through java without using input and output streams
CSV to Java
xml file to csv file conversion using java