Inserts text into a Microsoft Excel report.


icon

Inputs/Outputs

  • cu16.png font settings source

    font settings source specifies the way in which you want to select font settings.

    The VI ignores this input for HTML and standard reports.

  • ccclst.png font

    font sets the font attributes that the VI uses when formatting.

    The VI ignores this input if you wire the autoformat input.

  • cstr.png font name

    font name specifies the name of the font you want to use, such as Times New Roman.

    If you misspell the font name or specify a font that is not installed on the computer, the operating system selects a font.

  • cdbl.png font size

    font size specifies the size at which you want the font to appear, in points.

  • cu16.png bold

    bold specifies whether the text is in bold. The default is bolded text.

  • cu16.png italic

    italic specifies whether the text is in italics. By default, the control does not change the text settings.

  • cu16.png underline

    underline specifies whether the text is underlined. By default, the control does not change the text settings.

  • cu16.png strike through

    strike through specifies whether the text contains a strikethrough line. By default, the control does not change the text settings.

  • cu32.png font color

    font color allows you to select the color of the font from a color table. The default is transparency.

  • cbool.png border? (F)

    border? determines whether a border encloses the text.

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

  • cstr.png text

    text contains the text to insert into the worksheet.

  • cnclst.png start (-1, -1)

    start represents the position of the top left corner of the range of cells that the VI merges before inserting the text.

  • ci32.png row

    row represents the row index of the cell.

  • ci32.png column

    column represents the column index of the cell.

  • cnclst.png end (-1, -1)

    end represents the position of the bottom right corner of the range of cells that the VI merges before inserting the text.

  • ci32.png row

    row represents the row index of the cell.

  • ci32.png column

    column represents the column index of the cell.

  • cerrcodeclst.png error in (no error)

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

  • cstr.png name ("")

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

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

  • icclst.png font out

    font out contains the font settings the VI uses for formatting, which you can use in other VIs. The values are valid for all report types.

  • istr.png font name

    font name indicates the name of the font used, such as Times New Roman.

  • idbl.png font size

    font size indicates the size at which the font appears, in points.

  • iu16.png bold

    bold indicates whether the text is in bold.

  • iu16.png italic

    italic indicates whether the text is in italics.

  • iu16.png underline

    underline indicates whether the text is underlined.

  • iu16.png strike through

    strike through indicates whether the text is struck through.

  • iu32.png font color

    font color indicates the color of the text.

  • inclst.png next cell bottom-left

    next cell bottom-left returns the position of the cell located next to the bottom left corner of the range that the start and end clusters define.

    You can insert the output values in the start input of the Excel Easy Text, Excel Easy Table, or Excel Easy Graph VIs to append new elements below.

  • ii32.png row

    row represents the row index of the cell.

  • ii32.png column

    column represents the column index of the cell.

  • inclst.png next cell top-right

    next cell top-right returns the position of the cell located next to the top right corner of the range that the start and end clusters define.

    You can insert the output values in the start input of the Excel Easy Text, Excel Easy Table, or Excel Easy Graph VIs to append new elements on the left side.

  • ii32.png row

    row represents the row index of the cell.

  • ii32.png column

    column represents the column index of the cell.

  • ierrcodeclst.png error out

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