ExcelCell_SetValue
Description
Sets the value and the style of an Excel cell.
Cell Content
Format InArgument<String>
Specifies the number format for numeric values.
Formula InArgument<String>
A string expression that represents a formula contained in the cell or cell range. It starts with an equal sign (=).
Value InArgument<Object>
An object specifying the data to be assigned to the cell value.
Cell Search
SearchMode ESearchCellMode
Indicates how to search for the cell: by coordinates or by name.
Cell Search - By Coordinates
ColIndex InArgument<Int32>
The column index of the cell to set the value on.
RowIndex InArgument<Int32>
The row index of the cell to set the value on.
Cell Search - By Name
CellName InArgument<String>
The name of the Cell to set the value on.
Input
Workbook InArgument<Workbook> REQUIRED
The excel Workbook.
WorksheetName InArgument<String> REQUIRED
The name of the Worksheet where the cell is.
Style
ApplyStyle InArgument<Boolean>
Set this argument to true if you want to apply a style to the cell.
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
Horizontal 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.
Vertical EVerticalAlignment?
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.
Bold InArgument<Boolean>
Sets whether the cell content is formatted as bold.
Color InArgument<Color>
Sets the font color of the cell.
Italic InArgument<Boolean>
Sets whether the cell content is formatted as italic.
Name InArgument<String>
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.
Size InArgument<Int32>
Sets the font size of the cell.
Strikethrough InArgument<Boolean>
Sets whether the cell content is formatted as strikethrough.