msgraph-sdk-php
msgraph-sdk-php copied to clipboard
Excel UsedRange (WORKS on Graph Explorer, and code is given by the Explorer)
Is your feature request related to a problem? Please describe the problem.
When trying to Get values from a UsedRange on an shared Excel.
Graph Explorer provides the following example:
<?php
use Microsoft\Graph\GraphServiceClient;
use Microsoft\Graph\Generated\Drives\Item\Items\Item\Workbook\Worksheets\Item\UsedRange\UsedRangeRequestBuilderGetRequestConfiguration;
$graphServiceClient = new GraphServiceClient($tokenRequestContext, $scopes);
$requestConfiguration = new UsedRangeRequestBuilderGetRequestConfiguration();
$queryParameters = UsedRangeRequestBuilderGetRequestConfiguration::createQueryParameters();
$queryParameters->select = ["text"];
$requestConfiguration->queryParameters = $queryParameters;
$result = $graphServiceClient->drives()->byDriveId('drive-id')->items()->byDriveItemId('driveItem-id')->workbook()->worksheets()->byWorkbookWorksheetId('workbookWorksheet-id')->usedRange()->get($requestConfiguration)->wait();
This works on the graph explorer and you get the calculated field values, instead of the data without formulas applied.
However $queryParameters = UsedRangeRequestBuilderGetRequestConfiguration::createQueryParameters(); method does not exist.
Describe the solution you'd like.
Method added to the existing Code
Additional context?
No response