Java读取excel文件

读取excel某一行数据

package com.字节流;

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

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;

public class 读取excel中某一行数据 {
    public static void main(String[] args) {

        try {
            FileInputStream fileInputStream = new FileInputStream(new File("E:\\excel\\t1.xls"));
            HSSFWorkbook workbook = new HSSFWorkbook(fileInputStream);
            //获取表的sheet页数
            int numberOfSheets = workbook.getNumberOfSheets();
            for (int i = 0; i < numberOfSheets; i++) {
                HSSFSheet sheetAt = workbook.getSheetAt(i);

                //取sheet页名称
                String sheetName = sheetAt.getSheetName();
                if (sheetName.equals("名单")){
                    //获取sheet中表最大行
                    int lastRowNum = sheetAt.getLastRowNum();
                    System.out.println("最大行："+lastRowNum);//行是从0开始
                    System.out.println("最大列："+sheetAt.getRow(0).getPhysicalNumberOfCells());//物理列就是实实在在的列数
                    for (int j = 0; j <= lastRowNum; j++) {
                        for (int k = 0; k < 5; k++) {
                            String stringCellValue = sheetAt.getRow(i).getCell(k).getStringCellValue();
                            System.out.printf("%s\t",stringCellValue);
                        }
                        System.out.println();
                    }

                }

            workbook.close();
            }
            //HSSFSheet sheetAt = workbook.getSheetAt(3);
            //String sheetName = sheetAt.getSheetName();
            System.out.println("共有sheet页数："+numberOfSheets);

        } catch (FileNotFoundException e) {
            e.printStackTrace();
            System.out.println("读取文件失败");
        } catch (IOException e) {
            e.printStackTrace();
            System.out.println("读取excel出错");
        }

    }
}

读取excel各个sheet数据

package com.字节流;

import java.util.Map;

public class 读取xlsx各个sheet数据 {
    public static void main(String[] args) {
        GetXlsxSheetDate getXlsxSheetDate = new GetXlsxSheetDate();
        Map<String, String> 登录 = getXlsxSheetDate.getXlsxSheet("E:\\excel\\date.xlsx", "登录");
        System.out.println("登录数据");
        for (Map.Entry<String,String> m:登录.entrySet()){
            System.out.println(m.getKey()+":"+m.getValue());
        }
        Map<String, String> 查询 = getXlsxSheetDate.getXlsxSheet("E:\\excel\\date.xlsx", "查询");
        System.out.println("查询数据");
        for (Map.Entry<String,String> m:查询.entrySet()){
            System.out.println(m.getKey()+":"+m.getValue());
        }
        Map<String, String> 删除 = getXlsxSheetDate.getXlsxSheet("E:\\excel\\date.xlsx", "删除");
        System.out.println("删除数据");
        for (Map.Entry<String,String> m:删除.entrySet()){
            System.out.println(m.getKey()+":"+m.getValue());
        }
    }

}