https://community.blueprism.com/t5/Product-Forum/Get-Worksheet-Range-as-Collection/m-p/50627#M5827 When i am trying to get any excel column as range from mid,say 1000 to 2000,it is taking 1st value as column name.If i need to add all the values 1st value would be wasted and also i cant access the collection as column name will change for different range of values.How should i generalize the column name. Mon, 16 Apr 2018 18:23:00 GMT SiddharthSiddha 2018-04-16T18:23:00Z https://community.blueprism.com/t5/Product-Forum/Get-Worksheet-Range-as-Collection/m-p/50627#M5827 When i am trying to get any excel column as range from mid,say 1000 to 2000,it is taking 1st value as column name.If i need to add all the values 1st value would be wasted and also i cant access the collection as column name will change for different range of values.How should i generalize the column name. Mon, 16 Apr 2018 18:23:00 GMT https://community.blueprism.com/t5/Product-Forum/Get-Worksheet-Range-as-Collection/m-p/50627#M5827 SiddharthSiddha 2018-04-16T18:23:00Z https://community.blueprism.com/t5/Product-Forum/Get-Worksheet-Range-as-Collection/m-p/50628#M5828 Have a play around with the utility collections VBO - there are actions in there that allow you to add a new header row to your collection (There may also be an example of this in the Process Examples distributed with the templates)..     Mon, 16 Apr 2018 21:17:00 GMT https://community.blueprism.com/t5/Product-Forum/Get-Worksheet-Range-as-Collection/m-p/50628#M5828 Denis__Dennehy 2018-04-16T21:17:00Z