Please enable JavaScript.
Coggle requires JavaScript to display documents.
Spreadsheet (//Считать одно значение (%%column (%alphabet=[""…
Spreadsheet
//Считать одно значение
...Введите номер столбца (от 1 до 57)
%%column
%alphabet=["","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]
calc
%first=floor((%column-1)/26)
calc
%second=%column-%first*26
%first=$[%first] %alphabet
%second=$[%second] %alphabet
$SYS.GET
https://api.pipe.bot/docs/spreadsheets/read
1 more item...
ANSWER
1 more item...
QUESTION
3 more items...
//Считать всё
$SYS.GET
https://api.pipe.bot/docs/spreadsheets/read
$SYS.GET
https://api.pipe.bot/docs/spreadsheets/read
%raw
ANSWER
%raw
QUESTION
range=A%row:ZZ%row
doc=1t
75Vwz
-rx-nL1_onFIdLYo5TyC1q59cCN7QX9qQUo
ANSWER
%row=rowId
QUESTION
search=a
range=A:A
doc=1t
75Vwz
-rx-nL1_onFIdLYo5TyC1q59cCN7QX9qQUo
...Выберите способ получения данных