导入Excel 工作表.xls解析并保存到数据库

Question

目前我可以解析指定位置的Excel,比如D:/backup/currency.xls目录下的Excel,

但是从页面上导入currency.xls到系统里，再解析，并保存到数据库要怎么做啊？
[b]问题补充：[/b]
public static List getBOFromExcelFile(String fileAbsolutePathName) {
List boList = new ArrayList();
// CMSBean cmsBean ;
try {

        Workbook book = Workbook
                .getWorkbook(new File(fileAbsolutePathName));
        Sheet sheet = book.getSheet(0);
        int rowNum = sheet.getRows();
        int columnNum = sheet.getColumns();
        for (int i = 1; i < rowNum; i++) {
            // // cmsBean = new CMSBean();
            // for(int j=0;j<columnNum;j++){
            // Cell cell = sheet.getCell(j, i);
            // if(j == 0)
            // cmsBean.setUserName(cell.getContents());
            // if(j == 1)
            // cmsBean.setPassword(cell.getContents());
            // if(j == 2)
            // cmsBean.setRole(cell.getContents());
            // if(j == 3)
            // cmsBean.setEmail(cell.getContents());
            // }
            // boList.add(cmsBean);

            for (int j = 0; j < columnNum; j++) {
                Cell cell = sheet.getCell(j, i);
                if (j == 0)
                    System.out.println("+++++"+cell.getContents());
            }
        }
        book.close();
    } catch (Exception e) {
        // TODO: handle exception
        e.printStackTrace();

    }
    return boList;
}

我想问从web页面上导入Excel.xls,并马上解析入库，不保存到服务器然后再去解析入库

Answer 1

[url]http://hi.baidu.com/sunjsp/blog/item/3dce81231145da549922ed47.html[/url]