java poi 读取Excel demo

最新推荐文章于 2021-03-05 08:34:55 发布

原创最新推荐文章于 2021-03-05 08:34:55 发布 · 469 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#excel #java #hashmap #string #iterator #exception

该博客展示了如何使用Java的Apache POI库来读取Excel文件。通过创建`POIFSFileSystem`对象和`HSSFWorkbook`实例，然后获取工作表并遍历每一行和单元格，将数据存储到HashMap中，最后打印出来。代码中处理了行和单元格的迭代，并对单元格内容进行了字符串转换。

package apiTest;

import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.*;

import org.apache.poi.hssf.extractor.ExcelExtractor;
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;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;

public class ReadExcel {

@SuppressWarnings("unchecked")
public static void main(String[] args) throws Exception {
     HSSFWorkbook wb = null;
     POIFSFileSystem fs = null;
     try {
       fs = new POIFSFileSystem(new FileInputStream("e://workbook.xls"));
       wb = new HSSFWorkbook(fs);
     } catch (IOException e) {
       e.printStackTrace();
     }

     HSSFSheet sheet = wb.getSheetAt(0);
     //sheetName
     System.out.println(sheet.getSheetName());
//     HSSFRow row1 = sheet.getRow(0);
//     HSSFCell cell = row1.getCell(3);
//     String msg1 = cell.getStringCellValue();
//     System.out.println(msg1);
//     HSSFRow row2 = sheet.getRow(1);
//     HSSFCell cell2 = row2.getCell(2);
//     //System.out.println(cell2);
//     Double msg11 = cell2.getNumericCellValue();
//     System.out.println(msg11);
     List arrayListAll = new ArrayList();
     for (Iterator<Row> iter = (Iterator<Row>) sheet.rowIterator(); iter.hasNext();) {
         Row row = iter.next();
         Map<Integer,Object> hashmap = new HashMap();
         int i = 0;
         for (Iterator<Cell> iter2 = (Iterator<Cell>) row.cellIterator(); iter2.hasNext();) {
         Cell cell = iter2.next();
         String content = cell.getStringCellValue();// 除非是sring类型，否则这样迭代读取会有错误
         hashmap.put(i, content);
         i++;
         }
         arrayListAll.add(hashmap);
     }
     Iterator it1 = arrayListAll.iterator();
     while(it1.hasNext()){
     //System.out.println(it1.next());
     Map map = (HashMap)it1.next();
     System.out.println(map.get(0));
     System.out.println(map.get(1));
     System.out.println(map.get(2));
     System.out.println(map.get(3));
     System.out.println(map.get(5));
     }
}
}