XlsChartFrameFormat Properties |
The XlsChartFrameFormat type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
|
BackGroundColor |
Represents foreground known color.
|
|
|
BackGroundColorObject |
Represents background color.
|
|
|
BackGroundKnownColor |
Represents the known color used for the background in Excel.
|
|
|
Border |
Gets chart border. Read only.
|
|
Fill |
Represents XlsFill gradient format. Read only.
Examples
The following code illustrates the use of Fill property:
<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["B2:C6"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.Column3DClustered;</para><para>//Gets fill options for the chart element</para><para>IShapeFill fillChart = chart.ChartArea.Fill;</para><para>fillChart.FillType = ShapeFillType.Gradient;</para><para>fillChart.BackColor = Color.FromArgb(205, 217, 234);</para><para>fillChart.ForeColor = Color.White;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
|
|
ForeGroundColor |
Represents foreground known color.
|
|
|
ForeGroundColorObject |
Represents foreground color.
|
|
|
ForeGroundKnownColor |
Represents foreground known color.
|
|
|
Format3D |
Gets the chart3 D properties.
Examples
The following code illustrates the use of Shadow property:
<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["B2:C6"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.Column3DClustered;</para><para>//Gets shadow formatting properties for the chart element</para><para>ChartShadow shadowChart = chart.ChartArea.Shadow;</para><para>shadowChart.ShadowPrespectiveType = XLSXChartPrespectiveType.Below;</para><para>shadowChart.Color = Color.Aqua;</para><para>shadowChart.Blur = 22;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
|
|
HasFormat3D |
This property Indicates whether the Shadow object has been created(which includes the 3D properties)
|
|
|
HasInterior |
Indicates whether interior object was created. Read-only.
|
|
|
HasLineProperties |
Indicates whether border formatting object was created. Read-only.
|
|
|
HasManualLayout |
Obsolete.
Indicates whether border formatting object was created. Read-only.
|
|
|
HasShadow |
This property indicates whether the shadow object has been created
|
|
|
Height |
Y-size. 1/4000 of chart plot. IsHMode Shall set to True
|
|
|
InnerLayoutTarget |
Obsolete.
Gets or sets the inner layout target. Note: This property is obsolete and the get and set operations are not implemented.
|
|
|
Interior |
Gets frame interior. Read only
|
|
|
IsAutomaticFormat |
Represents if use automatic format.
|
|
|
IsAutoPosition |
Calculates position automatically.
|
|
|
IsAutoSize |
Calculates size automatically.
|
|
|
IsBorderCornersRound |
Gets or sets if border corners is round.
|
|
|
IsHMode |
false value Specifies that the Height shall be interpreted
as the Bottom of the chart element..
|
|
|
IsWMode |
false value Specifies that the Width shall be interpreted
as the Right of the chart element..
|
|
|
IsXMode |
true value Specifies that the X shall be interpreted
as the Left of the chart element..
|
|
|
IsYMode |
true value Specifies that the Y shall be interpreted
as the Top of the chart element..
|
|
|
LineProperties |
Gets chart border. Read-only.
|
|
|
Parent |
Reference to Parent object. Read-only.
(Inherited from
XlsObject
.)
|
|
|
Pattern |
Represents pattern.
|
|
|
RectangleStyle |
Obsolete.
Rectangle style.
|
|
ReferenceCount |
Get quantity of instance references.
(Inherited from
XlsObject
.)
|
|
|
Shadow |
Gets the shadow properties.
Examples
The following code illustrates the use of Shadow property:
<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["B2:C6"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.Column3DClustered;</para><para>//Gets shadow formatting properties for the chart element</para><para>ChartShadow shadowChart = chart.ChartArea.Shadow;</para><para>shadowChart.ShadowPrespectiveType = XLSXChartPrespectiveType.Below;</para><para>shadowChart.Color = Color.Aqua;</para><para>shadowChart.Blur = 22;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
|
|
Visible |
Represents visiblity.
|
|
|
Width |
X-size. 1/4000 of chart plot. IsWMode Shall set to True
|
|
|
X |
X-position of upper-left corner. 1/4000 of chart plot.
IsXMode Shall set to True
|
|
|
Y |
Y-position of upper-left corner. 1/4000 of chart plot.
IsYMode Shall set to True
|
See Also
