Excel Get Data 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

Retrieves data from the current worksheet. The data type you wire to the data type input determines the polymorphic instance to use.

Details  

Use the pull-down menu to select an instance of this VI.

Excel Get Data (str)

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.
data type sets the type of data the VI returns.
start defines the beginning of the range of cells the VI returns.
start row represents the row index.
start column represents the column index.
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
name describes the named range from which the VI retrieves data.
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.
data contains the data from the worksheet.
error out contains error information. This output provides standard error out functionality.

Excel Get Data (dbl)

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.
data type sets the type of data the VI returns.
start defines the beginning of the range of cells the VI returns.
start row represents the row index.
start column represents the column index.
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
name describes the named range from which the VI retrieves data.
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.
data contains the data from the worksheet.
error out contains error information. This output provides standard error out functionality.

Excel Get Data ([str])

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.
data type sets the type of data the VI returns.
start defines the beginning of the range of cells returned. If neither start nor end are wired, the VI returns the used section of the worksheet. If start is wired but end is unwired, the VI returns the unique cell specified by start. If both start and end are wired, the VI returns the range of cells between start and end.
rows specifies the row index.
columns specifies the column index.
end defines the end of the range of cells returned. If neither start nor end are wired, the VI returns the used section of the worksheet. If start is wired but end is unwired, the VI returns the unique cell specified by start. If both start and end are wired, the VI returns the range of cells between start and end.
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 describes the named range from which the VI retrieves data.
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.
data contains the data from the worksheet.
error out contains error information. This output provides standard error out functionality.

Excel Get Data ([dbl])

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.
data type sets the type of data the VI returns.
start defines the beginning of the range of cells returned. If neither start nor end are wired, the VI returns the used section of the worksheet. If start is wired but end is unwired, the VI returns the unique cell specified by start. If both start and end are wired, the VI returns the range of cells between start and end.
rows specifies the row index.
columns specifies the column index.
end defines the end of the range of cells returned. If neither start nor end are wired, the VI returns the used section of the worksheet. If start is wired but end is unwired, the VI returns the unique cell specified by start. If both start and end are wired, the VI returns the range of cells between start and end.
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 describes the named range from which the VI retrieves data.
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.
data contains the data from the worksheet.
error out contains error information. This output provides standard error out functionality.

Excel Get Data (i32)

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.
data type sets the type of data the VI returns.
start defines the beginning of the range of cells the VI returns.
start row represents the row index.
start column represents the column index.
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
name describes the named range from which the VI retrieves data.
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.
data contains the data from the worksheet.
error out contains error information. This output provides standard error out functionality.

Excel Get Data ([i32])

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.
data type sets the type of data the VI returns.
start defines the beginning of the range of cells returned. If neither start nor end are wired, the VI returns the used section of the worksheet. If start is wired but end is unwired, the VI returns the unique cell specified by start. If both start and end are wired, the VI returns the range of cells between start and end.
rows specifies the row index.
columns specifies the column index.
end defines the end of the range of cells returned. If neither start nor end are wired, the VI returns the used section of the worksheet. If start is wired but end is unwired, the VI returns the unique cell specified by start. If both start and end are wired, the VI returns the range of cells between start and end.
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 describes the named range from which the VI retrieves data.
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.
data represents the data the worksheet returns.
error out contains error information. This output provides standard error out functionality.

Excel Get Data Details

To return a numeric value, use the start cluster or the name input to specify the cell from which you want to return the value. To return an array, wire both the start and end clusters or the name input to specify the range from which you want to return the array. If the start and end clusters remain unwired, the VI returns the entire used section of the current worksheet.

Note  If the worksheet contains both strings and numeric values, connect a 2D array of strings to the data type input. Otherwise, the VI returns an error.

WAS THIS ARTICLE HELPFUL?

Not Helpful