【Java Poi Excel使用】

---

个人使用记录如有错误欢迎指出

一、Excel操作

根据模板创建一个Excel

	Workbook workbook;
    String classFilePath = "模板路径";
    InputStream in;
    try {
   
          in = this.getClass().getClassLoader().getResourceAsStream(classFilePath);
          workbook = WorkbookFactory.create(in);
      } catch (Exception e) {
   
            log.error("读取模板错误:", e);
      }

/**
 * @param inputStream 读取文件的输入流
 * @return 包含文件数据的工作簿对象
 */
public static Workbook getWorkbook(InputStream inputStream) throws IOException {
   
    return WorkbookFactory.create(inputStream);
}

//根据文件后缀名类型获取对应的工作簿对象
public static Workbook getWorkbook(String fileType) throws IOException {
   
        Workbook workbook;
        if (fileType.equalsIgnoreCase("xls")) {
   
            workbook = new HSSFWorkbook();
        } else if (fileType.equalsIgnoreCase("xlsx")) {
   
            workbook = new XSSFWorkbook();
        }else if (fileType.equalsIgnoreCase("et")) {
   
            workbook = new XSSFWorkbook();
        }else{
   
            throw new ServiceException(500, "未识别的Excel格式");
        }
        return workbook;
    }

1.获取/创建Sheet页

获取sheet页/创建Sheet页

//根据sheet页名称 获取sheet页
Sheet sheet = workbook.getSheet("sheet页名称");

//根据sheet页的位置获取sheet页  num从1开始
Sheet sheetAt = workbook.getSheetAt(num);

//创建sheet页  sheetName（sheet页名称）
Sheet sheet = workbook.createSheet(sheetName);

//删除sheet页
workbook.removeSheetAt(1);

//sheet页迭代