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 Microsoft.Office.Core;
using Microsoft.Office;
using System.Reflection;
using SHDocVw;
using Microsoft.Office.Interop.Excel;
using System.Runtime.InteropServices;
using System.Runtime.InteropServices.ComTypes;
using Office = Microsoft.Office.Core;

namespace ASODU_manual_input
{
    public partial class Form1 : Form
    {
        private string m_ExcelFileName = "test.xls";
        private Microsoft.Office.Interop.Excel.Application m_XlApplication=null;
        private Office.CommandBar m_StandardCommandBar = null;
        private Workbook m_Workbook = null;
        [DllImport("ole32.dll")]
        static extern int GetRunningObjectTable
            (uint reserved, out IRunningObjectTable pprot);
        [DllImport("ole32.dll")]
        static extern int CreateBindCtx(uint reserved, out IBindCtx pctx);

        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            if (this.openFileDialog1.ShowDialog() == DialogResult.Cancel) return;
            m_ExcelFileName = getFileName(this.openFileDialog1.FileName);
            this.OpenFile(this.openFileDialog1.FileName);
        }

        public String getFileName(String path)
        {
            string[] splitpath = path.Split('\\'); 
            string name = splitpath[splitpath.Length - 1];
            return name;
        }

        public void OpenFile(string filename)
        {
            if (!System.IO.File.Exists(filename)) throw new Exception();
            this.webBrowser1.Navigate(filename, false);
            
        }

        private void webBrowser1_Navigated(object sender, WebBrowserNavigatedEventArgs e)
        {
            // Creation of the workbook object
            if ((m_Workbook = RetrieveWorkbook(m_ExcelFileName)) == null) return;
            // Create the Excel.Application
            m_XlApplication = (Microsoft.Office.Interop.Excel.Application)m_Workbook.Application;
            AttachApplication();
          }

        private void AttachApplication()
        {
            try
            {
                // Creation of the standard toolbar
                m_StandardCommandBar = m_XlApplication.CommandBars["Standard"];
                m_StandardCommandBar.Position = Office.MsoBarPosition.msoBarTop;
                m_StandardCommandBar.Visible = true;
                // Enable the OpenFile and New buttons
                foreach (Office.CommandBarControl control in m_StandardCommandBar.Controls)
                {
                    string name = control.get_accName(Missing.Value);
                    if (name.Equals("Nouveau")) ((Office.CommandBarButton)control).Enabled = false;
                    if (name.Equals("Ouvrir")) ((Office.CommandBarButton)control).Enabled = false;
                }
            }
            catch
            {
                MessageBox.Show("Impossible de charger le fichier Excel");
                return;
            }
        }

        public Workbook RetrieveWorkbook(string xlfile)
        {
            IRunningObjectTable prot = null;
            IEnumMoniker pmonkenum = null;
            try
            {
                IntPtr pfetched = IntPtr.Zero;
                // Query the running object table (ROT)
                if (GetRunningObjectTable(0, out prot) != 0 || prot == null) return null;
                prot.EnumRunning(out pmonkenum); pmonkenum.Reset();
                IMoniker[] monikers = new IMoniker[1];
                while (pmonkenum.Next(1, monikers, pfetched) == 0)
                {
                    IBindCtx pctx; string filepathname;
                    CreateBindCtx(0, out pctx);
                    // Get the name of the file
                    monikers[0].GetDisplayName(pctx, null, out filepathname);
                    // Clean up
                    Marshal.ReleaseComObject(pctx);
                    // Search for the workbook
                    if (filepathname.IndexOf(xlfile) != -1)
                    {
                        object roval;
                        // Get a handle on the workbook
                        prot.GetObject(monikers[0], out roval);
                        return roval as Workbook;
                    }
                }
            }
            catch
            {
                return null;
            }
            finally
            {
                // Clean up
                if (prot != null) Marshal.ReleaseComObject(prot);
                if (pmonkenum != null) Marshal.ReleaseComObject(pmonkenum);
            }
            return null;
        }
    }
}