public XlWorkbook OpenDatabase(string fileName, object commandText, object commandType, object backgroundQuery, object importDataAs)
{
object[] paramArray = new object[5];
paramArray[0] = fileName;
paramArray[1] = commandText;
paramArray[2] = commandType;
paramArray[3] = backgroundQuery;
paramArray[4] = importDataAs;
object returnValue = InstanceType.InvokeMember("OpenDatabase", BindingFlags.InvokeMethod, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture);
if (null == returnValue)
{
return(null);
}
XlWorkbook newClass = new XlWorkbook(this, returnValue);
ListChildReferences.Add(newClass);
return(newClass);
}
public XlChartObject Add(Double left, Double top, Double width, Double height)
{
object[] paramArray = new object[4];
paramArray[0] = left;
paramArray[1] = top;
paramArray[2] = width;
paramArray[3] = height;
object returnValue = InstanceType.InvokeMember("Add", BindingFlags.InvokeMethod, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture);
if (null == returnValue)
{
return(null);
}
XlChartObject newClass = new XlChartObject(this, returnValue);
ListChildReferences.Add(newClass);
return(newClass);
}
public XlShape AddCallout(MsoCalloutType type, Single left, Single top, Single width, Single height)
{
object[] parameters = new object[5];
parameters[0] = type;
parameters[1] = left;
parameters[2] = top;
parameters[3] = width;
parameters[4] = height;
object returnValue = InstanceType.InvokeMember("AddCallout", BindingFlags.InvokeMethod | BindingFlags.OptionalParamBinding, null, ComReference, parameters, XlLateBindingApiSettings.XlThreadCulture);
if (null == returnValue)
{
return(null);
}
XlShape newClass = new XlShape(this, returnValue);
ListChildReferences.Add(newClass);
return(newClass);
}
public XlShape AddPicture(string filename, MsoTriState linkToFile, MsoTriState saveWithDocument, Single left, Single top, Single width, Single height)
{
object[] parameters = new object[7];
parameters[0] = filename;
parameters[1] = linkToFile;
parameters[2] = saveWithDocument;
parameters[3] = left;
parameters[4] = top;
parameters[5] = width;
parameters[6] = height;
object returnValue = InstanceType.InvokeMember("AddPicture", BindingFlags.InvokeMethod | BindingFlags.OptionalParamBinding, null, ComReference, parameters, XlLateBindingApiSettings.XlThreadCulture);
if (null == returnValue)
{
return(null);
}
XlShape newClass = new XlShape(this, returnValue);
ListChildReferences.Add(newClass);
return(newClass);
}
public XlShape AddTextEffect(MsoPresetTextEffect presetTextEffect, string text, string fontName, Single fontSize, MsoTriState fontBold, MsoTriState fontItalic, Single left, Single top)
{
object[] parameters = new object[8];
parameters[0] = presetTextEffect;
parameters[1] = text;
parameters[2] = fontName;
parameters[3] = fontSize;
parameters[4] = fontBold;
parameters[5] = fontItalic;
parameters[6] = left;
parameters[7] = top;
object returnValue = InstanceType.InvokeMember("AddTextEffect", BindingFlags.InvokeMethod | BindingFlags.OptionalParamBinding, null, ComReference, parameters, XlLateBindingApiSettings.XlThreadCulture);
if (null == returnValue)
{
return(null);
}
XlShape newClass = new XlShape(this, returnValue);
ListChildReferences.Add(newClass);
return(newClass);
}
public void RemoveChildReference(IXlObject comReference)
{
ListChildReferences.Remove(comReference);
}
