hie
i have a scenario where i have a workbook with multiple sheet and all sheet names are not same and every time the workbook comes the names wont be same but still i have to append all these sheets in one particular main sheet … how do i do this
one more scenario is i m accessing a web page and it can take any time to load be it 10s or 20s … in this situation what logic should i give ?
in append range also how it will read the sheet name as its dynamic … what logic should i give there
In classic excel activities you have a activity called Get Workbook Sheets which will return all the sheets available in a list
Use for each and iterate through the list and add the data as required
Regards
Sudharsan
This should solve the problem.
you can use for each sheet that would help
else if you have only one sheet then always can read current sheet without giving name
for page load better use a check app state and wait and also have wait for load option as well
cheers
hai …
can you send me scenario based question asked in interviews?
i have one more scenario
i have 4 5 bots using the same queqe data at the same time … then what logic should i give so that all bots run parallely
If you need to use the same excel file from all bots then you need to implement locking mechanism where only one bot would be accessing the file and others would be waiting for the current bot to complete task and next would acquire
cheers
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
