PADExcelexceltabledatatableread

Read Named Excel Table

Reads data from a named Excel Table (Insert → Table in Excel) into a PAD DataTable. Named tables are more reliable than range reads because they expand automatically and always include headers. Includes zombie-process prevention and empty-row cleanup.

Members OnlySign in or create a free account to view and copy this pattern.

Usage Notes

  • Format your Excel data as a Table (Ctrl+T) and give it a name in the Name Box — this is what varTableName refers to.
  • Named tables auto-expand when rows are added, so you never need to update row ranges.
  • Always open with ReadOnly: True and Visible: False for read operations.
  • Always close the Excel instance — unclosed instances leave zombie EXCEL.EXE processes.
  • If the workbook has multiple sheets, activate the correct sheet before reading.

Requirements

  • Power Automate Desktop 2.30+
  • Excel file with a named Table (not just a range)
  • Variables: varExcelPath (Text), varTableName (Text), varTableData (DataTable)