ComponentOne Excel for .NET
Index
 
ActiveIndex Property
Add Method (ShapeCollection)
Add Method (XLCellRangeCollection)
Add Method (XLColumnCollection)
Add Method (XLCommentCollection)
Add Method (XLConditionalFormattingCollection)
Add Method (XLConditionalFormattingRangeCollection)
Add Method (XLConditionalFormattingRuleCollection)
Add Method (XLDataValidationCollection)
Add Method (XLDataValidationRangeCollection)
Add Method (XLNamedRangeCollection)
Add Method (XLRowCollection)
Add Method (XLSheetCollection)
Adding a Comment to a Cell
Adding a Page Break to a Worksheet
Adding an Image to a Cell
Adding Content to a Workbook
AlignHorz Property
AlignVert Property
AlignWithMargins Property
AllowBlank Property
API Reference
Author Property (C1XLBook)
Author Property (XLComment)
AutoScale Property
BackColor Property (XLPatternFormatting)
BackColor Property (XLStyle)
Background Property
BackPattern Property
BadFormatRunDataLenFmt Property
BadOpenXmlFile Property
BadParamInSheetCtor Property
BadParamInStyleCtor Property
Bidirectional Property
BlackAndWhite Property
Bold Property
Book Property (XLCellRange)
Book Property (XLCellRangeCollection)
Book Property (XLColumn)
Book Property (XLColumnCollection)
Book Property (XLDataValidation)
Book Property (XLNamedRange)
Book Property (XLNamedRangeCollection)
Book Property (XLRow)
Book Property (XLRowCollection)
Book Property (XLSheet)
Book Property (XLSheetCollection)
Border Property
BorderBottom Property
BorderColorBottom Property
BorderColorLeft Property
BorderColorRight Property
BorderColorTop Property
BorderLeft Property
BorderRight Property
BorderTop Property
BottomBorder Property
BottomClip Property
BottomColor Property
BottomMargin Property
Brightness Property
BrightnessInPercents Property
C1.C1Excel Namespace
Overview
C1.C1Excel.4.5.2 Assembly
Overview
C1XLBook Class
Members
Overview
C1XLBook Constructor (C1XLBook)
CalculationMode Enumeration
CalculationMode Property
CannotCreateStorageFile Property
CannotCreateStorageStream Property
CannotCreateStream Property
CannotOpenStorageFile Property
CannotOpenStream Property
CannotSaveBookTooManyCols Property
CannotSaveBookTooManyRows Property
CannotSaveBookTooManyStyles Property
CannotSaveEmptyBook Property
CannotSaveWithoutSheets Property
CannotSeekToEndOfStream Property
CannotSetStreamLength Property
Cell Property
CellCount Property
CellRange Property
CellRanges Property
Cells
CenterHorizontal Property
CenterVertical Property
Clear Method (C1XLBook)
Clear Method (XLCellRangeCollection)
Clear Method (XLColumnCollection)
Clear Method (XLCommentCollection)
Clear Method (XLConditionalFormattingCollection)
Clear Method (XLConditionalFormattingRangeCollection)
Clear Method (XLConditionalFormattingRuleCollection)
Clear Method (XLDataValidationCollection)
Clear Method (XLDataValidationRangeCollection)
Clear Method (XLNamedRangeCollection)
Clear Method (XLRowCollection)
Clear Method (XLSheetCollection)
Clone Method (C1XLBook)
Clone Method (XLCell)
Clone Method (XLCellRange)
Clone Method (XLColumn)
Clone Method (XLComment)
Clone Method (XLConditionalFormatting)
Clone Method (XLConditionalFormattingRule)
Clone Method (XLDataValidation)
Clone Method (XLNamedRange)
Clone Method (XLPrintSettings)
Clone Method (XLRange)
Clone Method (XLRow)
Clone Method (XLShape)
Clone Method (XLSheet)
Clone Method (XLStyle)
Clone Method (XLTextShape)
CodeName Property
Collapsed Property (XLColumn)
Collapsed Property (XLRow)
ColorFromIndex Method
Column Property
ColumnAlreadyInSheet Property
ColumnCount Property
ColumnFirst Property
ColumnFrom Property
ColumnFromOtherSheet Property
ColumnFromRef Property
ColumnIndex Property
ColumnLast Property
ColumnMaxLevel Property
Columns Property
ColumnTo Property
ColumnToRef Property
Comment Property
Comments Property
CompatibilityMode Enumeration
CompatibilityMode Property
ConditionalFormatting Property (XLConditionalFormattingRangeCollection)
ConditionalFormatting Property (XLConditionalFormattingRuleCollection)
ConditionalFormattings Property
ConsolidationFunction Enumeration
Container Property
Contains Method (ShapeCollection)
Contains Method (XLCellRange)
Contains Method (XLCellRangeCollection)
Contains Method (XLColumnCollection)
Contains Method (XLCommentCollection)
Contains Method (XLConditionalFormattingCollection)
Contains Method (XLConditionalFormattingRangeCollection)
Contains Method (XLConditionalFormattingRuleCollection)
Contains Method (XLDataValidationCollection)
Contains Method (XLDataValidationRangeCollection)
Contains Method (XLNamedRange)
Contains Method (XLNamedRangeCollection)
Contains Method (XLRowCollection)
Contains Method (XLSheetCollection)
Contrast Property
ContrastInPercents Property
Copies Property
CopyFormula Method
Copying a Sheet
Copying Rows from One Book to Another
CopyTo Method (XLConditionalFormattingCollection)
CopyTo Method (XLConditionalFormattingRangeCollection)
CopyTo Method (XLConditionalFormattingRuleCollection)
CopyTo Method (XLDataValidationCollection)
CopyTo Method (XLDataValidationRangeCollection)
Count Property (ShapeCollection)
Count Property (XLCellRangeCollection)
Count Property (XLColumnCollection)
Count Property (XLCommentCollection)
Count Property (XLConditionalFormattingCollection)
Count Property (XLConditionalFormattingRangeCollection)
Count Property (XLConditionalFormattingRuleCollection)
Count Property (XLDataValidationCollection)
Count Property (XLDataValidationRangeCollection)
Count Property (XLNamedRangeCollection)
Count Property (XLRowCollection)
Count Property (XLSheetCollection)
CreateObjRef Method
Creating Documents
Creating Subtotals
DashedLineStyle Property
DataValidation Property
DataValidations Property
DefaultColumnWidth Property
DefaultFont Property
DefaultRowHeight Property
Diagonal Property (XLBorderFormatting)
Diagonal Property (XLStyle)
DiagonalColor Property (XLBorderFormatting)
DiagonalColor Property (XLStyle)
DiagonalStyle Property (XLBorderFormatting)
DiagonalStyle Property (XLStyle)
Direction Property
DisablePrompts Property
Disposed Event
DraftQuality Property
DuplicateSheetName Property
Equals Method (XLRange)
Equals Method (XLStyle)
Error Property
ErrorStyle Property
ErrorTitle Property
Escapement Property
Excel for .NET Frequently Asked Questions
Excel for .NET Limitations
Excel for .NET Overview
Excel for .NET QuickStart
Excel for .NET Samples
Excel for .NET Task-Based Help
FileFormat Enumeration
FileName Property
FilePasswordProtected Property
FirstFormula Property (XLConditionalFormattingRule)
FirstFormula Property (XLDataValidation)
FirstIndex Property
FitPagesAcross Property
FitPagesDown Property
Font Property (XLConditionalFormattingRule)
Font Property (XLStyle)
FontColor Property
FontHeight Property
FontWeight Property
Footer Property
FooterEven Property
FooterFirst Property
FooterPictureCenter Property
FooterPictureLeft Property
FooterPictureRight Property
ForeColor Property (XLPatternFormatting)
ForeColor Property (XLStyle)
Format Property
FormatDotNetToXL Method
FormatJapaneseDateTime Method
Formatting Cells
FormatXLToDotNet Method
Formula Property
Frozen Property (XLColumnCollection)
Frozen Property (XLRowCollection)
GetCell Method
GetFormattedText Method
GetHashCode Method (XLRange)
GetHashCode Method (XLStyle)
GetLifetimeService Method
GetRangeToRepeat Method
Getting Print Area from a Sheet of Existing Excel File
GridColor Property
Header Property
HeaderEven Property
HeaderFirst Property
HeaderPictureCenter Property
HeaderPictureLeft Property
HeaderPictureRight Property
Height Property
Help with WinForms Edition
HideDropDown Property
HorizAlign Property
Hyperlink Property (XLCell)
Hyperlink Property (XLShape)
Id Property
Image Property
ImageScaling Enumeration
ImageSize Property
IMEMode Property
IMEModeType Enumeration
Importing and Exporting OpenXml Files
Indent Property
IndexFromColor Method
IndexOf Method (ShapeCollection)
IndexOf Method (XLCellRangeCollection)
IndexOf Method (XLColumnCollection)
IndexOf Method (XLCommentCollection)
IndexOf Method (XLConditionalFormattingCollection)
IndexOf Method (XLConditionalFormattingRangeCollection)
IndexOf Method (XLConditionalFormattingRuleCollection)
IndexOf Method (XLDataValidationCollection)
IndexOf Method (XLDataValidationRangeCollection)
IndexOf Method (XLNamedRangeCollection)
IndexOf Method (XLRowCollection)
IndexOf Method (XLSheetCollection)
InitializeLifetimeService Method
Insert Method (ShapeCollection)
Insert Method (XLCellRangeCollection)
Insert Method (XLColumnCollection)
Insert Method (XLCommentCollection)
Insert Method (XLConditionalFormattingCollection)
Insert Method (XLConditionalFormattingRangeCollection)
Insert Method (XLConditionalFormattingRuleCollection)
Insert Method (XLDataValidationCollection)
Insert Method (XLDataValidationRangeCollection)
Insert Method (XLNamedRangeCollection)
Insert Method (XLRowCollection)
Insert Method (XLSheetCollection)
Intersects Method
InvalidFileFormat Property
InvalidSheetName Property
IsAutoBackColor Property
IsBuiltInName Property
IsCustomHeight Property
IsEmpty Property (XLCellRange)
IsEmpty Property (XLCommentShape)
IsEmpty Property (XLConditionalFormattingRule)
IsEmpty Property (XLNamedRange)
IsEmpty Property (XLOpaqueShape)
IsEmpty Property (XLPictureShape)
IsEmpty Property (XLShape)
IsLoading Property
IsNameOnly Property
IsShow Property
IsSubtotal Property (XLColumn)
IsSubtotal Property (XLRow)
Italic Property
Item Property (ShapeCollection)
Item Property (XLCellRangeCollection)
Item Property (XLColumnCollection)
Item Property (XLCommentCollection)
Item Property (XLConditionalFormattingCollection)
Item Property (XLConditionalFormattingRangeCollection)
Item Property (XLConditionalFormattingRuleCollection)
Item Property (XLDataValidationCollection)
Item Property (XLDataValidationRangeCollection)
Item Property (XLNamedRangeCollection)
Item Property (XLRowCollection)
Item Property (XLSheet)
Item Property (XLSheetCollection)
KeepFormulas Property
Key Features
Landscape Property
LeftBorder Property
LeftClip Property
LeftColor Property
LeftMargin Property
LineColor Property
LineStyle Property
LineWidth Property
ListSeparator Property
Load Method (C1XLBook)
Load Method (XLSheet)
LoadCsv Method
Loading and Saving Macro enabled Excel Files
Locked Property (XLSheet)
Locked Property (XLStyle)
Locked Property (XLTextShape)
MarginBottom Property
MarginFooter Property
MarginHeader Property
MarginLeft Property
MarginRight Property
MarginTop Property
MaxNoOfSheetsExceeded Property
MaxOutlineLevel Property
MergedCells Property
Merging Cells
Name Property (XLNamedRange)
Name Property (XLSheet)
NamedRangeAlreadyInBook Property
NamedRanges Property
NegativeStartIndexOfCellRange Property
ObjectId Property
OpaqueCopy Property
Operator Property (XLConditionalFormattingRule)
Operator Property (XLDataValidation)
Orientation Property
OutlineLevel Property (XLColumn)
OutlineLevel Property (XLRow)
OutlinesBelow Property
OutlinesRight Property
PageBreak Property (XLColumn)
PageBreak Property (XLRow)
PageBreakPreview Property
Palette Property
PaperKind Property
Parameter Property
ParseRefers Method
Pattern Property (XLConditionalFormattingRule)
Pattern Property (XLPatternFormatting)
PatternColor Property
Percent Property
PixelsToTwips Method
PrintGridlines Property
PrintHeaders Property
PrintPagesInRows Property
PrintSettings Property
Priority Property
Progress Event
Prompt Property
PromptTitle Property
Ranges Property (XLConditionalFormatting)
Ranges Property (XLDataValidation)
RangeType Property
Rectangle Property
ReferenceMode Property
Refers Property
Remove Method (ShapeCollection)
Remove Method (XLCellRangeCollection)
Remove Method (XLColumnCollection)
Remove Method (XLCommentCollection)
Remove Method (XLConditionalFormattingCollection)
Remove Method (XLConditionalFormattingRangeCollection)
Remove Method (XLConditionalFormattingRuleCollection)
Remove Method (XLDataValidationCollection)
Remove Method (XLDataValidationRangeCollection)
Remove Method (XLNamedRangeCollection)
Remove Method (XLRowCollection)
Remove Method (XLSheetCollection)
RemoveAt Method (XLCellRangeCollection)
RemoveAt Method (XLColumnCollection)
RemoveAt Method (XLCommentCollection)
RemoveAt Method (XLConditionalFormattingCollection)
RemoveAt Method (XLConditionalFormattingRangeCollection)
RemoveAt Method (XLConditionalFormattingRuleCollection)
RemoveAt Method (XLDataValidationCollection)
RemoveAt Method (XLDataValidationRangeCollection)
RemoveAt Method (XLNamedRangeCollection)
RemoveAt Method (XLRowCollection)
RemoveAt Method (XLSheetCollection)
ResourceManager Property
RightBorder Property
RightClip Property
RightColor Property
RightMargin Property
Rotation Property (XLShape)
Rotation Property (XLStyle)
Row Property
RowAlreadyInSheet Property
RowCount Property
RowFirst Property
RowFrom Property
RowFromOtherSheet Property
RowFromRef Property
RowIndex Property
RowLast Property
RowMaxLevel Property
Rows and Columns
Rows Property
RowTo Property
RowToRef Property
Rules Property
Save Method
SaveCsv Method
Saving and Loading CSV Files
Scale Property
ScaleWithDocument Property
ScalingFactor Property
SecondFormula Property (XLConditionalFormattingRule)
SecondFormula Property (XLDataValidation)
SelectedCells Property
SelectedIndex Property
SelectedIndexes Property
SetBorderColor Method
SetBorderStyle Method
SetRangeToRepeat Method
Setting Print Area in a Sheet
Setting the Calculation Mode for a Workbook
SetValue Method
ShapeAlreadyInSheet Property
ShapeCollection Class
Members
Overview
Shapes Property
Sheet Property (ShapeCollection)
Sheet Property (XLCellRangeCollection)
Sheet Property (XLColumn)
Sheet Property (XLColumnCollection)
Sheet Property (XLComment)
Sheet Property (XLCommentCollection)
Sheet Property (XLConditionalFormattingCollection)
Sheet Property (XLDataValidationCollection)
Sheet Property (XLRow)
Sheet Property (XLRowCollection)
Sheet Property (XLShape)
SheetAlreadyInBook Property
SheetCount Property
SheetFrom Property
SheetFromOtherBook Property
SheetNameInUse Property
SheetNotFoundFmt Property
Sheets Property (C1XLBook)
Sheets Property (XLCellRange)
SheetTo Property
ShowErrorMessage Property
ShowGridLines Property
ShowHeaders Property
ShowInputMessage Property
ShowZeros Property
ShrinkToFit Property
Site Property
StartPage Property
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
Strikeout Property
Strings Class
Members
Overview
Style Property (XLCell)
Style Property (XLCellRange)
Style Property (XLColumn)
Style Property (XLRow)
Styles
TabColor Property
Text Property (XLCell)
Text Property (XLTextShape)
TextBox Property
TextId Property
TextScale Property
TextToFit Property
TooManyColsFmt Property
TooManyRowsFmt Property
TopBorder Property
TopClip Property
TopColor Property
TopMargin Property
ToString Method (C1XLBook)
ToString Method (XLCellRange)
ToString Method (XLConditionalFormattingRangeCollection)
ToString Method (XLDataValidationRangeCollection)
ToString Method (XLRange)
TotalsBelowData Property
ToughRecalc Property (XLConditionalFormattingRangeCollection)
ToughRecalc Property (XLDataValidationRangeCollection)
Transparent Property
TwipsToPixels Method
Type Property
UICulture Property
Underline Property
UseDefaultCsvEncoding Property
UseTempStorage Property
Using Excel for .NET
ValidationType Property
Value Property (XLCell)
Value Property (XLCellRange)
VertAlign Property
ViewLayout Enumeration
ViewLayout Property
ViewType Property
Visible Property (XLColumn)
Visible Property (XLCommentShape)
Visible Property (XLRow)
Visible Property (XLSheet)
Width Property
WordWrap Property
Workbook Property
WorkbookMustBeLoaded Property
Worksheets
Wrapped Property
XLAlignHorzEnum Enumeration
XLAlignVertEnum Enumeration
XLBorderFormatting Class
Members
Overview
XLBorderFormatting Constructor (XLBorderFormatting)
XLCell Class
Members
Overview
XLCellRange Class
Members
Overview
XLCellRange Constructor (XLCellRange)
XLCellRangeCollection Class
Members
Overview
XLColumn Class
Members
Overview
XLColumn Constructor (XLColumn)
XLColumnCollection Class
Members
Overview
XLComment Class
Members
Overview
XLComment Constructor (XLComment)
XLCommentCollection Class
Members
Overview
XLCommentShape Class
Members
Overview
XLCommentShape Constructor (XLCommentShape)
XLComparisonOperator Enumeration
XLConditionalFormatting Class
Members
Overview
XLConditionalFormatting Constructor (XLConditionalFormatting)
XLConditionalFormattingCollection Class
Members
Overview
XLConditionalFormattingOperator Enumeration
XLConditionalFormattingRangeCollection Class
Members
Overview
XLConditionalFormattingRule Class
Members
Overview
XLConditionalFormattingRule Constructor (XLConditionalFormattingRule)
XLConditionalFormattingRuleCollection Class
Members
Overview
XLConditionalFormattingType Enumeration
XLDataValidation Class
Members
Overview
XLDataValidation Constructor (XLDataValidation)
XLDataValidationCollection Class
Members
Overview
XLDataValidationRangeCollection Class
Members
Overview
XLDiagonalFlags Enumeration
XLErrorStyle Enumeration
XLFontFormatting Class
Members
Overview
XLFontFormatting Constructor (XLFontFormatting)
XLFontScript Enumeration
XLHorizTextAlign Enumeration
XLLineStyleEnum Enumeration
XLNamedRange Class
Members
Overview
XLNamedRangeCollection Class
Members
Overview
XLOpaqueShape Class
Members
Overview
XLPatternEnum Enumeration
XLPatternFormatting Class
Members
Overview
XLPatternFormatting Constructor (XLPatternFormatting)
XLPictureShape Class
Members
Overview
XLPictureShape Constructor (XLPictureShape)
XLPictureViewType Enumeration
XLPrintSettings Class
Members
Overview
XLPrintSettings Constructor (XLPrintSettings)
XLProgressEventArgs Class
Members
Overview
XLProgressEventHandler Delegate
XLRange Class
Members
Overview
XLRange Constructor (XLRange)
XLRangeType Enumeration
XLReadingDirection Enumeration
XLReferenceMode Enumeration
XLReferenceType Enumeration
XLRow Class
Members
Overview
XLRow Constructor (XLRow)
XLRowCollection Class
Members
Overview
XLShape Class
Members
Overview
XLShapeDashedLineStyleEnum Enumeration
XLShapeLineStyleEnum Enumeration
XLSheet Class
Members
Overview
XLSheetCollection Class
Members
Overview
XLStyle Class
Members
Overview
XLStyle Constructor (XLStyle)
XLTextOrientation Enumeration
XLTextShape Class
Members
Overview
XLUnderlineStyle Enumeration
XLValidationType Enumeration
XLVertTextAlign Enumeration
XWindow Property
YWindow Property