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

Inputs/Outputs
horizontal alignment (left)
—
horizontal alignment sets the horizontal alignment of text in the specified cells. The default setting aligns text along the left side of the cells.
vertical alignment (top)
—
vertical alignment sets the vertical alignment of text in the specified cells. The default setting aligns text to the top of each cell.
—
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.
wrap text? (F)
—
wrap text? must be set to TRUE to wrap text into the 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. |
horizontal alignment (left)
—
—
wrap text? (F)
—
start (-1, -1)
—
error in (no error)
—
name ("")
—
—
error out
—