POI操作模板EXCEL带分页功能

?package https://www.360docs.net/doc/db18489478.html,mon;

import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.sql.Timestamp;
import java.util.Date;

import https://www.360docs.net/doc/db18489478.html,ermodel.HSSFCell;
import https://www.360docs.net/doc/db18489478.html,ermodel.HSSFCellStyle;
import https://www.360docs.net/doc/db18489478.html,ermodel.HSSFFont;
import https://www.360docs.net/doc/db18489478.html,ermodel.HSSFRow;
import https://www.360docs.net/doc/db18489478.html,ermodel.HSSFSheet;
import https://www.360docs.net/doc/db18489478.html,ermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.CellRangeAddress;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.hssf.util.Region;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.formula.functions.Rows;
import https://www.360docs.net/doc/db18489478.html,ermodel.Cell;
import https://www.360docs.net/doc/db18489478.html,ermodel.CellStyle;
import https://www.360docs.net/doc/db18489478.html,ermodel.IndexedColors;
import https://www.360docs.net/doc/db18489478.html,ermodel.Row;

/*
* 使用说明（固定格式模板的excel操作；excel版本2003）：
*
* 1：实例化对像
* 2：设置头部值 ExeHeadWith（）
* 3：加一行 1：带自动拷贝头部插入分页符：copyRows（） 2：不带插入分页符不拷贝头部copyRow（）
* 4：行的值设置 ExeRowWith（）
* 5：当前行设置介绍 EndPrint（）
* 6：输出文件 Close（）
*
*
*
*/
public class ExcelOperation {

public FileInputStream in = null;
public HSSFWorkbook workbook = null; //文件流
public HSSFSheet sheet = null; //excel工作
public HSSFRow row = null; //excel行总和
public HSSFCell cell = null; //excel列
public HSSFCellStyle cellstyle = null; //列的样式
public HSSFFont font = null; //字体样式
public CellRangeAddress region = null;
private String FileUrl; //模板文件路劲
private String OutUrl; //输出文件路劲
private int HeadNum; //头部固定行
private int CellRow; //列数
private int PSize; //
private int CurRow; //明细行的数
public boolean PaNext=false;
public int PNum= 1; //
public HSSFSheet sheetName = null;

public int getCurRow() {
return CurRow;
}
public void setCurRow(int curRow) {
CurRow = curRow;
}

public int getPSize() {
return PSize;
}
public void setPSize(int pSize) {
PSize = pSize;
}
public ExcelOperation(String strInputUrl,String strOutUrl) throws IOException{
FileUrl = strInputUrl;
OutUrl = strOutUrl;
LogFile();
}
/**
*
* @param strInputUrl 模板文件路径
* @param strOutUrl 输出文件路径
* @param relHeadNm 头部行数
* @param rePSize
* @param reCellRow 列数
*/
public ExcelOperation(String strInputUrl,String strOutUrl,int relHeadNm,int rePSize,int reCellRow) throws IOException{
FileUrl = strInputUrl;
OutUrl = strOutUrl;
HeadNum = relHeadNm;
CurRow = HeadNum;
PSize=rePSize;
CellR