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

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 cells	Returns the text contained in a specified cell of a worksheet from an established Excel session.
Excel - Get selected cells	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 cells 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 cells	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 cells	Sets the text of one or more cells in an established Excel session, usually with the values contained in a dataset.