| Name | Description | |
|---|---|---|
 | C1XLBook Constructor | Creates a new instance of the C1XLBook class. The new workbook contains a single empty XLSheet called "Sheet1". |
The following tables list the members exposed by C1XLBook.
| Name | Description | |
|---|---|---|
| C1XLBook Constructor | Creates a new instance of the C1XLBook class. The new workbook contains a single empty XLSheet called "Sheet1". |
| Name | Description | |
|---|---|---|
 | Author | Gets or sets the name of the person, company, or application that created this C1XLBook. |
| CalculationMode | Gets or sets the formula calculation mode. |
| CompatibilityMode | Gets or sets a value determining the limits on sheet size and the number of styles allowed per workbook. |
| Container | (Inherited from System.ComponentModel.Component) |
| DefaultFont | Gets or sets the default font object for the C1XLBook. |
| IsLoading | Determines whether the workbook is currently loading. |
| KeepFormulas | Specifies whether the component should store formulas read from XLS/XLSX files and write them back when saving the file. |
| ListSeparator | Gets or sets a list separator that used for CSV-data, by default used the list separator in the Windows system. |
| NamedRanges | Gets the collection of XLNamedRange objects for the current workbook. |
| OpaqueCopy | Gets or sets a value specifying whether the component should copy non-main BIFF records as opaque when loading and saving XLS files. |
| Palette | Gets or sets color palette of this workbook. |
| ReferenceMode | Gets or sets reference mode of this workbook. |
| Sheets | Gets a collection of XLSheet objects that represent the worksheets in the C1XLBook. |
| Site | (Inherited from System.ComponentModel.Component) |
| UseDefaultCsvEncoding | Specifies whether the component should use the default encoding for CSV files. |
| UseTempStorage | Specifies whether the component should use temporary storage at saving to XLSX/XSLT files for minimization used memory. |
| Name | Description | |
|---|---|---|
 | CanRaiseEvents | (Inherited from System.ComponentModel.Component) |
| DesignMode | (Inherited from System.ComponentModel.Component) |
| Events | (Inherited from System.ComponentModel.Component) |
| Name | Description | |
|---|---|---|
 | Clear | Clears the C1XLBook, restoring the initial state with a single XLSheet called "Sheet1". |
| ClearOpaqueData | Clears the C1XLBook opaque data. |
| Clone | Creates a copy of this C1Excel book. |
| CreateObjRef | (Inherited from System.MarshalByRefObject) |
| Dispose | Overloaded. (Inherited from System.ComponentModel.Component) |
| GetLifetimeService | (Inherited from System.MarshalByRefObject) |
| GetRtf | Gets RTF code for pairs text and font. |
| InitializeLifetimeService | (Inherited from System.MarshalByRefObject) |
| Load | Overloaded. Loads an Excel worksheet from a file. |
 | PixelsToTwips | Converts a pixel measurement into twips (1/20th of a point). |
| Save | Overloaded. Saves the worksheet to a file. |
| SetDpi | Sets horizontal and vertical DPI. |
| ToString | (Inherited from System.ComponentModel.Component) |
| TwipsToPixels | Converts a twips measurement into screen pixels. |
| Name | Description | |
|---|---|---|
 | Finalize | (Inherited from System.ComponentModel.Component) |
| GetService | (Inherited from System.ComponentModel.Component) |
| MemberwiseClone | Overloaded. (Inherited from System.MarshalByRefObject) |
| Name | Description | |
|---|---|---|
 | Disposed | (Inherited from System.ComponentModel.Component) |
| Progress | Fired while data is being read from or written into a workbook. |