我最近在做一个oa项目，其中有一个excel文件导入到数据中去，用poi做的。我现在在后台能够得到文件的完整路径，但是HSSFWorkbook并没有创建一个工作簿。在网上找了很多资料，并没有找到解决方案，本人是只菜鸟，望各位大侠指路，帮忙看看。谢谢！

前台import.jsp代码：

写道

<%@ page contentType="text/html;charset=GBK"%>
<%@ page session="true" %>
<%@ page isThreadSafe="true" %>
<head>

<style type="text/css">

</style>
<title></title>
</head>
<body >

<script language="javascript">
function add(){
var filePath = document.myform.Urlexcel.value;
alert(filePath);
myform.action="saveExcel.jsp?filePath="+filePath ;
myform.submit();
}

</script>
<form action="saveExcel.jsp" enctype="multipart/form-data" name="myform" method="post" onSubmit="return check(this)">

<p> </p>
<p> </p>
<p> </p>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="50" align="center" valign="middle"> </td>
<td height="50" align="left" valign="middle"> Excel文件：
<input name="Urlexcel" type="file" id="Urlexcel" size="41" /></td>
<td> </td>
</tr>
<tr>

<td height="50" align="center" valign="middle" colspan="2">
<input type="button" onClick="add();" name="Submit1" value="确认提交" />

<input type="submit" name="Submit2" value="取消重置" />
</td>
<td> </td>
</tr>
</table>
</form>

</body>
</html>

后台saveExcel.jsp代码：

<%@ page language="java"%>
<%@ page session="true"%>
<%@ page isThreadSafe="true"%>
<%@ page contentType="text/html;charset=GBK"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFWorkbook"%>
<%@page import="java.io.FileInputStream"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFSheet"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFCell"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFRow"%>
<%@page import="java.io.FileNotFoundException"%>
<%@page import="java.io.IOException"%>
<%@page import="org.apache.poi.poifs.filesystem.POIFSFileSystem"%>
<% 
    String filePath = request.getParameter("filePath");
    out.println(filePath);
    try {
            // 创建对Excel工作簿文件的引用
            FileInputStream fis = new FileInputStream(filePath); 
            POIFSFileSystem fs = new POIFSFileSystem(fis); 
            HSSFWorkbook wookbook = new HSSFWorkbook(fs);
            out.println(wookbook);//此处并没有打印出能容
            HSSFSheet sheet = wookbook.getSheet("Sheet1");
            // 获取到Excel文件中的所有行数
            int rows = sheet.getPhysicalNumberOfRows();
            out.println(rows);
            // 遍历行
            for (int i = 0; i < rows; i++) {
                // 读取左上端单元格?
                HSSFRow row = sheet.getRow(i);
                // 行不为空 if (row != null) {
                // 获取到Excel文件中的所有的列
                int cells = row.getPhysicalNumberOfCells();
                String value = "";
                // 遍历列
                for (short j = 0; j < cells; j++) {
                    // 获取到列的值
                    HSSFCell cell = row.getCell(j);
                    if (cell != null) {
                        switch (cell.getCellType()) {
                        case HSSFCell.CELL_TYPE_FORMULA:
                            break;
                        case HSSFCell.CELL_TYPE_NUMERIC:
                            value += cell.getNumericCellValue() + ",";
                            break;
                        case HSSFCell.CELL_TYPE_STRING:
                            value += cell.getStringCellValue() + ",";
                            break;
                        default:
                            value += "0";
                            break;
                        }
                    }
                } 
                // 将数据插入到mysql数据库中
                    String[] val = value.split(",");
                    Nsxxb1 entity = new Nsxxb1() ;
                    entity.setGLM(val[0]);
                    entity.setQYMC(val[1]);
                    entity.setXSE1(Double.parseDouble(val[2]));
                    entity.setZZS1(Double.parseDouble(val[3]));
                    entity.setYYS1(Double.parseDouble(val[4]));
                    entity.setXFS1(Double.parseDouble(val[5]));
                    entity.setQYSDS1(Double.parseDouble(val[6]));
                    entity.setGRSDS1(Double.parseDouble(val[7]));
                    entity.setYHS1(Double.parseDouble(val[8]));
                    entity.setTDZZS1(Double.parseDouble(val[9]));
                    entity.setCJS1(Double.parseDouble(val[10]));
                    Nsxxb1Service.insert(entity);
            }
        } catch (FileNotFoundException e) {
            out.println("导入失败");
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }   
%>

Jia__xin

poi实现在同一个单元格插入多个图片

3条回答

为你推荐