Java将EXCEL转为VCF格式工具

一、需求背景

由于部分邮箱只能导入VCF格式的通讯录，HRBP只有EXCEL类型的通讯录，分为姓名、邮箱两列，为了实现批量的通讯录邮箱导入，用Java帮人力做了一个EXCEL转换VCF格式的小工具，比较简单直接看代码

二、使用步骤

1.引入POM文件

代码如下（示例）：

        <dependency>
            <groupId>cn.hutool</groupId>
            <artifactId>hutool-all</artifactId>
            <version>5.3.8</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>4.1.2</version>
        </dependency>

2.代码

package com.example.demo.controller;


import cn.hutool.poi.excel.ExcelReader;
import cn.hutool.poi.excel.ExcelUtil;

import java.io.File;
import java.io.FileNotFoundException;
import java.io.PrintWriter;
import java.util.List;
import java.util.Map;

import org.apache.commons.lang.StringUtils;


public class test {
    private static String tempFileDir="C:\\Users\\Admin\\Desktop\\test0322"; //文件夹地址

    public static final String BEGIN = "BEGIN:VCARD";
    public static final String VERSION = "VERSION:3.0";
    public static final String N = "N:";
    public static final String EMAIL = "EMAIL;TYPE=PREF,INTERNET:";
    public static final String END = "END:VCARD";


    public static void main(String[] args) throws FileNotFoundException {

        String fileName = "test.xls";//excel名称
        File file = new File(tempFileDir + File.separator + fileName);
        ExcelReader reader;
        //通过sheet编号获取
        reader = ExcelUtil.getReader(file, 0);
        List<Map<String,Object>> resList = reader.readAll();
        PrintWriter pw = null;
        File out = new File(tempFileDir + File.separator + "mytest.vcf"); //导出文件名称
        pw = new PrintWriter(out);

        for (Map<String,Object> map:resList) {
            String vcContent = "";
            vcContent += BEGIN + "\n";
            vcContent += VERSION + "\n";
            vcContent += N + map.get("姓名").toString() + "\n";
            if(StringUtils.isNotEmpty(map.get("邮箱").toString())){
                vcContent += EMAIL + map.get("邮箱").toString() + "\n";
            }
            vcContent += END + "\n";
            pw.write(vcContent);
        }
        pw.close();

    }
}

参考https://blog.csdn.net/qq_33792242/article/details/123109947?ops_request_misc=&request_id=&biz_id=102&utm_term=Excel%E8%BD%ACVCF&utm_medium=distribute.pc_search_result.none-task-blog-2~all~sobaiduweb~default-9-123109947.nonecase&spm=1018.2226.3001.4187