Parameters of the Microsoft Excel connector methods

  • Release version: Australia
  • Updated March 12, 2026
  • 7 minutes to read

    • Learn about the parameters of the Microsoft Excel connector methods in RPA Desktop Design Studio.

    Table 1. Parameters of the Microsoft Excel connector methods
    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.