aspose file tools*
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 Soft Skills this week in the Jobs Discussion 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
Author

Appending different xls in a single xls

Naseem Khan
Ranch Hand

Joined: Apr 25, 2005
Posts: 809
Hi,

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,
Regards,
Naseem
[ September 12, 2008: Message edited by: Naseem Khan ]

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

Joined: Mar 22, 2005
Posts: 42913
    
  68
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: http://aspose.com/file-tools
 
subject: Appending different xls in a single xls