How to combine two excel workbooks using poi?

Question

I have to HSSFWorkbook objects, each of them contains one or more HSSFSheet. How can I get one workbook with sheets from both of these objects? POI 3.6

Answer 1

There are two code examples on the below thread - one of them is fully working as per comments, but I havent tried this one myself yet. Note, it's an old link, so the API might not match Poi 3.6

http://www.coderanch.com/t/420958/open-source/Copying-sheet-excel-file-another

Create a new Workbook and copy over sheets from both existing workbooks using the above