Update Chart Workbook

UiPath.Excel.Activities.UpdateChart

注:

このアクティビティはプレビューとして利用可能です。

Updates the properties of an existing chart in an Excel file. This is the cross-platform equivalent of the Update Excel Chart Windows-only activity.

注:

サポートされているブックの形式は、 .xls、 .xlsm、 .xltm、 .xlsx、および .xltxです。

プロジェクトの対応 OS

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

Properties and configuration

• File - The full path of the resource workbook. To switch to a local path, select the plus icon, and then Use Local File. The current field changes to File (local path), where you can provide the full path of the workbook.
• Chart - The chart to update. Select the file, sheet, and chart, or enter the chart name manually. You can also reference a chart saved by the Insert Chart Workbook activity.
• SheetName - The name of the sheet containing the chart. If not set, the chart is searched for in all sheets.
• Chart modifications - Select Open Collection Builder to add one or more modifications to apply to the chart. To set the options dynamically, you can use a variable. Select the plus menu icon, and then Use an Expression. The following modification types are available:
  • new ModifyChartTitleChartModification With {.ShowTitle = False, .Title = "myTitle"}
  • new ShowHideLegendChartModification With {.ShowLegend = False}
  • new ShowHideDataLabelsChartModification With {.ShowDataLabels = False}
  • new ChangeDataRangeChartModification With {.UseTableSource = False, .SheetName = "Sheet4", .Range = "A2:B2"}
  • new UpdateAxisTitleChartModification With {.Axis = AxisOrientationType.Vertical, .ShowTitle = True, .Title = "myVertTitle"}
  • new UpdateAxisBoundsChartModification With {.Axis = AxisOrientationType.Vertical, .MinBound = 10, .MaxBound = 40}

ブックを使用する

• ブック - 使用する既存のブックです。

オプション

• パスワード - ブックのパスワードです (必要な場合)。