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.