Formatted columns were not able to be read from sharepoint files using graph api.

Anumalasetti, Naveen 0 Reputation points
2024-10-28T06:44:01.18+00:00

Hi Team,

Currently there is a use case I am working on where I will be reading excel files from Sharepoint standalone server via graph API.

Everything is good but suddently I was not able to read few columns from the file.

When debugged I understood that they are formatted. I removed conditional formatting and when read the same file I was able to read it again. I want to understand whether there are any constraints while reading excel files via graph API.

Thank you,
Naveen.

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,804 questions
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
12,663 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,053 questions
SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,626 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

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.