How to extract data between particular rows from excel?

[Suggala_Tejaswi]

Hi everyone,
Need to extract data between particular rows from multiple excels

Highlighted rows same for all excel files ,between those rows data have to extract the data and data should stored in datatable variable.

[HainTavuk (Kadir Elgün)]

If i understand the question correctly,
You can use Read Range activity and give spesific Range like A1:B5

[Suggala_Tejaswi]

Hi @HainTavuk
We need to extract only based MASTER GROUP GROSS SALES SUMMARY and MASTER GROUP DISCOUNT SUMMARY

[HainTavuk (Kadir Elgün)]

is that MASTER GROUP GROSS SALES SUMMARY and MASTER GROUP DISCOUNT SUMMARY
rows at the same position?

[Gokul001 (Gokul Balaji)]

Duplicate Topic : How to extract data from excel

[srujana13a5]

Hi everyone,
Need to extract data between particular rows from multiple excels

Highlighted rows same for all excel files ,between those rows data have to extract the data and data should stored in datatable variable.

[Gokul_Jayakumar (Gokul Jai)]

@srujana13a5

Highlighted rows same for all excel files ,between those rows data have to extract the data and data should stored in datatable variable.

Hello @srujana13a5
You can use Lookup in excel application scope and find the value of both hight lighted values and pass in read range to extract the specific range values.

[Marius_Puscasu]

Hello @srujana13a5 ,

For reading data from:

• A cell, you have the Read Cell activity: https://docs.uipath.com/activities/docs/excel-read-cell

• A row, you have the Read Row activity: https://docs.uipath.com/activities/docs/excel-read-row

• A column, you have the Read Column activity: https://docs.uipath.com/activities/docs/excel-read-column

• A range, you have the Read Range activity: https://docs.uipath.com/activities/docs/excel-read-range

Now, it depends only by how your business scenario is structured. You can use one or more of the above mentioned UiPath activities.

Hope it helps!
Best regards,
Marius

[srujana13a5]

Can you please explain how to do

Thanks in advance

[Gokul_Jayakumar (Gokul Jai)]

@srujana13a5
Kindly Share the Sample input file, I will send the workflow

[loginerror (Maciej Kuźmicz)]

I merged duplicated topics.

[srujana13a5]

Can you please check the Input file in my topic

Thanks in advanced

[Suggala_Tejaswi]

No ,it will be in different positions in each file

[Gokul_Jayakumar (Gokul Jai)]

@Suggala_Tejaswi

Hi everyone,
Need to extract data between particular rows from multiple excels

Kindly find the Workflow , which may help you.
Forum_Lookup_Excel.zip (14.5 KB)

[Gokul_Jayakumar (Gokul Jai)]

@Suggala_Tejaswi

Highlighted rows same for all excel files ,between those rows data have to extract the data and data should stored in datatable variable.

@Suggala_Tejaswi @srujana13a5 @Soundarya_Guduri

Kindly find the Xaml file

Forum_Lookup_Excel.zip (22.9 KB)