https://community.blueprism.com/t5/Product-Forum/How-to-get-the-range-as-collection-without-header-in-Excel-VBO/m-p/68181#M20786 If your excel document is too large then I suggest you use the get workseet action that allows you to read smaller ranges. Another option for you is to then use the utility collections object to get the field (header) names of your collection. You could then use the actions in that object to rename headers etc. What you want to do is certainly possible - it just requires you to experiment with different Excel and Collection actions. If in doubt contact a more experienced lead developer or get your implementation lead to reach out to your Blue Prism DEM for advice. Thu, 29 Dec 2016 15:12:00 GMT Denis__Dennehy 2016-12-29T15:12:00Z https://community.blueprism.com/t5/Product-Forum/How-to-get-the-range-as-collection-without-header-in-Excel-VBO/m-p/68178#M20783 Hi everyone, I am facing the issue to get the range in excel without headers. My excel template has some headers with two rows that will show as XXX... in collection. I cannot get the value in those columns since I cannot type the correct field names. So I am thinking to enter the header manually and get the range with amount I needed into collection. But it seems Blue Prism will automatically set the first row as header and cannot directly import the value I need. Is there any way to work around this issue? Thanks. Leo Wed, 28 Dec 2016 00:02:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-get-the-range-as-collection-without-header-in-Excel-VBO/m-p/68178#M20783 LeoXu1 2016-12-28T00:02:00Z https://community.blueprism.com/t5/Product-Forum/How-to-get-the-range-as-collection-without-header-in-Excel-VBO/m-p/68179#M20784 Have you looked at all the Get Worksheet actions, I think one of them has an option to use header on not? Wed, 28 Dec 2016 14:54:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-get-the-range-as-collection-without-header-in-Excel-VBO/m-p/68179#M20784 Denis__Dennehy 2016-12-28T14:54:00Z https://community.blueprism.com/t5/Product-Forum/How-to-get-the-range-as-collection-without-header-in-Excel-VBO/m-p/68180#M20785 Thank you for your advice. However, my worksheet is too big to use get worksheet function. I cannot view it after I put it into collection. Blue Prism prompts a message to force closing it. Is it possible that I can get the field name like this in excel: XXXXX YY In collection it will only show XXXX... Wed, 28 Dec 2016 19:47:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-get-the-range-as-collection-without-header-in-Excel-VBO/m-p/68180#M20785 LeoXu1 2016-12-28T19:47:00Z https://community.blueprism.com/t5/Product-Forum/How-to-get-the-range-as-collection-without-header-in-Excel-VBO/m-p/68181#M20786 If your excel document is too large then I suggest you use the get workseet action that allows you to read smaller ranges. Another option for you is to then use the utility collections object to get the field (header) names of your collection. You could then use the actions in that object to rename headers etc. What you want to do is certainly possible - it just requires you to experiment with different Excel and Collection actions. If in doubt contact a more experienced lead developer or get your implementation lead to reach out to your Blue Prism DEM for advice. Thu, 29 Dec 2016 15:12:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-get-the-range-as-collection-without-header-in-Excel-VBO/m-p/68181#M20786 Denis__Dennehy 2016-12-29T15:12:00Z https://community.blueprism.com/t5/Product-Forum/How-to-get-the-range-as-collection-without-header-in-Excel-VBO/m-p/68182#M20787 Another option you might want to consider is using the OLEDB VBO. This allows you to get the data you need into collection, using a SQL Query. Wed, 04 Jan 2017 14:51:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-get-the-range-as-collection-without-header-in-Excel-VBO/m-p/68182#M20787 remko.bouwens 2017-01-04T14:51:00Z