excel import

Hi, I have been using the OLEDB VBO in Blue Prism for a few weeks, and have it successfully pulling information from one set of sheets that have a .xlsx format using the connection string: "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="&[File Path]&";Extended Properties=""Excel...

Hello, As we all know Transpose collection in Utility Collection Manipulation VBO - Changes the horizontal cells to Vertical I was wondering is there any way to transpose collection from vertical cells to horizontal. Thanks in Advance! Himavanth

My requirement is to read the Excel file headers directly from the excel file and save it to a collection. Then i need to verify the values of headers. So how shall i read only the header values from the excel?

Thats the message what i get if i am starting my process. I attached also a screenshot. Internal : Could not execute code stage because exception thrown by code stage: Exception has been thrown by the target of an invocation. Please help me out by that problem! Thank you very much.

When i try to import the contents of an excel in to a collection, I get the below error. Internal : Could not execute code stage because exception thrown by code stage: A column named 'XXX' already belongs to this DataTable. I was able to do the import successfully for the first time (where it...