SpringBoot利用POI上传excel文件

最新推荐文章于 2024-01-17 11:05:56 发布

szzssz

最新推荐文章于 2024-01-17 11:05:56 发布

阅读量1.3k

点赞数

文章标签： poi excel 上传文件

本文链接：https://blog.csdn.net/szzssz/article/details/81183552

版权

POM文件引入依赖包
<!-- Excel -->
<dependency>
   <groupId>org.apache.poi</groupId>
   <artifactId>poi-ooxml</artifactId>
   <version>3.14</version>
</dependency>

前端实例代码：

<!DOCTYPE html>
<html>
<head>
<#assign ctx = request.contextPath />

    <meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="${ctx}/label/importTag" enctype="multipart/form-data" method="post">
   <span style="white-space:pre">    </span><input type="file" name="file"/>
   <span style="white-space:pre">    </span><input type="submit" value="导入"/>
   <span style="white-space:pre">    </span>
</form>

</body>
</html>

后端java代码:

@RequestMapping(value="importTag")
public void importUser(HttpServletRequest request, HttpServletResponse response, MultipartFile file){
    try {
        InputStream is = file.getInputStream();
        XSSFWorkbook wb = new XSSFWorkbook(is);//xslx
        XSSFSheet sheet= wb.getSheetAt(0); //sheet 从0开始

        int rowNum = sheet.getLastRowNum() + 1; //取得最后一行的行号

        Date date = new Date();
        int all=0;
        for (int i = 0; i < rowNum; i++) {  //行循环开始

            XSSFRow row = sheet.getRow(i); //行

            String tagId =  getcellvalue(row.getCell(0));
            String tagName= getcellvalue(row.getCell(1));
            String pTagid= getcellvalue(row.getCell(2));


           /* TAG tag = new TAG();
            tag.setTagName(tagName);
            tag.setPTagid(pTagid);
            tag.setTagId(tagId);
            tag.setCreateUser("admin");
            tag.setModifyUser("admin");
            tag.setCreateDate(date);
            tag.setModifyDate(date);
            tag.setTagClassNo("2");
            tag.setTagClassName("22");
            tag.setStatus("1");
            int  count  =labelService.addLabel(tag);
            all=all+count;*/
        }

    } catch (Exception e) {
        System.out.println(e);
    }


    private static String getcellvalue(Cell cell){
        String cellValue = "";
        if (null != cell) {// 判断excel单元格内容的格式，并对其进行转换，以便插入数据库
            switch (cell.getCellType()) {  
                case 0:
                    cellValue = String.valueOf((int) cell.getNumericCellValue());
                    break;
                case 1:
                    cellValue = cell.getStringCellValue();
                    break;
                case 2:
                    cellValue = cell.getNumericCellValue() + "";
                    // cellValue = String.valueOf(cell.getDateCellValue());
                    break;
                case 3:
                    cellValue = "";
                    break;
                case 4:
                    cellValue = String.valueOf(cell.getBooleanCellValue());
                    break;
                case 5:
                    cellValue = String.valueOf(cell.getErrorCellValue());
                    break;
            }
        } 
        return  cellValue.trim();
    }

szzssz

关注

0
点赞
踩
3

收藏

觉得还不错? 一键收藏
0
评论
SpringBoot利用POI上传excel文件

POM文件引入依赖包&lt;!-- Excel --&gt;&lt;dependency&gt; &lt;groupId&gt;org.apache.poi&lt;/groupId&gt; &lt;artifactId&gt;poi-ooxml&lt;/artifactId&gt; &lt;version&gt;3.14&lt;/version&gt;&a
复制链接

扫一扫