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


icon

Inputs/Outputs

  • cNI__reportlvclass.png —

    report in is a reference to the report whose appearance, data, and printing you want to control. Use the New Report VI to generate this LabVIEW class object.

  • cdbl.png data type —

    data type sets the type of data the VI returns.

  • cnclst.png start (0, 0) —

    start defines the beginning of the range of cells the VI returns.

  • ci32.png start row —

    start row represents the row index.

  • ci32.png start column —

    start column represents the column index.

  • cerrcodeclst.png error in (no error) —

    error in describes error conditions that occur before this VI or function runs.

  • cstr.png name ("") —

    name describes the named range from which the VI retrieves data.

  • iNI__reportlvclass.png —

    report out is a reference to the report whose appearance, data, and printing you want to control.

  • idbl.png data —

    data contains the data from the worksheet.

  • ierrcodeclst.png error out —

    error out contains error information. If error in indicates that an error occurred before this VI or function ran, error out contains the same error information. Otherwise, it describes the error status that this VI or function produces.

    • 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.