br.com.tecsinapse.exporter.importer

Class ExcelParser<T>

java.lang.Object

br.com.tecsinapse.exporter.importer.ExcelParser<T>

All Implemented Interfaces:

Parser<T>, Closeable, AutoCloseable

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

Constructor Summary

Constructors

Constructor and Description
ExcelParser(Class<T> clazz, File file)
ExcelParser(Class<T> clazz, File file, int afterLine)
ExcelParser(Class<T> clazz, File file, int afterLine, boolean lastSheet, ImporterXLSXType importerXLSXType)
ExcelParser(Class<T> clazz, File file, int afterLine, boolean lastSheet, ImporterXLSXType importerXLSXType, Class<?> group)
ExcelParser(Class<T> clazz, InputStream inputStream, ExcelType type)
ExcelParser(Class<T> clazz, InputStream inputStream, ExcelType type, Class<?> group)
ExcelParser(Class<T> clazz, InputStream inputStream, ExcelType type, int afterLine)
ExcelParser(Class<T> clazz, InputStream inputStream, ExcelType type, int afterLine, boolean isLastSheet, ImporterXLSXType importerXLSXType)
ExcelParser(Class<T> clazz, InputStream inputStream, ExcelType type, int afterLine, boolean isLastSheet, ImporterXLSXType importerXLSXType, Class<?> group)
ExcelParser(Class<T> clazz, InputStream inputStream, ExcelType type, int afterLine, Class<?> group)

Method Summary

Methods

Modifier and Type	Method and Description
void	close()
String	getDateStringPattern()
List<List<String>>	getLines()
int	getNumberOfSheets() Quantidade de sheets na planilha Para csv sempre retorna 1, apenas para centralizar processamento pelo Importer idependente do arquivo
org.apache.poi.openxml4j.opc.OPCPackage	getOPCPackage() Deprecated.
int	getSheetNumber()
org.apache.poi.ss.usermodel.Workbook	getWorkbook()
List<List<String>>	getXlsLines() Deprecated.
List<List<String>>	getXlsxLines() Deprecated. Use getLines() mais afterLine 0 nao deveria importar se e xls ou xlsx
List<T>	parse() Não lê a primeira linha
protected Table	processXlsxSheet(org.apache.poi.xssf.model.StylesTable styles, org.apache.poi.xssf.eventusermodel.ReadOnlySharedStringsTable strings, InputStream sheetInputStream, boolean ignoreFirstRow)
protected Table	processXlsxSheet(org.apache.poi.xssf.model.StylesTable styles, org.apache.poi.xssf.eventusermodel.ReadOnlySharedStringsTable strings, InputStream sheetInputStream, int rowInitial)
void	setAfterLine(int afterLine)
void	setDateAsLocalDateTime(boolean dateAsLocalDateTime)
void	setDateStringPattern(String dateStringPattern)
void	setDateTimeStringPattern(String dateTimeStringPattern)
void	setSheetNumber(int sheetNumber)
void	setSheetNumberAsFirstNotHidden()

Methods inherited from class java.lang.Object

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

Constructor Detail

ExcelParser

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

Throws:

IOException

ExcelParser

public ExcelParser(Class<T> clazz,
           File file,
           int afterLine)
            throws IOException

Throws:

IOException

ExcelParser

public ExcelParser(Class<T> clazz,
           File file,
           int afterLine,
           boolean lastSheet,
           ImporterXLSXType importerXLSXType)
            throws IOException

Throws:

IOException

ExcelParser

public ExcelParser(Class<T> clazz,
           File file,
           int afterLine,
           boolean lastSheet,
           ImporterXLSXType importerXLSXType,
           Class<?> group)
            throws IOException

Throws:

IOException

ExcelParser

public ExcelParser(Class<T> clazz,
           InputStream inputStream,
           ExcelType type)

ExcelParser

public ExcelParser(Class<T> clazz,
           InputStream inputStream,
           ExcelType type,
           Class<?> group)

ExcelParser

public ExcelParser(Class<T> clazz,
           InputStream inputStream,
           ExcelType type,
           int afterLine)

ExcelParser

public ExcelParser(Class<T> clazz,
           InputStream inputStream,
           ExcelType type,
           int afterLine,
           Class<?> group)

ExcelParser

public ExcelParser(Class<T> clazz,
           InputStream inputStream,
           ExcelType type,
           int afterLine,
           boolean isLastSheet,
           ImporterXLSXType importerXLSXType)

ExcelParser

public ExcelParser(Class<T> clazz,
           InputStream inputStream,
           ExcelType type,
           int afterLine,
           boolean isLastSheet,
           ImporterXLSXType importerXLSXType,
           Class<?> group)

Method Detail

getDateStringPattern

public String getDateStringPattern()

setDateStringPattern

public void setDateStringPattern(String dateStringPattern)

Specified by:

setDateStringPattern in interface Parser<T>

setDateTimeStringPattern

public void setDateTimeStringPattern(String dateTimeStringPattern)

Specified by:

setDateTimeStringPattern in interface Parser<T>

setAfterLine

public void setAfterLine(int afterLine)

setSheetNumber

public void setSheetNumber(int sheetNumber)

getSheetNumber

public int getSheetNumber()

setSheetNumberAsFirstNotHidden

public void setSheetNumberAsFirstNotHidden()

getNumberOfSheets

public int getNumberOfSheets()

Description copied from interface: Parser

Quantidade de sheets na planilha Para csv sempre retorna 1, apenas para centralizar processamento pelo Importer idependente do arquivo

Specified by:

getNumberOfSheets in interface Parser<T>

Returns:

quantidade de sheets

parse

public List<T> parse()
              throws Exception

Não lê a primeira linha

Specified by:

parse in interface Parser<T>

Returns:

Throws:

Exception

getLines

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

Throws:

Exception

getXlsLines

@Deprecated
public List<List<String>> getXlsLines()
                               throws org.apache.poi.openxml4j.exceptions.InvalidFormatException,
                                      IOException

Deprecated.

Throws:

org.apache.poi.openxml4j.exceptions.InvalidFormatException

IOException

getWorkbook

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

getOPCPackage

@Deprecated
public org.apache.poi.openxml4j.opc.OPCPackage getOPCPackage()

Deprecated.

getXlsxLines

@Deprecated
public List<List<String>> getXlsxLines()
                                throws Exception

Deprecated. Use getLines() mais afterLine 0 nao deveria importar se e xls ou xlsx

Throws:

Exception

processXlsxSheet

protected Table processXlsxSheet(org.apache.poi.xssf.model.StylesTable styles,
                     org.apache.poi.xssf.eventusermodel.ReadOnlySharedStringsTable strings,
                     InputStream sheetInputStream,
                     boolean ignoreFirstRow)
                          throws Exception

Throws:

Exception

processXlsxSheet

protected Table processXlsxSheet(org.apache.poi.xssf.model.StylesTable styles,
                     org.apache.poi.xssf.eventusermodel.ReadOnlySharedStringsTable strings,
                     InputStream sheetInputStream,
                     int rowInitial)
                          throws Exception

Throws:

Exception

close

public void close()
           throws IOException

Specified by:

close in interface Closeable

Specified by:

close in interface AutoCloseable

Throws:

IOException

setDateAsLocalDateTime

public void setDateAsLocalDateTime(boolean dateAsLocalDateTime)

Specified by:

setDateAsLocalDateTime in interface Parser<T>