UiPath.Excel.Activities.Business.FormatRangeX

📘

Note:

This activity was first introduced in the UiPath.Excel.Activities v2.8.0-preview activities package.

Sets the format for all the cells in a specified range. Available formats are General, Number, Date, Time, Percentage, Currency, Text, and Custom. When using the Custom format, you can write Excel-like formats such as "#,##0.00".

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

In the Body of the Activity

• Source range - Click 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 data as type window, and then select the format from the Category drop-down list: General, Number, Date, Time, Percentage, Currency, Text, or Custom. Depending on your selection, other options may appear for additional configuration.

Properties

Common

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

Input

• See Source range in the body of the activity.

Misc

• Private - If selected, the data used in the activity is not logged by StudioX.