Click or drag to resize

IChartDataTable Interface

Represents the chart data table.

Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public interface IChartDataTable : IFont, 
	IExcelApplication, IOptimizedUpdate

The IChartDataTable type exposes the following members.

Properties
Name Description
Public property BackgroundMode
Gets or sets the background mode of the chart, which determines how the background is rendered.
Public property Color
Gets / sets font color. Searches for the closestes color in the workbook palette.
(Inherited from IFont .)
Public property FontName
Returns or sets the font name. Read / write string.
(Inherited from IFont .)
Public property Code example HasBorders
True if data table has borders.
Examples
The following code illustrates how to outline borders of IChartDataTable object:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:F2"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.ColumnClustered;</para><para>//Enabling the data table</para><para>chart.HasDataTable = true;</para><para>//Get data table of the chart</para><para>IChartDataTable dataTable = chart.DataTable;</para><para>//Set false to remove the borders in data table</para><para>dataTable.HasBorders = false;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example HasHorzBorder
True if data table has horizontal border.
Examples
The following code illustrates how to remove horizontal border for IChartDataTable object:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:F2"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.ColumnClustered;</para><para>//Enabling the data table</para><para>chart.HasDataTable = true;</para><para>//Get data table of the chart</para><para>IChartDataTable dataTable = chart.DataTable;</para><para>//Set false to remove the horizontal border in data table</para><para>dataTable.HasHorzBorder = false;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example HasVertBorder
True if data table has vertical border.
Examples
The following code illustrates how to remove vertical border for IChartDataTable object:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:F2"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.ColumnClustered;</para><para>//Enabling the data table</para><para>chart.HasDataTable = true;</para><para>//Get data table of the chart</para><para>IChartDataTable dataTable = chart.DataTable;</para><para>//Set false to remove the vertical border in data table</para><para>dataTable.HasVertBorder = false;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property IsAutoColor
Indicates whether color is automatically selected. Read-only.
(Inherited from IFont .)
Public property IsBold
True if the font is bold. Read / write Boolean.
(Inherited from IFont .)
Public property IsItalic
True if the font style is italic. Read / write Boolean.
(Inherited from IFont .)
Public property IsStrikethrough
True if the font is struck through with a horizontal line. Read / write Boolean
(Inherited from IFont .)
Public property IsSubscript
True if the font is formatted as subscript. False by default. Read / write Boolean.
(Inherited from IFont .)
Public property IsSuperscript
True if the font is formatted as superscript. False by default. Read/write Boolean
(Inherited from IFont .)
Public property KnownColor
Returns or sets the primary color of the object, as shown in the following table. Use the RGB function to create a color value. Read / write Integer.
(Inherited from IFont .)
Public property Parent
Gets the parent object of the current instance.
(Inherited from IExcelApplication .)
Public property Code example ShowSeriesKeys
True if there is series keys in the data table.
Examples
The following code illustrates how to show series keys in the IChartDataTable object:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:F2"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.ColumnClustered;</para><para>//Enabling the data table</para><para>chart.HasDataTable = true;</para><para>//Get data table of the chart</para><para>IChartDataTable dataTable = chart.DataTable;</para><para>//Set true to show series keys in the data table</para><para>dataTable.ShowSeriesKeys = true;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Size
Returns or sets the size of the font. Read / write Variant.
(Inherited from IFont .)
Public property StrikethroughType
Strikethrough Type. Read / write sngStrike dblStrike
(Inherited from IFont .)
Public property Underline
Returns or sets the type of underline applied to the font. Can be one of the following FontUnderlineTypeStyle constants. Read / write FontUnderlineType.
(Inherited from IFont .)
Public property VerticalAlignment
Gets / sets font vertical alignment.
(Inherited from IFont .)
Top
Methods
Name Description
Public method BeginUpdate
This method should be called before several updates to the object will take place.
(Inherited from IOptimizedUpdate .)
Public method EndUpdate
This method should be called after several updates to the object took place.
(Inherited from IOptimizedUpdate .)
Public method GenerateNativeFont
Generates .Net font object corresponding to the current font.
(Inherited from IFont .)
Public method GetThemeColor
Get the theme color.
(Inherited from IFont .)
Public method SetThemeColor
Set the theme color.
(Inherited from IFont .)
Top
See Also