package dataDriven;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.FileOutputStream;

import java.io.IOException;

import org.apache.poi.EncryptedDocumentException;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.Row;

import org.apache.poi.ss.usermodel.Sheet;

import org.apache.poi.ss.usermodel.Workbook;

import org.apache.poi.ss.usermodel.WorkbookFactory;

import org.openqa.selenium.WebDriver;

import org.openqa.selenium.chrome.ChromeDriver;

import io.github.bonigarcia.wdm.WebDriverManager;

public class Test5 {

public FileInputStream fis;

public static Workbook wb;

public static Sheet sh;

public static Row row;

public static Cell cell;

public WebDriver driver;

public static FileOutputStream fos;

public String readDatafromExcel() throws EncryptedDocumentException, IOException {

fis = new FileInputStream("./data.xlsx");

wb = WorkbookFactory.create(fis);

sh = wb.getSheet("Sheet1");

row = sh.getRow(1);

cell = row.getCell(4);

return cell.getStringCellValue();

}

public String getDataFromApplication() {

WebDriverManager.chromedriver().setup();

driver=new ChromeDriver();

driver.manage().window().maximize();

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

return driver.getTitle();

}

public static void writeDataToExcel(int rownum,int cellnum,String data) throws IOException {

row=sh.getRow(rownum);

cell=row.getCell(cellnum);

cell.setCellValue(data);

fos=new FileOutputStream("./data.xlsx");

wb.write(fos);

}

}