public void Insert(XlInsertShiftDirection shift, XlRange copyOrigin) { object[] paramArray = new object[2]; paramArray[0] = shift; paramArray[1] = copyOrigin.COMReference; InstanceType.InvokeMember("Insert", BindingFlags.InvokeMethod, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture); }
public void FillAcrossSheets(XlRange range, XlFillWith type) { object[] paramArray = new object[2]; paramArray[0] = range.COMReference; paramArray[1] = type; InstanceType.InvokeMember("FillAcrossSheets", BindingFlags.InvokeMethod, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture); }
public void Import(XlRange changingCells, object values) { object[] paramArray = new object[2]; paramArray[0] = changingCells; paramArray[1] = values; InstanceType.InvokeMember("Import", BindingFlags.InvokeMethod, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture); }
public XlRange this[string adress] { get { object[] paramArray = new object[1]; paramArray[0] = adress; object returnValue = InstanceType.InvokeMember("Range", BindingFlags.GetProperty, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture); XlRange newClass = new XlRange(this, returnValue); ListChildReferences.Add(newClass); return(newClass); } }
public XlRange Resize() { object returnValue = InstanceType.InvokeMember("Resize", BindingFlags.GetProperty, null, ComReference, null, XlLateBindingApiSettings.XlThreadCulture); if (null == returnValue) { return(null); } XlRange newClass = new XlRange(this, returnValue); ListChildReferences.Add(newClass); return(newClass); }
internal void RaiseSelectionChangeEvent(object Target) { if (null == SelectionChange) { Marshal.ReleaseComObject(Target); return; } XlRange ra = new XlRange(this, Target); ListChildReferences.Add(ra); SelectionChange(ra); }
internal void RaiseBeforeRightClickEvent(object Target, ref bool Cancel) { if (null == BeforeRightClick) { Marshal.ReleaseComObject(Target); return; } XlRange ra = new XlRange(this, Target); ListChildReferences.Add(ra); BeforeRightClick(ra, ref Cancel); }
public XlRange Range(XlRange cell1) { object[] paramArray = new object[1]; paramArray[0] = cell1.COMReference; object returnValue = InstanceType.InvokeMember("Range", BindingFlags.GetProperty, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture); if (null == returnValue) { return(null); } XlRange newClass = new XlRange(this, returnValue); ListChildReferences.Add(newClass); return(newClass); }
public XlAllowEditRange Add(string title, XlRange range) { object[] paramArray = new object[1]; paramArray[0] = title; paramArray[1] = range; object returnValue = InstanceType.InvokeMember("Add", BindingFlags.InvokeMethod, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture); if (null == returnValue) { return(null); } XlAllowEditRange newClass = new XlAllowEditRange(this, returnValue); ListChildReferences.Add(newClass); return(newClass); }
/// <summary> /// returns a XlRange by Index, not 0 based /// </summary> /// <param name="i"></param> /// <returns></returns> public XlRange this[int index] { get { object[] paramArray = new object[1]; paramArray[0] = index; object returnValue = InstanceType.InvokeMember("Item", BindingFlags.InvokeMethod, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture); if (null == returnValue) { return(null); } XlRange newClass = new XlRange(this, returnValue); ListChildReferences.Add(newClass); return(newClass); } }
/// <summary> /// Foreach Enumerator /// </summary> /// <returns></returns> public IEnumerator GetEnumerator() { int iCount = Count; XlRange[] res_addins = new XlRange[iCount]; for (int i = 1; i <= iCount; i++) { res_addins[i - 1] = this[i]; } for (int i = 0; i < res_addins.Length; i++) { yield return(res_addins[i]); } }
public XlRange Resize(double rowSize, double columnSize) { object[] paramArray = new object[2]; paramArray[0] = rowSize; paramArray[1] = columnSize; object returnValue = InstanceType.InvokeMember("Resize", BindingFlags.GetProperty, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture); if (null == returnValue) { return(null); } XlRange newClass = new XlRange(this, returnValue); ListChildReferences.Add(newClass); return(newClass); }
public XlRange Offset(int rowOffset, int columnOffset) { object[] paramArray = new object[2]; paramArray[0] = rowOffset; paramArray[1] = columnOffset; object returnValue = InstanceType.InvokeMember("Offset", BindingFlags.GetProperty, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture); if (null == returnValue) { return(null); } XlRange newClass = new XlRange(this, returnValue); ListChildReferences.Add(newClass); return(newClass); }
internal static XlNonCreatable CreateDynamicType(IXlObject parent, object comProxy) { string className = TypeDescriptor.GetClassName(comProxy); switch (className) { case "Workbooks": XlWorkbooks newBooks = new XlWorkbooks(parent, comProxy); return(newBooks); case "Workbook": XlWorkbook newBook = new XlWorkbook(parent, comProxy); return(newBook); case "Worksheets": XlWorksheets newSheets = new XlWorksheets(parent, comProxy); return(newSheets); case "Worksheet": XlWorksheet newSheet = new XlWorksheet(parent, comProxy); return(newSheet); case "Range": XlRange newRange = new XlRange(parent, comProxy); return(newRange); default: throw (new ProxyTypeException("Unhandled ComProxyType: " + className)); } }
public void Paste(XlRange range) { object[] paramArray = new object[1]; paramArray[0] = range.COMReference; InstanceType.InvokeMember("Paste", BindingFlags.InvokeMethod | BindingFlags.OptionalParamBinding, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture); }