java poi解析excel_Java用POI解析excel并获取所有单元格数据的实例

导读热词

1.导入POI相关jar包

org.apache.poi jar

2.代码示例

public List getAllExcel(File file,String tableName,String fname,　　String enterpriseId,String reportId,String projectId)

throws FileNotFoundException,IOException,ClassNotFoundException,　　InstantiationException,IllegalAccessException,　　NoSuchMethodException,SecurityException,IllegalArgumentException,　　InvocationTargetException,ParseException {

List listt = new ArrayList();

try {

FileInputStream fis = new FileInputStream(file);

Workbook workbook = null;

if (fname.toLowerCase().endsWith("xlsx")) {

workbook = new XSSFWorkbook(fis);

} else if (fname.toLowerCase().endsWith("xls")) {

workbook = new HSSFWorkbook(new POIFSFileSystem(fis));

}

int numberOfSheets = workbook.getNumberOfSheets();

for (int i &#