ComponentOne Excel for .NET
C1.Excel Assembly / C1.Excel Namespace / C1XLBook Class
Properties Methods Events

In This Topic
    C1XLBook Class Members
    In This Topic

    The following tables list the members exposed by C1XLBook.

    Public Constructors
     NameDescription
    Public ConstructorC1XLBook ConstructorCreates a new instance of the C1XLBook class. The new workbook contains a single empty XLSheet called "Sheet1".  
    Top
    Public Properties
     NameDescription
    Public PropertyAuthorGets or sets the name of the person, company, or application that created this C1XLBook.  
    Public PropertyCalculationModeGets or sets the formula calculation mode.  
    Public PropertyCompatibilityModeGets or sets a value determining the limits on sheet size and the number of styles allowed per workbook.  
    Public PropertyContainer (Inherited from System.ComponentModel.Component)
    Public PropertyDefaultFontGets or sets the default font object for the C1XLBook.  
    Public PropertyIsLoadingDetermines whether the workbook is currently loading.  
    Public PropertyKeepFormulasSpecifies whether the component should store formulas read from XLS/XLSX files and write them back when saving the file.  
    Public PropertyListSeparatorGets or sets a list separator that used for CSV-data, by default used the list separator in the Windows system.  
    Public PropertyNamedRangesGets the collection of XLNamedRange objects for the current workbook.  
    Public PropertyOpaqueCopyGets or sets a value specifying whether the component should copy non-main BIFF records as opaque when loading and saving XLS files.  
    Public PropertyPaletteGets or sets color palette of this workbook.  
    Public PropertyReferenceModeGets or sets reference mode of this workbook.  
    Public PropertySheetsGets a collection of XLSheet objects that represent the worksheets in the C1XLBook.  
    Public PropertySite (Inherited from System.ComponentModel.Component)
    Public PropertyUseDefaultCsvEncodingSpecifies whether the component should use the default encoding for CSV files.  
    Public PropertyUseTempStorageSpecifies whether the component should use temporary storage at saving to XLSX/XSLT files for minimization used memory.  
    Top
    Public Methods
     NameDescription
    Public MethodClearClears the C1XLBook, restoring the initial state with a single XLSheet called "Sheet1".  
    Public MethodClearOpaqueDataClears the C1XLBook opaque data.  
    Public MethodCloneCreates a copy of this C1Excel book.  
    Public MethodCreateObjRef (Inherited from System.MarshalByRefObject)
    Public MethodDispose (Inherited from System.ComponentModel.Component)
    Public MethodGetLifetimeService (Inherited from System.MarshalByRefObject)
    Public MethodGetRtfGets RTF code for pairs text and font.  
    Public MethodInitializeLifetimeService (Inherited from System.MarshalByRefObject)
    Public MethodLoadOverloaded. Loads an Excel worksheet from a file.  
    Public Methodstatic (Shared in Visual Basic)PixelsToTwipsConverts a pixel measurement into twips (1/20th of a point).  
    Public MethodSaveOverloaded. Saves the worksheet to a file.  
    Public Methodstatic (Shared in Visual Basic)SetDpiSets horizontal and vertical DPI.  
    Public MethodToString (Inherited from System.ComponentModel.Component)
    Public Methodstatic (Shared in Visual Basic)TwipsToPixelsConverts a twips measurement into screen pixels.  
    Top
    Public Events
     NameDescription
    Public EventDisposed (Inherited from System.ComponentModel.Component)
    Public EventProgressFired while data is being read from or written into a workbook.  
    Top
    See Also

    Reference

    C1XLBook Class
    C1.Excel Namespace