UsedRange not supported in Worksheet

[AngPeiHao]

It seems like UsedRange is not supported and not specifying the range through .range() returns None.

worksheets["test_sheet"].range().execute_query() returns None.

https://learn.microsoft.com/en-us/graph/api/worksheet-usedrange?view=graph-rest-1.0&tabs=http

[AngPeiHao]

Solution:

# Office365-REST-Python-Client/office365/onedrive/workbooks/worksheets/worksheet.py
class WorkbookWorksheet(Entity):
    ...
    def used_range(self):
        """Gets the used range object of the worksheet"""
        return_type = WorkbookRange(
            self.context, ResourcePath("range", self.resource_path)
        )
        qry = FunctionQuery(self, "usedRange", return_type=return_type)
        self.context.add_query(qry)
        return return_type
    ...

# Office365-REST-Python-Client/examples/onedrive/excel/read_range.py

# Get the smallest range of cells that have any values or formatting assigned to them
worksheet_range = worksheets["Sheet1"].used_range().execute_query()

[vgrem]

The support for used range has been introduced in 2.6.0 version.

Example:

worksheet_range = worksheets["Sheet1"].range().execute_query()

or

worksheet_range = worksheets["Sheet1"].range(address="A1:B3").execute_query()

read_range.py