汉字转换为拼音,汉字转换拼音类

问题:EXCEL怎么样自动将人名转换为拼音?

 代码如下

汉字转换拼音类

 汉字转移为拼音
引用自:

回答:

function pinyin($_string, $_code=’utf-8′)
{
$_datakey =
“a|ai|an|ang|ao|ba|bai|ban|bang|bao|bei|ben|beng|bi|bian|biao|bie|bin|bing|bo|bu|ca|cai|can|cang|cao|ce|ceng|cha”.
“|chai|chan|chang|chao|che|chen|cheng|chi|chong|chou|chu|chuai|chuan|chuang|chui|chun|chuo|ci|cong|cou|cu|”.
“cuan|cui|cun|cuo|da|dai|dan|dang|dao|de|deng|di|dian|diao|die|ding|diu|dong|dou|du|duan|dui|dun|duo|e|en|er”.
“|fa|fan|fang|fei|fen|feng|fo|fou|fu|ga|gai|gan|gang|gao|ge|gei|gen|geng|gong|gou|gu|gua|guai|guan|guang|gui”.
“|gun|guo|ha|hai|han|hang|hao|he|hei|hen|heng|hong|hou|hu|hua|huai|huan|huang|hui|hun|huo|ji|jia|jian|jiang”.
“|jiao|jie|jin|jing|jiong|jiu|ju|juan|jue|jun|ka|kai|kan|kang|kao|ke|ken|keng|kong|kou|ku|kua|kuai|kuan|kuang”.
“|kui|kun|kuo|la|lai|lan|lang|lao|le|lei|leng|li|lia|lian|liang|liao|lie|lin|ling|liu|long|lou|lu|lv|luan|lue”.
“|lun|luo|ma|mai|man|mang|mao|me|mei|men|meng|mi|mian|miao|mie|min|ming|miu|mo|mou|mu|na|nai|nan|nang|nao|ne”.
汉字转换为拼音,汉字转换拼音类。”|nei|nen|neng|ni|nian|niang|niao|nie|nin|ning|niu|nong|nu|nv|nuan|nue|nuo|o|ou|pa|pai|pan|pang|pao|pei|pen”.
“|peng|pi|pian|piao|pie|pin|ping|po|pu|qi|qia|qian|qiang|qiao|qie|qin|qing|qiong|qiu|qu|quan|que|qun|ran|rang”.
“|rao|re|ren|reng|ri|rong|rou|ru|ruan|rui|run|ruo|sa|sai|san|sang|sao|se|sen|seng|sha|shai|shan|shang|shao|”.
“she|shen|sheng|shi|shou|shu|shua|shuai|shuan|shuang|shui|shun|shuo|si|song|sou|su|suan|sui|sun|suo|ta|tai|”.
“tan|tang|tao|te|teng|ti|tian|tiao|tie|ting|tong|tou|tu|tuan|tui|tun|tuo|wa|wai|wan|wang|wei|wen|weng|wo|wu”.
“|xi|xia|xian|xiang|xiao|xie|xin|xing|xiong|xiu|xu|xuan|xue|xun|ya|yan|yang|yao|ye|yi|yin|ying|yo|yong|you”.
“|yu|yuan|yue|yun|za|zai|zan|zang|zao|ze|zei|zen|zeng|zha|zhai|zhan|zhang|zhao|zhe|zhen|zheng|zhi|zhong|”.
“zhou|zhu|zhua|zhuai|zhuan|zhuang|zhui|zhun|zhuo|zi|zong|zou|zu|zuan|zui|zun|zuo”;

class cntopy {

  1图片 1图片 2    /**//// <summary>
  2图片 3    /// 将汉字转换到为拼音
  3图片 4    /// </summary>
  4图片 5    public class Chs2Py
  5图片 6图片 7    图片 8{
  6图片 9图片 10        private static int[] pyvalue = new int[]图片 11{ -20319,-20317,-20304,-20295,-20292,-20283,-20265,-20257,
  7图片 12            -20242,-20230,-20051,-20036,-20032,-20026,-20002,-19990,-19986,-19982,-19976,-19805,-19784,
  8图片 13            -19775,-19774,-19763,-19756,-19751,-19746,-19741,-19739,-19728, -19725,-19715,-19540,-19531,
  9图片 14            -19525,-19515,-19500,-19484,-19479,-19467,-19289,-19288,-19281,-19275,-19270,-19263, -19261,
 10图片 15            -19249,-19243,-19242,-19238,-19235,-19227,-19224,-19218,-19212,-19038,-19023,-19018,-19006,
 11图片 16            -19003,-18996,-18977,-18961,-18952,-18783,-18774,-18773,-18763,-18756,-18741,-18735,-18731,
 12图片 17            -18722,-18710,-18697,-18696,-18526, -18518,-18501,-18490,-18478,-18463,-18448,-18447,-18446,
 13图片 18            -18239,-18237,-18231,-18220,-18211,-18201,-18184,-18183,-18181,-18012,-17997,-17988,-17970,
 14图片 19            -17964,-17961,-17950,-17947,-17931,-17928,-17922,-17759,-17752,-17733,-17730,-17721,-17703,
 15图片 20            -17701,-17697,-17692,-17683,-17676,-17496,-17487,-17482,-17468,-17454,-17433,-17427,-17417,
 16图片 21            -17202,-17185,-16983,-16970,-16942,-16915,-16733,-16708,-16706,-16689,-16664,-16657,-16647,
 17图片 22            -16474,-16470,-16465,-16459,-16452,-16448,-16433,-16429,-16427,-16423,-16419,-16412,-16407,
 18图片 23            -16403,-16401,-16393,-16220,-16216,-16212,-16205,-16202,-16187,-16180,-16171,-16169,-16158,
 19图片 24            -16155,-15959,-15958,-15944,-15933,-15920,-15915,-15903,-15889,-15878, -15707,-15701,-15681,
 20图片 25            -15667,-15661,-15659,-15652,-15640,-15631,-15625,-15454,-15448,-15436,-15435,-15419,-15416, 
 21图片 26            -15408,-15394,-15385,-15377,-15375,-15369,-15363,-15362,-15183,-15180,-15165,-15158,-15153,
 22图片 27            -15150,-15149,-15144, -15143,-15141,-15140,-15139,-15128,-15121,-15119,-15117,-15110,-15109,
 23图片 28            -14941,-14937,-14933,-14930,-14929,-14928,-14926,-14922,-14921,-14914,-14908,-14902,-14894,
 24图片 29            -14889,-14882,-14873,-14871,-14857,-14678,-14674,-14670,-14668, -14663,-14654,-14645,-14630,
 25图片 30            -14594,-14429,-14407,-14399,-14384,-14379,-14368,-14355,-14353,-14345,-14170,-14159,-14151,
 26图片 31            -14149,-14145,-14140,-14137,-14135,-14125,-14123,-14122,-14112,-14109,-14099,-14097,-14094,
 27图片 32            -14092,-14090, -14087,-14083,-13917,-13914,-13910,-13907,-13906,-13905,-13896,-13894,-13878,
 28图片 33            -13870,-13859,-13847,-13831,-13658,  -13611,-13601,-13406,-13404,-13400,-13398,-13395,-13391,
 29图片 34            -13387,-13383,-13367,-13359,-13356,-13343,-13340,-13329,-13326,-13318,-13147,-13138,-13120,
 30图片 35            -13107,-13096,-13095,-13091,-13076,-13068,-13063,-13060,-12888,-12875,-12871,-12860,-12858,
 31图片 36            -12852,-12849,-12838,-12831,-12829,-12812,-12802,-12607,-12597,-12594,-12585,-12556,-12359,
 32图片 37            -12346, -12320,-12300,-12120,-12099,-12089,-12074,-12067,-12058,-12039,-11867,-11861,-11847,
 33图片 38            -11831,-11798,-11781,-11604,-11589,-11536,-11358,-11340,-11339,-11324,-11303,-11097,-11077,
 34图片 39            -11067,-11055,-11052,-11045,-11041,-11038,-11024,-11020,-11019,-11018,-11014,-10838,-10832,
 35图片 40            -10815,-10800,-10790,-10780,-10764,-10587,-10544,-10533,-10519,-10331, -10329,-10328,-10322,
 36图片 41            -10315,-10309,-10307,-10296,-10281,-10274,-10270,-10262,-10260,-10256,-10254};
 37图片 42图片 43        private static string[] pystr = new string[]图片 44{“a”,”ai”,”an”,”ang”,”ao”,”ba”,”bai”,”ban”,”bang”,”bao”,”bei”,”ben”,”beng”,”bi”,”bian”,”biao”,”bie”,”bin”,”bing”,”bo”,”bu”,”ca”,”cai”,”can”,”cang”,”cao”,”ce”,”ceng”,”cha”,”chai”,”chan”,”chang”,”chao”,”che”,”chen”,”cheng”,”chi”,”chong”,”chou”,”chu”,”chuai”,”chuan”,”chuang”,”chui”,”chun”,”chuo”,”ci”,”cong”,”cou”,”cu”,”cuan”,”cui”,”cun”,”cuo”,”da”,”dai”,”dan”,”dang”,”dao”,”de”,”deng”,”di”,”dian”,”diao”,”die”,”ding”,”diu”,”dong”,”dou”,”du”,”duan”,”dui”,”dun”,”duo”,”e”,”en”,”er”,”fa”,”fan”,”fang”,”fei”,”fen”,”feng”,”fo”,”fou”,”fu”,”ga”,”gai”,”gan”,”gang”,”gao”,”ge”,”gei”,”gen”,”geng”,”gong”,”gou”,”gu”,”gua”,”guai”,”guan”,”guang”,”gui”,”gun”,”guo”,”ha”,”hai”,”han”,”hang”, “hao”,”he”,”hei”,”hen”,”heng”,”hong”,”hou”,”hu”,”hua”,”huai”,”huan”,”huang”,”hui”,”hun”,”huo”,”ji”,”jia”,”jian”,”jiang”,”jiao”,”jie”,”jin”,”jing”,”jiong”,”jiu”,”ju”,”juan”,”jue”,”jun”,”ka”,”kai”,”kan”,”kang”,”kao”,”ke”,”ken”,”keng”,”kong”,”kou”,”ku”,”kua”,”kuai”,”kuan”,”kuang”,”kui”,”kun”,”kuo”,”la”,”lai”,”lan”,”lang”,”lao”,”le”,”lei”,”leng”,”li”,”lia”,”lian”,”liang”,”liao”,”lie”,”lin”,”ling”,”liu”,”long”,”lou”,”lu”,”lv”,”luan”,”lue”,”lun”,”luo”,”ma”,”mai”,”man”,”mang”,”mao”,”me”,”mei”,”men”,”meng”,”mi”,”mian”,”miao”,”mie”,”min”,”ming”,”miu”,”mo”,”mou”,”mu”,  “na”,”nai”,”nan”,”nang”,”nao”,”ne”,”nei”,”nen”,”neng”,”ni”,”nian”,”niang”,”niao”,”nie”,”nin”,”ning”,”niu”,”nong”, “nu”,”nv”,”nuan”,”nue”,”nuo”,”o”,”ou”,”pa”,”pai”,”pan”,”pang”,”pao”,”pei”,”pen”,”peng”,”pi”,”pian”,”piao”,”pie”, “pin”,”ping”,”po”,”pu”,”qi”,”qia”,”qian”,”qiang”,”qiao”,”qie”,”qin”,”qing”,”qiong”,”qiu”,”qu”,”quan”,”que”,”qun”, “ran”,”rang”,”rao”,”re”,”ren”,”reng”,”ri”,”rong”,”rou”,”ru”,”ruan”,”rui”,”run”,”ruo”,”sa”,”sai”,”san”,”sang”,”sao”,”se”,”sen”,”seng”,”sha”,”shai”,”shan”,”shang”,”shao”,”she”,”shen”,”sheng”,”shi”,”shou”,”shu”,”shua”,”shuai”,”shuan”,”shuang”,”shui”,”shun”,”shuo”,”si”,”song”,”sou”,”su”,”suan”,”sui”,”sun”,”suo”,”ta”,”tai”,”tan”,”tang”,”tao”,”te”,”teng”,”ti”,”tian”,”tiao”,”tie”,”ting”,”tong”,”tou”,”tu”,”tuan”,”tui”,”tun”,”tuo”,”wa”,”wai”,”wan”,”wang”,”wei”,”wen”,”weng”,”wo”,”wu”,”xi”,”xia”,”xian”,”xiang”,”xiao”,”xie”,”xin”,”xing”,”xiong”,”xiu”,”xu”,”xuan”,”xue”,”xun”,”ya”,”yan”,”yang”,”yao”,”ye”,”yi”,”yin”,”ying”,”yo”,”yong”,”you”, “yu”,”yuan”,”yue”,”yun”,”za”,”zai”,”zan”,”zang”,”zao”,”ze”,”zei”,”zen”,”zeng”,”zha”,”zhai”,”zhan”,”zhang”, “zhao”,”zhe”,”zhen”,”zheng”,”zhi”,”zhong”,”zhou”,”zhu”,”zhua”,”zhuai”,”zhuan”,”zhuang”,”zhui”,”zhun”,”zhuo”, “zi”,”zong”,”zou”,”zu”,”zuan”,”zui”,”zun”,”zuo”};
 38图片 45
 39图片 46图片 47        /**//// <summary>
 40图片 48        /// 构造函数
 41图片 49        /// </summary>
 42图片 50        public Chs2Py()
 43图片 51图片 52        图片 53{           
 44图片 54        }
 45图片 55
 46图片 56图片 57        /**//// <summary>
 47图片 58        /// 静态转换方法 获得输入汉字字符串的对应拼音
 48图片 59        /// </summary>
 49图片 60        /// <param name=”chrstr”>汉字字符串</param>
 50图片 61        /// <returns>再次来到对应的拼音</returns>
 51图片 62        public static string Convert(string chrstr)
 52图片 63图片 64        图片 65{
 53图片 66            byte[] byteArray = new byte[2];
 54图片 67            string returnStr = “”;
 55图片 68            int chrAsc = 0;
 56图片 69            int i1 = 0;
 57图片 70            int i2 = 0;
 58图片 71            char[] nowChar = chrstr.ToCharArray();
 59图片 72            for (int j = 0; j < nowChar.Length; j++)
 60图片 73图片 74            图片 75{
 61图片 76                byteArray = Encoding.Default.GetBytes(nowChar[j].ToString());
 62图片 77                i1 = (short)byteArray[0];
 63图片 78                i2 = (short)byteArray[1];
 64图片 79                chrAsc = i1 * 256 + i2 – 65536;
 65图片 80                if (chrAsc > 0 && chrAsc < 160)
 66图片 81图片 82                图片 83{
 67图片 84                    returnStr += nowChar[j];
 68图片 85                }
 69图片 86                else
 70图片 87图片 88                图片 89{
 71图片 90                    for (int i = (pyvalue.Length – 1); i >= 0; i–)
 72图片 91图片 92                    图片 93{
 73图片 94                        if (pyvalue[i] <= chrAsc)
 74图片 95图片 96                        图片 97{
 75图片 98                            returnStr += pystr[i];
 76图片 99                            break;
 77图片 100                        }
 78图片 101                    }
 79图片 102                }
 80图片 103            }
 81图片 104
 82图片 105            return returnStr;
 83图片 106        }
 84图片 107
 85图片 108图片 109        /**//// <summary>
 86图片 110        /// 得到汉字拼音缩写
 87图片 111        /// </summary>
 88图片 112        /// <param name=”str”>汉字字符串</param>
 89图片 113        /// <returns>重返汉字字符串的的拼音缩写</returns>
 90图片 114        public string GetPYString(string str)
 91图片 115图片 116        图片 117{
 92图片 118            string tempStr = “”;
 93图片 119            foreach (char c in str)
 94图片 120图片 121            图片 122{
 95图片 123                if ((int)c >= 33 && (int)c <= 126)
 96图片 124图片 125                图片 126{
 97图片 127                    //字母和符号原样保留
 98图片 128                    tempStr += c.ToString();
 99图片 129                }
100图片 130                else
101图片 131图片 132                图片 133{
102图片 134                    //累加拼音声母
103图片 135                    tempStr += GetPYChar(c.ToString());
104图片 136                }
105图片 137            }
106图片 138
107图片 139            return tempStr;
108图片 140        }
109图片 141
110图片 142图片 143        /**//// <summary>
111图片 144        /// 取单个字符的拼音字母
112图片 145        /// </summary>
113图片 146        /// <param name=”c”>汉字</param>
114图片 147        /// <returns>重回拼音字母</returns>
115图片 148        public string GetPYChar(string c)
116图片 149图片 150        图片 151{
117图片 152            byte[] byteArray = new byte[2];
118图片 153            byteArray = Encoding.Default.GetBytes(c);
119图片 154            int i = (short)(byteArray[0] – ‘\0’) * 256 + (short)(byteArray[1] – ‘\0’);
120图片 155
121图片 156            if (i < 0xB0A1) return “*”;
122图片 157            if (i < 0xB0C5) return “a”;
123图片 158            if (i < 0xB2C1) return “b”;
124图片 159            if (i < 0xB4EE) return “c”;
125图片 160            if (i < 0xB6EA) return “d”;
126图片 161            if (i < 0xB7A2) return “e”;
127图片 162            if (i < 0xB8C1) return “f”;
128图片 163            if (i < 0xB9FE) return “g”;
129图片 164            if (i < 0xBBF7) return “h”;
130图片 165            if (i < 0xBFA6) return “j”;
131图片 166            if (i < 0xC0AC) return “k”;
132图片 167            if (i < 0xC2E8) return “l”;
133图片 168            if (i < 0xC4C3) return “m”;
134图片 169            if (i < 0xC5B6) return “n”;
135图片 170            if (i < 0xC5BE) return “o”;
136图片 171            if (i < 0xC6DA) return “p”;
137图片 172            if (i < 0xC8BB) return “q”;
138图片 173            if (i < 0xC8F6) return “r”;
139图片 174            if (i < 0xCBFA) return “s”;
140图片 175            if (i < 0xCDDA) return “t”;
141图片 176            if (i < 0xCEF4) return “w”;
142图片 177            if (i < 0xD1B9) return “x”;
143图片 178            if (i < 0xD4D1) return “y”;
144图片 179            if (i < 0xD7FA) return “z”;
145图片 180
146图片 181            return “*”;   
147图片 182        }
148图片 183    }

多谢天涯论坛的特约,大家好,作者是Excel奇妙之旅,专注于Excel知识和技术的分享

$_datavalue =
“-20319|-20317|-20304|-20295|-20292|-20283|-20265|-20257|-20242|-20230|-20051|-20036|-20032|-20026|-20002|-19990”.
“|-19986|-19982|-19976|-19805|-19784|-19775|-19774|-19763|-19756|-19751|-19746|-19741|-19739|-19728|-19725”.
“|-19715|-19540|-19531|-19525|-19515|-19500|-19484|-19479|-19467|-19289|-19288|-19281|-19275|-19270|-19263”.
“|-19261|-19249|-19243|-19242|-19238|-19235|-19227|-19224|-19218|-19212|-19038|-19023|-19018|-19006|-19003”.
“|-18996|-18977|-18961|-18952|-18783|-18774|-18773|-18763|-18756|-18741|-18735|-18731|-18722|-18710|-18697”.
“|-18696|-18526|-18518|-18501|-18490|-18478|-18463|-18448|-18447|-18446|-18239|-18237|-18231|-18220|-18211”.
“|-18201|-18184|-18183|-18181|-18012|-17997|-17988|-17970|-17964|-17961|-17950|-17947|-17931|-17928|-17922”.
“|-17759|-17752|-17733|-17730|-17721|-17703|-17701|-17697|-17692|-17683|-17676|-17496|-17487|-17482|-17468”.
“|-17454|-17433|-17427|-17417|-17202|-17185|-16983|-16970|-16942|-16915|-16733|-16708|-16706|-16689|-16664”.
“|-16657|-16647|-16474|-16470|-16465|-16459|-16452|-16448|-16433|-16429|-16427|-16423|-16419|-16412|-16407”.
“|-16403|-16401|-16393|-16220|-16216|-16212|-16205|-16202|-16187|-16180|-16171|-16169|-16158|-16155|-15959”.
“|-15958|-15944|-15933|-15920|-15915|-15903|-15889|-15878|-15707|-15701|-15681|-15667|-15661|-15659|-15652”.
“|-15640|-15631|-15625|-15454|-15448|-15436|-15435|-15419|-15416|-15408|-15394|-15385|-15377|-15375|-15369”.
“|-15363|-15362|-15183|-15180|-15165|-15158|-15153|-15150|-15149|-15144|-15143|-15141|-15140|-15139|-15128”.
“|-15121|-15119|-15117|-15110|-15109|-14941|-14937|-14933|-14930|-14929|-14928|-14926|-14922|-14921|-14914”.
“|-14908|-14902|-14894|-14889|-14882|-14873|-14871|-14857|-14678|-14674|-14670|-14668|-14663|-14654|-14645”.
“|-14630|-14594|-14429|-14407|-14399|-14384|-14379|-14368|-14355|-14353|-14345|-14170|-14159|-14151|-14149”.
“|-14145|-14140|-14137|-14135|-14125|-14123|-14122|-14112|-14109|-14099|-14097|-14094|-14092|-14090|-14087”.
“|-14083|-13917|-13914|-13910|-13907|-13906|-13905|-13896|-13894|-13878|-13870|-13859|-13847|-13831|-13658”.
“|-13611|-13601|-13406|-13404|-13400|-13398|-13395|-13391|-13387|-13383|-13367|-13359|-13356|-13343|-13340”.
“|-13329|-13326|-13318|-13147|-13138|-13120|-13107|-13096|-13095|-13091|-13076|-13068|-13063|-13060|-12888”.
“|-12875|-12871|-12860|-12858|-12852|-12849|-12838|-12831|-12829|-12812|-12802|-12607|-12597|-12594|-12585”.
“|-12556|-12359|-12346|-12320|-12300|-12120|-12099|-12089|-12074|-12067|-12058|-12039|-11867|-11861|-11847”.
“|-11831|-11798|-11781|-11604|-11589|-11536|-11358|-11340|-11339|-11324|-11303|-11097|-11077|-11067|-11055”.
“|-11052|-11045|-11041|-11038|-11024|-11020|-11019|-11018|-11014|-10838|-10832|-10815|-10800|-10790|-10780”.
“|-10764|-10587|-10544|-10533|-10519|-10331|-10329|-10328|-10322|-10315|-10309|-10307|-10296|-10281|-10274”.
“|-10270|-10262|-10260|-10256|-10254”;
$_tdatakey = explode(‘|’, $_datakey);
$_tdatavalue = explode(‘|’, $_datavalue);

 /**
  * @var array $chineseSpellList 拼音编码对应表
  * @access private
  */
 private $chineseSpellList = array(
    ‘a’=>-20319,
    ‘ai’=>-20317,
    ‘an’=>-20304,
    ‘ang’=>-20295,
    ‘ao’=>-20292,
    ‘ba’=>-20283,
    ‘bai’=>-20265,
    ‘ban’=>-20257,
    ‘bang’=>-20242,
    ‘bao’=>-20230,
    ‘bei’=>-20051,
    ‘ben’=>-20036,
    ‘beng’=>-20032,
    ‘bi’=>-20026,
    ‘bian’=>-20002,
    ‘biao’=>-19990,
    ‘bie’=>-19986,
    ‘bin’=>-19982,
    ‘bing’=>-19976,
    ‘bo’=>-19805,
    ‘bu’=>-19784,
    ‘ca’=>-19775,
    ‘cai’=>-19774,
    ‘can’=>-19763,
    ‘cang’=>-19756,
    ‘cao’=>-19751,
    ‘ce’=>-19746,
    ‘ceng’=>-19741,
    ‘cha’=>-19739,
    ‘chai’=>-19728,
    ‘chan’=>-19725,
    ‘chang’=>-19715,
    ‘chao’=>-19540,
    ‘che’=>-19531,
    ‘chen’=>-19525,
    ‘cheng’=>-19515,
    ‘chi’=>-19500,
    ‘chong’=>-19484,
    ‘chou’=>-19479,
    ‘chu’=>-19467,
    ‘chuai’=>-19289,
    ‘chuan’=>-19288,
    ‘chuang’=>-19281,
    ‘chui’=>-19275,
    ‘chun’=>-19270,
    ‘chuo’=>-19263,
    ‘ci’=>-19261,
    ‘cong’=>-19249,
    ‘cou’=>-19243,
    ‘cu’=>-19242,
    ‘cuan’=>-19238,
    ‘cui’=>-19235,
    ‘cun’=>-19227,
    ‘cuo’=>-19224,
    ‘da’=>-19218,
    ‘dai’=>-19212,
    ‘dan’=>-19038,
    ‘dang’=>-19023,
    ‘dao’=>-19018,
    ‘de’=>-19006,
    ‘deng’=>-19003,
    ‘di’=>-18996,
    ‘dian’=>-18977,
    ‘diao’=>-18961,
    ‘die’=>-18952,
    ‘ding’=>-18783,
    ‘diu’=>-18774,
    ‘dong’=>-18773,
    ‘dou’=>-18763,
    ‘du’=>-18756,
    ‘duan’=>-18741,
    ‘dui’=>-18735,
    ‘dun’=>-18731,
    ‘duo’=>-18722,
    ‘e’=>-18710,
    ‘en’=>-18697,
    ‘er’=>-18696,
    ‘fa’=>-18526,
    ‘fan’=>-18518,
    ‘fang’=>-18501,
    ‘fei’=>-18490,
    ‘fen’=>-18478,
    ‘feng’=>-18463,
    ‘fo’=>-18448,
    ‘fou’=>-18447,
    ‘fu’=>-18446,
    ‘ga’=>-18239,
    ‘gai’=>-18237,
    ‘gan’=>-18231,
    ‘gang’=>-18220,
    ‘gao’=>-18211,
    ‘ge’=>-18201,
    ‘gei’=>-18184,
    ‘gen’=>-18183,
    ‘geng’=>-18181,
    ‘gong’=>-18012,
    ‘gou’=>-17997,
    ‘gu’=>-17988,
    ‘gua’=>-17970,
    ‘guai’=>-17964,
    ‘guan’=>-17961,
    ‘guang’=>-17950,
    ‘gui’=>-17947,
    ‘gun’=>-17931,
    ‘guo’=>-17928,
    ‘ha’=>-17922,
    ‘hai’=>-17759,
    ‘han’=>-17752,
    ‘hang’=>-17733,
    ‘hao’=>-17730,
    ‘he’=>-17721,
    ‘hei’=>-17703,
    ‘hen’=>-17701,
    ‘heng’=>-17697,
    ‘hong’=>-17692,
    ‘hou’=>-17683,
    ‘hu’=>-17676,
    ‘hua’=>-17496,
    ‘huai’=>-17487,
    ‘huan’=>-17482,
    ‘huang’=>-17468,
    ‘hui’=>-17454,
    ‘hun’=>-17433,
    ‘huo’=>-17427,
    ‘ji’=>-17417,
    ‘jia’=>-17202,
    ‘jian’=>-17185,
    ‘jiang’=>-16983,
    ‘jiao’=>-16970,
    ‘jie’=>-16942,
    ‘jin’=>-16915,
    ‘jing’=>-16733,
    ‘jiong’=>-16708,
    ‘jiu’=>-16706,
    ‘ju’=>-16689,
    ‘juan’=>-16664,
    ‘jue’=>-16657,
    ‘jun’=>-16647,
    ‘ka’=>-16474,
    ‘kai’=>-16470,
    ‘kan’=>-16465,
    ‘kang’=>-16459,
    ‘kao’=>-16452,
    ‘ke’=>-16448,
    ‘ken’=>-16433,
    ‘keng’=>-16429,
    ‘kong’=>-16427,
    ‘kou’=>-16423,
    ‘ku’=>-16419,
    ‘kua’=>-16412,
    ‘kuai’=>-16407,
    ‘kuan’=>-16403,
    ‘kuang’=>-16401,
    ‘kui’=>-16393,
    ‘kun’=>-16220,
    ‘kuo’=>-16216,
    ‘la’=>-16212,
    ‘lai’=>-16205,
    ‘lan’=>-16202,
    ‘lang’=>-16187,
    ‘lao’=>-16180,
    ‘le’=>-16171,
    ‘lei’=>-16169,
    ‘leng’=>-16158,
    ‘li’=>-16155,
    ‘lia’=>-15959,
    ‘lian’=>-15958,
    ‘liang’=>-15944,
    ‘liao’=>-15933,
    ‘lie’=>-15920,
    ‘lin’=>-15915,
    ‘ling’=>-15903,
    ‘liu’=>-15889,
    ‘long’=>-15878,
    ‘lou’=>-15707,
    ‘lu’=>-15701,
    ‘lv’=>-15681,
    ‘luan’=>-15667,
    ‘lue’=>-15661,
    ‘lun’=>-15659,
    ‘luo’=>-15652,
    ‘ma’=>-15640,
    ‘mai’=>-15631,
    ‘man’=>-15625,
    ‘mang’=>-15454,
    ‘mao’=>-15448,
    ‘me’=>-15436,
    ‘mei’=>-15435,
    ‘men’=>-15419,
    ‘meng’=>-15416,
    ‘mi’=>-15408,
    ‘mian’=>-15394,
    ‘miao’=>-15385,
    ‘mie’=>-15377,
    ‘min’=>-15375,
    ‘ming’=>-15369,
    ‘miu’=>-15363,
    ‘mo’=>-15362,
    ‘mou’=>-15183,
    ‘mu’=>-15180,
    ‘na’=>-15165,
    ‘nai’=>-15158,
    ‘nan’=>-15153,
    ‘nang’=>-15150,
    ‘nao’=>-15149,
    ‘ne’=>-15144,
    ‘nei’=>-15143,
    ‘nen’=>-15141,
    ‘neng’=>-15140,
    ‘ni’=>-15139,
    ‘nian’=>-15128,
    ‘niang’=>-15121,
    ‘niao’=>-15119,
    ‘nie’=>-15117,
    ‘nin’=>-15110,
    ‘ning’=>-15109,
    ‘niu’=>-14941,
    ‘nong’=>-14937,
    ‘nu’=>-14933,
    ‘nv’=>-14930,
    ‘nuan’=>-14929,
    ‘nue’=>-14928,
    ‘nuo’=>-14926,
    ‘o’=>-14922,
    ‘ou’=>-14921,
    ‘pa’=>-14914,
    ‘pai’=>-14908,
    ‘pan’=>-14902,
    ‘pang’=>-14894,
    ‘pao’=>-14889,
    ‘pei’=>-14882,
    ‘pen’=>-14873,
    ‘peng’=>-14871,
    ‘pi’=>-14857,
    ‘pian’=>-14678,
    ‘piao’=>-14674,
    ‘pie’=>-14670,
    ‘pin’=>-14668,
    ‘ping’=>-14663,
    ‘po’=>-14654,
    ‘pu’=>-14645,
    ‘qi’=>-14630,
    ‘qia’=>-14594,
    ‘qian’=>-14429,
    ‘qiang’=>-14407,
    ‘qiao’=>-14399,
    ‘qie’=>-14384,
    ‘qin’=>-14379,
    ‘qing’=>-14368,
    ‘qiong’=>-14355,
    ‘qiu’=>-14353,
    ‘qu’=>-14345,
    ‘quan’=>-14170,
    ‘que’=>-14159,
    ‘qun’=>-14151,
    ‘ran’=>-14149,
    ‘rang’=>-14145,
    ‘rao’=>-14140,
    ‘re’=>-14137,
    ‘ren’=>-14135,
    ‘reng’=>-14125,
    ‘ri’=>-14123,
    ‘rong’=>-14122,
    ‘rou’=>-14112,
    ‘ru’=>-14109,
    ‘ruan’=>-14099,
    ‘rui’=>-14097,
    ‘run’=>-14094,
    ‘ruo’=>-14092,
    ‘sa’=>-14090,
    ‘sai’=>-14087,
    ‘san’=>-14083,
    ‘sang’=>-13917,
    ‘sao’=>-13914,
    ‘se’=>-13910,
    ‘sen’=>-13907,
    ‘seng’=>-13906,
    ‘sha’=>-13905,
    ‘shai’=>-13896,
    ‘shan’=>-13894,
    ‘shang’=>-13878,
    ‘shao’=>-13870,
    ‘she’=>-13859,
    ‘shen’=>-13847,
    ‘sheng’=>-13831,
    ‘shi’=>-13658,
    ‘shou’=>-13611,
    ‘shu’=>-13601,
    ‘shua’=>-13406,
    ‘shuai’=>-13404,
    ‘shuan’=>-13400,
    ‘shuang’=>-13398,
    ‘shui’=>-13395,
    ‘shun’=>-13391,
    ‘shuo’=>-13387,
    ‘si’=>-13383,
    ‘song’=>-13367,
    ‘sou’=>-13359,
    ‘su’=>-13356,
    ‘suan’=>-13343,
    ‘sui’=>-13340,
    ‘sun’=>-13329,
    ‘suo’=>-13326,
    ‘ta’=>-13318,
    ‘tai’=>-13147,
    ‘tan’=>-13138,
    ‘tang’=>-13120,
    ‘tao’=>-13107,
    ‘te’=>-13096,
    ‘teng’=>-13095,
    ‘ti’=>-13091,
    ‘tian’=>-13076,
    ‘tiao’=>-13068,
    ‘tie’=>-13063,
    ‘ting’=>-13060,
    ‘tong’=>-12888,
    ‘tou’=>-12875,
    ‘tu’=>-12871,
    ‘tuan’=>-12860,
    ‘tui’=>-12858,
    ‘tun’=>-12852,
    ‘tuo’=>-12849,
    ‘wa’=>-12838,
    ‘wai’=>-12831,
    ‘wan’=>-12829,
    ‘wang’=>-12812,
    ‘wei’=>-12802,
    ‘wen’=>-12607,
    ‘weng’=>-12597,
    ‘wo’=>-12594,
    ‘wu’=>-12585,
    ‘xi’=>-12556,
    ‘xia’=>-12359,
    ‘xian’=>-12346,
    ‘xiang’=>-12320,
    ‘xiao’=>-12300,
    ‘xie’=>-12120,
    ‘xin’=>-12099,
    ‘xing’=>-12089,
    ‘xiong’=>-12074,
    ‘xiu’=>-12067,
    ‘xu’=>-12058,
    ‘xuan’=>-12039,
    ‘xue’=>-11867,
    ‘xun’=>-11861,
    ‘ya’=>-11847,
    ‘yan’=>-11831,
    ‘yang’=>-11798,
    ‘yao’=>-11781,
    ‘ye’=>-11604,
    ‘yi’=>-11589,
    ‘yin’=>-11536,
    ‘ying’=>-11358,
    ‘yo’=>-11340,
    ‘yong’=>-11339,
    ‘you’=>-11324,
    ‘yu’=>-11303,
    ‘yuan’=>-11097,
    ‘yue’=>-11077,
    ‘yun’=>-11067,
    ‘za’=>-11055,
    ‘zai’=>-11052,
    ‘zan’=>-11045,
    ‘zang’=>-11041,
    ‘zao’=>-11038,
    ‘ze’=>-11024,
    ‘zei’=>-11020,
    ‘zen’=>-11019,
    ‘zeng’=>-11018,
    ‘zha’=>-11014,
    ‘zhai’=>-10838,
    ‘zhan’=>-10832,
    ‘zhang’=>-10815,
    ‘zhao’=>-10800,
    ‘zhe’=>-10790,
    ‘zhen’=>-10780,
    ‘zheng’=>-10764,
    ‘zhi’=>-10587,
    ‘zhong’=>-10544,
    ‘zhou’=>-10533,
    ‘zhu’=>-10519,
    ‘zhua’=>-10331,
    ‘zhuai’=>-10329,
    ‘zhuan’=>-10328,
    ‘zhuang’=>-10322,
    ‘zhui’=>-10315,
    ‘zhun’=>-10309,
    ‘zhuo’=>-10307,
    ‘zi’=>-10296,
    ‘zong’=>-10281,
    ‘zou’=>-10274,
    ‘zu’=>-10270,
    ‘zuan’=>-10262,
    ‘zui’=>-10260,
    ‘zun’=>-10256,
    ‘zuo’=>-10254
    );
 
 /**
  * 取汉字全数拼音
  * @param string $chinese 要转移的汉字
  * @param string $delimiter 分隔符
  * @param int $length 重回的尺寸
  * @return string
  */
 public function getFullSpell($chinese, $delimiter = ‘ ‘, $length =

EXCEL怎么着自动将人名转换为拼音?以下是自个儿的缓解方法,不是用VBA,而是借助word来操作

$_data = (php_version>=’5.0′) ? array_combine($_tdatakey,
$_tdatavalue) : _array_combine($_tdatakey, $_tdatavalue);
arsort($_data);
reset($_data);

0) {
  $spell = $this->getChineseSpells($chinese, $delimiter);
  if ($length) {
   $spell = substr($spell, 0, $length);
  }
  return $spell;
 }
 
 /**
  * 取汉字第四个拼音
  * @param string $chinese 要转换的方块字
  * @param int $length 再次来到的长短
  * @return string
  */
 public function getFirstSpell($chinese, $length = 0) {
  $spell = $this->getChineseSpells($chinese, ‘ ‘, 1);
  if ($length) {
   $spell = substr($spell, 0, $length);
  }
  return $spell;
 }

操作思路:

if($_code != ‘gb2312’) $_string = _u2_utf8_gb($_string);
$_res = ”;
for($i=0; $i<strlen($_string); $i++)
{
$_p = ord(substr($_string, $i, 1));
if($_p>160) { $_q = ord(substr($_string, ++$i, 1)); $_p =
$_p*256 + $_q – 65536; }
$_res .= _pinyin($_p, $_data);
}
return preg_replace(“/[^a-z0-9]*/”, ”, $_res);
}

 /**
  * 取一个汉字码对应的拼音
  * @param int $num 汉字码
  * @param string $blank 空白字符
  * @return string
  */
 private function getChineseSpell ($num, $blank = ”) {
  if ( $num>0 && $num<160 ) {
   return chr($num);
  } elseif ($num<-20319||$num>-10247) {
   return $blank;
  } else {
   foreach ($this->chineseSpellList as $spell => $code)

第一:把excel中的姓名粘贴到word中,借助word添加拼音,再把word中添加拼音的结果粘贴到excel中

function _pinyin($_num, $_data)
{
if ($_num>0 && $_num<160 ) return chr($_num);
elseif($_num<-20319 || $_num>-10247) return ”;
else {
foreach($_data as $k=>$v){ if($v<=$_num) break; }
return $k;
}
}

{
    if ($code > $num) break;
    $result = $spell;
   }
   return $result;
  }
 }

第三:用PHONETIC函数取得拼音

function _u2_utf8_gb($_c)
{
$_string = ”;
if($_c < 0x80) $_string .= $_c;
elseif($_c < 0x800)
{
$_string .= chr(0xc0 | $_c>>6);
$_string .= chr(0x80 | $_c & 0x3f);
}elseif($_c < 0x10000){
$_string .= chr(0xe0 | $_c>>12);
$_string .= chr(0x80 | $_c>>6 & 0x3f);
$_string .= chr(0x80 | $_c & 0x3f);
} elseif($_c < 0x200000) {
$_string .= chr(0xf0 | $_c>>18);
$_string .= chr(0x80 | $_c>>12 & 0x3f);
$_string .= chr(0x80 | $_c>>6 & 0x3f);
$_string .= chr(0x80 | $_c & 0x3f);
}
return iconv(‘utf-8’, ‘gb2312’, $_string);
}

 /**
  * 取汉字拼音
  * @param string $chinese 要转移的方块字
  * @param string $delimiter 分隔符
  * @param int $first 是或不是只回去第三个
  * @return string
  */
 private function getChineseSpells($chinese, $delimiter = ‘ ‘,