File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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: 42959
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.
I agree. Here's the link:
subject: Appending different xls in a single xls
It's not a secret anymore!