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?

  • 10 April 2022
  • 1 reply
  • 23 views

Badge +7
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

Userlevel 4
Badge +8

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>

Reply