Refresh the Excel sheet without UI interaction

[Kunal_Jain]

I just need a code to refresh all sheet present in Data Menu option.
There are around 10 sheets present in an excel workbook and I just need to refresh all .
How to do it can anyone help
@ppr @Gokul001

[Gokul001 (Gokul Balaji)]

Hi @Kunal_Jain

Check out this thread

Refreshing Excel Workbook with UIPath

Hi Guys, I am trying to refresh an excel workbook but I am not able to do it without opening and passing refresh Hotkeys to it. I can’t open the workbook since this process fails if I have the Remote Desktop disconnected. Is there a way I can refresh the workbook without opening or doing any UI Interactions? Note: The excel is connected to SQL Server Database and I refresh it by clicking “Refresh All” in the data tab.

Can I refresh excel sheet without opening the file

That’s a good idea, but what do mean by after every regular interval.

Regards
Gokul