使用 Apache POI读取EXCEL文件

最新推荐文章于 2024-05-31 14:44:22 发布

翻译最新推荐文章于 2024-05-31 14:44:22 发布 · 856 阅读

文章标签：

#poi

APACHE POI 专栏收录该内容

1 篇文章

订阅专栏

本文介绍了如何使用Java的Apache POI库来读取和写入Excel文件(.xls)。通过示例代码展示了如何逐行读取单元格数据，并根据不同类型进行处理，最后将修改保存回原文件。

添加MAVEN依赖

<dependency>
    <groupid>org.apache.poi</groupid>
    <artifactid>poi</artifactid>
    <version>3.12</version>
</dependency>

读取EXCEL文件

比如：

test.xls

try {
             
            FileInputStream file = new FileInputStream(new File("C:\\test.xls"));
             
            //Get the workbook instance for XLS file 
            HSSFWorkbook workbook = new HSSFWorkbook(file);
 
            //Get first sheet from the workbook
            HSSFSheet sheet = workbook.getSheetAt(0);
             
            //Iterate through each rows from first sheet
            Iterator<row> rowIterator = sheet.iterator();
            while(rowIterator.hasNext()) {
                Row row = rowIterator.next();
                 
                //For each row, iterate through each columns
                Iterator<cell> cellIterator = row.cellIterator();
                while(cellIterator.hasNext()) {
                     
                    Cell cell = cellIterator.next();
                     
                    switch(cell.getCellType()) {
                        case Cell.CELL_TYPE_BOOLEAN:
                            System.out.print(cell.getBooleanCellValue() + "\t\t");
                            break;
                        case Cell.CELL_TYPE_NUMERIC:
                            System.out.print(cell.getNumericCellValue() + "\t\t");
                            break;
                        case Cell.CELL_TYPE_STRING:
                            System.out.print(cell.getStringCellValue() + "\t\t");
                            break;
                    }
                }
                System.out.println("");
            }
            file.close();
            FileOutputStream out = 
                new FileOutputStream(new File("C:\\test.xls"));
            workbook.write(out);
            out.close();
             
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
</cell></row>

输出：

Emp Id      Name        Salary     
0     John        2000000.0      
0     Dean        420000.0       
0     Sam     280000.0       
0     Cass        6000000.0  