topic Hi Sukesh Thanks you for the… in Product Forum

How to open indvidual excel files from folder

Praveen_KumarKa — Fri, 28 Dec 2018 23:58:00 GMT

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.

Hello praveen, Use ""Utility…

SukeshManthena — Mon, 31 Dec 2018 14:58:00 GMT

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.

Hi Sukesh Thanks you for the…

Praveen_KumarKa — Thu, 03 Jan 2019 05:38:00 GMT

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.

http://rpatools.com…

vivek.kumar.goel — Thu, 03 Jan 2019 11:10:00 GMT

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