FAN_int2ExcelColChar functions

复制代码
static void FAN_int2ExcelColChar(Args _args)
{
    Dialog  dlg = new dialog("please enter int number");
    DialogField dlgNum = dlg.addField(types::Integer,"数字");
    int     num;
    name    name;
str THK_int2ColChar(int _col)
{
    int     k, i;
    str     ret;
;
    i    = _col;
    while(i > 0)
    {
       k    = i mod 26;
       if(k == 0)
       {
           ret  = "Z" + ret;
           i    = i - 1;
       }
       else
       {
           ret  = num2char(k + 64) + ret;
       }

       i    = i / 26;
    }
    return ret;
}
;
    dlg.doInit();
    if(!dlg.run())
        return;
    num = dlgNum.value();
    name = THK_int2ColChar(num);
    setprefix(strfmt("%1",num));
    info(name);
}
复制代码

 

posted @   Fandy Xie  Views(249)  Comments(0Edit  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示