I need to create a table in Microsoft Excel using Graph API.
https://learn.microsoft.com/en-us/graph/api/worksheet-post-tables?view=graph-rest-1.0
As per above document, if we set hasHeaders
field as false in the create table API, it should create a table without headers. But still, I'm getting a table with headers. I added the screenshot below.
So how can create a table without headers in Excel?
If I read the documentation correctly, even if your source does not have headers, Excel will create headers automatically:
After you create your table, you would need to
Update
theWorkbookTable
object that you created, and setShowHeaders
toFalse
https://learn.microsoft.com/en-us/graph/api/table-update?view=graph-rest-1.0&tabs=http