C1XLBook Class Members

Excel for WPF and Silverlight

C1XLBook Class Members

Properties Methods Collapse All Members Options: Show All

Include Inherited Members

C1.Silverlight.Excel Namespace : C1XLBook Class

The following tables list the members exposed by C1XLBook.

Public Constructors

	Name	Description
	C1XLBook Constructor	Creates a new instance of the C1XLBook class. The new workbook contains a single empty XLSheet called "Sheet1".

Public 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.
	Palette	Gets or sets color palette of this workbook.
	Sheets	Gets a collection of XLSheet objects that represent the worksheets in the C1XLBook.
	UseTempStorage	Specifies whether the component should use temporary storage at saving to XLSX/XSLT files for minimization used memory.

Public Methods

	Name	Description
	Clear	Clears the C1XLBook, restoring the initial state with a single XLSheet called "Sheet1".
	Clone	Creates a copy of this C1Excel book.
	Load	Overloaded. Loads an Excel worksheet from a file.
	PixelsToTwips	Converts a pixel measurement into twips (1/20th of a point).
	Save	Overloaded. Saves the worksheet to a file.
	TwipsToPixels	Converts a twip measurement into screen pixels.

See Also

Reference

C1XLBook Class
C1.Silverlight.Excel Namespace