I am getting the few excel files on daily basis with the same names. After all my complete bot functionality i need to move the excel file on the basis of monthly and yearly folder with adding the date name in the prefix of file.
Eg: File Name: records.xlsx.
According to the current date i...
the vlookup is correct after one filter i am closing the excel and than again opening with the same handle than it works, its strange how it happens if you have any guide or study material related to read in depth of handle functionality please share it we great to get more in depth.
But i...
Currently i am using the different handles for both the workbooks for DeptWorkbook i am using handle name as handle and for another workbook name Project workbook i am using different handle as Project handle. And the workbook name stored in a data item which comes as an outpur from 'Open...
Hi sivagelli, i have already open the workbook of destination workbook by using the show workbook in the sub page of project calculation, And before copy paste i am able to see all the actions, but i used show workbook after the open workbook action.
I saw one below thread in which the...
I have requirement to filter the records on the basis of one criteria and after comparing both the sheets, paste the records into another sheet.
In both the excels the templates are same and there first three rows and last row are merge rows.
What i did: After perform all my bot functionality...
How can i get the total number of columns in the excel. Also i want to know the column range.
Eg: in my excel there are 125 columns and sometimes it comes more, i want know the total columns in excel also want to know the last column range.
in the snapshot i want to know the highlighted...
Thanks Sivagelli for complete and clear explanation and i hope it works for others too.
If we want to Unmerge the specific multiple rows in complete sheet in one complete action. How can we achieve.
Eg: in my excel there 5 merged cells from them i need to Unmerge only 2 cells and their ranges...
Sometimes It Will take around few hours or sometimes maximum 48 to synchronize your blueprism account on Pearson. If still you are not able to do, drop an email on Blueprism support you will get a response shortly.
I have an Excel file and i want to unmerge the top 3 rows and last 2 rows. Any customized action if some has or any other solution please share with me.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.