Run excel refresh successfully using UiPath

[RPA-botDev (RPA)]

Hi dev, please assist, I want to run a refresh successfully in excel without interacting with the UI of the excel cause most times when I open excel using bot it throws data locked for editing.Please assist as this is now urgent.Regards

[shreyash_shirbhate]

Hi @RPA-botDev

Check this out:

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.

[Palaniyappan (Palaniyappan P)]

Hi

Check this thread if you are looking for a scrip to run to refresh the excel file

Automate excel data refresh

Hi @loginerror, Thank you for your reply and sincerely appreciate that. I am trying to search how to use the Invoke VBA activities. Hope to share some good news on my success! Thank you! Rgds HY

Or you can use a activity to perform this

https://docs.uipath.com/activities/docs/refresh-data-connections-x

If you are not getting this activity go to activity panel and right click on filter icon in that panel
And enable show studioX

Then search for it and you can see this activity

Cheers @RPA-botDev

[RPA-botDev (RPA)]

@Palaniyappan

Activities - Refresh Excel Data Connections

HI Palaniyappan, can’t find the activity in package manager to install on studio, is it only for studio x?

[Palaniyappan (Palaniyappan P)]

its a studio x activities but you can get them in studio as

There’s a funnel icon on the Activities tab in UiPath Studio for Developers. Click on it and one of the options is “Show StudioX.”

If you click this “Show StudioX” button, UiPath StudioX activities become available to the full blow Studio product.

Cheers @RPA-botDev

[RPA-botDev (RPA)]

Do I need to upgrade studio as I can’t find show studio x

[Palaniyappan (Palaniyappan P)]

Yeah pls upgrade

@RPA-botDev