How to get the particular table values and store it into another datatable

Help Studio
, , ,
1

Hi,

I have sheet1 which contains mores texts and tables. I need to extract the particular table values. That The table values always start from 9th row of “A” column and end with "E"Column E9. The table contains header, values &
Input.xlsx (8.9 KB)
multiple row.

I need to extract that particular 9th row starting table values alone until the table values comes into empty Row. Bcoz in sheet contains so many tables but i need to extract that table start from 9th row and the row will be one or many.

Can someone Guide me on this please?

2

Hi @jamuna_T

So your starting point is always fixed that is A9.
You need to find end point, or end row.
Use a Lookup DataTable and find for one header of the next table.
for example you can try to find “NO” or “Range” keyword, in which row it is written, and then.
Use “A9:E”+(indexRowFound+1).toString

Thanks
Happy Automation! :smiley:

1 Like
3

@adiijaiin Thanks for your response. I will try this.
If possible, Could you please provide the xaml for this

4

Hi @jamuna_T

TestExcel.xaml (16.1 KB)

THis should work

1 Like
5

@adiijaiin Thanks for the Response & Xaml. It is working with sample input file as per expected but when I test with actual input file. The second table also added into the output sheet with headers & values. For example please refer output screenshot below.

image

how to get the first table alone and remove second table.
Please let me know @adiijaiin
Thanks!!

6

Can you DM me this file?
COz I tried to change the data to what you have right now and it worked for me. The same logic worked

1 Like
7

Hi @jamuna_T

Try this

This image depicts a sequence of automated Excel processes within an RPA workflow, where it opens an Excel file, identifies the first and last data rows, and copies a specified range to another sheet. (Captioned by AI)
This image depicts a sequence of automated Excel processes within an RPA workflow, where it opens an Excel file, identifies the first and last data rows, and copies a specified range to another sheet. (Captioned by AI)818×1312 65.3 KB

Input:

The image shows an Excel worksheet titled "Sheet1" with data organized into two main tables: one listing levels, company names, scales, IDs, and values; and another with columns for NO, Value, Range, date, Year, and Month. (Captioned by AI)
The image shows an Excel worksheet titled "Sheet1" with data organized into two main tables: one listing levels, company names, scales, IDs, and values; and another with columns for NO, Value, Range, date, Year, and Month. (Captioned by AI)916×750 10.9 KB

Output:

A spreadsheet labeled "Final" contains a table with columns "Level," "Company," "Scale," "ID," and "Value," filled with three rows of data. (Captioned by AI)
A spreadsheet labeled "Final" contains a table with columns "Level," "Company," "Scale," "ID," and "Value," filled with three rows of data. (Captioned by AI)625×759 9.09 KB

Sequence15.xaml (17.0 KB)

Regards,

1 Like
8

@lrtetala Thanks for response, It is working , How we can store this values into the datatable variable instead of using the read range activity. Please let me know possible way.
Thanks !!

9

@ adiijaiin.Thanks for the response. I am not able share the actual input.

10

@jamuna_T

This image depicts a sequence of steps in an automation workflow for processing an Excel file, including finding the first and last data rows based on a specified column and copying the range to another sheet. (Captioned by AI)
This image depicts a sequence of steps in an automation workflow for processing an Excel file, including finding the first and last data rows based on a specified column and copying the range to another sheet. (Captioned by AI)818×1466 72.6 KB

DT = Excel.Sheet("Final").DataTableValue

Regards,

1 Like
11

No Problem. :slight_smile: But the code works, I ran a few different sheets that I prepared.

Anyway, glad to help.

1 Like
12

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