Excel API: How to trigger the excel function and collect return data from it.

[MimiKLM]

Hi,

Exactly as in the subject: how to trigger the excel function and collect return data from it using excel API?

K.

[RavensFan]

What do you mean by "the Excel function"?

Excel is a program for working on spreadsheets.  It is not a "function".

[Kyle97330]

Best guess, I think he means using ActiveX controls to put data into an Excel spreadsheet open on the same computer, then get the result of a function in Excel that depended on the cell the data was just put into.

However, the question is so vague I can't really offer much advice on how to do it.  Can you post a much more detailed description of what you are trying to accomplish?

[MimiKLM]

OK, 

Sorry for being not precise enough.

What I think to do is to have one VI with two inputs and one output (not counting errors control and indicator).

In my VI I'd like to trigger open excel pass my two inputs arguments into the function defined in excel.

Trigger this function, gather the result and return it to VI.

One codition is that the excel file cannot be saved and excell function has to return result to the VI.

How to do that?

[RavensFan]

You will have to do Excel ActiveX calls as was pointed out.  Look through the threads listed within the Excel Board .

Use Find Examples within the LabVIEW help.

Though why do you need Excel to do a calculation for you?  Why don't you just program that function yourself into real LabVIEW code?

[MimiKLM]

I have a table in excel 61x19.

Having a column and row identifier I have to pick up one number from the table and return it into the LV.

The excel file has to remain unchanged. The file cannot be saved.

So, what I thought was to define a function in the excel with two inputs and one output.

The table has to be in excel as the data there is the calibration factors produced by external application.