jQuery in Action, 3rd edition
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: 42958
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: Appending different xls in a single xls
It's not a secret anymore!