Wolfram Function Repository
Instant-use add-on functions for the Wolfram Language
Function Repository Resource:
Convert spreadsheet coordinates to a Wolfram Language position
ResourceFunction["SpreadsheetIndexToPosition"][str] conversts a spreadsheet cell reference such as B3 to a Wolfram {row,col} position pair. |
Convert a spreadsheet cell reference to a Position pair:
In[1]:= | ![]() |
Out[1]= | ![]() |
In[2]:= | ![]() |
Out[2]= | ![]() |
SpreadsheetIndexToPosition is not sensitive to case:
In[3]:= | ![]() |
Out[3]= | ![]() |
If no row number is provided, only the column number is returned:
In[4]:= | ![]() |
Out[4]= | ![]() |
The resource function PositionToSpreadsheetIndex is the inverse of SpreadsheetIndexToPosition:
In[5]:= | ![]() |
Out[5]= | ![]() |
In[6]:= | ![]() |
Out[6]= | ![]() |
Wolfram Language 13.0 (December 2021) or above
This work is licensed under a Creative Commons Attribution 4.0 International License