Convert "A1"-style column IDs from a letter representation to an integer, e.g. column A becomes 1, column D becomes 4, etc. Or go the other way around.
1 2 3
a character vector of "A1" style column IDs (case insensitive)
a vector of integer column IDs
Google Sheets have up to 300 columns (column KN).
Excel 2010 spreadsheets have up to 16,384 columns (column XFD).
ZZ is column 702.
ZZZ is column 18,278 (no known spreadsheet actually goes that high).
a vector of column IDs, either character or integer
1 2 3 4 5 6 7 8
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.