コード例 #1
0
 public void Modify(LateBindingApi.Excel.Range location, string sourceData)
 {
     object[] paramArray = new object[2];
     paramArray.SetValue(location, 0);
     paramArray[1] = sourceData;
     Invoker.Method(this, "Modify", paramArray);
 }
コード例 #2
0
 public void FillAcrossSheets(LateBindingApi.Excel.Range range, LateBindingApi.Excel.Enums.XlFillWith type)
 {
     object[] paramArray = new object[2];
     paramArray.SetValue(range, 0);
     paramArray[1] = type;
     Invoker.Method(this, "FillAcrossSheets", paramArray);
 }
コード例 #3
0
        public void Change([In, MarshalAs(UnmanagedType.Interface)] object target)
        {
            object[] paramArray = new object[1];
            paramArray[0] = new LateBindingApi.Excel.Range(_eventClass, target);
            bool isRecieved = _eventBinding.CallEvent("ChangeEvent", paramArray);

            if (false == isRecieved)
            {
                Invoker.ReleaseParamArray(paramArray);
            }
        }
コード例 #4
0
        public void PivotTableAfterValueChange([In, MarshalAs(UnmanagedType.Interface)] object targetPivotTable, [In, MarshalAs(UnmanagedType.Interface)] object targetRange)
        {
            object[] paramArray = new object[2];
            paramArray[0] = new LateBindingApi.Excel.PivotTable(_eventClass, targetPivotTable);
            paramArray[1] = new LateBindingApi.Excel.Range(_eventClass, targetRange);
            bool isRecieved = _eventBinding.CallEvent("PivotTableAfterValueChangeEvent", paramArray);

            if (false == isRecieved)
            {
                Invoker.ReleaseParamArray(paramArray);
            }
        }
コード例 #5
0
        public void BeforeRightClick([In, MarshalAs(UnmanagedType.Interface)] object target, [In] ref bool cancel)
        {
            object[] paramArray = new object[2];
            paramArray[0] = new LateBindingApi.Excel.Range(_eventClass, target);
            paramArray.SetValue(cancel, 1);
            bool isRecieved = _eventBinding.CallEvent("BeforeRightClickEvent", paramArray);

            if (false == isRecieved)
            {
                Invoker.ReleaseParamArray(paramArray);
            }
        }
コード例 #6
0
        public LateBindingApi.Excel.Range get_Range(object cell1)
        {
            object[] paramArray = new object[1];
            paramArray[0] = cell1;
            object returnValue = Invoker.PropertyGet(this, "Range", paramArray);

            if (null == returnValue)
            {
                return(null);
            }
            LateBindingApi.Excel.Range newClass = new LateBindingApi.Excel.Range(this, returnValue);
            return(newClass);
        }
コード例 #7
0
        public LateBindingApi.Excel.SortField Add(LateBindingApi.Excel.Range key)
        {
            object[] paramArray = new object[1];
            paramArray.SetValue(key, 0);
            object returnValue = Invoker.MethodReturn(this, "Add", paramArray);

            if (null == returnValue)
            {
                return(null);
            }
            LateBindingApi.Excel.SortField newClass = new LateBindingApi.Excel.SortField(this, returnValue);
            return(newClass);
        }
コード例 #8
0
        public LateBindingApi.Excel.Range get__Default(Int32 index)
        {
            object[] paramArray = new object[1];
            paramArray[0] = index;
            object returnValue = Invoker.PropertyGet(this, "_Default", paramArray);

            if (null == returnValue)
            {
                return(null);
            }
            LateBindingApi.Excel.Range newClass = new LateBindingApi.Excel.Range(this, returnValue);
            return(newClass);
        }
コード例 #9
0
        public LateBindingApi.Excel.AllowEditRange Add(string title, LateBindingApi.Excel.Range range)
        {
            object[] paramArray = new object[2];
            paramArray[0] = title;
            paramArray.SetValue(range, 1);
            object returnValue = Invoker.MethodReturn(this, "Add", paramArray);

            if (null == returnValue)
            {
                return(null);
            }
            LateBindingApi.Excel.AllowEditRange newClass = new LateBindingApi.Excel.AllowEditRange(this, returnValue);
            return(newClass);
        }
コード例 #10
0
        public LateBindingApi.Excel.QueryTable Add(object connection, LateBindingApi.Excel.Range destination)
        {
            object[] paramArray = new object[2];
            paramArray[0] = connection;
            paramArray.SetValue(destination, 1);
            object returnValue = Invoker.MethodReturn(this, "Add", paramArray);

            if (null == returnValue)
            {
                return(null);
            }
            LateBindingApi.Excel.QueryTable newClass = new LateBindingApi.Excel.QueryTable(this, returnValue);
            return(newClass);
        }
コード例 #11
0
        public LateBindingApi.Excel.Range Union(LateBindingApi.Excel.Range arg1, LateBindingApi.Excel.Range arg2)
        {
            object[] paramArray = new object[2];
            paramArray.SetValue(arg1, 0);
            paramArray.SetValue(arg2, 1);
            object returnValue = Invoker.MethodReturn(this, "Union", paramArray);

            if (null == returnValue)
            {
                return(null);
            }
            LateBindingApi.Excel.Range newClass = new LateBindingApi.Excel.Range(this, returnValue);
            return(newClass);
        }
コード例 #12
0
 public LateBindingApi.Excel.Range this[object index]
 {
     get
     {
         object[] paramArray = new object[1];
         paramArray[0] = index;
         object returnValue = Invoker.PropertyGet(this, "Item", paramArray);
         if (null == returnValue)
         {
             return(null);
         }
         LateBindingApi.Excel.Range newClass = new LateBindingApi.Excel.Range(this, returnValue);
         return(newClass);
     }
 }
コード例 #13
0
        public IEnumerator GetEnumerator()
        {
            object    enumProxy  = Invoker.PropertyGet(this, "_NewEnum");
            COMObject enumerator = new COMObject(this, enumProxy);

            Invoker.Method(enumerator, "Reset", null);
            bool isMoveNextTrue = (bool)Invoker.MethodReturn(enumerator, "MoveNext", null);

            while (true == isMoveNextTrue)
            {
                object itemProxy = Invoker.PropertyGet(enumerator, "Current", null);
                LateBindingApi.Excel.Range returnClass = new LateBindingApi.Excel.Range(this, itemProxy);
                isMoveNextTrue = (bool)Invoker.MethodReturn(enumerator, "MoveNext", null);
                yield return(returnClass);
            }
        }
コード例 #14
0
        public LateBindingApi.Excel.SortField Add(LateBindingApi.Excel.Range key, object sortOn, object order, object customOrder, object dataOption)
        {
            object[] paramArray = new object[5];
            paramArray.SetValue(key, 0);
            paramArray[1] = sortOn;
            paramArray[2] = order;
            paramArray[3] = customOrder;
            paramArray[4] = dataOption;
            object returnValue = Invoker.MethodReturn(this, "Add", paramArray);

            if (null == returnValue)
            {
                return(null);
            }
            LateBindingApi.Excel.SortField newClass = new LateBindingApi.Excel.SortField(this, returnValue);
            return(newClass);
        }
コード例 #15
0
        public void SheetChange([In, MarshalAs(UnmanagedType.IDispatch)] object sh, [In, MarshalAs(UnmanagedType.Interface)] object target)
        {
            if (true == _eventClass.IsDisposed)
            {
                Marshal.ReleaseComObject(sh);
                Marshal.ReleaseComObject(target);
                return;
            }

            object[] paramArray = new object[2];
            paramArray[0] = new COMObject(_eventClass, sh);
            paramArray[1] = new LateBindingApi.Excel.Range(_eventClass, target);
            bool isRecieved = _eventBinding.CallEvent("SheetChangeEvent", paramArray);

            if (false == isRecieved)
            {
                Invoker.ReleaseParamArray(paramArray);
            }
        }
コード例 #16
0
        public LateBindingApi.Excel.Range Union(LateBindingApi.Excel.Range arg1, LateBindingApi.Excel.Range arg2, object arg3, object arg4, object arg5, object arg6, object arg7, object arg8, object arg9, object arg10, object arg11, object arg12, object arg13, object arg14, object arg15, object arg16, object arg17, object arg18, object arg19, object arg20, object arg21, object arg22, object arg23, object arg24, object arg25, object arg26, object arg27, object arg28, object arg29, object arg30)
        {
            object[] paramArray = new object[30];
            paramArray.SetValue(arg1, 0);
            paramArray.SetValue(arg2, 1);
            paramArray[2]  = arg3;
            paramArray[3]  = arg4;
            paramArray[4]  = arg5;
            paramArray[5]  = arg6;
            paramArray[6]  = arg7;
            paramArray[7]  = arg8;
            paramArray[8]  = arg9;
            paramArray[9]  = arg10;
            paramArray[10] = arg11;
            paramArray[11] = arg12;
            paramArray[12] = arg13;
            paramArray[13] = arg14;
            paramArray[14] = arg15;
            paramArray[15] = arg16;
            paramArray[16] = arg17;
            paramArray[17] = arg18;
            paramArray[18] = arg19;
            paramArray[19] = arg20;
            paramArray[20] = arg21;
            paramArray[21] = arg22;
            paramArray[22] = arg23;
            paramArray[23] = arg24;
            paramArray[24] = arg25;
            paramArray[25] = arg26;
            paramArray[26] = arg27;
            paramArray[27] = arg28;
            paramArray[28] = arg29;
            paramArray[29] = arg30;
            object returnValue = Invoker.MethodReturn(this, "Union", paramArray);

            if (null == returnValue)
            {
                return(null);
            }
            LateBindingApi.Excel.Range newClass = new LateBindingApi.Excel.Range(this, returnValue);
            return(newClass);
        }
コード例 #17
0
 public void ModifyAppliesToRange(LateBindingApi.Excel.Range range)
 {
     object[] paramArray = new object[1];
     paramArray.SetValue(range, 0);
     Invoker.Method(this, "ModifyAppliesToRange", paramArray);
 }
コード例 #18
0
 public void ModifyKey(LateBindingApi.Excel.Range key)
 {
     object[] paramArray = new object[1];
     paramArray.SetValue(key, 0);
     Invoker.Method(this, "ModifyKey", paramArray);
 }
コード例 #19
0
 public void SetRange(LateBindingApi.Excel.Range rng)
 {
     object[] paramArray = new object[1];
     paramArray.SetValue(rng, 0);
     Invoker.Method(this, "SetRange", paramArray);
 }
コード例 #20
0
 public void Group(LateBindingApi.Excel.Range location)
 {
     object[] paramArray = new object[1];
     paramArray.SetValue(location, 0);
     Invoker.Method(this, "Group", paramArray);
 }
コード例 #21
0
 public void Resize(LateBindingApi.Excel.Range range)
 {
     object[] paramArray = new object[1];
     paramArray.SetValue(range, 0);
     Invoker.Method(this, "Resize", paramArray);
 }