Excel Advanced VIs

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 Specific VIs

Requires: Report Generation Toolkit. This topic might not match its corresponding palette in LabVIEW depending on your operating system, licensed product(s), and target.

Use the Excel Advanced VIs to perform complex tasks in Microsoft Excel reports.

The VIs on this palette can return general LabVIEW error codes, specific report generation error codes, or specific Report Generation Toolkit error codes.

Palette ObjectDescription
Excel Get ActiveX ReferencesReturns ActiveX references to Microsoft Excel.

You can wire the references this VI returns to a Property Node or Invoke Node to configure the properties and methods available for the reference. You can use the properties and methods to control the appearance, data, and printing of a report.
Excel Get Excel LocationReturns the row and column indexes of a cell that you identify by Excel syntax.
Excel Insert FormulaInserts 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.
Excel Insert ObjectInserts an object associated with a file in the cell specified by the position/size cluster.
Excel Rename WorksheetRenames the current worksheet.
Excel Send WorkbookSends the current workbook to a list of recipients via email. You can use this VI only if you configure Microsoft Outlook or Outlook Express as the default email application.
Excel Set Excel LocationReturns the Excel syntax name of a cell that you identify by row and column indexes.
Excel Set Paper SizeSets the paper size you want to associate with a worksheet.
Excel Sort DataSorts the range of cells specified by the start and end clusters.


SubpaletteDescription
Excel Macros VIsUse the Excel Macros VIs to edit and run macros in Microsoft Excel reports.

WAS THIS ARTICLE HELPFUL?

Not Helpful