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.
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?
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:
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
Can you please explain how to do
Thanks in advance
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
@Suggala_Tejaswi @srujana13a5 @Soundarya_Guduri
Kindly find the Xaml file
Forum_Lookup_Excel.zip (22.9 KB)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.