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
Suhil  
#1 Posted : Thursday, April 7, 2022 4:03:30 AM(UTC)
Suhil

Rank: Member

Groups: Registered
Joined: 4/13/2021(UTC)
Posts: 15
Germany
Location: Düsseldorf

Hi!
I found the blelow script in Vmix Fourm by:@hpages
the aim is when there is a blank row in the spreadsheet its start from the beginning.
I tried to use the script, but my text doesn't showing other rows, just remain in first row.

title or input in vmix is: title_01.gtzip
data source name is: DATA.XLSX
text layer name: text_01.text
Excel sheet name: sheet01

Thank you for your help!

Quote:

while (true)
Dim i As Integer = 0
do while i<4
Dim client = WebRequest.Create("http://127.0.0.1:8088/api/?Function=DataSourceSelectRow&Value=DATA,sheet01," & i )
Dim response = client.GetResponse()

if Input.Find("title_01.gtzip").Text("text_01.text")=""
i = 0

Elseif i=3
i=0

Else Sleep(1000)

i=i+1

end if
loop
end while





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.