vMix Forums
»
General
»
General Discussion
»
Different datasources referring to the same excel file
Rank: Advanced Member
Groups: Registered
Joined: 2/20/2019(UTC) Posts: 63  Location: Firenze Was thanked: 5 time(s) in 5 post(s)
|
Hello everyone,
maybe this topic has been already discussed , i haven't been able to find any post.
I have an excel file , automatically generated by an external software which is made of different sheets containing different data.
I created a datasource "DATASOURCE1" pointing to the first sheet, selected in the combo box , and mapped to a graphic.
I have tried to create a new datasource, "DATASOURCE2" , pointing to the same file in order to use data in the second sheet.
When i select the 2nd sheet from the combo box, also datasource1 change its setting to this sheet.
I would need access and map data from different sheets to some graphics.
How can i handle this situation, provided i have no control on the file format?
Thank you in advance
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,216  Location: Belgium Thanks: 291 times
Was thanked: 955 time(s) in 790 post(s)
|
But what happens when you link the data to a title ?
Might as well just open the Excel only once and again specify the different sheet to use in the title ( will e less confusing when using)
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 2/20/2019(UTC) Posts: 63 Location: Firenze Was thanked: 5 time(s) in 5 post(s)
|
I did a stupid question, my bet!!
I was selecting the sheet in the datasource definition and not in the graphic field section.
Actually what i need can be done with a single datasource and then selecting the proper sheet for each single field.
I'm sorry
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 9/21/2021(UTC) Posts: 1  Location: Chicago
|
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 9/23/2021(UTC) Posts: 1 
|
Originally Posted by: fabfab10  Hello everyone, maybe this topic has been already discussed , i haven't been able to find any post. I have an excel file , automatically generated by an external software which is made of different sheets containing different data. I created a datasource "DATASOURCE1" pointing to the first sheet, selected in the combo box , and mapped to a graphic. I have tried to create a new datasource, "DATASOURCE2" , pointing to the same file in order to use data in the second sheet. When i select the 2nd sheet from the combo box, also datasource1 change its setting to this sheet. I would need access and map data from different sheets to some graphics. How can i handle this situation, provided i have no control on the file format? Thank you in advance MyLowesLife On the Excel Ribbon's Data tab, click Advanced. In the Advanced Filter dialog box, choose 'Copy to another location'. For the List range, select the column(s) from which you want to extract the unique values. Leave the Criteria Range blank.
|
|
|
|
|
|
vMix Forums
»
General
»
General Discussion
»
Different datasources referring to the same excel file
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
