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...
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...
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.