Format Cells

UiPath.Excel.Activities.Business.FormatRangeX

Sets the format for all the cells in a specified range. You can format the data type, alignment, font, and fill color of the cells. The activity can be used with an Excel file selected for a parent Use Excel File activity or with the Project Notebook.

To learn how to use this activity, see Tutorial: Extracting Table Data from a Web Page and Editing it in Excel.

Configuring the Activity

In the Body of the Activity

• Source - Click Plus on the right side of the field, then, from the menu, select the file and then a sheet, table, or range to format, or select Indicate in Excel to indicate a range directly from the file. Alternatively, you can select Custom Input to enter a sheet name, table name, or range manually, or Open in Advanced Editor to enter a VB expression.
• Format data as type - Click Set Format to open the Format cells window and then select what to format in the cells using the options at the top: Data Type (number format), Alignment (horizontal, vertical, wrap text), Font (font, font style, underline style, font size, color), or Fill (color). Depending on your selection, other options may appear for additional configuration.

Properties Panel

Common

• DisplayName - The name displayed for the activity in the Designer panel.

Input

• See Source in the body of the activity.

Misc

• Private - If selected, the values of variables and arguments are no longer logged at Verbose level.