Namespace: Spire.Xls
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 11.6.0.0 (11.6.0.5020)

Syntax

            
 C#  Visual Basic  Visual C++  F# 
public sealed class Workbook : IDisposable
Public NotInheritable Class Workbook
	Implements IDisposable
public ref class Workbook sealed : IDisposable
[<SealedAttribute>]
type Workbook =  
    class
        interface IDisposable
    end

Members

            
 All Members  Constructors   Properties   Methods  
 Public

 Protected
 Instance

 Static 
 Declared

 Inherited
 XNA Framework Only 

 .NET Compact Framework Only 

 MemberDescription
Workbook()()()()
Initializes a new instance of the Workbook class
AcceptAllTrackedChanges()()()()
ActiveSheet
ActiveSheetIndex
AddDigitalSignature(X509Certificate2, String, DateTime)
AddInFunctions
AddPivotTableStyle(PivotTableStyle)
Allow3DRangesInDataValidation
CaculateFormulaValue(String)
CalculateAllValue()()()()
CalculationMode
ChangePaletteColor(Color, Int32)
Charts
Chartsheets
CheckComptiliblity
CodeName
Colors
ColumnWidthToPixels(Double)
ContainsFont(ExcelFont)
ConverterSetting
CopyTheme(Workbook)
CopyToClipboard()()()()
CopyToClipboard(Worksheet)
CreateEmptySheet()()()()
CreateEmptySheet(String)
CreateEmptySheets(Int32)
CreateEmptySheets(array<String>[]()[][])
CreateFont()()()()
CreateFont(Font)
CreatePivotStyle()()()()
CustomDocumentProperties
CustomFontFileDirectory
CustomFontFilePaths
CustomTableStyles
DataConns
DataSorter
Date1904
DefaultFontName
DefaultFontSize
DisableMacrosStart
Dispose()()()()
Releases all resources used by the Workbook
DocumentProperties
Equals(Object)
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
ExternalLinks
FileName
FindAllBool(Boolean)
FindAllDateTime(DateTime)
FindAllNumber(Double, Boolean)
FindAllString(String, Boolean, Boolean)
FindAllTimeSpan(TimeSpan)
FindBool(Boolean)
FindDateTime(DateTime)
FindNumber(Double, Boolean)
FindString(String, Boolean, Boolean)
FindTimeSpan(TimeSpan)
GetChartSheetByName(String)
GetCustomFontParsedResult()()()()
GetDigitalSignatures()()()()
GetHashCode()()()()
Serves as a hash function for a particular type.
(Inherited from Object.)
GetMatchingColor(Color)
GetMatchingColor(Int32, Int32, Int32)
GetOleSize()()()()
GetPaletteColor(ExcelColors)
GetSafeSheetName(String)
GetSafeSheetName(String, Char)
GetSplitPageInfo()()()()
GetSplitPageTable(Workbook)
GetThemeColor(ThemeColorType)
GetType()()()()
Gets the Type of the current instance.
(Inherited from Object.)
HasMacros
HasTrackedChanges
InitCalcEngine()()()()
IsCellProtection
IsDigitallySigned
IsHideWindow
IsHScrollBarVisible
IsPasswordProtected(String)
IsRightToLeft
IsSaved
IsVScrollBarVisible
IsWindowProtection
LoadFromFile(String)
LoadFromFile(String, ExcelVersion)
LoadFromFile(String, Boolean)
LoadFromFile(String, String)
LoadFromFile(String, String, Int32, Int32)
LoadFromFile(String, String, Int32, Int32, ExcelVersion)
LoadFromFile(String, String, Int32, Int32, ExcelVersion, Encoding)
LoadFromHtml(Stream)
LoadFromHtml(String)
LoadFromMHtml(Stream)
LoadFromMHtml(String)
LoadFromStream(Stream)
LoadFromStream(Stream, ExcelVersion)
LoadFromStream(Stream, Boolean)
LoadFromStream(Stream, String, Int32, Int32)
LoadFromStream(Stream, String, Int32, Int32, ExcelVersion)
LoadFromXml(Stream)
LoadFromXml(String)
LoadTemplateFromFile(String)
LoadTemplateFromFile(String, Boolean)
MarkerDesigner
MaxDigitWidth
MaxRowsOfSharedFormula
NameRanges
OpenPassword
OptimizeImport
PasteFromClipboard()()()()
PivotCaches
PixelsToColumnWidth(Double)
PrintDialog
PrintDocument
Protect(String)
Protect(String, Boolean, Boolean)
ProtectWorkbook(Boolean, Boolean, String)
ReadOnly
RejectAllTrackedChanges()()()()
RemoveAllDigitalSignatures()()()()
Replace(String, DateTime)
Replace(String, Double)
Replace(String, String)
Replace(String, DataColumn, Boolean)
Replace(String, DataTable, Boolean)
Replace(String, array<Double>[]()[][], Boolean)
Replace(String, array<Int32>[]()[][], Boolean)
Replace(String, array<String>[]()[][], Boolean)
ResetPalette()()()()
Save()()()()
SaveAsImage(Single, Single)
SaveAsImage(Int32, Single, Single)
SaveAsTemplate(String)
SaveAsTemplate(String, HttpResponse)
SaveAsXml(Stream)
SaveAsXml(String)
SaveChartAsEmfImage(Worksheet) Obsolete.
SaveChartAsEmfImage(Worksheet, Int32) Obsolete.
SaveChartAsEmfImage(Worksheet, Int32, Stream)
SaveChartAsImage(ChartSheet)
SaveChartAsImage(Worksheet)
SaveChartAsImage(Worksheet, Int32)
SaveToFile(String)
SaveToFile(String, ExcelVersion)
SaveToFile(String, FileFormat)
SaveToFile(String, TextSaveOptions)
SaveToFile(String, String)
SaveToFile(String, FileFormat, Boolean)
SaveToHtml(String)
SaveToHtml(String, Boolean)
SaveToHttpResponse(String, HttpResponse)
SaveToHttpResponse(String, HttpResponse, HttpContentType)
SaveToHttpResponse(String, HttpResponse, Boolean)
SaveToHttpResponse(String, HttpResponse, HttpContentType, FileFormat)
SaveToStream(Stream)
SaveToStream(Stream, FileFormat)
SaveToStream(Stream, String)
SelectedTab
SetMaxDigitWidth(Int32)
SetOleSize(Int32, Int32, Int32, Int32)
SetThemeColor(ThemeColorType, Color)
SetWriteProtectionPassword(String)
SheetTabBarWidth
ShowTabs
Styles
ToString()()()()
Returns a String that represents the current Object.
(Inherited from Object.)
UnProtect()()()()
UnProtect(String)
UnProtectWorkbook(String)
UseStorageMode
Version
Worksheets
WriteProtection

Inheritance Hierarchy

System..::..Object
  Spire.Xls..::..Workbook

See Also