alexa
menu

MAUI

  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Search Results for

    Show / Hide Table of Contents

    Interface IThreeDFormat

    Represents the three-dimensional chart format.

    Namespace: Syncfusion.XlsIO
    Assembly: Syncfusion.XlsIO.NET.dll
    Syntax
    public interface IThreeDFormat

    Properties

    BevelBottom

    Gets or sets the bevel bottom. The bevel bottom property value from Excel2007ChartBevelProperties.

    Declaration
    Excel2007ChartBevelProperties BevelBottom { get; set; }
    Property Value
    Type Description
    Excel2007ChartBevelProperties

    The bevel bottom.

    Remarks

    To know more about charts refer this link.

    Examples

    The following code illustrates the use of BevelBottom property.

            <pre><code class="lang-csharp">using (ExcelEngine excelEngine = new ExcelEngine())
    

    { //Create a worksheet.
    IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet sheet = workbook.Worksheets[0]; sheet.Range["A1"].Text = "Student ID"; sheet.Range["B1"].Text = "Student Name"; sheet.Range["C1"].Text = "Mark(Out of 100)"; sheet.Range["A1:C1"].AutofitColumns(); sheet.Range["A2"].Number = 1; sheet.Range["A3"].Number = 2; sheet.Range["A4"].Number = 3; sheet.Range["A5"].Number = 4; sheet.Range["A6"].Number = 5; sheet.Range["B2"].Text = "Andrew"; sheet.Range["B3"].Text = "Marson"; sheet.Range["B4"].Text = "Jack"; sheet.Range["B5"].Text = "Sam"; sheet.Range["B6"].Text = "Breto"; sheet.Range["C2"].Number = 77; sheet.Range["C3"].Number = 45; sheet.Range["C4"].Number = 92; sheet.Range["C5"].Number = 39; sheet.Range["C6"].Number = 55;

    //Create a Chart IChartShape chart = sheet.Charts.Add(); chart.LeftColumn = 5; chart.RightColumn = 11; chart.Name = "Student Sample Chart"; chart.ChartType = ExcelChartType.Column_Clustered_3D; chart.DataRange = sheet.Range["B2:C6"]; chart.IsSeriesInRows = false;

    //sets the bevel bottom value chart.Series[0].SerieFormat.ThreeD.BevelBottom = Excel2007ChartBevelProperties.Convex; chart.Series[0].SerieFormat.ThreeD.BevelBottomHeight = 16; chart.Series[0].SerieFormat.ThreeD.BevelBottomWidth = 7;

    workbook.SaveAs("Charts.xlsx"); workbook.Close(); }

    BevelBottomHeight

    Gets or sets the bevel bottom height. This property used to adjust the height of BevelBottom property.

    Declaration
    int BevelBottomHeight { get; set; }
    Property Value
    Type Description
    int

    The bevel bottom height.

    Remarks

    To know more about charts refer this link.

    Examples

    The following code illustrates the use of BevelBottomHeight property.

            <pre><code class="lang-csharp">using (ExcelEngine excelEngine = new ExcelEngine())
    

    { //Create a worksheet.
    IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet sheet = workbook.Worksheets[0]; sheet.Range["A1"].Text = "Student ID"; sheet.Range["B1"].Text = "Student Name"; sheet.Range["C1"].Text = "Mark(Out of 100)"; sheet.Range["A1:C1"].AutofitColumns(); sheet.Range["A2"].Number = 1; sheet.Range["A3"].Number = 2; sheet.Range["A4"].Number = 3; sheet.Range["A5"].Number = 4; sheet.Range["A6"].Number = 5; sheet.Range["B2"].Text = "Andrew"; sheet.Range["B3"].Text = "Marson"; sheet.Range["B4"].Text = "Jack"; sheet.Range["B5"].Text = "Sam"; sheet.Range["B6"].Text = "Breto"; sheet.Range["C2"].Number = 77; sheet.Range["C3"].Number = 45; sheet.Range["C4"].Number = 92; sheet.Range["C5"].Number = 39; sheet.Range["C6"].Number = 55;

    //Create a Chart IChartShape chart = sheet.Charts.Add(); chart.LeftColumn = 5; chart.RightColumn = 11; chart.Name = "Student Sample Chart"; chart.ChartType = ExcelChartType.Column_Clustered_3D; chart.DataRange = sheet.Range["B2:C6"]; chart.IsSeriesInRows = false; chart.Series[0].SerieFormat.ThreeD.BevelBottom = Excel2007ChartBevelProperties.Convex;

    //sets the bevel bottom height value
    chart.Series[0].SerieFormat.ThreeD.BevelBottomHeight = 16; chart.Series[0].SerieFormat.ThreeD.BevelBottomWidth = 7;

    workbook.SaveAs("Charts.xlsx"); workbook.Close(); }

    BevelBottomWidth

    Gets or sets the bevel bottom width. This property used to adjust the width of BevelBottom property.

    Declaration
    int BevelBottomWidth { get; set; }
    Property Value
    Type Description
    int

    The bevel bottom width.

    Remarks

    To know more about charts refer this link.

    Examples

    The following code illustrates the use of BevelBottomWidth property.

            <pre><code class="lang-csharp">using (ExcelEngine excelEngine = new ExcelEngine())
    

    { //Create a worksheet.
    IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet sheet = workbook.Worksheets[0]; sheet.Range["A1"].Text = "Student ID"; sheet.Range["B1"].Text = "Student Name"; sheet.Range["C1"].Text = "Mark(Out of 100)"; sheet.Range["A1:C1"].AutofitColumns(); sheet.Range["A2"].Number = 1; sheet.Range["A3"].Number = 2; sheet.Range["A4"].Number = 3; sheet.Range["A5"].Number = 4; sheet.Range["A6"].Number = 5; sheet.Range["B2"].Text = "Andrew"; sheet.Range["B3"].Text = "Marson"; sheet.Range["B4"].Text = "Jack"; sheet.Range["B5"].Text = "Sam"; sheet.Range["B6"].Text = "Breto"; sheet.Range["C2"].Number = 77; sheet.Range["C3"].Number = 45; sheet.Range["C4"].Number = 92; sheet.Range["C5"].Number = 39; sheet.Range["C6"].Number = 55;

    //Create a Chart IChartShape chart = sheet.Charts.Add(); chart.LeftColumn = 5; chart.RightColumn = 11; chart.Name = "Student Sample Chart"; chart.ChartType = ExcelChartType.Column_Clustered_3D; chart.DataRange = sheet.Range["B2:C6"]; chart.IsSeriesInRows = false; chart.Series[0].SerieFormat.ThreeD.BevelBottom = Excel2007ChartBevelProperties.Convex;

    //sets the bevel bottom width value
    chart.Series[0].SerieFormat.ThreeD.BevelBottomWidth = 7; chart.Series[0].SerieFormat.ThreeD.BevelBottomHeight = 16;

    workbook.SaveAs("Charts.xlsx"); workbook.Close(); }

    BevelTop

    Gets or sets the bevel top. The bevel top property value from Excel2007ChartBevelProperties.

    Declaration
    Excel2007ChartBevelProperties BevelTop { get; set; }
    Property Value
    Type Description
    Excel2007ChartBevelProperties

    The bevel top.

    Remarks

    To know more about charts refer this link.

    Examples

    The following code illustrates the use of BevelTop property.

            <pre><code class="lang-csharp">using (ExcelEngine excelEngine = new ExcelEngine())
    

    { //Create a worksheet.
    IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet sheet = workbook.Worksheets[0]; sheet.Range["A1"].Text = "Student ID"; sheet.Range["B1"].Text = "Student Name"; sheet.Range["C1"].Text = "Mark(Out of 100)"; sheet.Range["A1:C1"].AutofitColumns(); sheet.Range["A2"].Number = 1; sheet.Range["A3"].Number = 2; sheet.Range["A4"].Number = 3; sheet.Range["A5"].Number = 4; sheet.Range["A6"].Number = 5; sheet.Range["B2"].Text = "Andrew"; sheet.Range["B3"].Text = "Marson"; sheet.Range["B4"].Text = "Jack"; sheet.Range["B5"].Text = "Sam"; sheet.Range["B6"].Text = "Breto"; sheet.Range["C2"].Number = 77; sheet.Range["C3"].Number = 45; sheet.Range["C4"].Number = 92; sheet.Range["C5"].Number = 39; sheet.Range["C6"].Number = 55;

    //Create a Chart IChartShape chart = sheet.Charts.Add(); chart.LeftColumn = 5; chart.RightColumn = 11; chart.Name = "Student Sample Chart"; chart.ChartType = ExcelChartType.Cone_Clustered_3D; chart.DataRange = sheet.Range["B2:C6"];

    //sets the bevel top value chart.ChartArea.ThreeD.BevelTop = Excel2007ChartBevelProperties.Slope;

    workbook.SaveAs("Charts.xlsx"); workbook.Close(); }

    BevelTopHeight

    Gets or sets the bevel top height. This property used to adjust the height of BevelTop property.

    Declaration
    int BevelTopHeight { get; set; }
    Property Value
    Type Description
    int

    The bevel top height.

    Remarks

    To know more about charts refer this link.

    Examples

    The following code illustrates the use of BevelTopHeight property.

            <pre><code class="lang-csharp">using (ExcelEngine excelEngine = new ExcelEngine())
    

    { //Create a worksheet.
    IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet sheet = workbook.Worksheets[0]; sheet.Range["A1"].Text = "Student ID"; sheet.Range["B1"].Text = "Student Name"; sheet.Range["C1"].Text = "Mark(Out of 100)"; sheet.Range["A1:C1"].AutofitColumns(); sheet.Range["A2"].Number = 1; sheet.Range["A3"].Number = 2; sheet.Range["A4"].Number = 3; sheet.Range["A5"].Number = 4; sheet.Range["A6"].Number = 5; sheet.Range["B2"].Text = "Andrew"; sheet.Range["B3"].Text = "Marson"; sheet.Range["B4"].Text = "Jack"; sheet.Range["B5"].Text = "Sam"; sheet.Range["B6"].Text = "Breto"; sheet.Range["C2"].Number = 77; sheet.Range["C3"].Number = 45; sheet.Range["C4"].Number = 92; sheet.Range["C5"].Number = 39; sheet.Range["C6"].Number = 55;

    //Create a Chart IChartShape chart = sheet.Charts.Add(); chart.LeftColumn = 5; chart.RightColumn = 11; chart.Name = "Student Sample Chart"; chart.ChartType = ExcelChartType.Cone_Clustered_3D; chart.DataRange = sheet.Range["B2:C6"]; chart.ChartArea.ThreeD.BevelTop = Excel2007ChartBevelProperties.Slope;

    //sets the bevel top height value chart.ChartArea.ThreeD.BevelTopHeight = 16; chart.ChartArea.ThreeD.BevelTopWidth = 7;

    workbook.SaveAs("Charts.xlsx"); workbook.Close(); }

    BevelTopWidth

    Gets or sets the bevel top width. This property used to adjust the width of BevelTop property.

    Declaration
    int BevelTopWidth { get; set; }
    Property Value
    Type Description
    int

    The bevel top width.

    Remarks

    To know more about charts refer this link.

    Examples

    The following code illustrates the use of BevelTopWidth property.

            <pre><code class="lang-csharp">using (ExcelEngine excelEngine = new ExcelEngine())
    

    { //Create a worksheet.
    IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet sheet = workbook.Worksheets[0]; sheet.Range["A1"].Text = "Student ID"; sheet.Range["B1"].Text = "Student Name"; sheet.Range["C1"].Text = "Mark(Out of 100)"; sheet.Range["A1:C1"].AutofitColumns(); sheet.Range["A2"].Number = 1; sheet.Range["A3"].Number = 2; sheet.Range["A4"].Number = 3; sheet.Range["A5"].Number = 4; sheet.Range["A6"].Number = 5; sheet.Range["B2"].Text = "Andrew"; sheet.Range["B3"].Text = "Marson"; sheet.Range["B4"].Text = "Jack"; sheet.Range["B5"].Text = "Sam"; sheet.Range["B6"].Text = "Breto"; sheet.Range["C2"].Number = 77; sheet.Range["C3"].Number = 45; sheet.Range["C4"].Number = 92; sheet.Range["C5"].Number = 39; sheet.Range["C6"].Number = 55;

    //Create a Chart IChartShape chart = sheet.Charts.Add(); chart.LeftColumn = 5; chart.RightColumn = 11; chart.Name = "Student Sample Chart"; chart.ChartType = ExcelChartType.Cone_Clustered_3D; chart.DataRange = sheet.Range["B2:C6"]; chart.ChartArea.ThreeD.BevelTop = Excel2007ChartBevelProperties.Slope;

    //sets the bevel top width value chart.ChartArea.ThreeD.BevelTopWidth = 7; chart.ChartArea.ThreeD.BevelTopHeight = 16;

    workbook.SaveAs("Charts.xlsx"); workbook.Close(); }

    Lighting

    Gets or sets the lighting. The lighting property value from Excel2007ChartLightingProperties.

    Declaration
    Excel2007ChartLightingProperties Lighting { get; set; }
    Property Value
    Type Description
    Excel2007ChartLightingProperties

    The lighting.

    Remarks

    To know more about charts refer this link.

    Examples

    The following code illustrates the use of Lighting property.

            <pre><code class="lang-csharp">using (ExcelEngine excelEngine = new ExcelEngine())
    

    { //Create a worksheet.
    IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet sheet = workbook.Worksheets[0]; sheet.Range["A1"].Text = "Student ID"; sheet.Range["B1"].Text = "Student Name"; sheet.Range["C1"].Text = "Mark(Out of 100)"; sheet.Range["A1:C1"].AutofitColumns(); sheet.Range["A2"].Number = 1; sheet.Range["A3"].Number = 2; sheet.Range["A4"].Number = 3; sheet.Range["A5"].Number = 4; sheet.Range["A6"].Number = 5; sheet.Range["B2"].Text = "Andrew"; sheet.Range["B3"].Text = "Marson"; sheet.Range["B4"].Text = "Jack"; sheet.Range["B5"].Text = "Sam"; sheet.Range["B6"].Text = "Breto"; sheet.Range["C2"].Number = 77; sheet.Range["C3"].Number = 45; sheet.Range["C4"].Number = 92; sheet.Range["C5"].Number = 39; sheet.Range["C6"].Number = 55;

    //Create a Chart IChartShape chart = sheet.Charts.Add(); chart.LeftColumn = 5; chart.RightColumn = 11; chart.Name = "Student Sample Chart"; chart.ChartType = ExcelChartType.Cone_Clustered_3D; chart.DataRange = sheet.Range["B2:C6"];

    //sets the lighting value chart.ChartArea.ThreeD.Lighting = Excel2007ChartLightingProperties.Sunrise;

    workbook.SaveAs("Charts.xlsx"); workbook.Close(); }

    Material

    Gets or sets the material. The material property value from Excel2007ChartMaterialProperties.

    Declaration
    Excel2007ChartMaterialProperties Material { get; set; }
    Property Value
    Type Description
    Excel2007ChartMaterialProperties

    The material.

    Remarks

    To know more about charts refer this link.

    Examples

    The following code illustrates the use of Material property.

            <pre><code class="lang-csharp">using (ExcelEngine excelEngine = new ExcelEngine())
    

    { //Create a worksheet.
    IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet sheet = workbook.Worksheets[0]; sheet.Range["A1"].Text = "Student ID"; sheet.Range["B1"].Text = "Student Name"; sheet.Range["C1"].Text = "Mark(Out of 100)"; sheet.Range["A1:C1"].AutofitColumns(); sheet.Range["A2"].Number = 1; sheet.Range["A3"].Number = 2; sheet.Range["A4"].Number = 3; sheet.Range["A5"].Number = 4; sheet.Range["A6"].Number = 5; sheet.Range["B2"].Text = "Andrew"; sheet.Range["B3"].Text = "Marson"; sheet.Range["B4"].Text = "Jack"; sheet.Range["B5"].Text = "Sam"; sheet.Range["B6"].Text = "Breto"; sheet.Range["C2"].Number = 77; sheet.Range["C3"].Number = 45; sheet.Range["C4"].Number = 92; sheet.Range["C5"].Number = 39; sheet.Range["C6"].Number = 55;

    //Create a Chart IChartShape chart = sheet.Charts.Add(); chart.LeftColumn = 5; chart.RightColumn = 11; chart.Name = "Student Sample Chart"; chart.ChartType = ExcelChartType.Cone_Clustered_3D; chart.DataRange = sheet.Range["B2:C6"];

    //sets the material value chart.ChartArea.ThreeD.Material = Excel2007ChartMaterialProperties.TranslucentPowder;

    workbook.SaveAs("Charts.xlsx"); workbook.Close(); }

    In this article
    Back to top Generated by DocFX
    Copyright © 2001 - 2026 Syncfusion Inc. All Rights Reserved