Java实现xlsx文件下载和文件上传

Java实现xlsx文件下载和文件上传

文件下载：(xlsx下载案例)

直接上代码 （注：header的文件头编码要设置好否则可能会出现乱码）

 public void downloadTemplate(HttpServletRequest request, HttpServletResponse response) {
        //设置ContentType文件下载类型
        response.setContentType("application/x-msdownload");
        //在Header上设置文件名和编码
        String dateName = "下载文件.xlsx";
        response.setHeader("Content-Disposition", "attachment;filename=" + new String(dateName.getBytes(StandardCharsets.UTF_8), StandardCharsets.ISO_8859_1));
        //声明一个输出流
        OutputStream out = null;
        try {
            //拿到response输出流
            out = response.getOutputStream();
            //sheet页name
            XSSFSheet sheet1 = workbook.createSheet("sheetName");
            //创建行
            XSSFRow titleRow1 = sheet1.createRow(0);
            //创建列
            titleRow1.createCell(0).setCellValue("行1列1");
            titleRow1.createCell(1).setCellValue("行1列2");
            titleRow1.createCell(2).setCellValue("行1列3");
            XSSFRow titleRow2 = sheet1.createRow(1);
            titleRow2.createCell(0).setCellValue("行2列1");
            titleRow2.createCell(1).setCellValue("行2列2");
            titleRow2.createCell(2).setCellValue("行2列3");
            try {
            	//写入输出流
                workbook.write(out);
            } catch (Exception e) {
                e.printStackTrace();
            }
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            try {
                if(out != null){
                    out.flush();
                    out.close();
                }
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }

文件上传

后续xlsx处理可进入主页查看我写的另一篇读取并解析xlsx

@PostMapping("/upload")
    public void Upload(HttpServletRequest request, @RequestPart("file") MultipartFile files) {
        String fileName = files.getOriginalFilename();
        //获取文件大小
        long size = files.getSize();
        String prefix = null;
        if (fileName != null) {
            //获取文件类型
            prefix = fileName.substring(fileName.lastIndexOf(".") + 1);
        }
    }