Save excel

Help Activities
1

Hi all my doubt is, I have a desktop application in that application I am clicking on Export to Excel tab, so the excel page is opening but not getting saved anywhere. Now I want to save that excel and move to a different folder. How can I save and move.

Note: the excel is just opening but not getting saved anywhere.

Thanks in advance

2

Hi @hanviprebday

Try this way:

=> Click "Export to Excel"
    Wait for Excel to Open
=> Send Hotkey "Ctrl + S" (Save)
=> Send Hotkey "Enter" (Confirm Save)
=> Type Into: Enter Destination Folder Path
=> Type Into: Enter File Name
=> Send Hotkey "Enter" (Confirm Save)
=>Send Hotkey "Alt + F4" (Close Excel)
=>Move File: Move Saved Excel File to Desired Folder

Hope it helps!!

3

If it’s opening in Excel it has to be saved somewhere. File/Info will tell you where.

4

Hey you can try putting the export to excel button - click activity in wait for download. So when the file opens, you will be able to get the file variable and using FullName (E.g:- File_Variable.FullName) will provide the full path of the file

5

Hi @hanviprebday

If you are able to save the excel file by using the Keypad shortcut keys.
In Automation you can use the Keyboard shortcuts activity to give Ctrl+S which used to save the file after that we can give the name of the file and save by using Ui activities.

Hope it helps!!