Excel Get Worksheet 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 General VIs

Requires: Report Generation Toolkit

Makes a specified worksheet the current worksheet. Use the worksheet index or name parameter to specify the worksheet you want to set as current.

After you define a worksheet as current, the Excel Graphs and Pictures VIs apply to the objects in the worksheet you defined.

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.
worksheet index represents the index of the new current worksheet. The worksheet index numbers start from zero, the default.
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
name represents the name of the new current worksheet. If this parameter is empty, the VI uses the worksheet index input. Microsoft Excel uses default names such as Sheet1, Sheet2, and Sheet3. You can use the Excel Rename Worksheet VI to customize worksheet names.
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.

WAS THIS ARTICLE HELPFUL?

Not Helpful