Skip to content

Support Excel Workbook Table Add TableRowCollection #1497

@coderintherye

Description

@coderintherye

Basically, same issue as described in the dotnet sdk, raising here to save others from wasting an entire day on this as I have.

microsoftgraph/msgraph-sdk-dotnet#1928

This issue exists in msgraph-sdk-php in dev branch.

The documentation is wrong as well for PHP at https://learn.microsoft.com/en-us/graph/api/tablerowcollection-add?view=graph-rest-1.0&tabs=php :

<?php

$graphServiceClient = new GraphServiceClient($tokenRequestContext, $scopes);

$requestBody = new AddPostRequestBody();
$requestBody->setIndex(5);
$requestBody->setValues([	[1,2,3],	[4,5,6],	]);

$result = $graphServiceClient->drives()->byDriveId('drive-id')->items()->byDriveItemId('driveItem-id')->workbook()->tables()->byWorkbookTableId('workbookTable-id')->rows()->add()->post($requestBody)->wait();

However, this will request in an error on the setValues() call saying it expects a Json object:
Fatal error: Uncaught TypeError: Microsoft\Graph\Generated\Drives\Item\Items\Item\Workbook\Tables\Item\Rows\Add\AddPostRequestBody::setValues(): Argument #1 ($value) must be of type ?Microsoft\Graph\Generated\Models\Json, array given,

Constructing a Json object using that class will instead result in an Odata error when making the actual request

Fatal error: Uncaught Microsoft\Graph\Generated\Models\ODataErrors\ODataError in vendor/microsoft/microsoft-graph/src/Generated/Models/ODataErrors/ODataError.php:36

Hoping this feature will get support added as well as hoping by surfacing this here others can find it in the search and know that adding table rows in Excel is not currently working with this SDK.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions