Package com.storedobject.office.od.ods

Class Workbook

java.lang.Object

com.storedobject.office.od.ods.Workbook

All Implemented Interfaces:

Closeable, AutoCloseable, Iterable<org.apache.poi.ss.usermodel.Sheet>, org.apache.poi.ss.usermodel.Workbook

public class Workbook
extends Object
implements org.apache.poi.ss.usermodel.Workbook

Field Summary

Fields inherited from interface org.apache.poi.ss.usermodel.Workbook

MAX_SENSITIVE_SHEET_NAME_LEN, PICTURE_TYPE_DIB, PICTURE_TYPE_EMF, PICTURE_TYPE_JPEG, PICTURE_TYPE_PICT, PICTURE_TYPE_PNG, PICTURE_TYPE_WMF

Constructor Summary

Constructors

Constructor	Description
Workbook()
Workbook(InputStream in)

Method Summary

Modifier and Type	Method	Description
int	addOlePackage(byte[] bytes, String s, String s1, String s2)
int	addPicture(byte[] bytes, int i)
void	addToolPack(org.apache.poi.ss.formula.udf.UDFFinder udfFinder)
org.apache.poi.ss.usermodel.Sheet	cloneSheet(int index)
void	close()
org.apache.poi.ss.usermodel.CellStyle	createCellStyle()
org.apache.poi.ss.usermodel.DataFormat	createDataFormat()
org.apache.poi.ss.formula.EvaluationWorkbook	createEvaluationWorkbook()
org.apache.poi.ss.usermodel.Font	createFont()
org.apache.poi.ss.usermodel.Name	createName()
org.apache.poi.ss.usermodel.Sheet	createSheet()
org.apache.poi.ss.usermodel.Sheet	createSheet(String name)
org.apache.poi.ss.usermodel.Font	findFont(boolean b, short i, short i1, String s, boolean b1, boolean b2, short i2, byte b3)
int	getActiveSheetIndex()
List<? extends org.apache.poi.ss.usermodel.Name>	getAllNames()
List<? extends org.apache.poi.ss.usermodel.PictureData>	getAllPictures()
org.apache.poi.ss.usermodel.CellReferenceType	getCellReferenceType()
org.apache.poi.ss.usermodel.CellStyle	getCellStyleAt(int index)
org.apache.poi.ss.usermodel.CreationHelper	getCreationHelper()
int	getFirstVisibleTab()
org.apache.poi.ss.usermodel.Font	getFontAt(int index)
boolean	getForceFormulaRecalculation()
org.apache.poi.ss.usermodel.Row.MissingCellPolicy	getMissingCellPolicy()
org.apache.poi.ss.usermodel.Name	getName(String s)
List<? extends org.apache.poi.ss.usermodel.Name>	getNames(String s)
int	getNumberOfFonts()
int	getNumberOfFontsAsInt()
int	getNumberOfNames()
int	getNumberOfSheets()
int	getNumCellStyles()
final PDFProperties	getPDFProperties()
String	getPrintArea(int i)
org.apache.poi.ss.usermodel.Sheet	getSheet(String name)
org.apache.poi.ss.usermodel.Sheet	getSheetAt(int index)
int	getSheetIndex(String name)
int	getSheetIndex(org.apache.poi.ss.usermodel.Sheet sheet)
String	getSheetName(int index)
org.apache.poi.ss.usermodel.SheetVisibility	getSheetVisibility(int index)
org.apache.poi.ss.SpreadsheetVersion	getSpreadsheetVersion()
boolean	isHidden()
boolean	isSheetHidden(int i)
boolean	isSheetVeryHidden(int i)
Iterator<org.apache.poi.ss.usermodel.Sheet>	iterator()
int	linkExternalWorkbook(String s, org.apache.poi.ss.usermodel.Workbook workbook)
void	reload()
void	removeName(org.apache.poi.ss.usermodel.Name name)
void	removePrintArea(int i)
void	removeSheetAt(int index)
void	setActiveSheet(int i)
void	setCellReferenceType(org.apache.poi.ss.usermodel.CellReferenceType cellReferenceType)
void	setFirstVisibleTab(int i)
void	setForceFormulaRecalculation(boolean b)
void	setHidden(boolean b)
void	setMissingCellPolicy(org.apache.poi.ss.usermodel.Row.MissingCellPolicy missingCellPolicy)
final void	setPDFProperties(PDFProperties pdfProperties)
void	setPrintArea(int i, int i1, int i2, int i3, int i4)
void	setPrintArea(int index, String area)
void	setSelectedTab(int i)
void	setSheetHidden(int i, boolean b)
void	setSheetName(int i, String s)
void	setSheetOrder(String s, int i)
void	setSheetVisibility(int index, org.apache.poi.ss.usermodel.SheetVisibility sheetVisibility)
Iterator<org.apache.poi.ss.usermodel.Sheet>	sheetIterator()
void	write(OutputStream out)

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.lang.Iterable

forEach

Methods inherited from interface org.apache.poi.ss.usermodel.Workbook

spliterator

Constructor Details

Workbook

public Workbook()
         throws Exception

Throws:

Exception

Workbook

public Workbook(InputStream in)
         throws Exception

Throws:

Exception

Method Details

setPDFProperties

public final void setPDFProperties(PDFProperties pdfProperties)

getPDFProperties

public final PDFProperties getPDFProperties()

getSheet

public org.apache.poi.ss.usermodel.Sheet getSheet(String name)

Specified by:

getSheet in interface org.apache.poi.ss.usermodel.Workbook

getSheetAt

public org.apache.poi.ss.usermodel.Sheet getSheetAt(int index)

Specified by:

getSheetAt in interface org.apache.poi.ss.usermodel.Workbook

removeSheetAt

public void removeSheetAt(int index)

Specified by:

removeSheetAt in interface org.apache.poi.ss.usermodel.Workbook

createFont

public org.apache.poi.ss.usermodel.Font createFont()

Specified by:

createFont in interface 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)

Specified by:

findFont in interface org.apache.poi.ss.usermodel.Workbook

getNumberOfFonts

public int getNumberOfFonts()

Specified by:

getNumberOfFonts in interface org.apache.poi.ss.usermodel.Workbook

getNumberOfFontsAsInt

public int getNumberOfFontsAsInt()

Specified by:

getNumberOfFontsAsInt in interface org.apache.poi.ss.usermodel.Workbook

getFontAt

public org.apache.poi.ss.usermodel.Font getFontAt(int index)

Specified by:

getFontAt in interface org.apache.poi.ss.usermodel.Workbook

createCellStyle

public org.apache.poi.ss.usermodel.CellStyle createCellStyle()

Specified by:

createCellStyle in interface org.apache.poi.ss.usermodel.Workbook

getNumCellStyles

public int getNumCellStyles()

Specified by:

getNumCellStyles in interface org.apache.poi.ss.usermodel.Workbook

getCellStyleAt

public org.apache.poi.ss.usermodel.CellStyle getCellStyleAt(int index)

Specified by:

getCellStyleAt in interface org.apache.poi.ss.usermodel.Workbook

close

public void close()

Specified by:

close in interface AutoCloseable

Specified by:

close in interface Closeable

Specified by:

close in interface org.apache.poi.ss.usermodel.Workbook

getNumberOfNames

public int getNumberOfNames()

Specified by:

getNumberOfNames in interface org.apache.poi.ss.usermodel.Workbook

getName

public org.apache.poi.ss.usermodel.Name getName(String s)

Specified by:

getName in interface org.apache.poi.ss.usermodel.Workbook

getNames

public List<? extends org.apache.poi.ss.usermodel.Name> getNames(String s)

Specified by:

getNames in interface org.apache.poi.ss.usermodel.Workbook

getAllNames

public List<? extends org.apache.poi.ss.usermodel.Name> getAllNames()

Specified by:

getAllNames in interface org.apache.poi.ss.usermodel.Workbook

createName

public org.apache.poi.ss.usermodel.Name createName()

Specified by:

createName in interface org.apache.poi.ss.usermodel.Workbook

removeName

public void removeName(org.apache.poi.ss.usermodel.Name name)

Specified by:

removeName in interface org.apache.poi.ss.usermodel.Workbook

linkExternalWorkbook

public int linkExternalWorkbook(String s,
 org.apache.poi.ss.usermodel.Workbook workbook)

Specified by:

linkExternalWorkbook in interface org.apache.poi.ss.usermodel.Workbook

setPrintArea

public void setPrintArea(int index,
 String area)

Specified by:

setPrintArea in interface org.apache.poi.ss.usermodel.Workbook

setPrintArea

public void setPrintArea(int i,
 int i1,
 int i2,
 int i3,
 int i4)

Specified by:

setPrintArea in interface org.apache.poi.ss.usermodel.Workbook

getPrintArea

public String getPrintArea(int i)

Specified by:

getPrintArea in interface org.apache.poi.ss.usermodel.Workbook

removePrintArea

public void removePrintArea(int i)

Specified by:

removePrintArea in interface org.apache.poi.ss.usermodel.Workbook

getMissingCellPolicy

public org.apache.poi.ss.usermodel.Row.MissingCellPolicy getMissingCellPolicy()

Specified by:

getMissingCellPolicy in interface org.apache.poi.ss.usermodel.Workbook

setMissingCellPolicy

public void setMissingCellPolicy(org.apache.poi.ss.usermodel.Row.MissingCellPolicy missingCellPolicy)

Specified by:

setMissingCellPolicy in interface org.apache.poi.ss.usermodel.Workbook

createDataFormat

public org.apache.poi.ss.usermodel.DataFormat createDataFormat()

Specified by:

createDataFormat in interface org.apache.poi.ss.usermodel.Workbook

addPicture

public int addPicture(byte[] bytes,
 int i)

Specified by:

addPicture in interface org.apache.poi.ss.usermodel.Workbook

getAllPictures

public List<? extends org.apache.poi.ss.usermodel.PictureData> getAllPictures()

Specified by:

getAllPictures in interface org.apache.poi.ss.usermodel.Workbook

getCreationHelper

public org.apache.poi.ss.usermodel.CreationHelper getCreationHelper()

Specified by:

getCreationHelper in interface org.apache.poi.ss.usermodel.Workbook

isHidden

public boolean isHidden()

Specified by:

isHidden in interface org.apache.poi.ss.usermodel.Workbook

setHidden

public void setHidden(boolean b)

Specified by:

setHidden in interface org.apache.poi.ss.usermodel.Workbook

isSheetHidden

public boolean isSheetHidden(int i)

Specified by:

isSheetHidden in interface org.apache.poi.ss.usermodel.Workbook

isSheetVeryHidden

public boolean isSheetVeryHidden(int i)

Specified by:

isSheetVeryHidden in interface org.apache.poi.ss.usermodel.Workbook

setSheetHidden

public void setSheetHidden(int i,
 boolean b)

Specified by:

setSheetHidden in interface org.apache.poi.ss.usermodel.Workbook

getSheetVisibility

public org.apache.poi.ss.usermodel.SheetVisibility getSheetVisibility(int index)

Specified by:

getSheetVisibility in interface org.apache.poi.ss.usermodel.Workbook

setSheetVisibility

public void setSheetVisibility(int index,
 org.apache.poi.ss.usermodel.SheetVisibility sheetVisibility)

Specified by:

setSheetVisibility in interface org.apache.poi.ss.usermodel.Workbook

addToolPack

public void addToolPack(org.apache.poi.ss.formula.udf.UDFFinder udfFinder)

Specified by:

addToolPack in interface org.apache.poi.ss.usermodel.Workbook

setForceFormulaRecalculation

public void setForceFormulaRecalculation(boolean b)

Specified by:

setForceFormulaRecalculation in interface org.apache.poi.ss.usermodel.Workbook

getForceFormulaRecalculation

public boolean getForceFormulaRecalculation()

Specified by:

getForceFormulaRecalculation in interface org.apache.poi.ss.usermodel.Workbook

getSpreadsheetVersion

public org.apache.poi.ss.SpreadsheetVersion getSpreadsheetVersion()

Specified by:

getSpreadsheetVersion in interface org.apache.poi.ss.usermodel.Workbook

addOlePackage

public int addOlePackage(byte[] bytes,
 String s,
 String s1,
 String s2)

Specified by:

addOlePackage in interface org.apache.poi.ss.usermodel.Workbook

createEvaluationWorkbook

public org.apache.poi.ss.formula.EvaluationWorkbook createEvaluationWorkbook()

Specified by:

createEvaluationWorkbook in interface org.apache.poi.ss.usermodel.Workbook

getCellReferenceType

public org.apache.poi.ss.usermodel.CellReferenceType getCellReferenceType()

Specified by:

getCellReferenceType in interface org.apache.poi.ss.usermodel.Workbook

setCellReferenceType

public void setCellReferenceType(org.apache.poi.ss.usermodel.CellReferenceType cellReferenceType)

Specified by:

setCellReferenceType in interface org.apache.poi.ss.usermodel.Workbook

getActiveSheetIndex

public int getActiveSheetIndex()

Specified by:

getActiveSheetIndex in interface org.apache.poi.ss.usermodel.Workbook

setActiveSheet

public void setActiveSheet(int i)

Specified by:

setActiveSheet in interface org.apache.poi.ss.usermodel.Workbook

getFirstVisibleTab

public int getFirstVisibleTab()

Specified by:

getFirstVisibleTab in interface org.apache.poi.ss.usermodel.Workbook

setFirstVisibleTab

public void setFirstVisibleTab(int i)

Specified by:

setFirstVisibleTab in interface org.apache.poi.ss.usermodel.Workbook

setSheetOrder

public void setSheetOrder(String s,
 int i)

Specified by:

setSheetOrder in interface org.apache.poi.ss.usermodel.Workbook

setSelectedTab

public void setSelectedTab(int i)

Specified by:

setSelectedTab in interface org.apache.poi.ss.usermodel.Workbook

setSheetName

public void setSheetName(int i,
 String s)

Specified by:

setSheetName in interface org.apache.poi.ss.usermodel.Workbook

getSheetName

public String getSheetName(int index)

Specified by:

getSheetName in interface org.apache.poi.ss.usermodel.Workbook

getSheetIndex

public int getSheetIndex(String name)

Specified by:

getSheetIndex in interface org.apache.poi.ss.usermodel.Workbook

getSheetIndex

public int getSheetIndex(org.apache.poi.ss.usermodel.Sheet sheet)

Specified by:

getSheetIndex in interface org.apache.poi.ss.usermodel.Workbook

cloneSheet

public org.apache.poi.ss.usermodel.Sheet cloneSheet(int index)

Specified by:

cloneSheet in interface org.apache.poi.ss.usermodel.Workbook

sheetIterator

public Iterator<org.apache.poi.ss.usermodel.Sheet> sheetIterator()

Specified by:

sheetIterator in interface org.apache.poi.ss.usermodel.Workbook

getNumberOfSheets

public int getNumberOfSheets()

Specified by:

getNumberOfSheets in interface org.apache.poi.ss.usermodel.Workbook

createSheet

public org.apache.poi.ss.usermodel.Sheet createSheet()

Specified by:

createSheet in interface org.apache.poi.ss.usermodel.Workbook

createSheet

public org.apache.poi.ss.usermodel.Sheet createSheet(String name)

Specified by:

createSheet in interface org.apache.poi.ss.usermodel.Workbook

write

public void write(OutputStream out)
           throws IOException

Specified by:

write in interface org.apache.poi.ss.usermodel.Workbook

Throws:

IOException

iterator

public Iterator<org.apache.poi.ss.usermodel.Sheet> iterator()

Specified by:

iterator in interface Iterable<org.apache.poi.ss.usermodel.Sheet>

Specified by:

iterator in interface org.apache.poi.ss.usermodel.Workbook

reload

public void reload()