| || |
Manipulating Excel Cells using TSL
Can anyone tell how to manipulate Excel workbook cells using TSL.
When I tried to record the operations done in Excel workbook...it is displaying like the one below.
set_window ("Microsoft Excel - Book7", 8);
obj_mouse_click ("Book3", 214, 101, LEFT);
obj_mouse_click ("Book3", 218, 98, RIGHT);
win_mouse_click ("Custom Popup 5", 21, 10);
set_window ("Microsoft Excel - Book3", 18);
obj_mouse_click ("Worksheet Menu Bar", 34, 12, LEFT);
Here in the above code, "obj_mouse_click" represents the cells manipulation. But I wish to control the above stuff programmatically.
The available commands like
do not solve my purpose as I wish to do following operations in a cell.
*Click on the specified cell in a sheet.
*Right click on the specified cell in a sheet etc.
Can anyone help me out!!!
Thanks a lot
Re: Manipulating Excel Cells using TSL
My advice would be to use the automation tools built in to Excel e.g (macros).... but that probably isn't the answer you are looking for.