Working with Google Sheets

Note!

For better performance with your data, upload it to MaviBot tables. This way, your bots will work much faster and avoid errors related to requests to Google Sheets.

For working with column letters

c2n() | n2c() | addCols()

Description

To get a column number by its letter

c2n(str)

Parameters: ! str - column number in letter notation

To get a column letter by number

n2c(n)

Parameter: ! n- column number as a numeric value

To get a column letter by offset from a given column

addCols(str, n)

Parameters: ! str - column letter n - offset; to get a column number to the left of the specified one, pass a negative offset value.

Examples

Examples

number=c2n('AAB')
string=n2c(54)
offset=addCols('AA',-1)