menu

UWP

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Interface IThreeDFormat - UWP API Reference | Syncfusion

    Show / Hide Table of Contents

    Interface IThreeDFormat

    Represents the three-dimensional chart format.

    Namespace: Syncfusion.XlsIO
    Assembly: Syncfusion.XlsIO.UWP.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.

          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
    System.Int32

    The bevel bottom height.

    Remarks

    To know more about charts refer this link.

    Examples

    The following code illustrates the use of BevelBottomHeight property.

          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
    System.Int32

    The bevel bottom width.

    Remarks

    To know more about charts refer this link.

    Examples

    The following code illustrates the use of BevelBottomWidth property.

          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.

          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
    System.Int32

    The bevel top height.

    Remarks

    To know more about charts refer this link.

    Examples

    The following code illustrates the use of BevelTopHeight property.

          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
    System.Int32

    The bevel top width.

    Remarks

    To know more about charts refer this link.

    Examples

    The following code illustrates the use of BevelTopWidth property.

          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.

          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.

          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();
          }

    Extension Methods

    DateTimeExtension.ToDateTime(Object)
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved