Excel activities

Every activity in Velophex.Excel.Activities 0.7.1-rc.7.

Supported

This pack is part of the supported Core profile and ships with Studio.

Older build

These pages come from build 0.7.1-rc.7; other Core packs are documented from 0.7.1-rc.12. Properties can differ slightly in the release you install.

Package Velophex.Excel.Activities · version 0.7.1-rc.7 · 58 activities. Generated from build 0.7.1-rc.7.

CSV#

  • Append to CSV: Appends rows from a DataTable to the end of a CSV file.
  • Read CSV: Reads a CSV or delimited text file into a DataTable.
  • Write CSV: Writes data from a DataTable to a CSV file.

Excel#

  • Append Range (Excel): Appends rows from a DataTable below the last used row in a sheet.
  • Auto Fill: Extends a source range down or right over a destination that starts with it: formulas keep relative references, two or more numbers continue as a series, other values repeat.
  • Auto Fit Range: Automatically adjusts column widths and row heights to fit content.
  • Clear Range: Clears contents and formats in a specified range or entire sheet.
  • Copy Paste Range: Copies cells from a source range to a destination sheet and cell.
  • Copy Sheet: Duplicates a worksheet in the workbook under a new name.
  • Create Sheet: Adds a new worksheet to the workbook.
  • Create Table: Turns a range, its first row the headers, into a named Excel table.
  • Delete Range: Deletes a range and shifts the cells below up or the cells to the right left, or deletes the range's entire rows or columns.
  • Delete Sheet: Deletes a worksheet from the workbook.
  • Export to CSV: Writes a sheet or range to a CSV file, each value as Excel displays it. Replaces the file if it exists.
  • Fill Range: Writes one value to every cell of a range. A value starting with = is a formula whose relative references move with each cell.
  • Filter Range: Applies an autofilter on a specified range and column.
  • Find/Replace Value: Finds cells whose displayed value matches, and optionally replaces it. Formula cells are found but never rewritten.
  • Format Cells: Sets the number format, font, fill, alignment and borders of a range. Options left empty keep the cells' current format.
  • Get Cell Formula: Reads the formula from a specific cell.
  • Get Workbook Sheets: Retrieves the names of all worksheets in the workbook.
  • Insert/Delete Columns: Inserts or deletes columns starting at a specified index.
  • Insert/Delete Rows: Inserts or deletes rows starting at a specified index.
  • Lookup Range: Searches for a cell containing the given value in a sheet or range.
  • Match Function: Returns the position of a value in one row or one column, as Excel's MATCH.
  • Open Excel File: Opens an .xlsx or .xlsm file for the activities of a Use Excel File scope.
  • Protect Sheet: Protects or unprotects a worksheet with an optional password.
  • Read Cell (Excel): Reads the value and the displayed text of one cell.
  • Read Column (Excel): Reads all populated cell values down a specified column.
  • Read Range (Excel): Reads cells from an Excel sheet into a DataTable.
  • Read Row (Excel): Reads all populated cell values across a specified row.
  • Remove Duplicates: Deletes the rows of a range that repeat an earlier row, comparing every column, and shifts the cells below up.
  • Rename Sheet: Renames an existing worksheet.
  • Save Excel File As: Writes the workbook, pending changes included, to another .xlsx or .xlsm file, replacing it if it exists. The scope keeps working on the original file.
  • Save Workbook: Saves any pending changes made to the workbook.
  • Set Cell Color: Sets the fill background color of a cell or range.
  • Set Cell Formula: Sets a formula in a specific cell.
  • Sort Range: Sorts a specified range by one column.
  • Text to Columns: Splits the text of each cell of one column at a delimiter into the columns to its right (or from a destination cell). Numeric parts are written as numbers.
  • VLookup: Finds a value in the first column of a range and returns the value in the same row of another column, as Excel's VLOOKUP.
  • Write Cell (Excel): Writes a value to a cell in a sheet.
  • Write Range (Excel): Writes data from a DataTable to an Excel worksheet.

Excel Desktop#

  • Change Pivot Data Source: Points a pivot table at a new source range in Microsoft Excel, refreshes it and saves the workbook. Needs Excel installed.
  • Create Pivot Table: Creates a pivot table from a range in Microsoft Excel, with row, column and value fields, and saves the workbook. Needs Excel installed.
  • Insert Chart: Adds a chart of a range to a sheet in Microsoft Excel and saves the workbook. Needs Excel installed.
  • Invoke VBA: Runs VBA code from a file against a workbook in Microsoft Excel, without adding it to the workbook. Needs Excel with "Trust access to the VBA project object model" on.
  • Refresh Data: Refreshes a workbook's data connections, queries and pivot tables in Microsoft Excel, or one named pivot table, and saves it. Needs Excel installed.
  • Run Macro: Runs a macro of an .xlsm, .xlsb or .xls workbook in Microsoft Excel and returns its result. Needs Excel installed; the workbook's macros run with your rights.
  • Save as PDF: Exports a workbook, or one sheet, to PDF with Excel's print layout. Needs Excel installed; the workbook is not changed.

Workbook#

  • Append Range (Workbook): Adds a DataTable's rows below the last used row of a workbook file's sheet, without Use Excel File. Creates the file and the sheet when missing.
  • Get Sheets: Lists the sheet names of a workbook file in workbook order, without Use Excel File.
  • Get Table Range: Returns the range of a named Excel table in a workbook file, for example A1:C10, without Use Excel File.
  • Read Cell (Workbook): Reads one cell of a workbook file, without Use Excel File.
  • Read Cell Formula: Reads the formula of one cell of a workbook file, without Use Excel File. Empty when the cell holds no formula.
  • Read Column (Workbook): Reads a column of a workbook file from a starting cell to the column's last used cell, without Use Excel File.
  • Read Range (Workbook): Reads a range of a workbook file's sheet into a DataTable, without Use Excel File.
  • Read Row (Workbook): Reads a row of a workbook file from a starting cell to the row's last used cell, without Use Excel File.
  • Write Cell (Workbook): Writes a value to one cell of a workbook file, without Use Excel File. Creates the file and the sheet when missing.
  • Write Range (Workbook): Writes a DataTable to a workbook file's sheet, without Use Excel File. Creates the file and the sheet when missing.

CSV

Excel

Excel Desktop

Workbook