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 Page Break to a Worksheet
Adding Content to a Workbook
AlignHorz Property
AlignVert Property
AlignWithMargins Property
AllowBlank Property
Author Property (C1XLBook)
Author Property (XLComment)
AutoScale Property
BackColor Property (XLPatternFormatting)
BackColor Property (XLStyle)
Background Property
BackPattern 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.UWP.Excel Assembly

Overview

C1.Xaml.Excel Namespace

Overview

C1XLBook Class

Members
Overview

C1XLBook Constructor (C1XLBook)
CalculationMode Enumeration
CalculationMode 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)
ClearItems Method (XLConditionalFormattingCollection)
ClearItems Method (XLConditionalFormattingRangeCollection)
ClearItems Method (XLConditionalFormattingRuleCollection)
ClearItems Method (XLDataValidationCollection)
ClearItems Method (XLDataValidationRangeCollection)
Clone Method (C1XLBook)
Clone Method (ICloneable)
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
ColumnCount Property
ColumnFirst Property
ColumnFrom 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
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
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)
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
DraftQuality Property
Equals Method (XLFont)
Equals Method (XLRange)
Equals Method (XLStyle)
Error Property
ErrorStyle Property
ErrorTitle Property
Escapement Property
Excel for UWP Quick Start
Excel for UWP Task-Based Help
Excel Overview
FileFormat Enumeration
FileName Property
FirstFormula Property (XLConditionalFormattingRule)
FirstFormula Property (XLDataValidation)
FirstIndex Property
FitPagesAcross Property
FitPagesDown Property
Font Property (XLConditionalFormattingRule)
Font Property (XLStyle)
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
GetFormattedText Method
GetHashCode Method (XLFont)
GetHashCode Method (XLRange)
GetHashCode Method (XLStyle)
GridColor Property
Header Property
HeaderEven Property
HeaderFirst Property
HeaderPictureCenter Property
HeaderPictureLeft Property
HeaderPictureRight Property
Height Property
Help With UWP Edition
HideDropDown Property
HorizAlign Property
Hyperlink Property (XLCell)
Hyperlink Property (XLShape)
ICloneable Interface
Id Property
Image Property
ImageScaling Enumeration
ImageSize Property
IMEMode Property
IMEModeType Enumeration
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)
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)
InsertItem Method (XLConditionalFormattingCollection)
InsertItem Method (XLConditionalFormattingRangeCollection)
InsertItem Method (XLConditionalFormattingRuleCollection)
InsertItem Method (XLDataValidationCollection)
InsertItem Method (XLDataValidationRangeCollection)
Intersects Method
IsAutoBackColor Property
IsBuiltInName Property
IsCustomHeight Property
IsEmpty Property (XLCellRange)
IsEmpty Property (XLCommentShape)
IsEmpty Property (XLConditionalFormattingRule)
IsEmpty Property (XLNamedRange)
IsEmpty Property (XLPictureShape)
IsEmpty Property (XLShape)
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)
Items Property (XLConditionalFormattingCollection)
Items Property (XLConditionalFormattingRangeCollection)
Items Property (XLConditionalFormattingRuleCollection)
Items Property (XLDataValidationCollection)
Items Property (XLDataValidationRangeCollection)
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)
LoadAsync Method (C1XLBook)
LoadAsync Method (XLSheet)
LoadCsv Method
LoadCsvAsync Method
Locked Property (XLSheet)
Locked Property (XLStyle)
Locked Property (XLTextShape)
MarginBottom Property
MarginFooter Property
MarginHeader Property
MarginLeft Property
MarginRight Property
MarginTop Property
MaxOutlineLevel Property
MergedCells Property
Name Property (XLNamedRange)
Name Property (XLSheet)
NamedRanges Property
New Topic
ObjectId 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)
RemoveItem Method (XLConditionalFormattingCollection)
RemoveItem Method (XLConditionalFormattingRangeCollection)
RemoveItem Method (XLConditionalFormattingRuleCollection)
RemoveItem Method (XLDataValidationCollection)
RemoveItem Method (XLDataValidationRangeCollection)
RightBorder Property
RightClip Property
RightColor Property
RightMargin Property
Rotation Property (XLShape)
Rotation Property (XLStyle)
Row Property
RowCount Property
RowFirst Property
RowFrom Property
RowFromRef Property
RowIndex Property
RowLast Property
RowMaxLevel Property
Rows and Columns
Rows Property
RowTo Property
RowToRef Property
Rules Property
Save Method
SaveAsync Method
SaveCsv Method
SaveCsvAsync Method
Scale Property
ScaleWithDocument Property
ScalingFactor Property
Script Property
SecondFormula Property (XLConditionalFormattingRule)
SecondFormula Property (XLDataValidation)
SelectedCells Property
SelectedIndex Property
SelectedIndexes Property
SetBorderColor Method
SetBorderStyle Method
SetItem Method (XLConditionalFormattingCollection)
SetItem Method (XLConditionalFormattingRangeCollection)
SetItem Method (XLConditionalFormattingRuleCollection)
SetItem Method (XLDataValidationCollection)
SetItem Method (XLDataValidationRangeCollection)
Setting the Calculation Mode for a Workbook
SetValue Method
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)
SheetCount Property
SheetFrom Property
Sheets Property (C1XLBook)
Sheets Property (XLCellRange)
SheetTo Property
ShowErrorMessage Property
ShowGridLines Property
ShowHeaders Property
ShowInputMessage Property
ShowZeros Property
ShrinkToFit 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: Saving the XLSX File
Step 4 of 4: Run the Program
Strikeout Property (XLFont)
Strikeout Property (XLFontFormatting)
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
TopBorder Property
TopClip Property
TopColor Property
TopMargin Property
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
Underline Property (XLFont)
Underline Property (XLFontFormatting)
UseDefaultCsvEncoding Property
UseTempStorage Property
Using Excel for UWP
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
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
XLFont Class

Members
Overview

XLFont Constructor (XLFont)
XLFontFormatting Class

Members
Overview

XLFontFormatting Constructor (XLFontFormatting)
XLFontScript Enumeration
XLHorizTextAlign Enumeration
XLLineStyleEnum Enumeration
XLNamedRange Class

Members
Overview

XLNamedRangeCollection 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