If you set this property to True, Microsoft Excel asks the user to update links when it opens files with links.

If you set this property to False, the system automatically updates the links and displays no dialog box. This property is a read/write Boolean. The default is True.

Specifies the changes to occur when the workbook is closed. Choose from the following options:

• Save
  • Changes are saved when the workbook is closed.
• DoNotSave
  • Changes are not saved when the workbook is closed.

If you set this property to True, Microsoft Excel displays alerts and messages while a macro is running.

If you set this property to False, the system suppresses the alerts and messages. This property is a read/write Boolean. The default is True.

Specifies how the system opens the workbook file. The options are:

• Create
• Open

When you set this property to Create, Robot Studio creates a file if the file does not exist.

If you select Open, the system tries to open the file but does not create it if the file does not exist. If the file does not exist, the system displays an error message.

The default is Create.

OutputName

(19.1.7 and later)

Specifies one of the supported file types.

• Microsoft Excel
  • .xlsx, .xlsm, .xltx, .xltm, .xls, .xlt
• OpenDocument spreadsheet
  • .ods, .ots
• Character Separated Values
  • .csv, .tsv

If you include a Save method, the system uses the value entered for this property unless it is set to null. If set to null, the system uses the value for the FileName property.

Use this property to specify the name of the workbook file that you want to use in the solution. You must specify a workbook to use the component.

By default, Robot Studio looks at the exact file path selected. However, you can use the Folder property to determine the folder file path that is resolved at runtime by using predefined tokens. You select the tokens from a menu that has options such as Deployment, Temporary, and Personal. The system resolves the folder file path using the selected token.

Closes the workbook and the Microsoft Excel application instance that you associate with the MicrosoftExcel connector.

Depending on your entry in the Changes property, the Close method might also try to save any changes before it closes the workbook.

Exports the range of cells from the worksheet into a Microsoft .NET data table.

If you set the createHeader property to True, the method bases the names of the columns in the table on the first row in the range.

Exports the range of cells from the worksheet into a .NET data table.

If you set the createHeader property to True, the method bases the names of the columns in the table on the first row in the range.

Exports the range of cells from the worksheet into the .NET data table that you specify.

This method retains only the data for the column names that are in the data table that you specify.

This method replaces DBNull.Values with String.Empty in the result table.

If you set the createHeader property to True, the method bases the names the columns in the table on the first row in the range.

Returns the value in the cell that you specify by using the input parameter.

You can select a specific cell, such as d4, or input the cell number from another object. You can also use a named value as the input. For more information, see Named Value.

Imports a .NET data table into the workbook. The row and column are zero (0) based for importing purposes.

The system uses a header for search parameters. If you set the createHeader parameter to True, the automation creates headers for the table.

Imports a .NET data table into the workbook. The row and column are zero (0) based for importing purposes.

The system uses a header for search parameters. If you set the createHeader parameter to True, the automation creates headers for the table.

Use the uiUpdates parameter to suspend user interface updates until the import operation finishes to execute the method more quickly.

Imports a .NET data table into the worksheet that you specify. The row and column are zero (0) based for importing purposes.

The system uses a header for search parameters. If you set the createHeader parameter to True, the automation creates headers for the table.

Imports a .NET data table into the worksheet that you specify. The row and column are zero (0) based for importing purposes.

The system uses a header for search parameters. If you set the createHeader parameter to True, the automation creates headers for the table.

Use the uiUpdates parameter to suspend user interface updates until the import operation finishes to have the method execute more quickly.

Opens a workbook and uses the workbook name that you specify.

This method returns True if the open succeeds and False if it fails or there is an exception. The message contains the Exception message.

Opens a workbook and uses the workbook name that you specify.

Include the readOnly parameter if you want the system to open the workbook in read only mode.

Include the Password parameter if the workbook is protected with a password.

This method returns an error message if the operation fails, but the system does not throw an exception.

Runs a Visual Basic macro or calls a function.

All of the macro or function parameters are optional.

Saves the open workbook and overwrites the file.

This method returns an error message if the operation fails, but the system does not throw an exception.

Saves the open workbook and uses the file name that you specify.

This method returns an error message if the operation fails, but the system does not throw an exception.

Use this method to save the open workbook that you specify in the fileName parameter, in an XLSB format.

If the operation fails, there is no message.

This method does not apply to Microsoft Office 2002 and 2003.

Use this method to save the open workbook that you specified in the fileName parameter in an XLSB format.

If the operation fails, the system returns False and the message that you specified with the out string message parameter.

This method does not apply to Microsoft Office 2002 and 2003.

Casts a generic object into a Microsoft.Office.Interop.Excel.Range type. Use this method when you are iterating through a Range collection with a ListLoop. The ListLoop outputs a generic object without the required properties, methods, and events.

This method creates a Range object with all of its properties, methods, and events. This method returns True if the attempt succeeds and False if there is an exception.

Microsoft.Office.Interop.Excel.Workbook type. Use this method when you iterate through a Workbook collection with a ListLoop. The ListLoop outputs a generic object without the required properties, methods, and events.

This method creates a Workbook object with all of its properties, methods, and events. This method returns True if the attempt succeeds and False if there is an exception.

Casts a generic object into a Microsoft.Office.Interop.Excel.Worksheet type. Use this method when you are iterating through a worksheet collection with a ListLoop. The ListLoop outputs a generic object without the required properties, methods, and events.

This method creates a Worksheet object with all of the properties, methods, and events expected. This method returns True if the attempt succeeds and False if there is an exception.

Accepts a Worksheet object and returns the column (string) and row (int) of the active cell.

The result is the cell address (A1 style notation).

Accepts a Worksheet object and deletes the column that you specified in the columnLetter parameter and shifts the other columns to the left.

Converts a columnNumber (int) to a string which represents the column portion of a cell address. For example:

1 = A, 2 = B, 27 = AA

You can use this method to construct the column portion of a cell address when you are iterating through columns using a ForLoop.

Converts a columnLetter (string) to an int. For example:

A = 1, B = 2, AA = 27

You can use this method to set the limit value of a ForLoop to a column value when you are iterating through the columns in a row.

Accepts a Worksheet object and inserts a column at the location that you specify by using the columnLetter parameter. The method then shifts the other columns to the right.

Use the insertFormatOrigin parameter to determine where to get the format for the inserted column. You can choose from e following options:

• xlFormatFromLeftOrAbove
• xlFormatFromRightOrBelow

This method returns True if the attempt succeeds and False if there is an exception. The system logs any exceptions.

Hides or shows a column.

This method accepts a Worksheet object and sets the visible property for the column you specify.

Returns the address boundaries for a range in A1 notation format.

The cellStart parameter contains the cell address at the per left of the range.

The cellEnd parameter contains the cell address for the bottom right of the range

Sets the AutoFilter property for a single column and returns the filtered range.

Use the XlAutoFilterOperator method to specify the operator to use to associate the two criteria applied by a filter. For more information, see XIAutoFilterOperator Enum.

Sorts a range.

For complete documentation on this method, see Range.Sort.

Inserts a row into the worksheet that you specify after the row number that you specify.

Use the XlInsertFormatOrigin method to specify where to get the format for inserted rows.

Returns the Worksheet that represents the active sheet (the visible sheet) in the workbook that you specify.

This method returns Nothing if no sheet is active.

Returns a Sheets collection that represents all of the sheets in the workbook that you specify.

For more information, see Sheets Interface.

Gets a range object from the worksheet that you specify with cell boundaries.

The system throws an exception if it cannot find the object.

Gets a range object from the worksheet that you specify using cell boundaries.

This method returns an error message if the operation fails. The system does not throw an exception.

Inserts one or more worksheets into the workbook that you specify.

Use the insertBefore and count parameters to specify where to insert the worksheet. For example, if you enter True and 3, the system inserts the three new worksheets before the worksheet that you specify with the sheetName parameter.

If you enter False and 3, then the system inserts the three new worksheets after the worksheet you specify with the sheetName parameter.

Inserts a worksheet into the workbook that you specify.

Use the insertBefore parameter to specify where to insert the worksheet. For example, if you enter True, the system inserts the new worksheet before the worksheet you specify with the sheetName parameter.

If you enter False, then the system inserts the new worksheet after the worksheet you specify with the sheetName parameter.