How to extract data table from unstructured excel sheet

Help
1

Hi, Can any one suggest how to extract data table(dynamic) from unstructured excel sheet?
I want to extract the dynamic data table and process the records one by one in a web application? Please suggest.

tried with Read range like range(“B13:N19”) buy my range keep changing.
Tried like range(“B13”), i thought it automatically calculates range starting from B13 to end of the data table but fails.

Can any one guide me on this, please?

sample.xlsx (10.1 KB)

1 Like
2

@tkatakam27

It should work and will read from B13 till end of the file.

1 Like
3

@tkatakam27, I hope this will help

  1. Use a read range activity and read the entire sheet data without giving any range
  2. You will get the number of rows using datatable.rows.count and store in a variable …
  3. Then in the second read range activity, give the range as “B13:N” + (count - 13).tostring
1 Like
4

This should work for sure
Kindly make sure that we are using EXCEL related activities and not WORKBOOK activities like get the read range from EXCEL activities package and not from workbook activities package

You were good with your actual steps and try with “B13”

Or only if we split tables then we may face this issue
Is that so
And if so we can get the count of the whole table with their number of rows
—use a read range activity and get the datatable as output named dt
—now use a assign activity like this
Out_rowcount = dt.Rows.Count
Where Out_rowcount is a int32 variable
—then use another read range activity and mention the range as
”B13:N”+(Out_rowcount-14).ToString
Where we will be getting the datatable with those rows alone from B13 till end

or if it’s a single table then mention just “B13” alone will work thus taking till the last cell value of the table from B13

Cheers @tkatakam27

5

Yes, it worked. Thanks for your time @HareeshMR, @Palaniyappan, @lakshman .

2 Likes
6

No worries
Cheers @tkatakam27

7

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