data in excel update

Q and A about functionality and how to solve a special task for your application.
Post Reply
alfred
Posts: 79
Joined: 12 Jul 2012, 03:26

data in excel update

Post by alfred » 21 Mar 2013, 07:51

The data in the .vzp/.vza file can be updated after i changed the data of the linked excel. But the the data in .vpr file can't be updated after i change the data of the linked excel. Is it possible for me to do so?
I do the test with the file downloaded from Ventuz website.

Thx
alfred

alfred
Posts: 79
Joined: 12 Jul 2012, 03:26

Re: data in excel update

Post by alfred » 21 Mar 2013, 08:28

I have solved the problem, it is my mistake ;)

alfred

User avatar
Oliver
Posts: 67
Joined: 12 Jan 2012, 10:38

Re: data in excel update

Post by Oliver » 22 Mar 2013, 13:45

maybe you like to post your mistake here.
Everybody using the search will have an answer then :)

cheers

alfred
Posts: 79
Joined: 12 Jul 2012, 03:26

Re: data in excel update

Post by alfred » 22 Mar 2013, 17:14

sorry for that :oops:
As creating a project file, if the excel is in the folder of data, the "reference" can't be checked, so the data in .vpr file can't be upgraded . But if I move the excel from the data folder to other folder, I can check the reference and the data in .vpr file can be upgraded .
that is my experience :D

alfred

User avatar
Daniel Willer
Posts: 309
Joined: 06 Jan 2012, 18:12

Re: data in excel update

Post by Daniel Willer » 25 Mar 2013, 10:22

Another solution would be to reference your files with an relative path. Therefore you need to use an URL node and set the Scheme to File.
Then you can reference files relative to your project file.
Check the UserManual for more info.

Cheers!

cogitator
Posts: 2
Joined: 04 Mar 2016, 14:33

Re: data in excel update

Post by cogitator » 30 Mar 2016, 12:38

Sorry for picking up this old thread!

I have the same problem.
My excel-file "database.xlsx" is located in a Folder "Excel" in the Project Folder.
The File Name of the Excel Workbook node(AutoUpdate activated) is feeded by an URL Node (Path "./Excel/database.xlsx" Scheme "FILE").
Changes of the excel-file in the Designer are no problem. But if I export the Scene as a Presentation there is no reaction on changes in the excel-file. Even if I close the presentation make the changes in the excel-file and start the presentation again the changes are ignored.

Thanks for your help in advance.

Cheers
David

cogitator
Posts: 2
Joined: 04 Mar 2016, 14:33

Re: data in excel update

Post by cogitator » 31 Mar 2016, 17:26

I solved the problem.

I just had to export the presentation in the root of the project-folder. Otherwise the relative path crashed, when I exported into the "Presentations" folder.

Post Reply