Skip to main content

Sheets troubleshooting

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.