Excel Set Cell Format VI

LabVIEW 2018 Report Generation Toolkit for Microsoft Office Help

Edition Date: June 2018

Part Number: 370274M-01

»View Product Info
Download Help (Windows Only)

Owning Palette: Excel Format VIs

Requires: Report Generation Toolkit

Sets the number format of the cells specified by the start and end clusters or by a named range.

In Excel, select Format»Cells and click the Number tab to view the available number format types for that version of Excel.

Example

report in is a reference to the report whose appearance, data, and printing you want to control. Use the Create Report VI to generate this LabVIEW class object.
number format describes the format to apply to the specified cells. Use the Excel number formatting guidelines instead of the LabVIEW string formatting guidelines. Use # to display significant digits. Excel does not display insignificant zeros. Use 0 (zero) to display insignificant zeros if the number has fewer digits than there are zeros in the format. Use ? (question mark) to add insignificant zeros on both sides of the decimal point to keep the decimal point aligned. The question mark can also be used for aligning fractions.
start determines the range of cells that the VI will format. If neither start nor end are wired, the VI formats the used section of the worksheet. If start is wired but end is unwired, the VI formats the unique cell specified by start. If neither row nor column are equal to –1, the VI formats the corresponding cell. If row is equal to –1, the VI formats the entire column. If column is equal to –1, the VI formats the entire row. If both start and end are wired, the VI formats the range of cells between start and end.
row represents the index of the first row of the range to format.
column represents the index of the first column of the range to format.
end determines the range of cells that the VI will format. If neither start nor end are wired, the VI formats the used section of the worksheet. If start is wired but end is unwired, the VI formats the unique cell specified by start. If neither row nor column are equal to –1, the VI formats the corresponding cell. If row is equal to –1, the VI formats the entire column. If column is equal to –1, the VI formats the entire row. If both start and end are wired, the VI formats the range of cells between start and end.
row represents the last row index.
column represents the last column index.
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
name specifies the named range to format.
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.
error out contains error information. This output provides standard error out functionality.

Example

Refer to the Conditionally Formatted Spreadsheet VI in the labview\examples\office\Excel Reports.llb for an example of using the Excel Set Cell Format VI.

WAS THIS ARTICLE HELPFUL?

Not Helpful