java 用PIO读取Excel

[java]代码库

package com.neusoft.counter.util;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
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 com.neusoft.counter.vo.LoginIdStaffNo;

public class ExcelDemo {

    private static final Log log = LogFactory.getLog(ExcelDemo.class);

    public List parseExcel(File in) {
        List arrayList = new ArrayList();

        FileInputStream fis = null;
        POIFSFileSystem fs = null;

        try {
            fis = new FileInputStream(in);
            fs = new POIFSFileSystem(fis);

            HSSFWorkbook wb = new HSSFWorkbook(fs);
            // first sheet
            HSSFSheet sheet = wb.getSheetAt(0);
            int lastRow = sheet.getLastRowNum();

            HSSFRow row = null;
            HSSFCell cell = null;
            int columnNum = row.getLastCellNum();
            String data[] = new String[2];

            // 读取Excel表格
            for (int i = 1; i <= lastRow; i++) { // 行循环
                row = sheet.getRow(i);

                for (int j = 0; j < columnNum; j++) { // 列循环
                    cell = row.getCell((short) j);
                    if (cell != null && cell.getCellType() != HSSFCell.CELL_TYPE_BLANK) {
                        data[j] = cell.getStringCellValue().trim();

                    }
                }

                //TODO add to List
            }

        }
        catch (FileNotFoundException e) {
            log.error(e);
        }
        catch (IOException e) {
            log.error(e);
        }

        return arrayList;

    }

    public void writeToExcel(Map map, File outFile) throws IOException {
        if (map == null) {
            log.info("没有输出到excel的数据！");
            return;
        }
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet sheet = wb.createSheet();

        // 标题
        HSSFRow title = sheet.createRow(0);
        HSSFCell userCell = title.createCell((short) 0), staffCell = title.createCell((short) 1), _infoCell = title
                .createCell((short) 2);
        userCell.setEncoding(HSSFCell.ENCODING_UTF_16);
        userCell.setCellValue("后台用户");
        staffCell.setEncoding(HSSFCell.ENCODING_UTF_16);
        staffCell.setCellValue("柜员号");
        _infoCell.setEncoding(HSSFCell.ENCODING_UTF_16);
        _infoCell.setCellValue("失败原因");

        for (Iterator itr = map.keySet().iterator(); itr.hasNext();) {
            String key = (String) itr.next();
            List list = (List) map.get(key);
            String info = "";
            if ("1".equals(key))
                info = "后台用户不存在";
            else if ("2".equals(key))
                info = "柜员号重复";
            else if ("3".equals(key))
                info = "插入数据库出错";

            appendToSheet(sheet, list, info);
        }

        FileOutputStream fos = new FileOutputStream(outFile);

        wb.write(fos);
        fos.close();

    }

    private void appendToSheet(HSSFSheet sheet, List datas, String info) {

        if (datas == null)
            return;
        int offset = sheet.getLastRowNum();
        int size = datas.size();
        for (int i = 0; i < size; i++) {
            LoginIdStaffNo ls = (LoginIdStaffNo) datas.get(i);
            HSSFRow row = sheet.createRow(offset + i + 1);
            row.createCell((short) 0).setCellValue(ls.getUserLoginId());
            row.createCell((short) 1).setCellValue(ls.getStaffNo());

            HSSFCell infoCell = row.createCell((short) 2);
            infoCell.setEncoding(HSSFCell.ENCODING_UTF_16);
            infoCell.setCellValue(info);
        }
    }
}

//源代码片段来自云代码http://yuncode.net