activities
latest
false
Productivity Activities
Last updated Oct 3, 2024

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.

Configuring the Activity

In the Body of the Activity
  • Source - Click Plus docs image 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.
  • Configuring the Activity

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.