logo

Live Production Software Forums

www.vmix.com

Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
DATA SOURCES IN EXCEL - AUTOMATIC PLAY EXECEL DATA IN COLUMN A TO B,C,D,E,F....
Options
Go to last post Go to first unread
Previous Topic Next Topic
kalpesh175  
#1 Posted : Tuesday, January 5, 2021 9:04:07 PM(UTC)
kalpesh175

Rank: Newbie

Groups: Registered
Joined: 9/10/2020(UTC)
Posts: 7
Man
India
Location: Ahmedabad
AUTOMATIC PLAY EXCEL DATA IN COLUMN A TO B,C,D,E,F....

WHEN WE PLAY AUTO NEXT IN EXCEL SHEET SYSTEM PLAY COLUMN 1 AND ROW 1,2, 3,4 BUT I PLAY COLUMN 1-1 AFTER COLUMN - EXEL DATA.png (23kb) downloaded 69 time(s). 2-1 ,COLUMN - 3-1 ETC

AS PER EXAMPLE EXCEL SHEET HOW TO PLAY 101->201->301->401->501

WHAT IS PROSSES
Back to top

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
doggy  
#2 Posted : Wednesday, January 6, 2021 1:14:06 AM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 5,427
Belgium
Location: Belgium

Thanks: 309 times
Was thanked: 996 time(s) in 826 post(s)
There is no reason to SHOUT !

would advice to have another look on how datasources can/need to be used and maybe the convert rows to columns might be an options
Best option would be to restructure your excel file
Of you are familiare with scripting ( coding) you could make some elaborate code to do what you want
Back to top
kalpesh175  
#3 Posted : Wednesday, August 13, 2025 5:34:19 PM(UTC)
kalpesh175

Rank: Newbie

Groups: Registered
Joined: 9/10/2020(UTC)
Posts: 7
Man
India
Location: Ahmedabad
scripting ( coding)
PLS GIVE ME
I DONT KNOW

CHANGE COLUMN A TO B,C,D,E,F.....
Back to top
mavik  
#4 Posted : Thursday, August 14, 2025 12:14:45 AM(UTC)
mavik

Rank: Advanced Member

Groups: Registered
Joined: 4/23/2017(UTC)
Posts: 1,354
Man
Location: Germany

Thanks: 3 times
Was thanked: 180 time(s) in 162 post(s)
The datasorce is using row by row. Not column by column.

What comes to my mind is to use two dynamic variables. One for row and one for column.
Back to top
WWW
Henny  
#5 Posted : Thursday, August 14, 2025 8:11:50 AM(UTC)
Henny

Rank: Advanced Member

Groups: Registered
Joined: 5/14/2013(UTC)
Posts: 146
Man
Location: uk

Thanks: 2 times
Was thanked: 26 time(s) in 22 post(s)
Do a v lookup with a drop down in the excel to put whatever data you want into the cells Vmix is looking at
Back to top
thanks 1 user thanked Henny for this useful post.
Stealth77 on 8/17/2025(UTC)
LuxGarden  
#6 Posted : Sunday, August 31, 2025 3:03:04 AM(UTC)
LuxGarden

Rank: Newbie

Groups: Registered
Joined: 8/31/2025(UTC)
Posts: 1
United States
Location: NY
Originally Posted by: doggy Go to Quoted Post
There is no reason to SHOUT !

would advice to have another look on how datasources can/need to be used and maybe the convert rows to columns might be an options
Best option would be to restructure your excel file
Of you are familiare with scripting ( coding) you could make some elaborate code to do what you want. OneBloodRewards


I totally agree, no need to shout! Thanks for the advice — I’ll definitely check out the datasource options and see if converting rows to columns works better. Restructuring the Excel file might be a good idea too. I’m familiar with coding, so I’ll consider writing a script if needed. Appreciate the input!
Back to top
WWW
Users browsing this topic
Guest
Similar Topics
DATA SOURCES IN EXCEL FILE AND GT DESIGNER (3rd Party Software and Development)
by kalpesh175 9/10/2020 3:49:49 PM(UTC)
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.

Privacy Policy | Powered by YAF.NET | YAF.NET © 2003-2025, Yet Another Forum.NET
This page was generated in 0.151 seconds.