data in excel update

Q and A about functionality and how to solve a special task for your application.

data in excel update

Postby 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

Postby alfred » 21 Mar 2013, 08:28

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

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

Re: data in excel update

Postby Oliver » 22 Mar 2013, 13:45

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

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

Re: data in excel update

Postby 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
alfred
 
Posts: 79
Joined: 12 Jul 2012, 03:26

Re: data in excel update

Postby 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!
User avatar
Daniel Willer
 
Posts: 297
Joined: 06 Jan 2012, 18:12

Re: data in excel update

Postby 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

Postby 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.
cogitator
 
Posts: 2
Joined: 04 Mar 2016, 14:33


Return to How to...