Issue while reading excel file from sharepoint Via graph API

Hi Anumalasetti, Naveen,

Thanks for reaching out to Microsoft!

I attempted to retrieve the content of an Excel file from SharePoint using the Microsoft Graph API

GET https://graph.microsoft.com/v1.0/sites/{SITEID}/drives/{DRIVEID}/root:/pathToitem:/ after deleting one of the sheets. The response was successful, and Microsoft Graph API was used to retrieve the dowloadURL of the Excel file, and there were no discrepancies in the data from the remaining sheets.

Note: Please ensure that the sheets do not have lookup columns which will lead to issues in getting the empty results.

Working with Excel in Microsoft Graph 

Hope this helps.

If the answer is helpful, please click Accept Answer and kindly upvote. If you have any further questions about this answer, please click Comment

Hi @Anumalasetti, Naveen,

Thanks for your detailed explanation, I am more than willing to help you out.

Based on the information you provided and based on this documentation, it appears that the Graph API request you are using is to download the document rather than read it.

If you need to read data from a table in an excel file, you can use this Graph API request.

If you confirm that you are using right request, then we would like you to perform the following tests and provide more details about the problem, which is essential for further investigation as it can help us better determine the root cause of the problem:

1. I checked the documentation, and the Graph API does not specify a limit on the number of worksheets in an excel file, but some users have mentioned that if there are too many worksheets it can cause errors. So, you can try creating an excel file with fewer worksheets to see if the problem still exists. Simplifying the file by reducing the number of worksheets or splitting the data into multiple files might help.
2. Are you having the same problem with other users performing the same request with the same file?
3. Please share the response to your request if it's convenient, I would like to know the specifics of the columns you mentioned and the data being empty. Please be careful not to disclose your private information.

If there is anything else I can do for you, please do not hesitate to reach me.

Hi @Anumalasetti, Naveen,

Appreciate for letting us know your experience.

Concerning the issue you mentioned, we have looked for relevant documentation and feedback from other users on similar situations, but there is no definitive answer.

Therefore, we are not sure if an excel file containing empty sheets will cause the entire file to return empty results when request this Graph API.

We have noticed that you seem to be able to resolve the issue by simply deleting your empty sheets. If this issue is not affecting you now, you can ignore this behavior.

If you would like to confirm whether this is the expected behavior of the Graph API, it is recommended that you open a ticket for further confirmation. Engineers there have access to more information than in the forums and may be able to confirm whether the issue is expected behavior.

If you have any concerns or questions, please do not hesitate to reach me.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. It will be beneficial to more community members reading here. Your contribution will be highly appreciated.