How to open indvidual excel files from folder

[Praveen_KumarKa]

Hi All, I have a folder which contains individual excel files. I need to open one by one excel file and read the data from them to work queue. Please suggest me solution.   Appreciate all your help.  

[SukeshManthena]

Hello praveen, Use ""Utility-File Management"" VBO & Action as ""Get Files"". Provide Inputs for  Folder: Patterns CSV:""*.xlsx""(this will search for Excel files only), Outputs as collection. In this collection, all the excel filepaths will be stored (Use the first column i.e. Path) and then loop this collection file by file. Implement the logic in between the Loop for loading it to Work Queues. Good Luck. Regards, Sukesh.

[Praveen_KumarKa]

Hi Sukesh Thanks you for the valuable input. But when I given the inputs as provided it is showing files are empty in collection. Is there anything to provide in the collection such as fields etc.   

[vivek.kumar.goel]

http://rpatools.com/technical-queriesblue-prism-bp-how-to-open-individu…