# C1.WPF.Excel.C1XLBook.CompatibilityMode

## Content

<div class="doc-site-dotnet-api-container">



<h1 id="C1_WPF_Excel_C1XLBook_CompatibilityMode_" data-uid="C1.WPF.Excel.C1XLBook.CompatibilityMode*">CompatibilityMode Property
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="C1_WPF_Excel_C1XLBook_CompatibilityMode_" data-uid="C1.WPF.Excel.C1XLBook.CompatibilityMode*"></a>
<h4 id="C1_WPF_Excel_C1XLBook_CompatibilityMode" data-uid="C1.WPF.Excel.C1XLBook.CompatibilityMode">CompatibilityMode</h4>
<div class="markdown level1 summary"><p>Gets or sets a value determining the limits on sheet size and the number of styles allowed per workbook.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public CompatibilityMode CompatibilityMode { get; set; }</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Property CompatibilityMode As CompatibilityMode</code></pre>
</div>
<h5 id="C1_WPF_Excel_C1XLBook_CompatibilityMode_remarks">Remarks</h5>
<div class="markdown level1 remarks"><pre><code>&lt;p&gt;This property allows you to specify which version of Microsoft Excel 
</code></pre>
<p>you want your workbooks to be compatible with.</p>
<p>
<b>Excel2003</b> mode allows you to create sheets with up to 65,536 rows and 256 columns.
<b>Excel2007</b> mode allows you to create sheets with up to 1,048,576 rows and 18,278 columns.</p>
<p>Note that the XLS file format is limited by the <b>Excel2003</b> limits. If you
use the <b>Excel2007</b> mode and create large sheets, save them into <b>OpenXml</b> files
instead of XLS.</p>
</div>
</div>