com.canoo.webtest.plugins.exceltest
Class ExcelCellUtils

java.lang.Object
  com.canoo.webtest.plugins.exceltest.ExcelCellUtils

public class ExcelCellUtils
extends Object

Util class for looking up string values of various parts of an Excel spreadsheet.

Author:

Rob Nielsen

Field Summary

static int	SIX_POINT_TWO_FIVE_GRAY
static int	TWELVE_POINT_FIVE_GRAY

Constructor Summary

ExcelCellUtils()

Method Summary

static String	getAlignmentString(short alignment)
static String	getBorder(short border)
static String	getCellRef(int col, int row)
static org.apache.poi.hssf.util.CellReference	getCellReference(Step step, String cell)
static org.apache.poi.hssf.util.CellReference	getCellReference(Step step, String cell, String rowStr, String colStr)
static String	getCellValueAt(org.apache.poi.hssf.usermodel.HSSFCell cell)
static org.apache.poi.hssf.usermodel.HSSFCell	getExcelCellAt(AbstractExcelSheetStep step, int row, short col)
static String	getFillPattern(short fillPattern)
static String	getVerticalAlignmentString(short verticalAlignment)

Methods inherited from class java.lang.Object

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

Field Detail

TWELVE_POINT_FIVE_GRAY

public static final int TWELVE_POINT_FIVE_GRAY

See Also:

Constant Field Values

SIX_POINT_TWO_FIVE_GRAY

public static final int SIX_POINT_TWO_FIVE_GRAY

See Also:

Constant Field Values

Constructor Detail

ExcelCellUtils

public ExcelCellUtils()

Method Detail

getExcelCellAt

public static org.apache.poi.hssf.usermodel.HSSFCell getExcelCellAt(AbstractExcelSheetStep step,
                                                                    int row,
                                                                    short col)

getCellValueAt

public static String getCellValueAt(org.apache.poi.hssf.usermodel.HSSFCell cell)

getCellReference

public static org.apache.poi.hssf.util.CellReference getCellReference(Step step,
                                                                      String cell,
                                                                      String rowStr,
                                                                      String colStr)

getCellReference

public static org.apache.poi.hssf.util.CellReference getCellReference(Step step,
                                                                      String cell)

getAlignmentString

public static String getAlignmentString(short alignment)

getVerticalAlignmentString

public static String getVerticalAlignmentString(short verticalAlignment)

getFillPattern

public static String getFillPattern(short fillPattern)

getBorder

public static String getBorder(short border)

getCellRef

public static String getCellRef(int col,
                                int row)