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

Excel Easy Text 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 text into a Microsoft Excel report.

Use the font parameter to format the text. The VI merges a range of cells specified by the start and end inputs and inserts the text into the merged cell.

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.
border? determines whether a border encloses the text.
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.
text contains the text to insert into the worksheet.
start represents the position of the top left corner of the range of cells that the VI merges before inserting the text.
row represents the first row index of the range to merge together.
column represents the first column index of the range to merge together.
end represents the position of the bottom right corner of the range of cells that the VI merges before inserting the text.
row represents the last row index of the range to merge together.
column represents the last column index of the range to merge together.
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
name describes the named range from which the VI retrieves data.
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