Excel Models_百度文库
两大类热门资源免费畅读
续费一年阅读会员，立省24元！
Excel Models
&&Excel Models
阅读已结束，下载文档到电脑
想免费下载更多文档？
定制HR最喜欢的简历
下载文档到电脑，方便使用
还剩20页未读，继续阅读
定制HR最喜欢的简历
你可能喜欢Access denied |
used Cloudflare to restrict access
Please enable cookies.
What happened?
The owner of this website () has banned your access based on your browser's signature (38faa7d-ua98).这样用Excel——轻松制作专业的数据图表（第2版） - 搜狗百科
这样用Excel——轻松制作专业的数据图表（第2版）
本书内容涵盖了“经验与心得与”、“体会评论与体会”、“归纳与总结”、“穿插性案例解析分析与讨论”、“归纳与总结”、“帮你解决一些问题”等方面，帮助你真正提高Excel的应用能力，真正掌握所谓的高级处理技能，在本书中，我们归纳了处理案例的各种技能知识，融入了大量应用过程中的各种体会、经验和总结，以及讨论了如何通过分析得出合理的解决方案。
！——轻松制作专业的数据图表（第2版）
978-7-121-20003-8
2013年5月出版
这样用 Excel！——轻松制作专业的数据图表（第2版）刘丽华邓志伟编著ISBN 978-7-121-20003-82013年5月出版定价：49.00元372页16开
首先要说明的是：本书重在讲述使用Excel的体验，而不像大多数书籍偏重于Word应用知识的讲解或案例的综合应用不仅可以传授Excel的全面技术、激发处理数据的灵感，还可以解决那些令人头疼、却在其他书中没有讲透的种种问题。本书内容涵盖了“经验与心得与”、“体会评论与体会”、“归纳与总结”、“穿插性案例解析分析与讨论” 、“归纳与总结”、“帮你解决一些问题”等方面，帮助你真正提高Excel的应用能力，真正掌握所谓的高级处理技能，在本书中，我们归纳了处理案例的各种技能知识，融入了大量应用过程中的各种体会、经验和总结，以及讨论了如何通过分析得出合理的解决方案。图书主要内容包括：高效准确的数据输入与编辑、突出显示数据要点、利用非数据图形和图示、计算功能、图表应用、数据基本分析、数据透视分析、数据、数据安全、数据应用中的一些问题。本书适合想学习Excel的全面技术、应用经验以及寻求数据处理解决方案的所有读者。
我不想与其他图书一样，在前言的一开始就展开长篇大论，还是把这些篇幅留给正文吧！
第1章 开始的五步工作
1.1 表格长啥样11.1.1 从应用的角度看表格11.1.2 从分析的角度看表格21.2 也谈表格设计31.2.1 从一个例子说起31.2.2 表格设计要点41.2.3 要避免的错误61.2.4 一点体会71.3 工作从这里开始（第一步）81.3.1 寻求符合自己要求的界面风格81.3.2 新建和打开注意事项101.3.3 谈谈121.4 将数据输入表中（第二步）131.4.1 输入数据前要弄明白的131.4.2 输入的效率不容忽视151.5 用公式和函数来计算（第三步）151.5.1 公式=算式151.5.2 到底函数是什么151.5.3 如此调用函数161.5.4 享用帮助查询函数181.5.5 我的一些体会201.6 快速完成格式设置（第四步）201.6.1 数据对齐听我说201.6.2 设置边框和填充211.6.3 就这样享用表格格式221.6.4 格式设置需要注意的事项231.7 保存工作成果（第五步）251.7.1 保存工作要注意的事项251.7.2 一个案例：创建自己的模板文件271.7.3 的保存281.8 帮你来解决一些问题吧281.8.1 如何修改默认的工作表数量281.8.2 如何同时查看多个工作簿的内容291.8.3 如何快速缩放数据表格301.8.4 在“打开”对话框中看不到文件311.8.5 如何在不同的工作簿工作表311.8.6 如何让表头始终显示321.8.7 数据显示不全，又不想换行，怎么办331.8.8 创建填充渐变效果的表样式341.8.9 我想让数据在中换行351.8.10 如何显示标尺351.8.11 如何同时浏览位置相隔较远的数据351.8.12 使用最近使用过的工作簿361.8.13 工作表“丢”了37
第2章 高效准确的数据输入与编辑
2.1 提高录入效率N招382.1.1 数据输入也能玩记忆382.1.2 有效率的数据输入方法392.1.3 唯一性数据的处理412.1.4 别小看“”412.1.5 分享一些经验吧432.2 另外几种数据的录入452.2.1 记录数字要科学462.2.2 分数就该如此输入462.2.3 解决身份证等长数字的输入问题462.2.4 快速输入日期与时间472.2.5 输入百分比数据482.2.6 货币格式，自己定义492.2.7 讨论一下自定义格式502.3 体验填充的魅力522.3.1 谈谈序列填充522.3.2 数值型序列的处理542.3.3 自定义序列填充552.3.4 我的一点体会562.4 先查找，后替换572.4.1 关于查找条件572.4.2 替换是这样用的582.4.3 查找和替换“？”与“*”592.4.4 利用定位条件查找592.5 帮你来解决一些问题吧612.5.1 能同时填充多个序列吗612.5.2 如何显示20th February 2010日期的格式612.5.3 设置默认的612.5.4 输入以0开始的数据622.5.5 如何批量删除相同的字符622.5.6 双击单元格后怎么没反应632.5.7 不见了632.5.8 恢复Excel的记忆力632.5.9 以中间数字序列填充642.5.10 引用的地址可以序列填充吗64
第3章 突出显示数据要点
3.1 让表格整齐653.1.1 N招解决单元格中内容显示不全问题653.1.2 使表格整齐的必要设置673.1.3 “隐藏”让表格更整齐683.2 让表格美观683.2.1 边框和底色应该这样用683.2.2 文本格式不能忽视713.2.3 设置倾斜的文字733.2.4 谈谈标题的设置743.3 用样式统一格式763.3.1 单元格样式，不只应用于单元格763.3.2 主题、字体和颜色783.4 活用动态的条件格式793.4.1 自动添加的数据条、色阶和图标集793.4.2 设置自己的条件格式803.4.3 复杂的条件规则的应用823.4.4 在条件格式中使用公式843.4.5 关于条件格式的优先顺序873.4.6 条件格式是可以删除的873.5 帮你来解决一些问题883.5.1 为什么有时候边框无法加黑883.5.2 为什么打印预览时没有显示表格边框883.5.3 怎样快速定位到包含条件格式的单元格893.5.4 如何将表格行列转置893.5.5 无法取消的表格边框90
第4章 利用非数据图形和图示
4.1 绘制形状需要说明以下几点914.1.1 活用画图的几个招数924.1.2 如何连续绘制924.1.3 随心所欲改变图形的形状934.2 体验图形的编辑乐趣944.2.1 必须了解的一些知识944.2.2 自选图形群的编辑984.2.3 特殊的图形：和1004.3 就这样享用外部图片1024.3.1 谈谈导入图片的方式1034.3.2 非常实用的裁剪1044.3.3 用样式快速美化图片1064.3.4 调整图片的色彩1064.3.5 的搜索1084.3.6 我的一点总结1094.4 就这样享用图示1094.4.1 这样创建1094.4.2 谈谈图示的效果设置1124.4.3 图示类型是可以修改的1144.4.4 我的一些体会：运用其他格式1154.5 帮你解决一些问题1164.5.1 关于隐藏图形的问题1164.5.2 怎样为批注框添加图片背景1164.5.3 如何把表格转换为图片1174.5.4 如何将图示转换为形状1174.5.5 改变图示中局部位置关系1184.5.6 解决文字在文本框中的显示效果118
第5章 计算功能尽收眼底
5.1 慧眼识公式1205.1.1 公式是这样用的1205.1.2 谈谈运算符号1215.1.3 输入公式时需要注意的几个方面1235.2 讨论一下公式的复制与移动1265.2.1 用复制公式1265.2.2 双击填充柄有妙用1275.2.3 我的一些体会1285.2.4 复制和移动公式对的影响1285.3 必须掌握公式中的引用1295.3.1 理解的引用很重要1295.3.2 你真正理解区域引用了吗1305.3.3 讨论一下如何引用其他和工作簿1335.3.4 谈谈我的体会1355.4 名称，可以简化公式1375.4.1 先举两个例子1375.4.2 三种定义名称的方法1385.4.3 经验分享1415.4.4 管理名称1435.4.5 一点体会1435.5 数组，你为何如此深奥1445.5.1 感悟的规则1445.5.2 谈谈修改数组公式1475.5.3 我的一点总结1475.6 谈谈函数的应用1485.6.1 更进一步地了解函数1485.6.2 关于函数的嵌套1495.6.3 一些函数的应用1495.7 帮你解决一些问题1555.7.1 “名称框”不见了1565.7.2 名称怎么定义不成功1565.7.3 如何删除公式而不删除其结果值1575.7.4 如何安全、快速地选择被引用的单元格1585.7.5 如何通过错误代码识别出错原因1585.7.6 如何快速转换引用类型1605.7.7 不连续单元格的公式复制问题1605.7.8 如何快速定位包含公式的单元格1615.7.9 怎样计算公式中部分算式的值161
第6章 图表——会说话的数据
6.1 几种有用的图表类型1626.2 就这样享用图表1646.2.1 要创建怎样的图表1646.2.2 让图表显得专业1666.2.3 处理变化的数据源1696.2.4 谈谈图表类型1716.3 图表修饰要适度1736.3.1 准确地选择图表元素1746.3.2 讨论一下图表效果的设置1756.3.3 个性图表的设计要素1776.3.4 形式还是内容1796.3.5 分享一些我的体验1806.4 分享一些较为高级的处理技巧1806.4.1 将“系列”和“类别”换位1806.4.2 让数据显示更精确1816.4.3 数值差异太大，可用次1826.4.4 添加数据标签1836.4.5 分离饼图的扇区1846.4.6 谈谈1856.4.7 谈谈误差线1876.5 帮你解决一些问题1896.5.1 如何实现只打印图表1896.5.2 如何使用图表模板1906.5.3 怎么把图表转为图片1926.5.4 如何将平滑化1926.5.5 如何在图表中显示数据表格1936.5.6 设置默认的图表类型1946.5.7 如何制作同一行的数据1956.5.8 解决空白单元格在图表中的显示问题1976.5.9 如何快速分离饼图中的所有扇区1986.5.10 在数据标签中显示单位1986.5.11 怎样创建嵌入式的图表199
第7章 数据基本分析
7.1 让数据井然有序2017.1.1 排序能做什么2017.1.2 谈谈排序的方式2027.1.3 数据类型对排序的影响2047.1.4 分享一些经验2047.2 数据的分类汇总2057.2.1 就这样享用分类汇总2057.2.2 分类汇总结果的复制2087.3 常常被遗忘的多表合并2097.3.1 表格结构相同时，按位置合并2097.3.2 表格结构不同时，要按类别合并2107.3.3 关于合并后的更新2127.4 数据净化术——筛选2127.4.1 筛选数据如此简单2137.4.2 准确定义筛选条件2147.4.3 高级筛选：条件设置很重要2177.4.4 深入体会高级筛选2187.5 分析工具的应用2207.5.1 分析工具哪里找2207.5.2 看看分析工具的具体应用2217.6 解决数据抽样中的重复问题2267.6.1 用“抽样”工具随机抽取样本2267.6.2 用筛选清除重复数据2287.7 帮你解决一些问题2287.7.1 解决按行排序时的故障2287.7.2 记录单功能哪里找2297.7.3 返回排序前的表格2297.7.4 工作表被保护后，“高级筛选”仍可以用2307.7.5 为什么分类汇总没有按指定的字段汇总2307.7.6 分类汇总与原始数据的自动重算2307.7.7 让高级筛选结果与原数据同步修改2317.7.8 卸载分析工具库2327.7.9 如何按照颜色对数据排序232
第8章 数据透视分析
8.1 你理解透视分析吗2338.1.1 从一个例子开始来理解2338.1.2 创建透视表前应了解的内容2358.2 就这样享用透视表2368.2.1 注意字段列表窗格的显示和隐藏2378.2.2 选择数据源的方式2378.2.3 多个行标签（列标签）的嵌套2408.2.4 如何筛选数据2428.2.5 关于布局的调整2458.2.6 更改计算方式2468.2.7 设置数据透视表的显示方式2488.2.8 说说透视表的样式2498.3 评论一下透视表2508.3.1 用快捷键隐藏数据透视表项目2508.3.2 关于值显示方式2508.3.3 关于“∑数值”2528.4 谈谈数据透视图2528.4.1 关于数据透视图的操作2528.4.2 谈谈数据透视图与图表的区别2558.5 帮你解决一些问题2558.5.1 如何快速清除数据透视表2568.5.2 如何实现将字段拖放到透视表中2568.5.3 如何推迟布局更新2578.5.4 如何将删除的项彻底删除2578.5.5 如何处理打开透视表却找不到设置区域的问题258
第9章 数据假设分析
9.1 ：因素对结果的影响2599.1.1 重要的准备工作2599.1.2 对单个因素分析2619.1.3 对两个因素的分析2639.1.4 我的一点体会2659.2 假设分析：在指定的结果下，求解因素值2659.2.1 单变量求解：原来如此2659.2.2 进一步的应用2669.3 使用规划求解2679.3.1 哪些问题可以使用规划求解2689.3.2 将模型输入到规划求解中2689.3.3 生成规划求解报表2719.3.4 我的一点操作体会2729.4 编制数据分析方案2749.4.1 先对方案有个认识2749.4.2 创建一个方案2759.4.3 方案比较和评析的几种常用方法2789.5 这个项目应该投资吗2789.5.1 先把基本数据组织好2799.5.2 必要的计算不可少：项目的2799.5.3 充分预测：各种方案的创建2819.5.4 查看单个方案的结果2829.5.5 对所有方案进行比较，得出结论2829.6 解决产品生产中的成本控制问题2839.6.1 提出问题2839.6.2 分析并建立模型2839.6.3 求解并得出结论2849.7 帮你解决一些问题2869.7.1 找不到“规划求解”按钮2869.7.2 目标的值未收敛，这意味着什么2889.7.3 如何在方案报表中使用多个结果单元格2889.7.4 如何取消修改时的提示框2899.7.5 如何复制其他中的方案2899.7.6 如何为方案定义名称290
第10章 为数据安全加把锁
10.1 数据输入的安全验证29110.1.1 为单元格设置有效性条件29110.1.2 数据有效性的一些应用29210.1.3 与你分享：多级联动菜单的制作29610.1.4 “圈”释有理29910.2 保护和工作表30210.2.1 密码保护的方方面面30210.2.2 数字签名，你有吗30510.3 用隐藏实现数据保护30910.3.1 隐藏数据的一些方法30910.3.2 隐藏公式31010.3.3 隐藏工作表结构元素31110.4 数据输入的权限控制31310.4.1 这样利用“锁定”属性31410.4.2 设置允许编辑区域31410.4.3 谈谈编辑区域的权限处理31610.5 帮你解决一些问题31710.5.1 如何修改工作簿的属性31710.5.2 输入了无效数据，却没有弹出警告31810.5.3 忘记了哪些区域被设置了数据有效性31910.5.4 我的数字签名如何从计算机中删除31910.5.5 我不想复制那些隐藏行或列中的数据32010.5.6 是否可以禁止数据32110.5.7 该怎样理解数据有效性的有效范围32110.5.8 为什么我的下拉列表没有显示按钮321
第11章 数据应用中的一些问题
11.1 协同工作效率高32311.1.1 将工作簿共享给他人32311.1.2 享用已共享的工作簿32411.1.3 处理共享时的冲突32511.1.4 谈谈共享的安全问题32611.1.5 分享一些经验32811.2 分享多种来源的数据32911.2.1 引用文本文件32911.2.2 使用实时的网页数据33311.2.3 与数据库共用资源33511.3 表格输出有讲究33711.3.1 打印之前先看效果33711.3.2 谈谈页面格式33811.3.3 处理表格的分页34211.3.4 关于打印区域34411.3.5 与你分享：不同规模表格的打印处理方法34711.4 帮你解决一些问题35011.4.1 为什么我的工作簿无法设置共享35011.4.2 保护共享工作簿时怎么不能添加密码35111.4.3 找不到“打印预览”按钮35111.4.4 如何才能不打印单元格中的“0”35211.4.5 不想打印公式的，怎么办35211.4.6 怎样才能让第一页不显示页眉35311.4.7 怎样将工作表中的公式清单打印出来35411.4.8 多个区域打印在同一页35411.4.9 如何在多工作表打印时让页码连续354
我不想与其他图书一样，在前言的一开始就展开长篇大论，还是把这些篇幅留给正文吧！2011年，我们编写了《这样用Excel！——轻松制作专业的数据图表》一书，推出后深受广大读者和网友们的喜爱，好评如潮，此次创作的新书《这样用Excel！——轻松制作专业的数据图表（第2版）》，继承了原作“语言生动”、“富有思想”、“层次分明”、“技术结合实用”、“充实全面”等鲜明特点，并特别针对广大读者及网友们的评论及建议，进行了全面改进，补充了广大朋友们关心的热点和我们这一年多来积累的经验之谈，改进了大量的处理技术和实用案例，讲透了其他书中经常讲不透的技术难点和制作思想，让广大朋友们读起来轻松，学起来愉快。希望这本书既可以传授Excel的全面技术，又可以开拓你的创作思路，还可以解决那些令人头疼、翻遍万书都难以找到答案的种种问题。在此，我要谢谢那么多阅读此书的朋友们，谢谢你们的喜爱；谢谢你们给了我许多建议和新的思路；谢谢你们，让我产生了许多灵感。为什么要推出这三本书到底有没有“成为Office高手的捷径”呢？这个问题就是我们为什么要推出《 这样用Word！——实用简洁的图文排版技巧（第2版）》、《 这样用Excel！——轻松制作专业的数据图表（第2版）》、《这样用PPT！——制作并演示更专业的幻灯片（第2版）》的原因，希望这三本书能给你一个完整的答案。这三本书在写法上采取了崭新的思路，重点讲述的是“体验Office过程中的点点滴滴”。笔者认为，在已经普及的今天，大家真正需要的就是这些点点滴滴。我们在这里提供的捷径是：本书为《这样用Excel！——轻松制作专业的数据图表（第2版）》，其核心内容可以用10个N来表示：N个知识体系、N个经验、N个体会、N个问题解决、N个处理比较、N个案例解析、N个归纳、N个总结、N个技巧、N个注意提示。具体如下图所示。浅析其他的Office类图书为了让大家学好Office，多少教学工作者许多老师煞费心思，《???从入门到精通》、《???详解》、《???范例精解》、《???技巧500招》等书籍层出不穷。这些书籍大致可以分三类：第一类以的功能为主线，第二类以实例应用为主线，第三类是技巧类。笔者在教学过程中，常常遇到这样的问题：“要应用Office，应该从何学起？”“有没有什么方法能让我快速成为Office高手？”“那些Office高手都是怎么炼成的？”……这样的问题看似简单，回答起来却远比解决一堆实际的技术问题复杂得多。用前面所提的三类书籍，恐怕很难能回答上述问题。（1）对于一些以功能学习为主线的书籍：学完后，面对一些问题或案例，需要给出合理的解决方案时，却发现自己仍一知半解，许多甚至是一个帮助的翻版，整个学习过程会让你精疲力竭，不如省下“银子”，按一下F1键，查查帮助吧！（2）对于实例应用为主线的书籍：笔者翻阅过无数与案例关联的书籍，好像找不出一本能在学了后真正做到举一反三、活学活用的，基本上都是为了实现案例效果的终极目标而“奋斗”着所有的步骤细节，而对一些处理方法上的经验体会、分析、归纳基本上是空白的。（3）对于技巧类的书籍：很明显内容体系不够完整，缺乏系统性，用来查询比较适用。当然，假如你有时间和精力，用上述三类书籍来学通Office，也不是没有可能，你可以多花一些“银子”购买多本这样的书籍，然后多花一些时间和精力，通过自己持之以恒的学习和反反复复的推敲，不久之后你便会发现自己慢慢开始有了积累。
如果你是Word的初学者，想循序渐进地学习Word的应用经验；如果你是急于提高Word应用水平的用户，想寻求文档的合理化解决方案，并达到能解决各种疑难问题的程度；如果你是文员、公务员、企业管理人员、数据分析人员、财务人员、统计人员、营销人员、技术开发人员等，想快速掌握所需要的办公操作知识和具体案例的实现，并查询到所面对问题的解决方案，那么本书都将成为你的良师益友。
本书由主编，担任副主编，参与编写的还有、潘全春、张二峰、张五成、、彭宗勤、竺海明、、程立荣、温永招、彭胜伟、李赐亮、。在此对所有参与编写的人员表示感谢。
词条标签：
合作编辑者：
搜狗百科词条内容由用户共同创建和维护，不代表搜狗百科立场。如果您需要医学、法律、投资理财等专业领域的建议，我们强烈建议您独自对内容的可信性进行评估，并咨询相关专业人士。
点击编辑词条，进入编辑页面
意见反馈及投诉2014年6月 .NET技术大版内专家分月排行榜第二2014年1月 .NET技术大版内专家分月排行榜第二
2014年2月 .NET技术大版内专家分月排行榜第三2013年4月 .NET技术大版内专家分月排行榜第三
本帖子已过去太久远了，不再提供回复功能。25116人阅读
办公（24）
Excel中文转拼音（完整版）
打开Excel-&工具-&宏-&Viaual Basic编辑器
在弹出来的窗口中对着VBAproject点右键-&插入-&模块
下面会出现一个名为&模块1&，点击
在右边的空白栏中粘贴以下内容：
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& &
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 getpy(str)
For i = 1 To Len(str)
getpy = getpy & pinyin(Mid(str, i, 1))
End Function
********复制到此结束,本行不复制*******
现在转换函数已编写完成!关掉此编缉的窗口。
要在Excel中使用，方法如下：
A1 & & & & A2
中国 & & =getpy(A1)
（有空格）
Excel中文转拼音（完整版）
打开Excel-&工具-&宏-&Viaual Basic编辑器
在弹出来的窗口中对着VBAproject点右键-&插入-&模块
下面会出现一个名为&模块1&，点击
在右边的空白栏中粘贴以下内容：
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 &
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 getpy(str)
For i = 1 To Len(str)
getpy = getpy & pinyin(Mid(str, i, 1))
End Function
********复制到此结束,本行不复制*******
现在转换函数已编写完成!关掉此编缉的窗口。
要在Excel中使用，方法如下：
A1 & & & & A2
中国 & & =getpy(A1)
&&相关文章推荐
* 以上用户言论只代表其个人观点，不代表CSDN网站的观点或立场
访问：932867次
积分：9740
积分：9740
排名：第1793名
原创：87篇
转载：276篇
评论：35条
(4)(1)(1)(1)(1)(4)(6)(8)(1)(3)(2)(1)(2)(2)(4)(2)(6)(17)(12)(5)(11)(4)(21)(24)(18)(10)(4)(15)(10)(4)(5)(17)(21)(5)(2)(19)(21)(10)(3)(1)(2)(4)(1)(2)(1)(5)(9)(1)(2)(2)(1)(1)(1)(4)(1)(2)(6)(3)(1)(4)(2)