com.seleniumtests.util

Class SpreadSheetHelper

java.lang.Object

com.seleniumtests.util.SpreadSheetHelper

public class SpreadSheetHelper
extends Object

Constructor Summary

Constructors

Constructor and Description
SpreadSheetHelper()

Method Summary

Methods

Modifier and Type	Method and Description
protected static void	formatDPTags(Map<String,Object> rowDataMap)
static int	getArraySize(Map<String,Object> map, String key)
static Iterator<Object[]>	getDataFromSpreadsheet(Class<?> clazz, String filename, Filter filter, boolean readHeaders) Reads data from spreadsheet.
static Iterator<Object[]>	getDataFromSpreadsheet(Class<?> clazz, String filename, Filter filter, boolean readHeaders, boolean supportDPFilter) Reads data from spreadsheet.
protected static Filter	getDPFilter()
static Iterator<Object[]>	getEntitiesFromSpreadsheet(Class<?> clazz, LinkedHashMap<String,Class<?>> entityClazzMap, String filename, Filter filter) Create Entity Objects based on data in spreadsheet.
static Map<String,Object>	getFieldsDataNeedToBeSet(Map<String,Object> map, String key)
static Map<String,Object>	getFieldsNeedToBeSet(Map<String,Object> map, String key)
static Object	getValue(Map<String,Object> map, String key)
static Object	readObject(Class<?> clz, String objectName, Map<String,Object> dataMap)

Methods inherited from class java.lang.Object

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

Constructor Detail

SpreadSheetHelper

public SpreadSheetHelper()

Method Detail

formatDPTags

protected static void formatDPTags(Map<String,Object> rowDataMap)

getArraySize

public static int getArraySize(Map<String,Object> map,
               String key)

getDataFromSpreadsheet

public static Iterator<Object[]> getDataFromSpreadsheet(Class<?> clazz,
                                        String filename,
                                        Filter filter,
                                        boolean readHeaders)
                                                 throws Exception

Reads data from spreadsheet. If sheetName and sheetNumber both are supplied the sheetName takes precedence. Put the excel sheet in the same folder as the test case and specify clazz as this.getClass() .

Throws:

Exception

getDataFromSpreadsheet

public static Iterator<Object[]> getDataFromSpreadsheet(Class<?> clazz,
                                        String filename,
                                        Filter filter,
                                        boolean readHeaders,
                                        boolean supportDPFilter)
                                                 throws Exception

Reads data from spreadsheet. If sheetName and sheetNumber both are supplied the sheetName takes precedence. Put the excel sheet in the same folder as the test case and specify clazz as this.getClass() .

Parameters:

clazz -

filename -

filter -

readHeaders -

Returns:

Throws:

Exception

getDPFilter

protected static Filter getDPFilter()

getEntitiesFromSpreadsheet

public static Iterator<Object[]> getEntitiesFromSpreadsheet(Class<?> clazz,
                                            LinkedHashMap<String,Class<?>> entityClazzMap,
                                            String filename,
                                            Filter filter)
                                                     throws Exception

Create Entity Objects based on data in spreadsheet.

This method is only for Data Provider. Because it also filer the data based on the dpTagsInclude/dpTagsExclude which is defined in testng configuration file

Parameters:

clazz -

entityClazzMap -

filename -

filter -

Returns:

Throws:

Exception

getFieldsDataNeedToBeSet

public static Map<String,Object> getFieldsDataNeedToBeSet(Map<String,Object> map,
                                          String key)

getFieldsNeedToBeSet

public static Map<String,Object> getFieldsNeedToBeSet(Map<String,Object> map,
                                      String key)

getValue

public static Object getValue(Map<String,Object> map,
              String key)

readObject

public static Object readObject(Class<?> clz,
                String objectName,
                Map<String,Object> dataMap)
                         throws Exception

Throws:

Exception