Importing data from excel in multiprocessing

[sibel]

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.

[Administrator]

Are you attempting to run this on a web server?

[sibel]

No, I run it on my local machine.

[Administrator]

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