StreamingWorkbook (Streaming Excel reader 2.3.5 API)

java.lang.Object
- com.github.greycode.xlsx.impl.StreamingWorkbook

所有已实现的接口:

Closeable, AutoCloseable, Iterable<org.apache.poi.ss.usermodel.Sheet>, org.apache.poi.ss.usermodel.Workbook
```
public class StreamingWorkbook
extends Object
implements org.apache.poi.ss.usermodel.Workbook, AutoCloseable
```

字段概要
- 从接口继承的字段 org.apache.poi.ss.usermodel.Workbook
  PICTURE_TYPE_DIB, PICTURE_TYPE_EMF, PICTURE_TYPE_JPEG, PICTURE_TYPE_PICT, PICTURE_TYPE_PNG, PICTURE_TYPE_WMF

构造器概要

构造器
构造器和说明

StreamingWorkbook(StreamingWorkbookReader reader)

构造器
构造器和说明
`StreamingWorkbook(StreamingWorkbookReader reader)`

方法概要

所有方法实例方法具体方法
限定符和类型	方法和说明
`int`	`addOlePackage(byte[] bytes, String s, String s1, String s2)` Not supported
`int`	`addPicture(byte[] pictureData, int format)` Not supported
`void`	`addToolPack(org.apache.poi.ss.formula.udf.UDFFinder toopack)` Not supported
`org.apache.poi.ss.usermodel.Sheet`	`cloneSheet(int sheetNum)` Not supported
`void`	`close()`
`org.apache.poi.ss.usermodel.CellStyle`	`createCellStyle()` Not supported
`org.apache.poi.ss.usermodel.DataFormat`	`createDataFormat()` Not supported
`org.apache.poi.ss.usermodel.Font`	`createFont()` Not supported
`org.apache.poi.ss.usermodel.Name`	`createName()` Not supported
`org.apache.poi.ss.usermodel.Sheet`	`createSheet()` Not supported
`org.apache.poi.ss.usermodel.Sheet`	`createSheet(String sheetname)` Not supported
`org.apache.poi.ss.usermodel.Font`	`findFont(boolean b, short i, short i1, String s, boolean b1, boolean b2, short i2, byte b3)` Not supported
`int`	`getActiveSheetIndex()` Not supported
`List<? extends org.apache.poi.ss.usermodel.Name>`	`getAllNames()` Not supported
`List<? extends org.apache.poi.ss.usermodel.PictureData>`	`getAllPictures()` Not supported
`org.apache.poi.ss.usermodel.CellStyle`	`getCellStyleAt(int i)` Not supported
`org.apache.poi.ooxml.POIXMLProperties.CoreProperties`	`getCoreProperties()` Returns the Core Properties if this feature is enabled on the `StreamingReader.Builder`
`org.apache.poi.ss.usermodel.CreationHelper`	`getCreationHelper()` Not supported
`int`	`getFirstVisibleTab()` Not supported
`org.apache.poi.ss.usermodel.Font`	`getFontAt(int i)` Not supported
`org.apache.poi.ss.usermodel.Font`	`getFontAt(short idx)` Not supported
`boolean`	`getForceFormulaRecalculation()` Not supported
`org.apache.poi.ss.usermodel.Row.MissingCellPolicy`	`getMissingCellPolicy()` Not supported
`org.apache.poi.ss.usermodel.Name`	`getName(String name)` Not supported
`org.apache.poi.ss.usermodel.Name`	`getNameAt(int nameIndex)` Not supported
`int`	`getNameIndex(String name)` Not supported
`List<? extends org.apache.poi.ss.usermodel.Name>`	`getNames(String s)` Not supported
`short`	`getNumberOfFonts()` Not supported
`int`	`getNumberOfFontsAsInt()` Not supported
`int`	`getNumberOfNames()` Not supported
`int`	`getNumberOfSheets()`
`int`	`getNumCellStyles()` Not supported
`String`	`getPrintArea(int sheetIndex)` Not supported
`org.apache.poi.ss.usermodel.Sheet`	`getSheet(String name)`
`org.apache.poi.ss.usermodel.Sheet`	`getSheetAt(int index)`
`int`	`getSheetIndex(org.apache.poi.ss.usermodel.Sheet sheet)`
`int`	`getSheetIndex(String name)`
`String`	`getSheetName(int sheet)`
`org.apache.poi.ss.usermodel.SheetVisibility`	`getSheetVisibility(int i)` Not supported
`org.apache.poi.ss.SpreadsheetVersion`	`getSpreadsheetVersion()`
`boolean`	`isHidden()` Not supported
`boolean`	`isSheetHidden(int sheetIx)`
`boolean`	`isSheetVeryHidden(int sheetIx)`
`Iterator<org.apache.poi.ss.usermodel.Sheet>`	`iterator()`
`int`	`linkExternalWorkbook(String name, org.apache.poi.ss.usermodel.Workbook workbook)` Not supported
`void`	`removeName(int index)` Not supported
`void`	`removeName(org.apache.poi.ss.usermodel.Name name)` Not supported
`void`	`removeName(String name)` Not supported
`void`	`removePrintArea(int sheetIndex)` Not supported
`void`	`removeSheetAt(int index)` Not supported
`void`	`setActiveSheet(int sheetIndex)` Not supported
`void`	`setFirstVisibleTab(int sheetIndex)` Not supported
`void`	`setForceFormulaRecalculation(boolean value)` Not supported
`void`	`setHidden(boolean hiddenFlag)` Not supported
`void`	`setMissingCellPolicy(org.apache.poi.ss.usermodel.Row.MissingCellPolicy missingCellPolicy)` Not supported
`void`	`setPrintArea(int sheetIndex, int startColumn, int endColumn, int startRow, int endRow)` Not supported
`void`	`setPrintArea(int sheetIndex, String reference)` Not supported
`void`	`setSelectedTab(int index)` Not supported
`void`	`setSheetHidden(int sheetIx, boolean hidden)` Not supported
`void`	`setSheetName(int sheet, String name)` Not supported
`void`	`setSheetOrder(String sheetname, int pos)` Not supported
`void`	`setSheetVisibility(int i, org.apache.poi.ss.usermodel.SheetVisibility sheetVisibility)` Not supported
`Iterator<org.apache.poi.ss.usermodel.Sheet>`	`sheetIterator()`
`void`	`write(OutputStream stream)` Not supported

从类继承的方法 java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

从接口继承的方法 java.lang.Iterable
forEach, spliterator

- 构造器详细资料
  - StreamingWorkbook
```
public StreamingWorkbook(StreamingWorkbookReader reader)
```
- 方法详细资料
  - iterator
```
public Iterator<org.apache.poi.ss.usermodel.Sheet> iterator()
```
    指定者:
    
    iterator 在接口中 Iterable<org.apache.poi.ss.usermodel.Sheet>
  - sheetIterator
```
public Iterator<org.apache.poi.ss.usermodel.Sheet> sheetIterator()
```
    指定者:
    
    sheetIterator 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getSheetName
```
public String getSheetName(int sheet)
```
    指定者:
    
    getSheetName 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getSheetIndex
```
public int getSheetIndex(String name)
```
    指定者:
    
    getSheetIndex 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getSheetIndex
```
public int getSheetIndex(org.apache.poi.ss.usermodel.Sheet sheet)
```
    指定者:
    
    getSheetIndex 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getNumberOfSheets
```
public int getNumberOfSheets()
```
    指定者:
    
    getNumberOfSheets 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getSheetAt
```
public org.apache.poi.ss.usermodel.Sheet getSheetAt(int index)
```
    指定者:
    
    getSheetAt 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getSheet
```
public org.apache.poi.ss.usermodel.Sheet getSheet(String name)
```
    指定者:
    
    getSheet 在接口中 org.apache.poi.ss.usermodel.Workbook
  - isSheetHidden
```
public boolean isSheetHidden(int sheetIx)
```
    指定者:
    
    isSheetHidden 在接口中 org.apache.poi.ss.usermodel.Workbook
  - isSheetVeryHidden
```
public boolean isSheetVeryHidden(int sheetIx)
```
    指定者:
    
    isSheetVeryHidden 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getSpreadsheetVersion
```
public org.apache.poi.ss.SpreadsheetVersion getSpreadsheetVersion()
```
    指定者:
    
    getSpreadsheetVersion 在接口中 org.apache.poi.ss.usermodel.Workbook
  - close
```
public void close()
           throws IOException
```
    指定者:
    
    close 在接口中 Closeable
    
    指定者:
    
    close 在接口中 AutoCloseable
    
    指定者:
    
    close 在接口中 org.apache.poi.ss.usermodel.Workbook
    
    抛出:
    
    IOException
  - getCoreProperties
```
public org.apache.poi.ooxml.POIXMLProperties.CoreProperties getCoreProperties()
```
    Returns the Core Properties if this feature is enabled on the StreamingReader.Builder
    
    返回:
    
    POIXMLProperties.CoreProperties
  - getActiveSheetIndex
```
public int getActiveSheetIndex()
```
    Not supported
    
    指定者:
    
    getActiveSheetIndex 在接口中 org.apache.poi.ss.usermodel.Workbook
  - setActiveSheet
```
public void setActiveSheet(int sheetIndex)
```
    Not supported
    
    指定者:
    
    setActiveSheet 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getFirstVisibleTab
```
public int getFirstVisibleTab()
```
    Not supported
    
    指定者:
    
    getFirstVisibleTab 在接口中 org.apache.poi.ss.usermodel.Workbook
  - setFirstVisibleTab
```
public void setFirstVisibleTab(int sheetIndex)
```
    Not supported
    
    指定者:
    
    setFirstVisibleTab 在接口中 org.apache.poi.ss.usermodel.Workbook
  - setSheetOrder
```
public void setSheetOrder(String sheetname,
                          int pos)
```
    Not supported
    
    指定者:
    
    setSheetOrder 在接口中 org.apache.poi.ss.usermodel.Workbook
  - setSelectedTab
```
public void setSelectedTab(int index)
```
    Not supported
    
    指定者:
    
    setSelectedTab 在接口中 org.apache.poi.ss.usermodel.Workbook
  - setSheetName
```
public void setSheetName(int sheet,
                         String name)
```
    Not supported
    
    指定者:
    
    setSheetName 在接口中 org.apache.poi.ss.usermodel.Workbook
  - createSheet
```
public org.apache.poi.ss.usermodel.Sheet createSheet()
```
    Not supported
    
    指定者:
    
    createSheet 在接口中 org.apache.poi.ss.usermodel.Workbook
  - createSheet
```
public org.apache.poi.ss.usermodel.Sheet createSheet(String sheetname)
```
    Not supported
    
    指定者:
    
    createSheet 在接口中 org.apache.poi.ss.usermodel.Workbook
  - cloneSheet
```
public org.apache.poi.ss.usermodel.Sheet cloneSheet(int sheetNum)
```
    Not supported
    
    指定者:
    
    cloneSheet 在接口中 org.apache.poi.ss.usermodel.Workbook
  - removeSheetAt
```
public void removeSheetAt(int index)
```
    Not supported
    
    指定者:
    
    removeSheetAt 在接口中 org.apache.poi.ss.usermodel.Workbook
  - createFont
```
public org.apache.poi.ss.usermodel.Font createFont()
```
    Not supported
    
    指定者:
    
    createFont 在接口中 org.apache.poi.ss.usermodel.Workbook
  - findFont
```
public org.apache.poi.ss.usermodel.Font findFont(boolean b,
                                                 short i,
                                                 short i1,
                                                 String s,
                                                 boolean b1,
                                                 boolean b2,
                                                 short i2,
                                                 byte b3)
```
    Not supported
    
    指定者:
    
    findFont 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getNumberOfFonts
```
public short getNumberOfFonts()
```
    Not supported
    
    指定者:
    
    getNumberOfFonts 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getNumberOfFontsAsInt
```
public int getNumberOfFontsAsInt()
```
    Not supported
    
    指定者:
    
    getNumberOfFontsAsInt 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getFontAt
```
public org.apache.poi.ss.usermodel.Font getFontAt(short idx)
```
    Not supported
    
    指定者:
    
    getFontAt 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getFontAt
```
public org.apache.poi.ss.usermodel.Font getFontAt(int i)
```
    Not supported
    
    指定者:
    
    getFontAt 在接口中 org.apache.poi.ss.usermodel.Workbook
  - createCellStyle
```
public org.apache.poi.ss.usermodel.CellStyle createCellStyle()
```
    Not supported
    
    指定者:
    
    createCellStyle 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getNumCellStyles
```
public int getNumCellStyles()
```
    Not supported
    
    指定者:
    
    getNumCellStyles 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getCellStyleAt
```
public org.apache.poi.ss.usermodel.CellStyle getCellStyleAt(int i)
```
    Not supported
    
    指定者:
    
    getCellStyleAt 在接口中 org.apache.poi.ss.usermodel.Workbook
  - write
```
public void write(OutputStream stream)
           throws IOException
```
    Not supported
    
    指定者:
    
    write 在接口中 org.apache.poi.ss.usermodel.Workbook
    
    抛出:
    
    IOException
  - getNumberOfNames
```
public int getNumberOfNames()
```
    Not supported
    
    指定者:
    
    getNumberOfNames 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getName
```
public org.apache.poi.ss.usermodel.Name getName(String name)
```
    Not supported
    
    指定者:
    
    getName 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getNames
```
public List<? extends org.apache.poi.ss.usermodel.Name> getNames(String s)
```
    Not supported
    
    指定者:
    
    getNames 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getAllNames
```
public List<? extends org.apache.poi.ss.usermodel.Name> getAllNames()
```
    Not supported
    
    指定者:
    
    getAllNames 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getNameAt
```
public org.apache.poi.ss.usermodel.Name getNameAt(int nameIndex)
```
    Not supported
    
    指定者:
    
    getNameAt 在接口中 org.apache.poi.ss.usermodel.Workbook
  - createName
```
public org.apache.poi.ss.usermodel.Name createName()
```
    Not supported
    
    指定者:
    
    createName 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getNameIndex
```
public int getNameIndex(String name)
```
    Not supported
    
    指定者:
    
    getNameIndex 在接口中 org.apache.poi.ss.usermodel.Workbook
  - removeName
```
public void removeName(int index)
```
    Not supported
    
    指定者:
    
    removeName 在接口中 org.apache.poi.ss.usermodel.Workbook
  - removeName
```
public void removeName(String name)
```
    Not supported
    
    指定者:
    
    removeName 在接口中 org.apache.poi.ss.usermodel.Workbook
  - removeName
```
public void removeName(org.apache.poi.ss.usermodel.Name name)
```
    Not supported
    
    指定者:
    
    removeName 在接口中 org.apache.poi.ss.usermodel.Workbook
  - linkExternalWorkbook
```
public int linkExternalWorkbook(String name,
                                org.apache.poi.ss.usermodel.Workbook workbook)
```
    Not supported
    
    指定者:
    
    linkExternalWorkbook 在接口中 org.apache.poi.ss.usermodel.Workbook
  - setPrintArea
```
public void setPrintArea(int sheetIndex,
                         String reference)
```
    Not supported
    
    指定者:
    
    setPrintArea 在接口中 org.apache.poi.ss.usermodel.Workbook
  - setPrintArea
```
public void setPrintArea(int sheetIndex,
                         int startColumn,
                         int endColumn,
                         int startRow,
                         int endRow)
```
    Not supported
    
    指定者:
    
    setPrintArea 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getPrintArea
```
public String getPrintArea(int sheetIndex)
```
    Not supported
    
    指定者:
    
    getPrintArea 在接口中 org.apache.poi.ss.usermodel.Workbook
  - removePrintArea
```
public void removePrintArea(int sheetIndex)
```
    Not supported
    
    指定者:
    
    removePrintArea 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getMissingCellPolicy
```
public org.apache.poi.ss.usermodel.Row.MissingCellPolicy getMissingCellPolicy()
```
    Not supported
    
    指定者:
    
    getMissingCellPolicy 在接口中 org.apache.poi.ss.usermodel.Workbook
  - setMissingCellPolicy
```
public void setMissingCellPolicy(org.apache.poi.ss.usermodel.Row.MissingCellPolicy missingCellPolicy)
```
    Not supported
    
    指定者:
    
    setMissingCellPolicy 在接口中 org.apache.poi.ss.usermodel.Workbook
  - createDataFormat
```
public org.apache.poi.ss.usermodel.DataFormat createDataFormat()
```
    Not supported
    
    指定者:
    
    createDataFormat 在接口中 org.apache.poi.ss.usermodel.Workbook
  - addPicture
```
public int addPicture(byte[] pictureData,
                      int format)
```
    Not supported
    
    指定者:
    
    addPicture 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getAllPictures
```
public List<? extends org.apache.poi.ss.usermodel.PictureData> getAllPictures()
```
    Not supported
    
    指定者:
    
    getAllPictures 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getCreationHelper
```
public org.apache.poi.ss.usermodel.CreationHelper getCreationHelper()
```
    Not supported
    
    指定者:
    
    getCreationHelper 在接口中 org.apache.poi.ss.usermodel.Workbook
  - isHidden
```
public boolean isHidden()
```
    Not supported
    
    指定者:
    
    isHidden 在接口中 org.apache.poi.ss.usermodel.Workbook
  - setHidden
```
public void setHidden(boolean hiddenFlag)
```
    Not supported
    
    指定者:
    
    setHidden 在接口中 org.apache.poi.ss.usermodel.Workbook
  - setSheetHidden
```
public void setSheetHidden(int sheetIx,
                           boolean hidden)
```
    Not supported
    
    指定者:
    
    setSheetHidden 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getSheetVisibility
```
public org.apache.poi.ss.usermodel.SheetVisibility getSheetVisibility(int i)
```
    Not supported
    
    指定者:
    
    getSheetVisibility 在接口中 org.apache.poi.ss.usermodel.Workbook
  - setSheetVisibility
```
public void setSheetVisibility(int i,
                               org.apache.poi.ss.usermodel.SheetVisibility sheetVisibility)
```
    Not supported
    
    指定者:
    
    setSheetVisibility 在接口中 org.apache.poi.ss.usermodel.Workbook
  - addToolPack
```
public void addToolPack(org.apache.poi.ss.formula.udf.UDFFinder toopack)
```
    Not supported
    
    指定者:
    
    addToolPack 在接口中 org.apache.poi.ss.usermodel.Workbook
  - setForceFormulaRecalculation
```
public void setForceFormulaRecalculation(boolean value)
```
    Not supported
    
    指定者:
    
    setForceFormulaRecalculation 在接口中 org.apache.poi.ss.usermodel.Workbook
  - getForceFormulaRecalculation
```
public boolean getForceFormulaRecalculation()
```
    Not supported
    
    指定者:
    
    getForceFormulaRecalculation 在接口中 org.apache.poi.ss.usermodel.Workbook
  - addOlePackage
```
public int addOlePackage(byte[] bytes,
                         String s,
                         String s1,
                         String s2)
                  throws IOException
```
    Not supported
    
    指定者:
    
    addOlePackage 在接口中 org.apache.poi.ss.usermodel.Workbook
    
    抛出:
    
    IOException

类 StreamingWorkbook

字段概要

从接口继承的字段 org.apache.poi.ss.usermodel.Workbook

构造器概要

方法概要

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

从接口继承的方法 java.lang.Iterable

构造器详细资料

StreamingWorkbook

方法详细资料

iterator

sheetIterator

getSheetName

getSheetIndex

getSheetIndex

getNumberOfSheets

getSheetAt

getSheet

isSheetHidden

isSheetVeryHidden

getSpreadsheetVersion

close

getCoreProperties

getActiveSheetIndex

setActiveSheet

getFirstVisibleTab

setFirstVisibleTab

setSheetOrder

setSelectedTab

setSheetName

createSheet

createSheet

cloneSheet

removeSheetAt

createFont

findFont

getNumberOfFonts

getNumberOfFontsAsInt

getFontAt

getFontAt

createCellStyle

getNumCellStyles

getCellStyleAt

write

getNumberOfNames

getName

getNames

getAllNames

getNameAt

createName

getNameIndex

removeName

removeName

removeName

linkExternalWorkbook

setPrintArea

setPrintArea

getPrintArea

removePrintArea

getMissingCellPolicy

setMissingCellPolicy

createDataFormat

addPicture

getAllPictures

getCreationHelper

isHidden

setHidden

setSheetHidden

getSheetVisibility

setSheetVisibility

addToolPack

setForceFormulaRecalculation

getForceFormulaRecalculation

addOlePackage