execl列表读取url并下载到文件夹

最新推荐文章于 2024-02-05 15:58:29 发布

不二嘉ya

最新推荐文章于 2024-02-05 15:58:29 发布

阅读量184

点赞数

文章标签： java

本文链接：https://blog.csdn.net/weixin_65687276/article/details/132468664

版权

package com.sysn.mysql.download;

import cn.hutool.core.util.StrUtil;
import cn.hutool.poi.excel.ExcelReader;
import cn.hutool.poi.excel.ExcelUtil;
import cn.hutool.poi.excel.ExcelWriter;
import org.apache.commons.collections4.CollectionUtils;
import org.apache.commons.collections4.MapUtils;

import java.util.*;

/**
 * @Author: WeiZJ
 * @Date: 2023/8/23 16:23
 * @Description:
 */
public class DownloadFileExcel {

    public static final String OUT_PATH = "E:\\test";

    public static void main(String[] args) {
        DownUtil downUtil = new DownUtil();

        ExcelReader reader = ExcelUtil.getReader("C:\\Users\\admin\\Desktop\\111\\play.xlsx");
        List<Map<String, Object>> readAll = reader.readAll();
        Iterator<Map<String, Object>> iterator = readAll.iterator();

        Map<String, List<String>> mapHashMap = new HashMap<>();

        while (iterator.hasNext()) {
            Map<String, Object> next = iterator.next();
            String uName = (String) next.get("姓名");
            uName = uName.trim();

            //附件集合
            ArrayList<String> fileUrl = new ArrayList<>();

            if (StrUtil.isNotBlank(next.get("上传简历").toString())) {
                fileUrl.add(next.get("上传简历").toString());
            }
            if (StrUtil.isNotBlank(next.get("报名表格").toString())) {
                fileUrl.add(next.get("报名表格").toString());
            }
            if (StrUtil.isNotBlank(next.get("身份证正面").toString())) {
                fileUrl.add(next.get("身份证正面").toString());
            }
            if (StrUtil.isNotBlank(next.get("身份证反面").toString())) {
                fileUrl.add(next.get("身份证反面").toString());
            }
            if (StrUtil.isNotBlank(next.get("户口簿").toString())) {
                fileUrl.add(next.get("户口簿").toString());
            }
            if (StrUtil.isNotBlank(next.get("学历证书").toString())) {
                fileUrl.add(next.get("学历证书").toString());
            }
            if (StrUtil.isNotBlank(next.get("学位证书").toString())) {
                fileUrl.add(next.get("学位证书").toString());
            }
            if (StrUtil.isNotBlank(next.get("专业技术资格证书").toString())) {
                fileUrl.add(next.get("专业技术资格证书").toString());
            }
            if (StrUtil.isNotBlank(next.get("工作经验证明").toString())) {
                fileUrl.add(next.get("工作经验证明").toString());
            }
            if (StrUtil.isNotBlank(next.get("电子照片").toString())) {
                fileUrl.add(next.get("电子照片").toString());
            }

            List<String> list = mapHashMap.get(uName);
            if (CollectionUtils.isEmpty(list)) {
                mapHashMap.put(uName, fileUrl);
            }
        }

        List<Map<String, String>> list = new ArrayList<>();
        mapHashMap.forEach((k, v) -> {
            Map<String, String> fileMap = new HashMap<>();
            String fileFinalPath = downUtil.downloadPicture(v, OUT_PATH);
            System.out.println(fileFinalPath);
            fileMap.put("姓名", k);
            fileMap.put("附件文件路径", fileFinalPath);

            list.add(fileMap);
        });


        ExcelWriter writer = ExcelUtil.getWriter("E:\\rcsjfj.xlsx");

        writer.passCurrentRow();

        writer.write(list, true);

        writer.close();
    }
}

package com.sysn.mysql.download;

import cn.hutool.core.util.StrUtil;
import org.apache.poi.util.StringUtil;

import java.io.FileOutputStream;
import java.io.DataInputStream;
import java.io.File;
import java.net.HttpURLConnection;
import java.net.URL;
import java.util.List;
import java.util.UUID;

/**
 * @Author: WeiZJ
 * @Date: 2023/8/23 16:15
 * @Description:
 */
public class DownUtil {

    public String downloadPicture(List<String> picUrls, String outPath) {
        String outUrl = outPath + "\\" + UUID.randomUUID().toString() + "\\";
        File outPathFile = new File(outPath);
        File outFile = new File(outUrl);
        //判断文件路劲存不存在
        if (!outPathFile.exists()) {
            outPathFile.mkdir();
        }
        if (!outFile.exists()) {
            outFile.mkdir();
        }
        String msg = "下载完成！！";

        picUrls.forEach(x -> {
            try {
                String suf = "";
                String[] split = x.split("\\.");
                if (split.length > 0) {
                    suf = split[split.length - 1];
                }

                URL url = new URL(x);
                HttpURLConnection conn = (HttpURLConnection) url.openConnection();
                conn.setRequestProperty("User-Agent", "Mozilla/5.0");

                DataInputStream dataInputStream = new DataInputStream(conn.getInputStream());
                String imageName = UUID.randomUUID().toString() + StrUtil.DOT + suf;
                FileOutputStream fileOutputStream = new FileOutputStream(new File(outUrl + imageName));

                byte[] buffer = new byte[10240];
                int length;

                while ((length = dataInputStream.read(buffer)) > 0) {
//                    System.out.println("正在下载:   " + imageName);
                    fileOutputStream.write(buffer, 0, length);
                }

                dataInputStream.close();
                fileOutputStream.close();

            } catch (Exception e) {
                e.printStackTrace();
            }
        });

        return outUrl;
    }
}