java解析出来excel数据后,如何才能将数据封装成List<Object[]> datas?

EXCEL表结构:图片说明
求大神给个解决方案

解析sheet页,for嵌套,遍历每一行,再遍历每一个单元格

百度poi就行,找个demo

这样:

        List<Object[]> list = new ArrayList<Object[]>();
        HSSFWorkbook workbook = new HSSFWorkbook(io);
        int sheets = workbook.getNumberOfSheets();

        for(int i =0;i<sheets;i++){
            HSSFSheet sheet = workbook.getSheetAt(i);

            for(int j=1;j<sheet.getPhysicalNumberOfRows();j++){
                HSSFRow row = sheet.getRow(j);
                Object[] arr = new Object[row.getPhysicalNumberOfCells()];

                for (int k = 0; k < row.getPhysicalNumberOfCells(); k++) {
                    arr[k] = getformatCellValue(row.getCell(k));
                }
                list.add(arr);
            }
        }

        return list;

cell可以识别文档中的数据类型,比如日期,字符串,或者数字,根据需要进行转换 如果要封装成Object[]那就(Object)强转就可以了。
HSSFWorkbook wb = new HSSFWorkbook(new POIFSFileSystem(new BufferedInputStream(source)));
Sheet sheet = wb.getSheetAt(1);
Row row = sheet.getRow(1);
Cell cell = row.getCell(1);

(1)Date date = cell.getDateCellValue();
(2)String string = cell.getStringCellValue();
(3)double double1 = cell.getNumericCellValue();