Scrape data from excel with multiple sections

Help
1

I have an excel with multiple data sections

example

Age Report
Name Age
name1 21
name2 45
name3 24

City Report
City State Zip
New York NY 10132
Chicago IL 82322
Las Vegas NV 65321

both the data sections are on the same sheet and I just want to extract the first section of the data (Name, age). the number of rows in the section is not constant and will vary everytime.

What is he best way to process this kind of excel ?

Thanks in advance.

2

@ajitbhatt
U can use read cell Activity or u can also use for loop activity, depends

3

Read excel and import rows to another datatable until you get blank row ( or blank cell of first column).

4

thanks. that is a good solution. I looked for the start of the next section (heading) instead of a blank row to read the first one into a secondary data table.

2 Likes
5

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