MarketplaceStudioActivityExtract Charts/Graphs as Images from Excel

Create your first automation in just a few minutes.Try Studio Web

Extract Charts/Graphs as Images from Excel

Extract Charts/Graphs as Images from Excel

by Internal Labs

1

Activity

Downloads

586

Scott Sniderwin
Posted a year ago

I am using this activity, and have had some strange results for the output.  

In attended mode (dev environment), it produces graphics for the three charts as expected.  

When moved to the test environment (unattended), the activity creates 6 graphic images from the 3 charts in the excel file.  It creates the 3 expected images with the correct naming convention, then an additional 3 with a different naming convention.  

To add more confusion, when moved to our Prod environment, it now creates 9 images from the 3 graphs.  It creates the 3 expected images with the correct naming convention, then an additional 6 with a different naming convention.  

I do understand the behavior change between the tenants.  I have run VBA on the workbook to count the number of existing graphs, and the result is 3.  What could be causing these results?

Sukannya Jamadar
Posted a year ago ago

Hi Scott, as per the code, it will only extract any charts or graphs that are already available in the excel. That means it will be able to extract and save 3 images.

Please check if your code is in retry scope/logic which when fails will rerun the extract images activity again.

Publisher

Internal Labs

Visit publisher's page

License & Privacy

License Agreement

Privacy Terms

Technical

Version

1.0.2

Updated

April 27, 2023

Works with

Studio: 22.10+

Certification

Silver Certified

Application

Microsoft Excel

Support

UiPath Community Support