Office

This section lists commands to automate Microsoft™ Office applications.

Some commands use the Microsoft™ Office version installed in the computer to run. Most Excel commands work regardless whether an Office suite version is installed. See more details below.

The following commands do not require Microsoft™ Office installed:

• Open Excel File
  Opens an Excel file.

• Checks If a Worksheet Exists
  Checks if a worksheet exists in an Excel file by looking up its name or index.

• Clone Excel Spreadsheet
  Clones the contents of a worksheet of an Excel file.

• Close Excel
  Closes an Excel file.

• Set Value in Excel
  Defines a value to a cell in Excel.

• Save Excel As
  Saves an Excel file to a defined format.

• Rename Excel Worksheet
  Renames a worksheet from an Excel file, located by index or name.

• Convert Excel from XLS to XLSX
  Converts a .xls file to an .xlsx Excel file.

• Insert Data Table into Excel File
  Creates and inserts values from a data table into an existing Excel file.

• Get Excel Table
  Gets the value of a table from an Excel file, based on its row and column coordinates.

• Get Excel Value
  Gets the value of a cell in an Excel file, using column and row coordinates.

• Excel Calculate Formula
  Calculates all formulas in an Excel file.

• Excel Merge
  Merges the contents of Excel files into one file according to the order set.

The following commands require Microsoft™ Office 2010 or higher installed:

• Assign Value to Office
  Assigns a value to an existing location in an Office file.

• Attach Office Application
  Connects to an Office application that is open.

• Close Office Application
  Closes an opened Word, Excel, or PowerPoint Office application.

• Create from Data Table
  Creates an Excel file and inserts the values of a data table into created file.

• Create Office File
  Creates a Word, Excel, or PowerPoint Office file and returns the process ID and application.

• Export Office File As
  Exports the contents of an Office file and returns it to an .xps or .pdf file.

• Get Office Text
  Gets the text from an Office file.

• Get Office Value
  Gets the value of an existing location in an Office file.

• Get Text from File
  Gets the text from a specified file.

• Go to Location in Office
  Allows the user to go to specific points in an Office file.

• Open Office File
  Opens an Office file of Excel, Word, or PowerPoint type.

• Print Office File
  Prints the content of an Office file.

• Refresh Office Application
  Refreshes information in an Office file opened by IBM RPA Studio.

• Run Macro in Excel
  Runs a macro defined in an Excel file.

• Run Macro Office
  Runs a macro defined in an Office application opened by the IBM RPA Studio.

• Save Office File
  Saves the contents of an Office file to the directory you entered.

• Save Office File As
  Saves an Office application file to a defined folder.