Data Extraction from excels

Help Studio
, ,
1

Hi team

I need to extract various data from excels, the excel sheets have a somewhat fixed form template, so how can I extract the data from it
sample of one of the excels is attached below:
sample.xls (280.5 KB)

I need to extract the following data:
tag no.
service
P&ID
fluid phase
process fluid
equipment

so how can I do it?

2

@Aishwarya_Bhargava

As the template is fixed then you can use Read Range activity and output the datatable.
You can retrive the values corresponding to the index values

Like Datatable(rowNumber)(Index of Column)

Hope this may help you

Thanks

3

this is just one of the templates that exist, there are many more, which are not fully displayed