Hi
@nkumarkolla,
I might have misinterpreted your question. By the wordings "in AAE" I assumed it to be column AAE of Excel, but I think you may want to know how to find the the total number of columns in an Excel sheet and below are the commands in Automation Anywhere.
-Open Worskheet: Either New or existing
-Activate sheet: Activate the required sheet
- Go to cell: A1
-Insert keystrokes - Control and Right arrow
Here there are two options:
i. If the sheet contains data in the first row: then you need to Insert these keystrokes twice so that it will take you to the last column (or can set it to maximum no. of times if you do not know how the 1st row is)
ii. If the sheet does not contain any data then only once.
-Set cell: 'Set Cell' to insert the formula as "
=Column()"
This will give the result as shown in the screenshot.
- Then you can either close the worksheet without saving Or just Set cell this cell back to blank so that the formula is removed.
This is Office 2010 so the last column number is 16384.