excel汉字转全拼音宏程序代码解析.docx

excel汉字转全拼音宏程序代码解析.docx

《excel汉字转全拼音宏程序代码解析.docx》由会员分享，可在线阅读，更多相关《excel汉字转全拼音宏程序代码解析.docx（30页珍藏版）》请在冰豆网上搜索。

excel汉字转全拼音宏程序代码解析

PublicPY_DB（1To72,1To94）AsString

PublicPY_Index（）AsInteger

SubDealVal_1（）

DimiAsInteger,jAsInteger

DimDbAsVariant

DimPYDB（72）AsString

PYDB（0）

"-2050,-2306,-2562,-2818,-3074,-3330,-3586,-3842,-4098,-4354,-4610,-4866,-5122,-5378,-5634,-5890,-6146,-6402,-6658,-6914,-7170,-7426,-7682,-7938,-8194,-8450,-8706,-8962,-9218,-9474,-9730,-9986,-10247,-10498,-10754,-11010,-11266,-11522,-11778,-12034,-12290,-12546,-12802,-13058,-13314,-13570,-13826,-14082,-14338,-14594,-14850,-15106,-15362,-15618,-15874,-16130,-16386,-16642,-16898,-17154,-17410,-17666,-17922,-18178,-18434,-18690,-18946,-19202,-19458,-19714,-19970,-20226,"

PYDB

（1）

"zha1,han1,qiu2,xi1,yan3,wu2,you4,fen2,an4,can3,qing2,li2,du2,qu1,yi1,xia2,you3,chu4,dai4,lin2,she4,ao2,qi2,mi2,zhu3,Jun1,ji3,mi2,hui1,me5,lie4,huan2,bin4,jiu1,quan2,xiu1,zi1,ji4,tiao2,ran2,mao2,kun1,biao1,yong1,tao1,tie4,yan4,xiang3,chi1,wang3,xiao1,liang3,yan3,ba2,mei4,du2,bin4,kuan1,qia4,lou2,bi4,ke1,ge2,hou2,di3,gu3,ku1,tou2,jie4,bei4,gou1,rou2,ju1,jian1,man2,qiao2,da2,yang1,da2,li3,zun1,shan4,gui4,yong1,min3,man2,xue3,biao4,le4,yao2,guan1,ta3,qi2,ao2,"PYDB

（2）

"sao1,bian1,huang2,fu4,qiu1,e4,die2,fen4,zi1,shi1,diao1,nian2,ni2,gu4,chang1,kun1,fei1,zou1,ling

2,qing1,ji4,huan4,sha1,gun3,tiao2,shi2,jian1,lian2,li2,geng3,xun2,xiang3,jiao1,ji4,er2,wei3,jie2,gui1,tai2,hou4,fu4,su1,lu2,nian2,ping2,ba4,fang2,you2,xin1,bei4,liu2,ao4,mou2,zan4,wu4,luan2,qiong2,chou2,qu2,luo4,ju1,Jun4,sun3,zhui1,tuo2,yuan2,mian3,wo4,chuo4,yu3,yin2,zi1,tiao2,bao1,ju

3,chen4,mai2,xian4,ai3,yin2,sha4,fei1,pei4,ji4,ting2,wen2,li4,yu2,liang4,qing3,zi1,zhi4,su4,gong1

II

J

PYDB（3）

"zi1,gu1,shang1,jue2,hu2,pi2,mo4,xiu1,mo4,diao1,zhi4,xie4,zuan1,lie4,chan2,lin4,zhu2,cu4,fan2,pu3,jue3,chu2,qi1,pan2,nie4,rou2,pian2,cuo1,duo2,ju3,zhong3,chuai4,die2,jian4,zhi2,bo2,dian3,zhi4,chi2,huai2,chuo1,ji4,liang2,jiao1,ji1,xian1,xian3,bi4,qiao1,kui3,tai2,bo3,jia1,tuo2,li4,shan1,fu

1,zhi2,qiang1,fu1,jian3,ta1,bo1,bie2,cu4,xue2,qiong2,dun3,cuo2,shi3,xun1,li3,ju4,xi1,jiao4,bu2,lao2,tang2,hai3,xu3,ti2,hu2,pei1,kun1,lei4,tu2,cheng2,shai1,yan4,zhi3,ming3,xian1,tuo2,zuo4,"PYDB（4）

"gu1,yi3,zhou4,gan1,ding3,chi3,jiang1,zhe3,nan3,zan3,zi1,lie4,ju1,jiu1,qu1,fu1,dao4,yao2,qi3,qi2,zhi2,jiao3,yi4,he2,pian1,jian3,fei3,zhu4,xi1,ling2,yi4,ji4,gen4,jiang4,qiu3,rou2,xu3,ci2,zan1,hou2,shen1,zong4,lin2,can4,zi1,xi1,tiao4,li4,ba1,mi3,xian1,xi1,tang1,jie2,suo1,qiang3,di1,bi4,sha1,qiu

2,jia1,niao3,qin1,meng2,chong1,cao2,shou3,meng3,wei3,shao1,xi1,ze2,zhu2,lu2,ge3,fang3,ban3,zhong1,bi3,yi3,shan1,chuan2,nv4,nie4,xi4,chong1,yu2,yu2,zhou4,lai4,bo3,deng1,zan1,dian4,"PYDB（5）

"gui3,duan4,lu4,dou1,mie4,su4,chi2,bi4,li4,fei3,gou1,hou2,huang2,kui4,zhen1,xiao1,yuan1,kong1,dan1,bi4,tuo4,qian2,ruo4,zhu4,qie4,ze2,qing4,xiao3,shao1,pa2,gang4,shi4,Jun1,zheng1,quan2,yan2,xian3,bi4,kou4,chi1,bian1,jia1,tiao2,si4,li4,gou3,ze2,sheng1,da2,po3,qiong2,hu4,zi3,zhao4,jian

3,ji1,du3,ji2,yu2,zhu2,shi4,xia4,qing4,ying1,fou3,qu2,du4,li2,mie4,lian2,chan2,meng3,huo4,shan

4,pan2,hui4,peng2,mao2,shuai4,zhang1,zhong1,xiang4,xi1,tang2,piao1,cao2,huang2,shi4,pang2,tang2,chi1,xi1,yuan2,ma2,"

PYDB（6）

"mang3,man3,ao2,qin2,mou2,bian1,you2,lou2,you2,yu2,sou1,fu4,ke1,kui2,fu2,nan3,rong2,chun1,meng3,lang2,wan1,quan2,tiao2,pi2,yi4,guo1,guo3,fei1,yu4,xi1,qi2,qing1,qiang1,fu2,chu2,li2,wu2,shao1,zhe1,shen4,mou2,yang2,jiao1,qi2,kuo4,ting2,qu1,si1,zhi4,nao2,jia2,qiong2,you4,cheng1,ling2,qiu1,zha4,ran2,you2,li4,ke1,gu1,han1,chi1,yin3,dou3,gong1,jie4,hao2,xian3,rui4,pi2,fu2,meng2,ge4,hui1,chai4,ji3,qiu2,qian2,hu3,pin2,ru2,hao4,sang3,man1,nie4,zhuan1,e4,han4,ke1,ying3,he2,jie2,"

PYDB（7）

"hang2,qi2,han1,tan2,ao2,kui4,guo1,ning2,ling2,dan1,ding1,die2,mo4,nou4,jiang3,lou2,ou3,tang1,lao4,huo1,si4,chao4,zi3,lei3,jin1,cun1,Jun1,xu1,ya3,pan4,ru2,qiang3,zhe3,chi3,lan2,bian3,lv3,baO3,bei4,da1,duo1,ju1,bi4,ti4,chu3,biao3,jian3,lian3,cheng2,lian2,ken4,ge1,jia2,dang1,pan4,mei4,jin1,ren4,na4,cha3,yi1,yu3,ju4,xun1,yu2,ke1,dou4,tiao3,yao3,bian3,zhun1,qiong2,xi1,song3,yi4,qu

2,dian1,pi3,dian4,yi4,lai4,ban1,chou1,yin3,long2,zhai4,ying3,luo3,biao1,huang2,ji2,ban1,mo4,chi

4,"

PYDB（8）

"sao4,jia3,lou4,chai4,hou2,yi4,la4,dan1,yu1,yu3,wei3,gu4,fei4,zhu2,sha1,xian2,cuo2,wu4,lao2,zhi4,yi2,ya3,jia1,xuan2,zhu4,pao4,zha4,da5,ke1,gan1,you2,li4,shan4,li4,jie1,ding1,bing4,guan4,lu4,hu4,yu4,jiu4,jiao1,liao2,liu4,zhe4,ying1,jian1,yao4,wu4,mei2,ci2,e4,hu2,chun2,bei1,an1,miao2,wu

3,ti2,xian2,yu4,hu2,li2,bo2,luan2,xiu1,gua1,zhi4,er2,si1,chi1,qu2,lu2,dong1,gu1,zhen4,bao3,yuan1,jiu1,yong3,hu4,die2,po2,xi1,hao4,jiao3,gui1,rang2,fu4,nian2,se4,ji4,zhen3,"

PYDB（9）

"ren3,ke1,lang2,fu1,ji1,lv3,shu2,mo4,zi3,bi3,zhi4,cuo2,shen3,zhong1,biao1,cha3,yi4,zhuo2,huo4,deng4,qiang1,cuan1,pu3,lan2,dui4,lu3,pu2,jue2,tan2,di2,xuan4,zu2,yong1,luo2,man4,tang2,biao1,bin1,jia1,yi4,liu2,na2,juan1,ge2,mo4,mei2,fei4,qiang1,lou4,ai1,huan2,sou1,cha1,e4,si1,kai3,qie4,zi1,tan2,juan3,pei2,huo1,gu4,kun1,ke4,de2,ben1,nuo4,qiang1,a1,ju1,qin3,lang2,jian3,kai1,liu3,lue4,cuo4,e2,gao4,li3,zeng4,keng1,te4,lai2,lao2,ru2,an3,tang1,chong4,se4,zheng1,yao2,sha1,"PYDB（10）

"ha1,quan2,hua2,diu1,ding4,zhu1,kai3,yin1,diao4,cheng1,ye2,nao2,jia2,cheng2,you3,er3,lao3,kao

4,duo2,pi2,ni2,bi4,ta1,xuan4,shi4,shuo4,dian4,tan3,mu4,yue4,bo2,bu1,po3,ke1,gu3,zheng1,yu4,ba3,huo3,tou3,kang4,fang1,qian2,ban3,ju4,tai4,bu4,nv3,chai1,men2,shan1,chuan4,tu3,liao3,zhao1,po1,yi3,ga2,jin1,juan1,guan4,he2,zeng1,ji1,li2,lan3,pi2,yan3,li4,gu3,gang1,fu2,tuan3,wan3,she1,zhen3,fan4,tian2,quan3,bi4,ding1,gu3,lin2,kan4,cheng1,piao3,ming2,ke1,mao4,kui2,sou3,rui4,pi4,sui1,"

PYDB（11）

"ni4,ya2,suo1,di4,jian3,lai4,mou2,chi1,zi4,sui1,yi2,yuan1,sheng3,dan1,miao3,dun3,kou1,mian3,xu1,fu3,fu2,zhi3,kan1,bo2,meng2,ca3,jiang1,deng4,dun1,qu2,qing4,sang3,gun3,zhe2,bian3,xuan4,di4,jie2,zhou2,chen3,ding4,bei4,dui4,qi4,wo4,ge4,nao2,dong4,zhai4,qiao1,xia2,mang2,xing2,fu2,tuo2,la2,di3,tong2,zha3,long2,li4,ai4,fa3,feng1,bian1,zhuo2,ya4,dun4,che1,hua1,dang4,gan1,ji1,miaO3,xue2,ta4,yu4,yu4,gang4,men4,mao4,dui4,qi4,te4,min3,qian1,que4,zi4,yang4,nin2,nv4,hui4,jia2,dui4,"

PYDB（12）

"tan3,te4,rang2,xi3,zhuo2,xi4,chan2,qi2,tiao1,zhen1,ci2,zhi1,mi2,zuo4,fu2,hu4,qu1,zhi3,xian1,si4,shi4,fei1,hu4,jiong1,hu4,li4,xi1,xu4,tao1,si4,cuan4,jue2,xian3,sui4,fan2,yu4,yi4,yun4,shang1,man4,liu1,tui4,bian1,xuan1,bao1,duan4,wei1,yu4,hu2,yan4,chao1,men4,han2,wu4,yang2,ye4,tai2,xuan4,zhu4,hu1,shi2,qiang4,dun4,wei3,yang2,yi3,liu2,ni3,jing1,zhan1,mao2,pei4,yu2,lan2,ji1,fei3,hu2,gu1,gou4,shu1,biao1,biao1,sou1,ju4,sa4,biao1,xi1,xin1,sha4,yi1,xi1,yu2,lin4,lian2,"PYDB（13）

"shan1,sao4,meng2,gu3,chuai4,zhi4,teng2,bin4,lv3,ge2,ying4,cheng2,shu4,e4,wa4,mian3,nan3,cou4,jian4,ding4,zong1,yu2,fei2,yan1,jing1,niao4,wan3,pao1,cuo3,luo2,tun2,mi3,zhen4,pian2,hai3,sa4,kuai4,yan1,dong4,guang1,jing4,zhi1,qu2,zhen1,gua1,zuo4,zhou4,shen4,jia3,lu2,ka3,dong4,long2,qian3,yao2,na4,zhun1,gong1,tai4,ruan3,jing3,huang1,rong2,wo4,yue4,guo2,yuan2,you3,die2,du2,jiao3,chi4,fan3,yun1,ke4,yin1,ya4,dong1,chuan1,xian1,dao1,pie1,qu2,pu3,lu5,chang3,shu1,san

1,jian4,cui4,mu2,mao4,bo4,ge2,"

PYDB（14）

"bai1,suo1,qie4,kao4,pian1,jian1,ju4,ji1,gu4,wu3,gu3,mao2,pin4,jiang4,jian4,qu4,jin4,gou4,yu2,di

2,xi2,ji4,chan1,fu4,dan3,ji1,qiu2,lai4,zhen4,jin4,gai1,zi1,zhi4,yi2,kuang4,shi4,ben1,nang3,xi1,yao

4,xun1,tun1,ming2,ai4,kui2,xuan1,gui3,han2,bu1,hui1,yan4,chao2,ye4,sheng4,qi2,ni4,chang3,yu4,mao3,zan3,he2,gui4,yun2,xin1,ze4,gao3,tan2,hao4,gan4,la2,ga1,po1,pi4,zeng4,beng4,bu4,ling2,ou1,zang1,jian3,gai4,deng3,kan1,ji2,ji3,jia2,qiang1,jian1,wei4,lin2,lu4,cou4,zi1,chuo4,"

PYDB（15）

"wang3,nian3,zhe2,lu4,quan2,zhi4,shi4,yao2,li4,hu1,zhen3,yi4,zhi3,lu2,ke1,gu1,e4,ren4,yi4,bin4,ji2,dan1,piao3,lian4,yun3,tian3,shang1,cu2,mo4,ao2,you2,cha2,bo4,lin3,yan2,lei2,yuan2,ju2,xi1,zun1,lu3,qin2,qiao2,jue2,tuo2,qing2,yue4,gan3,hu2,zhu1,tang2,chu1,qi4,qiang2,jin3,xie4,zhu1,rong2,bin1,shuo4,gao3,cui1,gao1,xie4,sun3,ta4,fei3,zhen1,ying2,mei2,xuan4,ju3,cha2,lv2,chen4,chui2,duan4,qiu1,ju3,pin3,ji2,lan3,lian4,zha1,nan2,zhen1,cou4,ju1,di4,jian4,guo3,liang2,chui2,luo2,"PYDB（16）

"zhao4,qian4,du2,fen2,chu3,ling2,suo1,zi3,jue2,fu2,gu4,fan4,xu3,an1,juan4,luan2,jie2,gui4,heng2,hua4,jiu4,gua1,ting3,qi1,guang1,zhen1,zhi4,rao2,ya1,lao3,kao3,cheng1,tuo2,li4,di3,gou3,ling2,zhi1,tuo4,zhi3,you4,xiao1,xia2,lu2,ping2,jiu4,long2,zhe4,zhi4,nai4,zhu4,pa2,fang1,xiao1,cong1,cheng2,chu3,jian3,rui4,yao3,miao3,pi2,li4,ma4,cha1,qi3,shao2,wu4,tao1,yun4,wei3,wen4,zan4,bi4,lu4,qu2,can4,pu2,zhang1,xuan2,cong1,cui3,ying1,huang2,jin3,tang2,ai4,nao3,xia2,yuan4,yu2,mao4,ju1,chen1,"

PYDB（17）

"wan3,cong2,yan3,kun1,hu3,qi2,ying1,qi2,lian3,hui1,xi3,luo4,yao2,heng2,ya2,xu1,gong3,er3,jia1,min2,po4,dai4,dian4,long2,ke1,jue2,min2,bin1,wei3,ji1,ding1,yong1,zai1,chuan1,ji1,yao1,zuan3,huan2,qiao1,qian3,jiang1,zeng1,liao2,xie2,sao1,miao4,lei2,man4,piao1,bin1,jian1,yi4,li2,gao3,ru4,zhen3,jin4,min2,zhui4,gou1,bian4,si1,hui4,miao3,ti2,xiang1,ke4,zi1,wan3,quan3,liu3,shou4,duo3,gun3,shang4,fei1,qi3,ling2,ti2,xiao1,geng3,jiang4,hang2,ku4,dai4,chu4,fu2,zhou4,fu2,xie4,gan4,shu1,pi1,yun2,"

PYDB（18）

"kuang4,wan2,ge1,zhou4,yu1,jiao3,xiang1,ji4,chan3,cong1,biao1,shan4,liu2,ao4,wu4,zhi4,can1,zhui1,ke4,qi2,li2,pian2,hua2,xiao1,dai4,nu2,yi4,zou1,fu4,si4,zang3,bao1,jue2,jie2,zi1,nu2,fu2,ga2,ga3,shuang1,mo2,niao3,bi4,shan4,xi1,zhang1,lei2