excel列号字母互转

lubyce

excel 列号的字母表示 与 数字表示的列号 互转的代码，简单
有点尴尬，一直有需求，但是手上的模块有点问题，就自己折腾了一个，想分享出来，结果论坛一搜，已经存在了。。。。
下载测试，有BUG   数字转  字母  部分会出现@    字母转数字  部分会出现  负数
https://bbs.125.la/forum.php?mod=viewthread&tid=13918508&highlight=EXCEL%C1%D0%BA%C5 已有代码

这个是用上面的源码测试的结果    单字母出现这个，不知道是不是软件版本的问题。
源码里用的土办法，可以改用(取代码或用字节集)
有需要的朋友自行下载测试

测试数字   1-256 随机   理论上支持所有的数字或字母
* “int 2 str:189-GG” | “str 2 int:GK-193”
* “int 2 str:96-CR” | “str 2 int:IE-239”
* “int 2 str:170-FN” | “str 2 int:BC-55”
* “int 2 str:135-EE” | “str 2 int:AF-32”
* “int 2 str:109-DE” | “str 2 int:AO-41”
* “int 2 str:54-BB” | “str 2 int:GG-189”
* “int 2 str:208-GZ” | “str 2 int:EN-144”
* “int 2 str:150-ET” | “str 2 int:AJ-36”
* “int 2 str:76-BX” | “str 2 int:BY-77”
* “int 2 str:16-P” | “str 2 int:HT-228”
* “int 2 str:193-GK” | “str 2 int:O-15”
* “int 2 str:167-FK” | “str 2 int:GN-196”
* “int 2 str:106-DB” | “str 2 int:DN-118”
* “int 2 str:140-EJ” | “str 2 int:H-8”
* “int 2 str:15-O” | “str 2 int:DQ-121”
* “int 2 str:236-IB” | “str 2 int:IE-239”
* “int 2 str:124-DT” | “str 2 int:E-5”
* “int 2 str:13-M” | “str 2 int:DX-128”
* “int 2 str:51-AY” | “str 2 int:HV-230”
* “int 2 str:153-EW” | “str 2 int:ED-134”
* “int 2 str:94-CP” | “str 2 int:IA-235”
* “int 2 str:58-BF” | “str 2 int:HJ-218”
* “int 2 str:7-G” | “str 2 int:BQ-69”
* “int 2 str:102-CX” | “str 2 int:HP-224”
* “int 2 str:139-EI” | “str 2 int:AW-49”
* “int 2 str:125-DU” | “str 2 int:CF-84”
* “int 2 str:76-BX” | “str 2 int:HG-215”
* “int 2 str:17-Q” | “str 2 int:BS-71”
* “int 2 str:167-FK” | “str 2 int:DI-113”
* “int 2 str:132-EB” | “str 2 int:CV-100”
* “int 2 str:38-AL” | “str 2 int:FS-175”
* “int 2 str:217-HI” | “str 2 int:DP-120”
* “int 2 str:246-IL” | “str 2 int:CL-90”
* “int 2 str:196-GN” | “str 2 int:AX-50”
* “int 2 str:155-EY” | “str 2 int:BE-57”
* “int 2 str:3-C” | “str 2 int:AM-39”
* “int 2 str:226-HR” | “str 2 int:AW-49”
* “int 2 str:241-IG” | “str 2 int:X-24”



* “int 2 str:19902-ACKL” | “str 2 int:ZBA-17629”
* “int 2 str:12265-RCS” | “str 2 int:IN-248”
* “int 2 str:3303-DWA” | “str 2 int:DAO-2745”
* “int 2 str:3989-EWK” | “str 2 int:JTI-7289”
* “int 2 str:8214-LCX” | “str 2 int:AJLI-24657”

cfvgbhnj

        感谢分享，很给力！~

q940408612

我读书少，不要骗我

178826559

谢谢楼主，下载收藏！