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. | |
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. | |
Palette | Gets or sets color palette of this workbook. | |
Sheets | Gets a collection of XLSheet objects that represent the worksheets in the C1XLBook. | |
UseTempStorage | Specifies whether the component should use temporary storage at saving to XLSX/XSLT files for minimization used memory. |
Name | Description | |
---|---|---|
Clear | Clears the C1XLBook, restoring the initial state with a single XLSheet called "Sheet1". | |
Clone | Creates a copy of this C1Excel book. | |
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. | |
TwipsToPixels | Converts a twip measurement into screen pixels. |