Jan-25-2025, 05:10 PM
here's the deal.. i barely know what i'm doing. hobby project.
i've got xlwings updating a ton of cells every few seconds with data from an API (Bitcoin/indicator info).
it's a long process.. it ticks through one cell at a time and then starts over.
so, since i wanted to speed this up i spent some time toying around with multithreading. i split up the whole thing in 6 little parts and it's way faster now. nice.
problem is... obviously it's getting gummed up with all the "busyness". if i run the program with excel open i get " AttributeError: 'NoneType' object has no attribute 'Worksheet' "
if i close the spreadsheet & run the program it'll open 6 separate instances of the same spreadsheet.
what's the best way to do what i'm trying to do here.. do i need maybe another program to take those 6 pieces and compile them into one master sheet?
is multiprocessing the way to go? what do i do........
sorry, i know this is dopey but i have no idea.
i've got xlwings updating a ton of cells every few seconds with data from an API (Bitcoin/indicator info).
it's a long process.. it ticks through one cell at a time and then starts over.
so, since i wanted to speed this up i spent some time toying around with multithreading. i split up the whole thing in 6 little parts and it's way faster now. nice.
problem is... obviously it's getting gummed up with all the "busyness". if i run the program with excel open i get " AttributeError: 'NoneType' object has no attribute 'Worksheet' "
if i close the spreadsheet & run the program it'll open 6 separate instances of the same spreadsheet.
what's the best way to do what i'm trying to do here.. do i need maybe another program to take those 6 pieces and compile them into one master sheet?
is multiprocessing the way to go? what do i do........
sorry, i know this is dopey but i have no idea.
