自动提取中文拼音首字母的格式表
查找函数之Vlookup(取汉字首位字母)
vlookup应用实例精确匹配查询之基本运用精确查找是vlookup 最基本也是最常用的功能，对于数据量大的查找，其速度比菜单中的查找还快。
设置vlookup 第四精确查找适用于文本，也适用于数值；但对数值查找时须注意格式一致，否则会出错数值近似匹配查询之基本运用近似匹配查找通常情况下用于累进数值的查找。
此时第四个参数省略，或为true，或为非0数值。
（EXCEL中0等同FA注意公式中第四个参数省略，或为true，或为非0数值。
并且查找的第一列必须升序排列，否则不会返回期望的结果（需要注意的是此时不一定返回错误）。
试着输入5000，你会发现税率为20%，应是15%（由条件指定），虽然对最后计算结果没有影响。
以返回文本近似匹配查询之基本运用对于文本，一般不使用近似匹配查找（非模糊查找）。
并非文本不能用于近似查找，主要是没有太多用途。
除了下面这个例子：这个例子利用文本近似匹配查找汉字的第一个拼音字母由于EXCEL中汉字字符是按拼音排序的，因此汉字字符比较时的大小与拼音同序左边的表是根据汉字拼音首字母排列，并取各字母的临界点汉字字符（该字母的通过将“家”与表中字符比较后，找到比“家”小的最大值“J这个例子一般用于姓名的缩写，而上面的公式只找第一个字符，因此需要修改这个公式取得前三个汉字字符的拼音字母。
使用MID依次取出字符后由Vlookup查使用该例关键是【表三】的建立；同理，如果要查找汉字的完整拼音，可以建立但这个方法并不一直正确，由于多音字及文字大小排序与其拼音不完全一致的原区别查询结果的空白与0值依次序返回同一查询结果的多列内容当查询某个结果的多列内容，并要依次取出，可使用column()函数作为index_num参数column()函数返回公式所在列的列号，当公式复制时，会随单元格的移动相应改变lookup_value参数使用混合引用，如$B96。
即对列标绝对引用（列标前加$）、行号相对引用上面公式只要输入C96中的公式，然后向右、向下复制就可以。
excel：汉字拼音首字母提取
方法一：VBA自定义函数"=hztopy（）"下面是一个VBA自定义函数，工具->宏->Visual Basic编辑器->，插入模块,在VBA编辑器里面->插入->模块->贴入下述代码，（按ALT＋F11，插入模块，在右面窗口中粘贴下面代码）那么，比如在A3中有"进退两难"，则在B3中输入"=hztopy（A3）"，则会得到"JTLN"。
不过此法有时候也会出错，比如"皓、鑫、婷、雯、奕"等，就无法提取汉字拼音首字母。
Function hztopy(hzpy As String) As StringDim hzstring As String, pystring As StringDim hzpysum As Integer, hzi As Integer, hzpyhex As Integerhzstring = Trim(hzpy)hzpysum = Len(Trim(hzstring))pystring = ""For hzi = 1 To hzpysumhzpyhex = "&H" + Hex(Asc(Mid(hzstring, hzi, 1)))Select Case hzpyhexCase &HB0A1 To &HB0C4: pystring = pystring + "A"Case &HB0C5 To &HB2C0: pystring = pystring + "B"Case &HB2C1 To &HB4ED: pystring = pystring + "C"Case &HB4EE To &HB6E9: pystring = pystring + "D"Case &HB6EA To &HB7A1: pystring = pystring + "E"Case &HB7A2 To &HB8C0: pystring = pystring + "F"Case &HB8C1 To &HB9FD: pystring = pystring + "G"Case &HB9FE To &HBBF6: pystring = pystring + "H"Case &HBBF7 To &HBFA5: pystring = pystring + "J"Case &HBFA6 To &HC0AB: pystring = pystring + "K"Case &HC0AC To &HC2E7: pystring = pystring + "L"Case &HC2E8 To &HC4C2: pystring = pystring + "M"Case &HC4C3 To &HC5B5: pystring = pystring + "N"Case &HC5B6 To &HC5BD: pystring = pystring + "O"Case &HC5BE To &HC6D9: pystring = pystring + "P"Case &HC6DA To &HC8BA: pystring = pystring + "Q"Case &HC8BB To &HC8F5: pystring = pystring + "R"Case &HC8F6 To &HCBF9: pystring = pystring + "S"Case &HCBFA To &HCDD9: pystring = pystring + "T"Case &HEDC5: pystring = pystring + "T"Case &HCDDA To &HCEF3: pystring = pystring + "W"Case &HCEF4 To &HD1B8: pystring = pystring + "X"Case &HD1B9 To &HD4D0: pystring = pystring + "Y"Case &HD4D1 To &HD7F9: pystring = pystring + "Z"Case Elsepystring = pystring + Mid(hzstring, hzi, 1)End SelectNexthztopy = pystringEnd Function方法二：VBA自定义函数"=getpy()"下面是一个VBA自定义函数，工具->宏->Visual Basic编辑器->，插入模块,在VBA编辑器里面->插入->模块->贴入上述代码，那么。
excel获得汉字首字母的方法
在日常工作和学习中，我们经常需要对文本进行处理和分析，尤其是对于中文文本。
在处理中文文本时，有时会遇到需要将汉字转换为拼音的需求。
而在Excel中，获得汉字的首字母则成为了一个常见的需求。
那么，如何在Excel中获得汉字的首字母呢？我们可以利用Excel内置的函数来实现这一目标。
在Excel中，可以使用VB脚本编写一个自定义函数来获取汉字的首字母。
具体步骤如下：1. 打开Excel表格，按下ALT + F11，打开VB编辑器。
2. 在VB编辑器中，插入一个新模块。
3. 在新模块中输入以下VB脚本代码：```vbFunction GetFirstLetter(str As String) As StringDim pinyin As StringDim i As IntegerDim ch As Stringpinyin = ""For i = 1 To Len(str)ch = Mid(str, i, 1)pinyin = pinyin &Left(Application.WorksheetFunction.Phonetic(ch), 1)Next iGetFirstLetter = pinyinEnd Function```4. 编译保存后，返回Excel表格界面。
5. 在需要获取汉字首字母的单元格中输入`=GetFirstLetter(A1)`，其中A1为需要转换的汉字所在的单元格。
6. 按下Enter键，即可在目标单元格中获取到相应汉字的首字母。
通过上述方法，我们可以轻松地在Excel中获得汉字的首字母，而且可以将这个函数在多个单元格中批量应用，提高工作效率。
除了使用VB脚本自定义函数外，我们还可以借助Excel内置的函数来实现汉字首字母的获取。
在Excel中，有一个叫做UNICODE的函数，可以返回指定字符的Unicode编码。
而对于汉字来说，其首字母的Unicode编码可以作为其拼音的首字母。
提取汉字首拼字母
-12860, -12858, -12852, -12849, -12838, -12831, -12829, -12812, -12802, -12607, -12597, -12594, -12585,
-12556, -12359, -12346,
-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,
-10329, -10328, -10322, -10315, -10309, -10307, -10296, -10281, -10274, -10270, -10262, -10260, -10256,
-10254
};
private static string[] pystr = new string[]
"huo", "ji", "jia", "jian",
"jiang", "jiao", "jie", "jin", "jing", "jiong", "jiu", "ju", "juan", "jue", "jun", "ka", "kai", "kan",
汉语拼音音节索引表格模板(很漂亮的完整版)
guan官
guang光
gui规
gun棍
guo锅
H
ha哈
hai孩
han含
hang杭
hao蒿
he喝
hei黑
hen痕
heng恒
hm嗽
hng哼
hong烘
hou喉
hu呼
hua花
huai怀
huan欢
huang荒
hui灰
hun昏
huo活
J
ji机
jia家
jian尖
jiang江
jiao交
jie街
jin今
jing京
jiong迥
jiu究
ju居
juan捐
jue决
jun军
K
ka咖
kai开
kan刊
kang康
kao考
ke科
kei克
ken肯
keng坑
kong空
kou抠
ku枯
kua夸
kuai快
kuan宽
kuang筐
kui亏
kun昆
kuo阔
L
la拉
lai来
lan兰
lang狼
lao捞
le勒
lei类
leng冷
li里
lia俩
lian连
nan男
nang囊
nao闹
ne讷
nei内
nen嫩
neng能
ng嗯
ni泥
nian年
niang娘
niao鸟
nie捏
nin您
ning宁
niu牛
nong农
nou耨（锄草）
nu奴
nu女
nuan暖
nue虐
提取单元格汉字首字母
提取单元格汉字首字母在处理 Excel 表格数据时，有时需要将单元格中的汉字转换为汉字拼音的首字母，以便进行后续的数据分析和处理。
本文将介绍如何使用 Excel 中的函数和工具来提取单元格汉字首字母，并分析其适用范围和注意事项。
一、使用 LEFT 函数提取单个汉字的首字母Excel 中的 LEFT 函数用于从文本字符串的左侧提取指定长度的字符。
结合汉字拼音的特点，可以使用 LEFT 函数提取汉字的首字母。
例如，假设 A1 单元格中为“中国”，则可以使用以下公式提取其首字母：=LEFT(A1,1)这个公式的含义是从单元格 A1 左侧提取 1 个字符，即“中”的首字母，“结果为“Z”。
需要注意的是，该方法只能提取单个汉字的首字母，多个汉字则无法处理。
二、使用 VBA 宏提取多个汉字的首字母如果需要提取多个汉字的首字母，可以使用 Excel 的 VBA 宏来实现。
下面是一段实现该功能的 VBA 代码：Sub ChineseFirstLetter()Dim str As String, result As Stringstr = Selection.ValueFor i = 1 To Len(str)result = result &Left(LCase(Application.WorksheetFunction.Substitute(Application.Transpose(Split(Trim (str(i, 1)), " ")), " ", "")), 1)Next iSelection.Value = UCase(result)End Sub该宏的作用是将选定区域中的汉字转换为首字母，并将结果替换原单元格中的内容。
需要注意的是，该宏需要在 Excel 中启用宏功能，并将其保存为一个新的模块。
三、使用 PinYin 工具包提取多个汉字的首字母使用 VBA 宏虽然能够实现多个汉字首字母的提取，但对于不熟悉 VBA 编程的用户来说，会存在一定的难度。
excel：汉字拼音首字母提取
方法一：VBA自定义函数"=hztopy（）"下面是一个VBA自定义函数，工具->宏->Visual Basic编辑器->，插入模块,在VBA编辑器里面->插入->模块->贴入下述代码，（按ALT＋F11，插入模块，在右面窗口中粘贴下面代码）那么，比如在A3中有"进退两难"，则在B3中输入"=hztopy（A3）"，则会得到"JTLN"。
不过此法有时候也会出错，比如"皓、鑫、婷、雯、奕"等，就无法提取汉字拼音首字母。
Function hztopy(hzpy As String) As StringDim hzstring As String, pystring As StringDim hzpysum As Integer, hzi As Integer, hzpyhex As Integerhzstring = Trim(hzpy)hzpysum = Len(Trim(hzstring))pystring = ""For hzi = 1 To hzpysumhzpyhex = "&H" + Hex(Asc(Mid(hzstring, hzi, 1)))Select Case hzpyhexCase &HB0A1 To &HB0C4: pystring = pystring + "A"Case &HB0C5 To &HB2C0: pystring = pystring + "B"Case &HB2C1 To &HB4ED: pystring = pystring + "C"Case &HB4EE To &HB6E9: pystring = pystring + "D"Case &HB6EA To &HB7A1: pystring = pystring + "E"Case &HB7A2 To &HB8C0: pystring = pystring + "F"Case &HB8C1 To &HB9FD: pystring = pystring + "G"Case &HB9FE To &HBBF6: pystring = pystring + "H"Case &HBBF7 To &HBFA5: pystring = pystring + "J"Case &HBFA6 To &HC0AB: pystring = pystring + "K"Case &HC0AC To &HC2E7: pystring = pystring + "L"Case &HC2E8 To &HC4C2: pystring = pystring + "M"Case &HC4C3 To &HC5B5: pystring = pystring + "N"Case &HC5B6 To &HC5BD: pystring = pystring + "O"Case &HC5BE To &HC6D9: pystring = pystring + "P"Case &HC6DA To &HC8BA: pystring = pystring + "Q"Case &HC8BB To &HC8F5: pystring = pystring + "R"Case &HC8F6 To &HCBF9: pystring = pystring + "S"Case &HCBFA To &HCDD9: pystring = pystring + "T"Case &HEDC5: pystring = pystring + "T"Case &HCDDA To &HCEF3: pystring = pystring + "W"Case &HCEF4 To &HD1B8: pystring = pystring + "X"Case &HD1B9 To &HD4D0: pystring = pystring + "Y"Case &HD4D1 To &HD7F9: pystring = pystring + "Z"Case Elsepystring = pystring + Mid(hzstring, hzi, 1)End SelectNexthztopy = pystringEnd Function方法二：VBA自定义函数"=getpy()"下面是一个VBA自定义函数，工具->宏->Visual Basic编辑器->，插入模块,在VBA编辑器里面->插入->模块->贴入上述代码，那么。
提取汉字的首字母
else if (@tmp>=0xD4D1 and @tmp<=0xD7F9)
Set @PY = @PY + 'Z'
else
Set @PY = @PY + UPPER(@HZS)
Set @Index = @Index+1
end /* while循环结束 */
Declare @HZS varchar(2)
Declare @Index int
Set @Index = 1
Set @Len = Len(@HZ)
Set @PY = ''
While @Index<=@Len
Begin
Set @HZS = Substring(@HZ,@Index,1)
return @PY
end
Set @PY = @PY + 'Q'
else if (@tmp>=0xC8BB and @tmp<=0xC8F5)
Set @PY = @PY + 'R'
else if (@tmp>=0xC8F6 and @tmp<=0xCBF9)
Set @PY = @PY + 'S'
else if (@tmp>=0xCBFA and @tmp<=0xCDD9)
Set @PY = @PY + 'T'
else if (@tmp>=0xCDDA and @tmp<=0xCEF3)
Set @PY = @PY + 'W'
excel提取汉语简拼
excel提取汉语简拼汉语简拼是一种将汉字通过拼音字母来表示的拼音输入法。
在Excel中，我们可以使用一些方法来提取汉语简拼，并利用这些拼音来命名或分类数据，提高数据的整理和查找效率。
我们可以使用Excel的函数来提取汉字的拼音首字母。
在Excel中，有一个函数叫做“LEFT”，它可以提取文本字符串的左边指定长度的字符。
我们可以利用这个函数，将汉字转换成拼音首字母。
例如，如果我们要提取汉字“汉”的拼音首字母，我们可以使用以下公式：=LEFT(拼音函数, 1)其中，“拼音函数”代表一个将汉字转换成拼音的函数，可以使用Excel的内置函数“=PINYIN(汉字)”来实现。
将这个公式应用到一个指定的单元格，就可以得到汉字的拼音首字母。
我们可以利用提取出的汉语简拼来命名或分类数据。
在Excel中，我们可以通过选择数据范围，然后点击“格式”->“条件格式”->“新建规则”，来为数据添加颜色标记。
我们可以根据汉语简拼的首字母来设置不同的颜色，以便在查找和整理数据时更加方便。
例如，我们可以将所有以“H”开头的汉字单元格标记为红色，以“Y”开头的汉字单元格标记为黄色，以此类推。
我们还可以利用提取出的汉语简拼来进行数据的筛选和排序。
在Excel中，我们可以使用“筛选”功能来快速筛选符合条件的数据。
我们可以选择一个数据范围，然后点击“数据”->“筛选”，在弹出的筛选窗口中选择“文本筛选”，然后选择“以...开头”或“以...结尾”的条件，输入汉语简拼的首字母，即可筛选出符合条件的数据。
类似地，我们还可以使用“排序”功能来按照汉语简拼的首字母对数据进行排序，以便更加方便地查找和整理数据。
利用Excel提取汉语简拼可以提高数据整理和查找的效率。
通过将汉字转换成拼音首字母，并将其用于命名、分类、标记、筛选和排序数据，我们可以更加方便地处理和管理大量的汉字数据。
这种方法不仅简单易用，而且能够节省我们大量的时间和精力，提高工作效率。
EXCEL如何提取汉字首字母
方法/步骤1.首先，打开Excel，同时按下Alt+F11键，打开VBE界面，如下图所示。
在VBE界面中，单击图片中所示的左上角空白处，选择“插入“，”模块“。
2.此时，就插入了一个模块，后面的代码就要放到这个模块中，保证右侧空白区域是模块代码的编辑区（最保险的做法是双击模块），然后执行下一步操作。
3.将下面的代码全部复制粘贴到空白区域。
Function pinyin(p As String) As Stringi = Asc(p)Select Case iCase -20319 To -20284: pinyin = "A"Case -20283 To -19776: pinyin = "B"Case -19775 To -19219: pinyin = "C"Case -19218 To -18711: pinyin = "D"Case -18710 To -18527: pinyin = "E"Case -18526 To -18240: pinyin = "F"Case -18239 To -17923: pinyin = "G"Case -17922 To -17418: pinyin = "H"Case -17417 To -16475: pinyin = "J"Case -16474 To -16213: pinyin = "K"Case -16212 To -15641: pinyin = "L"Case -15640 To -15166: pinyin = "M"Case -15165 To -14923: pinyin = "N"Case -14922 To -14915: pinyin = "O"Case -14914 To -14631: pinyin = "P"Case -14630 To -14150: pinyin = "Q"Case -14149 To -14091: pinyin = "R"Case -14090 To -13319: pinyin = "S"Case -13318 To -12839: pinyin = "T" Case -12838 To -12557: pinyin = "W" Case -12556 To -11848: pinyin = "X" Case -11847 To -11056: pinyin = "Y" Case -11055 To -2050: pinyin = "Z" Case Else: pinyin = pEnd SelectEnd FunctionFunction getpy(str)For i = 1 To Len(str)getpy = getpy& pinyin(Mid(str, i, 1)) Next iEnd Function4.然后关闭这个新界面，返回Excel，就可以像Excel自带的函数一样使用这个自定义的Getpy函数了，它只有一个参数，参数可以直接指定单元格，也可以直接输入字符。
提取汉字首拼字母
提取汉字首拼字母C#提取汉字拼音首字母的方法今天突然要用到提取汉字拼音首字母的功能，去网上找了找，发现没有几个好用的，决定自己写一个，效果还不错，发出来大家一起研究下，分享给大家！直接入主题：1.首先对编码进行定义#region 编码定义private static int[] pyvalue = new int[]{-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,-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,-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};private static string[] pystr = new string[]{"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","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","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",#endregion2.然后就是拼音的处理方法了#region 拼音处理/// <summary>/// 将一串中文转化为拼音/// 如果给定的字符为非中文汉字将不执行转化，直接返回原字符；/// </summary>/// <param name="chsstr">指定汉字</param>/// <returns>拼音码</returns>public string ChsString2Spell(string chsstr){string strRet = string.Empty;char[] ArrChar = chsstr.ToCharArray();foreach (char c in ArrChar){strRet += SingleChs2Spell(c.ToString());}return strRet;}/// <summary>/// 将一串中文转化为拼音/// </summary>/// <param name="chsstr">指定汉字</param>/// <returns>拼音首字母</returns>public string GetHeadOfChs(string chsstr){string strRet = string.Empty;char[] ArrChar = chsstr.ToCharArray();foreach (char c in ArrChar){strRet += GetHeadOfSingleChs(c.ToString());}return strRet;}/// <summary>/// 单个汉字转化为拼音/// </summary>/// <param name="SingleChs">单个汉字</param> /// <returns>拼音</returns>public string SingleChs2Spell(string SingleChs){byte[] array;int iAsc;string strRtn = string.Empty;array = Encoding.Default.GetBytes(SingleChs); try{iAsc = (short)(array[0]) * 256 + (short)(array[1]) - 65536;}catch{iAsc = 1;}if (iAsc > 0 && iAsc < 160)return SingleChs;for (int i = (pyvalue.Length - 1); i >= 0; i--){if (pyvalue[i] <= iAsc){strRtn = pystr[i];break;}}//将首字母转为大写if (strRtn.Length > 1){strRtn = strRtn.Substring(0, 1).ToUpper() + strRtn.Substring(1);}return strRtn;}/// <summary>/// 得到单个汉字拼音的首字母/// </summary>/// <returns> </returns>public string GetHeadOfSingleChs(string SingleChs) {return SingleChs2Spell(SingleChs).Substring(0, 1); }#endregion调用方法相信大家都会了，就不多说了！。
汉语拼音字母表格模板_完整版_可A4打印
声母：Bb Pp M m Ff Dd Tt Nn Ll Gg Kk Hh Jj Qq Xx Zz Cc Ss Rr YyWw翘舌音：zh ch sh单韵母：a o e i u u(u上边有两点读於）复韵母：ai ei ui ao ou iu ie ue (u上边有两点) er an en in ang eng ing ong整体认读音节：zhi chi shi yi wu yu yin yun ye yue音序表：Aa Bb Cc Dd Ee Ff Gg Hh Ii Jj Kk Ll Mm Nn Oo Pp Qq Rr Ss Tt Uu Vv Ww Xx Yy Zz声母表b p m fd t n lg k h j q xzh ch sh rz c sy w韵母表a o e i u üai ei ui ao ou iu ie üe eran en in unang eng ing ong声母表b p m f d t n l g k h j q xzh ch sh r z c sy w韵母表a o e i u üai ei uiAo ou iuie üe eran en in un ang eng ing ong汉语拼音音节表b ba bo bai bei bao ban ben bang beng bi bie biao bian bin bingp pa po pai pao pou pan pen pang peng pi pie piao pian pin pingm ma mo me mai mao mou man men mang meng mi mie miao miu mian min mingf fa fo fei fou fan fen fang fengd da de dai dei dao dou dan dang deng di die diao diu dian dingt ta te tai tao tou tan tang teng ti tie tiao tian tingn na nai nei nao no nen nang neng ni nie niao niu nian nin niang ningl la le lai lei lao lou lan lang leng li lia lie liao liu lian lin liang lingg ga ge gai gei gao gou gan gen gang gengk ka ke kai kou kan ken kang kengh ha he hai hei hao hou hen hang hengj ji jia jie jiao jiu jian jin jiang jingq qi qia qie qiao qiu qian qin qiang qingx xi xia xie xiao xiu xian xin xiang xingzh zha zhe zhi zhai zhao zhou zhan zhen zhang zheng ch cha che chi chai chou chan chen chang cheng sh sha she shi shai shao shou shan shen shang sheng r re ri rao rou ran ren rang rengz za ze zi zai zao zou zang zengc ca ce ci cai cao cou can cen cang cengs sa se si sai sao sou san sen sang sengy ya yao you yan yang yu ye yue yuan yi yin yun ying w wa wo wai wei wan wen wang weng wu前鼻韵母（5个）n en in un ün后鼻韵母四(4个)ng eng ing ong汉语拼音字母表Aa Bb Cc Dd Ee Ff Gg Hh Ii Jj Kk Ll Mm Nn Oo pp Qq Rr Ss Tt Uu Vv Ww Xx Yy Zz汉语拼音声母表b [玻] p [坡] m [摸] f [佛] d [得] t [特] n [讷] l [勒] g [哥] k [科] h [喝] j [基] q [欺] x [希] z [资] c[;雌] s [思] r [日] zh[知] ch [嗤] sh [诗] y [医] w [巫]汉语拼音韵母表单韵母a[阿] o[喔] e[鹅] i[衣] u[乌] ü[迂]复韵母ai[哀] ei[唉] ui[威] ao[奥] ou[欧] iu[由] ie[耶] üe[椰] er[儿]前鼻韵母an[安] en[恩] in[因] un[温]后鼻韵母ang[昂] eng[摁] ing[英] ong[雍]整体认读音节：zi ci si zhi chi shi ri yi wu yu yin ying yun ye yue yuan声调符号阴平：- 阳平：/ 上声：∨ 去声：﹨汉语拼音采用拉丁字母和一些附加符号表示汉语的发音。
获取汉字全拼以及首字母缩拼
获取汉字全拼以及首字母缩拼using System;using System.Collections.Generic;using System.Text;using System.Text.RegularExpressions;namespace mon.Tools{/// <summary>/// 汉字转拼音静态类,包括功能全拼和缩写，方法全部是静态的/// </summary>public static class Chinese2Spell{#region 属性数据定义/// <summary>/// 汉字的机内码数组/// </summary>private static int[] pyValue = new int[]{-20319,-20317,-20304,-20295,-20292,-20283,-20265,-20257,-20242,-202 30,-20051,-20036,-20032,-20026,-20002,-19990,-19986,-19982,-19976,-19805,-19784,-197 75,-19774,-19763,-19756,-19751,-19746,-19741,-19739,-19728,-19725,-19715,-19540,-195 31,-19525,-19515,-19500,-19484,-19479,-19467,-19289,-19288,-19281,-19275,-19270,-192 63,-19261,-19249,-19243,-19242,-19238,-19235,-19227,-19224,-19218,-19212,-19038,-190 23,-19018,-19006,-19003,-18996,-18977,-18961,-18952,-18783,-18774,-18773,-18763,-187 56,-18741,-18735,-18731,-18722,-18710,-18697,-18696,-18526,-18518,-18501,-18490,-184 78,-18463,-18448,-18447,-18446,-18239,-18237,-18231,-18220,-18211,-18201,-18184,-181 83, -18181,-18012,-17997,-17988,-17970,-17964,-17961,-17950,-17947,-17931,-17928,-179 22,-17759,-17752,-17733,-17730,-17721,-17703,-17701,-17697,-17692,-17683,-17676,-174 96,-17487,-17482,-17468,-17454,-17433,-17427,-17417,-17202,-17185,-16983,-16970,-169 42,-16915,-16733,-16708,-16706,-16689,-16664,-16657,-16647,-16474,-16470,-16465,-164 59,-16452,-16448,-16433,-16429,-16427,-16423,-16419,-16412,-16407,-16403,-16401,-163 93,-16220,-16216,-16212,-16205,-16202,-16187,-16180,-16171,-16169,-16158,-16155,-159 59,-15958,-15944,-15933,-15920,-15915,-15903,-15889,-15878,-15707,-15701,-15681,-156 67,-15661,-15659,-15652,-15640,-15631,-15625,-15454,-15448,-15436,-15435,-15419,-154 16,-15408,-15394,-15385,-15377,-15375,-15369,-15363,-15362,-15183,-15180,-15165,-151 58,-15153,-15150,-15149,-15144,-15143,-15141,-15140,-15139,-15128,-15121,-15119,-151 17,-15110,-15109,-14941,-14937,-14933,-14930,-14929,-14928,-14926,-14922,-14921,-149 14,-14908,-14902,-14894,-14889,-14882,-14873,-14871,-14857,-14678,-14674,-14670,-146 68,-14663,-14654,-14645,-14630,-14594,-14429,-14407,-14399,-14384,-14379,-14368,-143 55,-14353,-14345,-14170,-14159,-14151,-14149,-14145,-14140,-14137,-14135,-14125,-141 23,-14122,-14112,-14109,-14099,-14097,-14094,-14092,-14090,-14087,-14083,-13917,-139 14,-13910,-13907,-13906,-13905,-13896,-13894,-13878,-13870,-13859,-13847,-13831,-136 58,-13611,-13601,-13406,-13404,-13400,-13398,-13395,-13391,-13387,-13383,-13367,-133 59,-13356,-13343,-13340,-13329,-13326,-13318,-13147,-13138,-13120,-13107,-13096,-13095,-13091,-13076, -13068,-13063,-13060,-12888,-12875,-12871,-12860,-12858,-12852,-128 49,-12838,-12831,-12829,-12812,-12802,-12607,-12597,-12594,-12585,-12556,-12359,-123 46,-12320,-12300,-12120,-12099,-12089,-12074,-12067,-12058,-12039,-11867,-11861,-118 47,-11831,-11798,-11781,-11604,-11589,-11536,-11358,-11340,-11339,-11324,-11303,-110 97,-11077,-11067,-11055,-11052,-11045,-11041,-11038,-11024,-11020,-11019,-11018,-110 14,-10838,-10832,-10815,-10800,-10790,-10780,-10764,-10587,-10544,-10533,-10519,-10331,-10329,-10328,-10322,-10315,-10309,-10307,-10296,-10281,-10274,-10270,-10262,-102 60,-10256,-10254};/// <summary>/// 机内码对应的拼音数组/// </summary>private static string[] pyName = new string[]{"A","Ai","An","Ang",&q uot;Ao","Ba","Bai","Ban",&qu ot;Bang","Bao","Bei","Ben", "Beng","Bi","Bian","Biao&quo t;,"Bie","Bin","Bing","Bo" ;,"Bu","Ba","Cai","Can", "Cang","Cao","Ce","Ceng&quo t;,"Cha","Chai","Chan","Chang ","Chao","Che","Chen"," Cheng","Chi","Chong","Chou","Chu&q uot;,"Chuai","Chuan","Chuang",&qu ot;Chui","Chun","Chuo","Ci","Cong","Cou","Cu","Cuan","Cui" ,"Cun","Cuo","Da","Dai" ,"Dan","Dang","Dao","De&qu ot;,"Deng","Di","Dian","Diao&qu ot;,"Die","Ding","Diu","Dong& quot;,"Dou","Du","Duan","Dui ","Dun","Duo","E","En",& quot;Er","Fa","Fan","Fang",&q uot;Fei","Fen","Feng","Fo", "Fou","Fu","Ga","Gai",& quot;Gan","Gang","Gao","Ge" ,"Gei","Gen","Geng","Gong&q uot;,"Gou","Gu","Gua","Guai&quo t;,"Guan","Guang","Gui","Gun ","Guo","Ha","Hai","Han ","Hang","Hao","He","Hei" ;,"Hen","Heng","Hong","Hou&n","Huang","Hui","Hun","Huo&q uot;,"Ji","Jia","Jian","Jiang&qu ot;,"Jiao","Jie","Jin","Jing&quo t;,"Jiong","Jiu","Ju","Juan" ,"Jue","Jun","Ka","Kai", "Kan","Kang","Kao","Ke" ,"Ken","Keng","Kong","Kou&qu ot;,"Ku","Kua","Kuai","Kuan& quot;,"Kuang","Kui","Kun","Ku o","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&qn","Miao","Mie","Min","Ming&q uot;,"Miu","Mo","Mou","Mu& quot;,"Na","Nai","Nan","Nang ","Nao","Ne","Nei","Nen" ,"Neng","Ni","Nian","Niang&q uot;,"Niao","Nie","Nin","Ning ","Niu","Nong","Nu","Nv" ,"Nuan","Nue","Nuo","O&quo t;,"Ou","Pa","Pai","Pan", "Pang","Pao","Pei","Pen" ;,"Peng","Pi","Pian","Piao&qu ot;,"Pie","Pin","Ping","Po&qu ot;,"Pu","Qi","Qia","Qian", "Qiang","Qiao","Qie","Qin&qu ot;,"Qing","Qiong","Qiu","Qu ","Quan","Que","Qun","Ran","Rang","Rao","Re","Ren& quot;,"Reng","Ri","Rong","Rou ","Ru","Ruan","Rui","Run" ;,"Ruo","Sa","Sai","San", "Sang","Sao","Se","Sen" ,"Seng","Sha","Shai","Shan&qu ot;,"Shang","Shao","She","She n","Sheng","Shi","Shou","Shu","Shua","Shuai","Shuan","Shua ng","Shui","Shun","Shuo",&qu ot;Si","Song","Sou","Su",&quo t;Suan","Sui","Sun","Suo","Ta", "Tai","Tan","Tang","Tao" ,"Te","Teng","Ti","Tian", "Tiao","Tie","Ting","Tong","Tou","Tu","Tuan","Tui&quo t;,"Tun","Tuo","Wa","Wai&qu ot;,"Wan","Wang","Wei","Wen&q uot;,"Weng","Wo","Wu","Xi& quot;,"Xia","Xian","Xiang","Xia o","Xie","Xin","Xing","Xiong&quo t;,"Xiu","Xu","Xuan","Xue&qu ot;,"Xun","Ya","Yan","Yang&q uot;,"Yao","Ye","Yi","Yin",&q uot;Ying","Yo","Yong","You",& quot;Yu","Yuan","Yue","Yun", "Za","Zai","Zan","Zang","Zao" ;,"Ze","Zei","Zen","Zeng" ;,"Zha","Zhai","Zhan","Zhang","Zhao","Zhe","Zhen& quot;,"Zheng","Zhi","Zhong"," Zhou","Zhu","Zhua","Zhuai",& quot;Zhuan","Zhuang","Zhui","Zhun","Zhuo ","Zi","Zong","Zou","Zu ","Zuan","Zui","Zun","Zu o"};#endregion#region 把汉字转换成拼音(全拼)无间隔符号/// <summary>/// 把汉字转换成拼音(全拼)/// </summary>/// <param name="hzString">汉字字符串</param>/// <returns>转换后的拼音(全拼)字符串</returns>public static string Convert(string hzString){// 匹配中文字符Regex regex = new Regex("^["u4e00-"u9fa5]$"); byte[] array = new byte[2];string pyString = "";int chrAsc = 0;int i1 = 0;int i2 = 0;char[] noWChar = hzString.ToCharArray();for (int j = 0; j < noWChar.Length; j++){// 中文字符if (regex.IsMatch(noWChar[j].ToString())){array = System.Text.Encoding.Default.GetBytes(noWChar[j].ToString()); i1 = (short)(array[0]);i2 = (short)(array[1]);chrAsc = i1 * 256 + i2 - 65536;if (chrAsc > 0 && chrAsc < 160){pyString += noWChar[j];}else{// 修正部分文字if (chrAsc == -9254) // 修正“圳”字pyString += "Zhen";else{for (int i = (pyValue.Length - 1); i >= 0; i--) {if (pyValue[i] <= chrAsc){pyString += pyName[i];break;}}}}}// 非中文字符else{pyString += noWChar[j].ToString();}}return pyString;}#endregion#region 把汉字转换成拼音(全拼) 用空格间隔/// <summary>/// 把汉字转换成拼音(全拼)/// </summary>/// <param name="hzString">汉字字符串</param>/// <returns>转换后的拼音(全拼)字符串</returns>public static string ConvertWithBlank(string hzString){// 匹配中文字符Regex regex = new Regex("^["u4e00-"u9fa5]$"); byte[] array = new byte[2];string pyString = "";int chrAsc = 0;int i1 = 0;int i2 = 0;char[] noWChar = hzString.ToCharArray();for (int j = 0; j < noWChar.Length; j++){// 中文字符if (regex.IsMatch(noWChar[j].ToString())){array = System.Text.Encoding.Default.GetBytes(noWChar[j].ToString()); i1 = (short)(array[0]);i2 = (short)(array[1]);chrAsc = i1 * 256 + i2 - 65536;if (chrAsc > 0 && chrAsc < 160){pyString = pyString + " " + noWChar[j];}else{// 修正部分文字if (chrAsc == -9254) // 修正“圳”字pyString = pyString + " " + "Zhen";else{for (int i = (pyValue.Length - 1); i >= 0; i--)if (pyValue[i] <= chrAsc){pyString = pyString + " " + pyName[i]; break;}}}}}// 非中文字符else{pyString = pyString +" "+ noWChar[j].ToString(); }}return pyString.Trim();}#endregion#region 把汉字转换成拼音(全拼) 用特定的字符间隔/// <summary>/// 把汉字转换成拼音(全拼)/// </summary>/// <param name="hzString">汉字字符串</param>/// <returns>转换后的拼音(全拼)字符串</returns>public static string ConvertWithSplitChar(string hzString,string splitChar) {// 匹配中文字符Regex regex = new Regex("^["u4e00-"u9fa5]$"); byte[] array = new byte[2];string pyString = "";int chrAsc = 0;int i1 = 0;int i2 = 0;char[] noWChar = hzString.ToCharArray();for (int j = 0; j < noWChar.Length; j++)// 中文字符if (regex.IsMatch(noWChar[j].ToString())){array = System.Text.Encoding.Default.GetBytes(noWChar[j].ToString()); i1 = (short)(array[0]);i2 = (short)(array[1]);chrAsc = i1 * 256 + i2 - 65536;if (chrAsc > 0 && chrAsc < 160){pyString = pyString + splitChar + noWChar[j];}else{// 修正部分文字if (chrAsc == -9254) // 修正“圳”字pyString = pyString + splitChar + "Zhen";else{for (int i = (pyValue.Length - 1); i >= 0; i--){if (pyValue[i] <= chrAsc)pyString = pyString + splitChar + pyName[i];break;}}}}}// 非中文字符else{pyString = pyString + splitChar + noWChar[j].ToString(); }}char[] trimAChar = splitChar.ToCharArray();return pyString.TrimStart(trimAChar);}#endregion#region 汉字转拼音缩写(字符串) (小写)/// <summary>/// 汉字转拼音缩写/// </summary>/// <param name="str">要转换的汉字字符串</param>/// <returns>拼音缩写</returns>public static string GetSpellStringLower(string str){string tempStr = "";foreach(char c in str){if((int)c >= 33 && (int)c <=126){//字母和符号原样保留tempStr += c.ToString();}else{//累加拼音声母tempStr += GetSpellCharLower(c.ToString());}return tempStr;}#endregion#region 汉字转拼音缩写(字符串) (小写) (空格间隔)/// <summary>/// 汉字转拼音缩写(字符串) (小写) (空格间隔)/// </summary>/// <param name="str">要转换的汉字字符串</param>/// <returns>拼音缩写</returns>public static string GetSpellStringLowerSplitWithBlank(string str){string tempStr = "";foreach (char c in str){if ((int)c >= 33 && (int)c <= 126){//字母和符号原样保留tempStr = tempStr + " " + c.ToString();}else{//累加拼音声母tempStr = tempStr + " " + GetSpellCharLower(c.ToString()); }}return tempStr.Trim();}#endregion#region 汉字转拼音缩写(字符串)(大写)/// <summary>/// 汉字转拼音缩写(大写)/// </summary>/// <param name="str">要转换的汉字字符串</param>/// <returns>拼音缩写</returns>public static string GetSpellStringSupper(string str){string tempStr = "";foreach (char c in str){if ((int)c >= 33 && (int)c <= 126){//字母和符号原样保留tempStr += c.ToString();}else{//累加拼音声母tempStr += GetSpellCharSupper(c.ToString());}}return tempStr;}#endregion#region 汉字转拼音缩写(字符串)(大写)(空格间隔)/// <summary>/// 汉字转拼音缩写(字符串)(大写)(空格间隔)/// </summary>/// <param name="str">要转换的汉字字符串</param>/// <returns>拼音缩写</returns>public static string GetSpellStringSupperSplitWithBlank(string str){string tempStr = "";foreach (char c in str){if ((int)c >= 33 && (int)c <= 126){//字母和符号原样保留tempStr = tempStr + " " + c.ToString();}else{//累加拼音声母tempStr = tempStr + " " + GetSpellCharSupper(c.ToString()); }}return tempStr.Trim();}#endregion#region 取单个字符的拼音声母(字符)(大写)/// <summary>/// 取单个字符的拼音声母/// </summary>/// <param name="c">要转换的单个汉字</param>/// <returns>拼音声母</returns>public static string GetSpellCharSupper(string c){byte[] array = new byte[2];array = System.Text.Encoding.Default.GetBytes(c);int i = (short)(array[0] - '"0') * 256 + ((short)(array[1] -'"0'));if (i < 0xB0A1) return c;if (i < 0xB0C5) return "A";if (i < 0xB2C1) return "B";if (i < 0xB4EE) return "C";if (i < 0xB6EA) return "D";if (i < 0xB7A2) return "E"; if (i < 0xB8C1) return "F";if (i < 0xB9FE) return "G";if (i < 0xBBF7) return "H";if (i < 0xBFA6) return "J";if (i < 0xC0AC) return "K";if (i < 0xC2E8) return "L";if (i < 0xC4C3) return "M";if (i < 0xC5B6) return "N";if (i < 0xC5BE) return "O";if (i < 0xC6DA) return "P";if (i < 0xC8BB) return "Q";if (i < 0xC8F6) return "R";if (i < 0xCBFA) return "S";if (i < 0xCDDA) return "T";if (i < 0xCEF4) return "W";if (i < 0xD1B9) return "X";if (i < 0xD4D1) return "Y";if (i < 0xD7FA) return "Z";return c;}#endregion#region 取单个字符的拼音声母(字符)(小写)/// <summary>/// 取单个字符的拼音声母/// </summary>/// <param name="c">要转换的单个汉字</param>/// <returns>拼音声母</returns>public static string GetSpellCharLower(string c){byte[] array = new byte[2];array = System.Text.Encoding.Default.GetBytes(c);int i = (short)(array[0] - '"0') * 256 + ((short)(array[1] - '"0'));if (i < 0xB0A1) return c;if (i < 0xB0C5) return "a";if (i < 0xB2C1) return "b";if (i < 0xB4EE) return "c";if (i < 0xB6EA) return "d";if (i < 0xB7A2) return "e";if (i < 0xB8C1) return "f";if (i < 0xB9FE) return "g";if (i < 0xBBF7) return "h";if (i < 0xBFA6) return "j";if (i < 0xC0AC) return "k";if (i < 0xC2E8) return "l";if (i < 0xC4C3) return "m";if (i < 0xC5B6) return "n";if (i < 0xC5BE) return "o";if (i < 0xC6DA) return "p";if (i < 0xC8BB) return "q"; if (i < 0xC8F6) return "r"; if (i < 0xCBFA) return "s"; if (i < 0xCDDA) return "t"; if (i < 0xCEF4) return "w"; if (i < 0xD1B9) return "x"; if (i < 0xD4D1) return "y"; if (i < 0xD7FA) return "z"; return c;}#endregion}}0 0 0(请您对文章做出评价)。
vbs获得汉字拼音及首字母
vbs获得汉字拼音及首字母各位读友大家好，此文档由网络收集而来，欢迎您下载，谢谢’=======================获得汉字拼音Set d = 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:,-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:,-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,-10254Function g Dim a, i Dim b If num 0 And num 160 Then g = Chr Else If num -20319 Or num -10247 Then g = Else a = b = For i = - 1 To 0 Step -1 If a = num Then Exit For Next g = b End If End If End Function Function c Dim i c = For i = 1 To Len c = c g)) Next End Function’=======================获得汉字首字母Public Function getPYCharDim lChalChar = 65536 + AscIf Then getPYChar = AIf Then getPYChar = BIf Then getPYChar = CIf Then getPYChar = DIf Then getPYChar = EIf Then getPYChar = FIf ThengetPYChar = GIf Then getPYChar = HIf Then getPYChar = JIf Then getPYChar = KIf Then getPYChar = LIf Then getPYChar = MIf Then getPYChar = NIf Then getPYChar = OIf Then getPYChar = PIf Then getPYChar = QIf Then getPYChar = RIf Then getPYChar = SIf Then getPYChar = TIf Then getPYChar = WIf Then getPYChar = XIf Then getPYChar = YIf Then getPYChar = ZEnd FunctionPublic Function getPYFor i = 0 To Len - 1 getPY = getPY getPYChar)NextEnd Function’=======================获得汉字首字母)’=======================获得汉字拼音)各位读友大家好，此文档由网络收集而来，欢迎您下载，谢谢。
excel提取汉字首字母的公式
excel提取汉字首字母的公式Excel是一款功能强大的电子表格软件，广泛应用于数据分析、数据处理、数据可视化等各个领域。
在Excel中，提取汉字的首字母是一个常见的需求，可以通过公式来实现。
在Excel中，提取汉字首字母的公式为“=LEFT(A1,1)”（假设汉字所在单元格为A1）。
该公式的作用是提取单元格A1中汉字的首字母，并将结果显示在相应的单元格中。
需要注意的是，该公式只能提取汉字的首字母，对于其他字符或数字无效。
我们需要在Excel中输入一些包含汉字的文本。
假设我们在A列中输入了一些汉字，我们可以在B列中使用公式“=LEFT(A1,1)”来提取这些汉字的首字母。
通过拖动填充手柄，可以快速将公式应用到其他单元格中，实现批量提取汉字首字母的功能。
在实际使用过程中，我们可能会遇到一些问题。
首先，公式只能提取汉字的首字母，对于姓名等多音字的处理可能会出现误差。
其次，对于非汉字字符或数字，公式会返回空值。
因此，在使用公式提取汉字首字母时，需要注意文本的格式和内容。
除了使用公式，Excel还有其他方法来提取汉字首字母。
例如，可以使用VBA宏编程来实现该功能。
通过编写一段VBA代码，我们可以自定义提取汉字首字母的规则，并将结果显示在指定的单元格中。
这种方法更加灵活，可以根据具体需求进行定制。
总结起来，Excel提取汉字首字母的公式为“=LEFT(A1,1)”。
通过这个公式，我们可以快速提取汉字的首字母，并在其他单元格中显示结果。
在使用过程中，需要注意公式的适用范围和限制条件。
除了公式，我们还可以使用VBA宏编程来实现更加灵活的功能。
希望本文能够帮助读者理解和应用Excel提取汉字首字母的方法。
excel提取汉字的拼音首字母集锦
excel提取汉字的拼音首字母集锦方法一：（最完美的方法）如果你A列的汉字都在4个字符之内，那就在B列输入此公式：=LOOKUP(MID(A1,1,1),{"","";"吖","A";"八","B";"嚓","C";"咑","D";"鵽","E";"发","F";"猤","G";"铪","H";"夻","J";"咔","K";"垃","L";"嘸","M";"旀","N";"噢","O";"妑","P";"七","Q";"囕","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"})&LOOKUP(MID(A1,2,1),{"","";"吖","A";"八","B";"嚓","C";"咑","D";"鵽","E";"发","F";"猤","G";"铪","H";"夻","J";"咔","K";"垃","L";"嘸","M";"旀","N";"噢","O";"妑","P";"七","Q";"囕","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"})&LOOKUP(MID(A1,3,1),{"","";"吖","A";"八","B";"嚓","C";"咑","D";"鵽","E";"发","F";"猤","G";"铪","H";"夻","J";"咔","K";"垃","L";"嘸","M";"旀","N";"噢","O";"妑","P";"七","Q";"囕","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"})&LOOKUP(MID(A1,4,1),{"","";"吖","A";"八","B";"嚓","C";"咑","D";"鵽","E";"发","F";"猤","G";"铪","H";"夻","J";"咔","K";"垃","L";"嘸","M";"旀","N";"噢","O";"妑","P";"七","Q";"囕","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"})公式是长了一点，如果把{}里的数据定义为名称，可以转换更多的首字母具体方法：复制{}里的数据，插入-名称(或者按CTRL+F3)，定义名称，如图，定义“拼音”为名称，下面的“引用位置”的“=”号后面粘贴刚才复制的{}里的数据确定。
使用Excel快速获取姓名拼音
使用E x c e l快速获取姓名拼音The final edition was revised on December 14th, 2020.使用Excel快速获取姓名拼音召开会议或进行系统成员管理时，可能会需要批量获取姓名的汉语拼音，使用以下方法可以一劳永逸：1、新建一电子表格文件，内含两张表，一张命名为“转译”，一张命名为“资料”。
2、将以下内容粘至资料表的A1单元格（将会布满资料表的A1:B23单元格。
如果不好用鼠标选择，可将鼠标点在第一汉字前，按住Shift+向下键直到选完，然后按Ctrl+C复制，粘贴时右击鼠标后选择弹出的粘贴菜单的右侧那个去掉格式的按钮粘贴）吖 A八 B擦 C耷 D婀 E发 F噶G哈H肌J喀K垃L妈M拿N啪P期Q然R撒S塌T挖W西X压Y匝Z3、将以下资料粘至资料表的D1单元格（将会布满资料表的D1:E400单元格）吖 a安an肮ang凹ao八ba掰bai班ban邦bang包bao杯bei奔ben伻beng边bian 标biao 瘪bie 邠bin 冰bing 拨bo钸bu擦ca偲cai 参can 仓cang 糙cao 册ce参cen 噌ceng 叉cha 拆chai 觇chan 伥chang 抄chao 车che 抻chen 柽cheng充chong 抽chou 出chu欻chua 揣chuai 川chuan 窗chuang 吹chui 春chun 逴chuo 刺ci匆cong 凑cou粗cu汆cuan 崔cui村cun搓cuo咑da呆dai丹dan当dang 刀dao扽den 灯deng 氐di 嗲dia 掂dian 刁diao 爹die 丁ding 丢diu 东dong 兜dou 阇du 端duan 堆dui 吨dun 多duo 屙 e欸ei 奀en 鞥eng 儿er 发fa 帆fan飞fei 分fen 丰feng 佛fo缶fou 夫fu旮ga该gai 干gan 冈gang 皋gao 戈ge给gei 根gen 更geng 工gong 勾gou 估gu瓜gua 乖guai 关guan 光guang 归gui郭guo 哈ha孩hai 顸han 夯hang 蒿hao 呵he黑hei 痕hen 亨heng 轰hong 齁hou 乎hu花hua 怀huai 欢huan 肓huang 灰hui 昏hun 豁huo 几ji加jia 戋jian交jiao 节jie 巾jin 茎jing 垧jiong 纠jiu 居ju捐juan 撅jue 军jun 咔ka开kai 刊kan 康kang 尻kao 坷ke肯ken 阬keng 空kong 抠kou 刳ku夸kua 蒯kuai匡kuang 亏kui 坤kun 扩kuo 垃la来lai 兰lan 啷lang 捞lao 乐le勒lei 棱leng 黎li边lian 良liang 撩liao 咧lie 拎lin 令ling 溜liu 龙long 搂lou 撸lu抡lun 罗luo 驴lv 掠lve 妈ma 埋mai 嫚man 牤mang 猫mao 么me 没mei 闷men 蒙meng 咪mi 眠mian 喵miao 民min 名ming 谬miu 摸mo 哞mou 毪mu 那na囡nan 囊nang 孬nao 哪ne哪nei 恁nen 能neng 妮ni拈nian 酿niang 鸟niao 捏nie 您nin 宁ning 妞niu 农nong 耨nou 奴nu暖nuan 挪nuo 女nv疟nve 区ou拍pai 潘pan 乓pang 抛pao 呸pei 喷pen 烹peng 丕pi片pian 票piao 氕pie 拚pin 乒ping 钋po剖pou 仆pu七qi掐qia 千qian 强qiang 悄qiao 切qie 钦qin銎qiong 丘qiu 区qu悛quan 炔que 囷qun 蚺ran 嚷rang 饶rao 若re人ren 扔reng 日ri戎rong 柔rou 如ru阮ruan 蕤rui 闰run 若ruo 撒sa腮sai 三san搔sao色se森sen僧seng 杀sha筛shai 山shan 伤shang 捎shao 奢she申shen 升sheng 尸shi收shou 书shu刷shua 衰shuai 闩shuan 双shuang 谁shui 吮shun 说shuo 司si叟sou 苏su 狻suan 尿sui 孙sun 莎suo 他ta 台tai 坍tan 汤tang 涛tao 忑te 疼teng 体ti 天tian 佻tiao 帖tie 厅ting 恫tong 偷tou 凸tu 湍tuan 忒tui托tuo 挖wa歪wai 弯wan 汪wang 危wei 温wen 翁weng 挝wo乌wu夕xi虾xia 仙xian 乡xiang 肖xiao 些xie 心xin 兴xing 凶xiong 休xiu 需xu轩xuan 削xue丫ya 咽yan 央yang 幺yao 耶ye 一yi 因yin 应ying 庸yong 优you 迂yu 鸢yuan 曰yue 晕yun 扎za 灾zai 簪zan 赃zang 遭zao 则ze 贼zei 怎zen 曾zeng沾zhan 张zhang 钊zhao 折zhe这zhei 贞zhen 争zheng 之zhi中zhong 州zhou 朱zhu抓zhua 拽zhuai 专zhuan 庄zhuang 隹zhui 屯zhun 拙zhuo 孖zi宗zong 邹zou苴zu尊zun作zuo4、在将以下内容分别粘进转译表的A1～C1单元格中：姓名（2～4汉字，无空格）简拼全拼5、将以下公式粘进转译表的B2单元格并回车，以获得得姓名的简拼，注意不要多复制：=IF(LEN(A2)=2,LOOKUP(LEFT(A2,1),资料!$A$1:$B$23)&LOOKUP(RIGHT(A2,1),资料!$A$1:$B$23),IF(LEN(A2)=3,LOOKUP(LEFT(A2,1),资料!$A$1:$B$23)&LOOKUP(MID(A2,2,1),资料!$A$1:$B$23)&LOOKUP(RIGHT(A2,1),资料!$A$1:$B$23),IF(LEN(A2)=4,LOOKUP(LEFT(A2,1),资料!$A$1:$B$23)&LOOKUP(MID(A2,2,1),资料!$A$1:$B$23)&LOOKUP(MID(A2,3,1),资料!$A$1:$B$23)&LOOKUP(RIGHT(A2,1),资料!$A$1:$B$23),"请查检查姓名")))6、将以下公式粘进转译表的C2单元格并回车，以获得姓名的全拼：=IF(LEN(A2)=2,PROPER(LOOKUP(LEFT(A2,1),资料!$D$1:$E$400))&PROPER(LOOKUP(RIGHT(A2,1),资料!$D$1:$E$400)),IF(LEN(A2)=3,PROPER(LOOKUP(LEFT(A2,1),资料!$D$1:$E$400))&PROPER(LOOKUP(MID(A2,2,1),资料!$D$1:$E$400)),IF(LEN(A2)=4,PROPER(LOOKUP(LEFT(A2,1),资料!$D$1:$E$400))&PROPER(LOOKUP(MID(A2,2,1),资料!$D$1:$E$400))&PROPER(LOOKUP(MID(A2,3,1),资料!$D$1:$E$400))&PROPER(LOOKUP(RIGHT(A2,1),资料!$D$1:$E$400)),"请查检查姓名")))7、现在可以在A2开始的A列中输入汉字姓名了，最后根据需要向下填充公式即可。