POI读取Excel

要下载相应的jar包,在百度搜索poi 进入Apache里面下载.

package POIStudy;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

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

public class poiexceltest {
    public static void main(String[] args) {
        try {
            //读取数据流
            InputStream inputStream = new FileInputStream("F:\\studyTestFiles\\files.xls");
            //解析工作簿
            HSSFWorkbook workbook = new HSSFWorkbook(inputStream);   //到这一步就相当于拿到了工作表
            //解析工作表   读取一共有多少个工作表
            int size = workbook.getNumberOfSheets();
            System.out.println("一共有" + size + "个工作表");
            for (int i = 0; i < size; i++) {
                HSSFSheet sheet = workbook.getSheetAt(i);
                System.out.println("读取当前工作表名称"+sheet.getSheetName());
                //读到有效行数
                int rownum = sheet.getPhysicalNumberOfRows();
                System.out.println("有效行数:"+rownum);
                for(int rowindex =0;rowindex<rownum;rowindex++){
                    if(rowindex==0){
                        continue;  //这是标题
                    }

                    HSSFRow row = sheet.getRow(rowindex);
                    for (int cellindex=0;cellindex<2;cellindex++){
                        HSSFCell cell = row.getCell(cellindex);
                        System.out.println("列值:"+cell.getStringCellValue());
                    }


                }
            }


        } catch (Exception e) {
            e.printStackTrace();
        }


    }
}