public void SetupEventBinding(XlWorksheet workSheet)
{
if (true == XlLateBindingApiSettings.EventsEnabled)
{
_workSheet = workSheet;
IConnectionPointContainer connectionPointContainer = (IConnectionPointContainer)workSheet.COMReference;
Guid guid = new Guid("{00024411-0000-0000-C000-000000000046}");
connectionPointContainer.FindConnectionPoint(ref guid, out _connectionPoint);
_connectionPoint.Advise(this, out _connectionCookie);
}
}
public XlWorksheet Add()
{
object returnValue = InstanceType.InvokeMember("Add", BindingFlags.InvokeMethod, null, ComReference, null, XlLateBindingApiSettings.XlThreadCulture);
if (null == returnValue)
{
return(null);
}
XlWorksheet newClass = new XlWorksheet(this, returnValue);
ListChildReferences.Add(newClass);
return(newClass);
}
/// <summary>
/// Foreach Enumerator
/// </summary>
/// <returns></returns>
public IEnumerator GetEnumerator()
{
int iCount = Count;
XlWorksheet[] res_addins = new XlWorksheet[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 XlWorksheet 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);
}
XlWorksheet newClass = new XlWorksheet(this, returnValue);
ListChildReferences.Add(newClass);
return(newClass);
}
}
public void Move(XlWorksheet before, XlWorksheet after)
{
object param1 = Missing.Value;
object param2 = Missing.Value;
if (null != before)
{
param1 = before.COMReference;
}
if (null != after)
{
param2 = after.COMReference;
}
object[] paramArray = new object[2];
paramArray[0] = param1;
paramArray[1] = param2;
InstanceType.InvokeMember("Move", BindingFlags.InvokeMethod | BindingFlags.OptionalParamBinding, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture);
}
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));
}
}
