Here I want to extract P771 column for the respective DTC column i.e 1st Column
Experts plss help…
give a try on read range with an offst to downr rows e.g. B4
No thats not working bcoz i want column name as DTC for the 1st column
[quote=“Tabbu, post:3, topic:357333”]
as DTC for the 1st column
[/quote]But sure about your requirements, whether you are extracting other fields or not.
If your concern is only to get P771 value for DTC column, you may consider reading the data and then removing the unwanted columns and headers from the top(as the feels are merged, there will be repeating values which aren’t required)
This can be done at datatable level by using delete data row activity.
Also you may read from the first row of data as suggested above correctly by Peter, and then only keep desired columns and add headers to them.
You can add column headers individually using this :
dtInput.Columns(0).Columnname(0) = “DTC”
I recommend to read the data and then process it to make a standard datatable, using proper headers and removing unwanted rows from top. It might take some time but it’s the ideal way and good for long term.
Hope this helps!