Java org.apache.poi.xssf.usermodel XSSFWorkbook fields, constructors, methods, implement or subclass

Introduction

In this page you can find the methods, fields and constructors for org.apache.poi.xssf.usermodel XSSFWorkbook.

The text is from its open source code.

Subclass

org.apache.poi.xssf.usermodel.XSSFWorkbook has subclasses.
Click this link to see all its subclasses.

Constructor

	XSSFWorkbook(XSSFFactory factory)
	XSSFWorkbook(XSSFWorkbookType workbookType) Create a new SpreadsheetML workbook.
	XSSFWorkbook(OPCPackage pkg) Constructs a XSSFWorkbook object given a OpenXML4J `Package` object, see http://poi.apache.org/oxml4j/.
	XSSFWorkbook(InputStream is) Constructs a XSSFWorkbook object, by buffering the whole stream into memory and then opening an OPCPackage object for it.
	XSSFWorkbook(File file) Constructs a XSSFWorkbook object from a given file.
	XSSFWorkbook(String path) Constructs a XSSFWorkbook object given a file name.
	XSSFWorkbook(PackagePart part) Constructs a XSSFWorkbook object using Package Part.
	XSSFWorkbook() Create a new SpreadsheetML workbook.

Method

int	addPicture(byte[] pictureData, int format) Adds a picture to the workbook.
int	addPicture(InputStream is, int format) Adds a picture to the workbook.
XSSFSheet	cloneSheet(int sheetNum, String newName) Create an XSSFSheet from an existing sheet in the XSSFWorkbook.
XSSFSheet	cloneSheet(int sheetNum) Create an XSSFSheet from an existing sheet in the XSSFWorkbook.
void	close()
XSSFCellStyle	createCellStyle() Create a new XSSFCellStyle and add it to the workbook's style table
XSSFDataFormat	createDataFormat() Returns the workbook's data format table (a factory for creating data format strings).
XSSFFont	createFont() Create a new Font and add it to the workbook's font table
XSSFName	createName()
XSSFSheet	createSheet() Create an XSSFSheet for this workbook, adds it to the sheets and returns the high level representation.
XSSFSheet	createSheet(String sheetname) Create a new sheet for this Workbook and return the high level representation.
int	getActiveSheetIndex() Convenience method to get the active sheet.
List	getAllEmbedds() Get the document's embedded files.
List	getAllPictures() Gets all pictures from the Workbook.
XSSFCellStyle	getCellStyleAt(int idx) Get the cell style object at the given index
XSSFCreationHelper	getCreationHelper() Returns an object that handles instantiating concrete classes of the various instances for XSSF.
Collection	getCustomXMLMappings()
XSSFFont	getFontAt(short idx)
XSSFFont	getFontAt(int idx)
XSSFName	getName(String name) Get the first named range with the given name.
XSSFName	getNameAt(int nameIndex) Get the named range at the given index.
int	getNumberOfNames() Get the number of named ranges in the this workbook
int	getNumberOfSheets() Get the number of worksheets in the this workbook
int	getNumCellStyles() Get the number of styles the workbook contains
POIXMLProperties	getProperties() Get the document properties.
XSSFSheet	getSheet(String name) Get sheet with the given name (case insensitive match)
XSSFSheet	getSheetAt(int index) Get the XSSFSheet object at the given index.
int	getSheetIndex(String name) Returns the index of the sheet by his name (case insensitive match)
int	getSheetIndex(Sheet sheet) Returns the index of the given sheet
String	getSheetName(int sheetIx) Get the sheet name
StylesTable	getStylesSource() Return a object representing a collection of shared objects used for styling content, e.g.
ThemesTable	getTheme() Returns the Theme of current workbook.
Iterator	iterator() Alias for #sheetIterator() to allow foreach loops Note: remove() is not supported on this iterator.
void	removeSheetAt(int index) Removes sheet at the given index. Care must be taken if the removed sheet is the currently active or only selected sheet in the workbook.
void	setActiveSheet(int index) Convenience method to set the active sheet.
void	setForceFormulaRecalculation(boolean value) Whether the application shall perform a full recalculation when the workbook is opened.
void	setMissingCellPolicy(MissingCellPolicy missingCellPolicy) Sets the policy on what to do when getting missing or blank cells from a row.
void	setPrintArea(int sheetIndex, int startColumn, int endColumn, int startRow, int endRow) For the Convenience of Java Programmers maintaining pointers.
void	setSheetName(int sheetIndex, String sheetname) Set the sheet name.
void	setSheetOrder(String sheetname, int pos) sets the order of appearance for a given sheet.
void	write(OutputStream stream) Write out this document to an Outputstream.