Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to open indvidual excel files from folder

Praveen_KumarKa
Level 3

‎28-12-18 11:58 PM

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.  
0 Likes
3 REPLIES 3

SukeshManthena
Level 4

‎31-12-18 02:58 PM

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

Praveen_KumarKa
Level 3

‎03-01-19 05:38 AM

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