ExcelStyle_New

Description

Creates a new Style and adds it to the workbook’s collection of styles.


Cell Content

Content Format InArgument<String>

Specifies a number format for a numeric cell value.


Input

Name InArgument<String> REQUIRED

The name of the new style.

Workbook InArgument<Workbook> REQUIRED

The workbook to add the new style to.

It is possible to obtain a new workbook with the activity ExcelWorkbook_New or to get it from an existing file with ExcelWorkbook_Get.

Misc

Result OutArgument<Style>


Style - Borders

Bottom Border EBorderLineStyle?

Sets the style of the bottom border of the cell. The value None means to set the border style to the default value, null means not to change it.

Bottom Color InArgument<Color>

Sets the color of the bottom border of the cell.

Left Border EBorderLineStyle?

Sets the style of the left border of the cell. The value None means to set the border style to the default value, null means not to change it.

Left Color InArgument<Color>

Sets the color of the left border of the cell.

Right Border EBorderLineStyle?

Sets the style of the right border of the cell. The value None means to set the border style to the default value, null means not to change it.

Right Color InArgument<Color>

Sets the color of the right border of the cell.

Top Border EBorderLineStyle?

Sets the style of the top border of the cell. The value None means to set the border style to the default value, null means not to change it.

Top Color InArgument<Color>

Sets the color of the top border of the cell.


Style - Content Alignment

HorizontalAlignment EHorizontalAlignment?

Sets the horizontal alignment of the cell. The value null means not to change the alignment.

RotationAngle InArgument<Int32>

An integer value that specifies the rotation angle of the cell content (in degrees). The value must be between -90 and 90.

Sets the vertical alignment of the cell. The value null means not to change the alignment.

WrapText InArgument<Boolean>

Sets whether the text contained in a cell is wrapped into multiple lines.


Style - Font

Background InArgument<Color>

Sets the fill color of the cell.

Sets whether the cell content is formatted as bold.

Color InArgument<Color>

Sets the font color of the cell.

Sets whether the cell content is formatted as italic.

Sets the font name of the cell.

ShrinkToFit InArgument<Boolean>

Specifies whether text size in a cell changes automatically to fit the cell width: true to automatically change text size to fit a cell; otherwise, false.

Sets the font size of the cell.

Strikethrough InArgument<Boolean>

Sets whether the cell content is formatted as strikethrough.