Notes

package Demo;

import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import org.openqa.selenium.chrome.ChromeDriver;
import org.openqa.selenium.interactions.Actions;
import org.apache.poi.ss.usermodel.FillPatternType;
import org.apache.poi.ss.usermodel.IndexedColors;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFCellStyle;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.List;

import io.github.bonigarcia.wdm.WebDriverManager;

public class FontTest {

public static void main(String[] args) throws IOException, InterruptedException {
// TODO Auto-generated method stub

//System.out.println("Hello World");
WebDriverManager.chromedriver().setup();
WebDriver driver = new ChromeDriver();
driver.manage().window().maximize();

driver.get("https://fonts.adobe.com/foundries");
driver.findElement(By.xpath("//button[@id='onetrust-reject-all-handler']")).click();
List<WebElement> element = driver.findElements(By.xpath("//p[@class='spectrum-Body--large foundry-landing-page-item--foundry-name ng-binding']"));
//System.out.println(tagname);
FileInputStream instreamSet= new FileInputStream(".\FontsData.xlsx");
XSSFWorkbook workbook = new XSSFWorkbook(instreamSet);
XSSFSheet sheet = workbook.getSheetAt(0);

System.out.println(element.size());
for(int i=0; i<1;i++) {
String foundryName= "";
foundryName= element.get(i).getText();
System.out.println(foundryName);
Thread.sleep(3000);
Actions actions = new Actions(driver);
actions.moveToElement(element.get(i)).click().build().perform();
//element.get(i).click();
Thread.sleep(3000);

WebElement element1= driver.findElement(By.xpath("//span[@class='adobe-fonts-family-card__family_name ng-binding']"));
String foundrySubName="";
foundrySubName= element1.getText();
//element1.click();
System.out.println(foundrySubName);
actions.moveToElement(element1).click().build().perform();

List<WebElement> element2= driver.findElements(By.xpath("//ul[@class='spectrum-grid-row spectrum-grid-start-xs list--no-decoration font-variation-list']/li/div/div/div/span"));
System.out.println("Element2 size"+ element2.size());
for(int l=0;l<element2.size();l++) {
String foundrySubItem="";
foundrySubItem= element2.get(l).getText();
System.out.println(foundrySubItem);
XSSFRow row= sheet.createRow(l+1);

XSSFCell cell= row.createCell(0);
cell.setCellValue((String) foundryName);

XSSFCell cell1= row.createCell(1);
cell1.setCellValue((String) foundrySubName);

XSSFCell cell2= row.createCell(2);
cell2.setCellValue((String) foundrySubItem);
}


}
instreamSet.close();
String filepath= ".\FontsData.xlsx";
FileOutputStream outstream= new FileOutputStream(filepath);
workbook.write(outstream);
outstream.close();
workbook.close();
System.out.println("=============Excel created=================");

driver.close();
}

}







<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>4.1.2</version>
</dependency>

<!-- Apache POI-OOXML Dependency -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>4.1.2</version>
</dependency>

<!-- Apache POI-OOXML SCHEMAS Dependency -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml-schemas</artifactId>
<version>4.1.2</version>
</dependency>

<!-- Apache OOXML SCHEMAS Dependency -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>ooxml-schemas</artifactId>
<version>1.4</version>
</dependency>

<!-- Apache XML Beans Dependency -->
<dependency>
<groupId>org.apache.xmlbeans</groupId>
<artifactId>xmlbeans</artifactId>
<version>3.1.0</version>
</dependency>