在C#中创建Excel图表 [英] creat Excel chart in c#

问题描述

HI

我想在运行时创建excel图表，但是当我运行我的项目时，显示此异常:

HI

I want to creat excel chart in run time but when I was run my project show this Exception :

[System.Runtime.InteropServices.COMException] = {"Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))"}

我的代码是:

My Code is:

    Excel.Application m_objExcel = null;

    Excel._Workbook m_objBook = null;

    Excel._Chart m_objChart = null;

    Excel.ChartGroup m_objChartGroup = null;

    Excel.Series m_objSeries = null;

    object m_objOpt = System.Reflection.Missing.Value;

    try
    {

        m_objExcel = new Excel.Application();

        m_objBook =

m_objExcel.Workbooks.Open

(@"c:\\ExcelDemo", m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt,

m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt);

        m_objChart = (Excel._Chart)m_objExcel.Charts.get_Item(1);

        m_objChart.BarShape = Excel.XlBarShape.xlCylinder;

        m_objChartGroup = (Excel.ChartGroup)m_objChart.ChartGroups(1);

        m_objSeries = (Excel.Series)m_objChartGroup.SeriesCollection(1);

        m_objSeries.Values = 456;

        m_objExcel.DisplayAlerts = false;

        m_objBook.SaveAs(@"c:\\ExcelDemo", m_objOpt, m_objOpt,

       m_objOpt, m_objOpt, m_objOpt, Excel.XlSaveAsAccessMode.xlNoChange,

                                m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt);

    }

    catch (Exception ex)
    {

        MessageBox.Show(ex.Message);

    }

    finally
    {

        m_objBook.Close(m_objOpt, m_objOpt, m_objOpt);

        m_objExcel.Workbooks.Close();

        m_objExcel.Quit();

        System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objBook);

        System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objExcel);

        m_objBook = null;

        m_objExcel = null;

        GC.Collect();

        this.Close();

    }

}

请尽快帮助我........... plze

Plze Help Me soon........... plze

推荐答案

看看这个线程:区域语言"("en-US" "

Have a look at this thread: Similar discussion...[^]

Looks like related to some ''regional language of OS other than "en-US"''

这篇关于在C#中创建Excel图表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！