• Excel for WPF and Silverlight Overview
    • Help with WPF and Silverlight Edition
    • Key Features
  • QuickStart: Excel for WPF
    • Step 1 of 4: Setting up the Project
    • Step 2 of 4: Adding Content to a C1XLBook
    • Step 3 of 4: Formatting the Content
    • Step 4 of 4: Saving and Opening the XLS File
  • QuickStart: Excel for Silverlight
    • Step 1 of 4: Setting up the Project
    • Step 2 of 4: Adding Content to a C1XLBook
    • Step 3 of 4: Saving the XLSX File
    • Step 4 of 4: Run the Program
  • Using Excel for WPF and Silverlight
    • Creating Documents
    • Worksheets
    • Rows and Columns
    • Cells
    • Styles
  • C1Excel Task-Based Help
    • Adding a Comment to a Cell (WPF)
    • Adding Content to a Workbook
    • Adding an Image to a Cell (WPF)
    • Adding a Page Break to a Worksheet
    • Copying Rows from One Book to Another (WPF)
    • Creating Subtotals
    • Formatting Cells
    • Importing and Exporting OpenXml Files (WPF)
    • Saving a CSV File (Silverlight)
    • Setting the Calculation Mode for a Workbook
  • C1Excel Samples
  • API Reference
    • C1.Silverlight.Excel.5 Assembly
      • Namespaces
        • C1.Silverlight.Excel Namespace
          • Overview
          • Classes
            • C1XLBook
              • Overview
              • Members
              • C1XLBook Constructor
              • Methods
                • Clear Method
                • Clone Method
                • Load Method
                  • Load(String) Method
                  • Load(String,Boolean) Method
                  • Load(String,FileFormat) Method
                  • Load(String,FileFormat,Boolean) Method
                  • Load(Stream) Method
                  • Load(Stream,Boolean) Method
                  • Load(Stream,FileFormat) Method
                  • Load(Stream,FileFormat,Boolean) Method
                • PixelsToTwips Method
                • Save Method
                  • Save(String) Method
                  • Save(String,FileFormat) Method
                  • Save(Stream) Method
                  • Save(Stream,FileFormat) Method
                • TwipsToPixels Method
              • Properties
                • Author Property
                • CalculationMode Property
                • CompatibilityMode Property
                • DefaultFont Property
                • IsLoading Property
                • KeepFormulas Property
                • ListSeparator Property
                • NamedRanges Property
                • Palette Property
                • Sheets Property
                • UseTempStorage Property
            • XLBorderFormatting
              • Overview
              • Members
              • XLBorderFormatting Constructor
              • Properties
                • BottomBorder Property
                • BottomColor Property
                • Diagonal Property
                • DiagonalColor Property
                • DiagonalStyle Property
                • LeftBorder Property
                • LeftColor Property
                • RightBorder Property
                • RightColor Property
                • TopBorder Property
                • TopColor Property
            • XLCell
              • Overview
              • Members
              • Methods
                • Clone Method
                • SetValue Method
              • Properties
                • Formula Property
                • Hyperlink Property
                • Style Property
                • Text Property
                • Value Property
            • XLCellRange
              • Overview
              • Members
              • XLCellRange Constructor
                • XLCellRange Constructor()
                • XLCellRange Constructor(Int32,Int32,Int32,Int32)
                • XLCellRange Constructor(XLSheet,Int32,Int32,Int32,Int32)
                • XLCellRange Constructor(XLSheet,Int32,Int32,Int32,Int32,XLReferenceType,XLReferenceType,XLReferenceType,XLReferenceType)
                • XLCellRange Constructor(XLSheet,Int32,Int32,XLReferenceType,XLReferenceType)
                • XLCellRange Constructor(Int32,Int32,Int32,Int32,Int32,Int32,XLReferenceType,XLReferenceType,XLReferenceType,XLReferenceType)
                • XLCellRange Constructor(XLSheet,String)
                • XLCellRange Constructor(C1XLBook,String)
              • Methods
                • Clone Method
                • Contains Method
                  • Contains(XLSheet,Int32,Int32) Method
                  • Contains(XLCellRange) Method
                • Intersects Method
                • ToString Method
              • Properties
                • Book Property
                • ColumnCount Property
                • ColumnFrom Property
                • ColumnFromRef Property
                • ColumnTo Property
                • ColumnToRef Property
                • IsEmpty Property
                • RangeType Property
                • RowCount Property
                • RowFrom Property
                • RowFromRef Property
                • RowTo Property
                • RowToRef Property
                • SheetCount Property
                • SheetFrom Property
                • Sheets Property
                • SheetTo Property
                • Style Property
                • Value Property
            • XLCellRangeCollection
              • Overview
              • Members
              • Methods
                • Add Method
                  • Add(XLCellRange) Method
                  • Add(Int32,Int32,Int32,Int32) Method
                • Clear Method
                • Contains Method
                • IndexOf Method
                • Insert Method
                • Remove Method
                • RemoveAt Method
              • Properties
                • ActiveIndex Property
                • Book Property
                • Count Property
                • Item Property
                • Sheet Property
            • XLColumn
              • Overview
              • Members
              • XLColumn Constructor
              • Methods
                • Clone Method
                  • Clone() Method
                  • Clone(XLCell[]) Method
              • Properties
                • Book Property
                • Collapsed Property
                • IsSubtotal Property
                • OutlineLevel Property
                • PageBreak Property
                • Sheet Property
                • Style Property
                • Visible Property
                • Width Property
            • XLColumnCollection
              • Overview
              • Members
              • Methods
                • Add Method
                  • Add() Method
                  • Add(XLColumn) Method
                • Clear Method
                • Contains Method
                • IndexOf Method
                • Insert Method
                  • Insert(Int32) Method
                  • Insert(Int32,XLColumn) Method
                  • Insert(Int32,XLColumn,XLCell[]) Method
                • Remove Method
                • RemoveAt Method
              • Properties
                • Book Property
                • Count Property
                • Frozen Property
                • Item Property
                • Sheet Property
            • XLConditionalFormatting
              • Overview
              • Members
              • XLConditionalFormatting Constructor
              • Methods
                • Clone Method
              • Properties
                • Ranges Property
                • Rules Property
            • XLConditionalFormattingCollection
              • Overview
              • Members
              • Properties
                • Sheet Property
            • XLConditionalFormattingRangeCollection
              • Overview
              • Members
              • Methods
                • ToString Method
              • Properties
                • ConditionalFormatting Property
                • ToughRecalc Property
            • XLConditionalFormattingRule
              • Overview
              • Members
              • XLConditionalFormattingRule Constructor
              • Methods
                • Clone Method
              • Properties
                • Border Property
                • FirstFormula Property
                • Font Property
                • IsEmpty Property
                • Operator Property
                • Parameter Property
                • Pattern Property
                • Priority Property
                • SecondFormula Property
                • Type Property
            • XLConditionalFormattingRuleCollection
              • Overview
              • Members
              • Properties
                • ConditionalFormatting Property
            • XLFont
              • Overview
              • Members
              • XLFont Constructor
                • XLFont Constructor(String,Single)
                • XLFont Constructor(String,Single,Color)
                • XLFont Constructor(String,Single,Boolean,Boolean)
                • XLFont Constructor(String,Single,Boolean,Boolean,Color)
                • XLFont Constructor(String,Single,Boolean,Boolean,Boolean,XLFontScript,XLUnderlineStyle,Color)
                • XLFont Constructor(String,Single,Boolean,Boolean,Boolean,XLFontScript,XLUnderlineStyle,Color,Byte)
              • Methods
                • Equals Method
                • GetHashCode Method
              • Properties
                • Bold Property
                • CharSet Property
                • Color Property
                • FontName Property
                • FontSize Property
                • Italic Property
                • Script Property
                • SizeInPoints Property
                • Strikeout Property
                • Underline Property
            • XLFontFormatting
              • Overview
              • Members
              • XLFontFormatting Constructor
              • Properties
                • Bold Property
                • Escapement Property
                • FontColor Property
                • FontHeight Property
                • FontWeight Property
                • Italic Property
                • Strikeout Property
                • Underline Property
            • XLNamedRange
              • Overview
              • Members
              • Methods
                • Clone Method
                • Contains Method
              • Properties
                • Book Property
                • CellRange Property
                • CellRanges Property
                • Comment Property
                • IsBuiltInName Property
                • IsEmpty Property
                • IsNameOnly Property
                • Name Property
            • XLNamedRangeCollection
              • Overview
              • Members
              • Methods
                • Add Method
                  • Add(XLNamedRange) Method
                  • Add(String,XLCellRange) Method
                  • Add(String,XLCellRange[]) Method
                  • Add(String,XLSheet,Int32,Int32) Method
                  • Add(String,Int32,Int32,Int32,Int32) Method
                  • Add(String,XLSheet,Int32,Int32,Int32,Int32) Method
                • Clear Method
                • Contains Method
                  • Contains(XLNamedRange) Method
                  • Contains(String) Method
                • IndexOf Method
                  • IndexOf(XLNamedRange) Method
                  • IndexOf(String) Method
                • Insert Method
                • Remove Method
                  • Remove(XLNamedRange) Method
                  • Remove(String) Method
                • RemoveAt Method
              • Properties
                • Book Property
                • Count Property
                • Item Property
                  • Item(Int32) Property
                  • Item(String) Property
            • XLPatternFormatting
              • Overview
              • Members
              • XLPatternFormatting Constructor
              • Properties
                • BackColor Property
                • ForeColor Property
                • Pattern Property
            • XLPrintSettings
              • Overview
              • Members
              • XLPrintSettings Constructor
              • Methods
                • Clone Method
              • Properties
                • AlignWithMargins Property
                • AutoScale Property
                • BlackAndWhite Property
                • CenterHorizontal Property
                • CenterVertical Property
                • Copies Property
                • DraftQuality Property
                • FitPagesAcross Property
                • FitPagesDown Property
                • Footer Property
                • FooterEven Property
                • FooterFirst Property
                • Header Property
                • HeaderEven Property
                • HeaderFirst Property
                • Landscape Property
                • MarginBottom Property
                • MarginFooter Property
                • MarginHeader Property
                • MarginLeft Property
                • MarginRight Property
                • MarginTop Property
                • PaperKind Property
                • PrintGridlines Property
                • PrintHeaders Property
                • PrintPagesInRows Property
                • ScaleWithDocument Property
                • ScalingFactor Property
                • StartPage Property
            • XLRange
              • Overview
              • Members
              • XLRange Constructor
                • XLRange Constructor(String)
                • XLRange Constructor(Int32,Int32)
                • XLRange Constructor(Int32,Int32,Int32,Int32)
              • Methods
                • Clone Method
                • Equals Method
                • GetHashCode Method
                • ToString Method
              • Properties
                • ColumnFirst Property
                • ColumnLast Property
                • RowFirst Property
                • RowLast Property
            • XLRow
              • Overview
              • Members
              • XLRow Constructor
              • Methods
                • Clone Method
              • Properties
                • Book Property
                • Collapsed Property
                • Height Property
                • IsCustomHeight Property
                • IsSubtotal Property
                • OutlineLevel Property
                • PageBreak Property
                • Sheet Property
                • Style Property
                • Visible Property
            • XLRowCollection
              • Overview
              • Members
              • Methods
                • Add Method
                  • Add() Method
                  • Add(XLRow) Method
                • Clear Method
                • Contains Method
                • IndexOf Method
                • Insert Method
                  • Insert(Int32) Method
                  • Insert(Int32,XLRow) Method
                • Remove Method
                • RemoveAt Method
              • Properties
                • Book Property
                • Count Property
                • Frozen Property
                • Item Property
                • Sheet Property
            • XLSheet
              • Overview
              • Members
              • Methods
                • Clone Method
                • CopyFormula Method
                • GetCell Method
                • GetFormattedText Method
                • Load Method
                  • Load(String,Boolean) Method
                  • Load(Stream,Boolean) Method
                • LoadCsv Method
                  • LoadCsv(String) Method
                  • LoadCsv(Stream) Method
                • SaveCsv Method
                  • SaveCsv(String) Method
                  • SaveCsv(Stream) Method
              • Properties
                • Book Property
                • ColumnMaxLevel Property
                • Columns Property
                • ConditionalFormattings Property
                • DefaultColumnWidth Property
                • DefaultRowHeight Property
                • GridColor Property
                • Item Property
                • Locked Property
                • MaxOutlineLevel Property
                • MergedCells Property
                • Name Property
                • OutlinesBelow Property
                • OutlinesRight Property
                • PrintSettings Property
                • RowMaxLevel Property
                • Rows Property
                • Scale Property
                • SelectedCells Property
                • ShowGridLines Property
                • ShowHeaders Property
                • ShowZeros Property
                • TabColor Property
                • TotalsBelowData Property
                • Visible Property
            • XLSheetCollection
              • Overview
              • Members
              • Methods
                • Add Method
                  • Add() Method
                  • Add(XLSheet) Method
                  • Add(String) Method
                • Clear Method
                • Contains Method
                  • Contains(XLSheet) Method
                  • Contains(String) Method
                • IndexOf Method
                  • IndexOf(XLSheet) Method
                  • IndexOf(String) Method
                • Insert Method
                  • Insert(Int32) Method
                  • Insert(Int32,XLSheet) Method
                • Remove Method
                  • Remove(XLSheet) Method
                  • Remove(String) Method
                • RemoveAt Method
              • Properties
                • Book Property
                • Count Property
                • FirstIndex Property
                • Item Property
                  • Item(Int32) Property
                  • Item(String) Property
                • SelectedIndex Property
            • XLStyle
              • Overview
              • Members
              • XLStyle Constructor
              • Methods
                • Clone Method
                • Equals Method
                • FormatDotNetToXL Method
                  • FormatDotNetToXL(String,Type) Method
                  • FormatDotNetToXL(String,Type,CultureInfo) Method
                  • FormatDotNetToXL(String) Method
                  • FormatDotNetToXL(String,CultureInfo) Method
                • FormatXLToDotNet Method
                  • FormatXLToDotNet(String) Method
                  • FormatXLToDotNet(String,CultureInfo) Method
                • GetHashCode Method
                • SetBorderColor Method
                • SetBorderStyle Method
              • Properties
                • AlignHorz Property
                • AlignVert Property
                • BackColor Property
                • BackPattern Property
                • BorderBottom Property
                • BorderColorBottom Property
                • BorderColorLeft Property
                • BorderColorRight Property
                • BorderColorTop Property
                • BorderLeft Property
                • BorderRight Property
                • BorderTop Property
                • Diagonal Property
                • DiagonalColor Property
                • DiagonalStyle Property
                • Direction Property
                • Font Property
                • ForeColor Property
                • Format Property
                • Indent Property
                • Locked Property
                • PatternColor Property
                • Rotation Property
                • ShrinkToFit Property
                • WordWrap Property
          • Enumerations
            • CalculationMode
            • CompatibilityMode
            • ConsolidationFunction
            • FileFormat
            • XLAlignHorzEnum
            • XLAlignVertEnum
            • XLConditionalFormattingOperator
            • XLConditionalFormattingType
            • XLDiagonalFlags
            • XLFontScript
            • XLLineStyleEnum
            • XLPatternEnum
            • XLRangeType
            • XLReadingDirection
            • XLReferenceMode
            • XLReferenceType
            • XLUnderlineStyle
          • Interfaces
            • ICloneable
              • Overview
              • Members
              • Methods
                • Clone Method
    • C1.WPF.Excel.4 Assembly
      • Namespaces
        • C1.WPF.Excel Namespace
          • Overview
          • Classes
            • C1XLBook
              • Overview
              • Members
              • C1XLBook Constructor
              • Methods
                • Clear Method
                • Clone Method
                • Load Method
                  • Load(String) Method
                  • Load(String,Boolean) Method
                  • Load(String,FileFormat) Method
                  • Load(String,FileFormat,Boolean) Method
                  • Load(Stream) Method
                  • Load(Stream,Boolean) Method
                  • Load(Stream,FileFormat) Method
                  • Load(Stream,FileFormat,Boolean) Method
                • PixelsToTwips Method
                • Save Method
                  • Save(String) Method
                  • Save(String,FileFormat) Method
                  • Save(Stream) Method
                  • Save(Stream,FileFormat) Method
                • TwipsToPixels Method
              • Properties
                • Author Property
                • CalculationMode Property
                • CompatibilityMode Property
                • DefaultFont Property
                • IsLoading Property
                • KeepFormulas Property
                • ListSeparator Property
                • NamedRanges Property
                • OpaqueCopy Property
                • Palette Property
                • ReferenceMode Property
                • Sheets Property
                • UseDefaultCsvEncoding Property
                • UseTempStorage Property
            • ShapeCollection
              • Overview
              • Members
              • Methods
                • Add Method
                • Contains Method
                  • Contains(XLShape) Method
                  • Contains(Int32) Method
                • IndexOf Method
                  • IndexOf(XLShape) Method
                  • IndexOf(Int32) Method
                • Insert Method
                • Remove Method
                  • Remove(XLShape) Method
                  • Remove(Int32) Method
              • Properties
                • Count Property
                • Item Property
                • Sheet Property
            • XLBorderFormatting
              • Overview
              • Members
              • XLBorderFormatting Constructor
              • Properties
                • BottomBorder Property
                • BottomColor Property
                • Diagonal Property
                • DiagonalColor Property
                • DiagonalStyle Property
                • LeftBorder Property
                • LeftColor Property
                • RightBorder Property
                • RightColor Property
                • TopBorder Property
                • TopColor Property
            • XLCell
              • Overview
              • Members
              • Methods
                • Clone Method
                • SetValue Method
              • Properties
                • Formula Property
                • Hyperlink Property
                • Style Property
                • Text Property
                • Value Property
            • XLCellRange
              • Overview
              • Members
              • XLCellRange Constructor
                • XLCellRange Constructor()
                • XLCellRange Constructor(Int32,Int32,Int32,Int32)
                • XLCellRange Constructor(XLSheet,Int32,Int32,Int32,Int32)
                • XLCellRange Constructor(XLSheet,Int32,Int32,Int32,Int32,XLReferenceType,XLReferenceType,XLReferenceType,XLReferenceType)
                • XLCellRange Constructor(XLSheet,Int32,Int32,XLReferenceType,XLReferenceType)
                • XLCellRange Constructor(Int32,Int32,Int32,Int32,Int32,Int32,XLReferenceType,XLReferenceType,XLReferenceType,XLReferenceType)
                • XLCellRange Constructor(XLSheet,String)
                • XLCellRange Constructor(C1XLBook,String)
              • Methods
                • Clone Method
                • Contains Method
                  • Contains(XLSheet,Int32,Int32) Method
                  • Contains(XLCellRange) Method
                • Intersects Method
                • ToString Method
              • Properties
                • Book Property
                • ColumnCount Property
                • ColumnFrom Property
                • ColumnFromRef Property
                • ColumnTo Property
                • ColumnToRef Property
                • IsEmpty Property
                • RangeType Property
                • RowCount Property
                • RowFrom Property
                • RowFromRef Property
                • RowTo Property
                • RowToRef Property
                • SheetCount Property
                • SheetFrom Property
                • Sheets Property
                • SheetTo Property
                • Style Property
                • Value Property
            • XLCellRangeCollection
              • Overview
              • Members
              • Methods
                • Add Method
                  • Add(XLCellRange) Method
                  • Add(Int32,Int32,Int32,Int32) Method
                • Clear Method
                • Contains Method
                • IndexOf Method
                • Insert Method
                • Remove Method
                • RemoveAt Method
              • Properties
                • ActiveIndex Property
                • Book Property
                • Count Property
                • Item Property
                • Sheet Property
            • XLColumn
              • Overview
              • Members
              • XLColumn Constructor
              • Methods
                • Clone Method
                  • Clone() Method
                  • Clone(XLCell[]) Method
              • Properties
                • Book Property
                • Collapsed Property
                • IsSubtotal Property
                • OutlineLevel Property
                • PageBreak Property
                • Sheet Property
                • Style Property
                • Visible Property
                • Width Property
            • XLColumnCollection
              • Overview
              • Members
              • Methods
                • Add Method
                  • Add() Method
                  • Add(XLColumn) Method
                • Clear Method
                • Contains Method
                • IndexOf Method
                • Insert Method
                  • Insert(Int32) Method
                  • Insert(Int32,XLColumn) Method
                  • Insert(Int32,XLColumn,XLCell[]) Method
                • Remove Method
                • RemoveAt Method
              • Properties
                • Book Property
                • Count Property
                • Frozen Property
                • Item Property
                • Sheet Property
            • XLComment
              • Overview
              • Members
              • XLComment Constructor
              • Methods
                • Clone Method
              • Properties
                • Author Property
                • Cell Property
                • ColumnIndex Property
                • IsShow Property
                • RowIndex Property
                • Sheet Property
                • TextBox Property
            • XLCommentCollection
              • Overview
              • Members
              • Methods
                • Add Method
                  • Add(XLComment) Method
                  • Add(Int32,Int32,String) Method
                  • Add(Int32,Int32,String,String) Method
                  • Add(Int32,Int32,String,String,Boolean) Method
                • Clear Method
                • Contains Method
                • IndexOf Method
                • Insert Method
                • Remove Method
                • RemoveAt Method
              • Properties
                • Count Property
                • Item Property
                • Sheet Property
            • XLCommentShape
              • Overview
              • Members
              • XLCommentShape Constructor
                • XLCommentShape Constructor(String,Int32,Int32)
                • XLCommentShape Constructor(String,Double,Double,Double,Double)
                • XLCommentShape Constructor(String,Rect)
                • XLCommentShape Constructor(String)
              • Properties
                • IsEmpty Property
                • Visible Property
            • XLConditionalFormatting
              • Overview
              • Members
              • XLConditionalFormatting Constructor
              • Methods
                • Clone Method
              • Properties
                • Ranges Property
                • Rules Property
            • XLConditionalFormattingCollection
              • Overview
              • Members
              • Properties
                • Sheet Property
            • XLConditionalFormattingRangeCollection
              • Overview
              • Members
              • Methods
                • ToString Method
              • Properties
                • ConditionalFormatting Property
                • ToughRecalc Property
            • XLConditionalFormattingRule
              • Overview
              • Members
              • XLConditionalFormattingRule Constructor
              • Methods
                • Clone Method
              • Properties
                • Border Property
                • FirstFormula Property
                • Font Property
                • IsEmpty Property
                • Operator Property
                • Parameter Property
                • Pattern Property
                • Priority Property
                • SecondFormula Property
                • Type Property
            • XLConditionalFormattingRuleCollection
              • Overview
              • Members
              • Properties
                • ConditionalFormatting Property
            • XLFont
              • Overview
              • Members
              • XLFont Constructor
                • XLFont Constructor(String,Single)
                • XLFont Constructor(String,Single,Color)
                • XLFont Constructor(String,Single,Boolean,Boolean)
                • XLFont Constructor(String,Single,Boolean,Boolean,Color)
                • XLFont Constructor(String,Single,Boolean,Boolean,Boolean,XLFontScript,XLUnderlineStyle,Color)
                • XLFont Constructor(String,Single,Boolean,Boolean,Boolean,XLFontScript,XLUnderlineStyle,Color,Byte)
              • Methods
                • Equals Method
                • GetHashCode Method
              • Properties
                • Bold Property
                • CharSet Property
                • Color Property
                • FontName Property
                • FontSize Property
                • Italic Property
                • Script Property
                • SizeInPoints Property
                • Strikeout Property
                • Underline Property
            • XLFontFormatting
              • Overview
              • Members
              • XLFontFormatting Constructor
              • Properties
                • Bold Property
                • Escapement Property
                • FontColor Property
                • FontHeight Property
                • FontWeight Property
                • Italic Property
                • Strikeout Property
                • Underline Property
            • XLNamedRange
              • Overview
              • Members
              • Methods
                • Clone Method
                • Contains Method
                • ParseRefers Method
              • Properties
                • Book Property
                • CellRange Property
                • CellRanges Property
                • Comment Property
                • IsBuiltInName Property
                • IsEmpty Property
                • IsNameOnly Property
                • Name Property
                • Refers Property
            • XLNamedRangeCollection
              • Overview
              • Members
              • Methods
                • Add Method
                  • Add(XLNamedRange) Method
                  • Add(String,XLCellRange) Method
                  • Add(String,XLCellRange[]) Method
                  • Add(String,XLSheet,Int32,Int32) Method
                  • Add(String,Int32,Int32,Int32,Int32) Method
                  • Add(String,XLSheet,Int32,Int32,Int32,Int32) Method
                • Clear Method
                • Contains Method
                  • Contains(XLNamedRange) Method
                  • Contains(String) Method
                • IndexOf Method
                  • IndexOf(XLNamedRange) Method
                  • IndexOf(String) Method
                • Insert Method
                • Remove Method
                  • Remove(XLNamedRange) Method
                  • Remove(String) Method
                • RemoveAt Method
              • Properties
                • Book Property
                • Count Property
                • Item Property
                  • Item(Int32) Property
                  • Item(String) Property
            • XLOpaqueShape
              • Overview
              • Members
              • Properties
                • IsEmpty Property
            • XLPatternFormatting
              • Overview
              • Members
              • XLPatternFormatting Constructor
              • Properties
                • BackColor Property
                • ForeColor Property
                • Pattern Property
            • XLPictureShape
              • Overview
              • Members
              • XLPictureShape Constructor
                • XLPictureShape Constructor(WriteableBitmap,Int32,Int32)
                • XLPictureShape Constructor(WriteableBitmap,Int32,Int32,Int32,Int32)
                • XLPictureShape Constructor(WriteableBitmap,Rect)
                • XLPictureShape Constructor(WriteableBitmap)
                • XLPictureShape Constructor(WriteableBitmap,Size,HorizontalAlignment,VerticalAlignment,ImageScaling)
                • XLPictureShape Constructor(XLSheet,WriteableBitmap,Double,Double,Double,Double)
                • XLPictureShape Constructor(C1Bitmap,Int32,Int32)
                • XLPictureShape Constructor(C1Bitmap,Int32,Int32,Int32,Int32)
                • XLPictureShape Constructor(C1Bitmap,Rect)
                • XLPictureShape Constructor(C1Bitmap)
                • XLPictureShape Constructor(C1Bitmap,Size,HorizontalAlignment,VerticalAlignment,ImageScaling)
                • XLPictureShape Constructor(XLSheet,C1Bitmap,Double,Double,Double,Double)
              • Properties
                • BottomClip Property
                • Brightness Property
                • BrightnessInPercents Property
                • Contrast Property
                • ContrastInPercents Property
                • FileName Property
                • Image Property
                • ImageSize Property
                • IsEmpty Property
                • LeftClip Property
                • RightClip Property
                • TopClip Property
                • Transparent Property
                • ViewType Property
            • XLPrintSettings
              • Overview
              • Members
              • XLPrintSettings Constructor
              • Methods
                • Clone Method
              • Properties
                • AlignWithMargins Property
                • AutoScale Property
                • BlackAndWhite Property
                • CenterHorizontal Property
                • CenterVertical Property
                • Copies Property
                • DraftQuality Property
                • FitPagesAcross Property
                • FitPagesDown Property
                • Footer Property
                • FooterEven Property
                • FooterFirst Property
                • FooterPictureCenter Property
                • FooterPictureLeft Property
                • FooterPictureRight Property
                • Header Property
                • HeaderEven Property
                • HeaderFirst Property
                • HeaderPictureCenter Property
                • HeaderPictureLeft Property
                • HeaderPictureRight Property
                • Landscape Property
                • MarginBottom Property
                • MarginFooter Property
                • MarginHeader Property
                • MarginLeft Property
                • MarginRight Property
                • MarginTop Property
                • PaperKind Property
                • PrintGridlines Property
                • PrintHeaders Property
                • PrintPagesInRows Property
                • ScaleWithDocument Property
                • ScalingFactor Property
                • StartPage Property
            • XLRange
              • Overview
              • Members
              • XLRange Constructor
                • XLRange Constructor(String,XLReferenceMode)
                • XLRange Constructor(Int32,Int32)
                • XLRange Constructor(Int32,Int32,Int32,Int32)
              • Methods
                • Clone Method
                • Equals Method
                • GetHashCode Method
                • ToString Method
              • Properties
                • ColumnFirst Property
                • ColumnLast Property
                • RowFirst Property
                • RowLast Property
            • XLRow
              • Overview
              • Members
              • XLRow Constructor
              • Methods
                • Clone Method
              • Properties
                • Book Property
                • Collapsed Property
                • Height Property
                • IsCustomHeight Property
                • IsSubtotal Property
                • OutlineLevel Property
                • PageBreak Property
                • Sheet Property
                • Style Property
                • Visible Property
            • XLRowCollection
              • Overview
              • Members
              • Methods
                • Add Method
                  • Add() Method
                  • Add(XLRow) Method
                • Clear Method
                • Contains Method
                • IndexOf Method
                • Insert Method
                  • Insert(Int32) Method
                  • Insert(Int32,XLRow) Method
                • Remove Method
                • RemoveAt Method
              • Properties
                • Book Property
                • Count Property
                • Frozen Property
                • Item Property
                • Sheet Property
            • XLShape
              • Overview
              • Members
              • Methods
                • Clone Method
              • Properties
                • Column Property
                • DashedLineStyle Property
                • Hyperlink Property
                • Id Property
                • IsEmpty Property
                • LineColor Property
                • LineStyle Property
                • LineWidth Property
                • Rectangle Property
                • Rotation Property
                • Row Property
                • Sheet Property
                • Workbook Property
            • XLSheet
              • Overview
              • Members
              • Methods
                • Clone Method
                • CopyFormula Method
                • GetCell Method
                • GetFormattedText Method
                • GetRangeToRepeat Method
                • Load Method
                  • Load(String,Boolean) Method
                  • Load(Stream,Boolean) Method
                • LoadCsv Method
                  • LoadCsv(String) Method
                  • LoadCsv(Stream) Method
                • SaveCsv Method
                  • SaveCsv(String) Method
                  • SaveCsv(Stream) Method
                • SetRangeToRepeat Method
              • Properties
                • Book Property
                • ColumnMaxLevel Property
                • Columns Property
                • Comments Property
                • ConditionalFormattings Property
                • DefaultColumnWidth Property
                • DefaultRowHeight Property
                • GridColor Property
                • Item Property
                • Locked Property
                • MaxOutlineLevel Property
                • MergedCells Property
                • Name Property
                • OutlinesBelow Property
                • OutlinesRight Property
                • PageBreakPreview Property
                • PrintSettings Property
                • RowMaxLevel Property
                • Rows Property
                • Scale Property
                • SelectedCells Property
                • Shapes Property
                • ShowGridLines Property
                • ShowHeaders Property
                • ShowZeros Property
                • TabColor Property
                • TotalsBelowData Property
                • Visible Property
            • XLSheetCollection
              • Overview
              • Members
              • Methods
                • Add Method
                  • Add() Method
                  • Add(XLSheet) Method
                  • Add(String) Method
                • Clear Method
                • Contains Method
                  • Contains(XLSheet) Method
                  • Contains(String) Method
                • IndexOf Method
                  • IndexOf(XLSheet) Method
                  • IndexOf(String) Method
                • Insert Method
                  • Insert(Int32) Method
                  • Insert(Int32,XLSheet) Method
                • Remove Method
                  • Remove(XLSheet) Method
                  • Remove(String) Method
                • RemoveAt Method
              • Properties
                • Book Property
                • Count Property
                • FirstIndex Property
                • Item Property
                  • Item(Int32) Property
                  • Item(String) Property
                • SelectedIndex Property
            • XLStyle
              • Overview
              • Members
              • XLStyle Constructor
              • Methods
                • Clone Method
                • Equals Method
                • FormatDotNetToXL Method
                  • FormatDotNetToXL(String,Type) Method
                  • FormatDotNetToXL(String,Type,CultureInfo) Method
                  • FormatDotNetToXL(String) Method
                  • FormatDotNetToXL(String,CultureInfo) Method
                • FormatXLToDotNet Method
                  • FormatXLToDotNet(String) Method
                  • FormatXLToDotNet(String,CultureInfo) Method
                • GetHashCode Method
                • SetBorderColor Method
                • SetBorderStyle Method
              • Properties
                • AlignHorz Property
                • AlignVert Property
                • BackColor Property
                • BackPattern Property
                • BorderBottom Property
                • BorderColorBottom Property
                • BorderColorLeft Property
                • BorderColorRight Property
                • BorderColorTop Property
                • BorderLeft Property
                • BorderRight Property
                • BorderTop Property
                • Diagonal Property
                • DiagonalColor Property
                • DiagonalStyle Property
                • Direction Property
                • Font Property
                • ForeColor Property
                • Format Property
                • Indent Property
                • Locked Property
                • PatternColor Property
                • Rotation Property
                • ShrinkToFit Property
                • WordWrap Property
            • XLTextShape
              • Overview
              • Members
              • Properties
                • Bidirectional Property
                • BottomMargin Property
                • HorizAlign Property
                • LeftMargin Property
                • Locked Property
                • Orientation Property
                • RightMargin Property
                • Text Property
                • TextId Property
                • TextScale Property
                • TextToFit Property
                • TopMargin Property
                • VertAlign Property
                • Wrapped Property
          • Enumerations
            • CalculationMode
            • CompatibilityMode
            • ConsolidationFunction
            • FileFormat
            • ImageScaling
            • XLAlignHorzEnum
            • XLAlignVertEnum
            • XLConditionalFormattingOperator
            • XLConditionalFormattingType
            • XLDiagonalFlags
            • XLFontScript
            • XLHorizTextAlign
            • XLLineStyleEnum
            • XLPatternEnum
            • XLPictureViewType
            • XLRangeType
            • XLReadingDirection
            • XLReferenceMode
            • XLReferenceType
            • XLShapeDashedLineStyleEnum
            • XLShapeLineStyleEnum
            • XLTextOrientation
            • XLUnderlineStyle
            • XLVertTextAlign
          • Interfaces
            • ICloneable
              • Overview
              • Members
              • Methods
                • Clone Method