Read Excel
The Read Excel component in Robbot RPA is used to read data from an Excel file. You can specify the range of rows and columns to read, and you can also choose whether to treat the first row as the header row.
Parameters
Is Header : When this checkbox is selected, the first row of the Excel file will be treated as the header row. The values in the first row will be used as the column names in the resulting data table. Type : String
Start Row : Specify the row number from which you want to start reading the data. This is an optional parameter. Type : Integer
End Row : Specify the row number at which you want to stop reading the data. This is an optional parameter. If not specified, all rows until the last non-empty row will be read Type : Integer
Start Column : Specify the column number from which you want to start reading the data. This is an optional parameter Type : Integer
End Column : Specify the column number at which you want to stop reading the data. This is an optional parameter. If not specified, all columns until the last non-empty column will be read Type : Integer
Column Name : You need to write the column name you want to read. Type : String
Sheet Name : Enter the name of the sheet you want to read the data from. Type: String
Table Name : You need to write the table name you want to read. Type : String
Usage
To use the ReadExcel component in your Robbot RPA project, follow these steps:
Open your Robbot RPA project.
Drag and drop the Read Excel component to the activity adding section of the Open Excel component.
Configure the parameters based on your requirements:
Select the Is Header checkbox if the first row of the Excel file is the header row.
Specify the Start Row, End Row, Start Column, End Column and/or Column Name as needed.
Enter the Sheet Name from which you want to read the data.
The output of the ReadExcel component will be a JArray containing the read data from the Excel file. You can use this JArray in subsequent components or actions for further processing or analysis.
Continue building your sequence or workflow by adding other components or actions that require the data from the Excel file.
Execute the workflow or sequence to read the data from the Excel file.
The ReadExcel component provides a convenient way to read data from an Excel file in Robbot RPA. You can specify the range of rows and columns to read, and choose whether to treat the first row as the header row.
Note: The ReadExcel component relies on external libraries or APIs to read Excel files. Ensure that you have the necessary dependencies installed or configured in your environment to successfully read Excel files.
Please refer to the Robbot RPA documentation or consult your system administrator for more information on working with Excel files and reading data from them in Robbot RPA.