Unable to read certain Excel sheet data using Graph API

Gopi, Radhika 61 Reputation points

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


and the REST call:


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?

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

    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.