How to sort excel sheet column wise?
Hi, I need to sort an excel sheet, column wise through C++ Script. I am not able to find anything regarding that on Test Complete help. Kindly help me with the same. I am c...
Forum Discussion
Well... I was able to sort a worksheet by recording a script and manually performing all the steps needed as one of my test scripts requires a sorted Excel spreadsheet.
However, this returns a code that uses absolute mouse position on the open Excel worksheet and running a test with a different sized Excel window causes the mouse position to be different.
But as I run this script with the Excel window maximized using the same monitor, it works.
Another Solution is to record a Macro of what is needed, then use:
excel.Run("MACRO_NAME")
to run the macro.
I haven't tried this method, yet. So I'm not sure just how well it'll work.
It's on my ToDo list
However, this returns a code that uses absolute mouse position on the open Excel worksheet and running a test with a different sized Excel window causes the mouse position to be different.
But as I run this script with the Excel window maximized using the same monitor, it works.
Another Solution is to record a Macro of what is needed, then use:
excel.Run("MACRO_NAME")
to run the macro.
I haven't tried this method, yet. So I'm not sure just how well it'll work.
It's on my ToDo list
