poi进行xlsx 复制一行_poi Excel复制指定行案例

一、poi excel复制指定行

package com.smart.test;

import java.io.FileInputStream;

import java.io.FileOutputStream;

import org.apache.poi.hssf.usermodel.HSSFCell;

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.hssf.util.Region;

import org.apache.poi.poifs.filesystem.POIFSFileSystem;

public class ExcelCopy {

public static void main(String[] args) throws Exception {

copyTemplate("Template.xls",

"workbook.xls");

}

public static void copyTemplate(String exTemplateFilePath,

String targetFilePath) throws Exception {

POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(

exTemplateFilePath));

HSSFWorkbook wb = new HSSFWorkbook(f