Skip to main content

Get Table Range Workbook

Extracts the range of an Excel table from a specified spreadsheet.

Input​

  • Workbook Path: Full path of the workbook
    • Type: System.String
    • Required
  • Sheet Name: The name of the sheet from which to get the range
    • Type: System.String
    • Required
  • Table Name: The name of the table to extract the range from
    • Type: System.String
    • Required

Options​

  • Is Pivot: When selected, this option indicates that the specified table is a pivot one.
    • Type: System.Boolean
  • Password: The password of the workbook, if necessary
    • Type: System.String

Output​

  • Range: The range of the specified table.
    • 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.