å©ç¨EXCELæ¿æ¢æ件åï¼ä½ çæè·¯æ¯å¯¹å¤´çï¼åªæ¯ä½ è¿éè¦BATæ¹å¤çå½ä»¤ã
å ·ä½æä½ï¼
1ãå½å ¥æ è§åå½åç §çæ件åå°EXCELï¼
Aãç¹å»ï¼å¼å§-è¿è¡ï¼è¾å ¥ï¼CMDï¼å¹¶å车ï¼è¿å ¥CMDå½ä»¤çªå£ï¼åè¾å ¥ï¼ç §çæå¨ç符å¦âD:âå车ï¼åè¿å ¥ï¼ç §çæå¨æ件夹å¦âcd \photoâå车ã
Bãè¾å ¥å½ä»¤ï¼dir /b >photo.txtï¼å车ãå³å¯å°è¯¥æ件夹ä¸æææ件åå½å ¥ææ¬æ件ä¸ã
Cãæå¼photo.txtï¼éä¸å¹¶å¤å¶ææå 容ï¼åæ°å»ºEXCELæ件ï¼å°ææå 容å³æ è§åå½åç §çæ件åç²è´´å°Båï¼ä½ æ称çA1ãA2æ¯ä¸å¯¹çï¼ã
2ãå½å ¥å§åï¼å°å§åæå·¥è¾å ¥æå¤å¶ç²è´´å°Cåãå¨Dåè¾å ¥âï¼jpgâä½ä¸ºç §çæ©å±åãå¨Eåå©ç¨å½ä»¤â=B1&C1âå并BåCåå 容ï¼ä½¿ä¹åæâå§å.jpgâãåå°Eåéä¸å¹¶éæ©æ§å¤å¶-æ°å¼å½¢å¼ç²è´´å°Fåãåå é¤æ ç¨çCãDãEåï¼åæ¥çFåéè¿ä¸ºCåã
3ãè¾å ¥æ´åå½ä»¤ï¼å¨Aåè¾å ¥"ren"ã
4ãå¶ä½æ¹å¤çæ件ï¼å¨ç §çæ件夹ä¸æ°å»ºä¸ææ¬æ件ï¼å¹¶éå½å为âmy.batâï¼å°ä¸è¿°XLSè¡¨æ ¼å å®¹å ¨é¨å¤å¶ç²è´´å°æ¤æ件ä¸æ¥ï¼æ¿æ¢å°å¤ä½çç©ºæ ¼åï¼ä¿åã
5ãè¿è¡æ¹å¤çæ件ï¼å¨èµæºç®¡çå¨ä¸åå»my.batï¼WIN7éè¦å³å»éæ©â以管çå身份è¿è¡âï¼ï¼åä¼èªå¨è¿è¡éå½åã