Excel for WinRT
C1XLBook Class Members
Properties  Methods 

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 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 PropertyPaletteGets or sets color palette of this workbook.  
Public PropertySheetsGets a collection of XLSheet objects that represent the worksheets in the C1XLBook.  
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 MethodCloneCreates a copy of this C1Excel book.  
Public MethodLoadAsyncOverloaded. Loads an Excel worksheet from a file storage.  
Public Methodstatic (Shared in Visual Basic)PixelsToTwipsConverts a pixel measurement into twips (1/20th of a point).  
Public MethodSaveAsyncOverloaded. Saves the worksheet to a file storage.  
Public Methodstatic (Shared in Visual Basic)TwipsToPixelsConverts a twip measurement into screen pixels.  
Top
See Also

Reference

C1XLBook Class
C1.Xaml.Excel Namespace

 

 


Copyright (c) GrapeCity, inc. All rights reserved.

Product Support Forum  |  Documentation Feedback