br.com.tecsinapse.dataio.importer.parser

Class SpreadsheetParser<T>

java.lang.Object

br.com.tecsinapse.dataio.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, String filename)

Method Summary

Modifier and Type	Method and Description
void	close()
List<List<String>>	getLines()
int	getNumberOfSheets()
org.apache.poi.ss.usermodel.Workbook	getWorkbook()
List<T>	parse()
void	setFirstVisibleSheet()
void	setSheetNumberAsFirstNotHidden()

Methods inherited from class java.lang.Object

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

Methods inherited from interface br.com.tecsinapse.dataio.importer.Parser

getExporterFormatter, getFileType, getSheetNumber, isIgnoreBlankLinesAtEnd, setExporterFormatter, setGroup, setHeadersRows, setIgnoreBlankLinesAtEnd, setLastsheet, setSheetNumber

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)

Method Detail

setSheetNumberAsFirstNotHidden

public void setSheetNumberAsFirstNotHidden()

Specified by:

setSheetNumberAsFirstNotHidden in interface Parser<T>

setFirstVisibleSheet

public void setFirstVisibleSheet()

Specified by:

setFirstVisibleSheet 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()

Specified by:

getLines in interface Parser<T>

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