Unable to read certain Excel sheet data using Graph API

Gopi, Radhika 61 Reputation points
2021-06-28T23:24:46.75+00:00

Hi @MichaelHan-MSFT ,
I am trying to read a excel sheet with the following format:

110014-image.png

and the REST call:

110007-image.png

The range is not returned correctly and the values are null. There are 2 sheets in this workbook. One of them works fine and the other one has this issue. Any idea?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,552 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,453 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. MichaelHan-MSFT 18,016 Reputation points
    2021-06-29T06:45:47.837+00:00

    Hi @Gopi, Radhika ,

    Per my test, this works for me on my end. Please make sure that the excel file is checked in with a major version in SharePoint library.

    Since this only happens to the specific sheet, you could try to delete the content and re-add it. Or delete the sheet and add a same one. This may work for you.


    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.