Parameters of the Microsoft Excel connector methods
Learn about the parameters of the Microsoft Excel connector methods in RPA Desktop Design Studio.
| Parameter Name | Description | Mandatory? |
|---|---|---|
| CellName | Cell name in a Microsoft Excel worksheet to perform an operation. | |
| ApproximateMatch | Boolean option to find an exact or an approximate match. | Not applicable |
| CellLocation | Cell location in a Microsoft Excel worksheet to perform an operation. | Yes |
| CellRange | Set of one or more continuous cells in a worksheet.Example: A cell range of B2:E4 represents the cells from columns B through E and rows 2 through 4. | Yes |
| SheetName | Name of the sheet from where the data is taken to create a chart. | Yes |
| ChartType | Type of chart you can create in a Microsoft Excel such as an area, bar, line, and pie. | Yes |
| Color | Color to set on a cell. | |
| SheetName | Name of the sheet from where the data is taken to create a Pivot table. | |
| SheetName | Name of the sheet from which the rows will be deleted. | Yes |
| SheetName | Name of the sheet from where the empty columns will be deleted. | Yes |
| ColumnIndex | Index number of the column.Note: Index number must be greater than zero. | Yes |
| ColumnName | Column name in a Microsoft Excel worksheet from which values are to be obtained. | Yes |
| CreateNewFile | Boolean values to indicate whether you want to create a file. If you choose - True: You must provide the filepath including the new file name. - False: You are not creating a file. | No |
| Return \(Integer\) | Returns the Boolean response on whether the column was deleted. | Not applicable |
| DisplayAlerts | Option to display alerts when the file is opened. If you choose:- True: Alert is displayed. - False: Alerts are not displayed. | No |
| Return | Returns the Boolean value that indicates whether a file was open or created.- True: A file was opened or created. - False: No file was opened or created. | Not applicable |
| Distinct | Option to get only unique values. Set to True to get only distinct values or to False to get all values from a cell range. | |
| EndColumnName | Name of the last column in a set of columns. | Yes |
| EndRowIndex | Last row number in a set of rows in a Microsoft Excel worksheet for a bulk operation such as to search, set values, or get values. | Yes |
| FileName | Name of the Microsoft Excel file. | Yes |
| Filepath | Path to the file including the file name. This parameter is used for both opening existing files or creating new files. | Yes |
| Filepath | Path where the exported PDF will be saved. You must provide the name of the file followed by the PDF extension. | Yes |
| FillType | One of the following fill types values: - xlFillFormats: Copy only the formats from the source range to the target range, and repeat if necessary. - xlFillSeries: Extend the values in the source range into the target range as a series \(for example, '1, 2' is extended as '3, 4, 5'\). Formats are copied from the source range to the target range, and repeat if necessary. - xlFillValues: Copy only the values from the source range to the target range, and repeat if necessary. - xlFillCopy: Copy the values and formats from the source range to the target range, and repeat if necessary. - xlFillDays: Extend the names of the days of the week in the source range into the target range. Copy the formats from the source range to the target range, and repeat if necessary. - xlFillWeekdays: Extend the names of the days of the workweek in the source range into the target range. Copy the formats from the source range to the target range, and repeat if necessary. - xlFillMonths: Extend the names of the months in the source range into the target range. Copy the formats from the source range to the target range, and repeat if necessary. - xlFillYears: Extend the years in the source range into the target range. Copy the formats from the source range to the target range, and repeat if necessary. - xlGrowthTrend: Extend the numeric values from the source range into the target range, assuming that the relationships between the numbers in the source range are multiplicative \(for example, '1, 2,' is extended as '4, 8, 16' assuming that each number is a result of multiplying the previous number by some value\). Copy the formats from the source range to the target range, and repeat if necessary. - xlLinearTrend: Extend the numeric values from the source range into the target range, assuming that the relationship between the numbers is additive \(for example, '1, 2,' is extended as '3, 4, 5' assuming that each number is a result of adding some value to the previous number\). Copy the formats from the source range to the target range, and repeat if necessary. | Yes |
| FilterValue | Filter expression that consists of alphanumeric characters and one or more of the following operators: <, >, \\, &, \|, and =. | Yes |
| FindText | Text to search in a Microsoft Excel worksheet. | Yes |
| StartColumnName | Name of the first column in a set of columns. | Yes |
| FirstRowAsHeader | Option to indicate whether the first row in a Microsoft Excel worksheet is a header row. | Yes |
| FormatType | Format type that is supported in a Microsoft Excel.Example: Currency, Number, Long Date | Yes |
| Formula | Formula to be applied on a cell in a Microsoft Excel file. | Yes |
| Height | Height of a row in pixels. | Yes |
| HorizontalAlignment | Horizontal alignment formatting of the specified cells.Example: Left, Right, Center, Justify | Yes |
| IsVisible | Boolean value to indicate whether the file will be visible when it's open. If you choose:- True: The file is displayed. - False: The file is not displayed. | No |
| IncludeHeaders | Option to include the header row while getting a used cell range in a Microsoft Excel. | No |
| LookupRange | Range of columns of data.The values in the first column of the range are the values searched. | Yes |
| OldSheetName | Current name of the worksheet in a Microsoft Excel file that you want to rename. | Yes |
| MacroName | Name of the macro to run. | Yes |
| NewSheetName | New name of the worksheet in a Microsoft Excel file | Yes |
| Password | Password to open a protected file. | No |
| PivotTableName | Name of the new PivotTable. | |
| ReadOnlyMode | Boolean value to indicate whether the file will be opened or created in read-only mode. If you choose:- True: The file is opened or created in read-only mode. - False: The file is opened or created in write mode. | No |
| DestinationRange | The range of cells to be filled in the Microsoft Excel file. | Yes |
| ReplaceTo | Text with which to replace the found text in a Microsoft Excel worksheet. | Yes |
| RowIndex | Index value of a row. | Yes |
| RowNumber | Row number in a Microsoft Excel worksheet to perform an operation. | Yes |
| SaveFolderpath | Folder path to save the file. | Yes |
| SearchColumn | Column name in a Microsoft Excel worksheet where to search the specified text. | Yes |
| Return \(String\) | Returns the name of the active or selected sheet. | Not applicable |
| SheetName | Name of the sheet that will be deleted. | Yes |
| SheetName | Name of the sheet from where data will be exported. | Yes |
| SheetName | The name of the sheet where the data will be filled. | Yes |
| SearchText | Text to search in a Microsoft Excel worksheet. | Yes |
| saveChanges | Boolean values to indicate whether the changes will be saved while closing.- True: The method requests inputs on whether to save changes. - False: The method closes the file and unsaved changes, if any, are lost. | Yes |
| SheetName | Name of the worksheet added to the file. | Yes |
| SheetName | Name of the sheet where the formula will be applied. | |
| SheetName | Name of the sheet from where the column will be deleted. | Yes |
| SortingOrder | Sorting order—ascending or descending—set on a column. | |
| SheetName | Name of the sheet from where the row will be deleted. | Yes |
| SheetName | Name of the sheet from where the cell data will be deleted. | Yes |
| StartRowIndex | First row number in a set of rows in a Microsoft Excel worksheet for a bulk operation, such as to search, set values, get values. | Yes |
| Sheetname | Name of the sheet from where the cells will be copied. | Yes |
| Return | Returns the integer value of the number of columns counted. | Not applicable |
| SheetName | Name of the sheet on which the column count will be performed. | Yes |
| Value | Value to be set on a cell. | Yes |
| VerticalAlignment | Vertical alignment formatting of the specified cells.Example: Top, Middle, Bottom | No |
| Width | Width of a column in a Microsoft Excel. | Yes |
| Password | Option to make the Excel file password-protected. Provide the password in string format. | No |
Enter inputs for parameters
To enter inputs for the parameters, see Configure port properties.
Parent Topic:Microsoft Excel