EPPlus 3.0

Download the archived PDF

OfficeOpenXml Namespace
eDataTypes Enumeration
EncryptionAlgorithm Enumeration
eOrientation Enumeration
ePageOrder Enumeration
ePaperSize Enumeration
eWorkSheetHidden Enumeration
ExcelAddress Class
ExcelAddress Members
ExcelAddress Constructor
ExcelAddress Constructor (String)
ExcelAddress Constructor (Int32, Int32, Int32, Int32)
ExcelAddress Methods
ExcelAddress Properties
Address Property
ExcelAddressBase Class
ExcelAddressBase Members
ExcelAddressBase Constructor
ExcelAddressBase Constructor (String)
ExcelAddressBase Constructor (Int32, Int32, Int32, Int32)
ExcelAddressBase Methods
ToString Method
ExcelAddressBase Properties
Address Property
End Property
IsName Property
Start Property
ExcelBackgroundImage Class
ExcelBackgroundImage Members
ExcelBackgroundImage Methods
SetFromFile Method
ExcelBackgroundImage Properties
Image Property
ExcelCalcMode Enumeration
ExcelCellAddress Class
ExcelCellAddress Members
ExcelCellAddress Constructor
ExcelCellAddress Constructor
ExcelCellAddress Constructor (String)
ExcelCellAddress Constructor (Int32, Int32)
ExcelCellAddress Methods
ExcelCellAddress Properties
Address Property
Column Property
IsRef Property
Row Property
ExcelCellBase Class
ExcelCellBase Members
ExcelCellBase Methods
GetAddress Method
GetAddress Method (Int32, Int32)
GetAddress Method (Int32, Int32, Boolean)
GetAddress Method (Int32, Boolean, Int32, Boolean)
GetAddress Method (Int32, Int32, Int32, Int32)
GetAddress Method (Int32, Int32, Int32, Int32, Boolean)
GetFullAddress Method
IsValidCellAddress Method
TranslateFromR1C1 Method
TranslateToR1C1 Method
ExcelColumn Class
ExcelColumn Members
ExcelColumn Methods
AutoFit Method
AutoFit Method
AutoFit Method (Double)
ToString Method
ExcelColumn Properties
BestFit Property
Collapsed Property
ColumnMax Property
ColumnMin Property
Hidden Property
OutlineLevel Property
PageBreak Property
Phonetic Property
Style Property
StyleID Property
StyleName Property
Width Property
ExcelComment Class
ExcelComment Members
ExcelComment Methods
ExcelComment Properties
Author Property
Font Property
RichText Property
Text Property
ExcelCommentCollection Class
ExcelCommentCollection Members
ExcelCommentCollection Methods
Add Method
Remove Method
RemoveAt Method
ExcelCommentCollection Properties
CommentXml Property
Count Property
Item Property
Item Property (ExcelCellAddress)
Item Property (Int32)
Worksheet Property
ExcelEncryption Class
ExcelEncryption Members
ExcelEncryption Methods
ExcelEncryption Properties
Algorithm Property
IsEncrypted Property
Password Property
ExcelHeaderFooter Class
ExcelHeaderFooter Members
ExcelHeaderFooter Fields
CurrentDate Field
CurrentTime Field
FileName Field
FilePath Field
FontColor Field
Image Field
NumberOfPages Field
OutlineStyle Field
PageNumber Field
ShadowStyle Field
SheetName Field
ExcelHeaderFooter Methods
ExcelHeaderFooter Properties
AlignWithMargins Property
differentFirst Property
differentOddEven Property
EvenFooter Property
EvenHeader Property
FirstFooter Property
FirstHeader Property
OddFooter Property
OddHeader Property
Pictures Property
ExcelHeaderFooterText Class
ExcelHeaderFooterText Members
ExcelHeaderFooterText Fields
CenteredText Field
LeftAlignedText Field
RightAlignedText Field
ExcelHeaderFooterText Methods
InsertPicture Method
InsertPicture Method (Image, PictureAlignment)
InsertPicture Method (FileInfo, PictureAlignment)
ExcelHyperLink Class
ExcelHyperLink Members
ExcelHyperLink Constructor
ExcelHyperLink Constructor (String)
ExcelHyperLink Constructor (String, Boolean)
ExcelHyperLink Constructor (String, String)
ExcelHyperLink Constructor (String, UriKind)
ExcelHyperLink Methods
ExcelHyperLink Properties
ColSpann Property
Display Property
ReferenceAddress Property
RowSpann Property
ToolTip Property
ExcelNamedRange Class
ExcelNamedRange Members
ExcelNamedRange Constructor
ExcelNamedRange Methods
AutoFitColumns Method
LoadFromCollection Method
LoadFromDataTable Method
LoadFromText Method
Offset Method
ExcelNamedRange Properties
IsNameHidden Property
LocalSheetId Property
Name Property
NameComment Property
ExcelNamedRangeCollection Class
ExcelNamedRangeCollection Members
ExcelNamedRangeCollection Methods
Add Method
AddFormla Method
AddValue Method
ContainsKey Method
GetEnumerator Method
Remove Method
ExcelNamedRangeCollection Properties
Count Property
Item Property
ExcelPackage Class
ExcelPackage Members
ExcelPackage Constructor
ExcelPackage Constructor
ExcelPackage Constructor (FileInfo)
ExcelPackage Constructor (Stream)
ExcelPackage Constructor (FileInfo, Boolean)
ExcelPackage Constructor (FileInfo, FileInfo)
ExcelPackage Constructor (FileInfo, String)
ExcelPackage Constructor (Stream, Stream)
ExcelPackage Constructor (Stream, String)
ExcelPackage Constructor (FileInfo, Boolean, String)
ExcelPackage Constructor (FileInfo, FileInfo, String)
ExcelPackage Constructor (Stream, Stream, String)
ExcelPackage Fields
MaxColumns Field
MaxRows Field
ExcelPackage Methods
Dispose Method
GetAsByteArray Method
GetAsByteArray Method
GetAsByteArray Method (String)
Load Method
Load Method (Stream)
Load Method (Stream, String)
Save Method
Save Method
Save Method (String)
SaveAs Method
SaveAs Method (FileInfo)
SaveAs Method (Stream)
SaveAs Method (FileInfo, String)
SaveAs Method (Stream, String)
ExcelPackage Properties
Compression Property
DoAdjustDrawings Property
Encryption Property
File Property
Package Property
Stream Property
Workbook Property
ExcelPrinterSettings Class
ExcelPrinterSettings Members
ExcelPrinterSettings Methods
ExcelPrinterSettings Properties
BlackAndWhite Property
BottomMargin Property
Draft Property
FitToHeight Property
FitToPage Property
FitToWidth Property
FooterMargin Property
HeaderMargin Property
HorizontalCentered Property
LeftMargin Property
Orientation Property
PageOrder Property
PaperSize Property
PrintArea Property
RepeatColumns Property
RepeatRows Property
RightMargin Property
Scale Property
ShowGridLines Property
ShowHeaders Property
TopMargin Property
VerticalCentered Property
ExcelProtection Class
ExcelProtection Members
ExcelProtection Methods
SetPassword Method
ExcelProtection Properties
LockRevision Property
LockStructure Property
LockWindows Property
ExcelRange Class
ExcelRange Members
ExcelRange Methods
AutoFitColumns Method
LoadFromCollection Method
LoadFromDataTable Method
LoadFromText Method
Offset Method
ExcelRange Properties
Item Property
Item Property (String)
Item Property (Int32, Int32)
Item Property (Int32, Int32, Int32, Int32)
ExcelRangeBase Class
ExcelRangeBase Members
ExcelRangeBase Methods
AddComment Method
AutoFitColumns Method
AutoFitColumns Method
AutoFitColumns Method (Double)
Clear Method
Copy Method
CreateArrayFormula Method
Dispose Method
GetEnumerator Method
GetValue(T) Method
LoadFromArrays Method
LoadFromCollection Method
LoadFromCollection(T) Method (IEnumerable(T))
LoadFromCollection(T) Method (IEnumerable(T), Boolean)
LoadFromCollection(T) Method (IEnumerable(T), Boolean, TableStyles)
LoadFromCollection(T) Method (IEnumerable(T), Boolean, TableStyles, BindingFlags, MemberInfo[])
LoadFromDataTable Method
LoadFromDataTable Method (DataTable, Boolean)
LoadFromDataTable Method (DataTable, Boolean, TableStyles)
LoadFromText Method
LoadFromText Method (FileInfo)
LoadFromText Method (String)
LoadFromText Method (FileInfo, ExcelTextFormat)
LoadFromText Method (String, ExcelTextFormat)
LoadFromText Method (FileInfo, ExcelTextFormat, TableStyles, Boolean)
LoadFromText Method (String, ExcelTextFormat, TableStyles, Boolean)
MoveNext Method
Offset Method
Offset Method (Int32, Int32)
Offset Method (Int32, Int32, Int32, Int32)
Reset Method
ExcelRangeBase Properties
AutoFilter Property
Comment Property
Current Property
DataValidation Property
Formula Property
FormulaR1C1 Property
FullAddress Property
FullAddressAbsolute Property
Hyperlink Property
IsArrayFormula Property
IsRichText Property
Merge Property
RichText Property
Style Property
StyleID Property
StyleName Property
Text Property
Value Property
Worksheet Property
ExcelRow Class
ExcelRow Members
ExcelRow Methods
ExcelRow Properties
Collapsed Property
CustomHeight Property
Height Property
Hidden Property
OutlineLevel Property
PageBreak Property
Phonetic Property
Row Property
RowID Property
Style Property
StyleID Property
StyleName Property
ExcelSheetProtection Class
ExcelSheetProtection Members
ExcelSheetProtection Methods
SetPassword Method
ExcelSheetProtection Properties
AllowAutoFilter Property
AllowDeleteColumns Property
AllowDeleteRows Property
AllowEditObject Property
AllowEditScenarios Property
AllowFormatCells Property
AllowFormatColumns Property
AllowFormatRows Property
AllowInsertColumns Property
AllowInsertHyperlinks Property
AllowInsertRows Property
AllowPivotTables Property
AllowSelectLockedCells Property
AllowSelectUnlockedCells Property
AllowSort Property
IsProtected Property
ExcelStyleCollection(T) Class
ExcelStyleCollection(T) Members
ExcelStyleCollection(T) Constructor
ExcelStyleCollection(T) Constructor
ExcelStyleCollection(T) Constructor (Boolean)
ExcelStyleCollection(T) Methods
GetEnumerator Method
ExcelStyleCollection(T) Properties
Count Property
Item Property
TopNode Property
ExcelStyles Class
ExcelStyles Members
ExcelStyles Fields
Borders Field
CellStyleXfs Field
CellXfs Field
Fills Field
Fonts Field
NamedStyles Field
NumberFormats Field
ExcelStyles Methods
CreateNamedStyle Method
CreateNamedStyle Method (String)
CreateNamedStyle Method (String, ExcelStyle)
UpdateXml Method
ExcelTextFormat Class
ExcelTextFormat Members
ExcelTextFormat Constructor
ExcelTextFormat Methods
ExcelTextFormat Properties
Culture Property
DataTypes Property
Delimiter Property
Encoding Property
EOL Property
SkipLinesBeginning Property
SkipLinesEnd Property
TextQualifier Property
ExcelWorkbook Class
ExcelWorkbook Members
ExcelWorkbook Methods
ExcelWorkbook Properties
CalcMode Property
MaxFontWidth Property
Names Property
Properties Property
Protection Property
Styles Property
StylesXml Property
View Property
WorkbookXml Property
Worksheets Property
ExcelWorkbookView Class
ExcelWorkbookView Members
ExcelWorkbookView Methods
SetWindowSize Method
ExcelWorkbookView Properties
Height Property
Left Property
Minimized Property
ShowHorizontalScrollBar Property
ShowSheetTabs Property
ShowVerticalScrollBar Property
Top Property
Width Property
ExcelWorksheet Class
ExcelWorksheet Members
ExcelWorksheet Constructor
ExcelWorksheet Methods
Column Method
DeleteRow Method
DeleteRow Method (Int32, Int32)
DeleteRow Method (Int32, Int32, Boolean)
GetValue Method
GetValue Method (Int32, Int32)
GetValue(T) Method (Int32, Int32)
InsertRow Method
InsertRow Method (Int32, Int32)
InsertRow Method (Int32, Int32, Int32)
Row Method
Select Method
Select Method (ExcelAddress)
Select Method (String)
Select Method (ExcelAddress, Boolean)
Select Method (String, Boolean)
SetValue Method
SetValue Method (String, Object)
SetValue Method (Int32, Int32, Object)
ToString Method
ExcelWorksheet Properties
AutoFilterAddress Property
BackgroundImage Property
Cells Property
Comments Property
DataValidations Property
DefaultColWidth Property
DefaultRowHeight Property
Dimension Property
Drawings Property
HeaderFooter Property
Hidden Property
Index Property
MergedCells Property
Name Property
Names Property
OutLineApplyStyle Property
OutLineSummaryBelow Property
OutLineSummaryRight Property
PivotTables Property
PrinterSettings Property
Protection Property
SelectedRange Property
TabColor Property
Tables Property
View Property
Workbook Property
WorksheetXml Property
ExcelWorksheet.MergeCellsCollection(T) Class
ExcelWorksheet.MergeCellsCollection(T) Members
ExcelWorksheet.MergeCellsCollection(T) Methods
GetEnumerator Method
ExcelWorksheet.MergeCellsCollection(T) Properties
Count Property
Item Property
ExcelWorksheets Class
ExcelWorksheets Members
ExcelWorksheets Methods
Add Method
Add Method (String)
Add Method (String, ExcelWorksheet)
Copy Method
Delete Method
Delete Method (ExcelWorksheet)
Delete Method (Int32)
Delete Method (String)
GetEnumerator Method
MoveAfter Method
MoveAfter Method (Int32, Int32)
MoveAfter Method (String, String)
MoveBefore Method
MoveBefore Method (Int32, Int32)
MoveBefore Method (String, String)
MoveToEnd Method
MoveToEnd Method (Int32)
MoveToEnd Method (String)
MoveToStart Method
MoveToStart Method (Int32)
MoveToStart Method (String)
ExcelWorksheets Properties
Count Property
Item Property
Item Property (Int32)
Item Property (String)
ExcelWorksheetView Class
ExcelWorksheetView Members
ExcelWorksheetView Methods
FreezePanes Method
UnFreezePanes Method
ExcelWorksheetView Properties
ActiveCell Property
PageBreakView Property
PageLayoutView Property
Panes Property
RightToLeft Property
SelectedRange Property
ShowGridLines Property
ShowHeaders Property
TabSelected Property
ZoomScale Property
ExcelWorksheetView.ExcelWorksheetPanes Class
ExcelWorksheetView.ExcelWorksheetPanes Members
ExcelWorksheetView.ExcelWorksheetPanes Methods
ExcelWorksheetView.ExcelWorksheetPanes Properties
ActiveCell Property
SelectedRange Property
OfficeProperties Class
OfficeProperties Members
OfficeProperties Methods
GetCustomPropertyValue Method
SetCustomPropertyValue Method
OfficeProperties Properties
Application Property
AppVersion Property
Author Property
Category Property
Comments Property
Company Property
CorePropertiesXml Property
CustomPropertiesXml Property
ExtendedPropertiesXml Property
HyperlinkBase Property
Keywords Property
LastModifiedBy Property
LastPrinted Property
Manager Property
Status Property
Subject Property
Title Property
PictureAlignment Enumeration
XmlHelper Class
XmlHelper Members
XmlHelper Methods
OfficeOpenXml.DataValidation Namespace
eDataValidationType Enumeration
ExcelDataValidation Class
ExcelDataValidation Members
ExcelDataValidation Methods
Validate Method
ExcelDataValidation Properties
Address Property
AllowBlank Property
AllowsOperator Property
Error Property
ErrorStyle Property
ErrorTitle Property
Operator Property
Prompt Property
PromptTitle Property
ShowErrorMessage Property
ShowInputMessage Property
ValidationType Property
ExcelDataValidationCollection Class
ExcelDataValidationCollection Members
ExcelDataValidationCollection Methods
AddCustomValidation Method
AddDateTimeValidation Method
AddDecimalValidation Method
AddIntegerValidation Method
AddListValidation Method
AddTextLengthValidation Method
AddTimeValidation Method
Clear Method
Find Method
FindAll Method
Remove Method
RemoveAll Method
ExcelDataValidationCollection Properties
Count Property
Item Property
Item Property (Int32)
Item Property (String)
ExcelDataValidationCustom Class
ExcelDataValidationCustom Members
ExcelDataValidationCustom Methods
ExcelDataValidationCustom Properties
ExcelDataValidationDateTime Class
ExcelDataValidationDateTime Members
ExcelDataValidationDateTime Methods
ExcelDataValidationDateTime Properties
ExcelDataValidationDecimal Class
ExcelDataValidationDecimal Members
ExcelDataValidationDecimal Methods
ExcelDataValidationDecimal Properties
ExcelDataValidationInt Class
ExcelDataValidationInt Members
ExcelDataValidationInt Methods
ExcelDataValidationInt Properties
ExcelDataValidationList Class
ExcelDataValidationList Members
ExcelDataValidationList Methods
ExcelDataValidationList Properties
ExcelDataValidationOperator Enumeration
ExcelDataValidationTime Class
ExcelDataValidationTime Members
ExcelDataValidationTime Methods
ExcelDataValidationTime Properties
ExcelDataValidationType Class
ExcelDataValidationType Members
ExcelDataValidationType Methods
Equals Method
GetHashCode Method
ExcelDataValidationType Properties
Custom Property
DateTime Property
Decimal Property
List Property
TextLength Property
Time Property
Type Property
Whole Property
ExcelDataValidationWarningStyle Enumeration
ExcelDataValidationWithFormula(T) Class
ExcelDataValidationWithFormula(T) Members
ExcelDataValidationWithFormula(T) Methods
Validate Method
ExcelDataValidationWithFormula(T) Properties
Formula Property
ExcelDataValidationWithFormula2(T) Class
ExcelDataValidationWithFormula2(T) Members
ExcelDataValidationWithFormula2(T) Methods
ExcelDataValidationWithFormula2(T) Properties
Formula2 Property
ExcelTime Class
ExcelTime Members
ExcelTime Constructor
ExcelTime Constructor
ExcelTime Constructor (Decimal)
ExcelTime Fields
NumberOfDecimals Field
ExcelTime Methods
ToExcelString Method
ToExcelTime Method
ToString Method
ExcelTime Properties
Hour Property
Minute Property
Second Property
IRangeDataValidation Interface
IRangeDataValidation Members
IRangeDataValidation Methods
AddCustomDataValidation Method
AddDateTimeDataValidation Method
AddDecimalDataValidation Method
AddIntegerDataValidation Method
AddListDataValidation Method
AddTextLengthDataValidation Method
AddTimeDataValidation Method
OfficeOpenXml.DataValidation.Contracts Namespace
IExcelDataValidation Interface
IExcelDataValidation Members
IExcelDataValidation Methods
Validate Method
IExcelDataValidation Properties
Address Property
AllowBlank Property
AllowsOperator Property
Error Property
ErrorStyle Property
ErrorTitle Property
Prompt Property
PromptTitle Property
ShowErrorMessage Property
ShowInputMessage Property
ValidationType Property
IExcelDataValidationCustom Interface
IExcelDataValidationCustom Members
IExcelDataValidationCustom Methods
IExcelDataValidationCustom Properties
IExcelDataValidationDateTime Interface
IExcelDataValidationDateTime Members
IExcelDataValidationDateTime Methods
IExcelDataValidationDateTime Properties
IExcelDataValidationDecimal Interface
IExcelDataValidationDecimal Members
IExcelDataValidationDecimal Methods
IExcelDataValidationDecimal Properties
IExcelDataValidationInt Interface
IExcelDataValidationInt Members
IExcelDataValidationInt Methods
IExcelDataValidationInt Properties
IExcelDataValidationList Interface
IExcelDataValidationList Members
IExcelDataValidationList Methods
IExcelDataValidationList Properties
IExcelDataValidationTime Interface
IExcelDataValidationTime Members
IExcelDataValidationTime Methods
IExcelDataValidationTime Properties
IExcelDataValidationWithFormula(T) Interface
IExcelDataValidationWithFormula(T) Members
IExcelDataValidationWithFormula(T) Methods
IExcelDataValidationWithFormula(T) Properties
Formula Property
IExcelDataValidationWithFormula2(T) Interface
IExcelDataValidationWithFormula2(T) Members
IExcelDataValidationWithFormula2(T) Methods
IExcelDataValidationWithFormula2(T) Properties
Formula2 Property
IExcelDataValidationWithOperator Interface
IExcelDataValidationWithOperator Members
IExcelDataValidationWithOperator Properties
Operator Property
OfficeOpenXml.DataValidation.Formulas.Contracts Namespace
IExcelDataValidationFormula Interface
IExcelDataValidationFormula Members
IExcelDataValidationFormula Properties
ExcelFormula Property
IExcelDataValidationFormulaDateTime Interface
IExcelDataValidationFormulaDateTime Members
IExcelDataValidationFormulaDateTime Properties
IExcelDataValidationFormulaDecimal Interface
IExcelDataValidationFormulaDecimal Members
IExcelDataValidationFormulaDecimal Properties
IExcelDataValidationFormulaInt Interface
IExcelDataValidationFormulaInt Members
IExcelDataValidationFormulaInt Properties
IExcelDataValidationFormulaList Interface
IExcelDataValidationFormulaList Members
IExcelDataValidationFormulaList Properties
Values Property
IExcelDataValidationFormulaTime Interface
IExcelDataValidationFormulaTime Members
IExcelDataValidationFormulaTime Properties
IExcelDataValidationFormulaWithValue(T) Interface
IExcelDataValidationFormulaWithValue(T) Members
IExcelDataValidationFormulaWithValue(T) Properties
Value Property
OfficeOpenXml.Drawing Namespace
eEditAs Enumeration
eLineCap Enumeration
eLineStyle Enumeration
eTextAnchoringType Enumeration
eTextVerticalType Enumeration
ExcelDrawing Class
ExcelDrawing Members
ExcelDrawing Fields
EMU_PER_PIXEL Field
ExcelDrawing Methods
SetPosition Method
SetPosition Method (Int32, Int32)
SetPosition Method (Int32, Int32, Int32, Int32)
SetSize Method
SetSize Method (Int32)
SetSize Method (Int32, Int32)
ExcelDrawing Properties
EditAs Property
From Property
Locked Property
Name Property
Print Property
To Property
ExcelDrawing.ExcelPosition Class
ExcelDrawing.ExcelPosition Members
ExcelDrawing.ExcelPosition Methods
ExcelDrawing.ExcelPosition Properties
Column Property
ColumnOff Property
Row Property
RowOff Property
ExcelDrawingBorder Class
ExcelDrawingBorder Members
ExcelDrawingBorder Methods
ExcelDrawingBorder Properties
Fill Property
LineCap Property
LineStyle Property
Width Property
ExcelDrawingFill Class
ExcelDrawingFill Members
ExcelDrawingFill Methods
ExcelDrawingFill Properties
Color Property
Style Property
Transparancy Property
ExcelDrawings Class
ExcelDrawings Members
ExcelDrawings Methods
AddChart Method
AddChart Method (String, eChartType)
AddChart Method (String, eChartType, ExcelPivotTable)
AddPicture Method
AddPicture Method (String, Image)
AddPicture Method (String, FileInfo)
AddShape Method
GetEnumerator Method
ExcelDrawings Properties
Count Property
DrawingXml Property
Item Property
Item Property (Int32)
Item Property (String)
NameSpaceManager Property
UriDrawing Property
ExcelPicture Class
ExcelPicture Members
ExcelPicture Methods
SetPosition Method
SetSize Method
SetSize Method (Int32)
ExcelPicture Properties
Border Property
Fill Property
Image Property
ImageFormat Property
ExcelShape Class
ExcelShape Members
ExcelShape Methods
SetPosition Method
SetSize Method
ExcelShape Properties
Border Property
Fill Property
Font Property
Indent Property
LockText Property
RichText Property
Style Property
Text Property
TextAlignment Property
TextAnchoring Property
TextAnchoringControl Property
TextVertical Property
ExcelView3D Class
ExcelView3D Members
ExcelView3D Methods
ExcelView3D Properties
DepthPercent Property
HeightPercent Property
Perspective Property
RightAngleAxes Property
RotX Property
RotY Property
OfficeOpenXml.Drawing.Chart Namespace
eAxisOrientation Enumeration
eAxisPosition Enumeration
eAxisTickMark Enumeration
eChartStyle Enumeration
eChartType Enumeration
eCrossBetween Enumeration
eCrosses Enumeration
eDirection Enumeration
eDisplayBlanksAs Enumeration
eGrouping Enumeration
eLabelPosition Enumeration
eLegendPosition Enumeration
eMarkerStyle Enumeration
ePieType Enumeration
eScatterStyle Enumeration
eShape Enumeration
eTickLabelPosition Enumeration
eTrendLine Enumeration
eXAxisPosition Enumeration
ExcelBarChart Class
ExcelBarChart Members
ExcelBarChart Methods
SetPosition Method
SetSize Method
ExcelBarChart Properties
DataLabel Property
Direction Property
Shape Property
ExcelChart Class
ExcelChart Members
ExcelChart Methods
SetPosition Method
SetSize Method
ExcelChart Properties
Axis Property
Border Property
ChartType Property
ChartXml Property
DisplayBlanksAs Property
Fill Property
Grouping Property
Legend Property
PivotTableSource Property
PlotArea Property
Series Property
ShowHiddenData Property
Style Property
Title Property
UseSecondaryAxis Property
VaryColors Property
View3D Property
WorkSheet Property
XAxis Property
YAxis Property
ExcelChartAxis Class
ExcelChartAxis Members
ExcelChartAxis Methods
ExcelChartAxis Properties
AxisPosition Property
Border Property
CrossBetween Property
Crosses Property
CrossesAt Property
Deleted Property
Fill Property
Font Property
Format Property
LabelPosition Property
LogBase Property
MajorTickMark Property
MajorUnit Property
MaxValue Property
MinorTickMark Property
MinorUnit Property
MinValue Property
Orientation Property
TickLabelPosition Property
ExcelChartCollection Class
ExcelChartCollection Members
ExcelChartCollection Methods
Add Method
ExcelChartCollection Properties
Count Property
Item Property
ExcelChartDataLabel Class
ExcelChartDataLabel Members
ExcelChartDataLabel Methods
ExcelChartDataLabel Properties
Border Property
Fill Property
Font Property
Separator Property
ShowBubbleSize Property
ShowCategory Property
ShowLeaderLines Property
ShowLegendKey Property
ShowPercent Property
ShowSeriesName Property
ShowValue Property
ExcelChartLegend Class
ExcelChartLegend Members
ExcelChartLegend Methods
Add Method
Remove Method
ExcelChartLegend Properties
Border Property
Fill Property
Font Property
Overlay Property
Position Property
ExcelChartPlotArea Class
ExcelChartPlotArea Members
ExcelChartPlotArea Methods
ExcelChartPlotArea Properties
Border Property
ChartTypes Property
Fill Property
ExcelChartSerie Class
ExcelChartSerie Members
ExcelChartSerie Methods
ExcelChartSerie Properties
Header Property
HeaderAddress Property
Series Property
TrendLines Property
XSeries Property
ExcelChartSerieDataLabel Class
ExcelChartSerieDataLabel Members
ExcelChartSerieDataLabel Methods
ExcelChartSerieDataLabel Properties
Border Property
Fill Property
Font Property
Position Property
ExcelChartSeries Class
ExcelChartSeries Members
ExcelChartSeries Methods
Add Method
Add Method (ExcelRangeBase, ExcelRangeBase)
Add Method (String, String)
Delete Method
GetEnumerator Method
ExcelChartSeries Properties
Chart Property
Count Property
Item Property
ExcelChartTitle Class
ExcelChartTitle Members
ExcelChartTitle Methods
ExcelChartTitle Properties
Border Property
Fill Property
Font Property
Overlay Property
RichText Property
Text Property
ExcelChartTrendline Class
ExcelChartTrendline Members
ExcelChartTrendline Methods
ExcelChartTrendline Properties
Backward Property
DisplayEquation Property
DisplayRSquaredValue Property
Forward Property
Intercept Property
Name Property
Order Property
Period Property
Type Property
ExcelChartTrendlineCollection Class
ExcelChartTrendlineCollection Members
ExcelChartTrendlineCollection Methods
Add Method
ExcelDoughnutChart Class
ExcelDoughnutChart Members
ExcelDoughnutChart Methods
SetPosition Method
SetSize Method
ExcelDoughnutChart Properties
FirstSliceAngle Property
HoleSize Property
ExcelLineChart Class
ExcelLineChart Members
ExcelLineChart Methods
SetPosition Method
SetSize Method
ExcelLineChart Properties
DataLabel Property
Marker Property
Smooth Property
ExcelLineChartSerie Class
ExcelLineChartSerie Members
ExcelLineChartSerie Methods
ExcelLineChartSerie Properties
DataLabel Property
Marker Property
Smooth Property
ExcelOfPieChart Class
ExcelOfPieChart Members
ExcelOfPieChart Methods
SetPosition Method
SetSize Method
ExcelOfPieChart Properties
OfPieType Property
ExcelPieChart Class
ExcelPieChart Members
ExcelPieChart Methods
SetPosition Method
SetSize Method
ExcelPieChart Properties
DataLabel Property
ExcelPieChartSerie Class
ExcelPieChartSerie Members
ExcelPieChartSerie Methods
ExcelPieChartSerie Properties
DataLabel Property
Explosion Property
ExcelScatterChart Class
ExcelScatterChart Members
ExcelScatterChart Methods
SetPosition Method
SetSize Method
ExcelScatterChart Properties
Marker Property
ScatterStyle Property
ExcelScatterChartSerie Class
ExcelScatterChartSerie Members
ExcelScatterChartSerie Methods
ExcelScatterChartSerie Properties
DataLabel Property
Marker Property
Smooth Property
eYAxisPosition Enumeration
OfficeOpenXml.Drawing.Vml Namespace
eLineStyleVml Enumeration
eTextAlignHorizontalVml Enumeration
eTextAlignVerticalVml Enumeration
ExcelVmlDrawingBase Class
ExcelVmlDrawingBase Members
ExcelVmlDrawingBase Methods
ExcelVmlDrawingBase Properties
Id Property
ExcelVmlDrawingBaseCollection Class
ExcelVmlDrawingBaseCollection Members
ExcelVmlDrawingBaseCollection Methods
ExcelVmlDrawingComment Class
ExcelVmlDrawingComment Members
ExcelVmlDrawingComment Methods
ExcelVmlDrawingComment Properties
AutoFit Property
BackgroundColor Property
From Property
HorizontalAlignment Property
Id Property
LineColor Property
LineStyle Property
LineWidth Property
Locked Property
LockText Property
To Property
VerticalAlignment Property
Visible Property
ExcelVmlDrawingPicture Class
ExcelVmlDrawingPicture Members
ExcelVmlDrawingPicture Methods
ExcelVmlDrawingPicture Properties
BiLevel Property
BlackLevel Property
Gain Property
Gamma Property
GrayScale Property
Height Property
Image Property
Left Property
Position Property
Title Property
Top Property
Width Property
ExcelVmlDrawingPictureCollection Class
ExcelVmlDrawingPictureCollection Members
ExcelVmlDrawingPictureCollection Methods
ExcelVmlDrawingPictureCollection Properties
Count Property
Item Property
ExcelVmlDrawingPosition Class
ExcelVmlDrawingPosition Members
ExcelVmlDrawingPosition Methods
ExcelVmlDrawingPosition Properties
Column Property
ColumnOffset Property
Row Property
RowOffset Property
OfficeOpenXml.Style Namespace
Border Class
Border Members
Border Methods
Border Properties
Bottom Property
Diagonal Property
DiagonalDown Property
DiagonalUp Property
Left Property
Right Property
Top Property
eStrikeType Enumeration
eUnderLineType Enumeration
ExcelBorderItem Class
ExcelBorderItem Members
ExcelBorderItem Methods
ExcelBorderItem Properties
Color Property
Style Property
ExcelBorderStyle Enumeration
ExcelColor Class
ExcelColor Members
ExcelColor Methods
SetColor Method
ExcelColor Properties
Indexed Property
Rgb Property
Theme Property
Tint Property
ExcelFill Class
ExcelFill Members
ExcelFill Methods
ExcelFill Properties
BackgroundColor Property
Gradient Property
PatternColor Property
PatternType Property
ExcelFillGradientType Enumeration
ExcelFillStyle Enumeration
ExcelFont Class
ExcelFont Members
ExcelFont Methods
SetFromFont Method
ExcelFont Properties
Bold Property
Color Property
Family Property
Italic Property
Name Property
Scheme Property
Size Property
Strike Property
UnderLine Property
UnderLineType Property
VerticalAlign Property
ExcelGradientFill Class
ExcelGradientFill Members
ExcelGradientFill Methods
ExcelGradientFill Properties
Bottom Property
Color1 Property
Color2 Property
Degree Property
Left Property
Right Property
Top Property
Type Property
ExcelHorizontalAlignment Enumeration
ExcelNumberFormat Class
ExcelNumberFormat Members
ExcelNumberFormat Methods
ExcelNumberFormat Properties
BuildIn Property
Format Property
NumFmtID Property
ExcelParagraph Class
ExcelParagraph Members
ExcelParagraph Constructor
ExcelParagraph Methods
ExcelParagraph Properties
Text Property
ExcelParagraphCollection Class
ExcelParagraphCollection Members
ExcelParagraphCollection Methods
Add Method
Clear Method
Remove Method
RemoveAt Method
ExcelParagraphCollection Properties
Count Property
Item Property
Text Property
ExcelReadingOrder Enumeration
ExcelRichText Class
ExcelRichText Members
ExcelRichText Methods
ExcelRichText Properties
Bold Property
Color Property
FontName Property
Italic Property
PreserveSpace Property
Size Property
Strike Property
Text Property
UnderLine Property
VerticalAlign Property
ExcelRichTextCollection Class
ExcelRichTextCollection Members
ExcelRichTextCollection Methods
Add Method
Clear Method
Remove Method
RemoveAt Method
ExcelRichTextCollection Properties
Count Property
Item Property
Text Property
ExcelStyle Class
ExcelStyle Members
ExcelStyle Methods
ExcelStyle Properties
Border Property
Fill Property
Font Property
Hidden Property
HorizontalAlignment Property
Indent Property
Locked Property
Numberformat Property
ReadingOrder Property
ShrinkToFit Property
TextRotation Property
VerticalAlignment Property
WrapText Property
XfId Property
ExcelTextFont Class
ExcelTextFont Members
ExcelTextFont Methods
SetFromFont Method
ExcelTextFont Properties
Bold Property
Color Property
ComplexFont Property
Italic Property
LatinFont Property
Size Property
Strike Property
UnderLine Property
UnderLineColor Property
ExcelUnderLineType Enumeration
ExcelVerticalAlignment Enumeration
ExcelVerticalAlignmentFont Enumeration
StyleBase Class
StyleBase Members
StyleBase Methods
OfficeOpenXml.Style.XmlAccess Namespace
ExcelBorderItemXml Class
ExcelBorderItemXml Members
ExcelBorderItemXml Methods
ExcelBorderItemXml Properties
Color Property
Exists Property
Style Property
ExcelBorderXml Class
ExcelBorderXml Members
ExcelBorderXml Methods
ExcelBorderXml Properties
Bottom Property
Diagonal Property
DiagonalDown Property
DiagonalUp Property
Left Property
Right Property
Top Property
ExcelColorXml Class
ExcelColorXml Members
ExcelColorXml Methods
SetColor Method
ExcelColorXml Properties
Auto Property
Indexed Property
Rgb Property
Theme Property
Tint Property
ExcelFillXml Class
ExcelFillXml Members
ExcelFillXml Methods
ExcelFillXml Properties
BackgroundColor Property
PatternColor Property
PatternType Property
ExcelFontXml Class
ExcelFontXml Members
ExcelFontXml Methods
SetFromFont Method
ExcelFontXml Properties
Bold Property
Color Property
Family Property
Italic Property
Name Property
Scheme Property
Size Property
Strike Property
UnderLine Property
UnderLineType Property
VerticalAlign Property
ExcelGradientFillXml Class
ExcelGradientFillXml Members
ExcelGradientFillXml Methods
ExcelGradientFillXml Properties
Bottom Property
Degree Property
GradientColor1 Property
GradientColor2 Property
Left Property
Right Property
Top Property
Type Property
ExcelNamedStyleXml Class
ExcelNamedStyleXml Members
ExcelNamedStyleXml Methods
ExcelNamedStyleXml Properties
BuildInId Property
Name Property
Style Property
StyleXfId Property
ExcelNumberFormatXml Class
ExcelNumberFormatXml Members
ExcelNumberFormatXml Methods
ExcelNumberFormatXml Properties
BuildIn Property
Format Property
NumFmtId Property
ExcelXfs Class
ExcelXfs Members
ExcelXfs Methods
ExcelXfs Properties
Border Property
Fill Property
Font Property
Hidden Property
HorizontalAlignment Property
Indent Property
Locked Property
Numberformat Property
ReadingOrder Property
ShrinkToFit Property
Styles Property
TextRotation Property
VerticalAlignment Property
WrapText Property
XfId Property
StyleXmlHelper Class
StyleXmlHelper Members
StyleXmlHelper Methods
OfficeOpenXml.Table Namespace
ExcelTable Class
ExcelTable Members
ExcelTable Methods
ExcelTable Properties
Address Property
Columns Property
DataCellStyleName Property
HeaderRowCellStyle Property
Name Property
ShowColumnStripes Property
ShowFilter Property
ShowFirstColumn Property
ShowHeader Property
ShowLastColumn Property
ShowRowStripes Property
ShowTotal Property
StyleName Property
TableStyle Property
TableUri Property
TableXml Property
TotalsRowCellStyle Property
WorkSheet Property
ExcelTableCollection Class
ExcelTableCollection Members
ExcelTableCollection Methods
Add Method
GetEnumerator Method
GetFromRange Method
ExcelTableCollection Properties
Count Property
Item Property
Item Property (Int32)
Item Property (String)
ExcelTableColumn Class
ExcelTableColumn Members
ExcelTableColumn Methods
ExcelTableColumn Properties
CalculatedColumnFormula Property
DataCellStyleName Property
Id Property
Name Property
Position Property
TotalsRowFormula Property
TotalsRowFunction Property
TotalsRowLabel Property
ExcelTableColumnCollection Class
ExcelTableColumnCollection Members
ExcelTableColumnCollection Constructor
ExcelTableColumnCollection Methods
ExcelTableColumnCollection Properties
Count Property
Item Property
Item Property (Int32)
Item Property (String)
Table Property
RowFunctions Enumeration
TableStyles Enumeration
OfficeOpenXml.Table.PivotTable Namespace
DataFieldFunctions Enumeration
eDateGroupBy Enumeration
ePivotFieldAxis Enumeration
eSortType Enumeration
eSourceType Enumeration
eSubTotalFunctions Enumeration
ExcelPivotCacheDefinition Class
ExcelPivotCacheDefinition Members
ExcelPivotCacheDefinition Methods
ExcelPivotCacheDefinition Properties
CacheDefinitionUri Property
CacheDefinitionXml Property
CacheSource Property
PivotTable Property
SourceRange Property
ExcelPivotTable Class
ExcelPivotTable Members
ExcelPivotTable Methods
ExcelPivotTable Properties
Address Property
ApplyBorderFormats Property
ApplyFontFormats Property
ApplyNumberFormats Property
ApplyPatternFormats Property
ApplyWidthHeightFormats Property
CacheDefinition Property
ColumGrandTotals Property
ColumnFields Property
Compact Property
CompactData Property
DataCaption Property
DataFields Property
DataOnRows Property
EnableDrill Property
ErrorCaption Property
FieldPrintTitles Property
Fields Property
FirstDataCol Property
FirstDataRow Property
FirstHeaderRow Property
GrandTotalCaption Property
GridDropZones Property
Indent Property
ItemPrintTitles Property
MissingCaption Property
MultipleFieldFilters Property
Name Property
Outline Property
OutlineData Property
PageFields Property
PageWrap Property
PivotTableUri Property
PivotTableXml Property
PrintDrill Property
RowFields Property
RowGrandTotals Property
RowHeaderCaption Property
ShowCalcMember Property
ShowDataTips Property
ShowDrill Property
ShowError Property
ShowHeaders Property
ShowMemberPropertyTips Property
StyleName Property
TableStyle Property
UseAutoFormatting Property
WorkSheet Property
ExcelPivotTableCollection Class
ExcelPivotTableCollection Members
ExcelPivotTableCollection Methods
Add Method
GetEnumerator Method
ExcelPivotTableCollection Properties
Count Property
Item Property
Item Property (Int32)
Item Property (String)
ExcelPivotTableDataField Class
ExcelPivotTableDataField Members
ExcelPivotTableDataField Methods
ExcelPivotTableDataField Properties
BaseField Property
BaseItem Property
Field Property
Format Property
Function Property
Index Property
Name Property
ExcelPivotTableDataFieldCollection Class
ExcelPivotTableDataFieldCollection Members
ExcelPivotTableDataFieldCollection Methods
Add Method
Remove Method
ExcelPivotTableDataFieldCollection Properties
ExcelPivotTableField Class
ExcelPivotTableField Members
ExcelPivotTableField Methods
AddDateGrouping Method
AddDateGrouping Method (eDateGroupBy)
AddDateGrouping Method (eDateGroupBy, DateTime, DateTime)
AddDateGrouping Method (Int32, DateTime, DateTime)
AddNumericGrouping Method
ExcelPivotTableField Properties
Axis Property
Compact Property
Grouping Property
IncludeNewItemsInFilter Property
Index Property
IsColumnField Property
IsDataField Property
IsPageField Property
IsRowField Property
Items Property
Name Property
Outline Property
PageFieldSettings Property
ShowAll Property
Sort Property
SubTotalFunctions Property
SubtotalTop Property
ExcelPivotTableFieldCollection Class
ExcelPivotTableFieldCollection Members
ExcelPivotTableFieldCollection Methods
GetDateGroupField Method
GetNumericGroupField Method
ExcelPivotTableFieldCollection Properties
Item Property
Item Property (String)
ExcelPivotTableFieldCollectionBase(T) Class
ExcelPivotTableFieldCollectionBase(T) Members
ExcelPivotTableFieldCollectionBase(T) Methods
GetEnumerator Method
ExcelPivotTableFieldCollectionBase(T) Properties
Count Property
Item Property
ExcelPivotTableFieldDateGroup Class
ExcelPivotTableFieldDateGroup Members
ExcelPivotTableFieldDateGroup Methods
ExcelPivotTableFieldDateGroup Properties
AutoEnd Property
AutoStart Property
GroupBy Property
ExcelPivotTableFieldGroup Class
ExcelPivotTableFieldGroup Members
ExcelPivotTableFieldGroup Methods
ExcelPivotTableFieldItem Class
ExcelPivotTableFieldItem Members
ExcelPivotTableFieldItem Methods
ExcelPivotTableFieldItem Properties
Text Property
ExcelPivotTableFieldNumericGroup Class
ExcelPivotTableFieldNumericGroup Members
ExcelPivotTableFieldNumericGroup Methods
ExcelPivotTableFieldNumericGroup Properties
End Property
Interval Property
Start Property
ExcelPivotTablePageFieldSettings Class
ExcelPivotTablePageFieldSettings Members
ExcelPivotTablePageFieldSettings Methods
ExcelPivotTablePageFieldSettings Properties
Name Property
ExcelPivotTableRowColumnFieldCollection Class
ExcelPivotTableRowColumnFieldCollection Members
ExcelPivotTableRowColumnFieldCollection Methods
Add Method
Remove Method
RemoveAt Method
ExcelPivotTableRowColumnFieldCollection Properties
OfficeOpenXml.Utils Namespace
AddressUtility Class
AddressUtility Members
AddressUtility Methods
ParseEntireColumnSelections Method
ArgumentExtensions Class
ArgumentExtensions Members
ArgumentExtensions Methods
IsInRange(T) Method
IsNotNull(T) Method
IsNotNullOrEmpty Method
IArgument(T) Interface
IArgument(T) Members
IArgument(T) Methods
IArgument(T) Properties
Value Property
Require Class
Require Members
Require Methods
Argument(T) Method
SqRefUtility Class
SqRefUtility Members
SqRefUtility Methods
FromSqRefAddress Method
ToSqRefAddress Method

EPPlus 3.0

Table of contents