apps
2023.10
false
UiPath logo, featuring letters U and I in white
LEGACY
Legacy Apps User Guide for Automation Suite
Automation CloudAutomation Cloud Public SectorAutomation Suite
Last updated Nov 11, 2024

Include Excel Charts in Apps

Charts are visual representations for data visualization, in which the data is represented by symbols. They are often used because they are easier to read than the raw data.

To include a chart into your application developed with UiPath Apps, follow the procedure below.

Prerequisites

Before including a chart into your application, you must have:

  • A chart template in Excel.
  • The UiPath.Excel.Activities.Business.CopyChartToClipboardX activity installed and configured. For more information, see Get Excel Chart.
  • The UiPath.Core.Activities.LoadImage activity installed and configured. For more information, see Load Image.

Procedure

  1. Add a required chart with the needed data in an Excel sheet.
  2. Use the Get Excel Chart activity to save the chart.
  3. Save the chart as a picture.



  4. Use the Load Image activity and reference the chart image location.
  5. Convert the chart image to base64.
  6. Prefix the base64 string with the following: data:image/png;base64,. Make sure that base64 is a string data type.
  7. Pass the string as an out argument of your choice.
  8. Add the out argument in the Url field of your image control.



Result

The sequence in UiPath Studio should be similar to the one in the image below.



Your chart is now included into the application.



  • Prerequisites
  • Procedure
  • Result

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.