Update excel files

I'm using Excel with Workspace and Datastream. I have many files that I want to update via the excel addin. I want to write a code (VBA or Python) to open these files and "click" "Refresh Worksheet" button, wait for the update, and then save and close the excel files. Could you assist me with a short code snippet that would tell Workspace toolbar to "Refresh Workbook"? (either in Python or VBA) Also, is there any programatic indication that the update has finished, i.e. the data request has been completed? So that I know when can I save/close file or perform additional operations

Find more posts tagged with

excel

#technology

Accepted answers

All comments

wasin.w V3

Hello @krjaworski

Thank you for reaching out to us. The LSEG Python libraries do not have a feature to manage and control Excel. You may need to use the 3rd party library like https://www.xlwings.org/ to control Excel with Python.

This Stack Overflow post may help you too, Stack Overvflow: RefreshAll in excel file with xlwings.

Note: You can get helps from the xlwings support team directly via https://www.xlwings.org/contact website.

Jirapongse

@krjaworski

As far as I know, the Excel add-ins libraries are not designed to work like this. This could not be a long term solution.

Both Workspace and Datastream provide Python libraries that can be used to retrieve data with the Python code.

It is better to use those libraries to directly retrieve data.

EXPLORE OUR SITES