Форум программистов [Powered by Invision Power Board]

Код

using System;
using System.Reflection;
using System.Runtime.InteropServices;
using System.Windows.Forms;

namespace AddIn
{
    [Guid(@"AB634001-F13D-11D0-A459-004095E1DAEA"),
    InterfaceType(ComInterfaceType.InterfaceIsIUnknown)]
    public interface IInitDone
    {
        void Init([MarshalAs(UnmanagedType.IDispatch)] Object pConnection);
        void Done();
        void GetInfo([MarshalAs(UnmanagedType.SafeArray,
                SafeArraySubType = VarEnum.VT_VARIANT)] ref Object[] pInfo);
    }

    [Guid("AB634004-F13D-11D0-A459-004095E1DAEA"),
    InterfaceType(ComInterfaceType.InterfaceIsIUnknown)]
    public interface IAsyncEvent
    {
        void SetEventBufferDepth(Int32 depth);
        void GetEventBufferDepth(ref Int32 depth);
        void ExternalEvent([MarshalAs(UnmanagedType.BStr)] String source,
                                     [MarshalAs(UnmanagedType.BStr)] String message,
                                     [MarshalAs(UnmanagedType.BStr)] String data);
        void CleanBuffer();
    }





    [ComVisible(true), ProgId(@"AddIn.ExcelReader"),
    Guid(@"9F0CF3B4-B799-4852-8293-9BB9500A3099"),
    ClassInterface(ClassInterfaceType.AutoDispatch)]
    public class ExcelReader : IInitDone
    {
        public static Object pCon = new object();

        public ExcelReader(){}
      
        public void Init([MarshalAs(UnmanagedType.IDispatch)] Object pConnection)
        {
            try
            {
                pCon = pConnection;
            }
            catch
            {
                throw new COMException(@"Unknown object context ");
            }
        }

        public void Done()
        {         
        }

        public void Test()
        {
            object obj1C = pCon.GetType().InvokeMember("AppDispatch", BindingFlags.Public | BindingFlags.InvokeMethod | BindingFlags.Static, null, pCon, null);
            Object[] Args = new Object[1];
            Args[0] = "ТаблицаЗначений";
            object Object1C = obj1C.GetType().InvokeMember("CreateObject", BindingFlags.GetProperty, null, obj1C, Args);

            Args[0] = "Должность";
            Object1C.GetType().InvokeMember("НоваяКолонка", BindingFlags.Public | BindingFlags.InvokeMethod | BindingFlags.Static, null, Object1C, Args);

            Args[0] = "Зарплата";
            Object1C.GetType().InvokeMember("НоваяКолонка", BindingFlags.Public | BindingFlags.InvokeMethod | BindingFlags.Static, null, Object1C, Args);

            Object1C.GetType().InvokeMember("НоваяСтрока", BindingFlags.Public | BindingFlags.InvokeMethod | BindingFlags.Static, null, Object1C, null);


            Object1C.GetType().InvokeMember("УстановитьЗначение", BindingFlags.Public | BindingFlags.InvokeMethod | BindingFlags.Static, null, Object1C, new object[] { 1, "Должность", "Программер" });

            Object1C.GetType().InvokeMember("ВыбратьСтроку", BindingFlags.Public | BindingFlags.InvokeMethod | BindingFlags.Static, null, Object1C, null);

            Marshal.Release(Marshal.GetIDispatchForObject(Object1C));
            Marshal.ReleaseComObject(Object1C);
        }



        public void GetInfo([MarshalAs(UnmanagedType.SafeArray,
        SafeArraySubType = VarEnum.VT_VARIANT)] ref Object[] pInfo)
        {
            pInfo[0] = @""; 
        }      
    }
}