mardi 17 septembre 2019

Read excel data in page object model

Using windows-7 and keep getting errors to write code to ready excel Trying to read excel data file in java maven Keep getting error on line#49 sheet= book.getSheet(sheetname); I have added all dependencies and imported but still can not clear this error.

package com.newTour.qa.util;

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

import org.apache.poi.hslf.model.Sheet;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;

import com.newTour.qa.Base.TestBase;


public class TestUtil extends TestBase {


public static String TESTDATA_SHEET_PATH = "C:\\Users\\shahgee\\newtour.qu\\src\\main\\java\\"
            + "com\\qa\\newtour\\testdata\\MercutyTourTestData.xlsx" ;

    static Workbook book;
    static Sheet sheet;



public static Object[][]getTestData(String sheetname){
    FileInputStream file = null;
    try {
        file = new FileInputStream(TESTDATA_SHEET_PATH);
    } catch (FileNotFoundException e) {
        e.printStackTrace();
    }

     try {
        book= WorkbookFactory.create(file);
    } catch (InvalidFormatException e) {
        e.printStackTrace();
    } catch (IOException e) {
        e.printStackTrace();
    }

     sheet = book.getSheet(sheetname);
     Object[][]data = new Object[sheet.getLastRowNum()][sheet.getRow(0).getLastCellNum()];

     for (int i =0; i <sheet.getLastRowNum();i++){

         for (int k =0;k <sheet.getRow(0).getLastCellNum(); k++){
             data[i][k]= sheet.getRow(i+1).getCell(k).toString();

         }
     }

     return data;

    }


}

Aucun commentaire:

Enregistrer un commentaire