java poi 读取excel内容

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));

                }
            }
        }


    }

}

  

posted @ 2019-06-20 10:00  不列颠剑圣  阅读(762)  评论(0编辑  收藏  举报