|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.
|Excel Get ActiveX References||Returns 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 Location||Returns the row and column indexes of a cell that you identify by Excel syntax.|
|Excel Insert Formula||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.|
|Excel Insert Object||Inserts an object associated with a file in the cell specified by the position/size cluster.|
|Excel Rename Worksheet||Renames the current worksheet.|
|Excel Send Workbook||Sends 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 Location||Returns the Excel syntax name of a cell that you identify by row and column indexes.|
|Excel Set Paper Size||Sets the paper size you want to associate with a worksheet.|
|Excel Sort Data||Sorts the range of cells specified by the start and end clusters.|
|Excel Macros VIs||Use the Excel Macros VIs to edit and run macros in Microsoft Excel reports.|