logo

Live Production Software Forums


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

Notification

Icon
Error

Options
Go to last post Go to first unread
AndrewH  
#1 Posted : Thursday, April 9, 2026 2:13:15 PM(UTC)
AndrewH

Rank: Newbie

Groups: Registered
Joined: 4/1/2026(UTC)
Posts: 2
United States
Location: Michigan

I would like to get my data source to reset to row 3 whenever it hits a empty row as the data we have coming in is always changing the number of rows we have. This is the current script I have that works great to rotate throughout a certain amount of rows but if I have it set to rows 3-6 as thats about the max we would need but only 3 & 4 are getting used it sits on row 4 for the time that it would be on 5 & 6 if there was data in there.

' Define your range (vMix indices start at 0)
Dim startRow As Integer = 2 ' Actual row 3
Dim endRow As Integer = 3 ' Actual row 4
Dim delay As Integer = 10000 ' Time in milliseconds (10 seconds)
Dim dataSource As String = "TimingTest" ' Your Data Source Name
Dim table As String = "Sheet1" ' Your Table Name
Do While True
For i As Integer = startRow To endRow
' Select the row
API.Function("DataSourceSelectRow", Value:=dataSource & "," & table & "," & i)
Sleep(delay)
Next
Loop
AndrewH  
#2 Posted : Thursday, April 9, 2026 2:21:59 PM(UTC)
AndrewH

Rank: Newbie

Groups: Registered
Joined: 4/1/2026(UTC)
Posts: 2
United States
Location: Michigan

doggy  
#3 Posted : Thursday, April 9, 2026 4:09:03 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 316 times
Was thanked: 1020 time(s) in 838 post(s)
Originally Posted by: AndrewH Go to Quoted Post
I would like to get my data source to reset to row 3 whenever it hits a empty row as the data we have coming in is always changing the number of rows we have. This is the current script I have that works great to rotate throughout a certain amount of rows but if I have it set to rows 3-6 as thats about the max we would need but only 3 & 4 are getting used it sits on row 4 for the time that it would be on 5 & 6 if there was data in there.

' Define your range (vMix indices start at 0)
Dim startRow As Integer = 2 ' Actual row 3
Dim endRow As Integer = 3 ' Actual row 4
Dim delay As Integer = 10000 ' Time in milliseconds (10 seconds)
Dim dataSource As String = "TimingTest" ' Your Data Source Name
Dim table As String = "Sheet1" ' Your Table Name
Do While True
For i As Integer = startRow To endRow
' Select the row
API.Function("DataSourceSelectRow", Value:=dataSource & "," & table & "," & i)
Sleep(delay)
Next
Loop


Do a check on the data being "empty" by means of a title content read
Users browsing this topic
Guest
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.