Subject: Is there a way to import values without excel with good performance? Posted: 3/18/2017 Viewed: 374 times
I'm doing an automatization process in WEAP and I need to upload the initial Z1 and Initial Z2 variables for all branches.
I was tring to do that using the DataExpresion way:
WEAP.DataExpression(\Demand Sites and Catchments\CatchmentX\CoverY:Initial Z1) = var1
But it is very slow. I have 856 parameters to import and it take around 15 minutes to upload.
I'm going to run it in a Server without excel.
Is there another way to import a lot of values in WEAP without excel and with a good performance?
Subject: Re: Is there a way to import values without excel with good performance? Posted: 3/20/2017 Viewed: 313 times
No, I do not think there is a faster way to do what you want to do. Importing expressions from Excel is the only way to change multiple branch expressions at once.
One other option would be to read the Z1 and Z2 values from one or more CSV files, which you could update before each run. In this approach, the expressions would not change (ReadFromFile), but the CSV file would change.
Topic "Is there a way to import values without excel with good performance?"