logo

Live Production Software Forums

www.vmix.com

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

Notification

Icon
Error
Excel Data Sheets - How to change data by changing Data sheet
Options
Go to last post Go to first unread
Previous Topic Next Topic
FrankLeggett  
#1 Posted : Thursday, July 16, 2020 5:15:53 PM(UTC)
FrankLeggett

Rank: Advanced Member

Groups: Registered
Joined: 11/22/2018(UTC)
Posts: 94
United Kingdom
Location: Worthing

Thanks: 1 times
Was thanked: 4 time(s) in 3 post(s)
Hi,

I have a spreadsheet with each race listed on a differrent sheet on an excel spreadsheet.

Is it possible to change the text on the title just by changing the sheet. At present I am having to create a Title for each race taking data from a different sheet. I would like to have just one title that changed all the data in the textboxes so they pulled data from a different sheet.

Any ideas?
Back to top

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
DWAM  
#2 Posted : Thursday, July 16, 2020 5:31:13 PM(UTC)
DWAM

Rank: Advanced Member

Groups: Registered
Joined: 3/20/2014(UTC)
Posts: 2,721
Man
France
Location: Bordeaux, France

Thanks: 243 times
Was thanked: 794 time(s) in 589 post(s)
your datasource is linked to a sheet data.
if you want to go this route (which is not a good idea imho) you can simply modify your datasource setting to use another sheet
Back to top
WWW
doggy  
#3 Posted : Thursday, July 16, 2020 5:40:17 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 294 times
Was thanked: 960 time(s) in 794 post(s)
the "quickest" way it to rename the sheet in the excel file to the name you have it set in the title editor
Back to top
thanks 1 user thanked doggy for this useful post.
FrankLeggett on 7/16/2020(UTC)
FrankLeggett  
#4 Posted : Thursday, July 16, 2020 7:21:50 PM(UTC)
FrankLeggett

Rank: Advanced Member

Groups: Registered
Joined: 11/22/2018(UTC)
Posts: 94
United Kingdom
Location: Worthing

Thanks: 1 times
Was thanked: 4 time(s) in 3 post(s)
I had the same thought from a different angle which is to create a Current Sheet and copy and paste the sheet I want into it and use Current as the Sheet the data is drawn from. I was hoping that there was a way to do it from the Data Manage box by changing the sheet there.
Back to top
DWAM  
#5 Posted : Thursday, July 16, 2020 7:55:30 PM(UTC)
DWAM

Rank: Advanced Member

Groups: Registered
Joined: 3/20/2014(UTC)
Posts: 2,721
Man
France
Location: Bordeaux, France

Thanks: 243 times
Was thanked: 794 time(s) in 589 post(s)
Quote:
I was hoping that there was a way to do it from the Data Manage box by changing the sheet there.

That's exactly what I told you to do in the first place !

1st sheet
Presse-papier01.jpg (33kb) downloaded 2 time(s).

step 2 - change setting for datasource
Presse-papier02.jpg (35kb) downloaded 0 time(s).

now you're using 2nd sheet as the source for your data
Presse-papier03.jpg (36kb) downloaded 0 time(s).
Back to top
WWW
doggy  
#6 Posted : Thursday, July 16, 2020 8:12:35 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 294 times
Was thanked: 960 time(s) in 794 post(s)
Originally Posted by: DWAM Go to Quoted Post
Quote:
I was hoping that there was a way to do it from the Data Manage box by changing the sheet there.

That's exactly what I told you to do in the first place !

1st sheet


step 2 - change setting for datasource


now you're using 2nd sheet as the source for your data




Have to disagree on this one DWAM as one specifies the sheet again in the title editor and doesn't follow the sheet selection in the Data Source Manager
Back to top
DWAM  
#7 Posted : Thursday, July 16, 2020 9:27:29 PM(UTC)
DWAM

Rank: Advanced Member

Groups: Registered
Joined: 3/20/2014(UTC)
Posts: 2,721
Man
France
Location: Bordeaux, France

Thanks: 243 times
Was thanked: 794 time(s) in 589 post(s)
You're right Doggy

Then why not simply change the Sheet in the Title Editor? I just checked it works

Presse-papier04.jpg (46kb) downloaded 1 time(s).
Back to top
WWW
doggy  
#8 Posted : Thursday, July 16, 2020 9:31:37 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 294 times
Was thanked: 960 time(s) in 794 post(s)
Originally Posted by: DWAM Go to Quoted Post
You're right Doggy

Then why not simply change the Sheet in the Title Editor? I just checked it works


Sure as long as one is not using it for a ranking list display or liek participant list etc ;-)
Back to top
FrankLeggett  
#9 Posted : Friday, July 17, 2020 2:16:13 AM(UTC)
FrankLeggett

Rank: Advanced Member

Groups: Registered
Joined: 11/22/2018(UTC)
Posts: 94
United Kingdom
Location: Worthing

Thanks: 1 times
Was thanked: 4 time(s) in 3 post(s)
Thanks for all the responses. I have a page with about 40 Text boxes linked to a sheet so I can't change over the sheet in the data source for each text box quickly.

I have found the importing of Spreadsheet data to be hit and miss.
For Example:
For no reason I can see some imported spreadsheets have blank rows under the data and some just have populated rows only.
Also I have found using the Shrink function doesn't work uniformly I have some names reduced in even the text length isn't too long for the textbox. All the settings are the same but some names are shrink and some aren't.
Here are 2 words that different sizes "Ken Smith" (This one is reduced in size) "Jimmy Allen" (This one stays the same size), I have copied and pasted these 2 names into the same cells and "Ken Smith" is still reduced.

** The shrink function issue was caused by there being extra blank spaces in the cell that I was unaware of **
Back to top
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.

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