File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Other Open Source Projects
Appending different xls in a single xls
Joined: Apr 25, 2005
Sep 12, 2008 05:03:00
Could anyone please tell me how to append the different
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
[ September 12, 2008: Message edited by: Naseem Khan ]
Asking Smart Questions FAQ
How To Put Your Code In Code Tags
Joined: Mar 22, 2005
Sep 12, 2008 05:30:00
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
Downloading a multiple file from server
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
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015