java poi 读取excel内容

最新推荐文章于 2024-01-10 10:47:46 发布

weixin_30325487

最新推荐文章于 2024-01-10 10:47:46 发布

阅读量58

点赞数

CC 4.0 BY-SA版权

文章标签： java

原文链接：http://www.cnblogs.com/rumengqiang/p/11056975.html

此博客为转载内容，转载自https://www.cnblogs.com/rumengqiang/p/11056975.html ，涉及Java相关知识。

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;


public class MainTest {

    public static void main(String[] args) {
        String filePath="D:/home/读取测试.xls";
        try {
            readExcel(filePath);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    /**
     * 读取excel内容
     * @param filePath 文件路径
     * @throws Exception
     */
    public static void readExcel(String filePath) throws Exception{
        InputStream is = new FileInputStream(new File(filePath));
        Workbook hssfWorkbook = null;
        if (filePath.endsWith("xlsx")){
            //Excel 2007
            hssfWorkbook = new XSSFWorkbook(is);
        }else if (filePath.endsWith("xls")){
            //Excel 2003
            hssfWorkbook = new HSSFWorkbook(is);

        }
        // 循环工作表Sheet
        for (int numSheet = 0; numSheet <hssfWorkbook.getNumberOfSheets(); numSheet++) {
            Sheet hssfSheet = hssfWorkbook.getSheetAt(numSheet);
            if (hssfSheet == null) {
                continue;
            }
            // 循环行Row
            for (int rowNum = 1; rowNum <= hssfSheet.getLastRowNum(); rowNum++) {
                Row hssfRow = hssfSheet.getRow(rowNum);
                if (hssfRow != null) {
                    //第一列内容
                    System.out.println(hssfRow.getCell(0));
                    //第一列内容
                    System.out.println(hssfRow.getCell(1));

                }
            }
        }


    }

}

转载于:https://www.cnblogs.com/rumengqiang/p/11056975.html