Skip to main content

Read Cell Formula Workbook

Reads the formula of a cell from a spreadsheet as a string

Input​

  • Workbook Path: Contains the full path of the Excel workbook to be used
    • Type: System.String
    • Required
  • Sheet Name: The name of sheet from the workbook
    • Type: System.String
    • Required
  • Cell: The address of the cell from which to read the formula.
    • Type: System.String
    • Required

Options​

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

Output​

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

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.