Skip to main content
Navigator | Tier 3
April 10, 2022
Question

Hello, everyone I need to use Excel as DB and do the filtration by using Where condition. The condition is I need to retrieve data from excel where the column A not Equal Null. How can i do that?

  • April 10, 2022
  • 1 reply
  • 138 views
Hello, everyone I need to use Excel as DB and do the filtration by using Where condition. The condition is I need to retrieve data from excel where the column A not Equal Null. How can i do that?

    1 reply

    Automation Anywhere Team
    June 11, 2022

    Hello @Noura Almutair​ 

     

    Thanks for writing us at the AA forum.

     

    Request to check the connection string to create excel as a database

     

    https://www.connectionstrings.com/excel//p>

     

    You can use the same connection string than in the Database command to use and read excel as a database

     

    For assistance through our Support Engineers, please reach us via Support case

     

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

     

    You can also check our Live Chat support option, for quick assistance from our engineers

     

    https://apeople.automationanywhere.com/s/article/Live-Chat-Support-FAQs/p>

     

    You can also search for available documentation in

     

    https://docs.automationanywhere.com//p>

     

    For more details, you are welcome to leverage our open source portal where multiple use case is available

     

    https://botstore.automationanywhere.com//p>