Release Notes

V2.24.4

Release date: 6 December 2024

Improvements

For this release, we made sure to bring minor improvements and security fixes to this package.

Bug fixes

• In Studio Web, when the Ignore quotes option from the Read CSV activity was enabled, object types could not be converted to the expected type. To address this issue, we replaced the toggle from the Ignore quotes option with a condition builder control.
• The robot sometimes failed when you set the sensitivity label in the Excel Application Scope activity.
• The PreserveFormat property in the Read Range activity did not return the correct date and time format.

V2.24.3

Release date: 23 October 2024

New features and improvements

We are pleased to announce that the Excel Workbook activities now support IResources. In addition, the Workbook activities are now available on Studio Web.

Known issue

Due to an issue with ClosedXML, the Write Cell Workbook and Write Range Workbook activities sometimes do not work as expected. In an Excel document, when you attempt to write in an existing blank sheet, the action sometimes fails.

V2.24.2

Release date: 3 October 2024

Improvements

We have updated the Excel package to ensure compatibility with Clipboard AI v24.1.5 and Autopilot.

Additionally, we have implemented a few bug fixes to enhance overall performance and stability.

V2.24.1

Release date: 12 September 2024

New features and improvements

We now offer support for the Excel package in coded workflows.

The following activities are now available for Windows projects:

• Get Excel Sensitivity Label
• Add or Update Excel Sensitivity Label

The following activities are now supported on cross-platform projects:

• Read CSV
• Write CSV
• Append Range Workbook
• Get Table Range Workbook
• Read Cell Formula Workbook
• Read Cell Workbook
• Read Column Workbook
• Read Range Workbook
• Read Row Workbook
• Write Cell Workbook
• Write Range Workbook

For the Use Excel File activity, we have added two new properties to manage sensitivity labels: Sensitivity label and Sensitivity operation. For more details, refer to Use Excel File.

Known limitations

• An out-of-memory error occurs while trying to write a data table in Excel using the Write DataTable to Excel activity. The issue happens when attempting to read values with the = or '= prefix characters from Excel documents. As a solution, replace the = or '= prefixes with other characters.

Note: Erratum - Added September 13, 2024: We announced this limitation for the wrong activity, Write Range, when in fact the correct activity is Write DataTable to Excel.

• A COM error occurs when an automation attempts to update a file without a required sensitivity label, as mandated by company policy.

V2.23.5

Release date: 14 August 2024

Improvements

For this release, we made sure to bring minor improvements and security fixes to this package.

V2.23.4

Release date: 19 June 2024

New features and Improvements

Note: Erratum - Added September 2024: We mistakenly announced a new feature for this release (cross-platform support for the Read CSV and Write CSV activities), which was in fact made available in a later version.

Write CSV now includes in the same activity the options to both write and append a CSV file.

Until now, when converting a cross-platform project that contained a Write CSV activity to a Windows project, a generic Write CSV activity was displayed, which contained all the activity fields from cross-platform. This behavior has been improved and now the Write CSV activity keeps its original configuration when converting the project from cross-platform to Windows.

The Select Range and Get Selected Range activities are now available in the modern design experience for Windows-Legacy and Windows projects.

In the Select Range activity, setting the Range selection is now mandatory. However, you can now assign a variable to the range, which can be null. In this scenario, the error "Input value cannot be null" will be thrown at runtime.

The Get Selected Range activity now includes a field that auto-populates the target workbook when the activity is used within a Use Excel File context. Moreover, we added a new field, Save To, for the retrieved range variable. The selection applies only to the active sheet and requires Excel to be opened. Also, the option should return a Range and not a String.

Known issues

We have identified a limitation, where the Insert Rows activity may not work if there are active filters on the sheet.

Bug fixes

The Excel Add-in could not retrieve column names by using the Read Cell Value activity. This happened when multiple colors were set within a single cell and the Excel file was closed.

The Refresh Data Connections activity threw an error that the Create in workbook value cannot be null, although this already had a value assigned.

When pasting from the input dialog to an Excel sheet, an error occurred because the input could not be converted from string.

An error regarding the garbage collector occurred intermittently for the activities Use Excel File and Excel Application Scope when trying to open an Excel file.

Custom input values did not persist if the sheet name was set as a variable, and when opening or closing a file.

v2.22.4

Release date: 22 May 2024

Bug Fixes

Assigning a coded workflow-defined data type to a variable led to a failure in project publication.

v2.22.3

Release date: 4 December 2023

Bug Fixes

When you connected to an Excel file from the Data Manager and set the scope of the resource to anything other than Main, you could not select data from the Excel file or indicate in it from the Plus menu of activity properties.

Erratum - added 18 June 2024

When using For Each Row to manipulate a specific column value with headers as dates, you could select the header as a serial number instead of a date. However, when executing the activity, it failed with the error that the column could not be found.

v2.22.2

Release date: 12 October 2023

New Features and Improvements

Better handling of large files in Workbook activities

You can now add Excel files as Workbook resources from the Data Manager in Studio projects where you use Workbook activities. This enables a file to be loaded in the memory once and not be reloaded for each Workbook activity, which improves the runtime performance when you use multiple activities with the same file, especially when processing large files.

To further optimize performance, you can configure the scope of the resource to ensure it remains in the memory only for as long as it's needed.

After an Excel file is added as a resource, you can reference it from Workbook activities by selecting the resource from the Plus menu instead of providing the workbook file path.

Package now in available activities

You can now find and add activities from this package in Studio projects where it is not installed as a dependency. If the package is not installed in a project, its activities can be found in the Available category of the Activities panel and the Add activity search bar. When you add an available activity from the package to a project, the package is installed as a project dependency.

Bug Fixes

• An error occurred when running the Excel Application Scope activity if Microsoft Azure Information Protection (AIP) was installed on the machine and configured to work with Excel.

• Only the first column was available for selection from the CurrentRow menu in child activities of the For Each Excel Row activity when the range to iterate over had multiple columns and the In range property was set to a single starting cell in For Each Excel Row.
• Using the Write Range activity with an XLS file cleared all the cells from the row of the starting cell before writing the data.
• A compilation error occurred when running the Text to Columns activity if the delimiter was set to the backslash character (\) and the source range contained that character.
• When executing activities in a loop such as For Each Excel Sheet or For Each Excel Row, the execution time increased with each iteration.
• Creating or clearing a filter using the Filter Pivot Table activity did not work properly if the pivot table was created with external data sources.
• The Find/Replace Value activity allowed you to select an empty value to replace even though the property does not support blank text. Text - empty value is no longer available as an option in the Plus menu for the Value to find property.

Erratum - added 18 June 2024

When the Invoke VBA activity failed, the workbook used was not removed and, the next time the activity ran, the workbook could not be re-added. This resulted in a misleading error about Trust Center.

v2.5.5

Release Date: 11 September 2023

Bug Fixes

An error occurred when running the Excel Application Scope activity if Microsoft Azure Information Protection (AIP) was installed on the machine.

v2.20.3

Release date: 28 August 2023

Bug Fixes

A TargetInvocationException error occurred when adding an activity to a workflow using the latest version of the package with Studio 2022.10 and earlier.

v2.16.4

Release date: 28 August 2023

Bug Fixes

A TargetInvocationException error occurred when adding an activity to a workflow using the latest version of the package with Studio 2022.10 and earlier.

V2.20.2

Release date: 30 May 2023

This release includes accessibility fixes.

V2.16.3

Release date: 30 May 2023

This release includes accessibility fixes.

V2.20.1

Release date: 11 April 2023

New Features and Improvements

New Activities

• Lookup - Finds data in a range or sheet using the LOOKUP function.

Improvements

• You can now use the Refresh pivot table activity to refresh all the pivot tables in a workbook. When you indicate the pivot table to refresh, a new option called All Pivot Tables is available in the Plus menu for each Excel file.
• You no longer need to specify the columns to compare when using the Remove duplicates activity. A new option now enables you to compare all columns.
• You now have more control over how the Copy/Paste Range activity handles the header of the source range. The Exclude source headers property has been replaced with a dropdown that enables you to exclude or include the header regardless of the source range, exclude it only if the source range is a range, or only if it is a table.
• When you create a pivot table using the Create Pivot Table activity, the fields added as pivot filters now appear one below the other in a column instead of in a single row.
• You can now use the Format Cells activity to set an underline style for the font. The following underline styles are available: none, single, double, single accounting, or double accounting.
• Columns with empty headers are now available for selection in the Plus menu in Excel activity fields where you can select a column. For example, if column C doesn’t have a header while columns A and B do, when you access the column selector from the Plus menu, the header values are displayed for the first two columns (A and B), and Column C is displayed for the third column.
• The Filter Pivot Table activity now enables you to filter by pivot table rows and columns, not just filters. Row and column labels are available for selection from the Plus menu of the Column Name field.
• If the Use Excel File activity is used in a project, this information is now included in the published package, and is then available in Orchestrator. This feature requires Studio / StudioX 2023.4 or later.

Bug Fixes

• The Find First/Last Data Row activity sometimes took longer than expected to process data.
• The modern Read Range activity took longer than expected to process data. To increase performance further, we recommend setting the Read formatting option to RawValue and deselecting the Visible rows only option.
• An error occurred if you used a localized version of Windows and ran a project containing an Insert Column activity in which the data format was set to General.
• The Write DataTable to Excel and Write Range activities didn’t copy the column headers of empty DataTables that contained only headers.
• The Chinese translation for the Plus menu option Ask when run was incorrect.
• An error occurred if the Windows regional format was not set to English (United States) and you ran a project that used a Delete Rows activity with the option All visible rows on a range that included hidden rows.
• The Read Range Workbook activity did not read a cell if its value was a formula that included the HLOOKUP function.
• When you created a new variable or selected an existing variable in the Reference new sheet as field of the Insert Sheet activity from the Designer panel in Studio, the variable was not saved in the properties of the activity.
• An error occurred if you ran a project that contained an Excel Application Scope activity in which the workbook path was set to a CSV file without an extension.

V2.16.2

Release date: 1 February 2023

Bug Fixes

• The Find First/Last Data Row activity did not take into account filters applied to the source range when returning the first row with data. A new option called Visible rows only now enables you to indicate if hidden values from the source range should be ignored.
• A compilation error occurred and publishing failed when you tried to publish Windows - Legacy libraries that contained a Read CSV activity.
• Using the Format Cells activity on a filtered range caused incorrect data to be added to the range.

V2.16.1

Release date: 7 December 2022

New Features and Improvements

Support for Traditional Chinese

The user interface of the activities in the Excel package is now available in Traditional Chinese.

V2.16.0

Release date: 27 October 2022

New Features and Improvements

New Activities

• Filter Pivot Table - Creates a filter in a pivot table based on the values in a single column and can also be used to clear existing filters.
• Get Cell Color - Retrieves the background color of a cell and saves it as a color variable.
• Invoke VBA - Invokes a macro from an external file containing VBA code and runs it against an Excel file.

Improvements

• The Read Range activity has been optimized to perform faster when working with formatted Excel files.

• The Workbook activities under System have been renamed in order to be better separated from the Classic and Modern Excel activities:

  • Write Range has been renamed to Write Range Workbook.
  • Write Cell has been renamed to Write Cell Workbook.
  • Read Row has been renamed to Read Row Workbook.
  • Read Range has been renamed to Read Range Workbook.
  • Read Column has been renamed to Read Column Workbook.
  • Read Cell has been renamed to Read Cell Workbook.
  • Read Cell Formula has been renamed to Read Cell Formula Workbook.
  • Get Table Range has been renamed to Get Table Range Workbook.
  • Append Range has been renamed to Append Range Workbook.

Known Issues

• Some Excel versions always open SharePoint documents in read-only mode (e.g. Excel 2019). You can check if a remote document supports editing by opening it manually in Excel on your local machine.

Bug Fixes

• The Excel Process Scope activity was attempting to kill Excel processes on all users that had Excel processes running instead of just the current user when the Existing process action option was set to Force kill.

V2.12.3

Release date: 9 May 2022

New Features and Improvements

New Activities

• Match Function - Searches for a specified item in a range of cells and returns the relative position of that item in the range.

Improvements

• The Copy/Paste Range and Append Range activities now catch errors when a copy or paste operation isn’t possible in Excel and display an error message.
• The Use Excel File activity has been updated with a new option in the properties panel, called Keep excel file open. If the excel file is not open at the time the project runs, it keeps the workbook open after the project finished running instead of closing it. This can be used to review the file afterwards.
• The Excel activities and the Append to CSV, Read CSV, and Write CSV activities are now compatible with cross-platform projects.
• You can now specify an entire sheet as the source for the Create Pivot Table activity.
• The Create Pivot Table and Refresh Pivot Table activities have been updated with a new option, Layout, which allows you to change the layout and format of the pivot table. The available options are: compact, tabular, and outline.
• The position of the fields in the Write CSV and Append to CSV activities has been improved.

Known Issues

• Some Excel versions always open SharePoint documents in read-only mode (e.g. Excel 2019). You can check if a remote document supports editing by opening it manually in Excel on your local machine.

Bug Fixes

• The Delete Rows activity was failing when working with Excel files that have more than a few hundred rows.
• An error was being generated when an Exit Loop activity was added inside a For Each Excel Sheet activity.
• Ranges were not copied correctly in certain cases when using the Copy/Paste Range activity.
• The Copy Sheet activity was not working properly with certain versions of Office 2016.
• shift_jis character encoding is now supported in Windows projects when using the Read CSV activity.
• The Refresh Pivot Table activity was failing when it was used with a pivot table created through Power Query in Excel.

V2.11.4

Release date: 27 October 2021

New Features and Improvements

Modern Design Experience in Studio

• Starting with Studio v2021.10, a modern design experience is available in the Studio profile. The modern design experience:

  • Makes the modern StudioX activities the default activities in the Studio profile instead of the classic activities.

  • Brings the StudioX design experience to Studio, enabling you to configure child activities of the Use Excel File scope activity directly from the Plus menu of each property without having to manually enter expressions. You can:

    • Browse the contents of the file and select data that matches the type of each property. For example, you can select cells, ranges, tables, sheets, or charts from the workbook. You can also indicate the current row or current sheet in an iteration.
    • Use the Custom Input option to manually specify the input based on table, chart, or sheet names or to enter references to a cell or a range.

    • Switch to Excel to indicate data directly from the file using the Indicate in Excel option. This functionality requires that you install the Excel Add-in.

      The modern design experience is enabled by default. You can select which design experience is used for each project from the Excel activities project settings.

New Activities

• Excel Process Scope - Opens or reuses Excel processes, loads the Excel project settings and applies them to the associated Excel file. This activity supports working with multiple Excel processes and determines the behavior of the processes in certain situations.
• Single Excel Process Scope - Opens or reuses an Excel process, loads the Excel project settings and applies them to the associated Excel file. This activity supports working with a single Excel process. If you need to work with multiple Excel processes use the Excel Process Scope activity.
• Unprotect Sheet - Enables unprotecting a protected sheet in Excel in order to make changes to it.
• Protect Sheet - Enables protecting a specified sheet in Excel so that no additional changes can be made to it.
• Read Range - Reads the value of an Excel range as a DataTable.
• Remove Duplicates - Deletes duplicate rows in a specified range.

Improvements

• You can now add UI Automation activities inside a Use Excel File activity to quickly automate the interface of Excel.
• The Delete Rows activity has been updated to not work inside a For Each Excel Row activity when both activities target the same range of rows in order to avoid issues where unintended rows in the iteration would get deleted. A new warning message has been added to the activity for this.

• The Find First/Last Data Row activity has been updated with a new option that lets you select how the last row should be configured:

  • Last populated row – Returns the last populated row.
  • First empty row - Returns the first row that is empty.

• The Write Range activity has received a few updates:

  • The title has been changed to Write DataTable to Excel.
  • The tooltip of the What to write field has been updated to better reflect the intended use of this activity.

Bug Fixes

• Fixed a reference count issue which caused the ExcelApplicationScope instance cache to fail with a SempahoreFullException error.
• The Excel package now includes the Microsoft.Office.Interop.Excel assembly which was not included in previous releases. This was causing a compilation error when you tried to publish a library that contained a variable or argument type which required the assembly.

V2.10.4

Release date: 26 April 2021

New Features and Improvements

• You can now enable or disable Excel notifications when working with the StudioX Excel activities through the Show Excel alerts option that is located in the Excel Business project settings, under Excel Visibility.
• The App Integration Excel activities can now be used inside the Use Excel File activity in addition to the Excel Application Scope activity.

StudioX Activities

New Activities:

• Autofit Range - Changes the displayed column width and/or row height in the specified range to the widest entry in each column and the highest entry in each row.
• Get Excel Chart - Copies an Excel chart to the clipboard for use in other activities or saves it as a picture file.
• Insert Excel Chart - Inserts a chart in a sheet at the specified location.
• Find/Replace Value - Searches in a specified range for certain values. Depending on what operation you choose, it either returns the location of the cell or replaces the value with another given value.
• Refresh Excel Data Connections - Gets the latest data by refreshing all sources in an open Excel workbook.
• Update Excel Chart - Updates the properties of an existing Excel chart.

Other Improvements:

• SharePoint support has been added to the Use Excel File activity. You can open excel files stored on SharePoint by placing the SharePoint URL in the Excel File field.
• A new property called Read Formatting was added to the Use Excel File activity that lets you choose the formatting that will be applied to values read from Excel.
• A new property called Start in column was added to the Append Range activity.
• A new property called Empty Row Behavior was added to the For Each Excel Row activity that lets you select how the automation behaves if an empty row is encountered.
• A Text files entry was added to the Select File dialog when browsing for Excel files using the Use Excel File activity.
• You can now choose whether Excel windows are visible during the automation and what formatting will be applied to values read from Excel by using the options in the Excel Project settings window.
• New formatting options have been added to the Format Cells activity that enable you to change the alignment, font, and the fill color of a cell.

• The Copy Range activity has received the following updates:

  • The title has been changed to Copy/Paste Range.
  • The Destination field now supports cells. You can provide a single cell and then write the copied data starting from that cell.
  • A new Exclude source headers option has been added. If selected, the first row of the Source range is not copied.
• You can now get the number of rows in an Excel object (ranges, tables, sheets) by using the Row Count property through the Plus menu.
• The Excel Project Settings window has been updated with a new settings category called Excel Preview that determines how Excel files are accessed when using the Plus menu.

V2.9.5

Release Date: 27 January 2021

New Features and Improvements

When working with Excel Business activities, Excel can now be launched in a way that allows add-ins to be loaded, both at design time and at runtime. A new activities settings category titled Excel Business has been added to the Project Settings window. The Excel Preview option controls how Excel files are previewed when using the Plus menu in StudioX.

V2.9.3

Release Date: 12 October 2020

New Features and Improvements

This activity pack has now been upgraded and is fully compatible with the C# Studio feature. For more information about C# support, see About Automation Projects.

Some internal changes have been made to make the Excel activities seamlessly compatible with the new operators used for Formulas. No worries, this won’t affect any of your previous workflows.

The Refresh Pivot Table activity can now refresh the table when the data source is changed instead of needing to recreate it.

The amount of packages you can find on UiPath activity feeds is humongous, and it grows with each passing day. This can prove to be a nuisance when searching for a package with a more common name, for example. We felt your pain and decided to do something about this. From now on, all UiPath official activity packs can be easily filtered in the Package Manager so you’ll be able to reach your favorite package in no time!

StudioX Activities

Global Excel Resources:

You can now add an Excel file to your project as a global resource by connecting the project to the file. When a project is connected to an Excel file, all activities in the project can access and modify the file. You can still add Excel files to automations with the Use Excel File activity, in which case only activities added inside the container can modify the files.

New Activities

• Change Pivot Data Source - Changes the range of the source data for a pivot table.
• Save Excel File As - Saves a workbook added to the project or the Project Notebook as a different file. You can specify the file name and the file format to save as.
• Clear Sheet/Range/Table - Clears the data from a specified sheet, range, or table.
• Read Cell Value - Copies the value from a spreadsheet cell.
• Read Cell Formula - Copies the formula from a spreadsheet cell.
• For Each Excel Sheet - Executes one or more activities for each sheet in an Excel workbook.
• Find First/Last Data Row - Finds the row number for the row where data starts and for the last row containing data in a specified sheet, range, or table.
• Write Range - Writes a data table that was saved for later or values from an Excel table or range into another range.

Other Improvements:

You can now directly interact with a sheet added by the Insert Sheet activity. The Reference new sheet as optional field available for Insert Sheet enables you to save a reference to the sheet for later use in the automation.

The Text to Columns activity now supports Line Break as a delimiter.

You can now configure the Delete column activity to delete multiple columns.

When you select an Excel sheet using the Custom Input option, you no longer need to enter the sheet name manually. The Worksheet name field is now a combo box that enables you to select the sheet you want to use. This works when the Excel file defined for the Use Excel File activity is a static file, or when the file is dynamic and a template was defined.

If you select the Indicate in Excel option from the Plus and the Excel Add-in is not installed or it cannot be accessed, you no longer have to manually navigate to Home > Tools to install or repair the add-in. Simply click the Yes button in the error dialog box that appears.

Bug Fixes

• An error is no longer thrown when the Write Range activity is used to write in editable cells from protected sheets. The issue occurred in UiPath.Excel.Activities version 2.8.5 and later.
• Fixed an issue that caused the Robot to sometimes get stuck without throwing an error when executing Excel activities, for example when an Excel Application Scope activity was used in a loop, or when multiple Excel Application Scope activities were used consecutively in the same process.
• An error no longer occurs when you try to use the Indicate in Excel option in the StudioX profile with an Excel file from a OneDrive folder. In addition, please note that if a file from a OneDrive folder is open in Excel, the data in it cannot be accessed directly from the Plus menu. To access named cells, named ranges, tables, and sheets from the menu, you must first close the file.
• The correct range is now displayed as the Current Selection in the UiPath tab of the Excel ribbon when you select Indicate in Excel again after having already used this option to select data directly from the file for the same activity field.

V2.8.6

Release Date: 29 June 2020

Bug Fixes

• An error no longer occurs when you try to use the Indicate in Excel option in the StudioX profile with an Excel file from a OneDrive folder. In addition, please note that if a file from a OneDrive folder is open in Excel, the data in it cannot be accessed directly from the Plus menu. To be able to select named cells, named ranges, tables, and sheets from the menu, you must first close the file.

V2.8.5

Release Date: 8 May 2020

New Features and Improvements

This release brings new activities and enhancements to the existing activities designed for the StudioX profile.

V2.7.2

Release Date: 11 November 2019

New Features and Improvements

We have further increased language support by adding Turkish, Portuguese (Portugal), Spanish (Latin America), and Spanish (Spain) to the list of languages present in the UiPath Platform.

We have added activities designed especially for the preview version of StudioX this release, which is why you'll see the minor version incremented. To check them out, you can see the StudioX documentation here.

V2.6.3

Release Date: 26 August 2019

Improvements

Three new languages, German, South Korean, and Portuguese are available for the UiPath.Excel.Activities package.

V2.5.4

Release Date: 26 June 2019

Improvements

We want to reach out to the entire world and make automation a language everyone can speak. So, starting with this release, the entire platform is available in Chinese.

Note: Chinese can only be used in this pack when installed in Studio v2019.4.4 or v2019.7 or above.

V2.6.2

Release Date: 24 June 2019

Bug Fixes

• Fixed an issue that caused reading an empty sheet with the Read Range activity to return a data table that contained elements.
• Using the Read Range activity with the AddHeaders check box selected did not properly return values.
• The Execute Macro activity could be used with Excel files that had macro disabled.

V2.6.1

Release Date: 24 May 2019

Bug Fixes

• Fixed an issue that caused all languages except English to be incorrectly displayed.

V2.6.0

Release Date: 21 May 2019

Bug Fixes

• When trying to edit a read-only Excel file and save changes, the newly generated file was saved at a different location than the original one. The fix saves the new file correctly and also throws an exception notifying the fact that the original file could not be saved.

V2.5.3

Release Date: 25 April 2019

Improvements

To align with the Package Signing feature, the Excel activities pack has been officially signed by UiPath.

V2.5.2

Release Date: 18 February 2019

Bug Fixes

• Fixed an issue that caused the Excel Read Row activity to retrieve incomplete information from workbooks. As a result, retrieved rows now include the empty cells they contain.
• In certain situations, Excel Workbooks were closed during the execution of an automation project.

V2.5.1

Release Date: 21 January 2019

Bug Fixes

• The NPOI and SharpLibZip dependencies have been updated to versions 2.4.1 and 1.0 respectively, thus ensuring we use the latest versions for the Excel activity package.

V2.5.0

Release Date: 10 January 2019

Improvements

This new year brings two more languages in the entire UiPath Platform - French and Russian. Since we layed down the foundations of localization in our previous release, we are continuing our efforts in bringing you a more immersive experience and lowering the language barrier bit by bit.

V2.4.7628.27293

Release Date: 19 November 2020

Bug Fixes

• Fixed an issue that caused the Robot to sometimes hang or throw a COM exception when executing Excel activities, for example when an Excel Application Scope activity was used in a loop, or when multiple Excel Application Scope activities were used consecutively in the same process.

V2.4.6884.25683

Release Date: 6 November 2018

Bug Fixes

• Opening password protected files created with Microsoft Excel 2010 threw an error when using the Workbook Activities from the Excel Activities package.
• Fixed an issue that prevented using Excel methods from the Workbook field in Excel Application Scope.

V2.4.6863.30657

Release Date: 16 October 2018

Bug Fixes

• The Workbook Read Range activity returned incorrect values when reading cells that contained hyperlinks.

Known Issues

• The Excel Copy Sheet activity does not function properly with Office 2010 and 2013 versions.

V2.4.6856.17931

Release Date: 9 October 2018

New Features and Improvements

This brings a major update to the Excel Activities Pack, which features 14 new activities:

• Create Table - Creates a table from a specified range.
• Insert/Delete Rows - Adds or removes a specified number of rows at a certain position.
• Insert/Delete Columns - Adds or removes a specified number of columns at a certain position.
• Remove Duplicates Range - Deletes all the rows that are duplicates in a specified range.
• Copy Paste Range - Copies an entire range, including values, formulas, table format, and cell format, and pastes it to a specified sheet.
• LookUp Range - Searches in a specified range for the coordinates of a cell with a certain value and returns them as String variables.
• Get Workbook Sheet - Looks for a sheet based on its index and returns its name as a String variable.
• Get Workbook Sheets - Returns a list of all the sheet names in a workbook as String variables, ordered by their index.
• Auto Fill Range - Takes the formulas defined in the rule range and adapts them to the end range, mimicking the Autofill functionality in Excel.
• Refresh Pivot Table - Refreshes a specified pivot table.
• Create Pivot Table - Creates a pivot table from a specified range.
• Get Selected Range - Returns the selected range as a String variable.
• Copy Sheet - Copies a sheet from a specified workbook and pastes it to a specified workbook. If no other workbook is specified, it is copied to the source file.
• Delete Range - Deletes all the rows in a specified range.

Also, the new PreserveFormat property check box enables the Read Cell, Read Column, Read Row, and Read Range activities keep the formatting of cells they work with, whether it's currency, date, or anything else.

The Read-Only property has been added to the Excel Application Scope activity, enabling data extraction operations on workbooks that are locked for editing or have an edit password.

The moment is finally here - the entire UiPath Platform has been localized, so that you can have a truly immersive experience, from install to design and execution. Now, besides English, you can access everything, including our online documentation, in Japanese.

Bug Fixes

• Fixed an issue that caused the Read Range activity to improperly read worksheets that had the first row empty.

V2.3.6682.26635

Release Date: 18 April 2018

Bug Fixes

• The Read Range activity did not read the cell specified in the Range property if the Use Filter check box was not selected.

V2.3.6660.23035

Release Date: 27 March 2018

This pack brings several new key features for Excel automation, including new properties for Excel Application Scope and Execute Macro. Bug fixes were applied to multiple areas, and a new activity has also joined the pack, enabling users to invoke VBA functions for passing macros, called Invoke VBA.

New Features and Improvements

A new property, EditPassword, has been added to the Excel Application Scope activity. It can hold the password needed for editing protected workbooks.

To avoid situations when a new workbook was automatically created when the path was not correctly specified, Excel Application Scope now has a new property, Create New File. Once selected, if no workbook can be found at the specified path, a new workbook file is created at the same path.

Two new properties have been added to the Execute Macro activity. Macro Parameters enables you to pass multiple parameters to a macro when running it, while Macro Output retrieves any values returned by executing the macro.

The Invoke VBA activity has been introduced to the Excel pack, and enables users to invoke VBA code, running macros against Excel files. You can see more info about it and all of its properties here.

Bug Fixes

• The Write Range activity corrupted .xls files which were saved in the Excel 97-2003 Workbook format and had the Range property set to start from the B or greater column.
• An exception was thrown if you used the Read Range activity with the Range property set to A1:A1.
• A Read Range activity with the UseFilter property box selected threw an exception at runtime.
• Fixed an issue that caused Read Column to read only the A column in a workbook.

V2.0.6526.16321

Release Date: 13 December 2017

This release brings a new activity to the pack, which enables the user to save the workbook that is being used during the runtime of an Excel Application Scope. Also, a new property has been added for the Excel Application Scope, which specifies if the changes made to the workbook are to be saved automatically after exiting the Scope activity. Several known issues have been fixed, as can be seen below.

New Features and Improvements

The AutoSave property has been added to the Excel Application Scope, enabling all child activities of this container to save the workbook after their execution ends.

The Save Workbook activity has been added. This is a child activity of the Excel Application Scope container. It enables the user to save changes made to the workbook throughout the body of the Excel Application Scope.

Bug Fixes

• The AddHeaders property of the Read Range activity is now set to True by default.
• The Get Cell Color activity's Output property category is now spelled correctly, for all you grammar aficionados out there.
• If the WorkbookPath property points to an .xlsm file that doesn't exist, the file is now created without any issues.

Known Issues

• The IsPivot property of the Get Table Range activity does not function properly.
• The Read Column activity fails to properly read columns with empty cells.
• Assigning a variable and then using the Execute Macro activity with the variable as input throws an exception.