msgraph-sdk-php icon indicating copy to clipboard operation
msgraph-sdk-php copied to clipboard

Excel UsedRange (WORKS on Graph Explorer, and code is given by the Explorer)

Open dtwpt opened this issue 1 year ago • 0 comments

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

dtwpt avatar Jul 29 '24 15:07 dtwpt