Excel for WPF | ComponentOne
C1.Silverlight.Excel Namespace / C1XLBook Class
Properties Methods


In This Topic
    C1XLBook Class Members
    In This Topic

    The following tables list the members exposed by C1XLBook.

    Public Constructors
     NameDescription
    Public ConstructorCreates a new instance of the C1XLBook class. The new workbook contains a single empty XLSheet called "Sheet1".  
    Top
    Public Properties
     NameDescription
    Public PropertyGets or sets the name of the person, company, or application that created this C1XLBook.  
    Public PropertyGets or sets the formula calculation mode.  
    Public PropertyGets or sets a value determining the limits on sheet size and the number of styles allowed per workbook.  
    Public PropertyGets or sets the default font object for the C1XLBook.  
    Public PropertyDetermines whether the workbook is currently loading.  
    Public PropertySpecifies whether the component should store formulas read from XLS/XLSX files and write them back when saving the file.  
    Public PropertyGets or sets a list separator that used for CSV-data, by default used the list separator in the Windows system.  
    Public PropertyGets the collection of XLNamedRange objects for the current workbook.  
    Public PropertyGets or sets color palette of this workbook.  
    Public PropertyGets a collection of XLSheet objects that represent the worksheets in the C1XLBook.  
    Public PropertySpecifies whether the component should use temporary storage at saving to XLSX/XSLT files for minimization used memory.  
    Top
    Public Methods
     NameDescription
    Public MethodClears the C1XLBook, restoring the initial state with a single XLSheet called "Sheet1".  
    Public MethodCreates a copy of this C1Excel book.  
    Public MethodOverloaded. Loads an Excel worksheet from a file.  
    Public Methodstatic (Shared in Visual Basic)Converts a pixel measurement into twips (1/20th of a point).  
    Public MethodOverloaded. Saves the worksheet to a file.  
    Public Methodstatic (Shared in Visual Basic)Converts a twip measurement into screen pixels.  
    Top
    See Also