Skip to main content
how do you turn a range of data in excel and create a table? I do not want to use screen capture if I can help it.

Hi @dean mcghee​ ,

 

You can use the Excel Advanced: Select Rows/Columns/Cells Action toggled to Cell, pass in the required range and then use a Simulate Keystrokes: eCtrl Down]twCtrl Up] :

image 

Kind Regards,

Ashwin A.K

 


@dean mcghee​ :

 

if you are still facing an issue then please create a support case

 

How to create a support case :

https://apeople.automationanywhere.com/s/article/How-to-create-a-support-case-in-service-cloud

 

if you don't have access to the above link, email the AA Support team "apeopleopsteam@automationanywhere.com" to get access.


Hi @dean mcghee​ ,

 

You can use the Excel Advanced: Select Rows/Columns/Cells Action toggled to Cell, pass in the required range and then use a Simulate Keystrokes: eCtrl Down]twCtrl Up] :

image 

Kind Regards,

Ashwin A.K

 

If I want to filter the table that I created like this, it wont be able to find the table:

Any suggestions? 

 


Reply