I have two HSSFWorkbook objects, each having one HSSFSheet.
I want to create a third HSSFWorkbook containing two sheets (one from each
of the workbooks).
I could not find a way to do this from the API - am I missing something.
A code snippet to explain the same:
HSSFWorkbook hrWorkBook = getDepartmentDetails("HR");
HSSFWorkbook financeWorkBook = getDepartmentDetails("Finance");
HSSFWorkbook finalWorkBook = ???; // I want to somehow create this
finalWorkBook with the one sheet from the hr and finance workbook
Thanks
Cheenu