ComponentOne WinForms Edition
Demos
Docs
Samples
Download
ComponentOne Excel for .NET
C1.Excel Assembly
/
C1.Excel Namespace
/
C1XLBook Class
/ Clear Method
Collapse All
Expand All
Language Filter: All
Language Filter: Multiple
Language Filter: Visual Basic
Language Filter: Visual Basic (Declaration)
Language Filter: C#
Visual Basic (Declaration)
C#
In This Topic
Syntax
Remarks
See Also
Excel for .NET Overview
Key Features
Limitations
Quick Start
Workbook
Worksheet
View Layouts
Rows and Columns
Cells
Images
Calculation Modes
Compatibility Modes
Groups and Subtotals
Conditional Formatting
Data Validation
Copy Sheets
Load and Save
API Reference
C1.Excel Assembly
Namespaces
C1.Excel Namespace
Overview
Classes
C1XLBook
Overview
Members
C1XLBook Constructor
C1XLBook Constructor()
C1XLBook Constructor(CompatibilityMode)
Methods
Clear Method
ClearOpaqueData Method
Clone Method
GetRtf Method
Load Method
Load(String) Method
Load(String,Boolean) Method
Load(String,FileFormat) Method
Load(String,FileFormat,Boolean) Method
Load(Stream) Method
Load(Stream,Boolean) Method
Load(Stream,FileFormat) Method
Load(Stream,FileFormat,Boolean) Method
LoadBiffAsync Method
LoadBiffAsync(String,Boolean) Method
LoadBiffAsync(Stream,Boolean) Method
PixelsToTwips Method
Save Method
Save(String) Method
Save(String,FileFormat) Method
Save(Stream) Method
Save(Stream,FileFormat) Method
SaveBiffAsync Method
SaveBiffAsync(String) Method
SaveBiffAsync(Stream) Method
SetDpi Method
TwipsToPixels Method
Properties
Author Property
CalculationMode Property
CompatibilityMode Property
DefaultFont Property
IsLoading Property
KeepFormulas Property
ListSeparator Property
NamedRanges Property
OpaqueCopy Property
Palette Property
ReferenceMode Property
Sheets Property
UseDefaultCsvEncoding Property
UseTempStorage Property
Events
Progress Event
ShapeCollection
XLBorderFormatting
XLCell
XLCellRange
XLCellRangeCollection
XLColumn
XLColumnCollection
XLComment
XLCommentCollection
XLCommentShape
XLConditionalFormatting
XLConditionalFormattingCollection
XLConditionalFormattingRangeCollection
XLConditionalFormattingRule
XLConditionalFormattingRuleCollection
XLDataValidation
XLDataValidationCollection
XLDataValidationRangeCollection
XLFont
XLFontFormatting
XLNamedRange
XLNamedRangeCollection
XLOpaqueShape
XLPatternFormatting
XLPictureShape
XLPrintSettings
XLProgressEventArgs
XLRange
XLRow
XLRowCollection
XLShape
XLSheet
XLSheetCollection
XLStyle
XLTextShape
Enumerations
CalculationMode
CompatibilityMode
ConsolidationFunction
FileFormat
ImageFormat
ImageScaling
IMEModeType
ViewLayout
XLAlignHorz
XLAlignVert
XLComparisonOperator
XLConditionalFormattingOperator
XLConditionalFormattingType
XLDiagonalFlags
XLErrorStyle
XLFontScript
XLHorizTextAlign
XLLineStyle
XLPattern
XLPictureViewType
XLRangeType
XLReadingDirection
XLReferenceMode
XLReferenceType
XLShapeDashedLineStyle
XLShapeLineStyle
XLTextOrientation
XLUnderlineStyle
XLValidationType
XLVertTextAlign
Delegates
XLProgressEventHandler
C1.Util Namespace
Overview
Classes
BitmapGraphicsRendering
GraphicsRendering
SvgGraphicsRendering
SvgRendering
XLBorderRendering
XLCellRendering
XLPath
XLSheetRendering
XLTextLayout
XLTextRange
XLTextRangeCollection
Enumerations
TextAlignType
Interfaces
IRendering
IUsingRendering
Clear Method (C1XLBook)
In This Topic
Syntax
Remarks
See Also
Clears the
C1XLBook
, restoring the initial state with a single
XLSheet
called "Sheet1".
Syntax
Visual Basic
C#
public void Clear()
'Declaration Public Sub Clear()
Remarks
The
Clear
method restores the
C1XLBook
object to its initial state, with a single empty sheet called "Sheet1" and the
DefaultFont
set to 10pt Arial.
See Also
Reference
C1XLBook Class
C1XLBook Members