XSSFWorkbook（HSSFWorkbook）的方式读取

最新推荐文章于 2024-09-02 18:22:14 发布

发疯的man

最新推荐文章于 2024-09-02 18:22:14 发布

阅读量1.7k

点赞数

CC 4.0 BY-SA版权

分类专栏： java 工具

本文链接：https://blog.youkuaiyun.com/lzh657083979/article/details/104813540

java 工具专栏收录该内容

12 篇文章

订阅专栏

本文介绍了一种使用Apache POI库读取和解析Excel文件（.xls和.xlsx）的方法，通过Java代码示例展示了如何迭代Excel工作表、行和单元格，并获取单元格的字符串值。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

https://my.oschina.net/viakiba/blog/750787

package com.kakaluote.excel;

import lombok.extern.slf4j.Slf4j;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Cell;
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 org.springframework.util.StringUtils;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.Iterator;

@Slf4j
public class PoiTest07 {

    public static void main(String[] args) throws Exception {
        String path = "E:\\微信下载文件\\WeChat Files\\T-mac_01_\\FileStorage\\File\\2019-05\\账户交易明细表1.xls";
        File file = new File(path);
        System.out.println(file.getName());
        FileInputStream inputStream = new FileInputStream(file);
        Workbook wb = getWorkbook(inputStream,file.getName());
        Iterator<Sheet> sheetIterator = wb.sheetIterator();
        while(sheetIterator.hasNext()){
            Sheet sheet = sheetIterator.next();
            int numberOfRows = sheet.getPhysicalNumberOfRows();
            for (int i = 0; i < numberOfRows; i++) {
                Row row = sheet.getRow(i);
                int physicalNumberOfCells = row.getPhysicalNumberOfCells();
                for (int j = 0; j < physicalNumberOfCells; j++) {
                    Cell cell = row.getCell(j);
                    System.out.print(cell.getStringCellValue() + " ");
                }
                System.out.println("");
            }
        }
    }

    /**
     * 得到Workbook
     */
    public static Workbook getWorkbook(InputStream inputStream,String fileName){
        Workbook workbook  = null;
        try {
            if (StringUtils.endsWithIgnoreCase(fileName,".xls")){
                POIFSFileSystem pfs = new POIFSFileSystem(inputStream); // 解析2003版本
                workbook = new HSSFWorkbook(pfs,true);
            }else if (StringUtils.endsWithIgnoreCase(fileName,".xlsx")){
                workbook  = new XSSFWorkbook(inputStream); // 解析2007版本
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
        return workbook;
    }
}