LabWindows/CVI

cancel
Showing results for 
Search instead for 
Did you mean: 

What's the right method to write a formula to Excel, being Excel the ActiveX server?

I can write any data to Excel and modify the properties of the worksheet. However,every time I try to assign a cell a simple function as:
=AVERAGE(A1:A20)
the Excel worksheet shows the error message "#NAME?" in that cell, meanning it doesn't recognize the function. However, when I manually select the function (F2) for editing and press ENTER, Excel exceutes it. I'm using the ExcelRangeSetItem function to assign values to a cell.
0 Kudos
Message 1 of 2
(2,714 Views)
I think you can use ExcelRpt_SetCellRangeAttribute(), a function in ExcelReport driver. The fp file for the drive is in dirctory "\MeasuresurementStudio\cvi\samples\activex\excel" if you cvi version is 6.0. Using this function, you can set a lot of properties for a cell or a range of cell(cellrange). Good luck.
0 Kudos
Message 2 of 2
(2,714 Views)