Edit excel file directly inside window form application

Question

1.00/5 (1 vote)

See more:

Is it possible to open excel directly inside Window form C# and edit it the way we do in MS Office excel

.

I mean I need entire feature set of excel within a windows form?

I have tried below code:

What I have tried:

C#

public void loadDocument(string fileName)
        {

            del = new ConvertDocumentDelegate(ConvertExcel);
            // Call DocumentConversionComplete when the method has completed. 
            del.BeginInvoke(fileName, DocumentConversionComplete, null);
        }

  
        void ConvertExcel(string fileName)
        {        

            Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
            excel.Visible = true;
            excel.EditDirectlyInCell = true;
            Microsoft.Office.Interop.Excel.Workbook xlWorkbook = excel.Workbooks.Open(fileName);
            Microsoft.Office.Interop.Excel.Worksheet xlWorksheet = xlWorkbook.Sheets[1];

            tempFileName = GetTempFile("html");
            object missing = System.Reflection.Missing.Value;
            object newFileName = (object)tempFileName;
            object fileType = (object)Microsoft.Office.Interop.Excel.XlFileFormat.xlHtml;

            xlWorkbook.SaveAs(fileName, fileType, missing, missing, missing, missing,
                 Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
                 missing, missing, missing, missing, missing);
        }

        void DocumentConversionComplete(IAsyncResult result)
        {
            // navigate to our temp file. 
            wbPreview.Navigate(tempFileName);
        }

        void webBrowser1_DocumentCompleted(object sender,
            WebBrowserDocumentCompletedEventArgs e)
        {
            try
            {
                if (tempFileName != string.Empty)
                {
                    // delete the temp file we created. 
                    File.Delete(tempFileName);

                    // set the tempFileName to an empty string. 
                    tempFileName = string.Empty;
                }
            }
            catch (Exception ex)
            {
            }
        }

        string GetTempFile(string extension)
        {
            // Uses the Combine, GetTempPath, ChangeExtension, 
            // and GetRandomFile methods of Path to 
            // create a temp file of the extension we're looking for. 
            return Path.Combine(Path.GetTempPath(),
                Path.ChangeExtension(Path.GetRandomFileName(), extension));
        }

        private void button1_Click_1(object sender, EventArgs e)
        {

            loadDocument(@"C:\Project\TestDescription\Myfile.xml");
        }

Posted 11-Jan-21 20:32pm

rameshKumar1717

Updated 28-Jan-21 0:36am

v2

Add a Solution

2 solutions

Solution 1

Perhaps following articles will help guide on this aspect:
Automate Excel by using Visual C# to fill or to obtain data by using arrays - Office | Microsoft Docs[^]
How to Edit or Modify Excel Data in Windows Forms with C#[^]

Posted 11-Jan-21 20:52pm

Sandeep Mewara

Comments

Maciej Los 12-Jan-21 4:12am

5ed!

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

rameshKumar1717 · Accepted Answer · 2021-01-28T00:36:00

Below is my solution

set BrowserFlags = 0 at registry location:

Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.12

restart the machine and write below code in WPF

WebBrowser Control in wpf

<WebBrowser  Name="webBrowser1" HorizontalAlignment="Left"  Margin="10,10,0,0" VerticalAlignment="Top" />

using System;
using System.Collections.Generic;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;

namespace Webbrowser
{
    /// <summary>
    /// Interaction logic for MainWindow.xaml
    /// </summary>
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
            string mySheet = @"C:\Book 2.xlsx";          
            webBrowser1.Navigate(mySheet);
            webBrowser1.LoadCompleted += WebBrowser1_LoadCompleted;
          
        }

        private void WebBrowser1_LoadCompleted(object sender, NavigationEventArgs e)
        {
            Thread t = new Thread(new ThreadStart(RunThread));
            t.Start();
            

        }

        public void RunThread()
        {
            var pComWebBrowser = typeof(WebBrowser).GetProperty("AxIWebBrowser2", BindingFlags.Instance | BindingFlags.NonPublic);
            var objComWebBrowser = pComWebBrowser.GetValue(webBrowser1);
            const int OLECMDID_HIDETOOLBARS = 24;
            const int OLECMDEXECOPT_DONTPROMPTUSER = 2;
            ((dynamic)objComWebBrowser).ExecWB(OLECMDID_HIDETOOLBARS, OLECMDEXECOPT_DONTPROMPTUSER, 16);
        }


    }
}