Gets or sets a value determining the limits on sheet size and the number of styles allowed per workbook.

Namespace:  C1.Silverlight.Excel
Assembly:  C1.Silverlight.Excel.5 (in C1.Silverlight.Excel.5.dll)

Syntax

C#
public CompatibilityMode CompatibilityMode { get; set; }
Visual Basic
Public Property CompatibilityMode As CompatibilityMode
	Get
	Set

Remarks

This property allows you to specify which version of Microsoft Excel you want your workbooks to be compatible with.

Excel2003 mode allows you to create sheets with up to 65,536 rows and 256 columns. Excel2007 mode allows you to create sheets with up to 1,048,576 rows and 18,278 columns.

Note that the XLS file format is limited by the Excel2003 limits. If you use the Excel2007 mode and create large sheets, save them into OpenXml files instead of XLS.

See Also