Package overit.geocall.util

Class XLSBufferedReader

java.lang.Object

overit.geocall.util.XLSBufferedReader

public class XLSBufferedReader
extends Object

This class is an utility implementation that must be used if you want to read the contents of a XLS from an InputStream

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static interface	XLSBufferedReader.ExceptionHandler

Field Summary

Fields

Modifier and Type	Field	Description
protected int	_columns
protected int	_currLine
protected int	_rows
protected org.apache.poi.hssf.usermodel.HSSFSheet	_sheet
protected org.apache.poi.hssf.usermodel.HSSFWorkbook	_workbook
protected static final HashMap<String,SimpleDateFormat>	CONVERT_FORMATS
static final int	HEADERS
static final int	MAXCOLS
static final int	MAXROWS
static final int	NOHEADERS
static final int	SKIPHEADERS
static final int	TYPE_DATE
static final int	TYPE_FLOAT
static final int	TYPE_INTEGER
static final int	TYPE_STRING

Constructor Summary

Constructors

Constructor	Description
XLSBufferedReader(InputStream is)	Creates an instance of XLSBufferedReader from an InputStream
XLSBufferedReader(InputStream is, String sheetname)	Creates an instance of XLSBufferedReader from an InputStream and a name of the sheet

Method Summary

Modifier and Type	Method	Description
void	changeSheet(String sheetName)	Changes the sheet
void	close()	Closes the HSSFWorkbook
ArrayList	readCsvLine()	Reads the CVS line
ArrayList	readCsvLine(XLSBufferedReader.ExceptionHandler handler)	Reads the CVS line
DBView	toDBView(int[] types, String[] formats, int headers, PrintStream ps)	Returns the DBView representation of the XLS

Methods inherited from class java.lang.Object

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

Field Details

CONVERT_FORMATS

protected static final HashMap<String,SimpleDateFormat> CONVERT_FORMATS

_workbook

protected org.apache.poi.hssf.usermodel.HSSFWorkbook _workbook

_sheet

protected org.apache.poi.hssf.usermodel.HSSFSheet _sheet

_columns

protected int _columns

_rows

protected int _rows

_currLine

protected int _currLine

HEADERS

public static final int HEADERS

See Also:

• Constant Field Values

NOHEADERS

public static final int NOHEADERS

See Also:

• Constant Field Values

SKIPHEADERS

public static final int SKIPHEADERS

See Also:

• Constant Field Values

MAXROWS

public static final int MAXROWS

MAXCOLS

public static final int MAXCOLS

TYPE_STRING

public static final int TYPE_STRING

See Also:

• Constant Field Values

TYPE_DATE

public static final int TYPE_DATE

See Also:

• Constant Field Values

TYPE_INTEGER

public static final int TYPE_INTEGER

See Also:

• Constant Field Values

TYPE_FLOAT

public static final int TYPE_FLOAT

See Also:

• Constant Field Values

Constructor Details

XLSBufferedReader

public XLSBufferedReader(InputStream is)
                  throws IOException

Creates an instance of XLSBufferedReader from an InputStream

Parameters:

is - The InputStream

Throws:

IOException - if the InputStream does not contain a HSSFWorkbook

XLSBufferedReader

public XLSBufferedReader(InputStream is,
 String sheetname)
                  throws IOException

Creates an instance of XLSBufferedReader from an InputStream and a name of the sheet

Parameters:

is - The InputStream

sheetname - The name of the sheet

Throws:

IOException - if the InputStream does not contain a HSSFWorkbook

Method Details

changeSheet

public void changeSheet(String sheetName)

Changes the sheet

Parameters:

sheetName - The name of the sheet to change

close

public void close()
           throws IOException

Closes the HSSFWorkbook

Throws:

IOException - if an I/O error occurs

readCsvLine

public ArrayList readCsvLine()

Reads the CVS line

Returns:

An ArrayList containing the CVS line

readCsvLine

public ArrayList readCsvLine(XLSBufferedReader.ExceptionHandler handler)

Reads the CVS line

Parameters:

handler - The XLSBufferedReader.ExceptionHandler

Returns:

An ArrayList containing the CVS line

toDBView

public DBView toDBView(int[] types,
 String[] formats,
 int headers,
 PrintStream ps)
                throws DAValidateException

Returns the DBView representation of the XLS

Parameters:

types - The array of types, the lenght and the number of columns must be equals

formats - The array of formats

headers - The headers

ps - The PrintStream

Returns:

The DBView representation of the XLS

Throws:

DAValidateException - if the number of columns is not compatible, or the number of rows or columns excede the max number