Page 1 of 1
data in excel update
Posted: 21 Mar 2013, 07:51
by alfred
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
Re: data in excel update
Posted: 21 Mar 2013, 08:28
by alfred
I have solved the problem, it is my mistake
alfred
Re: data in excel update
Posted: 22 Mar 2013, 13:45
by Oliver
maybe you like to post your mistake here.
Everybody using the search will have an answer then
cheers
Re: data in excel update
Posted: 22 Mar 2013, 17:14
by alfred
sorry for that
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
alfred
Re: data in excel update
Posted: 25 Mar 2013, 10:22
by Daniel Willer
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!
Re: data in excel update
Posted: 30 Mar 2016, 12:38
by cogitator
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
Re: data in excel update
Posted: 31 Mar 2016, 17:26
by cogitator
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.