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

how to delete 2 column (M:N) from excel sheet in BOT AA 360? Please find attached snap.

  • April 30, 2022
  • 4 replies
  • 167 views

Should i use "Excel advanced: Insert/Delete rows/columns' action or other and how ?

    4 replies

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

    Hi @Rohan Bane​ ,

     

    Could you try passing in M:N and see if that works out for you?

    image 

    Kind Regards,

    Ashwin A.K

    Blogs at TheCodingTheory - https://www.thecodingtheory.com
    RB65Author
    Cadet | Tier 2
    April 30, 2022

    Hello Ashwin, Thanks for the reply but when i used "M:N" , header title also goes delete but i want to keep header title (Quote , Reference column) .

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

    Hi @Adrian Sazon​ ,

     

    Could you try toggling it over to Cell and pass in M:2:N999 followed by a Simulate Keystroke: [Delete]?

     

    image 

    Kind Regards,

    Ashwin A.K

    Blogs at TheCodingTheory - https://www.thecodingtheory.com
    RB65Author
    Cadet | Tier 2
    May 4, 2022

    It's resolved Thanks Ashwin.