皮皮网

1.EXCEL中能否直接把中文转换成拼音？
2.如何在excel中把汉字转换成拼音
3.已知关键词为26，公式公式17，源码源码19，使用12，公式公式23，源码源码34，使用航空订票网站源码24，公式公式25，源码源码30，使用34，公式公式
4.以一个实例说明在excel中根据A列汉字自动在B列生成拼音字母的源码源码方法

EXCEL中能否直接把中文转换成拼音？

       Excel内是可以把中文转换成为拼音的，但需要转换函数（函数可通过网络上面下载），使用下面给出具体操作方法：

       所需材料：Excel、公式公式准备好的源码源码中文转拼音函数。

       一、使用首先打开Excel软件，然后按Alt+F打开Viaual Basic编辑器，点击工具栏“插入”，选项内点击“模块”。

       二、这时把准备好的硬件家园源码载中文转拼音函数粘贴入该模块下，然后就可以关闭掉Viaual Basic编辑器。

       三、回到Excel界面在需要转换的单元格内输入中文转拼音的公式（这里需要根据下载的函数来输入对应的公式，如下图的公式为=pinyin，而有一些公式则为=getpy，注意公式不要用错），按下回车键即可得到公式内所求单元格的拼音。

       四、最后按住已转换完成单元格右下角向下拖动即可得到整列中文的拼音 。

如何在excel中把汉字转换成拼音

       利用EXCEl表格中的宝塔建站源码购买宏，轻松将汉字转换为拼音

       1.启动Excel （其它版本请仿照操作），打开相应的工作表；

       2.执行“工具→宏→Visual Basic编辑器”命令（或者直接按“Alt+F”组合键），进入Visual Basic编辑状态；

       3.执行“插入→模块”命令，插入一个新模块。再双击插入的模块，进入模块代码编辑状态；

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

       5.代码输入完成后，直接关闭Visual Basic编辑窗口，返回Excel编辑状态；

       6.自定义函数就可以用了，如：选中A2单元格，输入公式：=getpy(A2)。进口奶油溯源码

已知关键词为，，，，，，，，，，android源码解析九

       解：（1）先确定哈希表的长度：

       根据公式：α= n/m, （n为记录数，m为表长）可知因为α不小于0.，所以当记录数为时，可以设表长为，此时α的值为0.

       （2）根据关键字首字母的排序建立哈希表，若首字母相同则将第二个字母的排序加上，依次类推，易知

       可以转换为数字ZHAO = ；QIAN = ；SUN = ；LI = ；ZHOU = ；WU = ；

       ZHANG = ；WANG = ；CHANG = 3；CHAO = ；YANG = ；JIN =

       （3）

       增量di设为di = i((k)MOD+1

       H(key) = (3k)MOD

       易求得哈希表为：

       H() = ;

       H() = ;

       H() = ;

       H() =

       H() = 2;

       H() = 9;

       H() = 5;

       H() = ;

       H(3) = 9;H1(3) = 7;

       H() = ;

       H() = ;

       H() = ;

                                 

       平均查找长度：

       ASLsucc = (1×+2)/=/;

以一个实例说明在excel中根据A列汉字自动在B列生成拼音字母的方法

       下图所示的excel表格，A列是姓名列，根据A列的汉字姓名，自动在B列和C列分别自动生成姓名列的拼音字母。

       下面是小编整理出来的详细的操作步骤，分享给有需要的朋友。

       第一步，由于Excel中没有现成的函数套用可以解决此问题，首先自定义一个函数。方法如下：

       1. 运行“工具→宏→Visual Basic编辑器”命令（或者直接按“Alt+F”组合键），进入Visual Basic编辑状态。

       2. 运行“插入→模块”命令，插入一个新模块。再双击插入的模块，进入模块代码编辑状态。

       3. 将以下的代码输入其中，保存，关闭Visual Basic编辑窗口，返回Excel编辑状态。

       Function PinYin(Hz As String)

       Dim PinMa As String

       Dim MyPinMa As Variant

       Dim Temp As Integer, i As Integer, j As Integer

       PinMa = "a,,ai,,an,,ang,,ao,,"

       PinMa = PinMa & "ba,,bai,,ban,,bang,,bao,,bei,,ben,,beng,,bi,,bian,,biao,,bie,,bin,,bing,,bo,,bu,,"

       PinMa = PinMa & "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,,"

       PinMa = PinMa & "da,,dai,,dan,,dang,,dao,,de,,deng,,di,,dian,,diao,,die,,ding,,diu,,dong,,dou,,du,,duan,,dui,,dun,,duo,,"

       PinMa = PinMa & "e,,en,,er,,"

       PinMa = PinMa & "fa,,fan,,fang,,fei,,fen,,feng,,fo,,fou,,fu,,"

       PinMa = PinMa & "ga,,gai,,gan,,gang,,gao,,ge,,gei,,gen,,geng,,gong,,gou,,gu,,gua,,guai,,guan,,guang,,gui,,gun,,guo,,"

       PinMa = PinMa & "ha,,hai,,han,,hang,,hao,,he,,hei,,hen,,heng,,hong,,hou,,hu,,hua,,huai,,huan,,huang,,hui,,hun,,huo,,"

       PinMa = PinMa & "ji,,jia,,jian,,jiang,,jiao,,jie,,jin,,jing,,jiong,,jiu,,ju,,juan,,jue,,jun,,"

       PinMa = PinMa & "ka,,kai,,kan,,kang,,kao,,ke,,ken,,keng,,kong,,kou,,ku,,kua,,kuai,,kuan,,kuang,,kui,,kun,,kuo,,"

       PinMa = PinMa & "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,,"

       PinMa = PinMa & "ma,,mai,,man,,mang,,mao,,me,,mei,,men,,meng,,mi,,mian,,miao,,mie,,min,,ming,,miu,,mo,,mou,,mu,,"

       PinMa = PinMa & "na,,nai,,nan,,nang,,nao,,ne,,nei,,nen,,neng,,ni,,nian,,niang,,niao,,nie,,nin,,ning,,niu,,nong,,nu,,nv,,nuan,,nue,,nuo,,"

       PinMa = PinMa & "o,,ou,,"

       PinMa = PinMa & "pa,,pai,,pan,,pang,,pao,,pei,,pen,,peng,,pi,,pian,,piao,,pie,,pin,,ping,,po,,pu,,"

       PinMa = PinMa & "qi,,qia,,qian,,qiang,,qiao,,qie,,qin,,qing,,qiong,,qiu,,qu,,quan,,que,,qun,,"

       PinMa = PinMa & "ran,,rang,,rao,,re,,ren,,reng,,ri,,rong,,rou,,ru,,ruan,,rui,,run,,ruo,,"

       PinMa = PinMa & "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,,"

       PinMa = PinMa & "ta,,tai,,tan,,tang,,tao,,te,,teng,,ti,,tian,,tiao,,tie,,ting,,tong,,tou,,tu,,tuan,,tui,,tun,,tuo,,"

       PinMa = PinMa & "wa,,wai,,wan,,wang,,wei,,wen,,weng,,wo,,wu,,"

       PinMa = PinMa & "xi,,xia,,xian,,xiang,,xiao,,xie,,xin,,xing,,xiong,,xiu,,xu,,xuan,,xue,,xun,,"

       PinMa = PinMa & "ya,,yan,,yang,,yao,,ye,,yi,,yin,,ying,,yo,,yong,,you,,yu,,yuan,,yue,,yun,,"

       PinMa = PinMa & "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,"

       MyPinMa = Split(PinMa, ",")

       For i = 1 To Len(Hz)

       Temp = Asc(Mid(Hz, i, 1))

           If Temp < 0 Then

             Temp = Abs(Temp)

             For j = To 1 Step -2

                 If Temp <= Val(MyPinMa(j)) Then

                     PinYin = PinYin & MyPinMa(j - 1) & " "

                     Exit For

                 End If

             Next

           End If

       Next

       PinYin = Trim(PinYin)

       End Function

       第二步，在空白列，比如F2单元格，输入公式：=PinYin(A2)，就可以在F2单元格得到A2单元格汉字的拼音。然后下拉复制完成A列所有的汉字转拼音。

       提示：公式中的“PinYin”就是第一步自定义函数的名称。

       第三步，在B2单元格输入公式：=LEFT(F2,FIND(" ",F2)-1)，就可以提取出F2单元格中的第一个汉字的拼音。然后下拉复制完成A列中汉字“姓”的拼音提取。

       第四步，在C2单元格输入公式：=TRIM(SUBSTITUTE(F2,B2,""))，即可得到剩余的“名”字部分的汉字的拼音。下拉复制公式。

       第五步，如果需要拼音的首字母大写，可以再用PROPER函数来转换一下。最终完成的效果如下图所示。