The C1XLBook type exposes the following members.

Constructors

  Name Description
Public method C1XLBook
Creates a new instance of the C1XLBook class. The new workbook contains a single empty XLSheet called "Sheet1".

Methods

  Name Description
Public method Clear
Clears the C1XLBook, restoring the initial state with a single XLSheet called "Sheet1".
Public method Clone
Creates a copy of this C1Excel book.
Public method Equals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Public method GetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object.)
Public method Load(Stream)
Loads the worksheet from a stream.
Public method Load(String)
Loads an Excel worksheet from a file.
Public method Load(Stream, FileFormat)
Loads the worksheet from a stream.
Public method Load(Stream, Boolean)
Loads the worksheet from a stream.
Public method Load(String, FileFormat)
Loads an Excel worksheet from a file.
Public method Load(String, Boolean)
Loads an Excel worksheet from a file.
Public method Load(Stream, FileFormat, Boolean)
Loads the worksheet from a stream.
Public method Load(String, FileFormat, Boolean)
Loads an Excel worksheet from a file.
Public method Static member PixelsToTwips
Converts a pixel measurement into twips (1/20th of a point).
Public method Save(Stream)
Saves the worksheet into a stream.
Public method Save(String)
Saves the worksheet to a file.
Public method Save(Stream, FileFormat)
Saves the worksheet into a stream.
Public method Save(String, FileFormat)
Saves the worksheet to a file.
Public method ToString
Returns a string that represents the current object.
(Inherited from Object.)
Public method Static member TwipsToPixels
Converts a twip measurement into screen pixels.

Properties

  Name Description
Public property Author
Gets or sets the name of the person, company, or application that created this C1XLBook.
Public property CalculationMode
Gets or sets the formula calculation mode.
Public property CompatibilityMode
Gets or sets a value determining the limits on sheet size and the number of styles allowed per workbook.
Public property DefaultFont
Gets or sets the default font object for the C1XLBook.
Public property IsLoading
Determines whether the workbook is currently loading.
Public property KeepFormulas
Specifies whether the component should store formulas read from XLS/XLSX files and write them back when saving the file.
Public property NamedRanges
Gets the collection of XLNamedRange objects for the current workbook.
Public property Palette
Gets or sets color palette of this workbook.
Public property Sheets
Gets a collection of XLSheet objects that represent the worksheets in the C1XLBook.

See Also