Создание, редактирование Гугл Таблиц в Кибор

if (CN_GoogleSheets[0][n]<26) cs=formatic(CN_GoogleSheets[0][n]+65)+format(CN_GoogleSheets[1][n]);
else
if (CN_GoogleSheets[0][n]>26 && CN_GoogleSheets[0][n]<52) cs="A"+formatic(CN_GoogleSheets[0][n]+65-26)+format(CN_GoogleSheets[1][n]);
else
if (CN_GoogleSheets[0][n]>52 && CN_GoogleSheets[0][n]<78) cs="B"+formatic(CN_GoogleSheets[0][n]+65-52)+format(CN_GoogleSheets[1][n]);
else
if (CN_GoogleSheets[0][n]>78 && CN_GoogleSheets[0][n]<104) cs="C"+formatic(CN_GoogleSheets[0][n]+65-78)+format(CN_GoogleSheets[1][n]);
else
cs="D"+formatic(CN_GoogleSheets[0][n]+65-104)+format(CN_GoogleSheets[1][n])

for (n=0; n<KML_GoogleSheets; n++)
{
if (CN_GoogleSheets[0][n]<26) cs=formatic(CN_GoogleSheets[0][n]+65)+format(CN_GoogleSheets[1][n]);
else cs="A"+formatic(CN_GoogleSheets[0][n]+65-26)+format(CN_GoogleSheets[1][n]);
if (FI_GoogleSheets[n]==0)
{
if (n+1<KML_GoogleSheets)sendgetpython("{^"range^": ^""+sheetname+"!"+cs+"^","+"^"majorDimension^": ^"ROWS^","+"^"values^": [[^""+Values_GoogleSheets[n]+"^"]]},");
else t=sendgetpython("{^"range^": ^""+sheetname+"!"+cs+"^","+"^"majorDimension^": ^"ROWS^","+"^"values^": [[^""+Values_GoogleSheets[n]+"^"]]}]}).execute()");
}
else
{
if (n+1<KML_GoogleSheets)sendgetpython("{^"range^": ^""+sheetname+"!"+cs+"^","+"^"majorDimension^": ^"ROWS^","+"^"values^": [[^""+Values_GoogleSheets[n]+"^"]]},");
else t=sendgetpython("{^"range^": ^""+sheetname+"!"+cs+"^","+"^"majorDimension^": ^"ROWS^","+"^"values^": [["+Values_GoogleSheets[n]+"]]}]}).execute()");
}
}

external(INT, "_strrev", "_strrev", "msvcrt.dll");


messagebox(GetName(3)); // D
messagebox(GetName(27)); // AB
for (int n=55; n<60; n++)messagebox(format(n)+" = "+GetName(n)); // BD:BH


function GetName(int num)
{
string Name2 = "";
char c[99];
getNameFromNumber(num, #Name2);
strcpy(#c[0], Name2);
_strrev(address(#c[0]));
return format(#c[0]);
}

function getNameFromNumber(int num, string #Name)
{
int numeric = mod(num, 26);
string letter = formatic(65 + numeric);
int num2 = num / 26;
Name = Name + letter;
if (num2 > 0)return getNameFromNumber(num2 - 1, #Name);
else return;
}

function mod(int x, int y){int z=x/y; return x-z*y;}

external(INT, "_strrev", "_strrev", "msvcrt.dll");


messagebox(get_number("D"));
messagebox(get_number("AB"));


function get_number(string ceil)
{
int result = 0;
char c[99];
strcpy(#c[0], ceil);
_strrev(address(#c[0]));

for(int i=0; i<size(ceil); i++)
{
int num = formatci(c[i])-64;
result = result + pow(26, i) * num;
}
return result-1;
}