poi拷贝sheet

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;

import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.util.CellRangeAddress;


/**
 * poi拷贝sheet(只能在当前文件中实现)
 * @author ambo.lch
 *
 */
public class CopyExcel {



	public static void main(String[] args) throws FileNotFoundException,
			IOException {


		final String INVOICE_FILE = "D:\\file1\\test.xls";

		POIFSFileSystem filein = new POIFSFileSystem(new FileInputStream(INVOICE_FILE));
		HSSFWorkbook wb = new HSSFWorkbook(filein);
		HSSFSheet sheet1 = wb.getSheet("model");
		HSSFSheet sheet2 = wb.createSheet("8月");
		sheet2 = copySheet(sheet1, sheet2);
		FileOutputStream fileOut = new FileOutputStream("D:\\file1\\test.xls");
		wb.write(fileOut);
		fileOut.close();

	}

	private static HSSFSheet copySheet(HSSFSheet sheetFrom, HSSFSheet sheetTo) {
		CellRangeAddress region = null;
		Row rowFrom = null;
		Row rowTo = null;
		Cell cellFrom = null;
		Cell cellTo = null;
		for (int i = 0; i < sheetFrom.getNumMergedRegions(); i++) {
			region = sheetFrom.getMergedRegion(i);
			if ((region.getFirstColumn() >= sheetFrom.getFirstRowNum())
			&& (region.getLastRow() <= sheetFrom.getLastRowNum())) {
				sheetTo.addMergedRegion(region);
			}
		}
		for (int intRow = sheetFrom.getFirstRowNum(); intRow < sheetFrom.getLastRowNum(); intRow++) {
			rowFrom = sheetFrom.getRow(intRow);
			rowTo = sheetTo.createRow(intRow);
			if (null == rowFrom)
				continue;
			rowTo.setHeight(rowFrom.getHeight());
			for (int intCol = 0; intCol < rowFrom.getLastCellNum(); intCol++) {
				sheetTo.setDefaultColumnStyle(intCol,sheetFrom.getColumnStyle(intCol));
				sheetTo.setColumnWidth(intCol, sheetFrom.getColumnWidth(intCol));
				cellFrom = rowFrom.getCell(intCol);
				cellTo = rowTo.createCell(intCol);
				if (null == cellFrom)
					continue;
				cellTo.setCellStyle(cellFrom.getCellStyle());
				cellTo.setCellType(cellFrom.getCellType());
				if (null != cellFrom.getStringCellValue()&& !"".equals(cellFrom.getStringCellValue().trim()))
					cellTo.setCellValue(cellFrom.getStringCellValue());
			}
		}
		sheetTo.setDisplayGridlines(true);//是否显示网格线
		sheetTo.setZoom(50, 100);//设置表格缩放比例
		return sheetTo;

	}

}

比之前一片文章的代码简单许多