情况是这样的:
我有一个 Excel 文件,其中包含以下信息:
文档位置:(C:/folder/sub/file.doc)
和文档新名称:(RENAMED-FILE.doc)
由于我有大约一千个文件需要重命名,因此自动化此操作的最佳方法是什么?
*笔记:
文档位置可以位于不同的位置(文件并不总是位于文件夹/子文件夹内)
文档新名称没有命名约定。
所以基本上,所有内容都必须来自 excel 文件,或者我必须将 excel 文件更改为其他文件(也许是 CSV 文件?)才能使其与另一个实用程序一起使用。
有什么建议么?
Here's the situation:
I have an excel file which contains the following information:
Document location: (C:/folder/sub/file.doc)
and Document New Name: (RENAMED-FILE.doc)
What would be the be the best way to automate this as I have about a thousand files to rename?
*Note:
Document location can be in different locations (files will not always be inside folder/sub)
Document new name has no naming convention.
So basically, everything has to come from the excel file, or I have to change the excel file into something (maybe a CSV file?) to have it work with another utility.
Any suggestions?
发布评论
评论(2)
将其导出为 CSV 或其他易于解析的文本格式,然后编写快速脚本来重命名内容可能是最快的方法。
Exporting it to CSV or another easily parse-able text format and then writing a quick script to rename things would probably be the fastest method.
我已经通过熟练的谷歌搜索回答了我自己的问题:
http://www.labnol.org/software/tutorials/rename-multiple-files-bulk-excel-googl-docs/2481/
感谢您抽出宝贵的时间,Dav: )
I've answered my own question with a well-versed google search:
http://www.labnol.org/software/tutorials/rename-multiple-files-bulk-excel-googl-docs/2481/
Thank you for your time though Dav :)