Mak Cash

Hello All -
I am not sure if this was still a problem ....

But this is what I am doing now ... to copy a sheet. ...
1> clone old sheet to new
2> rename new sheet to new name ..

   private XSSFSheet copyWorksheet(XSSFWorkbook wb, String oldSheetName, String newSheetName, boolean safeCreateFlag) throws Exception { XSSFSheet oldSheet = wb.getSheet(oldSheetName); if (oldSheet == null) { throw new Exception("Sheet with name " + oldSheetName + " doesnt exist"); } XSSFSheet newSheet = wb.getSheet(newSheetName); int newSheetIndex = -1; if (newSheet != null) { if (safeCreateFlag) { newSheetIndex = wb.getSheetIndex(newSheetName); wb.removeSheetAt(newSheetIndex); } else { throw new Exception("Sheet with name " + newSheetName + " already exists"); } } int oldSheetNo = wb.getSheetIndex(oldSheet); newSheet = wb.cloneSheet(oldSheetNo); int newSheetNo = wb.getSheetIndex(newSheet); wb.setSheetName(newSheetNo, newSheetName); if (newSheetIndex >= 0) { wb.setSheetOrder(newSheetName, newSheetIndex); } return newSheet;    }