Insert Chart Workbook

UiPath.Excel.Activities.InsertChart

备注：

此活动目前为预览版。

Inserts a chart into an Excel file. This is the cross-platform equivalent of the Insert Chart Windows-only activity.

备注：

支持的 Workbook 格式为.xls 、 .xlsm 、 .xltm 、 .xlsx和.xltx 。

You can choose from the following chart categories and chart types:

图表类别	图表类型
区域	区域 堆积面积图 百分比堆积面积图
条形	簇状条形图 堆积条形图 百分比堆积条形图
列	簇状柱形图 堆积柱形图 百分比堆积柱形图
线条	线条 带数据标记的折线图 堆积折线图 百分比堆积折线图 带数据标记的堆积折线图 带数据标记的百分比堆积折线图
饼状	饼状 圆环
散点图	散点图 带平滑线的散点图 带平滑线和数据标记的散点图 带直线的散点图 带直线和数据标记的散点图

项目兼容性

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.
• Use table source - Toggle to switch between using a sheet range or a named table as the data source.
  • When you disable this option, the following fields are displayed:
    • Source sheet - The sheet containing the source data for the chart.
    • Source range - The range containing the source data for the chart.
  • When you enable this option, the following field is displayed:
    • Source table name - The name of the table that contains the source data.
• Insert into sheet - The sheet in which to insert the chart.
• Chart category - Select one of the following categories of the chart to insert:
  • 区域
  • 条形
  • 列
  • 线条
  • 饼状
  • 散点图
• Chart type - Select one of the following chart types based on the selected chart category:
  • 簇状柱形图
  • 堆积柱形图
  • 百分比堆积柱形图

使用 workbook

• “工作簿” - 要使用的现有工作簿。

输入

• Chart height - The height of the chart, in points.
• Chart width - The width of the chart, in points.
• Chart left - The distance from the left edge of the sheet to the chart insertion point, in points.
• Chart top - The distance from the top of the sheet to the chart insertion point, in points.

选项

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

输出

• Save chart to - The name of the inserted chart, available for use in other activities such as Update Chart Workbook.