查看: 1234|回复: 19
姓名转拼音
阅读权限20
在线时间 小时
& & & & & & & &
各位大侠，
我有些邮件中需要用到一些姓名拼音，不太符合常规，因此求助各位姓名怎么以下面形式转变拼音
张三，转变为“san.zhang”，
王二麻，转变为“erma.wang”
即姓在后，名在前，中间用点隔开，都是小写
多谢各位了
阅读权限95
在线时间 小时
输入函数公式即可
(28.86 KB, 下载次数: 111)
19:33 上传
点击文件名下载附件
阅读权限95
在线时间 小时
& & & & & & & &
Function pinyin(p As String) As String
i = Asc(p)
Select Case i
Case -20319 To -20318: pinyin = &a&
Case -20317 To -20305: pinyin = &ai&
Case -20304 To -20296: pinyin = &an&
Case -20295 To -20293: pinyin = &ang&
Case -20292 To -20284: pinyin = &ao&
Case -20283 To -20266: pinyin = &ba&
Case -20265 To -20258: pinyin = &bai&
Case -20257 To -20243: pinyin = &ban&
Case -20242 To -20231: pinyin = &bang&
Case -20230 To -20052: pinyin = &bao&
Case -20051 To -20037: pinyin = &bei&
Case -20036 To -20033: pinyin = &ben&
Case -20032 To -20027: pinyin = &beng&
Case -20026 To -20003: pinyin = &bi&
Case -20002 To -19991: pinyin = &bian&
Case -19990 To -19987: pinyin = &biao&
Case -19986 To -19983: pinyin = &bie&
Case -19982 To -19977: pinyin = &bin&
Case -19976 To -19806: pinyin = &bing&
Case -19805 To -19785: pinyin = &bo&
Case -19784 To -19776: pinyin = &bu&
Case -19775 To -19775: pinyin = &ca&
Case -19774 To -19764: pinyin = &cai&
Case -19763 To -19757: pinyin = &can&
Case -19756 To -19752: pinyin = &cang&
Case -19751 To -19747: pinyin = &cao&
Case -19746 To -19742: pinyin = &ce&
Case -19741 To -19740: pinyin = &ceng&
Case -19739 To -19729: pinyin = &cha&
Case -19728 To -19726: pinyin = &chai&
Case -19725 To -19716: pinyin = &chan&
Case -19715 To -19541: pinyin = &chang&
Case -19540 To -19532: pinyin = &chao&
Case -19531 To -19526: pinyin = &che&
Case -19525 To -19516: pinyin = &chen&
Case -19515 To -19501: pinyin = &cheng&
Case -19500 To -19485: pinyin = &chi&
Case -19484 To -19480: pinyin = &chong&
Case -19479 To -19468: pinyin = &chou&
Case -19467 To -19290: pinyin = &chu&
Case -19289 To -19289: pinyin = &chuai&
Case -19288 To -19282: pinyin = &chuan&
Case -19281 To -19276: pinyin = &chuang&
Case -19275 To -19271: pinyin = &chui&
Case -19270 To -19264: pinyin = &chun&
Case -19263 To -19262: pinyin = &chuo&
Case -19261 To -19250: pinyin = &ci&
Case -19249 To -19244: pinyin = &cong&
Case -19243 To -19243: pinyin = &cou&
Case -19242 To -19239: pinyin = &cu&
Case -19238 To -19236: pinyin = &cuan&
Case -19235 To -19228: pinyin = &cui&
Case -19227 To -19225: pinyin = &cun&
Case -19224 To -19219: pinyin = &cuo&
Case -19218 To -19213: pinyin = &da&
Case -19212 To -19039: pinyin = &dai&
Case -19038 To -19024: pinyin = &dan&
Case -19023 To -19019: pinyin = &dang&
Case -19018 To -19007: pinyin = &dao&
Case -19006 To -19004: pinyin = &de&
Case -19003 To -18997: pinyin = &deng&
Case -18996 To -18978: pinyin = &di&
Case -18977 To -18962: pinyin = &dian&
Case -18961 To -18953: pinyin = &diao&
Case -18952 To -18784: pinyin = &die&
Case -18783 To -18775: pinyin = &ding&
Case -18774 To -18774: pinyin = &diu&
Case -18773 To -18527: pinyin = &dong&
Case -18526 To -18519: pinyin = &fa&
Case -18518 To -18502: pinyin = &fan&
Case -18501 To -18491: pinyin = &fang&
Case -18490 To -18479: pinyin = &fei&
Case -18478 To -18464: pinyin = &fen&
Case -18463 To -18449: pinyin = &feng&
Case -18448 To -18448: pinyin = &fo&
Case -18447 To -18447: pinyin = &fou&
Case -18446 To -18240: pinyin = &fu&
Case -18239 To -18238: pinyin = &ga&
Case -18237 To -18232: pinyin = &gai&
Case -18231 To -18221: pinyin = &gan&
Case -18220 To -18212: pinyin = &gang&
Case -18211 To -18202: pinyin = &gao&
Case -18201 To -18185: pinyin = &ge&
Case -18184 To -18184: pinyin = &gei&
Case -18183 To -18182: pinyin = &gen&
Case -18181 To -18013: pinyin = &geng&
Case -18012 To -17998: pinyin = &gong&
Case -17997 To -17989: pinyin = &gou&
Case -17988 To -17971: pinyin = &gu&
Case -17970 To -17965: pinyin = &gua&
Case -17964 To -17962: pinyin = &guai&
Case -17961 To -17951: pinyin = &guan&
Case -17950 To -17948: pinyin = &guang&
Case -17947 To -17932: pinyin = &gui&
Case -17931 To -17929: pinyin = &gun&
Case -17928 To -17923: pinyin = &guo&
Case -17922 To -17760: pinyin = &ha&
Case -17759 To -17753: pinyin = &hai&
Case -17752 To -17734: pinyin = &han&
Case -17733 To -17731: pinyin = &hang&
Case -17730 To -17722: pinyin = &hao&
Case -17721 To -17704: pinyin = &he&
Case -17703 To -17702: pinyin = &hei&
Case -17701 To -17698: pinyin = &hen&
Case -17697 To -17693: pinyin = &heng&
Case -17692 To -17684: pinyin = &hong&
Case -17683 To -17677: pinyin = &hou&
Case -17676 To -17497: pinyin = &hu&
Case -17496 To -17488: pinyin = &hua&
Case -17487 To -17483: pinyin = &huai&
Case -17482 To -17469: pinyin = &huan&
Case -17468 To -17455: pinyin = &huang&
Case -17454 To -17434: pinyin = &hui&
Case -17433 To -17428: pinyin = &hun&
Case -17427 To -17418: pinyin = &huo&
Case -17417 To -17203: pinyin = &ji&
Case -17202 To -17186: pinyin = &jia&
Case -17185 To -16984: pinyin = &jian&
Case -16983 To -16971: pinyin = &jiang&
Case -16970 To -16943: pinyin = &jiao&
Case -16942 To -16916: pinyin = &jie&
Case -16915 To -16734: pinyin = &jin&
Case -16733 To -16709: pinyin = &jing&
Case -16708 To -16707: pinyin = &jiong&
Case -16706 To -16690: pinyin = &jiu&
Case -16689 To -16665: pinyin = &ju&
Case -16664 To -16658: pinyin = &juan&
Case -16657 To -16648: pinyin = &jue&
Case -16647 To -16475: pinyin = &jun&
Case -16474 To -16471: pinyin = &ka&
Case -16470 To -16466: pinyin = &kai&
Case -16465 To -16460: pinyin = &kan&
Case -16459 To -16453: pinyin = &kang&
Case -16452 To -16449: pinyin = &kao&
Case -16448 To -16434: pinyin = &ke&
Case -16433 To -16430: pinyin = &ken&
Case -16429 To -16428: pinyin = &keng&
Case -16427 To -16424: pinyin = &kong&
Case -16423 To -16420: pinyin = &kou&
Case -16419 To -16413: pinyin = &ku&
Case -16412 To -16408: pinyin = &kua&
Case -16407 To -16404: pinyin = &kuai&
Case -16403 To -16402: pinyin = &kuan&
Case -16401 To -16394: pinyin = &kuang&
Case -16393 To -16221: pinyin = &kui&
Case -16220 To -16217: pinyin = &kun&
Case -16216 To -16213: pinyin = &kuo&
Case -16212 To -16206: pinyin = &la&
Case -16205 To -16203: pinyin = &lai&
Case -16202 To -16188: pinyin = &lan&
Case -16187 To -16181: pinyin = &lang&
Case -16180 To -16172: pinyin = &lao&
Case -16171 To -16170: pinyin = &le&
Case -16169 To -16159: pinyin = &lei&
Case -16158 To -16156: pinyin = &leng&
Case -16155 To -15960: pinyin = &li&
Case -15959 To -15959: pinyin = &lia&
Case -15958 To -15945: pinyin = &lian&
Case -15944 To -15934: pinyin = &liang&
Case -15933 To -15921: pinyin = &liao&
复制代码
阅读权限95
在线时间 小时
代码接上面
Case -15920 To -15916: pinyin = &lie&
Case -15915 To -15904: pinyin = &lin&
Case -15903 To -15890: pinyin = &ling&
Case -15889 To -15879: pinyin = &liu&
Case -15878 To -15708: pinyin = &long&
Case -15707 To -15702: pinyin = &lou&
Case -15701 To -15682: pinyin = &lu&
Case -15681 To -15668: pinyin = &lv&
Case -15667 To -15662: pinyin = &luan&
Case -15661 To -15660: pinyin = &lue&
Case -15659 To -15653: pinyin = &lun&
Case -15652 To -15641: pinyin = &luo&
Case -15640 To -15632: pinyin = &ma&
Case -15631 To -15626: pinyin = &mai&
Case -15625 To -15455: pinyin = &man&
Case -15454 To -15449: pinyin = &mang&
Case -15448 To -15437: pinyin = &mao&
Case -15436 To -15436: pinyin = &me&
Case -15435 To -15420: pinyin = &mei&
Case -15419 To -15417: pinyin = &men&
Case -15416 To -15409: pinyin = &meng&
Case -15408 To -15395: pinyin = &mi&
Case -15394 To -15386: pinyin = &mian&
Case -15385 To -15378: pinyin = &miao&
Case -15377 To -15376: pinyin = &mie&
Case -15375 To -15370: pinyin = &min&
Case -15369 To -15364: pinyin = &ming&
Case -15363 To -15363: pinyin = &miu&
Case -15362 To -15184: pinyin = &mo&
Case -15183 To -15181: pinyin = &mou&
Case -15180 To -15166: pinyin = &mu&
Case -15165 To -15159: pinyin = &na&
Case -15158 To -15154: pinyin = &nai&
Case -15153 To -15151: pinyin = &nan&
Case -15150 To -15150: pinyin = &nang&
Case -15149 To -15145: pinyin = &nao&
Case -15144 To -15144: pinyin = &ne&
Case -15143 To -15142: pinyin = &nei&
Case -15141 To -15141: pinyin = &nen&
Case -15140 To -15140: pinyin = &neng&
Case -15139 To -15129: pinyin = &ni&
Case -15128 To -15122: pinyin = &nian&
Case -15121 To -15120: pinyin = &niang&
Case -15119 To -15118: pinyin = &niao&
Case -15117 To -15111: pinyin = &nie&
Case -15110 To -15110: pinyin = &nin&
Case -15109 To -14942: pinyin = &ning&
Case -14941 To -14938: pinyin = &niu&
Case -14937 To -14934: pinyin = &nong&
Case -14933 To -14931: pinyin = &nu&
Case -14930 To -14930: pinyin = &nv&
Case -14929 To -14929: pinyin = &nuan&
Case -14928 To -14927: pinyin = &nue&
Case -14926 To -14923: pinyin = &nuo&
Case -14922 To -14922: pinyin = &o&
Case -14921 To -14915: pinyin = &ou&
Case -14914 To -14909: pinyin = &pa&
Case -14908 To -14903: pinyin = &pai&
Case -14902 To -14895: pinyin = &pan&
Case -14894 To -14890: pinyin = &pang&
Case -14889 To -14883: pinyin = &pao&
Case -14882 To -14874: pinyin = &pei&
Case -14873 To -14872: pinyin = &pen&
Case -14871 To -14858: pinyin = &peng&
Case -14857 To -14679: pinyin = &pi&
Case -14678 To -14675: pinyin = &pian&
Case -14674 To -14671: pinyin = &piao&
Case -14670 To -14669: pinyin = &pie&
Case -14668 To -14664: pinyin = &pin&
Case -14663 To -14655: pinyin = &ping&
Case -14654 To -14646: pinyin = &po&
Case -14645 To -14631: pinyin = &pu&
Case -14630 To -14595: pinyin = &qi&
Case -14594 To -14430: pinyin = &qia&
Case -14429 To -14408: pinyin = &qian&
Case -14407 To -14400: pinyin = &qiang&
Case -14399 To -14385: pinyin = &qiao&
Case -14384 To -14380: pinyin = &qie&
Case -14379 To -14369: pinyin = &qin&
Case -14368 To -14356: pinyin = &qing&
Case -14355 To -14354: pinyin = &qiong&
Case -14353 To -14346: pinyin = &qiu&
Case -14345 To -14171: pinyin = &qu&
Case -14170 To -14160: pinyin = &quan&
Case -14159 To -14152: pinyin = &que&
Case -14151 To -14150: pinyin = &qun&
Case -14149 To -14146: pinyin = &ran&
Case -14145 To -14141: pinyin = &rang&
Case -14140 To -14138: pinyin = &rao&
Case -14137 To -14136: pinyin = &re&
Case -14135 To -14126: pinyin = &ren&
Case -14125 To -14124: pinyin = &reng&
Case -14123 To -14123: pinyin = &ri&
Case -14122 To -14113: pinyin = &rong&
Case -14112 To -14110: pinyin = &rou&
Case -14109 To -14100: pinyin = &ru&
Case -14099 To -14098: pinyin = &ruan&
Case -14097 To -14095: pinyin = &rui&
Case -14094 To -14093: pinyin = &run&
Case -14092 To -14091: pinyin = &ruo&
Case -14090 To -14088: pinyin = &sa&
Case -14087 To -14084: pinyin = &sai&
Case -14083 To -13918: pinyin = &san&
Case -13917 To -13915: pinyin = &sang&
Case -13914 To -13911: pinyin = &sao&
Case -13910 To -13908: pinyin = &se&
Case -13907 To -13907: pinyin = &sen&
Case -13906 To -13906: pinyin = &seng&
Case -13905 To -13897: pinyin = &sha&
Case -13896 To -13895: pinyin = &shai&
Case -13894 To -13879: pinyin = &shan&
Case -13878 To -13871: pinyin = &shang&
Case -13870 To -13860: pinyin = &shao&
Case -13859 To -13848: pinyin = &she&
Case -13847 To -13832: pinyin = &shen&
Case -13831 To -13659: pinyin = &sheng&
Case -13658 To -13612: pinyin = &shi&
Case -13611 To -13602: pinyin = &shou&
Case -13601 To -13407: pinyin = &shu&
Case -13406 To -13405: pinyin = &shua&
Case -13404 To -13401: pinyin = &shuai&
Case -13400 To -13399: pinyin = &shuan&
Case -13398 To -13396: pinyin = &shuang&
Case -13395 To -13392: pinyin = &shui&
Case -13391 To -13388: pinyin = &shun&
Case -13387 To -13384: pinyin = &shuo&
Case -13383 To -13368: pinyin = &si&
Case -13367 To -13360: pinyin = &song&
Case -13359 To -13357: pinyin = &sou&
Case -13356 To -13344: pinyin = &su&
Case -13343 To -13341: pinyin = &suan&
Case -13340 To -13330: pinyin = &sui&
Case -13329 To -13327: pinyin = &sun&
Case -13326 To -13319: pinyin = &suo&
Case -13318 To -13148: pinyin = &ta&
Case -13147 To -13139: pinyin = &tai&
Case -13138 To -13121: pinyin = &tan&
Case -13120 To -13108: pinyin = &tang&
Case -13107 To -13097: pinyin = &tao&
Case -13096 To -13096: pinyin = &te&
Case -13095 To -13092: pinyin = &teng&
Case -13091 To -13077: pinyin = &ti&
Case -13076 To -13069: pinyin = &tian&
Case -13068 To -13064: pinyin = &tiao&
Case -13063 To -13061: pinyin = &tie&
Case -13060 To -12889: pinyin = &ting&
Case -12888 To -12876: pinyin = &tong&
Case -12875 To -12872: pinyin = &tou&
Case -12871 To -12861: pinyin = &tu&
Case -12860 To -12859: pinyin = &tuan&
Case -12858 To -12853: pinyin = &tui&
Case -12852 To -12850: pinyin = &tun&
Case -12849 To -12839: pinyin = &tuo&
Case -12838 To -12832: pinyin = &wa&
Case -12831 To -12830: pinyin = &wai&
Case -12829 To -12813: pinyin = &wan&
Case -12812 To -12803: pinyin = &wang&
Case -12802 To -12608: pinyin = &wei&
Case -12607 To -12598: pinyin = &wen&
Case -12597 To -12595: pinyin = &weng&
Case -12594 To -12586: pinyin = &wo&
Case -12585 To -12557: pinyin = &wu&
Case -12556 To -12360: pinyin = &xi&
Case -12359 To -12347: pinyin = &xia&
Case -12346 To -12321: pinyin = &xian&
Case -12320 To -12301: pinyin = &xiang&
Case -12300 To -12121: pinyin = &xiao&
Case -12120 To -12100: pinyin = &xie&
Case -12099 To -12090: pinyin = &xin&
Case -12089 To -12075: pinyin = &xing&
Case -12074 To -12068: pinyin = &xiong&
Case -12067 To -12059: pinyin = &xiu&
Case -12058 To -12040: pinyin = &xu&
Case -12039 To -11868: pinyin = &xuan&
Case -11867 To -11862: pinyin = &xue&
Case -11861 To -11848: pinyin = &xun&
Case -11847 To -11832: pinyin = &ya&
Case -11831 To -11799: pinyin = &yan&
Case -11798 To -11782: pinyin = &yang&
Case -11781 To -11605: pinyin = &yao&
Case -11604 To -11590: pinyin = &ye&
Case -11589 To -11537: pinyin = &yi&
Case -11536 To -11359: pinyin = &yin&
Case -11358 To -11341: pinyin = &ying&
Case -11340 To -11340: pinyin = &yo&
Case -11339 To -11325: pinyin = &yong&
Case -11324 To -11304: pinyin = &you&
Case -11303 To -11098: pinyin = &yu&
Case -11097 To -11078: pinyin = &yuan&
Case -11077 To -11068: pinyin = &yue&
Case -11067 To -11056: pinyin = &yun&
Case -11055 To -11053: pinyin = &za&
Case -11052 To -11046: pinyin = &zai&
Case -11045 To -11042: pinyin = &zan&
Case -11041 To -11039: pinyin = &zang&
Case -11038 To -11025: pinyin = &zao&
Case -11024 To -11021: pinyin = &ze&
Case -11020 To -11020: pinyin = &zei&
Case -11019 To -11019: pinyin = &zen&
Case -11018 To -11015: pinyin = &zeng&
Case -11014 To -10839: pinyin = &zha&
Case -10838 To -10833: pinyin = &zhai&
Case -10832 To -10816: pinyin = &zhan&
Case -10815 To -10801: pinyin = &zhang&
Case -10800 To -10791: pinyin = &zhao&
Case -10790 To -10781: pinyin = &zhe&
Case -10780 To -10765: pinyin = &zhen&
Case -10764 To -10588: pinyin = &zheng&
Case -10587 To -10545: pinyin = &zhi&
Case -10544 To -10534: pinyin = &zhong&
Case -10533 To -10520: pinyin = &zhou&
Case -10519 To -10332: pinyin = &zhu&
Case -10331 To -10330: pinyin = &zhua&
Case -10329 To -10329: pinyin = &zhuai&
Case -10328 To -10323: pinyin = &zhuan&
Case -10322 To -10316: pinyin = &zhuang&
Case -10315 To -10310: pinyin = &zhui&
Case -10309 To -10308: pinyin = &zhun&
Case -10307 To -10297: pinyin = &zhuo&
Case -10296 To -10282: pinyin = &zi&
Case -10281 To -10275: pinyin = &zong&
Case -10274 To -10271: pinyin = &zou&
Case -10270 To -10263: pinyin = &zu&
Case -10262 To -10261: pinyin = &zuan&
Case -10260 To -10257: pinyin = &zui&
Case -10256 To -10255: pinyin = &zun&
Case -10254 To -10254: pinyin = &zuo&
Case Else: pinyin = p
End Select
End Function
Function getname(str As String)
& & Dim i%, str1$
& & str1 = pinyin(Mid(str, 1, 1))
& & For i = 2 To Len(str)
& && &&&getname = getname & pinyin(Mid(str, i, 1))
& & Next
& & getname = getname & &.& & str1
End Function复制代码
阅读权限95
在线时间 小时
& & & & & & & &
自定义函数用法，复制以上239行代码到工作簿模块当中
然后在任意单元格输入诸如：
=getname(&张三丰&)&&函数自动返回&&sanfeng.zhang
或者假如A1=&李四&& &在B1当中输入公式=getname(A1)&&回车即可
阅读权限20
在线时间 小时
自定义函数用法，复制以上239行代码到工作簿模块当中
然后在任意单元格输入诸如：
=getname(&张三丰&)& &...
可以弄成excel形式吗？不知道是哪出问题了，在我电脑上生成不了
阅读权限95
在线时间 小时
可以弄成excel形式吗？不知道是哪出问题了，在我电脑上生成不了
亲，这就是excel VBA代码啊，是自定义函数
阅读权限30
在线时间 小时
输入函数公式即可
QQ图片48.png (6.66 KB, 下载次数: 33)
19:49 上传
老师这个错的
哈哈，你也发现了啊。。。比我早一楼。
阅读权限90
在线时间 小时
可以弄成excel形式吗？不知道是哪出问题了，在我电脑上生成不了
不适合生僻字的，
=getname(&陈钰琦&)&&结果将会是 “钰琦.chen”
阅读权限90
在线时间 小时
代码接上面
很伟大的代码，可惜有些字没有，比如 =getname(&陈钰琦&) =& “钰琦.chen”
最新热点 /1
ExcelHome每周都有线上直播公开课，
国内一流讲师真身分享，高手贴身答疑，
赶不上直播还能看录像，
关键居然是免费的！
厚木哥们都已经这么努力了，
你还好意思说学不好Office。
玩命加载中，请稍候
玩命加载中，请稍候
Powered by
本论坛言论纯属发表者个人意见，任何违反国家相关法律的言论，本站将协助国家相关部门追究发言者责任！ & & 本站特聘法律顾问：徐怀玉律师 李志群律师博客访问： 529124
博文数量： 142
博客积分： 8196
博客等级： 中将
技术积分： 1350
注册时间：
IT168企业级官微
微信号：IT168qiye
系统架构师大会
微信号：SACC2013
分类： LINUX
刚刚在网上看了篇文章，老外写的，介绍了几种自由软件的名字发音，总结一下与大家分享。
GNU/Linux： 可能很多人都不知道GNU的发音，因而直接读成G-N-U，实际上根据GNU官方网站的说法， GNU应该发成guh-Noo，类似于‘伽努’的发音。至于Linux，发音就千奇百怪了，主要的差别在于字母u的读音上。这个u呢，有发成‘衣’的，有发成‘优’的，发成‘乌’，有发成‘er’的，还有发成‘a’的，我听到的发‘衣’和‘乌’的比较多，其他的基本没听到过。那么这个Linux到底怎么读，还是来听听Torvalds自己的读音：
这里是mp3: &
他说：Hello, I am Linus Torvalds, I pronounce Linux as Linux.
我听了好几遍，应该是发成类似‘er’的音（就是bonus这个词里的u的发音），所以Linux应该读成‘李呢克斯’
SUSE: Novell的发行版，以“易使用，难发音”著名。这个也是比较混乱的那种，怎么读的都有，来个权威的吧：来自Novell的发音 —— Soo-suh（苏塞？？苏瑟？？苏撒？？反正不是苏西）
Ubuntu: 最流行的发行版，我估计没几个中国人会念这个词。来自Ubuntu父公司的Marlize Coetzee说：“Ubuntu，来自非洲祖鲁族(Zulu)和克萨族(Xhosa)人的单词，读成oo-boon-too(乌奔突)”
Debian： 好像很多人（包括我）都读成“地被恩”，但事实并非如此，这个看起来很有异国情调的词语实际的来源很简单，就是两个人名的连接 —— Deb 和 Ian，所以，正确的读法是DEB-ee-un
Azureus: 如何读这个著名的BT客户端软件的名字一直都是人们争论的焦点，Azureus官方声明此单词没有官方读音，但是他们建议读成uh-Zoo-ree-us
Liferea: 这个著名的RSS阅读器的名字来自如下缩写：LInux FEed REAder。该项目的领导者Lars Lindner说：“我，一个德国人，这样读这个名字的'lee-fer-rejah'（注：本人学过一点德语，所以发音肯定是‘丽菲雷亚’，很美的名字啊）。但是我想很多英语国家的人会发另外一种很不同的音，因此该单词没有官方读音”
QT:& 这个非常有意思，很多人都读成字母Q-T，但是奇趣公司给的官方读音是Cute，怪不得QT做出来的界面如此可爱呢
阅读(2953) | 评论(2) | 转发(0) |
相关热门文章
给主人留下些什么吧！~~
对！剩下的就听我的了，肯定没错
Linux的读音我早知道了~Ubuntu的读音我也知道。剩下的……就听你说的了……
请登录后评论。我习惯用outlook来管理通讯录，并通过导入功能将EXcel版的通讯录全部导入outlook中，在我的outlook中有1484个联系人的信息,我还将这些联系人信息同步到智能手机中。这么多的联系人，查找是非常麻烦的事。前两天，从网络上查找到电话本姓名完美转拼音缩写的Excel程序，经过操作，已经成功地将1484个联系人姓名全部转拼音缩写。现在，无论在outlook中还是在智能手机中查找联系人都非常地方便，推荐大家使用，具体程序详见附件。有一位网友写了详细的过程，现分享如下(过程有些复杂，请仔细看)：下面我就将我自己的Outlook电话本转成带拼音首字母的过程作一个简单的介绍，重点讲一下处理过程中的注意事项。前提：1、你熟悉Outlook联系人方面的有关操作，能够熟练的将Outlook电话本与智能手机进行同步，不熟悉的看有关教程。2、由于要用Excel来处理电话本，不可避免的会出现电话号码变成数字的科学计数法表示以及丢失区号前面的0等现象，因此，在用Excel打开导出的电话本之前，一定要对电话号码进行简单的处理，防止电话号码变成数字。推荐的处理方法（银行帐号等数字格式的文本也遵循这个原则）：1)将电话号码中加上－这样的英文符号，如变成。2) 对于带区号的电话号码，如可以写成这种形式：(010)。3) 对于+2这种带国家号的电话号码最好变成(+86)139-这种格式。最简单的处理办法就是在导出CSV文件之后，用UltraEdit（简称UE，一款编辑软件，可以到网络中查找）的正则表达式将所有的数字前面加上几个#号，这样号码就不会被Excel处理成数字了，然后被Excel处理完成后，再使用UE，将所有的#号替换为无。UE正则表达式替换的使用方法：首先，设置UE使用Unix形式的正则表达式（在高级-&配置-&查找中设置），我使用的是UE 10.10c。查找：&([+0-9])([0-9]*)&替换为：&###\1\2&注意，上面的符号均为半角，对于直接阅读本文件的人来说&&和&&是论坛里用于加粗的代码，不在查找替换范围之内。 待用Excel处理完导出文件（加上拼音简写之后），再用UE将所有的###替换为空即可（不需要再使用正则表达式了，这也是为什么使用三个#号的原因）。特别注意：无论下面的处理过程如何，务必备份好你的原始Outlook个人文件夹文件。备份方法很简单，关闭Outlook，然后复制一份对应的.pst文件到另一个地方就行了。Outlook电话本到Excel再转回Outlook的大致步骤如下：1、首先，将Outlook的电话本导出成用&,&（半角逗号）分隔的CSV文件。我用的是Outlook 2000，也就是Office 2000中自带的Outlook。打开Outlook，选择&联系人&，然后从Outlook的菜单依次&文件 -& 导入和导出 -& 导出到一个文件 -& 以逗号为分隔符(Windows) -& 选择导出文件 -& 映射自定义字段&，到这里需要注意：1) Outlook默认的字段映射中，姓名这一部分是很复杂的，分为&英文称谓、名、中间名、姓、中文称谓&五个字段，其中的名对应智能手机上的名字，姓对应智能手机上的姓氏。如果导出这一部分，取决于你想把电话本处理成什么形式，也别指望这个过程可以一步到位。有的人在Outlook中输入联系人时是按照姓、名分别输入成两个字段的，有人干脆就是将姓名全部输入到&姓&或者&名&一个字段中，还有的在&姓&字段中对联系人进行分类，将联系人的名字输入到&名&字段中（一般中国人没有习惯使用中间名这东西），例如：&同事，张三&，&同事，李四&，&同学，王五&等等。再一个就是生成的拼音简写放到什么位置的问题，我提供的这个Excel程序支持两种生成方式：一种是与姓名合并成一列的，例如&张三zs&，&李四ls&，另一种是单列存放的，也就是&张三&和对应的&zs&分别各占一列。我的实践是将生成的拼音简写放到姓名的前边。 2) 我个人推荐的方式：无论你原来是如何填写姓名的，将姓名合并成一个字段，也就是要么将所有汉字放到&姓&中，要么将所有的汉字放到&名&中，而另一个空出来的字段单独存放对应汉字的拼音缩写。这样的优点是显而易见的，最主要的是易于维护，现在大部分的手机电话本都与Outlook兼容，姓、名这两个字段也没有明显的长度限制。怎么将原来分开的姓、名两个字段合并成一个&姓名&字段呢？很简单，在Outlook导出过程中上面的字段映射部分，Outlook会自动将前面的&英文称谓、名、中间名、姓、中文称谓&五个字段合并出一个&姓名&字段，加入这个字段（从左拖到右），你的导出表中就多出了这个合并后的&姓名&字段，然后在Excel中将它复制、粘贴到&姓&或者&名&字段中就很简单了。总之，既然outlook提供了字段映射功能，你自己该怎么处理自己的电话本就由自己决定了。我的处理过程是导出了两次，第一次导出合并的姓名字段，第二次按默认的字段映射导出，然后将第一次导出的&姓名&替换掉第二次导出的&姓&字段（在Excel中操作），而将生成的拼音简写替换掉&名&字段。2、对导出的CSV文件使用UE进行前面所述的替换处理，防止文本变数字。3、用Excel文件直接打开CSV文件，同时打开上面下载的压缩包中提供的&姓名添加拼音缩写xyf.xls&Excel转换程序，由于这个Excel转换程序使用了宏，因此，你要将Excel的宏安全性设置为&中&及以下级别，在打开时选择&启用宏&。然后将CSV文件中的&姓名&字段（也就是需要加拼音缩写的汉字部分，可以带有英文及其它符号，程序会只处理汉字）复制、粘贴到Excel转换程序的Sheet1的A列中。4、单击转换程序&Sheet1&中的&开始编辑&按钮，首先提示你将生成的拼音缩写放到什么位置，按自己的需要选择，我建议是单独成列，然后开始转换过程，转换过程中会提示多音字，按需要选择即可（程序会自动统计多音字中某个字的首字母的出现数量并记录到sheet2中，按数量多少优先选择多的那个，还是比较智能的），直到转换完成，程序会自动显示转换开始时间及完成时间。5、用Excel将转换后的字段再复制、粘贴回CSV文件的对应字段，检查有无问题，确认没有问题后，保存CSV文件（这个保存过程会导致CSV导出文件中的所有双引号丢失，不过不影响导入Outlook）。6、用UE再次对上面转换后的CSV文件进行处理，主要是去掉前面在数字字段加上的#号字符。7、在Outlook中新建一个联系人文件夹（或者删除原来联系人文件夹中的所有记录），然后执行CSV文件的导入，查看导入后的记录是否正常，如果有不满意的地方，重复前面的步骤，直到满意为止。8、将转换完成的Outlook电话本与智能手机进行同步，在智能手机上检测拼音缩写的使用是否方便，一个字儿：爽极了！我的Cu928用拼音缩写查找1484个联系人，基本上不会有停顿现象。如果对转换程序有什么不满意的地方，可以自己修改宏程序，例如：联系人的姓一般比较特殊，不会出现多音字的现象，针对联系人的第一个汉字（一般是姓）可以用程序特殊处理，不用选择多音字。例如：解x，贾j，查z，单s等。可以参考下载压缩包中的&姓名添加拼音缩写姓氏单独处理不完善版.xls&文件，对sheet4中的姓氏读音进行特别处理，由于数据量太大，只修正了少数的错误，将这个表中不该发音的姓氏读音去掉即可，例如去掉&解j、贾g、查c&等行，对百家姓了解不多，很多姓都不知道念什么：（。
( 92 KB )<div class="votes" id="Score
| 发表时间: 23:44:20 | 浏览数:11677 | 回复数:1
行业：保险
职能部门：销售管理
金币：21460
有什么不清楚的，请写明白。
行业：保险
职能部门：销售管理
金币：21460
(共 1 条) 上一页1 下一页
您还不是圈子成员，不能对文章进行评论。请先，待管理员通过申请之后才能进行评论。
| 畅享服务