Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
dtwpt opened this issue Jul 29, 2024 · 0 comments
Open
Assignees
Labels

Comments

@dtwpt
Copy link

dtwpt commented Jul 29, 2024

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 dtwpt added status:waiting-for-triage An issue that is yet to be reviewed or assigned type:feature New experience request labels Jul 29, 2024
@Ndiritu Ndiritu added bug: documentation type:bug A broken experience and removed status:waiting-for-triage An issue that is yet to be reviewed or assigned type:feature New experience request labels Aug 8, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants