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


icon

Inputs/Outputs

  • cNI__reportlvclass.png report in —

    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.

  • ci32.png offset —

    offset specifies the number of rows by which you want to offset the output in MS Office parameters. The default is 0.

  • cerrcodeclst.png error in (no error) —

    error in describes error conditions that occur before this node runs. This input provides standard error in functionality.

  • ccclst.png MS Office parameters —

    MS Office parameters specifies the point in a Microsoft Word or Excel report where you want an insertion to occur. The VI ignores this input for HTML and standard reports.

    You can specify a bookmark in Word or a named range or cell coordinates in Excel. If you set the report type to Word but do not specify a bookmark, the insertion occurs at the end of the document.

  • cnclst.png position (excel) —

    position contains the row and column coordinates of the point in an Excel worksheet from which the insertion occurs.

    Row and column values in Excel are zero-based, so the row and column coordinates of (0,0) correspond to cell A1.

  • ci32.png row —

    row represents the row index.

  • ci32.png column —

    column represents the column index.

  • cstr.png name (excel) —

    name contains the name of the cell in a Microsoft Excel worksheet from which the insertion occurs.

  • cstr.png bookmark (word) —

    bookmark contains the name of the bookmark in a Word document from which the insertion occurs.

  • iNI__reportlvclass.png report out —

    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.

  • ierrcodeclst.png error out —

    error out contains error information. This output provides standard error out functionality.

  • icclst.png MS Office parameters out —

    MS Office parameters out contains the MS Office parameters input values and the contents of the row.

  • inclst.png position (excel) —

    position (Excel) contains the row and column coordinates of the point in an Excel worksheet from which the insertion occurred.

    Row and column values in Excel are zero-based, so the row and column coordinates of (0,0) correspond to cell A1.

  • ii32.png row —

    row returns the row index.

  • ii32.png column —

    column returns the column index.

  • istr.png name (excel) —

    name (Excel) contains the name of the cell in an Excel worksheet from which the insertion occurred.

  • istr.png bookmark (word) —

    bookmark (Word) contains the name of the bookmark in a Word document from which the insertion occurred.