ExcelWriter v9 Docs (1260 pages)
- Addressing Cells
- Advanced Grouping and Nesting
- Anchor
- Anchor.Column
- Anchor.OffsetX
- Anchor.OffsetY
- Anchor.Row
- API Reference
- Application to Template Sample
- Area
- Area.AllColumnWidths
- Area.AllColumnWidthsInChars
- Area.AllRowsHeight
- Area.ApplyStyle(Style)
- Area.ArrayFormula
- Area.AutoFitHeight()
- Area.AutoFitWidth()
- Area.BorderAround
- Area.CalculateFormulas
- Area.CalculateFormulas
- Area.CalculateFormulas()
- Area.CalculateFormulas()
- Area.CalculateFormulas()
- Area.ClearContent()
- Area.ColumnCount
- Area.CreateHyperlink(String)
- Area.Dimensions
- Area.FirstColumn
- Area.FirstRow
- Area.GetColumnWidth(Int32)
- Area.GetColumnWidthInChars(Int32)
- Area.GetRowHeight(Int32)
- Area.GroupColumns(Boolean)
- Area.GroupRows(Boolean)
- Area.ImportData
- Area.ImportData(Object()())
- Area.ImportData(Object()(), String(), DataImportProperties)
- Area.ImportData(Object(,))
- Area.ImportData(Object(,), String(), DataImportProperties)
- Area.ImportData(System.Data.DataTable)
- Area.ImportData(System.Data.DataTable, DataImportProperties)
- Area.ImportData(System.Data.DataView)
- Area.ImportData(System.Data.DataView, DataImportProperties)
- Area.ImportData(System.Data.IDataReader)
- Area.ImportData(System.Data.IDataReader, DataImportProperties)
- Area.Item(Int32, Int32)
- Area.MergeCells()
- Area.PopulatedCells
- Area.RemoveConditionalFormat()
- Area.RowCount
- Area.SaveImage
- Area.SaveImage(String, ImageFormat)
- Area.SaveImage(String, ImageFormat, int?, int?)
- Area.SaveImage(System.IO.Stream, ImageFormat)
- Area.SaveImage(System.IO.Stream, ImageFormat, int?, int?)
- Area.SetColumnWidth(Int32, Double)
- Area.SetColumnWidthInChars(Int32, Double)
- Area.SetConditionalFormat(ConditionalFormat)
- Area.SetDataValidation(DataValidation)
- Area.SetRowHeight(Int32, Double)
- Area.SetStyle(Style)
- Area.Sort
- Area.Sort
- Area.Sort
- Area.Sort
- Area.Sort
- Area.Sort
- Area.Sort(Integer, bool, bool)
- Area.Sort(Integer, Boolean, Boolean)
- Area.ToString()
- Area.UngroupColumns()
- Area.UngroupRows()
- Area.WorksheetIndex
- Areas and Ranges
- Arrays and Collections as Data Sources
- AutoFilter
- AutoFilter.Area
- AutoFilter.Clear()
- Axis
- Axis.AxisLine
- Axis.LabelFont
- Axis.LinkedToSource
- Axis.MajorGridline
- Axis.MajorTickType
- Axis.MinorGridline
- Axis.MinorTickType
- Axis.NumberFormat
- Axis.TextDisplayTopToBottom
- Axis.TextRotationAngle
- Axis.TickLabelPos
- Axis.TickLabelPosition
- Axis.TickType
- Axis.Title
- Axis.ValuesInReverseOrder
- Axis.Visible
- AxisLabel
- AxisLabel.LabelPosition
- AxisLabel.Position
- AxisType
- Basic Steps
- Basic Steps R1C1
- Basic Tutorials
- Best Practices with Large Reports
- Border
- Border.Color
- Border.Item(Border.Part)
- Border.LineStyle
- Border.Part
- Border.Style
- BorderPart
- BorderPart.Color
- BorderPart.Style
- Calculation Engine Supported Formulas
- CategoryAxis
- CategoryAxis.AxisCrossesMaxCategory
- CategoryAxis.AxisCrossesMidCategory
- CategoryAxis.AxisDisplayType
- CategoryAxis.AxisTimeUnit
- CategoryAxis.BaseUnit
- CategoryAxis.CategoriesBetweenTickMarkLabels
- CategoryAxis.CategoriesBetweenTickMarks
- CategoryAxis.DisplayType
- CategoryAxis.MajorUnit
- CategoryAxis.MajorUnitValue
- CategoryAxis.MaximumValue
- CategoryAxis.MaximumValueAsDate
- CategoryAxis.MinimumValue
- CategoryAxis.MinimumValueAsDate
- CategoryAxis.MinorUnit
- CategoryAxis.MinorUnitValue
- CategoryAxis.ValueCrossingPoint
- CategoryAxis.ValueCrossingPointAsDate
- Cell
- Cell.ApplyStyle(Style)
- Cell.CellValueType
- Cell.ClearContent()
- Cell.ClearRichTextFormatting()
- Cell.ColumnNumber
- Cell.Comment
- Cell.ConditionalFormat
- Cell.CreateAnchor(Int32, Int32)
- Cell.CreateHyperlink(String)
- Cell.DataValidation
- Cell.Formula
- Cell.GetCharacters
- Cell.GetCharacters(Int32)
- Cell.GetCharacters(Int32, Int32)
- Cell.HasComment
- Cell.HasConditionalFormat
- Cell.HasDataValidation
- Cell.IsMerged
- Cell.Name
- Cell.RemoveComment()
- Cell.RemoveConditionalFormat()
- Cell.RemoveDataValidation()
- Cell.RowNumber
- Cell.SetAddInFormula(String)
- Cell.SetConditionalFormat(ConditionalFormat)
- Cell.Style
- Cell.ToString()
- Cell.Unmerge()
- Cell.Value
- Cell.ValueType
- Cells
- Cells.Item
- Cells.Item(Int32, Int32)
- Cells.Item(String)
- CellStyle
- CharacterRun
- CharacterRun.Clear()
- CharacterRun.Font
- CharacterRun.Length
- CharacterRun.StartIndex
- Chart
- Chart Report
- Chart.CategoryAxis
- Chart.ChartArea
- Chart.ChartLocation
- Chart.ChartSettings3D
- Chart.ChartType
- Chart.DataTable
- Chart.Height
- Chart.Legend
- Chart.MoveChart
- Chart.MoveChart(Chart.ChartLocation, Int32)
- Chart.MoveChart(Chart.ChartLocation, Int32, Anchor)
- Chart.MoveChart(Chart.ChartLocation, String)
- Chart.MoveChart(Chart.ChartLocation, String, Int32)
- Chart.Name
- Chart.ObjectPositioning
- Chart.PageSetup
- Chart.PlotArea
- Chart.Position
- Chart.PositionInCollection
- Chart.SaveImage
- Chart.SaveImage(String, ImageFormat)
- Chart.SaveImage(string, ImageFormat, int?, int?)
- Chart.SaveImage(System.IO.Stream, ImageFormat)
- Chart.SaveImage(System.IO.Stream, ImageFormat, int?, int?)
- Chart.ScatterValueAxis
- Chart.SecondaryCategoryAxis
- Chart.SecondaryValueAxis
- Chart.SeriesCollection
- Chart.ShowRoundedCorners
- Chart.Title
- Chart.ValueAxis
- Chart.Width
- Chart.ZCategoryAxis
- ChartDataTable
- ChartDataTable.BorderLine
- ChartDataTable.Font
- ChartDataTable.Height
- ChartDataTable.ShowHorizontalBorders
- ChartDataTable.ShowLegendKeys
- ChartDataTable.ShowOutlineBorders
- ChartDataTable.ShowVerticalBorders
- ChartDataTable.Visible
- ChartDataTable.Width
- ChartDataTable.X
- ChartDataTable.Y
- ChartFillPattern
- ChartInterior
- ChartInterior.BackgroundColor
- ChartInterior.ClearFillEffects()
- ChartInterior.ForegroundColor
- ChartInterior.Pattern
- ChartInterior.Visible
- ChartLine
- ChartLine.Color
- ChartLine.LineStyle
- ChartLine.LineWeight
- ChartLine.Style
- ChartLine.Visible
- ChartLine.Weight
- ChartPageSetup
- ChartPageSetup.ChartSize
- ChartPageSetup.PrintedChartSize
- ChartRegion
- ChartRegion.BorderLine
- ChartRegion.Font
- ChartRegion.HasShadow
- ChartRegion.Height
- ChartRegion.HorizontalAlignment
- ChartRegion.Interior
- ChartRegion.TextDisplayTopToBottom
- ChartRegion.TextHorizontalAlignment
- ChartRegion.TextRotationAngle
- ChartRegion.TextVerticalAlignment
- ChartRegion.VerticalAlignment
- ChartRegion.Width
- ChartRegion.X
- ChartRegion.Y
- Charts
- Charts in ExcelApplication
- Charts.AddChart(Chart, Anchor)
- Charts.Count
- Charts.CreateChart(ChartType, Anchor)
- Charts.GetEnumerator()
- Charts.Item
- Charts.Item(Int32)
- Charts.Item(String)
- Charts.Remove
- Charts.Remove(Chart)
- Charts.Remove(Int32)
- ChartSettings3D
- ChartSettings3D.ChartDepth
- ChartSettings3D.DistanceFromEyeToChart
- ChartSettings3D.ElevationAngle
- ChartSettings3D.Floor3D
- ChartSettings3D.Floor3DBorder
- ChartSettings3D.PlotVolumeHeight
- ChartSettings3D.RotationAngle
- ChartSettings3D.SeriesGapWidth
- ChartSettings3D.UseAutoScaling
- ChartSettings3D.UseRightAngleAxes
- ChartSettings3D.Wall3D
- ChartSettings3D.Wall3DBorder
- Chartsheet
- Chartsheet.Chart
- ChartText
- ChartText.ClearRichTextFormatting()
- ChartText.Formula
- ChartText.GetCharacters
- ChartText.GetCharacters(Int32)
- ChartText.GetCharacters(Int32, Int32)
- ChartText.NumberFormat
- ChartText.Text
- ChartTextCollection
- ChartTextCollection.AddChartText(ChartText)
- ChartTextCollection.Count
- ChartTextCollection.CreateChartText
- ChartTextCollection.CreateChartText()
- ChartTextCollection.CreateChartText(String)
- ChartTextCollection.Item(Int32)
- ChartTextCollection.Remove
- ChartTextCollection.Remove(ChartText)
- ChartTextCollection.Remove(Int32)
- ChartType
- ChartType.Area
- ChartType.Bar
- ChartType.Bubble
- ChartType.Category
- ChartType.ChartCategory
- ChartType.Column
- ChartType.Custom
- ChartType.Doughnut
- ChartType.Is3D
- ChartType.Line
- ChartType.Name
- ChartType.Pie
- ChartType.Radar
- ChartType.Scatter
- ChartType.Surface
- Color
- Color.Blue
- Color.Green
- Color.IsCustomColor
- Color.IsPaletteColor
- Color.IsSystemColor
- Color.PaletteIndex
- Color.Red
- Color.SystemColor
- Color.ToString()
- ColumnProperties
- ColumnProperties.ApplyStyle(Style)
- ColumnProperties.AutoFitWidth()
- ColumnProperties.ColumnNumber
- ColumnProperties.Hidden
- ColumnProperties.OutlineCollapsed
- ColumnProperties.OutlineLevel
- ColumnProperties.PaddingInChars
- ColumnProperties.Style
- ColumnProperties.Width
- ColumnProperties.WidthInChars
- Comment
- Comment.Author
- Comment.Cell
- Comment.ClearRichTextFormatting()
- Comment.FitToText
- Comment.GetCharacters
- Comment.GetCharacters(Int32)
- Comment.GetCharacters(Int32, Int32)
- Comment.HorizontalAlignment
- Comment.Shape
- Comment.Text
- Comment.VerticalAlignment
- Comment.Visible
- Comments
- Comments.Count
- Comments.CreateComment
- Comments.CreateComment(Cell)
- Comments.CreateComment(Int32, Int32)
- Comments.GetEnumerator()
- Comments.Item
- Comments.Item(Int32)
- Comments.Item(String)
- Comments.Remove(Int32)
- Condition
- Condition.ApplyStyle(Style)
- Condition.ChangeCondition
- Condition.ChangeCondition(Condition.Comparison, String)
- Condition.ChangeCondition(Condition.Comparison, String, String)
- Condition.Comparison
- Condition.ComparisonType
- Condition.Formula1
- Condition.Formula2
- Condition.Style
- ConditionalFormat
- ConditionalFormat.Count
- ConditionalFormat.CreateCondition
- ConditionalFormat.CreateCondition(Condition.Comparison, String)
- ConditionalFormat.CreateCondition(Condition.Comparison, String, String)
- ConditionalFormat.Item(Int32)
- ConditionalFormat.Range
- ConditionalFormat.RemoveCondition
- ConditionalFormat.RemoveCondition(Condition)
- ConditionalFormat.RemoveCondition(Int32)
- Convert strings to formatted numerical values
- Copying Data From a Worksheet
- CopyPasteProperties
- CopyPasteProperties.CopyColumnWidth
- CopyPasteProperties.CopyComments
- CopyPasteProperties.CopyFormatting
- CopyPasteProperties.CopyFormulas
- CopyPasteProperties.CopyMergedCells
- CopyPasteProperties.CopyPasteType
- CopyPasteProperties.CopyRowHeight
- CopyPasteProperties.CopyValues
- Creating a Basic PivotTable
- Creating Data Markers
- Data Binding Properties
- Data Marker Options
- Data Validation
- DataBindingProperties
- DataBindingProperties.MaxRows
- DataBindingProperties.Transpose
- DataBindingProperties.WorksheetName
- DataImportProperties
- DataImportProperties.ALLCOLUMNS
- DataImportProperties.ALLROWS
- DataImportProperties.ColumnIndexFilter
- DataImportProperties.ColumnNameFilter
- DataImportProperties.ConversionCulture
- DataImportProperties.ConvertStrings
- DataImportProperties.IgnoreNulls
- DataImportProperties.MaxColumns
- DataImportProperties.MaxRows
- DataImportProperties.PreserveDataOnMergedCells
- DataImportProperties.Transpose
- DataImportProperties.Truncate
- DataImportProperties.TruncateColumns
- DataImportProperties.TruncateRows
- DataImportProperties.UseColumnNames
- DataLabelPlacementType
- DataPoint
- DataPoint.DistanceFromCenter
- DataPoint.Interior
- DataPoint.IsOnSecondaryPieorBar
- DataPoint.Label
- DataPoint.LegendEntryFont
- DataPoint.Line
- DataPoint.Marker
- DataPoint.ShowLegendEntry
- DataPointMarker
- DataPointMarker.BackgroundColor
- DataPointMarker.ForegroundColor
- DataPointMarker.HasShadow
- DataPointMarker.MarkerType
- DataPointMarker.ShapeType
- DataPointMarker.ShowBackgroundColor
- DataPointMarker.ShowForegroundColor
- DataPointMarker.Size
- DataPointMarker.Visible
- DataValidation
- DataValidation.AllowedType
- DataValidation.Clear()
- DataValidation.Comparison
- DataValidation.ComparisonType
- DataValidation.ErrorAlert
- DataValidation.ErrorAlertStyle
- DataValidation.ErrorAlertStyleType
- DataValidation.ErrorAlertTitle
- DataValidation.IgnoreBlanks
- DataValidation.InputMessage
- DataValidation.MaximumValue
- DataValidation.MinimumValue
- DataValidation.SetAllowedType
- DataValidation.SetAllowedType(DataValidation.ValidationType, DataValidation.ComparisonType, Object)
- DataValidation.SetAllowedType(DataValidation.ValidationType, DataValidation.ComparisonType, Object, Object)
- DataValidation.SetAllowedType(DataValidation.ValidationType, Object)
- DataValidation.ShowErrorAlert
- DataValidation.ShowInputMessage
- DataValidation.Title
- DataValidation.UseListDropdown
- DataValidation.ValidationType
- DocumentProperties
- DocumentProperties.Application
- DocumentProperties.Author
- DocumentProperties.BuiltIn
- DocumentProperties.Category
- DocumentProperties.Clear()
- DocumentProperties.Comments
- DocumentProperties.Company
- DocumentProperties.CreationDate
- DocumentProperties.GetCustomProperty(String)
- DocumentProperties.Item
- DocumentProperties.Item(DocumentProperties.BuiltIn)
- DocumentProperties.Item(String)
- DocumentProperties.Keywords
- DocumentProperties.LastSavedDate
- DocumentProperties.Manager
- DocumentProperties.RestoreDefaults()
- DocumentProperties.SetCustomProperty(String, Object)
- DocumentProperties.Title
- Drawing Objects
- Drawing Objects and Data Markers
- Effective Use of Styles
- ErrorBar
- ErrorBar.BarDirection
- ErrorBar.CustomMinusFormula
- ErrorBar.CustomPlusFormula
- ErrorBar.Direction
- ErrorBar.ErrorValueType
- ErrorBar.Line
- ErrorBar.TShaped
- ErrorBar.Value
- ErrorBar.ValueType
- Excel to DataTable Sample
- ExcelApplication
- ExcelApplication API
- ExcelApplication Guides
- ExcelApplication Samples
- ExcelApplication.Create(FileFormat)
- ExcelApplication.ExcelApplication()
- ExcelApplication.FileFormat
- ExcelApplication.LicenseKey
- ExcelApplication.Open
- ExcelApplication.Open(ExcelTemplate)
- ExcelApplication.Open(String)
- ExcelApplication.Open(String, String)
- ExcelApplication.Open(System.IO.Stream)
- ExcelApplication.Open(System.IO.Stream, String)
- ExcelApplication.Save
- ExcelApplication.Save(Workbook, String)
- ExcelApplication.Save(Workbook, System.IO.Stream)
- ExcelApplication.Save(Workbook, System.Web.HttpResponse, String, Boolean)
- ExcelApplication.Save(Workbook, System.Web.HttpResponse, String, Boolean, String)
- ExcelApplication.SaveToStream(Workbook)
- ExcelApplication.Version
- ExcelTemplate
- ExcelTemplate API
- ExcelTemplate Guides
- ExcelTemplate Output Options
- ExcelTemplate Samples
- ExcelTemplate.ALL_ROWS
- ExcelTemplate.BindCellData(Object, String, DataBindingProperties)
- ExcelTemplate.BindColumnData
- ExcelTemplate.BindColumnData(Object(), String, DataBindingProperties)
- ExcelTemplate.BindColumnData(System.Collections.IDictionary, String, DataBindingProperties)
- ExcelTemplate.BindColumnData(System.Collections.IEnumerable, String, DataBindingProperties)
- ExcelTemplate.BindData
- ExcelTemplate.BindData(Object()(), String(), String, DataBindingProperties)
- ExcelTemplate.BindData(Object(,), String(), String, DataBindingProperties)
- ExcelTemplate.BindData(System.Collections.Generic.IEnumerable(T), String, DataBindingProperties)
- ExcelTemplate.BindData(System.Data.DataSet, String, DataBindingProperties)
- ExcelTemplate.BindData(System.Data.DataTable, String, DataBindingProperties)
- ExcelTemplate.BindData(System.Data.DataView, String, DataBindingProperties)
- ExcelTemplate.BindData(System.Data.IDataReader, String, DataBindingProperties)
- ExcelTemplate.BindRowData
- ExcelTemplate.BindRowData(Object(), String(), String, DataBindingProperties)
- ExcelTemplate.BindRowData(System.Collections.IDictionary, String, DataBindingProperties)
- ExcelTemplate.BindRowData(System.Collections.IEnumerable, String(), String, DataBindingProperties)
- ExcelTemplate.BindRowData(System.Data.DataSet, String, DataBindingProperties)
- ExcelTemplate.BindRowData(System.Data.DataTable, String, DataBindingProperties)
- ExcelTemplate.BindRowData(System.Data.DataView, String, DataBindingProperties)
- ExcelTemplate.ContentType
- ExcelTemplate.CreateDataBindingProperties()
- ExcelTemplate.DecryptPassword
- ExcelTemplate.EncryptPassword
- ExcelTemplate.ExcelTemplate()
- ExcelTemplate.ExcludeMacros
- ExcelTemplate.LicenseKey
- ExcelTemplate.Open
- ExcelTemplate.Open(ExcelApplication, Workbook)
- ExcelTemplate.Open(String)
- ExcelTemplate.Open(System.IO.Stream)
- ExcelTemplate.PreserveStrings
- ExcelTemplate.Process()
- ExcelTemplate.RemoveExtraDataMarkers
- ExcelTemplate.Save
- ExcelTemplate.Save(String)
- ExcelTemplate.Save(System.IO.Stream)
- ExcelTemplate.Save(System.Web.HttpResponse)
- ExcelTemplate.Save(System.Web.HttpResponse, String, Boolean)
- ExcelTemplate.SaveToStream()
- ExcelTemplate.StretchCellReferencesInCharts
- ExcelTemplate.Version
- ExcelWriter Introduction
- ExcelWriter Learning Center
- ExcelWriterException
- Extended Sales Summary
- FieldCollection
- FieldCollection.Count
- FieldCollection.CreateField(SourceField)
- FieldCollection.Item(Int32)
- FieldCollection.Item(String)
- Financial Report
- Font
- Font.Bold
- Font.Color
- Font.Italic
- Font.Name
- Font.ScriptStyle
- Font.Size
- Font.Strikethrough
- Font.Underline
- Font.UnderlineStyle
- Font.VerticalPosition
- Formatting Headers and Footers
- Formulas
- FunctionValue
- FunctionValue.FunctionValue(Boolean)
- FunctionValue.FunctionValue(Double)
- FunctionValue.FunctionValue(Range)
- FunctionValue.FunctionValue(String)
- FunctionValueType
- GlobalStyle
- Group
- Group.Height
- Group.Position
- Group.Type
- Group.Width
- Grouping and Nesting Sample
- Grouping and Subtotals
- Groups
- Groups.Count
- Groups.GetEnumerator()
- Groups.ListGroups()
- Groups.Remove
- Groups.Remove(Group)
- Groups.Remove(Int32)
- HeaderFooterPicture
- HeaderFooterPicture.Height
- HeaderFooterPicture.LockAspectRatio
- HeaderFooterPicture.Width
- HeaderFooterSection
- HeaderFooterSection.GetPicture()
- HeaderFooterSection.GetText()
- HeaderFooterSection.Section
- HeaderFooterSection.SetContent
- HeaderFooterSection.SetContent(String)
- HeaderFooterSection.SetContent(String, String)
- HeaderFooterSection.SetContent(String, System.IO.Stream)
- Hello World Tutorial
- Hello World Using ExcelApplication
- Hello World using ExcelTemplate
- How ExcelWriter Inserts Rows
- How to Use Templates
- Hyperlink
- Hyperlink.Area
- Hyperlink.Href
- Hyperlink.Text
- Hyperlinks
- Hyperlinks.Count
- Hyperlinks.CreateHyperlink
- Hyperlinks.CreateHyperlink(Area, String)
- Hyperlinks.CreateHyperlink(Area, String, String)
- Hyperlinks.GetEnumerator()
- Hyperlinks.Item(Int32)
- IFunction
- IFunction.Calculate
- Importing Data
- Intro to PivotTables
- ItemsToRetain
- ItemsToRetain.Automatic
- ItemsToRetain.Max
- ItemsToRetain.None
- ItemsToRetain.Value
- Legend
- Legend.LegendLocation
- Legend.Location
- Legend.Vertical
- Legend.Visible
- Loan Calculator Spreadsheet
- Memory Related Performance Issues
- Modifying an Existing Spreadsheet
- Multilingual Support
- Multiple Chart Report
- NamedObject
- NamedObject.BuiltInName
- NamedObject.Formula
- NamedObject.Name
- NamedObject.NamedObjectType
- NamedObject.NameScope
- NamedObject.ReturnType
- NamedObject.Scope
- NamedObject.Value
- NamedStyle
- NamedStyle.Name
- Number Formats
- NumberFormat
- NumberFormat.Color
- NumberFormat.CreateAccounting(Int32, Boolean, NumberFormat.Color)
- NumberFormat.CreateCurrency
- NumberFormat.CreateCurrency(Int32, Boolean, Boolean, Boolean, NumberFormat.Color)
- NumberFormat.CreateCurrency(Int32, Boolean, Boolean, NumberFormat.Color, String, String, Boolean, Boolean)
- NumberFormat.CreateFraction
- NumberFormat.CreateFraction(Int32)
- NumberFormat.CreateFraction(Int32, Int32)
- NumberFormat.CreateNumber(Int32, Boolean, Boolean, Boolean, Boolean, NumberFormat.Color)
- NumberFormat.CreatePercentage(Int32)
- NumberFormat.CreateScientific(Int32)
- NumberFormat.DateFormat
- NumberFormat.Special_EN_US
- NumberFormat.TimeFormat
- ObjectPositioning
- Othersheet
- Output Options for ExcelApplication
- PageSetup
- PageSetup.BottomMargin
- PageSetup.CellErrorsAs
- PageSetup.CenterHorizontally
- PageSetup.CenterVertically
- PageSetup.FirstPageNumber
- PageSetup.FirstPageNumberAuto
- PageSetup.FitToPagesTall
- PageSetup.FitToPagesWide
- PageSetup.FooterMargin
- PageSetup.GetFooter(HeaderFooterSection.Section)
- PageSetup.GetHeader(HeaderFooterSection.Section)
- PageSetup.HeaderMargin
- PageSetup.LeftMargin
- PageSetup.Orientation
- PageSetup.PageOrientation
- PageSetup.PagePaperSize
- PageSetup.PagePrintOrder
- PageSetup.PaperSize
- PageSetup.PrintArea
- PageSetup.PrintAsDraft
- PageSetup.PrintCellErrorsAs
- PageSetup.PrintComments
- PageSetup.PrintCommentsAtEnd
- PageSetup.PrintGridlines
- PageSetup.PrintHeadings
- PageSetup.PrintInBlackAndWhite
- PageSetup.PrintOrder
- PageSetup.PrintTitles
- PageSetup.RightMargin
- PageSetup.SetPrintTitleColumns(Int32, Int32)
- PageSetup.SetPrintTitleRows(Int32, Int32)
- PageSetup.TopMargin
- PageSetup.UseZoom
- PageSetup.Zoom
- Palette
- Palette.GetClosestColor
- Palette.GetClosestColor(Int32, Int32, Int32)
- Palette.GetClosestColor(System.Drawing.Color)
- Palette.GetColor
- Palette.GetColor(Int32, Int32, Int32)
- Palette.GetColor(System.Drawing.Color)
- Palette.GetColorAt(Int32)
- Palette.MaxColorIndex
- Palette.MaxRGBValue
- Palette.MinColorIndex
- Palette.MinRGBValue
- Palette.SetColor(Color, Int32, Int32, Int32)
- Palette.SetColorAt(Int32, Int32, Int32, Int32)
- Palette.SystemColor
- Part 1 - Creating a Dynamic Template
- Part 1 - Getting Started
- Part 1 - Using Modifiers and Ordinal Syntax
- Part 2 - Creating a Cover sheet
- Part 2 - Using Styles and Formatting
- Part 2 - Working with Formulas
- Part 3 - Adding a Chart
- Part 3 - Combine Reports with CopySheet
- Passing ExcelApplication to ExcelTemplate
- Passing ExcelTemplate to ExcelApplication
- Pattern
- Picture
- Picture.Height
- Picture.LockAspectRatio
- Picture.Name
- Picture.PictureData
- Picture.Position
- Picture.Shape
- Picture.Width
- Pictures
- Pictures.Count
- Pictures.CreatePicture
- Pictures.CreatePicture(String, Anchor)
- Pictures.CreatePicture(System.IO.Stream, Anchor)
- Pictures.GetEnumerator()
- Pictures.Item
- Pictures.Item(Int32)
- Pictures.Item(String)
- Pictures.ListPictures()
- Pictures.Remove
- Pictures.Remove(Int32)
- Pictures.Remove(Picture)
- PivotTable
- PivotTable.ChangeDataSource(Area)
- PivotTable.ColumnLabels
- PivotTable.DataFields
- PivotTable.Name
- PivotTable.PageFields
- PivotTable.PivotTableLayout
- PivotTable.PivotTableSettings
- PivotTable.RowLabels
- PivotTable.SourceFields
- PivotTableField
- PivotTableField.DisplayName
- PivotTableField.DisplaySubtotalsAtTop
- PivotTableField.FieldType
- PivotTableField.IsValuesLabel
- PivotTableField.NumberFormat
- PivotTableField.SortOptions
- PivotTableField.Source
- PivotTableField.SummarizeBy
- PivotTableField.SummarizeByType
- PivotTableLayout
- PivotTableLayout.LayoutOptions
- PivotTableLayout.ReportLayout
- PivotTables
- PivotTables.Count
- PivotTables.CreateConsolidatedPivotTable(IEnumerable, Int32, Int32)
- PivotTables.CreatePivotTable(Area, Int32, Int32)
- PivotTables.GetEnumerator()
- PivotTables.Item
- PivotTables.Item(Int32)
- PivotTables.Item(String)
- PivotTables.Remove(Int32)
- PivotTables.Remove(PivotTable)
- PivotTableSettings
- PivotTableSettings.ClassicLayout
- PivotTableSettings.EmptyValueCaption
- PivotTableSettings.FriendlyErrorCaption
- PivotTableSettings.RefreshOnOpen
- PivotTableSettings.ShowEmptyValueCaption
- PivotTableSettings.ShowFriendlyErrorCaption
- PivotTableSettings.ValuesLabelOnRow
- Preprocessing vs. Postprocessing
- Protecting Your Worksheet
- Quick Guides
- Range
- Range.ApplyStyle(Style)
- Range.AreaCount
- Range.Areas
- Range.BorderAround
- Range.ClearContent()
- Range.FirstCellStyle
- Range.Item(Int32)
- Range.JoinRange(Range)
- Range.RemoveConditionalFormat()
- Range.SetConditionalFormat(ConditionalFormat)
- Range.SetDataValidation(DataValidation)
- Range.SetStyle(Style)
- Range.ToString()
- RowProperties
- RowProperties.ApplyStyle(Style)
- RowProperties.AutoFitHeight()
- RowProperties.Height
- RowProperties.Hidden
- RowProperties.OutlineCollapsed
- RowProperties.OutlineLevel
- RowProperties.RowNumber
- RowProperties.Style
- Sales Commission Report
- Sample Expense Report
- Samples
- Scatter Chart Report
- Series
- Series.AxisType
- Series.BubbleSizes
- Series.ChangeConfiguration(ChartType, AxisType)
- Series.ChartType
- Series.DataLabels
- Series.DataPointMarker
- Series.ErrorBarX
- Series.ErrorBarY
- Series.HasShadow
- Series.HasSmoothedLine
- Series.Interior
- Series.Item(Int32)
- Series.LegendEntryFont
- Series.Line
- Series.Name
- Series.NameFormula
- Series.ScatterValues
- Series.SettingsBarColumn
- Series.SettingsLineAreaScatter
- Series.SettingsPieDoughnut
- Series.ShowLegendEntry
- Series.Trendlines
- Series.Values
- Series.VaryColorsByPoint
- SeriesCollection
- SeriesCollection.CategoryData
- SeriesCollection.Count
- SeriesCollection.CreateSeries
- SeriesCollection.CreateSeries(Area)
- SeriesCollection.CreateSeries(Area, ChartType, AxisType)
- SeriesCollection.CreateSeries(Range)
- SeriesCollection.CreateSeries(Range, ChartType, AxisType)
- SeriesCollection.CreateSeries(String)
- SeriesCollection.CreateSeries(String, ChartType, AxisType)
- SeriesCollection.GetEnumerator()
- SeriesCollection.Item(Int32)
- SeriesCollection.Remove
- SeriesCollection.Remove(Int32)
- SeriesCollection.Remove(Series)
- SeriesCollection.SecondaryCategoryData
- SeriesDataLabel
- SeriesDataLabel.ContainsBubbleSize
- SeriesDataLabel.ContainsCategoryName
- SeriesDataLabel.ContainsSeriesName
- SeriesDataLabel.ContainsValue
- SeriesDataLabel.ContainsValueAsPercentage
- SeriesDataLabel.DataLabelPlacement
- SeriesDataLabel.LabelItemSeperator
- SeriesDataLabel.LinkedToSource
- SeriesDataLabel.ShowLegendKey
- SettingsBarColumn
- SettingsBarColumn.DataShapeType
- SettingsBarColumn.Overlap
- SettingsBarColumn.ShapeType
- SettingsBarColumn.SpaceBetweenCategories
- SettingsLineAreaScatter
- SettingsLineAreaScatter.DropLine
- SettingsLineAreaScatter.HighLowLine
- SettingsLineAreaScatter.ShowDropLines
- SettingsLineAreaScatter.ShowHighLowLines
- SettingsLineAreaScatter.ShowUpDownBars
- SettingsLineAreaScatter.UpDownBar
- SettingsPieDoughnut
- SettingsPieDoughnut.AngleOfFirstSlice
- SettingsPieDoughnut.BopPopGapSize
- SettingsPieDoughnut.BopPopSecondChartSize
- SettingsPieDoughnut.BopPopSeriesLines
- SettingsPieDoughnut.BopPopSplit
- SettingsPieDoughnut.BopPopSplitPercentage
- SettingsPieDoughnut.BopPopSplitPosition
- SettingsPieDoughnut.BopPopSplitType
- SettingsPieDoughnut.BopPopSplitValue
- SettingsPieDoughnut.LeaderLines
- SettingsPieDoughnut.ShowLeaderLines
- SettingsPieDoughnut.SizeOfCenterHole
- SettingsPieDoughnut.SlicesDistanceFromCenter
- SettingsPieDoughnut.UseDefaultSplitValue
- Shape
- Shape.ClearRichTextFormatting()
- Shape.FillColor
- Shape.FillTransparency
- Shape.FitToText
- Shape.GetCharacters
- Shape.GetCharacters(Int32)
- Shape.GetCharacters(Int32, Int32)
- Shape.Height
- Shape.HorizontalAlignment
- Shape.LineColor
- Shape.LockAspectRatio
- Shape.Name
- Shape.ObjectPositioning
- Shape.Position
- Shape.Rotation
- Shape.SetCustomFillColor(Int32, Int32, Int32)
- Shape.SetCustomLineColor(Int32, Int32, Int32)
- Shape.Text
- Shape.Type
- Shape.VerticalAlignment
- Shape.Width
- Shapes
- Shapes.AddShape(Shape)
- Shapes.Count
- Shapes.CreateShape(ShapeType, Anchor)
- Shapes.GetEnumerator()
- Shapes.Item
- Shapes.Item(Int32)
- Shapes.Item(String)
- Shapes.ListShapes()
- Shapes.Remove
- Shapes.Remove(Int32)
- Shapes.Remove(Shape)
- ShapeType
- SharePoint Solution - Excel Export Plus
- SharePointIntegration
- SharePointIntegration API
- SharePointIntegration.BindData(ExcelTemplate, Microsoft.SharePoint.SPList, String, DataBindingProperties)
- SharePointIntegration.BindData(ExcelTemplate, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, String, DataBindingProperties)
- SharePointIntegration.BindRowData(ExcelTemplate, Microsoft.SharePoint.SPList, String, DataBindingProperties)
- SharePointIntegration.BindRowData(ExcelTemplate, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, String, DataBindingProperties)
- SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPList)
- SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPList, DataImportProperties)
- SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList)
- SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)
- SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.SharePoint.SPList)
- SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.SharePoint.SPList, DataImportProperties)
- SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList)
- SharePointIntegration.ImportData(Worksheet, Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)
- SharePointIntegration.Open(ExcelApplication, Microsoft.SharePoint.SPDocumentLibrary, String)
- SharePointIntegration.Open(ExcelApplication, Microsoft.SharePoint.SPListItem, String)
- SharePointIntegration.Open(ExcelTemplate, Microsoft.SharePoint.SPDocumentLibrary, String)
- SharePointIntegration.Open(ExcelTemplate, Microsoft.SharePoint.SPListItem, String)
- SharePointIntegration.Save(ExcelApplication, Workbook, Microsoft.SharePoint.SPDocumentLibrary, String, Boolean)
- SharePointIntegration.Save(ExcelApplication, Workbook, Microsoft.SharePoint.SPListItem, String)
- SharePointIntegration.Save(ExcelTemplate, Microsoft.SharePoint.SPDocumentLibrary, String, Boolean)
- SharePointIntegration.Save(ExcelTemplate, Microsoft.SharePoint.SPListItem, String)
- SheetProtection
- SheetProtection.AllowDeleteColumns
- SheetProtection.AllowDeleteRows
- SheetProtection.AllowFormatCells
- SheetProtection.AllowFormatColumns
- SheetProtection.AllowFormatRows
- SheetProtection.AllowInsertColumns
- SheetProtection.AllowInsertHyperlinks
- SheetProtection.AllowInsertRows
- SheetProtection.AllowSelectLockedCells
- SheetProtection.AllowSelectUnlockedCells
- SheetProtection.AllowSort
- SheetProtection.AllowUseAutoFilter
- SheetProtection.AllowUsePivotTableReports
- ShowValueAs
- ShowValueAs.BaseField
- ShowValueAs.BaseIndex
- ShowValueAs.BaseItemNext
- ShowValueAs.BaseItemPrevious
- ShowValueAs.SetShowValueAs(ShowValueAsType, SourceField, Int32)
- ShowValueAs.ShowValueAsType
- ShowValueAs.ValueType
- Simple Expense Summary
- SortOptions
- SortOptions.Ordering
- SortOptions.OrderingType
- SourceField
- SourceField.Name
- SourceField.Position
- SourceFieldCollection
- SourceFieldCollection.Count
- SourceFieldCollection.Item(Int32)
- SourceFieldCollection.Item(String)
- Stretching Formulas
- String Data Source
- Style
- Style.BackgroundColor
- Style.Border
- Style.CellLocked
- Style.ColumnInsertBehavior
- Style.Font
- Style.ForegroundColor
- Style.HAlign
- Style.HideFormulas
- Style.HorizontalAlignment
- Style.IndentLevel
- Style.JustifyDistributed
- Style.NumberFormat
- Style.Orientation
- Style.Pattern
- Style.RowInsertBehavior
- Style.ShrinkToFit
- Style.TextDir
- Style.TextDirection
- Style.VAlign
- Style.VerticalAlignment
- Style.WrapText
- Styles in ExcelWriter
- Switching from XLS to XLSX or XLSM
- Template Grouping and Nesting
- Template to Application Sample
- Templates and Pivot Tables in Older Versions
- Templates and PivotTables
- The Color Palette
- Time Related Performance Issues
- Topics
- Trendline
- Trendline.BackcastPeriods
- Trendline.ClearIntercept()
- Trendline.ForecastPeriods
- Trendline.Intercept
- Trendline.LegendEntryFont
- Trendline.Line
- Trendline.Name
- Trendline.Regression
- Trendline.RegressionType
- Trendline.RegressionValue
- Trendline.ShowEquation
- Trendline.ShowLegendEntry
- Trendline.ShowRSquaredValue
- Trendline.TrendlineLabel
- Trendline.UseIntercept
- Trendlines
- Trendlines.Count
- Trendlines.CreateTrendline(Trendline.Regression)
- Trendlines.GetEnumerator()
- Trendlines.Item(Int32)
- Trendlines.Remove
- Trendlines.Remove(Int32)
- Trendlines.Remove(Trendline)
- Tutorials
- Two Axis Chart Sample
- UpDownBar
- UpDownBar.DownBarBorderLine
- UpDownBar.DownBarInterior
- UpDownBar.GapBetweenBars
- UpDownBar.UpBarBorderLine
- UpDownBar.UpBarInterior
- Using a Database as a Data Source
- Using an Array as a Data Source
- Using Charts with ExcelTemplate
- Using Data Markers in Sheet Tabs
- Using Grouping and Nesting with ExcelTemplate
- ValueAxis
- ValueAxis.CategoryAxisCrossMaxValue
- ValueAxis.CategoryCrossingValue
- ValueAxis.MajorIncrement
- ValueAxis.MaxValue
- ValueAxis.MinorIncrement
- ValueAxis.MinValue
- ValueAxis.UseLogarithmicScale
- Workbook
- Workbook.CalculateFormulas
- Workbook.CreateConditionalFormat()
- Workbook.CreateCopyPasteProperties(CopyPasteProperties.CopyPasteType)
- Workbook.CreateDataImportProperties()
- Workbook.CreateDataValidation
- Workbook.CreateDataValidation(DataValidation.ValidationType, DataValidation.ComparisonType, Object)
- Workbook.CreateDataValidation(DataValidation.ValidationType, DataValidation.ComparisonType, Object, Object)
- Workbook.CreateDataValidation(DataValidation.ValidationType, DataValidation.ComparisonType, String)
- Workbook.CreateDataValidation(DataValidation.ValidationType, DataValidation.ComparisonType, String, String)
- Workbook.CreateDataValidation(DataValidation.ValidationType, Object)
- Workbook.CreateDataValidation(DataValidation.ValidationType, String)
- Workbook.CreateNamedRange
- Workbook.CreateNamedRange(Area(), String)
- Workbook.CreateNamedRange(String, String)
- Workbook.CreateNamedStyle(String)
- Workbook.CreateRange
- Workbook.CreateRange(Area())
- Workbook.CreateRange(String)
- Workbook.CreateStyle()
- Workbook.DisplayTabs
- Workbook.DocumentProperties
- Workbook.EncryptPassword
- Workbook.ExcludeMacros
- Workbook.FirstDisplayedTab
- Workbook.GetEnumerator()
- Workbook.GetNamedObject(String)
- Workbook.GetNamedRange(String)
- Workbook.GetNamedStyle(String)
- Workbook.GetTextHeight(String, Font, Double)
- Workbook.GetTextWidth(String, Font, Double)
- Workbook.Height
- Workbook.HorizontalPosition
- Workbook.IsProtected
- Workbook.Item
- Workbook.Item(Int32)
- Workbook.Item(String)
- Workbook.NamedRanges
- Workbook.NumberFormat
- Workbook.Palette
- Workbook.PasswordToModify
- Workbook.Protect(String)
- Workbook.ProtectPasswordHash
- Workbook.ReadOnly
- Workbook.ReadOnlyRecommended
- Workbook.RegisterCustomFunction
- Workbook.RemoveFormulas
- Workbook.ShowHorizontalScrollBar
- Workbook.ShowVerticalScrollBar
- Workbook.TabRatio
- Workbook.Unprotect()
- Workbook.UseRCFormulaNotation
- Workbook.VerticalPosition
- Workbook.Width
- Workbook.Worksheets
- Worksheet
- Worksheet.AutoFilter
- Worksheet.Cells
- Worksheet.Charts
- Worksheet.Comments
- Worksheet.Constants
- Worksheet.CopyPaste
- Worksheet.CopyPaste(Cell, Area)
- Worksheet.CopyPaste(Cell, Area, CopyPasteProperties)
- Worksheet.CopyPaste(Int32, Int32, Area)
- Worksheet.CopyPaste(Int32, Int32, Area, CopyPasteProperties)
- Worksheet.CopyPaste(String, Area)
- Worksheet.CopyPaste(String, Area, CopyPasteProperties)
- Worksheet.CreateAnchor(Int32, Int32, Double, Double)
- Worksheet.CreateArea
- Worksheet.CreateArea(Int32, Int32, Int32, Int32)
- Worksheet.CreateArea(String)
- Worksheet.CreateAreaOfColumns(Int32, Int32)
- Worksheet.CreateAreaOfRows(Int32, Int32)
- Worksheet.CreateNamedRange
- Worksheet.CreateNamedRange(Int32, Int32, Int32, Int32, String)
- Worksheet.CreateNamedRange(String, String)
- Worksheet.CreateRange(String)
- Worksheet.DeleteColumn(Int32)
- Worksheet.DeleteColumns(Int32, Int32)
- Worksheet.DeleteRow(Int32)
- Worksheet.DeleteRows(Int32, Int32)
- Worksheet.FirstShownColumn
- Worksheet.FirstShownRow
- Worksheet.FreezePanes
- Worksheet.GetColumnProperties(Int32)
- Worksheet.GetNamedObject(String)
- Worksheet.GetNamedRange(String)
- Worksheet.GetRowProperties(Int32)
- Worksheet.GridlinesColor
- Worksheet.GroupColumns(Int32, Int32, Boolean)
- Worksheet.GroupRows(Int32, Int32, Boolean)
- Worksheet.Hyperlinks
- Worksheet.ImportData
- Worksheet.ImportData(Object()(), Cell)
- Worksheet.ImportData(Object()(), String(), Cell, DataImportProperties)
- Worksheet.ImportData(Object(,), Cell)
- Worksheet.ImportData(Object(,), String(), Cell, DataImportProperties)
- Worksheet.ImportData(System.Data.DataTable, Cell)
- Worksheet.ImportData(System.Data.DataTable, Cell, DataImportProperties)
- Worksheet.ImportData(System.Data.DataView, Cell)
- Worksheet.ImportData(System.Data.DataView, Cell, DataImportProperties)
- Worksheet.ImportData(System.Data.IDataReader, Cell)
- Worksheet.ImportData(System.Data.IDataReader, Cell, DataImportProperties)
- Worksheet.InsertColumn
- Worksheet.InsertColumn(Int32)
- Worksheet.InsertColumn(Int32, Style.ColumnInsertBehavior)
- Worksheet.InsertColumn(Int32, Style.ColumnInsertBehavior, Style.ColumnInsertBehavior)
- Worksheet.InsertColumns
- Worksheet.InsertColumns(Int32, Int32)
- Worksheet.InsertColumns(Int32, Int32, Style.ColumnInsertBehavior)
- Worksheet.InsertColumns(Int32, Int32, Style.ColumnInsertBehavior, Style.ColumnInsertBehavior)
- Worksheet.InsertHorizontalPageBreak(Cell)
- Worksheet.InsertRow
- Worksheet.InsertRow(Int32)
- Worksheet.InsertRow(Int32, Style.RowInsertBehavior)
- Worksheet.InsertRow(Int32, Style.RowInsertBehavior, Style.RowInsertBehavior)
- Worksheet.InsertRows
- Worksheet.InsertRows(Int32, Int32)
- Worksheet.InsertRows(Int32, Int32, Style.RowInsertBehavior)
- Worksheet.InsertRows(Int32, Int32, Style.RowInsertBehavior, Style.RowInsertBehavior)
- Worksheet.InsertVerticalPageBreak(Cell)
- Worksheet.IsProtected
- Worksheet.IsSelected
- Worksheet.Item
- Worksheet.Item(Int32, Int32)
- Worksheet.Item(String)
- Worksheet.Name
- Worksheet.NamedRanges
- Worksheet.PageSetup
- Worksheet.Pictures
- Worksheet.PivotTables
- Worksheet.PopulatedCells
- Worksheet.Position
- Worksheet.Protect(String)
- Worksheet.ProtectPasswordHash
- Worksheet.RemoveFormulas
- Worksheet.Select()
- Worksheet.ShapeGroups
- Worksheet.Shapes
- Worksheet.SheetProtection
- Worksheet.SheetViewState
- Worksheet.SheetVisibility
- Worksheet.ShowFormulas
- Worksheet.ShowGridlines
- Worksheet.ShowRowColHeaders
- Worksheet.ShowZeroValues
- Worksheet.StandardHeight
- Worksheet.StandardWidth
- Worksheet.StandardWidthInChars
- Worksheet.SummaryColumns
- Worksheet.SummaryColumnsLocation
- Worksheet.SummaryRows
- Worksheet.SummaryRowsLocation
- Worksheet.TabColor
- Worksheet.UngroupColumns(Int32, Int32)
- Worksheet.UngroupRows(Int32, Int32)
- Worksheet.Unprotect()
- Worksheet.ViewState
- Worksheet.Visibility
- Worksheet.Workbook
- Worksheet.ZoomPercentage
- Worksheets
- Worksheets.CopySheet(Worksheet, Int32, String)
- Worksheets.Count
- Worksheets.CreateChartsheet
- Worksheets.CreateChartsheet(ChartType, String)
- Worksheets.CreateChartsheet(ChartType, String, Int32)
- Worksheets.CreateWorksheet
- Worksheets.CreateWorksheet(String)
- Worksheets.CreateWorksheet(String, Int32)
- Worksheets.Delete
- Worksheets.Delete(Int32)
- Worksheets.Delete(String)
- Worksheets.GetEnumerator()
- Worksheets.InsertSheet(String, Int32)
- Worksheets.Item
- Worksheets.Item(Int32)
- Worksheets.Item(String)
- Worksheets.MoveSheet(Worksheet, Int32)
- Worksheets.Select(Object())
- XML Data Import