Set fill, font, borders, alignment, number format and size on a range. Every field is optional and only the ones filled in are changed
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | Not set | |
Sheet Name sheetName | string | Optional | Not set | Leave empty for the first sheet |
Range range | string | Optional | Not set | A1:D20, a single cell, whole columns A:C, or empty for everything on the sheet |
Fill Colour fillColor | string | Optional | Not set | Hex such as #4472C4, or a name such as light green |
Font Colour fontColor | string | Optional | Not set | |
Font fontName | string | Optional | Not set | Calibri, Arial, Georgia |
Font Size fontSize | number | Optional | Not set | |
Bold bold | boolean | Optional | Not set | |
Italic italic | boolean | Optional | Not set | |
Underline underline | boolean | Optional | Not set | |
Horizontal Alignment horizontalAlignment | enum | Optional | Not set | leftcenterrightjustifyfill |
Vertical Alignment verticalAlignment | enum | Optional | Not set | topmiddlebottom |
Wrap Text wrapText | boolean | Optional | Not set | |
Indent indent | number | Optional | Not set | |
Text Rotation textRotation | number | Optional | Not set | Degrees, -90 to 90 |
Number Format numberFormat | enum | Optional | Not set | generalnumbernumber2thousandscurrencypercentpercent2datedatetimetimetextcustom |
Currency Symbol currencySymbol | string | Optional | $ | Shown when numberFormat = currency |
Custom Format Code customNumberFormat | string | Optional | Not set | Such as #,##0.00 or dd-mmm-yyyy Shown when numberFormat = custom |
Border Style borderStyle | enum | Optional | Not set | nonethinmediumthickdotteddasheddouble |
Border Colour borderColor | string | Optional | Not set | Shown when borderStyle = thin / medium / thick / dotted / dashed / double |
Border Edges borderEdges | enum | Optional | all | alloutlinetopbottomleftrightShown when borderStyle = none / thin / medium / thick / dotted / dashed / double |
Column Width columnWidth | number | Optional | Not set | |
Row Height rowHeight | number | Optional | Not set |
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Apply Conditional Formatting
Add a rule that keeps highlighting cells as the data changes, rather than colouring the ones that match today
Autofit Rows and Columns
Widen columns to fit their contents. Widths are estimated from the longest value rather than measured, and rows are handed back to Excel to fit when the file opens
Format as Table
Turn a range into a real Excel table with banded rows, filter arrows and a name formulas can use
Merge Cells
Join a range into one cell, or split a merged one back up. Safe to re-run
Add Row to Sheet
Add a row of values to the end of a sheet
Append Data to Sheet
Add many rows to the end of a sheet in one step. Use Add Row to Sheet for a single row