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.

プロジェクトの対応 OS

Windows | クロスプラットフォーム

プロパティ

共通

• 表示名 - デザイナー パネルに表示されるアクティビティの名前です。

入力

• ファイル - リソースのブックのフル パスです。ローカル パスに切り替えるには、プラス記号のアイコンを選択し、[ローカル ファイルを使用] を選択します。現在のフィールドが [ファイル (ローカル パス)] に変更され、ブックのフル パスを指定できます。
• シート名 - ブックのシートの名前です。
• 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.
  • Number
    • 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
    • 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:
  • なし
  • Single
  • 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 - 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.