Skip to main content

Use Excel File

Gets Excel file to use.

Input​

  • Workbook Path: The full path of the Excel workbook to be used
    • Type: System.String
  • Password: The password required for opening the Excel workbook, if the file is password-protected.
    • Type: System.String
  • Edit Password: The password required for editing the Excel workbook, if the file is password-protected.
    • Type: System.String

Options​

  • Create If Not Exists: If the workbook cannot be found at the specified path, a new Excel workbook is created with the name specified in the WorkbookPath property field.
    • Type: System.Boolean
    • Required
  • Read Only: If selected, the specified workbook is opened in Read-Only mode. Selecting this check box enables you to perform data extraction operations in an Excel file which is locked for editing or has an edit password. This option is not selected by default.
    • Type: System.Boolean
    • Required
  • Save Changes: Saves the workbook after each Excel activity that makes a change to its content.
    • Type: System.Boolean
    • Required
  • Read Formatting: Choose what formatting should be applied to values read from Excel.
    • Type: System.Int32
    • Required
    • Dropdown Options:
      • (null)
      • Default
      • Raw Value
      • Display Value

Output​

  • Workbook: The path of the workbook to use
    • Type: Microsoft.Office.Interop.Excel.Workbook

Details​

  • This is a container activity that enables other Excel activities to be used within it. The Excel application must be installed on the machine where the process will run.