How to set/refresh indicator value from an excel worksheet?

[pjambon]

Hello

I tried

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 ?

Regards.

[hsoegaard]

Hi,

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.

[pjambon]

Hope they work !

Can you drive me to THE example ?

[hsoegaard · Accepted solution]

Yes, in the MEGA Tutorial repository, look for the two Indicators: "Monthly Number of ..."

[pjambon · Accepted solution]

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.

Regards

[hcontreras]

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

[pjambon]

You have to fully qualify the Excel file in the sValueExcelWorkbookName parameter.

Look at the PNG file posted by hsoegaard