Hi, RPA Devs!
I have a Excel workbook into which I’m appending a new data row at a specific time once per day. I use an embedded Excel Line Chart to visually display this time series. Here’s my problem … How can up update the Chart Data Range attribute of the Excel Chart each time my Bot runs and appends a new row to the data series?
I don’t see an explicit UiPath Activity for updating Excel Charts in either the uiPath.Excel.Activities or the UiPathTeam.Excel.Extensions.Activities packages. The only solution I can see at this juncture, is to create an Excel Macro and pass in the new row as a parameter, or via the Excel Macro, reselect the range of data that is used to define what is displayed in the chart.
I.e. if the old Chart Data Range was: =‘TimeSeriesValues’!$A$1:$E$5, run a macro which reselects a contiguous data range and increments the last row in the range to:
=‘TimeSeriesValues’!$A$1:$E$6. i.e. change the last row from 5 to 6 to account for the newly appended row.
Another approach, have the Chart Data Range simply reference an Excel Named Range … but again, there is no explicit Activity in UiPath Studio Community Edition 2019.10.1 to define or update an existing Named Range.
Thanks in advance for your ideas and alternate solutions