Create table for pivot

Hi All,

I need to create Pivot table. I checked with UiPath Documents, and some videos on Youtube.
for create table, all are saying to select a range hard coded. I want to create a table for PIVOT from A1 ( I have header) and everyday rows for the downloaded excel file change. that is i don’t know how many rows it will have. It should create the table from a1 to end of the file. How to do that?
Please help

Hello @khooshbu.jani

Please watch the below video to understand the pivot creation in uipath

I don’t get excel and indicate excel option