How to Read Datatable in Excel

Assuming that there is a data table whose position changes in Excel, please tell me how to read the table.


can you provide what was your input

Column1 Column2 Column3 Column4
Value1 Value2 Value3 Value4
Value5 Value6 Value7 Value8

Row is fluid.


You can use the Read Range activity. This activity allows you to read the data from an Excel worksheet and store it in a Datatable variable…


Hi @minth08 ,

Could you let us know if the Header position also changes ? Meaning you would not know where the header row start ?

Do provide us with 2 different example data so that we can understand and analyse the data representation and accordingly provide you a suggestion.

Header count: Fixed
Header Start Location: Fluid
Number of rows: fluid

Hello @minth08
Try this

  • Use Excel lookup activity and search the position of Column 1 Header. —> It gives a column position like A10
  • In the Read range activity pass the Look-up Variable in Range Properties. It will read the data until the end.


can you check out the XAML file

16.10.2023_Forum_1.xaml (10.4 KB)


  1. Ideally read range activity with no range specified should read the data from the first available cell
  2. If 1 does not work…then try to use find/replace activity to find the first column name…use that cell number to reqd the range from there

Hope this helps



  1. Open Excel File:
  • Use the “Excel Application Scope” activity to open the Excel file. Specify the file path as the input.
  1. Read Excel Data:
  • Inside the “Excel Application Scope,” you can use the “Read Range” activity to read data from the Excel file. If the table position changes, you can read the entire sheet into a DataTable.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.