package dataDriven;

import java.io.FileInputStream;
import java.io.IOException;

import org.apache.poi.EncryptedDocumentException;
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.testng.annotations.Test;

public class Test4 {
	@Test
	public void tc1() throws EncryptedDocumentException, IOException {
		FileInputStream fis=new FileInputStream("./data.xlsx");
		Workbook wb = WorkbookFactory.create(fis);
		Sheet sh = wb.getSheet("Sheet1");
		int rownumb = sh.getLastRowNum();
		
		for(int i=1;i<rownumb;i++) {
			Row row = sh.getRow(i);
			String rowData = row.getCell(0).getStringCellValue();
			if(rowData.equals("2"))
			{
				short cellnum = row.getLastCellNum();
				for(int j=0;j<cellnum;j++) {
					String data = row.getCell(j).getStringCellValue();
					System.out.println(data);
				
				}
				break;
			}
			
			else
			{
				System.out.println("data not found");
			}
		}
		
	}}