Combine Worksheets into One Workbook

[Colagrosso Matthew]

Dear all,

New to POI, I'm wondering if anyone has had any success combining worksheets
from different workbooks into one workbook?  Do I have to iterate over each
row and copy the contents/style or is there a simpler way?

For example, I've tried:

HSSFWorkbook oldWb = new HSSFWorkbook(oldfs);
HSSFWorkbook newWb = new HSSFWorkbook(newfs);

HSSFSheet newSheet = newWb.getSheetAt(1);

oldWb.getSheetAt(1) = newSheet;

But that's no good...

Thanks for your help in advance.

-Matthew