I have 10 excel files in sharepoint, I need to open each file & refresh it & then close it, But every file should be only refreshed once in a day, how can i automate this? Can i do this with using queue?
@gajanan_patil1 @ashokkarale @Anil_G @Vinit_Kawle @ruchirmahajan
Try
Add 10 Excel file names to an Orchestrator Queue using Add Queue Item.
Enable Unique Reference to avoid duplicates.
Use Get Transaction Item to fetch one file from the queue.
Download the Excel file from SharePoint using UiPath Microsoft 365 activities.
Open the file using Excel Application Scope.
Use Refresh All activity to refresh the data.
Save and close the file.
Use Set Transaction Status to mark the queue item as Successful.
Schedule the process in Orchestrator to run once per day.
1 Like
yes. Queue would be the best option
Prerequisiste- One queue with unique queue reference
Split the process into 2.
Dispatcher for adding items to Queue - You can add 10 queue items keeping reference as Filename_Date and one of the property as File Path. Run one time per day only. Even if it runs next time - it will throw error as we have set unique queue reference
Performer for refresh - Get items from Queue. Refresh excel one by one. Mark the status as successful
You would be able to manage this through scheduling. Schedule this once in a day.
Store these files to check in an input file or in config and pick it one by one by modifying REFramework to have transactionItem of type string.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.