How do you load a formula into the Excel file before you run the LabVIEW program

[GaryLT]

Hello,

I have a LabVIEW program that runs efficiency measurements on DC to DC power supplies.  It generates an Excel file with all the data (voltages and currents of the input and output). 

What I would like to do is calculate the efficiency of the power supply in the Excel spreadsheet.  How to I load a column in the Excel file with a formula before I run the LabVIEW program.

If that is possible, the next thing I would like to do is display a graph on the LabVIEW front panel of the efficiency data that is in the Excel file.

Thanks,

Gary

[johnsold]

Gary,

Why not calculate the efficiency in LabVIEW, display it in whatever format you want, and then save both the measured and calculated data to Excel? LabVIEW can calculate almost anything Excel can and can do some things much better.

Lynn

[Ecleamus]

Hi Gary,

If you have the LabVIEW Report Generation Toolkit for Microsoft Office, you can use the Excel Insert Formula.vi.  Otherwise you will need to use ActiveX to perform the same functionality.  Consult the MSDN website for the Excel identifier(s) that will allow you to insert the formula via an ActiveX control.
Ecleamus Ricks, Jr.
National Instruments
Applications Engineer