时间戳

首页 > 解决方案 > 使用 vb.net 创建 3d 饼图

vb.net - 使用 vb.net 创建 3d 饼图

问题描述

我试图创建一个 3d 饼图，但我得到一个错误这里我使用的代码

Public Sub ShowChart(ByVal mylist As List(Of Classdayhag))
        Dim celltable As excel.Range
        Dim indexcol As Integer
        Dim indexrow As Integer
        Try

            With xlworksheet
                celltable = .Range("A1", "B" & (mylist.Count - 1))
                indexcol = 1
                indexrow = 1
                For Each item As Classdayhag In mylist
                    .Cells(indexrow, indexcol) = item.dayname
                    .Cells(indexrow, indexcol + 1) = item.count
                    indexrow += 1
                Next
                celltable.Select()
                Dim mychart As New excel.Chart
                With mychart
                    .Shapes.AddChart.Select()
                    .ChartType = excel.XlChartType.xl3DPie
                    .SetSourceData(Source:=celltable)
                    .ApplyLayout(6)
                End With
            End With

            objexcel.Visible = True
            RaiseEvent isshown()
            objexcel = Nothing
        Catch ex As Exception
            MessageBox.Show(ex.Message)
            objexcel = Nothing
        End Try

    End Sub

错误 无法将“Microsoft.Office.Interop.Excel.ChartClass”类型的 COM 对象转换为接口类型“Microsoft.Office.Interop.Excel._Chart” 在第 1 行引发

 .Shapes.AddChart.Select()

提前致谢

标签： vb.net

解决方案

我成功了

Public Sub ShowChart(ByVal mylist As List(Of Classdayhag), ByVal title As String)

        'create chart

        Dim xlCharts As excel.ChartObjects
        Dim myChart As excel.ChartObject
        Dim celltable As excel.Range
        Dim indexcol As Integer
        Dim indexrow As Integer

        Try
            xlCharts = CType(xlworksheet.ChartObjects, excel.ChartObjects)
            myChart = xlCharts.Add(10, 80, 400, 400)
            With xlworksheet
                celltable = .Range("A1", "B" & (mylist.Count))


                indexcol = 1
                indexrow = 1
                For Each item As Classdayhag In mylist
                    .Cells(indexrow, indexcol) = item.dayname
                    .Cells(indexrow, indexcol + 1) = item.count
                    indexrow += 1
                Next
                celltable.Select()


                With myChart
                    .Chart.ChartType = excel.XlChartType.xl3DPie
                    .Chart.HasTitle = True
                    .Chart.ChartTitle.Text = title
                    .Chart.ChartTitle.Font.Name = "Arial"
                    .Chart.ChartTitle.Font.Size = 12
                    .Chart.ChartTitle.Font.Bold = True
                    .Chart.SetSourceData(Source:=celltable)
                    .Chart.ApplyLayout(6)

                End With
            End With

            objexcel.Visible = True
            RaiseEvent isshown()
            objexcel = Nothing
        Catch ex As Exception
            MessageBox.Show(ex.Message)
            objexcel = Nothing
        End Try

    End Sub

推荐阅读