This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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: 41149
    
  45
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?