Java 读取excel xls以及xlsx文件

最新推荐文章于 2024-07-25 08:16:40 发布

itsonglin

最新推荐文章于 2024-07-25 08:16:40 发布

阅读量5.2k

点赞数 1

分类专栏： Java

本文链接：https://blog.csdn.net/itsonglin/article/details/52459874

版权

Java 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

下载poi依赖包：http://poi.apache.org/download.html

poi对读取xls以及xlsx有不同的实现。

/**
     * 读取xls文件
     * @throws IOException
     */
    public static void readXls() throws IOException
    {
        FileInputStream in = new FileInputStream("/home/song/Desktop/book1.xls");
        HSSFWorkbook book = new HSSFWorkbook(in);

        HSSFSheet sheet = book.getSheetAt(0);
        HSSFRow row;
        String cell;

        for (int i = sheet.getFirstRowNum(); i < sheet.getPhysicalNumberOfRows(); i++)
        {
            row = sheet.getRow(i);
            for (int j = row.getFirstCellNum(); j < row.getPhysicalNumberOfCells(); j++)
            {
                cell = row.getCell(j).toString();
                System.out.print(cell + " \t");
            }
            System.out.println("");
        }
    }

    /**
     * 读取xlsx文件
     * @throws IOException
     */
    public static void readXlsx() throws IOException
    {
        XSSFWorkbook xwb = new XSSFWorkbook("/home/song/Desktop/book1.xlsx");
        XSSFSheet sheet = xwb.getSheetAt(0);
        XSSFRow row;
        String cell;
        for (int i = sheet.getFirstRowNum(); i < sheet.getPhysicalNumberOfRows(); i++)
        {
            row = sheet.getRow(i);
            for (int j = row.getFirstCellNum(); j < row.getPhysicalNumberOfCells(); j++)
            {
                cell = row.getCell(j).toString();
                System.out.print(cell + "\t");
            }
            System.out.println("");
        }
    }

public static void main(String[] args) throws IOException
    {
        //readXls();
        readXlsx();
    }