<menu id="suuyg"><code id="suuyg"></code></menu>
  • <menu id="suuyg"><nav id="suuyg"></nav></menu>
    <tt id="suuyg"><tt id="suuyg"></tt></tt>
  • <xmp id="suuyg">
  • <nav id="suuyg"></nav>
    <nav id="suuyg"></nav>
    Question to say "I can!"

    如何批量修改文件名

    2016-12-28

    如果我們有一堆的圖片要批量命名,命名的規則要對應用一個表中的字段名。我們可以批量修改文件名,下面就和大家一起分享這個經驗。

    1.在e盤建立一個文件夾,將所有的圖片放置于該文件夾中。

    2.鼠標左鍵點擊,開始->運行->在對話框中輸入字母cmd,進入dos模式鼠標。

    3.在dos模式輸入命令行“cd e:\pic”然后回車,再輸入命令行“dir /b>rename.xls",可將文件夾中的文件名在rename.xls文件中列出。

    (小貼士:有的時候,你的計算機正處于中文輸入狀態,為確保命令行能夠打出來,你可以切換成英文大寫狀態。)

    4.用xls打開e:\pic文件夾中的rename.xls,你會發現文件名已全部羅列在A列中,你可以在B1列中輸入對應的文件文件名(這里你可以用vlookup函數從另一個表中取出對應的字段)。

    5.將A列單元格中沒有用的文件名刪除。

    6.鼠標選中C1單元格,并在編輯框中輸入公式="ren "&A1&" "&B1&".jpg"

    7.繼續用鼠標拖動C1單元格右下方的句柄。

    8.然后,鼠標選中C列,鼠標右鍵復制。

    9.在記事本中,粘貼剛才的命令行。

    10.鼠標點擊菜單“文件”-“另存為”,輸入文件名ren.bat,保存在e:\pic中,文件的保存類型選擇“所有文件”。

    11.打開e盤pic文件夾,鼠標雙擊ren.bat這個批處理文件,即可將該文件夾下的jpg圖片,按照剛才rename.xls中的順序和文件名批量修改文件名。

    自此,你已經完成了批量修改文件名的操作。我們運用了dos命令技巧、xls技巧以及批處理3個知識點來達到批量修改文件名的效果。

    作者:admin | Categories:辦公能手 | Tags:

    發表評論

    電子郵件地址不會被公開。 必填項已用*標注

    *

    日彩网平台日彩网主页日彩网网站日彩网官网日彩网娱乐 www.7340111.com | www.kx151.com | www.030158.com | 85698s.com | www.555pj8.cc | www.60108e.com | www.498888k.com | www.cb3188.com | www.y611.com | www.177478.com | www.xpj6666.cc | www.sxyl2.com | www.849431.com | 86811j.com | www.vnsr388.com | 7196ee.com | www.suncity758.com | 1691991.com | www.138cpm.com | amhg033.com | www.2807777.com | bet28q.com | www.3126q.com | www.bet365de.com | www.179223.com | www.5360tt.com | 0055buyu.com | www.4102p.com | 4809o.com | www.78949h.com | 44077j.com | www.926576.com | www.21204126.com | 267365.com | www.dayou266.com | www.ag9.com | 33313w.com | www.938d.cc | 36406622.com | www.022e.cc | www.88837r.com | 18775u.com | www.115527b.com | mmm40033.com | www.hx6606.com | www.57768u.com | hgvipvip3.com | www.amjsylc.bet | 56988vv.com | www.547638.com | www.3350.com | 0015mm.com | www.85wcp.com | www.hg0532.com | 001122331.com | www.68993267.com | www.586885.com | 8898000.com | www.00772n.com | pj88dd.com | www.2373b.com | www.88554066.com | 3559zzz.com | www.64700.com | www.3643r.com | 0033p.cc | www.35898f.com | www.yh6556.com | 31435544.com | www.bet73k.com | www.pp224.cc | 80878w.com | www.022l.cc | www.ylg3456.com | 44303.com | www.c5906.com | www.g4042.com | 66185a.net | www.255811.com | www.38345o.com | jbb93.cc | www.338082.com | www.600w.com | 28839r.com | www.525059.com | www.466890.com | 8866vn77.com | 99151i.com | www.16065g.com | www.38987.com | 69448877.com | www.976291.com | www.668hyc.com | 8742aa.com | x48i.com | www.71399b.com | www.4858189.com | 8685050.com | 28758j.com | www.89777j.com | www.79667.com | 35222i.com | www.374677.com | www.56730.cc | www.1869c.com | 3121gg.com | www.8839n.com | www.wt5222.com | 2544b3.com | 4630022.com | www.607116.com | www.430msc.com | 8037i.com | www.591029.com | www.695044.com | www.wn0003.com | 00755b.com | www.171880.com | www.16065i.com | www.98msxfpt4.com | www.hg9192.com | 450372.com | www.rcw8833.com | www.xj7003.com | www.77605u.com | hgyz5.com | bet365vip.com | www.nnw6.com | www.a88.com | www.ii9702.com | 4809m.com | pjshanghai.com | www.005710.com | www.33588k.com | www.rb4440.com | www.hf0688.com | www.7788.tt | www.hqg88.com | 50099p.com | 228888f.com | www.596233.com | www.3790022.com | www.4972m.com | www.77077.com | 8159ee.cc | www.97655e.com | www.22303.cc | www.4078k.com | www.k38008.com | www.flcb5.com | www.4833011.com | www.biying900vip.com | www.660649.com | am2828.cc | 9645hh.com | www.609814.com | www.60007d.com | www.r32939.com | www.bet36576.com | le888w.com | 3467n.com | YHvip.vip | 9566362.com | www.23636h.com | www.535901.com | www.37533.com | www.s8866.com | 30006f.com | 8827ttt.com | 33382ee.com | www.860836.com | www.621233.com | www.rgcp.cc | www.246123.com | www.hg77716.com | 88am.cc | 3522ee.com | www.50054u.com | www.cmc.cc | www.88266f.com | www.366908.com | www.5504c.com | www.701556.com | www.8816ks.com | 2381i.com | 33382aa.com | 33oo8331.com | 4647q.com | www.339125.com | www.909935.com | www.0014z.com | www.12455o.com | www.jinsha51.com | www.20199bb.com | www.5678096.com | www.dwc4.com | 79794858.com | 20054499.com | 4647l.com | 22207x.com | 1099528.com | qhc52.com | 87665y.com | 1665k.com | www.196209.com | www.627793.com | www.9478x.com | www.80767x.com | www.4923y.com | www.78919f.com | www.2234.cc | www.pj88u.com | www.bwin499.com | www.7025r.com | www.bet365607.com | www.yh6776.com | www.hgw3999.com | www.81866v.com | uu38648.com | 3187.com | 1479r.com | 9964g.com | pj444.com | 3807o.com | 3662u.com | 30019gg.com | bb4119.com | bwin8m.com | jr9933.com | 998g.cc | 22883g.com | 8881480.com | 6q604.com | 3089s.com | 22ff940.com | 50022211.com | 86226j.com | 78808t.com | 32555h.com | 11018o.com | 0099227.com | 2222buyu.com | hy5900.com | www.00amjs.com | www.v3304.com | www.xpj4464.com | www.2388.tv | 4066a.com | 9420y.com | n21148.com | 8381l.com | 69111a.com | jjj2267.com | www.long8308.com | www.25288v.com | www.98am444.com | www.h70088h.com | www.123377.com | www.hg702.com | www.4546700.com | www.60886r.com | www.jsggb02.com | www.130057.com | www.8039w.com | www.844689.com | www.584499.com | www.257015.com | 34e35.com | tz478.com | vip4553.com | hhh8827.com | www.hg518.com | www.hg474.com | www.f72.com | www.bwinyz45.com | www.683909.com | www.ycp4.com | www.73166a.com | pj677r.com | 350833.com | vip31447.com | www.3311sb.com | www.xg536.com | www.9737uu.com | www.xcw988.com | www.228128.com | www.zfcp4.com | www.033708.com | www.27363h.com | www.i94600.com | www.88266m.com | www.612212.com | 5647q.com | xpj677m.com | 463393.com | www.309999.com | www.5055msc.com | www.hg6668.la | www.4323z.com | www.529081.com | zunyi803.com | 9339999f.com | www.4938x.com | www.55545n.com | www.997746.com | www.665478.com | 915610.com | 3650711.com | www.vns62999.com | www.90665.com | www.6889783.com | www.810706.com | 5622r.com | 51133ccc.com | www.yh8213.com | www.l5504.com | www.xy52.com | www.593477.com | 1634c.com | dazhuangjia.com | www.5968j.com | www.78680p.com | www.3416u.com | 5005i.com | 56400.com | www.4972rr.com | www.csh365.com | www.hg27388.com | www.136031.com | 97799mcom | www.hg1528.com | www.feng01.com | www.33997r.com | js111js.com | hg886.com | www.13789g.com | www.60886k.com | www.758786.com | 5003xx.com | 6766.net | www.555030a.com | 505503.com | www.hg8445.com | www.4988.hk | www.80075o.com | 7599gg.com | www.msc08.com | www.ls22.vip | www.26299k.com | 8722iiii.com | feicai0979.com | www.938i.cc | www.3933g.cc | vvv444000.com | 44488s.com | www.wt5222.com | www.ybao7.com | 4066zz.com | www.1869m.com | www.55070v.com | www.6832x.com | 7742vv.com | 256777w.com | www.206037.com | www.21czj.com | 2287dd.com | www.xpj0880.com | www.u80288.com | www.ck09.com | 7893w2.com | www.5511sb.com | www.68993255.com | 228888v.com | 65005k.com | www.19yh5.com | www.791317.com | 01234t.com | www.4052i.com | www.771478.com | 1634q.com | www.6033l.com | www.C6371.COM | www.701547.com | youleseo.com | www.slr000.com | www.6653j.com | tt6821.com | 59964vv.com | www.9997028.com | www.106572.com | spj80.net | www.009289.com | www.281566.com | 36407744.com | www.778879.com | www.fo64.com | 36405544.com | www.sb005.com | www.qm26.com | 2214k.com | www.56655c.com | www.739233.com | bet99339.com | www.rcw058.com | www.502433.com | 53262s.com | www.sun7789.com | www.671075.com | 25288o.com | www.58665j.com | www.342977.com | 8381005.com | www.http://09991.com | 1294o.cc | www.tyc8808.com | www.xb88.com | 55.net | www.tm3721.com | www.c143.vip | js57666.com | www.b35jj.com | 31325b.com | www.1118xj.com | www.0601s.com | 21289455.com | www.575001.com | www.668742.com | 8547g.com | www.vnsr938.com | 1679n.com | www.8494u.com | www.ykylc02.com | 3778rr.com | www.3589111.com | www.570133.com | 3202x.com | www.5856886.com | 972t.com | www.50000.com | www.39500u.com | www.hg05567.com | www.77803m.com | 57157u.com | www.9737ww.com | 38345s.com | www.xpj2886.com | www.858399.com | 2373x.com | www.6033888.com | hg345.com | www.4136e.com | 88552007.com | www.189555.com | www.544096.com | 7893w40.com | www.50080p.com | www.178763.com | www.81233y.com | 477106.net | www.bwin940.co | 2546b.com | www.709msc.com | www.65707v.com | www.zzzz0261.com | www.801876.com | 97799c.com | www.d17848.com | 8159pp.cc | www.wns123f.com | yqw998.com | www.7415rr.com | xpjbk3.com | www.129786.com | dzj.org | www.hg3373.com | www.874966.com | 6137s.net | www.3126a.com | 2546i.com | www.00840z.com | 123456aa.cc | www.81520c.com | df8g.com | www.99788b.com | 56787xx.com | www.pujing75.com | wb399.com | www.t639.com | 20772222.com | www.68568n.com | 3122oo.com | www.50054n.com | 0080h.com | www.9928f.com | ff555p.com | www.99clf.com | qq5144.com | www.33588d.com | 118184.com | www.qucp7.com | www.56733o.com | www.865850.com | www.70000.com | www.314213.com | www.z0151.com | 18775j.com | www.89055.com | 15g1.net | www.xpj668.com | 97570c.com | www.gx58qp.com | 2148888.net | www.26878c.com | qq88688.com | www.745557.com | www.1018111.com | 88904141.com | www.93036511.com | n888101.com | www.yl61332.com | bt1088.com | www.7782s.com | www.6491w.com | www.177949.com | www.7424.com | 54241177.com | www.89599g.com | 8159p.cc | www.55228j.com | www.jsjsjs59567.com | www.394689.com | www.52564.com | 1116076.com | www.07679p.com | bt1088.com | www.qmkl3.com | www.58777e.com | 668.bz | www.1429c1.com | xinhao3559.com | www.3890o.com | www.56520n.com | hsh88.com | www.sha2288.com | 53358n.com | www.du126.com | www.32666h.com | 56988.cc | www.bwinyz14.com | tt1030.com | www.aa8618.com | www.216yh.com | www.61233x.com | www.20909l.com | b47479.com | www.45598t.com | ylzz2220.com | www.698300.com | www.2010889.com | nce7998.com | www.77801x.com | www.vns0708.com | 44077a.com | www.38775vv.com | 500000757.com | www.235187.com | www.yk222b.com | 32126r.net | www.890413.com | www.mailebi.com | 4270qq.com | www.yun870.com | www.xhtd02.com | 67888z.cc | www.984701.com | www.6000bjl.com | 95gamevip6.com | www.2997709.com | 77335156.com | pj111177.com | www.flb903.com | x86.com | www.36166v.com | www.bet63h.com | 2247zz.com | www.126509.com | www.1851138.com | pj12234.com | 4195uu.com | www.79095f.com | 365vip07.win | qg162.com | www.bet3651688.com | www.2880880.com | 9737aa.me | www.60108x.com | www.20180077.com | rb431.com | www.900845.com | www.5504z.com | 2247000.com | 97297l.com | www.22mgm777.com | 908080l.com | 7584999.com | www.ya2019s.com | www.098842.com | 7893w15.com | www.809572.com | www.88166k.com | 3438w.com | 66300vip11.com | www.525409.com | www.0659ks.com | 3467v.cc | www.196072.com | www.20000.cc | www.n32126.cc | 6177006.com | www.df79.com | www.60hga.com | 444789.com | 58222x.com | www.3552i.com | www.35252o.com | 2019c.cc | 0080c.com | www.918ar.com | www.dyjtaiwan.com | 2844a.com | 56787rr.com | www.2350u.com | www.58665q.com | 5004dd.com | cp088h.com | www.938901.com | www.cn365w.com | www.617707.com | v939.com | www.309877.com | www.77201.com | www.jnh663.com | 8522oooo.com | 63305z.com | www.9205c.com | www.55545o.com | www.d0709.com | 55811.com | www.314377.com | www.1466w.com | www.xpj180.com | xldwh.com | JS1388v.com | www.pkfc8.com | www.4058qq.com | www.dh70507.com | 4995t.com | 365102c.com | www.16878j.com | www.80969c.com | www.1019997.com | xpj66112.com | 2934u.com | www.2632k.com | www.bet63i.com | www.58777j.com | 05168722.com | 01572.com | www.645977.com | www.9971001.com | www.jin188.com | hggjtg6.com | 8722kkkk.com | 33778016.com | www.lu126.com | www.60886m.com | www.749888.com | 3641.com | 7508j.com | drcp555.com | www.ya350.com | www.r999994.com | www.888wa.com | www.yl9819.com | 6487qqq.com | 56988pp.com | www.644680.com | www.0601e.com | www.c7201.com | www.2846f.com | 6572s.com | 1489m.com | 630.cc | www.810525.com | www.22274.vip | www.5446zz.com | www.xpj98k.com | 2190l.com | yumingty5.com | 1294m.com | www.501207.com | www.41518l.com | www.5719a.com | www.996sun.com | www.8658822.com | feicai0719.com | dzj0707.com | 4647033.com | www.450568.com | www.54591.com | www.xpj71333.com | www.58509.com | www.36677e.com | dh4546.com | 6150k.com | 997799.net | 659pj.com | www.339208.com | www.918li.com | www.4331b.com | www.80188j.com | www.cntwsm.com | www.xh7738.com | 1654gg.com | 11mm8332.com | bwin8u.com | 55797x.com | js848.vip | www.638262.com | www.3478v.cc | www.1213688.com | www.62979g.com | www.rycp154.com | www.88hm.com | www.87680w.com | 55984t.com | 500000518.com | so777.cc | 0332h.com | 3616q.com | k1.z6528.com | 118888j.com | www.550346.com | www.c5638.com | www.50026t.com | www.37377j.com | www.33678mm.com | www.28000j.com | www.c53889.com | www.hqr77.com | www.55268kk.com | www.md005.com | P35jj.com | 500000437.com | 678210.com | 6002p.com | 1331n.com | 31325a.com | 0805n.com | 84494477.com | www.156689.com | www.530961.com | www.854766.com | www.00tdc.com | www.66095.cc | www.39500m.com | www.a773776.com | www.db373.com | www.707213.com | www.vnsr2345.com | www.b83377.com | www.xpj558888.com | www.340dh.com | www.3157t.com | www.caipiao88.com | www.56655l.com | www.hv588.com | www.10444.com | www.suncity888.com | www.1828338.com | www.29019.com | www.dzvip9.com | www.8806132.com | www.129u.com | www.597449.com | www.8825666.com | www.110476.com | www.xpj230.com | www.38238d.com | www.twcp05.com | www.klcp009.com | www.28000z.com | www.bwinyz17.com | www.1754r.com | www.pjc44.vip | www.46876.com | www.h6610.com | www.954321m.com | www.3978h.com | www.26878x.com | www.600hc.com | www.cb2588.com | www.684335.com | www.335324.com | www.77803o.com | mgm3242g.com | 4323y.com | hhh01234.com | 3y5511.com | 40033hhh.com | 8kk.co | 667766d.com | www.ylg292.com | www.h7788d.com | www.1138js.com | www.hg8236.com | www.wct555.com | www.420082.com | www.12345604.cc | www.sx1844.com | www.15355x.com | www.c6129.com | www.505170.com | 56987jj.com | 33115p.com | 888991166.com | 36407755.com | 0245u.com | www.22264400.com | www.7025d.com | www.60sun.com | www.9966.so | www.69989f.com | www.9422.com | www.15256.cc | www.689066.com | mtime.com | 75991b.com | hg345.com | 1679c.com | www.7435x.com | www.20550577.com | www.c53889.com | www.p1432.com | www.4331e.com | www.lu126.com | www.267051.com | 2381006.com | 759hd.com | e7742.com | www.hg2877.org | www.49559.com | www.28000r.com | www.9996qq.com | www.33ckb.com | www.063766.com | 89777v.com | 8159e.cc | 90307y.com | www.999e888.com | www.hg1044.com | www.81608z.com | www.bai84.com | 5310.com | 4136e.com | 3636888.com | 500000555.com | www.pj7991.com | www.58118b.com | www.ampj3439.com | www.901180.com | 68228m.com | p62365.com | h4455g.com | www.606881.com | www.mgm868002.com | www.83033j.com | www.422626.com | 86811a.com | 35442999.com | www.4763000.vip | www.452msc.com | www.1558666.com | www.912183.com | 998a.cc | 8037rrr.com | www.xhtd08.com | www.g9478.com | www.68993231.com | www.628867.com | lego.vip | 4647dh.com | www.v456456.com | www.bwinyz40.com | www.99849.cc | 00hh8331.com | eee5701.com | www.0111js.com | www.88ff88.com | www.68993238.com | www.rcw8899.com | 66648z.com | 1109758.com | www.xb0027.com | www.63606l.com | www.998924.com | 4997g.com | xx7742.com | www.53516u.com | www.8700666.com | www.cb2988.com | yd91.com | w35151.com | www.vns7312.com | www.833bbb.com | www.608115.com | 38648ee.cc | 1705z.com | www.qmc0099.com | www.0270m.com | 66300vip48.com | w3410.com | www.00618v.com | www.158024.com | www.924177.com | 1770m.com | 3544e.com | www.44c.com | www.36788n.com | 5003ll.com | 73055g.com | www.778849.com | www.ampj3438.com | 0033d.cc | 2490w.com | www.65833.com | www.0270v.com | p2894.com | 6764999.com | www.973678.com | www.80065m.com | 658089.com | yy3189.com | www.dzcp7777.com | www.3668r.com | feicai0311.com | 124058.com | www.610160.COM | www.26czj.com | 18775i.com | www.pj90666.com | www.cn365o.com | www.755705.com | 91333.com | www.77cmsc.net | www.4809q.com | www.33997o.com | b21148.com | www.xz1088.com | www.88266w.com | hg2808dd.com | cbw15.com | www.38138z.com | www.560161.com | 3482y.com | www.901008.com | www.07163e.com | o2146.com | n07958.net | www.91779t.com | www.335324.com | 45637m.com | www.497789.com | www.3005u.com | 3467z.cc | www.362811.com | www.004549.com | 256777d.com | www.3435x.com | www.w84g.com | 97297r.com | 500000579.com | www.0169c.com | www.460689.com | 6261520.com | www.lfcp097.com | www.986656.com | x15666.com | www.k555555.com | www.022ln.cc | 444000.com | www.33455b.com | www.9155h.cc | 553322VV.com | www.5254y.com | www.50080y.com | 5099gg.com | www.90486.com | www.5095b.com | 30177755.com | www.86939.com | www.79gcw.com | 31553a.com | www.k3374.com | www.863012.com | d2146.com | www.yk222c.com | www.303853.com | pj08444.com | www.556255.com | man476.com | www.tyc9907.com | www.x77789.com | 820vv.com | www.1504.com | www.42969.com | 0343k.com | www.5559961.com | www.393121.com | 2649uu.com | www.js89m.vip | 1294m.com | www.0011152.com | www.8039i.com | s14666.com | www.dggcp100.com | www.djcp002.com | yk105.com | www.jl58qp.com | cp088t.com | www.hg7754.com | www.743966.com | 70118b.com | www.1022777.com | s83377.com | www.320288.com | www.937065.com | g72227.com | www.js89d.vip | x33x.vip | www.pj43.com | www.529121.com | 2613y.com | www.87480.com | qjdating.com | www.222bet365.cc | www.117015.com | www.88hggj.com | www.55228d.com | 9068r.com | www.3983116.com | 6245w.com | www.511111.com | www.560693.com | 22661381.com | www.87668t.com | 3950u.com | www.4996jq.com | js14x.com | www.js06888.com | www.313055.com | www.0882389.com | www.15355l.com | 2334vip7.com | www.7920j.com | 5309p.com | www.80969u.com | 3807ff.com | www.hg8477.com | www.109307.com | www.hg001111.com | www.hj8987.com | 4023e.com | www.whh4488.com | 2214rr.com | www.ba503.com | 2381ppp.com | www.4078p.com | 500000436.com | www.xinpujingcaipiao.com |