poi拷贝sheet 包括每个单元格的style

注意本例需要jxls的支持

Java代码

1. /**
2.       * copy all rows include styles from source sheet to target sheet
3.       * @param srcSheet
4.       * @param targetSheet
5.       */  
6.     public static void copySheet(HSSFSheet srcSheet, HSSFSheet targetSheet){   
7.          Iterator it = srcSheet.rowIterator();   
8.         while(it.hasNext()){   
9.              HSSFRow srcRow = (HSSFRow) it.next();   
10.              Util.copyRow(srcSheet, targetSheet, srcRow, targetSheet.createRow(srcRow.getRowNum()));   
11.          }   
12.      }