org.imaginea.test.automation.framework.util.readers

Class ExcelReader

java.lang.Object

org.imaginea.test.automation.framework.util.readers.ExcelReader

public class ExcelReader
extends Object

Utility to read Excel files. This file makes use of apache poi for reading excel files. It supports both "xls" and "xlsx" file extension.

Author:

Varun Menon

Field Summary

Fields

Modifier and Type	Field and Description
static int	noOfSheet

Constructor Summary

Constructors

Constructor and Description
ExcelReader()
ExcelReader(File file) Creates a ExcelReader object based on File object passed
ExcelReader(File file, int sheetNo)
ExcelReader(File file, String sheetName)
ExcelReader(String filePath) Creates a ExcelReader object based on filePath
ExcelReader(String filePath, int sheetNo)
ExcelReader(String filePath, String sheetName)

Method Summary

Methods

Modifier and Type	Method and Description
String	getData(int row, int column) Gets the data from the currently opened sheet based on row and column number
int	getNoOfColumn() Gets the no.
int	getNoOfColumn(int rowNo) Gets the no.
int	getNoOfRows() Gets the no.
org.apache.poi.ss.usermodel.Workbook	getOpenWorkbook()
Map<String,List<String>>	getStoredData()
void	openFile(File file, int sheetNo)
void	openFile(File file, String sheetName)
void	openFile(String filePath, int sheetNo)
void	openFile(String filePath, String sheetName)
void	openSheet(int sheetNo)
void	openSheet(String sheetName)
void	storeData() Stores the whole data of the currently opened sheet in a Map containing keys

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

noOfSheet

public static int noOfSheet

Constructor Detail

ExcelReader

public ExcelReader(String filePath)
            throws FileNotFoundException,
                   IOException

Creates a ExcelReader object based on filePath

Parameters:

filePath - File path of the file to be opened

Throws:

FileNotFoundException

IOException

ExcelReader

public ExcelReader(File file)
            throws IOException,
                   FileNotFoundException

Creates a ExcelReader object based on File object passed

Parameters:

file - File object of the file to be opened.

Throws:

IOException

FileNotFoundException

ExcelReader

public ExcelReader(String filePath,
           int sheetNo)
            throws IOException,
                   FileNotFoundException

Parameters:

filePath -

sheetNo -

Throws:

IOException

FileNotFoundException

ExcelReader

public ExcelReader(String filePath,
           String sheetName)
            throws IOException,
                   FileNotFoundException

Parameters:

filePath -

sheetName -

Throws:

IOException

FileNotFoundException

ExcelReader

public ExcelReader(File file,
           int sheetNo)
            throws IOException,
                   FileNotFoundException

Parameters:

file -

sheetNo -

Throws:

IOException

FileNotFoundException

ExcelReader

public ExcelReader(File file,
           String sheetName)
            throws IOException,
                   FileNotFoundException

Parameters:

file -

sheetName -

Throws:

IOException

FileNotFoundException

ExcelReader

public ExcelReader()

Method Detail

openFile

public void openFile(File file,
            int sheetNo)
              throws IOException,
                     FileNotFoundException

Parameters:

file -

sheetNo -

Throws:

IOException

FileNotFoundException

openFile

public void openFile(String filePath,
            int sheetNo)
              throws FileNotFoundException,
                     IOException

Parameters:

filePath -

sheetNo -

Throws:

FileNotFoundException

IOException

openFile

public void openFile(File file,
            String sheetName)
              throws FileNotFoundException,
                     IOException

Throws:

FileNotFoundException

IOException

openFile

public void openFile(String filePath,
            String sheetName)
              throws FileNotFoundException,
                     IOException

Throws:

FileNotFoundException

IOException

openSheet

public void openSheet(int sheetNo)

openSheet

public void openSheet(String sheetName)

getOpenWorkbook

public org.apache.poi.ss.usermodel.Workbook getOpenWorkbook()

getData

public String getData(int row,
             int column)

Gets the data from the currently opened sheet based on row and column number

Parameters:

row - Row no. from which the value has to be fetched

column - Respective column no. in the row from which the value has to be fetched

Returns:

The data present in the respective row & column. If no value is found it returns and empty String.

getNoOfRows

public int getNoOfRows()

Gets the no. of rows in the currently opened sheet

Returns:

The actual no of physical rows present

getNoOfColumn

public int getNoOfColumn()

Gets the no. of column present in the first row of the currently opened sheet.

Returns:

Return the no. of column present in the first row of the currently opened sheet.

getNoOfColumn

public int getNoOfColumn(int rowNo)

Gets the no. of column present in the specified row of the currently opened sheet.

Parameters:

rowNo - Row no. for which the no. of column have to evaluated.

Returns:

Return the no. of column present in the specified row of the currently opened sheet.

storeData

public void storeData()

Stores the whole data of the currently opened sheet in a Map containing keys

getStoredData

public Map<String,List<String>> getStoredData()