电子表格、WPS单元格 汉字转拼音的方法
温柔似野鬼°
876次浏览
2021年01月17日 07:51
最佳经验
本文由作者推荐
七月七日记-面试视频
电子表格、
WPS
单元格
汉字转拼音的方法
第一步：该界面下，使用
Alt+F11
打开
VB
代码编 辑窗口，
第二步：点击插入
-
模块。双击打开模块
1 vb
编辑窗口。如下图
第三步：以下代码复制到窗体中
Function
pinyin(p
As
String
)
As
String
i =
Asc
(p)
Select
Case
i
Case
-
20319
To
-
20318
: pinyin =
Case
-
20317
To
-
20305
: pinyin =
Case
-
20304
To
-
20296
: pinyin =
Case
-
20295
To
-
20293
: pinyin =
Case
-
20292
To
-
20284
: pinyin =
Case
-
20283
To
-
20266
: pinyin =
Case
-
20265
To
-
20258
: pinyin =
Case
-
20257
To
-
20243
: pinyin =
Case
-
20242
To
-
20231
: pinyin =
Case
-
20230
To
-
20052
: pinyin =
Case
-
20051
To
-
20037
: pinyin =
Case
-
20036
To
-
20033
: pinyin =
Case
-
20032
To
-
20027
: pinyin =
Case
-
20026
To
-
20003
: pinyin =
Case
-
20002
To
-
19991
: pinyin =
Case
-
19990
To
-
19987
: pinyin =
Case
-
19986
To
-
19983
: pinyin =
Case
-
19982
To
-
19977
: pinyin =
Case
-
19976
To
-
19806
: pinyin =
Case
-
19805
To
-
19785
: pinyin =
Case
-
19784
To
-
19776
: pinyin =
Case
-
19775
To
-
19775
: pinyin =
Case
-
19774
To
-
19764
: pinyin =
Case
-
19763
To
-
19757
: pinyin =
Case
-
19756
To
-
19752
: pinyin =
Case
-
19751
To
-
19747
: pinyin =
Case
-
19746
To
-
19742
: pinyin =
Case
-
19741
To
-
19740
: pinyin =
Case
-
19739
To
-
19729
: pinyin =
Case
-
19728
To
-
19726
: pinyin =
Case
-
19725
To
-
19716
: pinyin =
Case
-
19715
To
-
19541
: pinyin =
Case
-
19540
To
-
19532
: pinyin =
Case
-
19531
To
-
19526
: pinyin =
Case
-
19525
To
-
19516
: pinyin =
Case
-
19515
To
-
19501
: pinyin =
Case
-
19500
To
-
19485
: pinyin =
Case
-
19484
To
-
19480
: pinyin =
Case
-
19479
To
-
19468
: pinyin =
Case
-
19467
To
-
19290
: pinyin =
Case
-
19289
To
-
19289
: pinyin =
Case
-
19288
To
-
19282
: pinyin =
Case
-
19281
To
-
19276
: pinyin =
Case
-
19275
To
-
19271
: pinyin =
Case
-
19270
To
-
19264
: pinyin =
Case
-
19263
To
-
19262
: pinyin =
Case
-
19261
To
-
19250
: pinyin =
Case
-
19249
To
-
19244
: pinyin =
Case
-
19243
To
-
19243
: pinyin =
Case
-
19242
To
-
19239
: pinyin =
Case
-
19238
To
-
19236
: pinyin =
Case
-
19235
To
-
19228
: pinyin =
Case
-
19227
To
-
19225
: pinyin =
Case
-
19224
To
-
19219
: pinyin =
Case
-
19218
To
-
19213
: pinyin =
Case
-
19212
To
-
19039
: pinyin =
Case
-
19038
To
-
19024
: pinyin =
Case
-
19023
To
-
19019
: pinyin =
Case
-
19018
To
-
19007
: pinyin =
Case
-
19006
To
-
19004
: pinyin =
Case
-
19003
To
-
18997
: pinyin =
Case
-
18996
To
-
18978
: pinyin =
Case
-
18977
To
-
18962
: pinyin =
Case
-
18961
To
-
18953
: pinyin =
Case
-
18952
To
-
18784
: pinyin =
Case
-
18783
To
-
18775
: pinyin =
Case
-
18774
To
-
18774
: pinyin =
Case
-
18773
To
-
18527
: pinyin =
Case
-
18526
To
-
18519
: pinyin =
Case
-
18518
To
-
18502
: pinyin =
Case
-
18501
To
-
18491
: pinyin =
Case
-
18490
To
-
18479
: pinyin =
Case
-
18478
To
-
18464
: pinyin =
Case
-
18463
To
-
18449
: pinyin =
Case
-
18448
To
-
18448
: pinyin =
Case
-
18447
To
-
18447
: pinyin =
Case
-
18446
To
-
18240
: pinyin =
Case
-
18239
To
-
18238
: pinyin =
Case
-
18237
To
-
18232
: pinyin =
Case
-
18231
To
-
18221
: pinyin =
Case
-
18220
To
-
18212
: pinyin =
Case
-
18211
To
-
18202
: pinyin =
Case
-
18201
To
-
18185
: pinyin =
Case
-
18184
To
-
18184
: pinyin =
Case
-
18183
To
-
18182
: pinyin =
Case
-
18181
To
-
18013
: pinyin =
Case
-
18012
To
-
17998
: pinyin =
Case
-
17997
To
-
17989
: pinyin =
Case
-
17988
To
-
17971
: pinyin =
Case
-
17970
To
-
17965
: pinyin =
Case
-
17964
To
-
17962
: pinyin =
Case
-
17961
To
-
17951
: pinyin =
Case
-
17950
To
-
17948
: pinyin =
Case
-
17947
To
-
17932
: pinyin =
Case
-
17931
To
-
17929
: pinyin =
Case
-
17928
To
-
17923
: pinyin =
Case
-
17922
To
-
17760
: pinyin =
Case
-
17759
To
-
17753
: pinyin =
Case
-
17752
To
-
17734
: pinyin =
Case
-
17733
To
-
17731
: pinyin =
Case
-
17730
To
-
17722
: pinyin =
Case
-
17721
To
-
17704
: pinyin =
Case
-
17703
To
-
17702
: pinyin =
Case
-
17701
To
-
17698
: pinyin =
Case
-
17697
To
-
17693
: pinyin =
Case
-
17692
To
-
17684
: pinyin =
Case
-
17683
To
-
17677
: pinyin =
Case
-
17676
To
-
17497
: pinyin =
Case
-
17496
To
-
17488
: pinyin =
Case
-
17487
To
-
17483
: pinyin =
Case
-
17482
To
-
17469
: pinyin =
Case
-
17468
To
-
17455
: pinyin =
Case
-
17454
To
-
17434
: pinyin =
Case
-
17433
To
-
17428
: pinyin =
Case
-
17427
To
-
17418
: pinyin =
Case
-
17417
To
-
17203
: pinyin =
Case
-
17202
To
-
17186
: pinyin =
Case
-
17185
To
-
16984
: pinyin =
Case
-
16983
To
-
16971
: pinyin =
Case
-
16970
To
-
16943
: pinyin =
Case
-
16942
To
-
16916
: pinyin =
Case
-
16915
To
-
16734
: pinyin =
Case
-
16733
To
-
16709
: pinyin =
Case
-
16708
To
-
16707
: pinyin =
Case
-
16706
To
-
16690
: pinyin =
Case
-
16689
To
-
16665
: pinyin =
Case
-
16664
To
-
16658
: pinyin =
Case
-
16657
To
-
16648
: pinyin =
Case
-
16647
To
-
16475
: pinyin =
Case
-
16474
To
-
16471
: pinyin =
Case
-
16470
To
-
16466
: pinyin =
Case
-
16465
To
-
16460
: pinyin =
Case
-
16459
To
-
16453
: pinyin =
Case
-
16452
To
-
16449
: pinyin =
Case
-
16448
To
-
16434
: pinyin =
Case
-
16433
To
-
16430
: pinyin =
Case
-
16429
To
-
16428
: pinyin =
Case
-
16427
To
-
16424
: pinyin =
Case
-
16423
To
-
16420
: pinyin =
Case
-
16419
To
-
16413
: pinyin =
Case
-
16412
To
-
16408
: pinyin =
Case
-
16407
To
-
16404
: pinyin =
Case
-
16403
To
-
16402
: pinyin =
Case
-
16401
To
-
16394
: pinyin =
Case
-
16393
To
-
16221
: pinyin =
Case
-
16220
To
-
16217
: pinyin =
Case
-
16216
To
-
16213
: pinyin =
Case
-
16212
To
-
16206
: pinyin =
Case
-
16205
To
-
16203
: pinyin =
Case
-
16202
To
-
16188
: pinyin =
Case
-
16187
To
-
16181
: pinyin =
Case
-
16180
To
-
16172
: pinyin =
Case
-
16171
To
-
16170
: pinyin =
Case
-
16169
To
-
16159
: pinyin =
Case
-
16158
To
-
16156
: pinyin =
Case
-
16155
To
-
15960
: pinyin =
Case
-
15959
To
-
15959
: pinyin =
Case
-
15958
To
-
15945
: pinyin =
Case
-
15944
To
-
15934
: pinyin =
Case
-
15933
To
-
15921
: pinyin =
Case
-
15920
To
-
15916
: pinyin =
Case
-
15915
To
-
15904
: pinyin =
Case
-
15903
To
-
15890
: pinyin =
Case
-
15889
To
-
15879
: pinyin =
Case
-
15878
To
-
15708
: pinyin =
Case
-
15707
To
-
15702
: pinyin =
Case
-
15701
To
-
15682
: pinyin =
Case
-
15681
To
-
15668
: pinyin =
Case
-
15667
To
-
15662
: pinyin =
Case
-
15661
To
-
15660
: pinyin =
Case
-
15659
To
-
15653
: pinyin =
Case
-
15652
To
-
15641
: pinyin =
Case
-
15640
To
-
15632
: pinyin =
Case
-
15631
To
-
15626
: pinyin =
Case
-
15625
To
-
15455
: pinyin =
Case
-
15454
To
-
15449
: pinyin =
Case
-
15448
To
-
15437
: pinyin =
Case
-
15436
To
-
15436
: pinyin =
Case
-
15435
To
-
15420
: pinyin =
Case
-
15419
To
-
15417
: pinyin =
Case
-
15416
To
-
15409
: pinyin =
Case
-
15408
To
-
15395
: pinyin =
Case
-
15394
To
-
15386
: pinyin =
Case
-
15385
To
-
15378
: pinyin =
Case
-
15377
To
-
15376
: pinyin =
Case
-
15375
To
-
15370
: pinyin =
Case
-
15369
To
-
15364
: pinyin =
Case
-
15363
To
-
15363
: pinyin =
Case
-
15362
To
-
15184
: pinyin =
Case
-
15183
To
-
15181
: pinyin =
Case
-
15180
To
-
15166
: pinyin =
Case
-
15165
To
-
15159
: pinyin =
Case
-
15158
To
-
15154
: pinyin =
Case
-
15153
To
-
15151
: pinyin =
Case
-
15150
To
-
15150
: pinyin =
Case
-
15149
To
-
15145
: pinyin =
Case
-
15144
To
-
15144
: pinyin =
Case
-
15143
To
-
15142
: pinyin =
Case
-
15141
To
-
15141
: pinyin =
Case
-
15140
To
-
15140
: pinyin =
Case
-
15139
To
-
15129
: pinyin =
Case
-
15128
To
-
15122
: pinyin =
Case
-
15121
To
-
15120
: pinyin =