This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Writing into Excel file. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Writing into Excel file." Watch "Writing into Excel file." New topic

Writing into Excel file.

zuber syed

Joined: Jun 15, 2005
Posts: 1

My requirement is to add column into already existing excel sheet and and writing in to that column.

Is there anyway to do this?

Your comments are greatly appreciated.

Ulf Dittmer

Joined: Mar 22, 2005
Posts: 41177
Welcome to JavaRanch.

There are a couple of libraries that read and write XLS files, POI and jExcelApi. The AccessingFileFormats wiki page has links to them.

Ping & DNS - my free Android networking tools app
Kamesh Loganathan

Joined: Jan 21, 2006
Posts: 20
That is correct, there are a couple of free api's to interact will excel or com in general. POI, IBM java-com bridge etc. Jintegra can be used to interact with any com component, although it has to be bought. If you are looking at just adding a column into the spread sheet the best way to do it is write a comma seperated format file and rename the file to .xls. This is simple and fast to do.
I agree. Here's the link:
subject: Writing into Excel file.
Similar Threads
how to read excel using JSP
JSP data to CSV format conversion
cewolf charts
Reading and Writing chinese characters
data from data base to excel in servlet