Excel

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. AutoMate's Excel action can solve such issues.

When you work with Microsoft Excel, you usually select a cell or cells and then perform an action, such as formatting the cells or entering values in them. AutoMate contains a variety of activities that are capable of automating such steps from start to finish, thus, reducing time and eliminating errors. These activities allow you to activate specific worksheets, select cells on the active worksheet and activate a cell within the selection. In addition, AutoMate is capable of running 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
Excel - Activate worksheet

Activates a worksheet in a workbook from an established Excel session.

Excel - Add worksheet

Adds a new worksheet to a workbook in an established Excel session.

Excel - Close workbook

Closes a workbook previously created or opened in an established Excel session. If modifications have been made, the document will be saved when closed.

Excel - Get active worksheet

Retrieves the name or index of the currently active worksheet in an established Excel session and populates either or both of two variables, one for the worksheet name and the other for the index.

Excel - Get cell(s)

Returns the text contained in a specified cell of a worksheet from an established Excel session.

Excel - Get selected cell(s)

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.

Excel - Open/Create workbook

Opens an existing Microsoft Excel workbook or creates a new workbook and establishes a session name for use in subsequent Excel activities.

Excel - Run macro

Runs an existing Excel macro.

Excel - Select cell(s)

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.

Excel - Set cell(s)

Sets the text of one or more cells in an established Excel session, usually with the values contained in a dataset.