public XlWorkbook Open(string fileName,
object updateLinks, bool readOnly, object format, object passWord, object writeResPassword,
object ignoreReadOnlyRecommended, object origin, object delimiter, object editable, object notify, object converter, object addToMru, object local, object corruptLoad)
{
object[] paramArray = new object[15];
paramArray[0] = fileName;
paramArray[1] = updateLinks;
paramArray[2] = readOnly;
paramArray[3] = format;
paramArray[4] = passWord;
paramArray[5] = writeResPassword;
paramArray[6] = ignoreReadOnlyRecommended;
paramArray[7] = origin;
paramArray[8] = delimiter;
paramArray[9] = editable;
paramArray[10] = notify;
paramArray[11] = converter;
paramArray[12] = addToMru;
paramArray[13] = local;
paramArray[14] = corruptLoad;
object returnValue = InstanceType.InvokeMember("Open", BindingFlags.InvokeMethod, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture);
if (null == returnValue)
{
return(null);
}
XlWorkbook newClass = new XlWorkbook(this, returnValue);
ListChildReferences.Add(newClass);
return(newClass);
}
public void ReplaceLine(int Line, string String)
{
object[] paramArray = new object[2];
paramArray[0] = Line;
paramArray[1] = String;
InstanceType.InvokeMember("ReplaceLine", 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 Characters(int start, int lenght)
{
object[] parameter = new object[1];
parameter[0] = start;
parameter[1] = lenght;
InstanceType.InvokeMember("Characters", BindingFlags.InvokeMethod, null, ComReference, parameter, XlLateBindingApiSettings.XlThreadCulture);
}
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 Insert()
{
object[] paramArray = new object[2];
paramArray[0] = Missing.Value;
paramArray[1] = Missing.Value;
InstanceType.InvokeMember("Insert", BindingFlags.InvokeMethod, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture);
}
public void MoveNode(XlDiagramNode targetNode, MsoRelativeNodePosition pos)
{
object[] paramArray = new object[2];
paramArray[0] = targetNode.COMReference;
paramArray[1] = pos;
InstanceType.InvokeMember("MoveNode", BindingFlags.InvokeMethod, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture);
}
public void ShowPopup(int x, int y)
{
object[] paramArray = new object[2];
paramArray[0] = x;
paramArray[1] = y;
InstanceType.InvokeMember("ShowPopup", BindingFlags.InvokeMethod, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture);
}
public void AutoSort(int order, string field)
{
object[] paramArray = new object[2];
paramArray[0] = order;
paramArray[1] = field;
InstanceType.InvokeMember("AutoSort", BindingFlags.InvokeMethod, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture);
}
public void Distribute(MsoDistributeCmd distributeCmd, MsoTriState relativeTo)
{
object[] paramArray = new object[2];
paramArray[0] = distributeCmd;
paramArray[1] = relativeTo;
InstanceType.InvokeMember("Distribute", BindingFlags.InvokeMethod, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture);
}
public void ScaleWidth(Single factor, MsoTriState relativeToOriginalSize)
{
object[] paramArray = new object[2];
paramArray[0] = factor;
paramArray[1] = relativeToOriginalSize;
InstanceType.InvokeMember("ScaleWidth", BindingFlags.InvokeMethod, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture);
}
public XlShape AddOLEObject(string classType, string filename, Single left, Single top, Single width, Single height)
{
object[] parameters = new object[11];
parameters[0] = classType;
parameters[1] = filename;
parameters[2] = Missing.Value;
parameters[3] = Missing.Value;
parameters[4] = Missing.Value;
parameters[5] = Missing.Value;
parameters[6] = Missing.Value;
parameters[7] = left;
parameters[8] = top;
parameters[9] = width;
parameters[10] = height;
object returnValue = InstanceType.InvokeMember("AddOLEObject", 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 DragOff(XlDirection direction, int regionIndex)
{
object[] paramArray = new object[2];
paramArray[0] = direction;
paramArray[1] = regionIndex;
InstanceType.InvokeMember("DragOff", BindingFlags.InvokeMethod, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture);
}
public void TwoColorGradient(MsoGradientStyle style, long variant)
{
object[] paramArray = new object[1];
paramArray[0] = style;
paramArray[1] = variant;
InstanceType.InvokeMember("TwoColorGradient", BindingFlags.InvokeMethod, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture);
}
public void Deselect()
{
object[] paramArray = new object[1];
paramArray[0] = Missing.Value;
paramArray[1] = Missing.Value;
InstanceType.InvokeMember("Delete", BindingFlags.InvokeMethod | BindingFlags.OptionalParamBinding, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture);
}
public void EndConnect(XlShape connectedShape, int connectionSite)
{
object[] paramArray = new object[2];
paramArray[0] = connectedShape.COMReference;
paramArray[1] = connectionSite;
InstanceType.InvokeMember("EndConnect", 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 void Characters()
{
object[] parameter = new object[1];
parameter[0] = Missing.Value;
parameter[1] = Missing.Value;
InstanceType.InvokeMember("Characters", BindingFlags.InvokeMethod, null, ComReference, parameter, XlLateBindingApiSettings.XlThreadCulture);
}
public void DeleteLines(int startLine, int count)
{
object[] paramArray = new object[2];
paramArray[0] = startLine;
paramArray[1] = count;
InstanceType.InvokeMember("DeleteLines", BindingFlags.InvokeMethod, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture);
}
public void SwapNode(XlDiagramNode targetNode, bool swapChildren)
{
object[] paramArray = new object[2];
paramArray[0] = targetNode.COMReference;
paramArray[1] = swapChildren;
InstanceType.InvokeMember("SwapNode", BindingFlags.InvokeMethod, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture);
}
public void AddItem(string text, int index)
{
object[] paramArray = new object[2];
paramArray[0] = text;
paramArray[1] = index;
InstanceType.InvokeMember("AddItem", BindingFlags.InvokeMethod, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture);
}
public void Move(XlNonCreatable before, XlNonCreatable after)
{
object[] paramArray = new object[2];
paramArray[0] = before.ComReference;
paramArray[1] = after.ComReference;
InstanceType.InvokeMember("Move", BindingFlags.InvokeMethod | BindingFlags.OptionalParamBinding, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture);
}
public void Align(MsoAlignCmd alignCmd, MsoTriState relativeTo)
{
object[] paramArray = new object[2];
paramArray[0] = alignCmd;
paramArray[1] = relativeTo;
InstanceType.InvokeMember("Align", BindingFlags.InvokeMethod, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture);
}
public void CopyPicture(XlPictureAppearance appearance, XlCopyPictureFormat format)
{
object[] parameter = new object[2];
parameter[0] = appearance;
parameter[1] = format;
InstanceType.InvokeMember("CopyPicture", BindingFlags.InvokeMethod | BindingFlags.OptionalParamBinding, null, ComReference, null, XlLateBindingApiSettings.XlThreadCulture);
}
public void PresetGradient(MsoGradientStyle style, long variant, MsoPresetGradientType presetGradientType)
{
object[] paramArray = new object[3];
paramArray[0] = style;
paramArray[1] = variant;
paramArray[2] = presetGradientType;
InstanceType.InvokeMember("PresetGradient", BindingFlags.InvokeMethod, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture);
}
public string List(int index)
{
object[] parameter = new object[1];
parameter[0] = index;
object returnValue = InstanceType.InvokeMember("List", BindingFlags.GetProperty, null, ComReference, parameter, XlLateBindingApiSettings.XlThreadCulture);
return((string)returnValue);
}
/// <summary>
/// LanguageID
/// </summary>
public int LanguageID(XlMsoAppLanguageID ID)
{
object returnValue = InstanceType.InvokeMember("LanguageID", BindingFlags.GetProperty, null, ComReference, new object[1] {
ID
}, XlLateBindingApiSettings.XlThreadCulture);
return((int)returnValue);
}
public void CopyPicture()
{
object[] paramArray = new object[3];
paramArray[0] = XlPictureAppearance.xlScreen;
paramArray[1] = XlCopyPictureFormat.xlPicture;
paramArray[2] = XlPictureAppearance.xlPrinter;
InstanceType.InvokeMember("CopyPicture", BindingFlags.InvokeMethod | BindingFlags.OptionalParamBinding, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture);
}
public object Values(int index)
{
object[] paramArray = new object[1];
paramArray[0] = index;
object returnValue = InstanceType.InvokeMember("Values", BindingFlags.GetProperty | BindingFlags.OptionalParamBinding, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture);
return((object)returnValue);
}
public void OneColorGradient(MsoGradientStyle style, int variant, Single degree)
{
object[] paramArray = new object[3];
paramArray[0] = style;
paramArray[1] = variant;
paramArray[2] = degree;
InstanceType.InvokeMember("OneColorGradient", BindingFlags.InvokeMethod, null, ComReference, paramArray, XlLateBindingApiSettings.XlThreadCulture);
}