sValueExcelWorkbookName="MyexcelFile.xlsm" sValueExcelWorksheetName="Description" sValueExcelCellName="N12" Value=sValueExcelCellName.Value
in the bottom zone of the indicator properties (folder "Compute Value & status)
setting evaluation protocol to excel.
But it doesn't work
Can somebody help me ?
Solved! Go to Solution.
Yes I think there might be some problems with the documentatiom. But try and have a look at the examples in the Demo environment, they work.
Thx, it works !
Attached document is to set values from Mega, but my code works too after few operations:
* blank indicator value in the top grid
* in indicator properties:
- override the evaluation protocole (set to excel)
- set the code => apply
* click the refresh buttom => the excel value is now in the grid
Unfortunately, my 2009-sp4 raises an exception and a to Mega mail with attached dump ... but we're about to upgrade....
As the exception raises even when generating the web site, the indicators are up to date.
Where should be the Excel file? What is the correct form to refer the file? I try several combination and I always mega show me "No Workbook name specified"
I have MEGA 2009 SP5 with Process and Supervisor licences
You have to fully qualify the Excel file in the sValueExcelWorkbookName parameter.
Look at the PNG file posted by hsoegaard