Reframe work

how to read different excel one by one in folder and read the data using re framework. can you please help guys

1 Like

Using ReFramework, You can add all the paths of excels to the Transactions in the orchestrator and then iterating through the values @mahesha

Hi
Welcome to uipath community
–generally to read different excel one by one from a folder
we use a assign activity like this
arr_filepath = Directory.GetFiles(“yourfolderpath”,"*.xlsx")
where arr_filepath is a variable of type string array
–now we pass this array variable to a for each activity and change the type argument as string in the type argument property of for each activity
–inside the loop we use excel application scope and mention the file path input as item as it is the variable that holds the file path of each excel from for each loop activity

Now this can be done in REFramework at different STATES
like
–assign activity can be used Get Transaction Data state
–and for each loop activity can be used and the output from the above state with OUT argument can be used in PROCESS state where we can open excel with the file path that we get from each iteration between this Process state and above Get Transaction Data state
–once all the file path is accessed and data is obtained from excel and stored to a datatable variable it goes to END PROCESS state as there is not Transaction Data to be processed

Simple isn’t it
Hope this would help you
Cheers @mahesha

if you have any sample workflow regarding this please share me