Blue Prism Excel export without headers Ask

Question

I'm searching for a solution for this: I have an excel file with headers that contain "." this is a problem for Blue Prism because it can't work with it to set a value.

For example I have ExportCollection with column A, B. and C

if I use the calculation for this collection to parse it to another collection with column A and B, I would do this:

[ExportCollection.A] store in [NewCollection.A] [ExportCollection.B.] store in [NewCollection.B]

now the last one will give me an error.

My solution was, maybe I can extract the data into my ExportCollection without headers but I don't know how to do this.

Can someone help me with this?

Answer 1

Try using GetWorksheetAsCollectionOffset Action in Excel VBO as it can be of use - because it has a 'Use Header' flag