How to check if the rows are merged in an excel? If it is, the bot should move ahead to update the succeeding column cell.
This is just an idea.
You will need to have Excel open like with an Excel Scope. So that may make some things less ideal like needing to navigate the spreadsheet with keystrokes.
Once you get to each cell you check for if Merge button is active. I’m not sure if there is part of the selector that tells you that, but you could use Image Exists.
It might be slow doing that though.
Hope you find a good answer.
This can hlep you to merge and un merge cells.
Kindly let me know the solution to read the merged cell data in the excel as like source excel. It will be helpful to us.