Excel app integration would be the best practice here since there is Get Table Range activity which has the Option IsPivot - When selected, this option indicates that the specified table is a pivot one. By default, this check box is not selected.
Also, you can join the UiPath Academy for free. You will learn a lot of things and will help you better to automate you processes.