br.com.tecsinapse.exporter.importer.parser

Class SpreadsheetParser<T>

java.lang.Object

br.com.tecsinapse.exporter.importer.parser.SpreadsheetParser<T>

All Implemented Interfaces:

Parser<T>, Closeable, AutoCloseable

public class SpreadsheetParser<T>
extends Object
implements Parser<T>

Constructor Summary

Constructors

Constructor and Description
SpreadsheetParser(Class<T> clazz, File file)
SpreadsheetParser(Class<T> clazz, InputStream inputStream, FileType fileType)
SpreadsheetParser(Class<T> clazz, InputStream inputStream, FileType fileType, int headersRows, boolean lastSheet)
SpreadsheetParser(Class<T> clazz, InputStream inputStream, FileType fileType, int headersRows, boolean lastSheet, ImporterXLSXType importerXLSXType) Deprecated.
SpreadsheetParser(Class<T> clazz, InputStream inputStream, String filename)

Method Summary

Modifier and Type	Method and Description
void	close()
ExporterFormatter	getExporterFormatter()
FileType	getFileType()
List<List<String>>	getLines()
int	getNumberOfSheets()
int	getSheetNumber()
org.apache.poi.ss.usermodel.Workbook	getWorkbook()
boolean	isIgnoreBlankLinesAtEnd()
boolean	isUseFormatterToParseValueAsString()
List<T>	parse()
void	setAfterLine(int headersRows) Deprecated. use setHeadersRows(int) }
void	setExporterFormatter(ExporterFormatter exporterFormatter)
void	setFirstVisibleSheet()
void	setGroup(Class<?> group)
void	setHeadersRows(int headersRows)
void	setIgnoreBlankLinesAtEnd(boolean ignoreBlankLinesAtEnd)
void	setLastsheet(boolean lastsheet)
void	setSheetNumber(int sheetNumber)
void	setSheetNumberAsFirstNotHidden()
void	setUseFormatterToParseValueAsString(boolean useFormatterToParseValueAsString)

Methods inherited from class java.lang.Object

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

Constructor Detail

SpreadsheetParser

public SpreadsheetParser(Class<T> clazz,
                         File file)
                  throws IOException

Throws:

IOException

SpreadsheetParser

public SpreadsheetParser(Class<T> clazz,
                         InputStream inputStream,
                         String filename)

SpreadsheetParser

public SpreadsheetParser(Class<T> clazz,
                         InputStream inputStream,
                         FileType fileType)

SpreadsheetParser

public SpreadsheetParser(Class<T> clazz,
                         InputStream inputStream,
                         FileType fileType,
                         int headersRows,
                         boolean lastSheet)

SpreadsheetParser

@Deprecated
public SpreadsheetParser(Class<T> clazz,
                                     InputStream inputStream,
                                     FileType fileType,
                                     int headersRows,
                                     boolean lastSheet,
                                     ImporterXLSXType importerXLSXType)

Deprecated.

For compatibility

Method Detail

isIgnoreBlankLinesAtEnd

public boolean isIgnoreBlankLinesAtEnd()

Specified by:

isIgnoreBlankLinesAtEnd in interface Parser<T>

setIgnoreBlankLinesAtEnd

public void setIgnoreBlankLinesAtEnd(boolean ignoreBlankLinesAtEnd)

Specified by:

setIgnoreBlankLinesAtEnd in interface Parser<T>

getExporterFormatter

public ExporterFormatter getExporterFormatter()

Specified by:

getExporterFormatter in interface Parser<T>

setExporterFormatter

public void setExporterFormatter(ExporterFormatter exporterFormatter)

Specified by:

setExporterFormatter in interface Parser<T>

setHeadersRows

public void setHeadersRows(int headersRows)

Specified by:

setHeadersRows in interface Parser<T>

setAfterLine

@Deprecated
public void setAfterLine(int headersRows)

Deprecated. use setHeadersRows(int) }

For compatibility

getSheetNumber

public int getSheetNumber()

Specified by:

getSheetNumber in interface Parser<T>

setSheetNumber

public void setSheetNumber(int sheetNumber)

Specified by:

setSheetNumber in interface Parser<T>

setSheetNumberAsFirstNotHidden

public void setSheetNumberAsFirstNotHidden()

Specified by:

setSheetNumberAsFirstNotHidden in interface Parser<T>

isUseFormatterToParseValueAsString

public boolean isUseFormatterToParseValueAsString()

setUseFormatterToParseValueAsString

public void setUseFormatterToParseValueAsString(boolean useFormatterToParseValueAsString)

setLastsheet

public void setLastsheet(boolean lastsheet)

Specified by:

setLastsheet in interface Parser<T>

setFirstVisibleSheet

public void setFirstVisibleSheet()

Specified by:

setFirstVisibleSheet in interface Parser<T>

setGroup

public void setGroup(Class<?> group)

Specified by:

setGroup in interface Parser<T>

getFileType

public FileType getFileType()

Specified by:

getFileType in interface Parser<T>

getNumberOfSheets

public int getNumberOfSheets()

Specified by:

getNumberOfSheets in interface Parser<T>

parse

public List<T> parse()
              throws Exception

Specified by:

parse in interface Parser<T>

Throws:

Exception

getLines

public List<List<String>> getLines()
                            throws Exception

Specified by:

getLines in interface Parser<T>

Throws:

Exception

getWorkbook

public org.apache.poi.ss.usermodel.Workbook getWorkbook()

close

public void close()
           throws IOException

Specified by:

close in interface Closeable

Specified by:

close in interface AutoCloseable

Throws:

IOException