wood burning stoves 2.0*
The moose likes Other Open Source Projects and the fly likes Appending different xls in a single xls Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Appending different xls in a single xls" Watch "Appending different xls in a single xls" New topic

Appending different xls in a single xls

Naseem Khan
Ranch Hand

Joined: Apr 25, 2005
Posts: 809

Could anyone please tell me how to append the different excel sheets content in a single xls file.

I have different excel sheets and I want to write the records of all excel sheets in a single master.xls

I have tried writing it by apache POI, but it�s not appending the files in a single file rather it is updating the same master.xls with different input source xls file

Many Thanks,
[ September 12, 2008: Message edited by: Naseem Khan ]

Asking Smart Questions FAQ - How To Put Your Code In Code Tags
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 41060
I don't think that there's a way to copy a sheet from one file to another. You may have to create a new sheet and copy the rows, cells and cell styles one by one.

Ping & DNS - my free Android networking tools app
Consider Paul's rocket mass heater.
subject: Appending different xls in a single xls
Similar Threads
want to get more then 256 columns in XL using JXL API
How to convert .xls to .xlsx and vice versa using Apache POI api
How add ajax Functionalities to my JSP page
Downloading a multiple file from server
Record Export?