Excel Insert Formula VI

LabVIEW 2018 Report Generation Toolkit for Microsoft Office Help

Edition Date: June 2018

Part Number: 370274M-01

»View Product Info
Download Help (Windows Only)

Owning Palette: Excel Advanced VIs

Requires: Report Generation Toolkit

Inserts a formula in the cell defined by the start cluster. If you use the name parameter to specify a named range, the VI inserts the formula from the top left cell of the range.

A formula is an equation that performs operations on worksheet data. Formulas can perform mathematical operations, such as addition and multiplication, or they can compare worksheet values or join text. Formulas can refer to other cells on the same worksheet, cells on other sheets in the same workbook, or cells on sheets in other workbooks. Refer to the Microsoft Excel Help for more information about formulas.

Example

report in is a reference to the report whose appearance, data, and printing you want to control. Use the Create Report VI to generate this LabVIEW class object.
formula specifies the formula to insert in the specified cell.
start contains the row and column indexes of the cell in which the VI inserts the formula.
rows specifies the row index.
columns specifies the column index.
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
name specifies a named range from which the VI performs the insertion. If the named range covers multiple cells, the insertion appears in the top left corner of the range.
report out is a reference to the report whose appearance, data, and printing you want to control. You can wire this output to other Report Generation VIs.
error out contains error information. This output provides standard error out functionality.

Example

Refer to the Insert Formulas in Spreadsheet VI in the labview\examples\office\Excel Reports.llb for an example of using the Excel Insert Formula VI.

WAS THIS ARTICLE HELPFUL?

Not Helpful