POI对Excel操作——java读取Excel数据

来源：互联网发布：js随机动态显示编辑：程序博客网时间：2024/05/17 04:25

在上篇博文POI对Excel操作——java保存数据到Excel我们介绍了java poi创建数据保存到Excel文件，本篇博文我将介绍如何读取Excel中的数据。下面看java代码：

import org.apache.poi.hssf.usermodel.HSSFRow;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.poifs.filesystem.POIFSFileSystem;import org.apache.poi.ss.usermodel.Cell;import java.io.File;import java.io.FileInputStream;import java.io.IOException;public class ReadExcel {    public static void main(String[] srgs){        String filePath = "F:\\d.xls";        HSSFWorkbook wb = null;        POIFSFileSystem fs = null;        try {            fs = new POIFSFileSystem(new FileInputStream(new File(filePath)));            wb = new HSSFWorkbook(fs);        } catch (IOException e) {        }        HSSFSheet sheet = wb.getSheetAt(0);        System.out.println("excel共有数据：" + sheet.getLastRowNum());        for(int rowNum = 1; rowNum <= sheet.getLastRowNum(); rowNum++){            HSSFRow row = sheet.getRow(rowNum);            System.out.print("第" + rowNum + "行数据：");            for (int cellNum = row.getFirstCellNum() ; cellNum < row.getLastCellNum(); cellNum++) {                Cell cell = row.getCell(cellNum);                System.out.print(cell.getStringCellValue() + "   ");            }            System.out.println();        }    }}

0 0