Class Floor

Class Floor

命名空间: Aspose.Cells.Charts
程序集: Aspose.Cells.dll (25.2.0)

封装表示 3-D 图表底部的对象。

public class Floor : Area

继承

object ← Area ← Floor

派生

Walls

继承成员

Area.BackgroundColor, Area.ForegroundColor, Area.Formatting, Area.InvertIfNegative, Area.FillFormat, Area.Transparency, object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()

示例 


//实例化 License 类
Aspose.Cells.License license = new Aspose.Cells.License();

//仅传递嵌入程序集中的许可证文件名称
license.SetLicense("Aspose.Cells.lic");

//实例化工作簿对象
Workbook workbook = new Workbook();

//获取单元格集合
Cells cells = workbook.Worksheets[0].Cells;

//在单元格中放置值
cells["A1"].PutValue(1);

cells["A2"].PutValue(2);

cells["A3"].PutValue(3);

//获取图表集合
ChartCollection charts = workbook.Worksheets[0].Charts;

//添加一个新图表 
int index = charts.Add(ChartType.Column3DStacked, 5, 0, 15, 5);

//获取新添加的图表
Chart chart = charts[index];

//设置图表系列
chart.NSeries.Add("A1:A3", true);

//显示数据标签
chart.NSeries[0].DataLabels.ShowValue = true;

//获取图表的底部
Floor floor = chart.Floor;

//将底部边框设置为红色
floor.Border.Color = System.Drawing.Color.Red;

//设置填充格式
floor.FillFormat.SetPresetColorGradient(GradientPresetType.CalmWater, GradientStyleType.DiagonalDown, 2); 

//保存文件
workbook.Save(@"dest.xls");

'实例化 License 类
Dim license As New Aspose.Cells.License()

'仅传递嵌入程序集中的许可证文件名称
license.SetLicense("Aspose.Cells.lic")

'实例化工作簿对象
Dim workbook As Workbook = New Workbook()

'获取单元格集合
Dim cells As Cells = workbook.Worksheets(0).Cells

'在单元格中放置值
cells("A1").PutValue(1)

cells("A2").PutValue(2)

cells("A3").PutValue(3)

'获取图表集合
Dim charts As ChartCollection = workbook.Worksheets(0).Charts

'添加一个新图表 
Dim index As Integer = charts.Add(ChartType.Column3DStacked, 5, 0, 15, 5)

'获取新添加的图表
Dim chart As Chart = charts(index)

'设置图表系列
chart.NSeries.Add("A1:A3", True)

'显示数据标签
chart.NSeries(0).DataLabels.ShowValue = True

'获取图表的底部
Dim floor As Floor = chart.Floor

'将底部边框设置为红色
floor.Border.Color = System.Drawing.Color.Red

'设置填充格式
floor.FillFormat.SetPresetColorGradient(GradientPresetType.CalmWater, GradientStyleType.DiagonalDown, 2)

'保存文件
workbook.Save("dest.xls")

字段

m_SpPr 

protected ShapePropertyCollection m_SpPr

字段值

ShapePropertyCollection

属性

Border

获取或设置边框 Aspose.Cells.Drawing.Line。

public Line Border { get; set; }

属性值

Line

 中文