deploy_xfld_excel.java

JAVA通过POI操作EXCEL 对复制一行、单元格格式的复制等一些操作进行封装

package app;

import java.io.FileInputStream;
import java.io.FileOutputStream;

import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import excel.WorkbookOper;

public class Deploy_xfld_Excel {
	
	static int cellStyleRowNum_grey = 0;				//灰色CELL所在行
	static int cellStyleColNum_grey = 6;				//灰色CELL所在列
	static int cellStyleRowNum_white =0;				//白色CELL所在行
	static int cellStyleColNum_white = 1;				//白色CELL所在列
	
	public static void main(String[] args) throws Exception {
		String strExcelFile = "excel/first.xls";
		// 创建对Excel工作簿文件的引用
		HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(strExcelFile));
		HSSFSheet sheet = workbook.getSheet("Sheet0");
		System.out.println(sheet.getLastRowNum());
		HSSFRow row = sheet.getRow(sheet.getLastRowNum());

		HSSFCellStyle style_white = WorkbookOper.getCellStyle(sheet,cellStyleRowNum_grey,cellStyleColNum_grey);
		WorkbookOper.copyRow(sheet, row, sheet.getLastRowNum()+1,style_white);	//COPY一行
		
		FileOutputStream fOut = new FileOutputStream(strExcelFile);
		// 把相应的Excel 工作簿存盘
		workbook.write(fOut);
		fOut.flush();
		// 操作结束，关闭文件
		fOut.close();
		System.out.println("COPY完成...");
	}
}