Rank: Newbie
Groups: Registered
Joined: 4/1/2026(UTC) Posts: 2  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
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 4/1/2026(UTC) Posts: 2  Location: Michigan
|
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,509  Location: Belgium Thanks: 315 times Was thanked: 1020 time(s) in 838 post(s)
|
Originally Posted by: AndrewH  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
|
|
|
|
|
|
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