I got a little python script running that takes data from a website every 2-3s. This data is then transformed to just a small table 10x10 and saved in a csv form. This csv file is obviously being refreshed all the time.
Is there a good way to somehow link an excel file to this table so that I can see the changes live? I've thought that maybe i create a file with mere links to this one and vba as in:
compared to python though, this code is very performance heavy (takes one core of an i7) and blocks excel from doing anything else (throwing in doevents perhaps?). Perhaps any of you know of a more sophisticated way to get a live feed of that data into excel?
Please Login or Register to view this content.