Graph Excel refer to ranges numerically

Steven Fayers 1 Reputation point
2021-02-04T21:34:11.72+00:00

Hi

The examples always to refer to a range always using the A1:C3 type notation, howver given that graph is used by machines, is there a way to refer to ranges using only a numerical syntax such as 1,1:3,3 ? The reason for this is to avoid translating a n column dataset into a range with the correct alpha character(s) for the column reference.

Thanks
Steven

Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
457 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,641 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,526 Reputation points
    2021-02-08T08:26:44.513+00:00

    @Steven Fayers
    Could you please share us a sample to help me understand your issue better?

    Currently, I suggest you go to Excel > Options > Formulas > Working with formulas section, check the box of "R1C1 reference style" > OK.
    Then you would find the columns are also marked by numbers.
    65239-capture15.png

    ------------------
    Update -------------------------

    If this issue is about Graph API, which is more related to development, I would suggest you post a new question on the following forum. As we are mainly responsible for general issues of Excel clients.
    Office developer community

    Thanks for your understanding.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. Steven Fayers 1 Reputation point
    2021-02-08T09:14:16.137+00:00

    Hi. This is about addressing ranges when using Graph APIs: 

    https://graph.microsoft.com/v1.0/drives/<driveid>/items/<itemid>/workbook/worksheets/<worksheetid>/range(address='A1:AP254')

    Is there a way to address the range using a numeric column reference in the API URI?