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.
11,229 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.
4,358 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. MichaelHan-MSFT 18,126 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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.