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.ContentHandlerstartElement 在类中 org.xml.sax.helpers.DefaultHandlerorg.xml.sax.SAXExceptionpublic void endElement(java.lang.String uri,
java.lang.String localName,
java.lang.String name)
throws org.xml.sax.SAXException
endElement 在接口中 org.xml.sax.ContentHandlerendElement 在类中 org.xml.sax.helpers.DefaultHandlerorg.xml.sax.SAXExceptionpublic 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.ContentHandlerendDocument 在类中 org.xml.sax.helpers.DefaultHandlerorg.xml.sax.SAXExceptionpublic void characters(char[] ch,
int start,
int length)
throws org.xml.sax.SAXException
characters 在接口中 org.xml.sax.ContentHandlercharacters 在类中 org.xml.sax.helpers.DefaultHandlerch - 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)