Refresh Excel file in SharePoint

[Rreddy]

Hi all, can anyone tell me how can i refresh the excel file in SharePoint.
I have a Excel file in SharePoint in that it have 3 sheets with formulas. I want to refresh 2 sheets based on name.
How can I achieve this

[Uthraa_S (Uthraa)]

Hi,

Please check if the file is synced to local . If so you can directly access excel form that folder and use excel activities. To refresh excel you can use Refresh Excel Data Connections activity . Please check the below thread

Background process: Is it possible to refresh an excel worksheet table that is connected to sharepoint?

So I’m trying to see if it’s possible to refresh an excel spreadsheet that has a table that is connected to a sharepoint list, as a background process? I’d like to take the refreshed information and populate it into a queue for processing. I currently run a foreground process that runs a refresh macro in the spreadsheet and then it reads the updated info and adds it to a queue. But it occupies a runtime doing this. I know I could use a power apps license to have an api anytime the sharepoint i…

[Rreddy]

Hi @Uthraa_S we are not syncing this to local. I have to do it in online only. I’m using Graph API activities. If not i can use scripting also.

[ashokkarale]

@Rreddy,

There is no prebuilt activity for online excel file in SharePoint. You got scripting option only.

Thanks,
Ashok

[Rreddy]

Hi @ashokkarale thanks for the info. Let me try that.

[Rreddy]

Can anyone help me. Do we have any possibility to achieve this using API. If yes can anyone guide me how Can i do this.