com.platform.utils.excel

Class Excel2007Reader

java.lang.Object

org.xml.sax.helpers.DefaultHandler

com.platform.utils.excel.Excel2007Reader

All Implemented Interfaces:

ContentHandler, DTDHandler, EntityResolver, ErrorHandler

public class Excel2007Reader
extends DefaultHandler

Excel2007解析器

Author:

lipengjun

Constructor Summary

Constructors

Constructor and Description
Excel2007Reader()

Method Summary

Modifier and Type	Method and Description
void	characters(char[] ch, int start, int length) 添加字符
void	endElement(String uri, String localName, String name) Receive notification of the end of an element.
short	getFormatIndex() 取得formatIndex的值
String	getFormatString() 取得formatString的值
org.apache.poi.ss.usermodel.DataFormatter	getFormatter() 取得formatter的值
int	getLastColumnNumber() 取得lastColumnNumber的值
int	getMinColumnCount() 取得minColumnCount的值
XssfDataType	getNextDataType() 取得nextDataType的值
List<String>	getRowlist() 取得rowlist的值
org.apache.poi.xssf.eventusermodel.ReadOnlySharedStringsTable	getSharedStringsTable() 取得sharedStringsTable的值
Map<Integer,List<String[]>>	getSheetData() 获取数据(多Sheet)
List<String[]>	getSheetData(Integer sheetIndex) 获取数据(单Sheet)
int	getSheetIndex() 取得sheetIndex的值
org.apache.poi.xssf.model.StylesTable	getStylesTable() 取得stylesTable的值
int	getThisColumn() 取得thisColumn的值
StringBuffer	getValue() 取得value的值
Map<Integer,List<String[]>>	getWorkData() 取得workData的值
boolean	isvIsOpen() 取得vIsOpen的值
void	process(InputStream fileStream, boolean isMuti) 解析多Sheet内容 异常处理暂时不完整
void	setFormatIndex(short formatIndex) 设定formatIndex的值
void	setFormatString(String formatString) 设定formatString的值
void	setFormatter(org.apache.poi.ss.usermodel.DataFormatter formatter) 设定formatter的值
void	setLastColumnNumber(int lastColumnNumber) 设定lastColumnNumber的值
void	setNextDataType(XssfDataType nextDataType) 设定nextDataType的值
void	setRowlist(List<String> rowlist) 设定rowlist的值
void	setSharedStringsTable(org.apache.poi.xssf.eventusermodel.ReadOnlySharedStringsTable sharedStringsTable) 设定sharedStringsTable的值
void	setSheetData(List<String[]> sheetData) 设定sheetData的值
void	setSheetIndex(int sheetIndex) 设定sheetIndex的值
void	setStylesTable(org.apache.poi.xssf.model.StylesTable stylesTable) 设定stylesTable的值
void	setThisColumn(int thisColumn) 设定thisColumn的值
void	setValue(StringBuffer value) 设定value的值
void	setvIsOpen(boolean vIsOpen) 设定vIsOpen的值
void	setWorkData(Map<Integer,List<String[]>> workData) 设定workData的值
void	startElement(String uri, String localName, String name, Attributes attributes) Receive notification of the start of an element.

Methods inherited from class org.xml.sax.helpers.DefaultHandler

endDocument, endPrefixMapping, error, fatalError, ignorableWhitespace, notationDecl, processingInstruction, resolveEntity, setDocumentLocator, skippedEntity, startDocument, startPrefixMapping, unparsedEntityDecl, warning

Methods inherited from class java.lang.Object

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

Constructor Detail

Excel2007Reader

public Excel2007Reader()

Method Detail

process

public void process(InputStream fileStream,
                    boolean isMuti)

解析多Sheet内容 异常处理暂时不完整

Parameters:

fileStream - 文件流

isMuti - 是否多个sheet

startElement

public void startElement(String uri,
                         String localName,
                         String name,
                         Attributes attributes)
                  throws SAXException

Receive notification of the start of an element.

By default, do nothing. Application writers may override this method in a subclass to take specific actions at the start of each element (such as allocating a new tree node or writing output to a file).

Specified by:

startElement in interface ContentHandler

Overrides:

startElement in class DefaultHandler

Parameters:

uri - The Namespace URI, or the empty string if the element has no Namespace URI or if Namespace processing is not being performed.

localName - The local name (without prefix), or the empty string if Namespace processing is not being performed.

name - The qualified name (with prefix), or the empty string if qualified names are not available.

attributes - The attributes attached to the element. If there are no attributes, it shall be an empty Attributes object.

Throws:

SAXException - Any SAX exception, possibly wrapping another exception.

See Also:

ContentHandler.startElement(java.lang.String, java.lang.String, java.lang.String, org.xml.sax.Attributes)

endElement

public void endElement(String uri,
                       String localName,
                       String name)
                throws SAXException

Receive notification of the end of an element.

By default, do nothing. Application writers may override this method in a subclass to take specific actions at the end of each element (such as finalising a tree node or writing output to a file).

Specified by:

endElement in interface ContentHandler

Overrides:

endElement in class DefaultHandler

Parameters:

uri - The Namespace URI, or the empty string if the element has no Namespace URI or if Namespace processing is not being performed.

localName - The local name (without prefix), or the empty string if Namespace processing is not being performed.

name - The qualified name (with prefix), or the empty string if qualified names are not available.

Throws:

SAXException - Any SAX exception, possibly wrapping another exception.

See Also:

ContentHandler.endElement(java.lang.String, java.lang.String, java.lang.String)

characters

public void characters(char[] ch,
                       int start,
                       int length)
                throws SAXException

添加字符

Specified by:

characters in interface ContentHandler

Overrides:

characters in class DefaultHandler

Parameters:

ch - char[] 添加字符串

start - 开始位置

length - 长度

Throws:

SAXException - SAX异常

getSheetData

public List<String[]> getSheetData(Integer sheetIndex)

获取数据(单Sheet)

Parameters:

sheetIndex - sheet下标

Returns:

List

getSheetData

public Map<Integer,List<String[]>> getSheetData()

获取数据(多Sheet)

Returns:

Map> 对应列的Map

getSharedStringsTable

public org.apache.poi.xssf.eventusermodel.ReadOnlySharedStringsTable getSharedStringsTable()

取得sharedStringsTable的值

Returns:

sharedStringsTable值.

setSharedStringsTable

public void setSharedStringsTable(org.apache.poi.xssf.eventusermodel.ReadOnlySharedStringsTable sharedStringsTable)

设定sharedStringsTable的值

Parameters:

sharedStringsTable - 设定值

isvIsOpen

public boolean isvIsOpen()

取得vIsOpen的值

Returns:

vIsOpen值.

setvIsOpen

public void setvIsOpen(boolean vIsOpen)

设定vIsOpen的值

Parameters:

vIsOpen - 设定值

getNextDataType

public XssfDataType getNextDataType()

取得nextDataType的值

Returns:

nextDataType值.

setNextDataType

public void setNextDataType(XssfDataType nextDataType)

设定nextDataType的值

Parameters:

nextDataType - 设定值

getThisColumn

public int getThisColumn()

取得thisColumn的值

Returns:

thisColumn值.

setThisColumn

public void setThisColumn(int thisColumn)

设定thisColumn的值

Parameters:

thisColumn - 设定值

getLastColumnNumber

public int getLastColumnNumber()

取得lastColumnNumber的值

Returns:

lastColumnNumber值.

setLastColumnNumber

public void setLastColumnNumber(int lastColumnNumber)

设定lastColumnNumber的值

Parameters:

lastColumnNumber - 设定值

getValue

public StringBuffer getValue()

取得value的值

Returns:

value值.

setValue

public void setValue(StringBuffer value)

设定value的值

Parameters:

value - 设定值

getRowlist

public List<String> getRowlist()

取得rowlist的值

Returns:

rowlist值.

setRowlist

public void setRowlist(List<String> rowlist)

设定rowlist的值

Parameters:

rowlist - 设定值

getSheetIndex

public int getSheetIndex()

取得sheetIndex的值

Returns:

sheetIndex值.

setSheetIndex

public void setSheetIndex(int sheetIndex)

设定sheetIndex的值

Parameters:

sheetIndex - 设定值

getWorkData

public Map<Integer,List<String[]>> getWorkData()

取得workData的值

Returns:

workData值.

setWorkData

public void setWorkData(Map<Integer,List<String[]>> workData)

设定workData的值

Parameters:

workData - 设定值

getFormatter

public org.apache.poi.ss.usermodel.DataFormatter getFormatter()

取得formatter的值

Returns:

formatter值.

setFormatter

public void setFormatter(org.apache.poi.ss.usermodel.DataFormatter formatter)

设定formatter的值

Parameters:

formatter - 设定值

getFormatIndex

public short getFormatIndex()

取得formatIndex的值

Returns:

formatIndex值.

setFormatIndex

public void setFormatIndex(short formatIndex)

设定formatIndex的值

Parameters:

formatIndex - 设定值

getFormatString

public String getFormatString()

取得formatString的值

Returns:

formatString值.

setFormatString

public void setFormatString(String formatString)

设定formatString的值

Parameters:

formatString - 设定值

getStylesTable

public org.apache.poi.xssf.model.StylesTable getStylesTable()

取得stylesTable的值

Returns:

stylesTable值.

setStylesTable

public void setStylesTable(org.apache.poi.xssf.model.StylesTable stylesTable)

设定stylesTable的值

Parameters:

stylesTable - 设定值

getMinColumnCount

public int getMinColumnCount()

取得minColumnCount的值

Returns:

minColumnCount值.

setSheetData

public void setSheetData(List<String[]> sheetData)

设定sheetData的值

Parameters:

sheetData - 设定值