How to Read Datatable in Excel

Help Activities
, ,
1

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

2

@minth08

can you provide what was your input

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

Row is fluid.

4

@minth08

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…

Cheers…!

5

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.

6

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

7

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.
8

@minth08

can you check out the XAML file

16.10.2023_Forum_1.xaml (10.4 KB)

image
image639×754 20.4 KB

9

@minth08

  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

Cheers

10

Hi,

  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.
11

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