使用Apache Poi从固定位置的模板复制表

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

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

public class ApachePoiExample {
    public static void main(String[] args) {
        try {
            // 创建工作簿对象
            Workbook workbook = new HSSFWorkbook();

            // 加载模板文件
            FileInputStream templateFile = new FileInputStream("template.xls");
            Workbook templateWorkbook = new HSSFWorkbook(templateFile);

            // 获取模板中的表对象
            Sheet templateSheet = templateWorkbook.getSheet("TemplateSheet");

            // 创建新的表对象
            Sheet newSheet = workbook.createSheet("NewSheet");

            // 复制表
            for (Row templateRow : templateSheet) {
                Row newRow = newSheet.createRow(templateRow.getRowNum());
                for (Cell templateCell : templateRow) {
                    Cell newCell = newRow.createCell(templateCell.getColumnIndex());
                    newCell.setCellValue(templateCell.getStringCellValue());
                }
            }

            // 保存工作簿
            FileOutputStream outputFile = new FileOutputStream("output.xls");
            workbook.write(outputFile);

            // 关闭文件流
            templateFile.close();
            outputFile.close();

            System.out.println("表复制成功！");
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}