Productivity Activities
Last updated Jul 9, 2024


Unbounded ranges do not return values

Unbounded ranges (e.g., 1:1000, A:D or Sheet1!1:5, Sheet1!A:D) do not return values. This is a Microsoft Graph API limitation. For details, see Unbounded Range. For optimal performance, you must use fully specified ranges.

The only API available that returns any sort of used range is the UsedRange API. This, however, returns the smallest contiguous range.

Starting with UiPath.MicrosoftOffice365.Activities v2.0.0, the UsedRange API is called when dealing with a sheet. If your sheet is composed of multiple disparate (separated by empty rows/columns) ranges, only the first one will be read.

  • Unbounded ranges do not return values

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.