å·¥å ·/åæ
çµèï¼WINDOWS7ç³»ç»
1ãæè¦æ´åçæ件æ¾å¨åä¸ä¸ªæ件夹ä¸ãæ¬æ以E:\song\beyondæ件夹ä¸çææmp3ææ²ä¸ºä¾ãè¿äºMP3æ件æ¯ç´æ¥ä»ç½ä¸ä¸è½½çï¼ç°å¨è¦å»ææ件åä¸å¤ä½çé¨åï¼è®©å ¶æ´ç®æ´ä¸è´ã
2ãå¨âå¼å§âèåææ¬æ¡ä¸ï¼æè¿è¡å½ä»¤ä¸ï¼è¾å ¥cmdï¼å车è¿å ¥DOSå½ä»¤è¡çªå£ã
3ãè¾å ¥âE:âå车ï¼è¿å ¥Eçï¼åè¾å ¥"cd song\beyond"ï¼å车ï¼è¿å ¥ç®æ æ件夹ã
4ãè¾å ¥âdir/b>1.xls",å车ï¼å°±å¯ä»¥ææææ件çæ件åè¾å ¥å°1.xlsçµåè¡¨æ ¼æ件ä¸ãå¯ä»¥çå°å¨beyondæ件夹ä¸å¤äºä¸ä¸ªçµåè¡¨æ ¼æ件1.xlsã
5ãæå¼1.xlsæ件ãå æ第ä¸è¡ã
6ãå¼å§å»ææ件夹ä¸çDOSä¸ä¸å 许å¨æ件åä¸åºç°çå符å¦ç©ºæ ¼ãç横线ãé¡¿å·çãç¨æ¥æ¾/æ¿æ¢å»æè¿äºç¬¦å·ãåæè¦æ±å»æä¸éè¦çæåãå¢å éè¦çæåã
7ãå¨B1åå æ ¼è¾å ¥(1)ï¼åä¸å¡«å ï¼å¨C1åå æ ¼è¾å ¥å ¬å¼"=b1&".mp3"ï¼åä¸å¡«å ï¼å¨D1åå æ ¼è¾å ¥å ¬å¼="ren "&c1&" "&row()&"."&a1,注æç©ºæ ¼ä¸è½æãåä¸å¡«å ãç»æå¦å¾æ示ã
8ãæDåä¸çææå 容å¤å¶å°è®°äºæ¬ä¸ãå°è®°äºæ¬å 容ä¿åè³beyondæ件夹ä¸ï¼å½å为"ren.bat"æ件ã
9ãæå¼beyondæ件夹ãéä¸ææè¦æ¹åçæ件ï¼å¯¹éä¸ç第ä¸ä¸ªæ件ç¹å³é®ï¼éæ©âéå½åâï¼è¾å ¥å称(1)ãå¦ææ¾ç¤ºäºæ©å±åï¼åè¾å ¥å称为(1).mp3ãæå车é®ï¼ææçæ件åä¼åæä¸ä¸ªåºåã注æï¼ä¸è½æ¹æå ¶ä»æ件åãå¦å产ççæ件åä¸ä¼äº§çç©ºæ ¼ï¼è¿æ¯DOSä¸æ件åä¸ä¸å 许çã
10ãåå»beyondæ件夹ä¸çren.batæ件ãå¾å¿«ææçæ件å°èªå¨æ´æ¹ä¸ºæéè¦çæ件åãå é¤1.xlsåren.bat两个æ件ã