Open Excel

The Open Excel component in Robbot RPA is a NativeActivity that enables you to open Excel files and create a session that includes the file's information. This session can be shared with other components in your automation workflow, allowing you to perform various operations on the Excel file.

Parameters

Excel File Path : Click the button and select the Excel file you want to open. Specify the file path as a string. This parameter allows you to choose the Excel file that you want to work with. Type : String

Password : If the Excel file is password protected, fill in this field. Type : String

Usage

To use the OpenExcel component in your Robbot RPA project, follow these steps:

Open your Robbot RPA project.

Drag and drop the OpenExcel component into your sequence or workflow.

Configure the component by providing the necessary input:

Click the button next to the Excel File Path parameter and select the file location of the Excel file you want to open.

If there is a password in the Excel file, enter the file password.

Continue building your sequence or workflow by adding other components or actions that require the Excel file session.

When other components require the Excel file session, make sure to use the session created by the Open Excel component as the input.

Execute the workflow or sequence to open the Excel file and create the session.

The OpenExcel component creates a session that allows other components to interact with the opened Excel file. You can use this session to perform various operations such as reading data, writing data, formatting cells, or any other Excel-related tasks.

Note: Make sure to properly close the Excel file session after you have finished working with it using the CloseExcel component to release any resources and ensure the file is not locked.

Please refer to the Robbot RPA documentation or consult your system administrator for more information on working with Excel files and sessions in Robbot RPA.