microsoftgraph / microsoftgraph/msgraph-sdk-python

Please add CRUD methods to RangeWithAddressRequestBuilder subclass and please re-add "values" property to WorkbookRange subclass

Open
#844 5 comments 1 reaction 1 assignee View on GitHub

@andrueastman is already working on this.

Since Aug 9, 2024.

priority:p2 type:feature type:investigation
Dominant language
Python
Stars
630
Forks
96
Avg merge
15h 20m
Merged PRs (30d)
3

Description

Is your feature request related to a problem? Please describe the problem.

With version 1.5.4, I am unable to perform CRUD operations against a user-defined Excel worksheet range address (i.e., A1:B2) using the RangeWithAddressRequestBuilder and WorkbookRange subclasses in the Python SDK. Specifically, I am unable to read, update, and delete Excel worksheet cell data in a user-defined range address. Please note that I am able to perform these actions using Graph Explorer.

Describe the solution you'd like.
  1. Can PATCH and DELETE methods be added to the RangeWithAddressRequestBuilder subclass?
  2. Can the "values" property be re-added to the WorkbookRange subclass?
Additional context?
  1. Currently, the RangeWithAddressRequestBuilder subclass has methods to build a GET request that is sent to the MS Graph API, but this subclass does not have update or delete methods to send PATCH or DELETE requests.

  2. In the recently updated Python SDK, the WorkbookRange subclass no longer contains the "values" property. Previously, with the "values" property, a GET request could be sent to retrieve raw values from a given Excel range address in the Python SDK. Now that the "values" property is no longer in the WorkbookRange subclass, a user can no longer submit a GET request for raw values at a given range address.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.