How to get the pivot table Table range in excel

Help Activities
, , ,
1

Hi Community
strong textWe are trying to get the range of the pivot table in excel using ‘Get Table Range’ activity but it is throwing below error:
RemoteException wrapping UiPath.Excel.ExcelException: Could not retrieve Days to Report table’s range. —> RemoteException wrapping System.Runtime.InteropServices.COMException: Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
at System.RuntimeType.ForwardCallToInvokeMember(String memberName,
BindingFlags flags,
Object target,
Int32 aWrapperTypes,
MessageData& msgData)
at Microsoft.Office.Interop.Excel.ListObjects.get__Default(Object Index)
at UiPath.Excel.WorkbookApplication.GetTableRange(String tableName)
— End of inner exception stack trace —
at UiPath.Excel.Activities.ExcelInteropActivity`1.EndExecute(AsyncCodeActivityContext context,
IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context,
IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor,
BookmarkManager bookmarkManager)

However, when we try to use same activity for getting the range of regular table in excel it works fine.

Could you please suggest how we can get the range of pivot table.

Thanks,
Ravi

2

Hi @rchin

Please use a read range activity instead by giving only the start index as the start cell of the pivot table and check

cheers