Export Excel and save as specific file name on a particular drive


#1

I understand there are questions regarding export to excel but I couldn’t find definitive answer.
After loading a part webpage I get a table where I have the option of exporting to excel.

When I click on this element, I get IE message which says
Do you want to open or save ExcelExport234513.xlsx from xyz.com which includes option of Open, Save, Saveas, save open and cancel

I want this file export to be saved on a particular drive location so that my excel macros can read and format.

Is there a option to do this efficiently in UiPath?


#2

If you are able to get the excel download url from Website itself, use below

If not, you need to click Save As - > Type Into --> New Path

To click on Save as —> Indicate on Screen --> F2 (gives you 3 seconds to click on arrow) —> Indicate Save AS


#3

To click on Save as —> Indicate on Screen --> F2 (gives you 3 seconds to click on arrow) —> Indicate Save AS

I didnt get 3 seconds option. I dragged Indicate on screen to the environment and clicked F2. What am i doing wrong ?


#4

Click Activity ->Indicate on Screen --> Click F2 (you will see below 3 second timer on bottom right) --> It allows you to click on drop down arrow --> Indicate on Save As