如何使用Apache POI读取所有单元格值? [英] how to read all cell value using Apache POI?

问题描述

我想使用Apache POI从excel表中读取所有单元格值并将其存储到一维字符串数组中.是否可以逐行从excel中读取数据并从每个单元格中提取值?

I want to read all cell value from excel sheet using Apache POI and store it into one dimensional string array .Is is possible to read data from excel row by row and extract value from each cell?

请帮我解决这个问题.

谢谢

推荐答案

import java.io.FileInputStream;
import java.util.Iterator;
import java.util.Vector;

导入org.apache.poi.hssf.usermodel.HSSFCell；导入 org.apache.poi.hssf.usermodel.HSSFRow;导入 org.apache.poi.hssf.usermodel.HSSFSheet;导入 org.apache.poi.hssf.usermodel.HSSFWorkbook；导入 org.apache.poi.poifs.filesystem.POIFSFileSystem;

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 org.apache.poi.poifs.filesystem.POIFSFileSystem;

公共类 ReadExcelFile {

public class ReadExcelFile {

}

这篇关于如何使用Apache POI读取所有单元格值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！