How to refresh my excel file with Uipath ?

Help Activities
, ,
1

I would like to refresh my excel file before processing

2

What you mean for refresh?

3

refresh the whole sheet

4

Hi @Nightowl_music Is your excel file connected to some data source or it have pivot tables, why you want to refresh it ?

5

no it’s on my windows pc in a folder path

6

I am still not getting why you want to refresh it? we usually use refresh option in case of pivots or data source.

Please clarify so that i can help you.

7

im opening excel with Excel Application Scope, then I want to refresh the sheet. so pretty easy I think.

8

Sorry but i am not getting it.
The Refresh i understand in excel is shown below.
Not sure if you are talking about this.

image
image1325×462 29.5 KB

1 Like
9

yes that’s it

10

In this case, You can use send hotkey

11

For this you have below activity
image

12

If this doesn’t work for you then you can use 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!”

End Sub

13

don’t know how to build that to be honest

14

Is activity not worked for you ?

15

You can use a Send Hot Key as mentioned by @ganesh4.

image

So:

image
image569×663 22.2 KB

Then monitor the messages that will appear here:

image

1 Like
16

no don’t know how to build it