How to get the range as collection without header in Excel VBO?

[LeoXu1]

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

[Denis__Dennehy]

Have you looked at all the Get Worksheet actions, I think one of them has an option to use header on not?

[LeoXu1]

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...

[Denis__Dennehy]

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.

[remko.bouwens]

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.