Hi,
I have a model which reads input data from Excel using the GET XLS CONSTANTS function.
I try to run this model via a Python interface in multiprocessing. In other words, I create multiple instances of the model and its input files. Vensim and Excel are perfectly fine in multiprocessing when they are used alone, i.e. multiple instances of the same file can be used in multiprocessing. However, when the Vensim file imports from Excel, I get file access errors because Vensim is trying to read from the Excel files with the same name.
I will appreciate any suggestion to solve this problem.
Importing data from excel in multiprocessing
-
- Super Administrator
- Posts: 4590
- Joined: Wed Mar 05, 2003 3:10 am
Re: Importing data from excel in multiprocessing
Are you attempting to run this on a web server?
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
Re: Importing data from excel in multiprocessing
No, I run it on my local machine.
-
- Super Administrator
- Posts: 4590
- Joined: Wed Mar 05, 2003 3:10 am
Re: Importing data from excel in multiprocessing
The normal Vensim DLL cannot be used for multi-processing. A search of Google will give you much more information on why it cannot be done.
https://www.google.com/search?client=fi ... 72&dpr=1.5
https://www.google.com/search?client=fi ... 72&dpr=1.5
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559