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);
}
原文地址:https://www.cnblogs.com/Fandyx/p/3200749.html