C1XLBook Class

Represents an Excel workbook containing one or more worksheets.

Contains methods for loading and saving XLS files, and exposes a collection of XLSheet objects that represent the individual worksheets.

Inheritance

object

MarshalByRefObject

Component

C1XLBook

Implements

IComponent

IDisposable

ICloneable

Namespace: C1.C1Excel

Assembly: C1.C1Excel.4.8.dll

Syntax

[ToolboxBitmap(typeof(C1XLBook), "C1XLBook.png")]
[Obsolete("This library is obsolete. Please use C1.Excel for .NET Standard instead.")]
public class C1XLBook : Component, IComponent, IDisposable, ICloneable

<ToolboxBitmap(GetType(C1XLBook), "C1XLBook.png")>
<Obsolete("This library is obsolete. Please use C1.Excel for .NET Standard instead.")>
Public Class C1XLBook
    Inherits Component
    Implements IComponent, IDisposable, ICloneable

Remarks

This library is obsolete and may be removed in the future. Please plan migration to C1.Excel for .NET Standard library. To use it, you need to replace brushes, pens and images from System.Drawing to DS.Document.Imaging.

Constructors

Name	Description
C1XLBook()	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.
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.
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.
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.
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.
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.