Excel General 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 General VIs to perform general tasks in Microsoft Excel reports, such as adding and retrieving worksheets, inserting cells, and searching worksheets.

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 Add WorksheetAdds a new worksheet to the worksheet collection.
Excel Bring to FrontChanges the state of a Microsoft Excel window to minimized, maximized, or normal.
Excel Find and ReplaceSearches the occurrences of searched string and replaces them with a new string or numeric value. The data type you wire to the replacement input determines the polymorphic instance to use.
Excel Get DataRetrieves data from the current worksheet. The data type you wire to the data type input determines the polymorphic instance to use.
Excel Get Last RowRetrieves the coordinates of the last row in an Excel worksheet. Use the MS Office parameters input to append the contents of the row to a report.
Excel Get WorksheetMakes a specified worksheet the current worksheet. Use the worksheet index or name parameter to specify the worksheet you want to set as current.
Excel Insert CellsInserts a new cell, row, or column into the current worksheet from a position that the row and column indexes specify.
Excel Set Page NumberingActivates the page numbering on the current document.
Excel Workbook PropertiesSets the properties of the current workbook, such as the author, title, and subject. You also can use this VI to return the number of worksheets in the current workbook.

WAS THIS ARTICLE HELPFUL?

Not Helpful