Logic for pushing data to Queue

PushStockDataToQueue.xaml (7.2 KB)

Hi im trying to create a queue in orchestrator tp push data i have in folder containing multiple files.

I have folder a folder with 7 excel files, how can i write a logic that incorporates all the files?

Many thanks

That depends on what you’re considering as a queue item. Is it the path to the Excel file? A value in a cell from an Excel file?

its a path to an excel file but i have 7 files

Use a For Each loop, and iterate over System.IO.Directory.GetFiles(Path), where Path is the directory where the Excel files are kept. Then you can load the path to the file in the loop using a string.

1 Like