Company Events Academic Community Support Solutions Products & Services Contact NI MyNI

Excel Easy Table VI

LabVIEW 2013 Report Generation Toolkit for Microsoft Office Help

Edition Date: June 2013

Part Number: 370274G-01

»View Product Info

Owning Palette: Excel Specific VIs

Requires: Report Generation Toolkit

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.

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

Excel Easy Table (str)

font settings source specifies the way in which you want to select font settings. The VI ignores this input for HTML and standard reports.

0VI Inputs (default)—The VI uses the values you set in the font input. If you do not wire font, the VI uses the default font settings of the report class.
1Font Dialog Box—A dialog box appears that you can use to select font settings.
font sets the font attributes that the VI uses when formatting. The VI ignores this input if you wire the autoformat input.
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.
font size specifies the size at which you want the font to appear, in points.
bold specifies whether the text is in bold. The default is bolded text.
italic specifies whether the text is in italics. By default, the control does not change the text settings.
underline specifies whether the text is underlined. By default, the control does not change the text settings.
strike through specifies whether the text contains a strikethrough line. By default, the control does not change the text settings.
font color allows you to select the color of the font from a color table. The default is transparency.
Iteration specifies the loop iteration count if you are adding data to an Excel worksheet within a loop.
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.
auto format sets the table format using Excel preset table styles. The default is no formatting. In Excel, select Format»AutoFormat to view examples of Excel table styles.
start represents the position of the top left corner of the range of cells in which the table appears.
rows specifies the row index.
columns specifies the column index.
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.
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
name specifies a named range from which the VI performs the insertion. If the named range covers multiple cells, the insertion appears in the top left corner of the range.
row headers contains the row headings.
column headers contains the column headings.
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.
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.
font name indicates the name of the font used, such as Times New Roman.
font size indicates the size at which the font appears, in points.
bold indicates whether the text is in bold.
italic indicates whether the text is in italics.
underline indicates whether the text is underlined.
strike through indicates whether the text is struck through.
font color indicates the color of the text.
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.
row represents the row index of the cell.
column represents the column index of the cell.
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.
row represents the row index of the cell.
column represents the column index of the cell.
error out contains error information. This output provides standard error out functionality.

Excel Easy Table (num)

font settings source specifies the way in which you want to select font settings. The VI ignores this input for HTML and standard reports.

0VI Inputs (default)—The VI uses the values you set in the font input. If you do not wire font, the VI uses the default font settings of the report class.
1Font Dialog Box—A dialog box appears that you can use to select font settings.
font sets the font attributes that the VI uses when formatting. The VI ignores this input if you wire the autoformat input.
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.
font size specifies the size at which you want the font to appear, in points.
bold specifies whether the text is in bold. The default is bolded text.
italic specifies whether the text is in italics. By default, the control does not change the text settings.
underline specifies whether the text is underlined. By default, the control does not change the text settings.
strike through specifies whether the text contains a strikethrough line. By default, the control does not change the text settings.
font color allows you to select the color of the font from a color table. The default is transparency.
Iteration specifies the loop iteration count if you are adding data to an Excel worksheet within a loop.
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.
auto format sets the table format using Excel preset table styles. The default is no formatting. In Excel, select Format»AutoFormat to view examples of Excel table styles.
start represents the position of the top left corner of the range of cells in which the table appears.
rows specifies the row index.
columns specifies the column index.
text data contains the data for the table.
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
name specifies a named range from which the VI performs the insertion. If the named range covers multiple cells, the insertion appears in the top left corner of the range.
row headers contains the row headings.
column headers contains the column headings.
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.
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.
font name indicates the name of the font used, such as Times New Roman.
font size indicates the size at which the font appears, in points.
bold indicates whether the text is in bold.
italic indicates whether the text is in italics.
underline indicates whether the text is underlined.
strike through indicates whether the text is struck through.
font color indicates the color of the text.
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.
row represents the row index of the cell.
column represents the column index of the cell.
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.
row represents the row index of the cell.
column represents the column index of the cell.
error out contains error information. This output provides standard error out functionality.

 

Your Feedback! poor Poor  |  Excellent excellent   Yes No
 Document Quality? 
 Answered Your Question? 
Add Comments 1 2 3 4 5 submit