C#调用office2003的OWC11组件生成报表统计图

owc11控件是microsoft office图表控件(owc10为ofiiceXP的组件、owc11为office2003的组件,组件的路径为C:/ProgramFiles/Common Files/Microsoft Shared/WebComponents/11/owc11,帮助文件的路径为C:/Program Files/Common Files/MicrosoftShared/Web Components/11/2052),调用它可以生成三维图、柱状图、饼状图、趋势图和误差图等。 ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
    首先必须添加引用owc11:在“com选项卡”中选择“misrosoft office 11.0 objectlibrary”或直接选择路径为C:/Program Files/Common Files/Microsoft Shared/WebComponents/11/owc11的owc11; ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
    接下来是自己写的对owc11操作的封装类,以便于在程序里调用。 ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
具体代码及说明如下: ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
using System; ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
using System.Data; ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
using System.Text; ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
using Microsoft.Office.Interop.Owc11; ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
namespace Chat ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
{ ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
    ///    ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
    /// 星辰.Net技术社区 ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
    /// [url]http://www.netcsharp.cn[/url] ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
    /// 2008-07-11 ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
    /// ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
    public class ShowChart ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
    { ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        #region 属性 ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        private string _phaysicalimagepath;//图片存放路径 ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        private string _title; //图片标题 ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        private string _xtitle;//图片x座标名称 ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        private string _ytitle;//图片y座标名称 ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        private string _seriesname;//图例名称 ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        private int _picwidth;//图片宽度 ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        private int _pichight;//图片高度 ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        private DataTable _datasource;//图片数据源 ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        private string strCategory;//图片数据源的分类 ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        private string strValue;//图片数据源的值 ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        /// ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        /// 图片存放路径 ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        /// ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        public string PhaysicalImagePath ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        { ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
            set { _phaysicalimagepath = value; } ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
            get { return _phaysicalimagepath; } ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        } ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        /// ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        /// 图片标题 ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        /// ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        public string Title ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        { ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
            set { _title = value; } ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
            get { return _title; } ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        } ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        /// ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        /// 图片标题 ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        /// ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        public string XTitle ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        { ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
            set { _xtitle = value; } ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
            get { return _xtitle; } ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        } ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        /// ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        /// 图片标题 ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        /// ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        public string YTitle ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        { ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
            set { _ytitle = value; } ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
            get { return _ytitle; } ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        } ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        /// ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        /// 图例名称 ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        /// ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        public string SeriesName ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        { ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
            set { _seriesname = value; } ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
            get { return _seriesname; } ^xæ_‰7ÏñAwww.netcsharp.cn nQƒ9ù¤X=î
        }
  • 0
    点赞
  • 5
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Retrieving the COM class factory for component with CLSID {0002E55D-0000-0000-C000-000000000046} failed due to the following error: 80040154. 收藏 Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.COMException: Retrieving the COM class factory for component with CLSID {0002E55D-0000-0000-C000-000000000046} failed due to the following error: 80040154. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [COMException (0x80040154): Retrieving the COM class factory for component with CLSID {0002E55D-0000-0000-C000-000000000046} failed due to the following error: 80040154.] GraphPage.Page_Load(Object sender, EventArgs e) +1097 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +50 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082 请大家帮忙 谢谢 Server Error in '/' Application. -------------------------------------------------------------------------------- Retrieving the COM class factory for component with CLSID {0002E55D-0000-0000-C000-000000000046} failed due to the following error: 80040154.

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值