Class ChartExcelExport

Inheritance

System.Object

ChartExcelExport

Inherited Members

System.Object.ToString()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: Syncfusion.EJ.Export

Assembly: Syncfusion.EJ.Export.dll

Syntax

public class ChartExcelExport

Constructors

ChartExcelExport()

Declaration

public ChartExcelExport()

Fields

IsSeriesInRows

Declaration

public bool IsSeriesInRows

Field Value

Type	Description
System.Boolean

Properties

Chart

Gets or sets the Chart.

Declaration

public IChart Chart { get; set; }

Property Value

Type	Description
IChart	Chart

ChartPosition

Gets or sets position for chart.

Declaration

public ChartPosition ChartPosition { get; set; }

Property Value

Type	Description
ChartPosition	Position for chart.

DataSource

Gets or sets the datasource of the chart.

Declaration

public IEnumerable DataSource { get; set; }

Property Value

Type	Description
System.Collections.IEnumerable	The Datasource of the chart.

DownloadType

Gets or sets the Excel download type of the file.

Declaration

public ExcelDownloadType DownloadType { get; set; }

Property Value

Type	Description
ExcelDownloadType	DownloadType.

ExcelRange

Gets or sets the is Data Range.

Declaration

public string ExcelRange { get; set; }

Property Value

Type	Description
System.String	The LocalSave option for file.

Excelversion

Gets or sets the excel version.

Declaration

public ExcelVersion Excelversion { get; set; }

Property Value

Type	Description
ExcelVersion	The excel version.

ExportType

Gets or sets the MultipleExportType for the file.

Declaration

public MultipleExportType ExportType { get; set; }

Property Value

Type	Description
MultipleExportType	The MultipleExportType for file.

FileName

Gets or sets the name of the file.

Declaration

public string FileName { get; set; }

Property Value

Type	Description
System.String	The name of the file.

FilePath

Gets or sets the File Path for saving file.

Declaration

public string FilePath { get; set; }

Property Value

Type	Description
System.String	The File Path for saving file in local.

Query

Gets or sets the number of rows.

Declaration

public double Query { get; set; }

Property Value

Type	Description
System.Double	Number of rows.

SaveLocal

Gets or sets the is file locally saved.

Declaration

public bool SaveLocal { get; set; }

Property Value

Type	Description
System.Boolean	The LocalSave option for file.

Sheet

Gets or sets the Chart.

Declaration

public IWorksheet Sheet { get; set; }

Property Value

Type	Description
IWorksheet	Chart

SourceType

Declaration

public Type SourceType { get; set; }

Property Value

Type	Description
System.Type

Methods

ChangeSeriesType(SeriesType, Boolean, ColumnFacet)

Declaration

public ExcelChartType ChangeSeriesType(SeriesType type, bool enable3D, ColumnFacet columnFacet)

Parameters

Type	Name	Description
SeriesType	type
System.Boolean	enable3D
ColumnFacet	columnFacet

Returns

Type	Description
ExcelChartType

ChangeTrendlineType(TrendlineType)

Declaration

public ExcelTrendLineType ChangeTrendlineType(TrendlineType type)

Parameters

Type	Name	Description
TrendlineType	type

Returns

Type	Description
ExcelTrendLineType

ChartCustomization()

Declaration

public void ChartCustomization()

CustomizeCategoryAxis(IChartCategoryAxis, Axis)

Declaration

public void CustomizeCategoryAxis(IChartCategoryAxis excelAxis, Axis axis)

Parameters

Type	Name	Description
IChartCategoryAxis	excelAxis
Axis	axis

CustomizeValueAxis(IChartValueAxis, Axis)

Declaration

public void CustomizeValueAxis(IChartValueAxis excelAxis, Axis axis)

Parameters

Type	Name	Description
IChartValueAxis	excelAxis
Axis	axis

DataLabelPosition(TextPosition, SeriesType)

Declaration

public ExcelDataLabelPosition DataLabelPosition(TextPosition position, SeriesType type)

Parameters

Type	Name	Description
TextPosition	position
SeriesType	type

Returns

Type	Description
ExcelDataLabelPosition

DrawDataLabel()

Declaration

public void DrawDataLabel()

DrawMarker()

Declaration

public void DrawMarker()

Export(ChartProperties, IEnumerable, Boolean)

Declaration

public IWorkbook Export(ChartProperties chartModel, IEnumerable datasource, bool multipleExport)

Parameters

Type	Name	Description
ChartProperties	chartModel
System.Collections.IEnumerable	datasource
System.Boolean	multipleExport

Returns

Type	Description
IWorkbook

ExportChart()

Declaration

public void ExportChart()

InitializeExcel(IWorkbook)

Declaration

public void InitializeExcel(IWorkbook book)

Parameters

Type	Name	Description
IWorkbook	book

InitializeLegend()

Declaration

public void InitializeLegend()

InitializeModelProperty(ChartProperties)

Declaration

public void InitializeModelProperty(ChartProperties chartModel)

Parameters

Type	Name	Description
ChartProperties	chartModel

InitializeXAxis()

Declaration

public void InitializeXAxis()

MarkerShape(ChartShape)

Declaration

public ExcelChartMarkerType MarkerShape(ChartShape shape)

Parameters

Type	Name	Description
ChartShape	shape

Returns

Type	Description
ExcelChartMarkerType

RenderSeries()

Declaration

public void RenderSeries()

RGBColor(String)

Declaration

public Color RGBColor(string color)

Parameters

Type	Name	Description
System.String	color

Returns

Type	Description
System.Drawing.Color

SaveLocalFile(String)

Declaration

public void SaveLocalFile(string filepath)

Parameters

Type	Name	Description
System.String	filepath

SetDataRange()

Declaration

public void SetDataRange()