CompatibilityMode Property

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

Syntax

Visual Basic
C#

'Declaration
 
Public Property CompatibilityMode As CompatibilityMode

'Usage
 
Dim instance As C1XLBook
Dim value As CompatibilityMode
 
instance.CompatibilityMode = value
 
value = instance.CompatibilityMode

public CompatibilityMode 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.

Reference

C1XLBook Class
C1XLBook Members