C1.WPF.Excel Namespace > C1XLBook Class : CompatibilityMode Property |
'Declaration
Public Property CompatibilityMode As CompatibilityMode
public CompatibilityMode CompatibilityMode {get; set;}
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.
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2