com.qmetry.qaf.automation.util

Class ExcelUtil

java.lang.Object

com.qmetry.qaf.automation.util.ExcelUtil

public class ExcelUtil
extends java.lang.Object

com.qmetry.qaf.automation.util.ExcelUtil.java

Author:

chirag

Constructor Summary

Constructors

Constructor and Description
ExcelUtil()

Method Summary

Modifier and Type	Method and Description
static java.lang.Object[][]	getExcelData(java.lang.String file, boolean headerRow)
static java.lang.Object[][]	getExcelData(java.lang.String file, boolean headerRow, java.lang.String sheetName)
static java.lang.Object[][]	getExcelDataAsMap(java.lang.String file, java.lang.String sheetName)
static java.lang.String[][]	getTableData(java.lang.String xlFilePath, java.lang.String tableName, java.lang.String sheetName)
static java.lang.Object[][]	getTableDataAsMap(java.lang.String xlFilePath, java.lang.String tableName, java.lang.String sheetName)

Methods inherited from class java.lang.Object

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

Constructor Detail

ExcelUtil

public ExcelUtil()

Method Detail

getExcelData

public static java.lang.Object[][] getExcelData(java.lang.String file,
                                                boolean headerRow,
                                                java.lang.String sheetName)

getExcelData

public static java.lang.Object[][] getExcelData(java.lang.String file,
                                                boolean headerRow)

Parameters:

file -

headerRow -

Returns:

getTableData

public static java.lang.String[][] getTableData(java.lang.String xlFilePath,
                                                java.lang.String tableName,
                                                java.lang.String sheetName)

getExcelDataAsMap

public static java.lang.Object[][] getExcelDataAsMap(java.lang.String file,
                                                     java.lang.String sheetName)

getTableDataAsMap

public static java.lang.Object[][] getTableDataAsMap(java.lang.String xlFilePath,
                                                     java.lang.String tableName,
                                                     java.lang.String sheetName)