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
fabfab10  
#1 Posted : Saturday, September 18, 2021 12:47:18 AM(UTC)
fabfab10

Rank: Advanced Member

Groups: Registered
Joined: 2/20/2019(UTC)
Posts: 60
Italy
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
doggy  
#2 Posted : Saturday, September 18, 2021 2:49:28 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 284 times
Was thanked: 920 time(s) in 759 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)
fabfab10  
#3 Posted : Saturday, September 18, 2021 5:39:36 AM(UTC)
fabfab10

Rank: Advanced Member

Groups: Registered
Joined: 2/20/2019(UTC)
Posts: 60
Italy
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

Floyd1  
#4 Posted : Tuesday, September 21, 2021 4:24:50 PM(UTC)
Floyd1

Rank: Newbie

Groups: Registered
Joined: 9/21/2021(UTC)
Posts: 1
Bahrain
Location: Chicago

Amazing Content on this website.I Like it.Thanks for sharing....www.mygroundbiz.com
Royse64  
#5 Posted : Thursday, September 23, 2021 9:55:23 PM(UTC)
Royse64

Rank: Newbie

Groups: Registered
Joined: 9/23/2021(UTC)
Posts: 1
United States

Originally Posted by: fabfab10 Go to Quoted Post
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.
Users browsing this topic
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.