sync toc
Overview
Version history
License agreement
Trial User License
Registered User License
Site License
Contact us
Getting Started
Examples
Data alignment
Cell data types
Font formatting
Font features
Formula
Group rows and columns
Hyperlinks
Interior
Merged cells
NumberFormat
Split and Freeze
Images
Defined Names
View workbook using DataGrid
Order sample
Ten Times Table sample
Create new workbook
Open an existing workbook
Font formatting
ASP.NET Hello World
How to reference Cells and Ranges
Referring to Cells using A1 notation
Referring to Ranges using A1 notation
Referring to Cells by using Index numbers
Referring to Ranges by using Index numbers
Referring to Rows
Referring to Columns
Formatting Codes for Headers and Footers
NativeExcel Namespace
Enumerations
MsoLineDashStyle Enumeration
MsoLineStyle Enumeration
XlBordersIndex Enumeration
XlBorderWeight Enumeration
XlDeleteShiftDirection Enumeration
XlFileFormat Enumeration
XlHAlign Enumeration
XlInsertShiftDirection Enumeration
XlLineStyle Enumeration
XlPageOrientation Enumeration
XlPaperSize Enumeration
XlPasteType Enumeration
XlPattern Enumeration
XlReadingOrder Enumeration
XlReferenceStyle Enumeration
XlSheetVisibility Enumeration
XlSummaryColumn Enumeration
XlSummaryRow Enumeration
XlUnderlineStyle Enumeration
XlVAlign Enumeration
XlWindowView Enumeration
Factory Class
Factory Members
Properties
FormulaCompiler Property
Methods
CreateWorkbook Method
OpenWorkbook Method
OpenWorkbook Method (Stream)
OpenWorkbook Method (Stream, String)
OpenWorkbook Method (String)
OpenWorkbook Method (String, String)
FormulaCompilerSettings Class
FormulaCompilerSettings Members
Properties
DecimalSeparator Property
ListSeparator Property
IBorder Interface
IBorder Members
Properties
Color Property
ColorIndex Property
LineStyle Property
Weight Property
IBorders Interface
IBorders Members
Properties
Color Property
ColorIndex Property
Item Property
LineStyle Property
Weight Property
IColorFormat Interface
IColorFormat Members
Properties
RGB Property
SchemeColor Property
IComment Interface
IComment Members
Properties
Column Property
Row Property
Shape Property
Text Property
Visible Property
IFillFormat Interface
IFillFormat Members
Properties
BackColor Property
ForeColor Property
Visible Property
Methods
Solid Method
IFont Interface
IFont Members
Properties
Bold Property
Color Property
ColorIndex Property
Italic Property
Name Property
OutlineFont Property
Shadow Property
Size Property
Strikethrough Property
Subscript Property
Superscript Property
Underline Property
IHyperlink Interface
IHyperlink Members
Properties
Address Property
Range Property
ScreenTip Property
SubAddress Property
TextToDisplay Property
Methods
Delete Method
IHyperlinks Interface
IHyperlinks Members
Properties
Count Property
Item Property
Methods
Add Method
Add Method (Object, String)
Add Method (Object, String, String)
Add Method (Object, String, String, String)
Add Method (Object, String, String, String, String)
Delete Method
GetEnumerator Method
IInterior Interface
IInterior Members
Properties
Color Property
ColorIndex Property
Pattern Property
PatternColor Property
PatternColorIndex Property
ILineFormat Interface
ILineFormat Members
Properties
BackColor Property
DashStyle Property
ForeColor Property
Style Property
Visible Property
Weight Property
IName Interface
IName Members
Properties
Index Property
Name Property
RefersTo Property
Visible Property
Methods
Delete Method
INames Interface
INames Members
Properties
Count Property
Item Property
Item Property (Int32)
Item Property (String)
Methods
Add Method
Add Method (String, String)
Add Method (String, String, Boolean)
GetEnumerator Method
IOutline Interface
IOutline Members
Properties
SummaryColumn Property
SummaryRow Property
IPageBreak Interface
IPageBreak Members
Properties
Location Property
Methods
Delete Method
IPageBreaks Interface
IPageBreaks Members
Properties
Count Property
Item Property
Methods
Add Method
GetEnumerator Method
Reset Method
IPageSetup Interface
IPageSetup Members
Properties
BottomMargin Property
CenterFooter Property
CenterHeader Property
CenterHorizontally Property
CenterVertically Property
FitToPages Property
FitToPagesTall Property
FitToPagesWide Property
FooterMargin Property
HeaderMargin Property
LeftFooter Property
LeftHeader Property
LeftMargin Property
Orientation Property
PaperSize Property
PrintArea Property
PrintAreaDefined Property
PrintGridLines Property
PrintHeadings Property
PrintTitleColumns Property
PrintTitleColumnsDefined Property
PrintTitleRows Property
PrintTitleRowsDefined Property
RightFooter Property
RightHeader Property
RightMargin Property
TopMargin Property
Zoom Property
Methods
SetPrintArea Method
SetPrintTitleColumns Method
SetPrintTitleColumns Method ()
SetPrintTitleColumns Method (Int32)
SetPrintTitleColumns Method (Int32, Int32)
SetPrintTitleRows Method
SetPrintTitleRows Method ()
SetPrintTitleRows Method (Int32)
SetPrintTitleRows Method (Int32, Int32)
IPalette Interface
IPalette Members
Properties
Item Property
IPicture Interface
IPicture Members
Properties
TransparentColor Property
TransparentColorDefined Property
Methods
ClearTransparentColor Method
IRange Interface
IRange Members
Properties
Borders Property
Column Property
Columns Property
ColumnWidth Property
Comment Property
Count Property
DisplayValue Property
EntireColumn Property
EntireRow Property
Font Property
Formula Property
FormulaHidden Property
HasFormula Property
Height Property
HorizontalAlignment Property
Hyperlinks Property
Interior Property
Item Property
Item Property (Int32, Int32)
Item Property (Int32, Int32, Int32, Int32)
Item Property (String)
Item Property (String, String)
MergeArea Property
MergeCells Property
NumberFormat Property
Orientation Property
OutlineLevel Property
ReadingOrder Property
Row Property
RowHeight Property
Rows Property
ShrinkToFit Property
Value Property
VerticalAlignment Property
Width Property
WrapText Property
Methods
AddComment Method
AddComment Method ()
AddComment Method (String)
Autofit Method
Clear Method
ClearComments Method
ClearContents Method
ClearOutline Method
Copy Method
Copy Method (Object)
Copy Method (Object, XlPasteType)
Delete Method
Delete Method ()
Delete Method (XlDeleteShiftDirection)
GetDataTable Method
GetEnumerator Method
Group Method
Insert Method
Insert Method ()
Insert Method (XlInsertShiftDirection)
isIntersect Method
Merge Method
Merge Method ()
Merge Method (Boolean)
Move Method
Move Method (Object)
Move Method (Object, XlPasteType)
SaveAs Method
SaveAs Method (Stream, XlFileFormat)
SaveAs Method (String, XlFileFormat)
Select Method
SetDataTable Method
Ungroup Method
UnMerge Method
IRangeColumn Interface
IRangeColumn Members
Properties
Hidden Property
Item Property
OutlineLevel Property
Methods
ClearOutline Method
Delete Method
GetEnumerator Method
Group Method
Insert Method
Ungroup Method
IRangeColumns Interface
IRangeColumns Members
Properties
Count Property
Hidden Property
Item Property
Item Property (Int32)
Item Property (Int32, Int32)
OutlineLevel Property
Methods
ClearOutline Method
Delete Method
GetEnumerator Method
Group Method
Insert Method
Merge Method
Ungroup Method
IRangeRow Interface
IRangeRow Members
Properties
Hidden Property
Item Property
Methods
ClearOutline Method
GetEnumerator Method
IRangeRows Interface
IRangeRows Members
Properties
Count Property
Hidden Property
Item Property
Item Property (Int32)
Item Property (Int32, Int32)
Methods
Autofit Method
ClearOutline Method
GetEnumerator Method
Merge Method
IShape Interface
IShape Members
Properties
Fill Property
Height Property
Line Property
Visible Property
Widht Property
Methods
Delete Method
IShapes Interface
IShapes Members
Properties
Count Property
Item Property
Methods
AddPicture Method
AddPicture Method (Bitmap)
AddPicture Method (Stream)
AddPicture Method (String)
IWorkbook Interface
IWorkbook Members
Properties
NativeExcel Namespace
NativeExcel Namespace