有冇方法張一堆檔案名加入excel中?

2008-08-19 6:53 am
我有過百個檔案,想張檔案名做成一個excel表,但吾知用咩方法可以匯入表中有冇人可以教教我呀?

回答 (3)

2008-08-19 8:00 pm
✔ 最佳答案
windows start menu --> RUN cmd
change to the target directory where those files are in
type the following command:
dir /b >list.xls
now you have the list.xls in the target directory
open that file with excel
you will see file names row by row


2008-08-19 12:01:14 補充:
dir /b >list.xls

there is a space after dir;
there is a space after /b
2008-08-25 5:42 pm
ThankYou so much !
2008-08-19 11:09 pm
Very good!


收錄日期: 2021-04-19 01:42:17
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20080818000051KK04053

檢視 Wayback Machine 備份