com.fr.data.impl.excelplus

类 Excel2007Util

java.lang.Object

com.fr.data.impl.excelplus.ExcelUtil

com.fr.data.impl.excelplus.Excel2007Util

public class Excel2007Util
extends ExcelUtil

Created by Young on 2015/7/3.

嵌套类概要

从类继承的嵌套类/接口 com.fr.data.impl.excelplus.ExcelUtil

ExcelUtil.COLUMN, ExcelUtil.ExcelFileLock

字段概要

字段

限定符和类型	字段和说明
boolean	isEmpty

从类继承的字段 com.fr.data.impl.excelplus.ExcelUtil

PREVIEW_COUNT

构造器概要

构造器

限定符	构造器和说明
	Excel2007Util(java.io.InputStream in, boolean preview)
	Excel2007Util(java.lang.String filePath, boolean preview)
protected	Excel2007Util(com.fr.third.v2.org.apache.poi.xssf.model.StylesTable styles, com.fr.third.v2.org.apache.poi.xssf.eventusermodel.ReadOnlySharedStringsTable strings, java.io.InputStream sheetInputStream)

方法概要

方法

限定符和类型	方法和说明
static java.util.List<Excel2007Util>	createMutiSheetExcel(java.io.InputStream in)
int	getColumnCount()
java.util.List<java.lang.Object[]>	getRowDataList()
void	mergeCell()
void	process()
void	processFirstSheet()
void	processFirstSheetFromBI()
void	processSheet(com.fr.third.v2.org.apache.poi.xssf.model.StylesTable styles, com.fr.third.v2.org.apache.poi.xssf.eventusermodel.ReadOnlySharedStringsTable strings, java.io.InputStream sheetInputStream)

从类继承的方法 com.fr.data.impl.excelplus.ExcelUtil

mergeCells, replaceSpecialCharOfNumber, supportDateFormat

从类继承的方法 java.lang.Object

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

字段详细资料

isEmpty

public boolean isEmpty

构造器详细资料

Excel2007Util

protected Excel2007Util(com.fr.third.v2.org.apache.poi.xssf.model.StylesTable styles,
             com.fr.third.v2.org.apache.poi.xssf.eventusermodel.ReadOnlySharedStringsTable strings,
             java.io.InputStream sheetInputStream)
                 throws java.io.IOException,
                        javax.xml.parsers.ParserConfigurationException,
                        org.xml.sax.SAXException

抛出:

java.io.IOException

javax.xml.parsers.ParserConfigurationException

org.xml.sax.SAXException

Excel2007Util

public Excel2007Util(java.lang.String filePath,
             boolean preview)
              throws java.lang.Exception

抛出:

java.lang.Exception

Excel2007Util

public Excel2007Util(java.io.InputStream in,
             boolean preview)
              throws java.lang.Exception

抛出:

java.lang.Exception

方法详细资料

createMutiSheetExcel

public static java.util.List<Excel2007Util> createMutiSheetExcel(java.io.InputStream in)
                                                          throws java.lang.Exception

抛出:

java.lang.Exception

getColumnCount

public int getColumnCount()

getRowDataList

public java.util.List<java.lang.Object[]> getRowDataList()

mergeCell

public void mergeCell()

processSheet

public void processSheet(com.fr.third.v2.org.apache.poi.xssf.model.StylesTable styles,
                com.fr.third.v2.org.apache.poi.xssf.eventusermodel.ReadOnlySharedStringsTable strings,
                java.io.InputStream sheetInputStream)
                  throws java.io.IOException,
                         javax.xml.parsers.ParserConfigurationException,
                         org.xml.sax.SAXException

抛出:

java.io.IOException

javax.xml.parsers.ParserConfigurationException

org.xml.sax.SAXException

processFirstSheet

public void processFirstSheet()
                       throws java.lang.Exception

抛出:

java.lang.Exception

processFirstSheetFromBI

public void processFirstSheetFromBI()
                             throws java.lang.Exception

抛出:

java.lang.Exception

process

public void process()
             throws java.io.IOException,
                    com.fr.third.v2.org.apache.poi.openxml4j.exceptions.OpenXML4JException,
                    javax.xml.parsers.ParserConfigurationException,
                    org.xml.sax.SAXException

抛出:

java.io.IOException

com.fr.third.v2.org.apache.poi.openxml4j.exceptions.OpenXML4JException

javax.xml.parsers.ParserConfigurationException

org.xml.sax.SAXException