Skip to main content

Insert

The Insert component in Robbot RPA enables you to insert data into a specific cell in an Excel file. You can choose the design type for the Excel entry and provide the necessary details such as the sheet name, text to be inserted, row number, and column number. This component is useful for automating data entry tasks in Excel.

Parameters​

Design Type : Select the Excel entry design. This parameter allows you to choose the design type for the Excel entry. The available options depend on your Robbot RPA configuration.

Design : If you selected the design type, enter the design. This parameter is applicable if you selected a specific design type for Excel entry. Enter the design based on the selected type. The format and structure of the design will vary depending on your Robbot RPA configuration. Type: String

Text : Enter the text to be inserted into the Excel cell. Type : String

Sheet Name : Enter the name of the sheet where you want to insert the data.Type: String

Row Number : Enter the row number where you want to insert the data. Type : Integer

Column Number : You need to enter the column number you want to add. Type : Integer

Result : Returns the status of performing the operation correctly. The result is a boolean value indicating whether the insertion was successful or not. Type : Boolean

Usage

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

Open your Robbot RPA project.

Drag and drop the Insert component to the activity adding section of the Open Excel component.

Configure the component by providing the necessary input:

Select the appropriate design type for Excel entry, enter the design (if applicable), provide the sheet name, text, row number, and column number for the insertion.

Continue building your sequence or workflow by adding other components or actions as needed.

After executing the Insert component, the result will indicate whether the data insertion was successful or not.

You can use the Insert component to automate data entry tasks in Excel by specifying the sheet, cell, and text values for insertion. It provides a convenient way to populate Excel sheets with data in your automation workflows.

Note: The available design types and their specific configurations may vary depending on your Robbot RPA setup and configuration. Refer to the Robbot RPA documentation or consult your system administrator for more information on available design types and their usage.