如何将文件夹中的批量映像文件名复制到excel

您可以打开命令提示符（运行>> cmd.exe）并转到指定的文件夹C：\> cd folder_path

然后键入此命令...

You can open a command prompt (Run>>cmd.exe) and go to the specified folder C:\> cd folder_path
then type this command...

dir > list.txt

如果你只想要文件名，那么在dir之后添加/ b

If you want filenames only then add /b after dir

dir /b > list.txt

将会有一个文件，即list.txt将在文件夹中创建..

你可以打开它，然后复制粘贴到Excel ...

There will be a file namely list.txt will be created in the folder..
You can open it, and copy-paste to Excel...

假设您有一个文件夹 C：\Temp \Images ，并且您希望文件中的所有 JPG 文件 C：\Temp \ MyFileList.csv ，您只需从命令行执行此操作;

Let's say you have a folder, C:\Temp\Images and you want all the JPG files from there in a file C:\Temp\MyFileList.csv, you could simply do this from the command line;

C:\dir C:\Temp\Images *.jpg /b > C:\Temp\MyFileList.csv

然后在Excel中打开该文件。



现在，如果你想要比这更自动化的东西，那么你需要指定应该如何完成（即使用C＃程序或从现有的电子表格中运行宏/ VBA）。



希望这会有所帮助，

Fredrik

Then open that file in Excel.

Now, if you want something a bit more automated than that then you need to specify how that should be done (i.e. using a C# program or running a macro/VBA from inside an already existing spread sheet).

Hope this helps,
Fredrik