I have one excel file with single sheet (abstract model). Now I want to copy the sheet to another existing workbook. How can I do this?
Asked
Active
Viewed 6.3k times
18
-
A little bit of googling helps: http://www.coderanch.com/t/420958/open-source/Copying-sheet-excel-file-another .. – limc Jul 26 '10 at 14:19
-
The solution proposed in the thread is to use a utility class from jxls (http://jxls.sourceforge.net/, LPGL), and vote for this feature to be included in POI (where it is on the TODO list, http://poi.apache.org/todo.html ) – Thilo Nov 28 '10 at 07:59
-
According to http://stackoverflow.com/questions/848212/copying-excel-worksheets-in-poi the jxls Util class does not work for copying between files. – Thilo Nov 28 '10 at 08:08
-
It fails when Columns are grouped. It has to be fixed in the code given in the link.http://www.coderanch.com/t/420958/open-source/Copying-sheet-excel-file-excel – Manikandan Arunachalam Jan 30 '16 at 19:40