com.kulana.core.foundation.utils.parser

Class XLSParser

java.lang.Object

com.kulana.core.foundation.utils.parser.XLSParser

public class XLSParser
extends java.lang.Object

Parser of Excel files.

Author:

Alex Khursevich

Constructor Summary

Constructors

Constructor and Description
XLSParser()

Method Summary

Methods

Modifier and Type	Method and Description
static java.lang.String	getCellValue(org.apache.poi.ss.usermodel.Cell cell) Returns cell value.
static XLSTable	parseSpreadSheet(java.lang.String xls, java.lang.String sheetName) Parses full data sheet.
static XLSTable	parseSpreadSheet(java.lang.String xls, java.lang.String sheetName, java.lang.String executeColumn, java.lang.String executeValue)
static java.lang.String	parseValue(java.lang.String locatorKey, java.lang.String xlsPath, java.util.Locale locale) Parses localized value from XLS file.
static java.lang.String	parseValue(java.lang.String xls, java.lang.String sheetName, java.lang.String key) Parses XLS value from specified spreadsheet by key.

Methods inherited from class java.lang.Object

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

Constructor Detail

XLSParser

public XLSParser()

Method Detail

parseValue

public static java.lang.String parseValue(java.lang.String locatorKey,
                          java.lang.String xlsPath,
                          java.util.Locale locale)

Parses localized value from XLS file.

Parameters:

locatorKey - key of value to parse

xlsPath - path to XLS file

locale - localized value

Returns:

parsed value

parseValue

public static java.lang.String parseValue(java.lang.String xls,
                          java.lang.String sheetName,
                          java.lang.String key)

Parses XLS value from specified spreadsheet by key.

Parameters:

xls - file path

sheetName -

key -

Returns:

parsed value

parseSpreadSheet

public static XLSTable parseSpreadSheet(java.lang.String xls,
                        java.lang.String sheetName)

Parses full data sheet.

Parameters:

xls - path to file

sheetName - name of sheet to parse

Returns:

parsed data sheet

parseSpreadSheet

public static XLSTable parseSpreadSheet(java.lang.String xls,
                        java.lang.String sheetName,
                        java.lang.String executeColumn,
                        java.lang.String executeValue)

getCellValue

public static java.lang.String getCellValue(org.apache.poi.ss.usermodel.Cell cell)

Returns cell value.

Parameters:

cell -

Returns:

cell value