-
dotnet-standard-api
-
C1.Excel Assembly
-
C1.Excel
-
Classes
- C1XLBook
- ShapeCollection
- XLBorderFormatting
- XLCell
- XLCellRange
- XLCellRangeCollection
- XLColumn
- XLColumnCollection
- XLComment
- XLCommentCollection
- XLCommentShape
- XLConditionalFormatting
- XLConditionalFormattingCollection
- XLConditionalFormattingRangeCollection
- XLConditionalFormattingRule
- XLConditionalFormattingRuleCollection
- XLDataValidation
- XLDataValidationCollection
- XLDataValidationRangeCollection
- XLExternalBook
- XLExternalBookCollection
- XLExternalSheet
- XLFont
- XLFontFormatting
- XLNamedRange
- XLNamedRangeCollection
- XLOpaqueShape
- XLPatternFormatting
- XLPictureShape
- XLPrintSettings
- XLProgressEventArgs
- XLRange
- XLRow
- XLRowCollection
- XLShape
- XLSheet
- XLSheetCollection
- XLStyle
- XLTextShape
- Structs
- Enums
- Delegates
-
Classes
- C1.Util
-
C1.Excel
-
C1.Excel Assembly
C1.Excel.C1XLBook
C1XLBook Class
<p>Represents an Excel workbook containing one or more worksheets.</p>
<p>Contains methods for loading and saving XLS files, and exposes
a collection of XLSheet objects that represent the individual worksheets.
Namespace: C1.Excel
Assembly: C1.Excel.dll
Syntax
public class C1XLBook : Component, IComponent, IDisposable, ICloneableConstructors
| Name | Description |
|---|---|
| C1XLBook() | Creates a new instance of the C1XLBook class. The new workbook contains a single empty XLSheet called "Sheet1". |
| C1XLBook(CompatibilityMode) | Creates a new instance of the C1XLBook class. The new workbook contains a single empty XLSheet called "Sheet1". |
Properties
| 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. |
| ExternalBooks | Gets a collection of XLExternalBook objects that represent the external worksheets in 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. |
| TwipsPerChar | Gets twips for one character. |
| 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. |
Methods
| 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. |
| GetRtf(params KeyValuePair<string, XLFont>[]) | Gets RTF code for pairs text and font. |
| Load(Stream) | Loads the worksheet from a stream. |
| Load(Stream, FileFormat) | Loads the worksheet from a stream. |
| Load(Stream, FileFormat, bool) | Loads the worksheet from a stream. |
| Load(Stream, bool) | Loads the worksheet from a stream. |
| Load(string) | Loads an Excel worksheet from a file. |
| Load(string, FileFormat) | Loads an Excel worksheet from a file. |
| Load(string, FileFormat, bool) | Loads an Excel worksheet from a file. |
| Load(string, bool) | Loads an Excel worksheet from a file. |
| LoadAsync(Stream, FileFormat, bool) | Loads asynchronous the worksheet from a stream. |
| LoadAsync(Stream, bool) | Loads asynchronous the worksheet from a stream. |
| LoadAsync(string, FileFormat, bool) | Loads asynchronous an Excel worksheet from a file. |
| LoadAsync(string, bool) | Loads asynchronous an Excel worksheet from a file. |
| LoadBiffAsync(Stream, bool) | Loads async the worksheet from a BIFF8 stream. |
| LoadBiffAsync(string, bool) | Loads async the worksheet from a BIFF8 (*.xls) file. |
| PixelsToTwips(double) | Converts a pixel measurement into twips (1/20th of a point). |
| Save(Stream) | Saves the worksheet into a stream. |
| Save(Stream, FileFormat) | Saves the worksheet into a stream. |
| Save(string) | Saves the worksheet to a file. |
| Save(string, FileFormat) | Saves the worksheet to a file. |
| SaveAsync(Stream, FileFormat) | Saves asynchronous the worksheet into a stream. |
| SaveAsync(string, FileFormat) | Saves asynchronous the worksheet to a file. |
| SaveBiffAsync(Stream) | Saves the worksheet into a stream. |
| SaveBiffAsync(string) | Saves async the workbook to a file. |
| SetDpi(float, float) | Sets horizontal and vertical DPI. |
| TwipsToPixels(double) | Converts a twips measurement into screen pixels. |
Events
| Name | Description |
|---|---|
| Progress | Fired while data is being read from or written into a workbook. |