🥥Office（Hutool-poi）
ExcelUtil

ExcelUtil

Introduction

Encapsulation of Excel operation tools.

Usage

  1. Read Excel from a file as an ExcelReader
ExcelReader reader = ExcelUtil.getReader(FileUtil.file("test.xlsx"));
  1. Read Excel from a stream as an ExcelReader (for example, reading an Excel file from the ClassPath)
ExcelReader reader = ExcelUtil.getReader(ResourceUtil.getStream("aaa.xlsx"));
  1. Read a specified sheet
ExcelReader reader;

// Get by sheet index
reader = ExcelUtil.getReader(FileUtil.file("test.xlsx"), 0);
// Get by sheet name
reader = ExcelUtil.getReader(FileUtil.file("test.xlsx"), "sheet1");
  1. Read large data volume Excel
private RowHandler createRowHandler() {
 return new RowHandler() {
 @Override
 public void handle(int sheetIndex, int rowIndex, List<Object> rowlist) {
 Console.log("[{}] [{}] {}", sheetIndex, rowIndex, rowlist);
 }
 };
}

ExcelUtil.readBySax("aaa.xlsx", 0, createRowHandler());

Next Steps

The ExcelUtil.getReader method only converts the physical Excel file into an ExcelReader object for operation. Please refer to the ExcelReader section for specific operations on the Excel workbook.

overviewExcelReader