Excel Actions
Description: Microsoft Excel is the industry standard for spreadsheet applications. It features data analysis, calculation and virtualization tools that help businesses track and highlight pertinent data. Users of all professions rely on Excel to manage daily operations, such as perform detailed analysis, gather statistics, and generate data. However, as with most applications, administering Excel can be tedious and time consuming. Excel action can solve such issues. It contains a variety of activities that are capable of automating common to complex Excel processes, thus, reducing time and eliminating errors. It also contains a new activity that enables execution of existing Excel macros as part of a fully automated sequence.
Available Activities
The list of activities for this action are arranged below in alphabetical order. For more information about a specific activity, click the associated link.
|
Activity |
Description |
|---|---|
|
Activates a worksheet in a workbook from an established Excel session. |
|
|
Adds a new worksheet to a workbook in an established Excel session. |
|
|
Closes a workbook previously created or opened in an established Excel session. If modifications have been made, the document will be saved when closed. |
|
|
Retrieves the name or index of the currently active worksheet in an established Excel session. The action populates either or both of two variables, one for the worksheet name and the other for the index. |
|
|
Retrieves the position of the currently active cell or range of cells in an established Excel session and populates one or more variables with the cell reference or position coordinates. Use the Activate Cell activity to activate a cell or range of cells in an established worksheet. |
|
|
Retrieves the position of the currently selected cell or range of cells in an established Excel session and populates one or more variables with the cell reference or position coordinates. Use the Select cell(s) activity to activate a specific cell or range of cells in an established worksheet. |
|
|
Opens an existing Microsoft Excel workbook or creates a new workbook and establishes a session name for use in subsequent Excel activities. |
|
|
Runs an existing Excel macro. |
|
|
Selects a single cell or multiple cells, ranges, rows or columns within the currently active worksheet in an established Excel session and populates a dataset with results. |
|
|
Sets the text of a selected cell in an established Excel session. |