Excel for WPF | ComponentOne
C1.WPF.Excel Namespace / C1XLBook Class / CompatibilityMode Property

In This Topic
    CompatibilityMode Property (C1XLBook)
    In This Topic
    Gets or sets a value determining the limits on sheet size and the number of styles allowed per workbook.
    Syntax
    'Declaration
     
    
    Public Property CompatibilityMode As 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.

    See Also