cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

Solved
Occasional Contributor

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

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 Man Sad

 

Can somebody help me ?

 

Regards.

6 Replies
Highlighted
MEGA Partner

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

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.

Occasional Contributor

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

Hope they work !

 

Can you drive me to THE example ?

MEGA Partner

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

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

 

 

Occasional Contributor

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

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

New Contributor

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

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

Occasional Contributor

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

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

Look at the PNG file posted by hsoegaard