Skip to main content

ReadExcellFile

Reads data from a specified Excel worksheet and loads it into a DataTable.

Core Functions

  • Opens an Excel file from a given file path
  • Extracts worksheet data into a structured DataTable

Inputs

  • Path:Specifies the file path of the Excel file to be read.
  • Type:: String
  • SheetName: Specifies the name of the worksheet to read data from.
  • Type:: String

Outputs

  • Output: Returns the Excel data from the specified worksheet as a DataTable.
  • Type:: DataTable

0000000000< > Short Technical Summary An Excel input activity that reads worksheet data and converts it into a DataTable for further processing in automation workflows.