Thanks for the screenshot.
Well, you got to devise an approach using Range.copy() method for your requirements. I have written the following sample code to accomplish the task for your needs. You may refer to it and test with the attached files (in the zipped archive) for your reference, the output file is also attached. The sample code appends two worksheets data from the source workbook to a sheet in the destination workbook:
Workbook workbook = new Workbook("f:\\files\\Bk_sourceappend1.xlsx");
Workbook destWorkbook = new Workbook("f:\\files\\Book1_new1.xlsx");
Worksheet destSheet = destWorkbook.getWorksheets().get(0);
//Get the last row in the destination worksheet.
int endRow = destSheet.getCells().getMaxDataRow()+1;
int totalRowCount = 0;
for (int i = 0; i < workbook.getWorksheets().getCount(); i++)
Worksheet sourceSheet = workbook.getWorksheets().get(i);
Range sourceRange = sourceSheet.getCells().getMaxDisplayRange();
Range destRange = destSheet.getCells().createRange(sourceRange.getFirstRow() + endRow + totalRowCount, sourceRange.getFirstColumn(), sourceRange.getRowCount(), sourceRange.getColumnCount());
totalRowCount = sourceRange.getRowCount() + totalRowCount;
Hope, this helps a bit.
files1.zip (24.1 KB)