• Home
• NPOI
• XSSF
• UserModel
• XSSFWorkbook

C# Class NPOI.XSSF.UserModel.XSSFWorkbook

Mostra file Open project: tonyqus/npoi Class Usage Examples

Public Properties

Property	Type	Description
DEFAULT_CHARACTER_WIDTH	float
PICTURE_TYPE_BMP	int
PICTURE_TYPE_DIB	int
PICTURE_TYPE_EMF	int
PICTURE_TYPE_EPS	int
PICTURE_TYPE_GIF	int
PICTURE_TYPE_JPEG	int
PICTURE_TYPE_PICT	int
PICTURE_TYPE_PNG	int
PICTURE_TYPE_TIFF	int
PICTURE_TYPE_WMF	int
PICTURE_TYPE_WPG	int

Public Methods

Method	Description
Add ( ISheet item ) : void
AddPicture ( Stream picStream, int format ) : int
AddPicture ( byte pictureData, PictureType format ) : int
AddPicture ( byte pictureData, int format ) : int
AddToolPack ( NPOI.SS.Formula.Udf.UDFFinder toopack ) : void
Clear ( ) : void
CloneSheet ( int sheetNum ) : ISheet
Contains ( ISheet item ) : bool
CopyTo ( ISheet array, int arrayIndex ) : void
CreateCellStyle ( ) : ICellStyle	Create a new XSSFCellStyle and add it to the workbook's style table
CreateDataFormat ( ) : IDataFormat	Returns the instance of XSSFDataFormat for this workbook.
CreateFont ( ) : IFont	Create a new Font and add it to the workbook's font table
CreateName ( ) : IName
CreateSheet ( ) : ISheet
CreateSheet ( String sheetname ) : ISheet
FindFont ( short boldWeight, short color, short fontHeight, String name, bool italic, bool strikeout, FontSuperScript typeOffset, FontUnderlineType underline ) : IFont
GetAllEmbedds ( ) : List
GetAllPictures ( ) : IList
GetBuiltInName ( String builtInCode, int sheetNumber ) : NPOI.XSSF.UserModel.XSSFName
GetCTWorkbook ( ) : NPOI.OpenXmlFormats.Spreadsheet.CT_Workbook
GetCalculationChain ( ) : NPOI.XSSF.Model.CalculationChain
GetCellStyleAt ( short idx ) : ICellStyle
GetCellStyleAt ( int idx ) : NPOI.XSSF.UserModel.XSSFCellStyle
GetCreationHelper ( ) : ICreationHelper
GetCustomXMLMappings ( ) : List
GetEnumerator ( ) : IEnumerator
GetFontAt ( short idx ) : IFont
GetForceFormulaRecalculation ( ) : bool
GetMapInfo ( ) : NPOI.XSSF.Model.MapInfo
GetName ( String name ) : IName
GetNameAt ( int nameIndex ) : IName
GetNameIndex ( String name ) : int
GetPrintArea ( int sheetIndex ) : String
GetSharedStringSource ( ) : NPOI.XSSF.Model.SharedStringsTable
GetSheet ( String name ) : ISheet
GetSheetAt ( int index ) : ISheet
GetSheetIndex ( ISheet sheet ) : int
GetSheetIndex ( String name ) : int	Returns the index of the sheet by his name (case insensitive match)
GetSheetName ( int sheetIx ) : String
GetStylesSource ( ) : NPOI.XSSF.Model.StylesTable
GetTheme ( ) : NPOI.XSSF.Model.ThemesTable
IndexOf ( ISheet item ) : int
Insert ( int index, ISheet item ) : void
IsMacroEnabled ( ) : bool
IsRevisionLocked ( ) : bool
IsSheetHidden ( int sheetIx ) : bool
IsSheetVeryHidden ( int sheetIx ) : bool
IsStructureLocked ( ) : bool
IsWindowsLocked ( ) : bool
LinkExternalWorkbook ( String name, IWorkbook workbook ) : int
LockRevision ( ) : void
LockStructure ( ) : void
LockWindows ( ) : void
Remove ( ISheet item ) : bool
RemoveAt ( int index ) : void
RemoveName ( String name ) : void
RemoveName ( NPOI.XSSF.UserModel.XSSFName name ) : void
RemoveName ( int nameIndex ) : void
RemovePrintArea ( int sheetIndex ) : void
RemoveSheetAt ( int index ) : void
SetActiveSheet ( int sheetIndex ) : void
SetForceFormulaRecalculation ( bool value ) : void
SetPrintArea ( int sheetIndex, String reference ) : void
SetPrintArea ( int sheetIndex, int startColumn, int endColumn, int startRow, int endRow ) : void
SetSelectedTab ( int index ) : void
SetSheetHidden ( int sheetIx, SheetState state ) : void
SetSheetHidden ( int sheetIx, bool hidden ) : void
SetSheetHidden ( int sheetIx, int hidden ) : void	Hide or unhide a sheet.
SetSheetName ( int sheetIndex, String sheetname ) : void
SetSheetOrder ( String sheetname, int pos ) : void
UnlockRevision ( ) : void
UnlockStructure ( ) : void
UnlockWindows ( ) : void
XSSFWorkbook ( ) : System.Text.RegularExpressions
XSSFWorkbook ( FileInfo file ) : System.Text.RegularExpressions
XSSFWorkbook ( NPOI.OpenXml4Net.OPC.OPCPackage pkg ) : System.Text.RegularExpressions
XSSFWorkbook ( Stream is1 ) : System.Text.RegularExpressions
XSSFWorkbook ( String path ) : System.Text.RegularExpressions
this ( int index ) : ISheet

Protected Methods

Method	Description
AddPivotCache ( String rId ) : NPOI.OpenXmlFormats.Spreadsheet.CT_PivotCache
BeforeDocumentRead ( ) : void
Commit ( ) : void
CreateDialogsheet ( String sheetname, NPOI.OpenXmlFormats.Spreadsheet.CT_Dialogsheet dialogsheet ) : NPOI.XSSF.UserModel.XSSFDialogsheet
newPackage ( ) : NPOI.OpenXml4Net.OPC.OPCPackage

Private Methods

Method	Description
AddSheet ( String sheetname ) : NPOI.OpenXmlFormats.Spreadsheet.CT_Sheet
ContainsSheet ( String name, int excludeSheetIdx ) : bool
CreateBuiltInName ( String builtInName, int sheetNumber ) : NPOI.XSSF.UserModel.XSSFName
CreateProtectionFieldIfNotPresent ( ) : void
GetReferenceBuiltInRecord ( String sheetName, int startC, int endC, int startR, int endR ) : String
GetReferencePrintArea ( String sheetName, int startC, int endC, int startR, int endR ) : String
GetUDFFinder ( ) : NPOI.SS.Formula.Udf.UDFFinder
IsDate1904 ( ) : bool
OnDeleteFormula ( NPOI.XSSF.UserModel.XSSFCell cell ) : void
OnDocumentRead ( ) : void
OnSheetDelete ( int index ) : void
OnWorkbookCreate ( ) : void
ReprocessNamedRanges ( ) : void
SaveCalculationChain ( ) : void
SaveNamedRanges ( ) : void
SetRepeatingRowsAndColumns ( int sheetIndex, int startColumn, int endColumn, int startRow, int endRow ) : void
ValidateSheetIndex ( int index ) : void
WorkbookProtectionPresent ( ) : bool

Method Details

Property Details