Excel lets you specify the version of Microsoft Excel you want your workbooks to be compatible with by using CompatibilityMode property of the C1XLBook class. Setting the CompatibilityMode property also determines the limits on the sheet size and number of styles that can be applied on the workbook. This property accepts its input from the CompatibilityMode enumeration which provides the following options:
| Enumeration Values | Descriptions |
|---|---|
| Excel 2003 | Sets the compatibility mode to Excel 2003. This means sheets may have up to 65,536 rows and 256 columns and workbooks may have up to 4050 unique cell styles. |
| Excel 2007 | Sets the compatibility mode to Excel 2007. This means sheets may have up to 1,048,576 rows and 18,278 columns and workbooks may have up to 65,536 unique cell styles. |
| NoLimits | Sets the compatibility mode to NoLimits (no version specified). This means that no size limits are enforced. |
To set compatibility mode in Excel, use the following code. In this example, we set the compatibility mode to NoLimits.
| C# |
Copy Code
|
|---|---|
//set compatibility mode
c1XLBook1.CompatibilityMode = CompatibilityMode.NoLimits;
|
|
