Package overit.geocall.util

Class XlsxBufferedReader

java.lang.Object

overit.geocall.util.XlsxBufferedReader

public class XlsxBufferedReader
extends Object

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

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static interface	XlsxBufferedReader.ExceptionHandler

Field Summary

Fields

Modifier and Type	Field	Description
protected int	_columns
protected int	_currLine
protected int	_rows
protected org.apache.poi.xssf.usermodel.XSSFSheet	_sheet
protected org.apache.poi.xssf.usermodel.XSSFWorkbook	_workbook
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
XlsxBufferedReader(InputStream is)	Creates an instance of XlsxBufferedReader from an InputStream

Method Summary

Modifier and Type	Method	Description
void	changeSheet(String sheetName)	Changes the sheet
void	close()	Closes the XSSFWorkbook
static final void	main(String[] args)
ArrayList	readCsvLine()	Reads the CVS line
ArrayList	readCsvLine(XlsxBufferedReader.ExceptionHandler handler)	Reads the CVS line
DBView	toDBView(int[] types, String[] formats, int headers, PrintStream ps)	Returns the DBView representation of the Xlsx

Methods inherited from class java.lang.Object

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

Field Details

_workbook

protected org.apache.poi.xssf.usermodel.XSSFWorkbook _workbook

_sheet

protected org.apache.poi.xssf.usermodel.XSSFSheet _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

XlsxBufferedReader

public XlsxBufferedReader(InputStream is)
                   throws IOException

Creates an instance of XlsxBufferedReader from an InputStream

Parameters:

is - The InputStream

Throws:

IOException - if the InputStream does not contain a XSSFWorkbook

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 XSSFWorkbook

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(XlsxBufferedReader.ExceptionHandler handler)

Reads the CVS line

Parameters:

handler - The XlsxBufferedReader.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 Xlsx

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 Xlsx

Throws:

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

main

public static final void main(String[] args)
                       throws Exception

Throws:

Exception