Insert Chart: Error HRESULT E_FAIL has been returned from a call to a COM component

Help Activities
,
1

It was normal when I created the pivot table, but when I got to the insert chart, I got an error.

The image shows a UiPath Studio Community interface with activities for creating a pivot table and inserting a chart in an Excel spreadsheet. (็”ฑ AI ็”Ÿๆˆๆ ‡้ข˜)
The image shows a UiPath Studio Community interface with activities for creating a pivot table and inserting a chart in an Excel spreadsheet. (็”ฑ AI ็”Ÿๆˆๆ ‡้ข˜)2560ร—1440 287 KB

2

The strange thing is that when I debug it found that it can generate charts.

An Excel pivot table and bar chart analysis of vegetable production data by vendor, storage zone, and production month. (็”ฑ AI ็”Ÿๆˆๆ ‡้ข˜)
An Excel pivot table and bar chart analysis of vegetable production data by vendor, storage zone, and production month. (็”ฑ AI ็”Ÿๆˆๆ ‡้ข˜)1898ร—987 115 KB

3

Hi @1972134464
Welcome to UiPath

Add a short delay before inserting the chart to ensure Excel is fully loaded, and set "Visible" = True in โ€œUse Excel Fileโ€ or โ€œExcel Application Scopeโ€ to keep Excel active.

If you found helpful mark as a solution.
Thanks

4

It doesnโ€™t work

A UiPath workflow is being designed to insert a clustered column chart into an Excel sheet, but an error related to COM component has been encountered. (็”ฑ AI ็”Ÿๆˆๆ ‡้ข˜)
A UiPath workflow is being designed to insert a clustered column chart into an Excel sheet, but an error related to COM component has been encountered. (็”ฑ AI ็”Ÿๆˆๆ ‡้ข˜)1598ร—845 85.2 KB

5

Hi @1972134464

As per Support docs:

UiPath Solution:

  1. Update UiPath.Excel.Activities to the latest version.
  2. Set Visible = True in Excel Application Scope.
  3. Use Kill Process activity to close any running Excel processes.
  4. Try using Invoke VBA to insert the chart.

Microsoft Solution:

  1. Update Excel via File > Account > Update Options.
  2. Repair Excel via Control Panel > Programs > Repair.
  3. Ensure Excel is not corrupted by opening it manually and saving as a new file.
6

It doesnโ€™t work. UiPath.Excel.Activities and Excel is the latest version

The image displays the UiPath Studio interface with an Excel activity workflow to process an Excel file named "VegetablesProduction.xlsx", highlighting the "Show Excel window" property set to true. (็”ฑ AI ็”Ÿๆˆๆ ‡้ข˜)
The image displays the UiPath Studio interface with an Excel activity workflow to process an Excel file named "VegetablesProduction.xlsx", highlighting the "Show Excel window" property set to true. (็”ฑ AI ็”Ÿๆˆๆ ‡้ข˜)1598ร—868 79.7 KB

This image shows the UiPath Studio Community edition interface with a workflow being designed, including activities such as a Delay and an Invoke Workflow File. (็”ฑ AI ็”Ÿๆˆๆ ‡้ข˜)
This image shows the UiPath Studio Community edition interface with a workflow being designed, including activities such as a Delay and an Invoke Workflow File. (็”ฑ AI ็”Ÿๆˆๆ ‡้ข˜)1595ร—872 83.7 KB

7

I fixed the issue, although I donโ€™t know why. The solution to the problem is to change the expressions of data range and insert into sheet to the same.

This screenshot shows a UiPath Studio workflow for inserting an Excel chart, highlighting the settings for data range and sheet insertion. (็”ฑ AI ็”Ÿๆˆๆ ‡้ข˜)
This screenshot shows a UiPath Studio workflow for inserting an Excel chart, highlighting the settings for data range and sheet insertion. (็”ฑ AI ็”Ÿๆˆๆ ‡้ข˜)1600ร—873 87.5 KB