Read sharepoint Excel File - Without Excel Application Scope


I am trying to read in a shared excel file that is stored on SharePoint.

However, I am running this on a server which does not have the Excel Application Installed so I cannot use the Excel Application Scope activities. I should add that this file contains a bunch of quite complicated formulae

Is there anyway to complete this? Perhaps using the O365 or SharePoint activities? I am not having much luck at the moment? Any help would be appreciated.


If that sharepoint is synced to your local server
Then you can access that file and read using WORKBOOK activities which doesn’t need excel application to be installed


Thanks for your reply. Sorry I forgot to mention that this excel file has quite a few formulea in it, so I believe using the workbook activity will not work in this case?