How can we create table without headers in Microsoft Excel Graph API?

656 views Asked by At

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. enter image description here

So how can create a table without headers in Excel?

1

There are 1 answers

2
Dragan Panjkov On

If I read the documentation correctly, even if your source does not have headers, Excel will create headers automatically: enter image description here

After you create your table, you would need to Update the WorkbookTable object that you created, and set ShowHeaders to False https://learn.microsoft.com/en-us/graph/api/table-update?view=graph-rest-1.0&tabs=http