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

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

public class ExcelParser {
    public static List<Object[]> parseExcel(String filename) throws IOException {
        List<Object[]> parsedData = new ArrayList<>();
        
        // 创建文件输入流
        FileInputStream fis = new FileInputStream(new File(filename));
        Workbook workbook = WorkbookFactory.create(fis);

        // 获取第一个工作表
        Sheet sheet = workbook.getSheetAt(0);

        // 迭代行
        Iterator<Row> rowIterator = sheet.iterator();
        while (rowIterator.hasNext()) {
            Row row = rowIterator.next();
            
            // 检查每行的第一个单元格是否包含有效数据
            Cell firstCell = row.getCell(0);
            if (firstCell != null && firstCell.getCellType() != CellType.BLANK) {
                List<Object> rowData = new ArrayList<>();
                
                // 迭代列
                Iterator<Cell> cellIterator = row.cellIterator();
                while (cellIterator.hasNext()) {
                    Cell cell = cellIterator.next();
                    
                    // 将单元格值添加到行数据中
                    switch (cell.getCellType()) {
                        case STRING:
                            rowData.add(cell.getStringCellValue());
                            break;
                        case NUMERIC:
                            rowData.add(cell.getNumericCellValue());
                            break;
                        // 根据需要添加更多单元格类型的处理逻辑
                        default:
                            rowData.add(""); // 或者添加其他默认值
                            break;
                    }
                }
                
                parsedData.add(rowData.toArray());
            }
        }
        
        workbook.close();
        fis.close();

        return parsedData;
    }

    public static void main(String[] args) {
        try {
            String filename = "your_excel_file.xlsx";
            List<Object[]> parsedData = parseExcel(filename);
            for (Object[] row : parsedData) {
                for (Object cellValue : row) {
                    System.out.print(cellValue + "\t");
                }
                System.out.println();
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}