订阅

UiPath 活动

UiPath 活动指南

设置单元格的格式

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.

配置活动

In the Body of the Activity

  • Source - Click Plus plus buttonplus button 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, Alignment, Font, or Fill. Depending on your selection, other options may appear for additional configuration.

In the Properties Panel

Common

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

Input

Misc

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

3个月前更新


设置单元格的格式


建议的编辑仅限用于 API 参考页面

You can only suggest edits to Markdown body content, but not to the API spec.