Refresh Excel Data Connections Query

Help Activities
, , ,
1

Can anyone provide an example of how to refresh data connections of an excel which is placed in Sharepoint?
I need to refresh the query inside of it without manually opening the file, as I usually do.

2

Open your excel using Excel Application Scope;
Inside the scope use an Attach Window to your Excel.
Use a Send Hot Key with Ctrl+Alt+F5 values.

I just answered a similar question here (screenshots available):

1 Like
3

Hi @RAZVAN-MARIUS_ANDONE ,

Try Macro code

Private Sub Workbook_Open()
'PURPOSE: Run Data tab’s Refresh All function when file is opened

ThisWorkbook.RefreshAll

MsgBox “Stock Data has been refreshed!”

If this doesn’t work for you let me know I will provide invoke code or macro whichever you prefer.

End Sub

1 Like
4

Hi Manoj, In UiPath Studio Pro Community edition, do you know if there is a way to natively use the “Refresh Excel Data Connections” activity which is supposedly included in the UiPath.Excel.Activities package?

5

Hi @RAZVAN-MARIUS_ANDONE ,

Try this, let me know if you face any issue.
RefreshAll.xaml (4.7 KB)

6

Thanks for the reply!

I also need to know how to make the Uipath process use the excel file located in Sharepoint while unattended, with a robot perhaps. How do I connect the Excel Scope to that file located in Sharepoint and with my PC off?

7

Thanks for the reply!

I also need to know how to make the Uipath process use the excel file located in Sharepoint while unattended, with a robot perhaps. How do I connect the Excel Scope to that file located in Sharepoint and with my PC off?

Is it possible for Excel Scope to access a https?

I know I can map Sharepoint to OneDrive, but will it access the excel file with my PC off?

8

Install below package and check if their is any activity which will help you to achieve this.

image

9

Will try, thank you very much!

1 Like
10

I’ve searched yesterday for the exact same thing but I am unable to even find the activity inside Studio. Do you know how to find it exactly? Maybe I am using the wrong Studio version, should it be X or Pro? Should I get some specific package installed?

11

I am using 2021.4.3
Which version you are using?

12

Also make sure

Local, official, marketplace checkbox is enabled.

Go to Manage Packages — Settings—

13

damn, 2020.10.7 and it’s a version offered by the company I work for.

Seems I need an update to see those new activities.
All packages are checked in settings .

14

There is one more package, not sure this helps you.

I never used it, try it

image
image818Ă—473 26.6 KB

15

Yeah, I saw those too but when I try to install them, I get an error stating that it cannot be installed :frowning:

Could be some restriction due to company policies.

16

Right, that’s not Uipath package.

Is refresh excel worked for you ?

17

Nope, I am stuck.

When I use the Excel Scope, it does not accept the Sharepoint link I insert, it only works if I provide a local file path.

Te BIG question remains: how do I use the Excel file located in Sharepoint? I need to do this without linking Sharepoint to OneDrive, I need to run the process without my PC being open.

18

To work with SharePoint the best thing that you can do is use the SharePoint activites.

I usually download the file from SharePoint with Get File, do my changes, and upload back to SharePoint using Upload File.

19

I understand.

Will it run though as a unattended process through a unattended robot or I need to keep my PC open în order to download, make changes and upload after?

20

It can run with unattended or attended bots.

No need to keep your PC open.