1、建立一个新的EXCLE表,单击鼠标右键—新建—XLS工作表,建立好后打开表格。
/iknow-pic.cdn.bcebos.com/71cf3bc79f3df8dc8219db67c311728b4710281b"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/71cf3bc79f3df8dc8219db67c311728b4710281b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/71cf3bc79f3df8dc8219db67c311728b4710281b"/>
2、在新建好的空白表格中第一列输入需要创建的文件夹名称。
/iknow-pic.cdn.bcebos.com/38dbb6fd5266d01662e2cfde992bd40734fa3548"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/38dbb6fd5266d01662e2cfde992bd40734fa3548?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/38dbb6fd5266d01662e2cfde992bd40734fa3548"/>
3、在第二列输入公式, ="MD"&A1,按下回车键,结果如下图所示。切记MD有半角状态下的双引号,且MD和”号之间需空一格。
/iknow-pic.cdn.bcebos.com/d788d43f8794a4c22315b7dd00f41bd5ad6e3915"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/d788d43f8794a4c22315b7dd00f41bd5ad6e3915?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/d788d43f8794a4c22315b7dd00f41bd5ad6e3915"/>
4、新建一个TXT文档,点击鼠标右键—新建—文本文档,打开新建的文本文档。
/iknow-pic.cdn.bcebos.com/2f738bd4b31c870101a8e210297f9e2f0708ff2e"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/2f738bd4b31c870101a8e210297f9e2f0708ff2e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/2f738bd4b31c870101a8e210297f9e2f0708ff2e"/>
5、将EXCLE表格中第二列内容复制粘贴到新建的文本文档中,并保存。
/iknow-pic.cdn.bcebos.com/8435e5dde71190ef6de4c629c01b9d16fdfa602c"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/8435e5dde71190ef6de4c629c01b9d16fdfa602c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/8435e5dde71190ef6de4c629c01b9d16fdfa602c"/>
6、关闭文本文档,将文本文文档扩展名由txt修改为bat,弹框选“是”。
/iknow-pic.cdn.bcebos.com/4bed2e738bd4b31c18e5c44d89d6277f9f2ff86f"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/4bed2e738bd4b31c18e5c44d89d6277f9f2ff86f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/4bed2e738bd4b31c18e5c44d89d6277f9f2ff86f"/>
7、双击运行刚改好的bat文件,即生成文档中名称对应的文件夹。
/iknow-pic.cdn.bcebos.com/18d8bc3eb13533fabc36c5d8a6d3fd1f40345b47"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/18d8bc3eb13533fabc36c5d8a6d3fd1f40345b47?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/18d8bc3eb13533fabc36c5d8a6d3fd1f40345b47"/>