Click here to Skip to main content
11,719,973 members (88,863 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: C# WPF Excel webbrowser
Hi all

I am using VS2008, C#, with WPF application (WebBrowser and Microsoft.Office.Interop.Excel)
I have a task : Hosting Excel on WPF-form in mode readonly.

How can I do this:
if ((WebBrowserExcel.Document as Excel.Workbook) == null) return;
      _Book = WebBrowserExcel.Document as Excel.Workbook;
      _Book.Protect("", Type.Missing, Type.Missing);
      foreach (Excel.Worksheet _sheet in _Book.Sheets)
            _sheet.Protect("", Type.Missing,Type.Missing,
                          Type.Missing,Type.Missing, true,Type.Missing,
                          Type.Missing, Type.Missing, Type.Missing, 
                          Type.Missing, Type.Missing,Type.Missing,
                          Type.Missing, Type.Missing, Type.Missing
   //In this moment - Exception
   _Book.Application.GetType().InvokeMember("DisplayAlerts", BindingFlags.SetProperty, null, _Book.Application, new object[] { false });

If I place all code in the Startup Windows (StartUpWindow) of Project - works well, but if I place all code in the other window (Window1) and show this window from Startup (Window1.Show())
private void btn_ViewExcel_Click(object sender, RoutedEventArgs e)
       Window1 _W1 = new Window1();
- works badly:
InnerException = {"could Not set the property DisplayAlerts Application class"}

Because of what it can be?
Thanks in advance, Alex...
Posted 10-Oct-12 0:34am
Edited 10-Oct-12 0:40am
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Rate this: bad
Please Sign up or sign in to vote.

Solution 2

Maybe it will help? Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 1,869
1 OriginalGriff 770
2 F-ES Sitecore 640
3 Maciej Los 609
4 Richard MacCutchan 540

Advertise | Privacy | Mobile
Web02 | 2.8.150901.1 | Last Updated 11 Oct 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100