Skip to main content
Cadet | Tier 2
April 30, 2022
Question

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.

  • April 30, 2022
  • 3 replies
  • 130 views
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.

    3 replies

    Ashwin A.K
    Navigator | Tier 3
    April 30, 2022

    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: [Ctrl Down]t[Ctrl Up] :

    image 

    Kind Regards,

    Ashwin A.K

     

    Blogs at TheCodingTheory - https://www.thecodingtheory.com
    Automation Anywhere Team
    October 10, 2022

    @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.

    Cadet | Tier 2
    January 4, 2023

    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: [Ctrl Down]t[Ctrl 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?