public abstract class SheetHandler
extends org.xml.sax.helpers.DefaultHandler
限定符和类型 | 类和说明 |
---|---|
static class |
SheetHandler.CellValidation |
static class |
SheetHandler.ParsedRow |
构造器和说明 |
---|
SheetHandler() |
限定符和类型 | 方法和说明 |
---|---|
void |
characters(char[] ch,
int start,
int length)
通知一个元素中的字符,是否处理由自己决定,比如
|
void |
endDocument()
sheet解析结束
|
void |
endElement(java.lang.String uri,
java.lang.String localName,
java.lang.String name) |
int |
getRowCount() |
SheetHandler.ParsedRow |
getRowHolder() |
org.apache.poi.xssf.model.SharedStringsTable |
getSharedStringsTable() |
org.apache.poi.xssf.model.StylesTable |
getStylesTable() |
void |
handleDataValidation(java.util.Set<SheetHandler.CellValidation> dataValidations)
处理所有的数据有效性规则(暂时只处理下拉选项)
|
abstract void |
handleRow(SheetHandler.ParsedRow currentRow)
处理每行数据
|
boolean |
isInterrupt() |
boolean |
isNumberFormat() |
void |
setInterrupt(boolean interrupt) |
void |
setNumberFormat(boolean numberFormat) |
void |
setRowCount(int rowCount) |
void |
setRowHolder(SheetHandler.ParsedRow holder) |
void |
setSharedStringsTable(org.apache.poi.xssf.model.SharedStringsTable sst) |
void |
setStylesTable(org.apache.poi.xssf.model.StylesTable stylesTable) |
void |
startElement(java.lang.String uri,
java.lang.String localName,
java.lang.String name,
org.xml.sax.Attributes attributes) |
public void startElement(java.lang.String uri, java.lang.String localName, java.lang.String name, org.xml.sax.Attributes attributes) throws org.xml.sax.SAXException
startElement
在接口中 org.xml.sax.ContentHandler
startElement
在类中 org.xml.sax.helpers.DefaultHandler
org.xml.sax.SAXException
public void endElement(java.lang.String uri, java.lang.String localName, java.lang.String name) throws org.xml.sax.SAXException
endElement
在接口中 org.xml.sax.ContentHandler
endElement
在类中 org.xml.sax.helpers.DefaultHandler
org.xml.sax.SAXException
public abstract void handleRow(SheetHandler.ParsedRow currentRow)
currentRow2
- public void handleDataValidation(java.util.Set<SheetHandler.CellValidation> dataValidations)
dataValidations
- public void endDocument() throws org.xml.sax.SAXException
endDocument
在接口中 org.xml.sax.ContentHandler
endDocument
在类中 org.xml.sax.helpers.DefaultHandler
org.xml.sax.SAXException
public void characters(char[] ch, int start, int length) throws org.xml.sax.SAXException
characters
在接口中 org.xml.sax.ContentHandler
characters
在类中 org.xml.sax.helpers.DefaultHandler
ch
- The characters. 整个sheet.xml的char[]数组表示start
- The start position in the character array. 本次处理的元素值的的开始位置length
- The number of characters to use from the ,元素长度
character array.org.xml.sax.SAXException
- Any SAX exception, possibly
wrapping another exception.ContentHandler.characters(char[], int, int)
public boolean isInterrupt()
public void setInterrupt(boolean interrupt)
public void setSharedStringsTable(org.apache.poi.xssf.model.SharedStringsTable sst)
public org.apache.poi.xssf.model.StylesTable getStylesTable()
public void setStylesTable(org.apache.poi.xssf.model.StylesTable stylesTable)
public org.apache.poi.xssf.model.SharedStringsTable getSharedStringsTable()
public SheetHandler.ParsedRow getRowHolder()
public void setRowHolder(SheetHandler.ParsedRow holder)
public boolean isNumberFormat()
public void setNumberFormat(boolean numberFormat)
public int getRowCount()
public void setRowCount(int rowCount)