'java.lang.IllegalStateException: The path to the driver executable must be set by the webdriver.chrome.driver system property-The Similiar doesn't ans

Trying to learn Selenium , I opened the similar question but nothing seemed to help. My code

package seleniumPractice;

import org.openqa.selenium.WebDriver;
import org.openqa.selenium.chrome.ChromeDriver;

public class seleniumPractice {
    public static void main(String[] args) {
        WebDriver driver = new ChromeDriver();

        driver.get("https://google.com");

        driver.quit();
    }
}

My Errors :-

Exception in thread "main" java.lang.IllegalStateException: The path to the driver executable The path to the driver executable must be set by the webdriver.chrome.driver system property; for more information, see https://github.com/SeleniumHQ/selenium/wiki/ChromeDriver. The latest version can be downloaded from https://chromedriver.storage.googleapis.com/index.html
    at org.openqa.selenium.internal.Require$StateChecker.nonNull(Require.java:311)
    at org.openqa.selenium.remote.service.DriverService.findExecutable(DriverService.java:135)
    at org.openqa.selenium.chrome.ChromeDriverService.access$000(ChromeDriverService.java:38)
    at org.openqa.selenium.chrome.ChromeDriverService$Builder.findDefaultExecutable(ChromeDriverService.java:231)
    at org.openqa.selenium.remote.service.DriverService$Builder.build(DriverService.java:437)
    at org.openqa.selenium.chrome.ChromeDriverService.createDefaultService(ChromeDriverService.java:127)
    at org.openqa.selenium.chrome.ChromeDriver.<init>(ChromeDriver.java:48)
    at seleniumPractice.seleniumPractice.main(seleniumPractice.java:8)
javaseleniumselenium-webdriverexcelexcel-formula


Solution 1:[1]

You could use COUNTIF function to count how many cells are fill with 'Available', 'Not Available' and based on that information build small (height=2) decision tree with IF function. Decision tree here (pseudocode) is:

-if count of 'Available' > 0 ?
    -if yes then if count of 'Not Available' > 0 ?
        -if yes -> 'Partly Available'
        -if no -> 'Available'
    -if no then if count of 'Not Available' > 0 ?
        -if yes -> 'Not Available'
        -if no -> 'No Data/Null'

Excel formula that are equivalent to that decision tree could be something like this:

=IF((COUNTIF(A1:Z1,"=Available"))>0,IF((COUNTIF(A1:Z1,"=Not Available"))>0,"Partly Available","Available"),IF((COUNTIF(A1:Z1,"=Not Available"))>0,"Not Available","No Data"))

but remember that A1:Z1 reffers to cells that are somwhere else, in diffrent sheets (SheetA!E11:SheetB!E11:SheetC!E11: ... :SheetZ!E11)

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1

Related Questions