首页 > 其他 > 详细

POI 解析xls

时间:2016-05-09 12:27:50      阅读:112      评论:0      收藏:0      [点我收藏+]

1、所需jar包

poi-3.6.jar

poi-ooxml-3.6.jar

 

2、M.java

package junit;

import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class M {
    public static void main(String[] args) throws IOException {
        readXls("C:\\Users\\taop\\Desktop\\dhm.xls");
    }

    public static void readXls(String path) throws IOException {
        List<Map<String, Object>> lMap = new ArrayList<Map<String, Object>>();
        InputStream is = new FileInputStream(path);
        
        HSSFWorkbook hssfWorkbook = new HSSFWorkbook(is);
        // Read the Sheet
        for (int numSheet = 0; numSheet < hssfWorkbook.getNumberOfSheets(); numSheet++) {
            HSSFSheet hssfSheet = hssfWorkbook.getSheetAt(numSheet);
            if (hssfSheet == null) {
                continue;
            }
            // Read the Row
            for (int rowNum = 1; rowNum <= hssfSheet.getLastRowNum(); rowNum++) {
                HSSFRow hssfRow = hssfSheet.getRow(rowNum);
                if (hssfRow != null) {
                    Map<String, Object> map = new HashMap<String, Object>();
                    int no = (int)hssfRow.getCell(0).getNumericCellValue();
                    String name = hssfRow.getCell(1).getStringCellValue();
                    map.put("no", no);
                    map.put("name", name);
                    lMap.add(map);
                }
            }
        }
    }

}

 

POI 解析xls

原文:http://www.cnblogs.com/tplovejava/p/5473248.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!