v.1.6.6

This version introduces important bug fixes and enhancements to Excel automation.

Bug Fix

Excel Scope – Fixed a production issue where the Excel Scope activity was not working for “.xls” files. The issue has been resolved to ensure smooth operation across all supported Excel file formats.

New Activities

This release introduces three new activities to further enhance Excel automation capabilities:

1. Text to Column – Inserts new columns in an Excel sheet by identifying and using specified text from a selected data range.
2. Get Chart – Retrieves chart information from an Excel sheet.
3. Insert Chart – Allows users to create charts in an Excel sheet based on the selected data range.
4. Change Pivot Data Source – Updates the data source of an existing Pivot Table.
5. Filter Pivot Table – Applies filters to Pivot Table data.
6. Update Chart: A parent activity that groups multiple chart update actions, including:
a. Update Chart Title – Updates the chart title.
b. Change Data Source – Changes the chart’s data source.
c. Update Axis Title – Updates the axis titles.
d. ShowHide Legend – Toggles the visibility of the chart legend.
e. ShowHide Data Labels – Toggles the visibility of data labels.
f. Update Axis Bounds – Modifies the minimum and maximum bounds of chart axes.