c#：WinForm窗体WebBrower内嵌Excel

爱被打了一巴掌 2022-10-06 05:42 301阅读 0赞

特点：带工具栏在WinForm窗体WebBrower中嵌入Excel表格  
使用环境：Windows10，VS 2019，MS Office 2010

using System;
    using System.Collections.Generic;
    using System.ComponentModel;
    using System.Data;
    using System.Drawing;
    using System.Linq;
    using System.Text;
    using System.Threading.Tasks;
    using System.Windows.Forms;
    using MSEXCEL=Microsoft.Office.Interop.Excel;
    
    namespace WFAces
    {
        public partial class Form2 : Form
        {
            public Form2()
            {
                InitializeComponent();
            }
    
            private void Form2_Load(object sender, EventArgs e)
            {
                string path = System.IO.Path.Combine(Environment.CurrentDirectory, DateTime.Now.ToString("M") + ".xlsx");
                Object missing = System.Reflection.Missing.Value;
                webBrowser1.Navigate(path);
            }
    
            private void webBrowser1_DocumentCompleted(object sender, WebBrowserDocumentCompletedEventArgs e)
            {
                Object missing = System.Reflection.Missing.Value;
                object[] args = new object[4];
                args[0] = SHDocVw.OLECMDID.OLECMDID_HIDETOOLBARS;
                args[1] = SHDocVw.OLECMDEXECOPT.OLECMDEXECOPT_DONTPROMPTUSER;
                args[2] = args[3] = missing;
    
                object axWebBrower = this.webBrowser1.ActiveXInstance;
                if(this.webBrowser1.Document == null)
                	axWebBrower.GetType().InvokeMember("ExecWB", System.Reflection.BindingFlags.InvokeMethod, null, axWebBrower, args);
            }
        }
    }

如果仍然打不开需要修改注册表参数。

方法：记事本保存以下内容为reg文件，双击运行。

Windows Registry Editor Version 5.00
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Word.Document.8]
    "BrowserFlags"=dword:80000024
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Word.RTF.8]
    "BrowserFlags"=dword:80000024
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Word.Document.12]
    "BrowserFlags"=dword:80000024
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Word.DocumentMacroEnabled.12]
    "BrowserFlags"=dword:80000024
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.8]
    "BrowserFlags"=dword:80000A00
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.12]
    "BrowserFlags"=dword:80000A00
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.SheetMacroEnabled.12]
    "BrowserFlags"=dword:80000A00
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.SheetBinaryMacroEnabled.12]
    "BrowserFlags"=dword:80000A00
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\PowerPoint.Show.8]
    "BrowserFlags"=dword:800000A0
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\PowerPoint.Show.12]
    "BrowserFlags"=dword:800000A0
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\PowerPoint.ShowMacroEnabled.12]
    "BrowserFlags"=dword:800000A0
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\PowerPoint.SlideShow.8]
    "BrowserFlags"=dword:800000A0
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\PowerPoint.SlideShow.12]
    "BrowserFlags"=dword:800000A0
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\PowerPoint.SlideShowMacroEnabled.12]
    "BrowserFlags"=dword:800000A0

————————————————  
版权声明：本文为CSDN博主「mygisforum」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。  
原文链接：[https://blog.csdn.net/mygisforum/article/details/6739930][https_blog.csdn.net_mygisforum_article_details_6739930]

[https_blog.csdn.net_mygisforum_article_details_6739930]: https://blog.csdn.net/mygisforum/article/details/6739930