ComponentOne Excel for UWP
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 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
Excel for UWP Quick Start
Excel for UWP Task-Based Help
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