ComponentOne Excel for .NET
Index
(Global) Namespace
Overview
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 (XLFont)
Bold Property (XLFontFormatting)
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.Excel Assembly
Overview
C1.Excel Namespace
Overview
C1.Util.Licensing Namespace
Overview
C1.Util.Localization Namespace
Overview
C1XLBook Class
Members
Overview
C1XLBook Constructor (C1XLBook)
Calculation Modes
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
CharSet 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)
ClearOpaqueData Method
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)
Color Property
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
Compatibility Modes
CompatibilityMode Enumeration
CompatibilityMode Property
Conditional Formatting
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
Copy Sheets
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
Data Validation
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
Dispose Method
Disposed Event
DraftQuality Property
DuplicateSheetName Property
Equals Method (XLFont)
Equals Method (XLRange)
Equals Method (XLStyle)
Error Property
ErrorStyle Property
ErrorTitle Property
Escapement Property
Excel for .NET Frequently Asked Questions
Excel for .NET Overview
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)
FontCharSet Property
FontColor Property
FontHeight Property
FontName Property
FontSize 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 (XLRow)
GetCell Method (XLSheet)
GetFormattedText Method
GetHashCode Method (XLFont)
GetHashCode Method (XLRange)
GetHashCode Method (XLStyle)
GetLifetimeService Method
GetMeasure Method
GetRangeToRepeat Method
GetRtf Method
Getting Print Area from a Sheet of Existing Excel File
GrapeCity.Common.Cryptography Namespace
Overview
GridColor Property
Groups and Subtotals
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
ImageFormat Enumeration
Images
ImageScaling Enumeration
ImageSize Property
IMEMode Property
IMEModeType Enumeration
Implicit Type Conversion Operator
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)
IsHiddenName Property
IsLoading Property
IsNameOnly Property
IsShow Property
IsSubtotal Property (XLColumn)
IsSubtotal Property (XLRow)
Italic Property (XLFont)
Italic Property (XLFontFormatting)
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
LicenseManager Class
Members
Overview
Limitations
LineColor Property
LineStyle Property
LineWidth Property
ListSeparator Property
Load
Load and Save
Load Method (C1XLBook)
Load Method (XLSheet)
LoadCsv Method
Loading and Saving Macro enabled Excel Files
Locked Property (XLSheet)
Locked Property (XLStyle)
Locked Property (XLTextShape)
Macro Property
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
Quick Start
QuotePrefix 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
Save Method
SaveCsv Method
Saving and Loading CSV Files
Scale Property
ScaleNormal Property
ScaleWithDocument Property
ScalingFactor Property
Script Property
SecondFormula Property (XLConditionalFormattingRule)
SecondFormula Property (XLDataValidation)
SelectedCells Property
SelectedIndex Property
SelectedIndexes Property
SetBorderColor Method
SetBorderStyle Method
SetDpi 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
SizeInPoints 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
StopIfTrue Property
Strikeout Property (XLFont)
Strikeout Property (XLFontFormatting)
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
TextLookup Property
TextScale Property
TextToFit Property
ToA1 Method
TooManyColsFmt Property
TooManyRowsFmt Property
TopBorder Property
TopClip Property
TopColor Property
TopMargin Property
ToR1C1 Method
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 (XLFont)
Underline Property (XLFontFormatting)
UseDefaultCsvEncoding Property
UseTempStorage Property
Using Excel for .NET
ValidationType Property
Value Property (XLCell)
Value Property (XLCellRange)
VertAlign Property
View Layouts
ViewLayout Enumeration
ViewLayout Property
ViewType Property
Visible Property (XLColumn)
Visible Property (XLCommentShape)
Visible Property (XLRow)
Visible Property (XLSheet)
Width Property
WordWrap Property
Workbook
Workbook Property
WorkbookMustBeLoaded Property
Worksheet
Worksheets
Wrapped Property
XLAlignHorz Enumeration
XLAlignVert Enumeration
XLBorderFormatting Class
Members
Overview
XLBorderFormatting Constructor (XLBorderFormatting)
XLCell Class
Members
Overview
XLCell Constructor (XLCell)
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
XLFont Class
Members
Overview
XLFont Constructor (XLFont)
XLFontFormatting Class
Members
Overview
XLFontFormatting Constructor (XLFontFormatting)
XLFontScript Enumeration
XLHorizTextAlign Enumeration
XLLineStyle Enumeration
XLNamedRange Class
Members
Overview
XLNamedRangeCollection Class
Members
Overview
XLOpaqueShape Class
Members
Overview
XLPattern 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
XLShapeDashedLineStyle Enumeration
XLShapeLineStyle 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