What should I do if the getpy function cannot be used?

getpy function cannot be used?

The getpy function cannot be used because Excel was not added successfully.

Recommended tutorial: excel tutorial

How to add getpy function to excel:

1. Open Excel and press the Alt F11 key at the same time to open VBE interface, click on the blank space in the upper left corner as shown in the picture, select "Insert", "Module";

2. At this time, a module is inserted, followed by The code must be placed in this module, ensuring that the blank area on the right is the editing area of ​​the module code (the safest way is to double-click the module), and then proceed to the next step;

3. Copy and paste all the following codes into the blank area;

Function pinyin(p As String) As String
i = Asc(p)
Select Case i
Case -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 = 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

4. Close this new interface, return to Excel, and then use the functions that come with Excel. Use this custom Getpy function. It has only one parameter. The parameter can directly specify the cell or directly enter characters.

The above is the detailed content of What should I do if the getpy function cannot be used?. For more information, please follow other related articles on the PHP Chinese website!