Data Extraction from excels

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.
fluid phase
process fluid

so how can I do it?


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


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