vMix Forums
»
General
»
General Discussion
»
Update Excel Data source from non vmix machine
Rank: Advanced Member
Groups: Registered
Joined: 9/5/2020(UTC) Posts: 38  Location: brisbane Thanks: 2 times
|
I have a stack of scripts that manipulate an excel spread sheet that i use as a data source. sometimes things go wrong and i need to adjust or edit the spreadsheet but i really need to make edits from a network connected laptop and not my vmix pc.
there are locking issues with excel that prevent 2 copies being opened and edited at the same time.
I tried to use one drive to store the spreadsheet and access from the pc and the laptop but datasource doesnt update while both are open.
Has anyone found a work around or solution to this problem. Yes google sheets is an option in theory but all my py scripts edit an excel sheet.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 11/5/2026(UTC)
Posts: 1
|
Originally Posted by: adambou  I have a stack of scripts that manipulate an excel spread sheet that i use as a data source drift boss. sometimes things go wrong and i need to adjust or edit the spreadsheet but i really need to make edits from a network connected laptop and not my vmix pc. there are locking issues with excel that prevent 2 copies being opened and edited at the same time. I tried to use one drive to store the spreadsheet and access from the pc and the laptop but datasource doesnt update while both are open. Has anyone found a work around or solution to this problem. Yes google sheets is an option in theory but all my py scripts edit an excel sheet. Have you considered using a small database like SQLite or PostgreSQL instead of Excel? Your Python scripts could read and update the data while you edit it remotely from your laptop. Another option is a simple web-based interface for making changes without opening the spreadsheet directly. This could help avoid the file-locking issues.
|
|
|
|
|
|
vMix Forums
»
General
»
General Discussion
»
Update Excel Data source from non vmix machine
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
Important Information:
The vMix Forums uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
More Details
Close
