Inserts and formats a table into a Microsoft Excel report. The data type you wire to the text data input determines the polymorphic instance to use.


icon

Inputs/Outputs

  • cu16.png font settings source —

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

  • ccclst.png font —

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

  • cstr.png font name —

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

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

  • ci32.png iteration —

    Iteration specifies the loop iteration count if you are adding data to an Excel worksheet within a loop.

  • 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 auto format (none) —

    auto format sets the table format using Excel preset table styles. The default is no formatting.

  • cnclst.png start (0, 0) —

    start represents the position of the top left corner of the range of cells in which the table appears.

  • ci32.png row —

    row represents the row index.

  • ci32.png column —

    column represents the column index.

  • c2dstr.png text data —

    text data contains the data for the table. Note LabVIEW limits each element of the text data array to 912 characters. If an element exceeds 912 characters, LabVIEW returns an error. Refer to the KnowledgeBase for more information about a workaround for this limitation.

  • cerrcodeclst.png error in (no error) —

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

  • cstr.png name ("") —

    name specifies a named range from which the VI performs the insertion.

  • c1dstr.png row headers —

    row headers contains the row headings.

  • c1dstr.png column headers —

    column headers contains the column headings.

  • iNI__reportlvclass.png report out —

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

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

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

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