How to extract data between particular rows from excel?

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.

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

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

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

Duplicate Topic : How to extract data from excel

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.

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.

Hello @srujana13a5 ,

For reading data from:

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

Can you please explain how to do

Thanks in advance

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

I merged duplicated topics.

Can you please check the Input file in my topic

Thanks in advanced

No ,it will be in different positions in each file

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

@Suggala_Tejaswi @srujana13a5 @Soundarya_Guduri

Kindly find the Xaml file :point_down:

Forum_Lookup_Excel.zip (22.9 KB)

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