-
dotnet-standard-api
-
C1.Excel Assembly
-
C1.Excel
-
Classes
- C1XLBook
- ShapeCollection
- XLBorderFormatting
- XLCell
- XLCellRange
- XLCellRangeCollection
- XLColumn
- XLColumnCollection
- XLComment
- XLCommentCollection
- XLCommentShape
- XLConditionalFormatting
- XLConditionalFormattingCollection
- XLConditionalFormattingRangeCollection
- XLConditionalFormattingRule
- XLConditionalFormattingRuleCollection
- XLDataValidation
- XLDataValidationCollection
- XLDataValidationRangeCollection
- XLExternalBook
- XLExternalBookCollection
- XLExternalSheet
- XLFont
- XLFontFormatting
- XLNamedRange
- XLNamedRangeCollection
- XLOpaqueShape
- XLPatternFormatting
- XLPictureShape
- XLPrintSettings
- XLProgressEventArgs
- XLRange
- XLRow
- XLRowCollection
- XLShape
- XLSheet
- XLSheetCollection
- XLStyle
- XLTextShape
- Structs
- Enums
- Delegates
-
Classes
- C1.Util
-
C1.Excel
-
C1.Excel Assembly
C1.Excel.C1XLBook.CompatibilityMode
CompatibilityMode Property
CompatibilityMode
Gets or sets a value determining the limits on sheet size and the number of styles allowed per workbook.
Declaration
public CompatibilityMode CompatibilityMode { get; set; }Remarks
<p>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.