Skip to main content

Read Cell Workbook

Reads the value of an Excel cell and stores it in a variable.

Input​

  • Workbook Path: The full path of the Excel spreadsheet that you want to use.
    • Type: System.String
    • Required
  • Sheet Name: The name of the sheet in which the cell that you want to read is
    • Type: System.String
    • Required
  • Cell: The cell that you want to read
    • Type: System.String
    • Required

Options​

  • Password: The password of the Excel workbook, if necessary.
    • Type: System.String

Output​

  • Result: Stores the information from the specified spreadsheet cell in a variable.
    • Type: System.Object
    • Required

Workbook​

  • Workbook: The existing workbook instance.
    • Type: DocumentFormat.OpenXml.Spreadsheet.Workbook
    • Required

Details​

  • This activity can be used even if Excel is not installed in the environment where the process runs.