<!-- Spring Boot Web -->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-web</artifactId>
</dependency>

<!-- Apache POI for Excel -->
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>5.2.3</version> <!-- 使用最新版本 -->
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>5.2.3</version>
</dependency>

# 文件上傳大小限制
spring.servlet.multipart.max-file-size=10MB
spring.servlet.multipart.max-request-size=10MB

public class User {
    private String name;
    private Integer age;
    private String email;
    
    // Getters and Setters
}

import org.apache.poi.ss.usermodel.*;
import org.springframework.web.multipart.MultipartFile;
import java.util.ArrayList;
import java.util.List;

public class ExcelUtil {
    
    public static List<User> parseExcelFile(MultipartFile file) throws Exception {
        List<User> users = new ArrayList<>();
        
        Workbook workbook = WorkbookFactory.create(file.getInputStream());
        Sheet sheet = workbook.getSheetAt(0); // 獲取第一個工作表
        
        for (Row row : sheet) {
            if (row.getRowNum() == 0) continue; // 跳過表頭
            
            User user = new User();
            user.setName(getStringValue(row.getCell(0)));
            user.setAge(getIntValue(row.getCell(1)));
            user.setEmail(getStringValue(row.getCell(2)));
            
            users.add(user);
        }
        workbook.close();
        return users;
    }
    
    private static String getStringValue(Cell cell) {
        return cell == null ? "" : cell.getStringCellValue();
    }
    
    private static Integer getIntValue(Cell cell) {
        return cell == null ? null : (int) cell.getNumericCellValue();
    }
}

import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

@RestController
@RequestMapping("/api/excel")
public class ExcelUploadController {

    @PostMapping("/upload")
    public ResponseEntity<String> uploadExcel(@RequestParam("file") MultipartFile file) {
        if (file.isEmpty()) {
            return ResponseEntity.badRequest().body("文件為空");
        }
        
        try {
            List<User> users = ExcelUtil.parseExcelFile(file);
            // 這里處理業(yè)務邏輯（如保存到數(shù)據(jù)庫）
            // userService.saveUsers(users);
            return ResponseEntity.ok("成功導入 " + users.size() + " 條數(shù)據(jù)");
        } catch (Exception e) {
            return ResponseEntity.internalServerError().body("導入失敗: " + e.getMessage());
        }
    }
}

<form action="/api/excel/upload" method="post" enctype="multipart/form-data">
    <input type="file" name="file" accept=".xlsx, .xls">
    <button type="submit">上傳Excel</button>
</form>

@Async
public void processExcelAsync(MultipartFile file) {
    // 耗時操作
}

// 使用JPA批量保存
@Transactional
public void saveUsers(List<User> users) {
    userRepository.saveAll(users);
}

if (!file.getOriginalFilename().endsWith(".xlsx")) {
    throw new IllegalArgumentException("僅支持.xlsx格式");
}

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>easyexcel</artifactId>
    <version>3.3.2</version>
</dependency>