MultipartFile excel文件获取表头 java

获取Excel文件的表头可以使用Apache POI库来操作。具体步骤如下：

1. 引入Apache POI和Apache POI-OOXML库：

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>4.1.2</version>
</dependency>

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>4.1.2</version>
</dependency>

2. 获取Excel文件的输入流：

InputStream inputStream = multipartFile.getInputStream();

3. 创建Workbook对象：

Workbook workbook = WorkbookFactory.create(inputStream);

4. 获取第一个Sheet页：

Sheet sheet = workbook.getSheetAt(0);

5. 获取第一行（即表头）：

Row headerRow = sheet.getRow(0);

6. 遍历表头中的每个单元格，获取单元格的值：

List<String> headers = new ArrayList<>();
for (int i = 0; i < headerRow.getLastCellNum(); i++) {
    Cell cell = headerRow.getCell(i);
    String header = cell.getStringCellValue();
    headers.add(header);
}

完整代码如下：

try {
    InputStream inputStream = multipartFile.getInputStream();
    Workbook workbook = WorkbookFactory.create(inputStream);
    Sheet sheet = workbook.getSheetAt(0);
    Row headerRow = sheet.getRow(0);
    List<String> headers = new ArrayList<>();
    for (int i = 0; i < headerRow.getLastCellNum(); i++) {
        Cell cell = headerRow.getCell(i);
        String header = cell.getStringCellValue();
        headers.add(header);
    }
    return headers;
} catch (IOException e) {
    e.printStackTrace();
    return null;
}