Excel Set Cell Format VI
- Updated2024-07-30
- 3 minute(s) read
Sets the number format of the cells specified by the start and end clusters or by a named range.

Inputs/Outputs
—
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.
number format
—
number format describes the format to apply to the specified cells.
start (-1, -1)
—
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.
end (-1, -1)
—
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.
error in (no error)
—
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
name ("")
—
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
—
error out contains error information. This output provides standard error out functionality. |
—
number format
—
start (-1, -1)
—
row
—
error in (no error)
—
—
error out
—