• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Writing into Excel file.

 
zuber syed
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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.

Thanks.
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Kamesh Loganathan
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic