Format Range Workbook (preview)

Format Range Workbook activity that sets the number format, alignment, and font of the cells in a range.

UiPath.Excel.Activities.FormatRange

描述

Sets the number format, alignment, and font of the cells in a range. This is the cross-platform equivalent of the Format Cells Windows activity.

备注：

This activity does not support .xls files.

项目兼容性

Windows | 跨平台

属性

常见

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

输入

• 文件- 资源工作簿的完整路径。要切换到本地路径，请选择加号图标，然后选择使用本地文件。当前字段更改为文件（本地路径） ，您可以在其中提供 workbook 的完整路径。
• “工作表名称” - workbook 中工作表的名称。
• Range - The range to format. This field is required.

格式

Like the Windows activity, the designer shows one section of the settings at a time. Use the Format selector to choose between Data Type, Alignment, and Font. The selector is only used by the designer and is not saved with the workflow. The settings of the sections that are not displayed are kept and still applied.

You can configure any combination of the settings in the three sections. A setting that you leave unset keeps the existing formatting of the cells. This includes Category. For example, if you set only Font style, the existing number format isn't reset to General.

数据类型

• Category - The number format category to apply. Leave this field unset to keep the existing number format. When you select a category, only the fields of that category are displayed. If you bind Category to a variable or an expression, all the category fields are displayed.
  • 数字
    • Decimals - The number of decimal places. The default value is 2.
    • Use 1000 Separator - Select this option to use a thousands separator. By default, this option is not selected.
  • 币种
    • Decimals - The number of decimal places. The default value is 2.
    • Use 1000 Separator - Select this option to use a thousands separator. By default, this option is not selected.
    • Symbol - The currency symbol. The default value is $. The symbol can't contain a quotation mark.
    • Set at the end - Select this option to place the symbol after the value instead of before it. By default, this option is not selected.
  • 百分比
    • Decimals - The number of decimal places. The default value is 2.
  • 日期
    • Date format - The date format: 3/14/2012 (short) or Wednesday, March 14, 2012 (long). The default value is 3/14/2012.
  • 时间
    • Time format - The time format: 11:30 (hours and minutes) or 11:30:55 (hours, minutes, and seconds). The default value is 11:30.
    • AM/PM - Select this option to use the 12-hour AM/PM format instead of the 24-hour format. By default, this option is not selected.
  • 自定义
    • Custom format - A custom Excel number format string, used as entered.
  • General and Text have no additional fields. General applies the General format, and Text applies the @ format.

对齐

• Horizontal - The horizontal alignment of the cell content. Leave this field unset to keep the existing alignment. You can choose from the following options:
  • 常规
  • 左侧
  • 居中
  • 右侧
  • Fill
  • Justify
  • Center Across Selection
  • Distributed
• Vertical - The vertical alignment of the cell content. Leave this field unset to keep the existing alignment. You can choose from the following options:
  • 顶部
  • 居中
  • 底部
  • Justify
  • Distributed
• Wrap text - Select this option to wrap the text within the cell. By default, this option is not selected. The setting is applied when the option is selected, or when a horizontal or vertical alignment is set, so that it can turn the wrapping off. Otherwise, the existing wrapping is kept.

字体

• Font - The name of the font family. Leave this field unset to keep the existing font.
• Font style - The font style. Leave this field unset to keep the existing style. You can choose from the following styles:
  • Regular
  • 斜体
  • 加粗
  • Bold Italic
• Font size - The font size, in points. Leave this field unset to keep the existing size.
• Font color - The font color, as a color name, for example Red, or a hex color, in the #RRGGBB or #AARRGGBB format. Leave this field unset to keep the existing color.
• Underline style - The underline style of the font. Leave this field unset to keep the existing style. To remove an underline, select None. You can choose from the following styles:
  • 无
  • 单个
  • Double
  • Single Accounting
  • Double Accounting
• Fill color - The fill, or background, color. It accepts the same values as Font color. Enter Transparent to remove the fill. Leave this field unset to keep the existing fill.

选项

• 密码- workbook 的密码（如有必要）。

使用 workbook

• Workbook - The existing workbook to use instead of a file path.

注意

• A setting that has no value isn't applied. A setting that has a value is applied, including False and 0.
• Font color and Fill color accept a color name, without taking the case into account, for any known System.Drawing color, such as Red or LightGray, or a hex color. Any other value causes an error before any setting is applied. There is no color picker yet, so you enter the colors as text.
• A whole-column or whole-row range, such as A:A, applies a single column-level or row-level style. This matches the behavior of Excel, and the style also applies to cells that you fill in later.
• Range must refer to the sheet in SheetName. A range that includes a sheet name, such as Sheet2!A1:A10, is not supported and causes an error.
• A Custom format causes an error if, before the first number, date, or time placeholder, the double quotation marks don't occur in pairs. This applies whether or not a quotation mark is preceded by a backslash. For example, "a"\"0.00 and \"0.00 are rejected.