public Int32 WorkbookBeforePrint(NetOffice.ExcelApi.Workbook wb, bool cancel)
{
object[] paramsArray = Invoker.ValidateParamsArray(wb, cancel);
object returnItem = Invoker.MethodReturn(this, "WorkbookBeforePrint", paramsArray);
return(NetRuntimeSystem.Convert.ToInt32(returnItem));
}
public Int32 WorkbookAddinUninstall(NetOffice.ExcelApi.Workbook wb)
{
object[] paramsArray = Invoker.ValidateParamsArray(wb);
object returnItem = Invoker.MethodReturn(this, "WorkbookAddinUninstall", paramsArray);
return(NetRuntimeSystem.Convert.ToInt32(returnItem));
}
public Int32 WorkbookNewSheet(NetOffice.ExcelApi.Workbook wb, object sh)
{
object[] paramsArray = Invoker.ValidateParamsArray(wb, sh);
object returnItem = Invoker.MethodReturn(this, "WorkbookNewSheet", paramsArray);
return(NetRuntimeSystem.Convert.ToInt32(returnItem));
}
public NetOffice.ExcelApi.Workbook Edit(object writeResPassword)
{
object[] paramsArray = Invoker.ValidateParamsArray(writeResPassword);
object returnItem = Invoker.MethodReturn(this, "Edit", paramsArray);
NetOffice.ExcelApi.Workbook newObject = Factory.CreateKnownObjectFromComProxy(this, returnItem,NetOffice.ExcelApi.Workbook.LateBindingApiWrapperType) as NetOffice.ExcelApi.Workbook;
return newObject;
}
public Int32 WindowActivate(NetOffice.ExcelApi.Workbook wb, NetOffice.ExcelApi.Window wn)
{
object[] paramsArray = Invoker.ValidateParamsArray(wb, wn);
object returnItem = Invoker.MethodReturn(this, "WindowActivate", paramsArray);
return(NetRuntimeSystem.Convert.ToInt32(returnItem));
}
/// <summary>
/// the event-handler for the <see cref="Excel.Application.WorkbookDeactivateEvent"/>
/// </summary>
/// <param name="workbook">
/// The workbook that was deactivated
/// </param>
private void OnWorkbookDeactivateEvent(NetOffice.ExcelApi.Workbook workbook)
{
logger.Debug("Workbook {0} deactivated", workbook.Name);
if (this.RibbonUI != null)
{
this.RibbonUI.Invalidate();
}
}
public NetOffice.ExcelApi.Workbook Edit()
{
object[] paramsArray = null;
object returnItem = Invoker.MethodReturn(this, "Edit", paramsArray);
NetOffice.ExcelApi.Workbook newObject = NetOffice.Factory.CreateKnownObjectFromComProxy(this, returnItem, NetOffice.ExcelApi.Workbook.LateBindingApiWrapperType) as NetOffice.ExcelApi.Workbook;
return(newObject);
}
/// <summary>
///
/// </summary>
/// <param name="wb"></param>
public void NewWorkbook([In, MarshalAs(UnmanagedType.IDispatch)] object wb)
{
if (!Validate("NewWorkbook"))
{
Invoker.ReleaseParamsArray(wb);
return;
}
NetOffice.ExcelApi.Workbook newWb = Factory.CreateKnownObjectFromComProxy <NetOffice.ExcelApi.Workbook>(EventClass, wb, typeof(NetOffice.ExcelApi.Workbook));
object[] paramsArray = new object[1];
paramsArray[0] = newWb;
EventBinding.RaiseCustomEvent("NewWorkbook", ref paramsArray);
}
/// <summary>
///
/// </summary>
/// <param name="wb"></param>
/// <param name="syncEventType"></param>
public void WorkbookSync([In, MarshalAs(UnmanagedType.IDispatch)] object wb, [In] object syncEventType)
{
if (!Validate("WorkbookSync"))
{
Invoker.ReleaseParamsArray(wb, syncEventType);
return;
}
NetOffice.ExcelApi.Workbook newWb = Factory.CreateKnownObjectFromComProxy <NetOffice.ExcelApi.Workbook>(EventClass, wb, typeof(NetOffice.ExcelApi.Workbook));
NetOffice.OfficeApi.Enums.MsoSyncEventType newSyncEventType = (NetOffice.OfficeApi.Enums.MsoSyncEventType)syncEventType;
object[] paramsArray = new object[2];
paramsArray[0] = newWb;
paramsArray[1] = newSyncEventType;
EventBinding.RaiseCustomEvent("WorkbookSync", ref paramsArray);
}
/// <summary>
///
/// </summary>
/// <param name="wb"></param>
/// <param name="target"></param>
public void WorkbookPivotTableOpenConnection([In, MarshalAs(UnmanagedType.IDispatch)] object wb, [In, MarshalAs(UnmanagedType.IDispatch)] object target)
{
if (!Validate("WorkbookPivotTableOpenConnection"))
{
Invoker.ReleaseParamsArray(wb, target);
return;
}
NetOffice.ExcelApi.Workbook newWb = Factory.CreateKnownObjectFromComProxy <NetOffice.ExcelApi.Workbook>(EventClass, wb, typeof(NetOffice.ExcelApi.Workbook));
NetOffice.ExcelApi.PivotTable newTarget = Factory.CreateKnownObjectFromComProxy <NetOffice.ExcelApi.PivotTable>(EventClass, target, typeof(NetOffice.ExcelApi.PivotTable));
object[] paramsArray = new object[2];
paramsArray[0] = newWb;
paramsArray[1] = newTarget;
EventBinding.RaiseCustomEvent("WorkbookPivotTableOpenConnection", ref paramsArray);
}
/// <summary>
///
/// </summary>
/// <param name="wb"></param>
/// <param name="changes"></param>
public void WorkbookModelChange([In, MarshalAs(UnmanagedType.IDispatch)] object wb, [In, MarshalAs(UnmanagedType.IDispatch)] object changes)
{
if (!Validate("WorkbookModelChange"))
{
Invoker.ReleaseParamsArray(wb, changes);
return;
}
NetOffice.ExcelApi.Workbook newWb = Factory.CreateKnownObjectFromComProxy <NetOffice.ExcelApi.Workbook>(EventClass, wb, typeof(NetOffice.ExcelApi.Workbook));
NetOffice.ExcelApi.ModelChanges newChanges = Factory.CreateKnownObjectFromComProxy <NetOffice.ExcelApi.ModelChanges>(EventClass, changes, typeof(NetOffice.ExcelApi.ModelChanges));
object[] paramsArray = new object[2];
paramsArray[0] = newWb;
paramsArray[1] = newChanges;
EventBinding.RaiseCustomEvent("WorkbookModelChange", ref paramsArray);
}
/// <summary>
///
/// </summary>
/// <param name="wb"></param>
/// <param name="cancel"></param>
public void WorkbookBeforePrint([In, MarshalAs(UnmanagedType.IDispatch)] object wb, [In][Out] ref object cancel)
{
if (!Validate("WorkbookBeforeSave"))
{
Invoker.ReleaseParamsArray(wb, cancel);
return;
}
NetOffice.ExcelApi.Workbook newWb = Factory.CreateKnownObjectFromComProxy <NetOffice.ExcelApi.Workbook>(EventClass, wb, typeof(NetOffice.ExcelApi.Workbook));
object[] paramsArray = new object[2];
paramsArray[0] = newWb;
paramsArray.SetValue(cancel, 1);
EventBinding.RaiseCustomEvent("WorkbookBeforeSave", ref paramsArray);
cancel = ToBoolean(paramsArray[1]);
}
/// <summary>
///
/// </summary>
/// <param name="wb"></param>
/// <param name="success"></param>
public void WorkbookAfterSave([In, MarshalAs(UnmanagedType.IDispatch)] object wb, [In] object success)
{
if (!Validate("WorkbookAfterSave"))
{
Invoker.ReleaseParamsArray(wb, success);
return;
}
NetOffice.ExcelApi.Workbook newWb = Factory.CreateKnownObjectFromComProxy <NetOffice.ExcelApi.Workbook>(EventClass, wb, typeof(NetOffice.ExcelApi.Workbook));
bool newSuccess = ToBoolean(success);
object[] paramsArray = new object[2];
paramsArray[0] = newWb;
paramsArray[1] = newSuccess;
EventBinding.RaiseCustomEvent("WorkbookAfterSave", ref paramsArray);
}
/// <summary>
///
/// </summary>
/// <param name="wb"></param>
/// <param name="sh"></param>
public void WorkbookNewSheet([In, MarshalAs(UnmanagedType.IDispatch)] object wb, [In, MarshalAs(UnmanagedType.IDispatch)] object sh)
{
if (!Validate("WorkbookNewSheet"))
{
Invoker.ReleaseParamsArray(wb, sh);
return;
}
NetOffice.ExcelApi.Workbook newWb = Factory.CreateKnownObjectFromComProxy <NetOffice.ExcelApi.Workbook>(EventClass, wb, typeof(NetOffice.ExcelApi.Workbook));
object newSh = Factory.CreateEventArgumentObjectFromComProxy(EventClass, sh) as object;
object[] paramsArray = new object[2];
paramsArray[0] = newWb;
paramsArray[1] = newSh;
EventBinding.RaiseCustomEvent("WorkbookNewSheet", ref paramsArray);
}
/// <summary>
///
/// </summary>
/// <param name="wb"></param>
/// <param name="map"></param>
/// <param name="url"></param>
/// <param name="result"></param>
public void WorkbookAfterXmlExport([In, MarshalAs(UnmanagedType.IDispatch)] object wb, [In, MarshalAs(UnmanagedType.IDispatch)] object map, [In] object url, [In] object result)
{
if (!Validate("WorkbookAfterXmlExport"))
{
Invoker.ReleaseParamsArray(wb, map, url, result);
return;
}
NetOffice.ExcelApi.Workbook newWb = Factory.CreateKnownObjectFromComProxy <NetOffice.ExcelApi.Workbook>(EventClass, wb, typeof(NetOffice.ExcelApi.Workbook));
NetOffice.ExcelApi.XmlMap newMap = Factory.CreateKnownObjectFromComProxy <NetOffice.ExcelApi.XmlMap>(EventClass, map, typeof(NetOffice.ExcelApi.XmlMap));
string newUrl = ToString(url);
NetOffice.ExcelApi.Enums.XlXmlExportResult newResult = (NetOffice.ExcelApi.Enums.XlXmlExportResult)result;
object[] paramsArray = new object[4];
paramsArray[0] = newWb;
paramsArray[1] = newMap;
paramsArray[2] = newUrl;
paramsArray[3] = newResult;
EventBinding.RaiseCustomEvent("WorkbookAfterXmlExport", ref paramsArray);
}
/// <summary>
///
/// </summary>
/// <param name="wb"></param>
/// <param name="description"></param>
/// <param name="sheet"></param>
/// <param name="success"></param>
public void WorkbookRowsetComplete([In, MarshalAs(UnmanagedType.IDispatch)] object wb, [In] object description, [In] object sheet, [In] object success)
{
if (!Validate("WorkbookRowsetComplete"))
{
Invoker.ReleaseParamsArray(wb, description, sheet, success);
return;
}
NetOffice.ExcelApi.Workbook newWb = Factory.CreateKnownObjectFromComProxy <NetOffice.ExcelApi.Workbook>(EventClass, wb, typeof(NetOffice.ExcelApi.Workbook));
string newDescription = ToString(description);
string newSheet = ToString(sheet);
bool newSuccess = ToBoolean(success);
object[] paramsArray = new object[4];
paramsArray[0] = newWb;
paramsArray[1] = newDescription;
paramsArray[2] = newSheet;
paramsArray[3] = newSuccess;
EventBinding.RaiseCustomEvent("WorkbookRowsetComplete", ref paramsArray);
}
/// <summary>
///
/// </summary>
/// <param name="wb"></param>
/// <param name="map"></param>
/// <param name="url"></param>
/// <param name="cancel"></param>
public void WorkbookBeforeXmlExport([In, MarshalAs(UnmanagedType.IDispatch)] object wb, [In, MarshalAs(UnmanagedType.IDispatch)] object map, [In] object url, [In][Out] ref object cancel)
{
if (!Validate("WorkbookBeforeXmlExport"))
{
Invoker.ReleaseParamsArray(wb, map, url, cancel);
return;
}
NetOffice.ExcelApi.Workbook newWb = Factory.CreateKnownObjectFromComProxy <NetOffice.ExcelApi.Workbook>(EventClass, wb, typeof(NetOffice.ExcelApi.Workbook));
NetOffice.ExcelApi.XmlMap newMap = Factory.CreateKnownObjectFromComProxy <NetOffice.ExcelApi.XmlMap>(EventClass, map, typeof(NetOffice.ExcelApi.XmlMap));
string newUrl = ToString(url);
object[] paramsArray = new object[4];
paramsArray[0] = newWb;
paramsArray[1] = newMap;
paramsArray[2] = newUrl;
paramsArray.SetValue(cancel, 3);
EventBinding.RaiseCustomEvent("WorkbookBeforeXmlExport", ref paramsArray);
cancel = ToBoolean(paramsArray[3]);
}
public Int32 WorkbookAddinUninstall(NetOffice.ExcelApi.Workbook wb)
{
return(Factory.ExecuteInt32MethodGet(this, "WorkbookAddinUninstall", wb));
}
public Int32 WorkbookModelChange(NetOffice.ExcelApi.Workbook wb, NetOffice.ExcelApi.ModelChanges changes)
{
return(Factory.ExecuteInt32MethodGet(this, "WorkbookModelChange", wb, changes));
}
public Int32 WorkbookPivotTableOpenConnection(NetOffice.ExcelApi.Workbook wb, NetOffice.ExcelApi.PivotTable target)
{
return(Factory.ExecuteInt32MethodGet(this, "WorkbookPivotTableOpenConnection", wb, target));
}
public Int32 WorkbookRowsetComplete(NetOffice.ExcelApi.Workbook wb, string description, string sheet, bool success)
{
return(Factory.ExecuteInt32MethodGet(this, "WorkbookRowsetComplete", wb, description, sheet, success));
}
public Int32 WorkbookAfterXmlExport(NetOffice.ExcelApi.Workbook wb, NetOffice.ExcelApi.XmlMap map, string url, NetOffice.ExcelApi.Enums.XlXmlExportResult result)
{
return(Factory.ExecuteInt32MethodGet(this, "WorkbookAfterXmlExport", wb, map, url, result));
}
public Int32 WorkbookBeforeXmlExport(NetOffice.ExcelApi.Workbook wb, NetOffice.ExcelApi.XmlMap map, string url, bool cancel)
{
return(Factory.ExecuteInt32MethodGet(this, "WorkbookBeforeXmlExport", wb, map, url, cancel));
}
public Int32 WorkbookBeforeXmlImport(NetOffice.ExcelApi.Workbook wb, NetOffice.ExcelApi.XmlMap map, string url, bool isRefresh, bool cancel)
{
return(Factory.ExecuteInt32MethodGet(this, "WorkbookBeforeXmlImport", new object[] { wb, map, url, isRefresh, cancel }));
}
public Int32 WorkbookSync(NetOffice.ExcelApi.Workbook wb, NetOffice.OfficeApi.Enums.MsoSyncEventType syncEventType)
{
return(Factory.ExecuteInt32MethodGet(this, "WorkbookSync", wb, syncEventType));
}
public Int32 WorkbookAfterSave(NetOffice.ExcelApi.Workbook wb, bool success)
{
return(Factory.ExecuteInt32MethodGet(this, "WorkbookAfterSave", wb, success));
}
private async Task <StreamlabsChatBotData> GatherStreamlabsChatBotSettings(string filePath)
{
try
{
StreamlabsChatBotData data = new StreamlabsChatBotData();
await Task.Run(() =>
{
using (NetOffice.ExcelApi.Application application = new NetOffice.ExcelApi.Application())
{
application.DisplayAlerts = false;
NetOffice.ExcelApi.Workbook workbook = application.Workbooks.Open(filePath);
if (workbook != null)
{
foreach (NetOffice.ExcelApi.Worksheet worksheet in workbook.Worksheets.AsEnumerable())
{
if (worksheet != null)
{
List <List <string> > dataValues = new List <List <string> >();
int totalColumns = 0;
bool hasValue = false;
do
{
hasValue = false;
NetOffice.ExcelApi.Range range = worksheet.Cells[1, totalColumns + 1];
if (range.Value != null)
{
totalColumns++;
hasValue = true;
}
} while (hasValue);
int currentRow = 2;
List <string> values = new List <string>();
do
{
values = new List <string>();
for (int i = 1; i <= totalColumns; i++)
{
NetOffice.ExcelApi.Range range = worksheet.Cells[currentRow, i];
if (range.Value != null)
{
values.Add(range.Value.ToString());
}
else
{
values.Add(string.Empty);
}
}
if (!values.All(v => string.IsNullOrEmpty(v)))
{
dataValues.Add(values);
}
currentRow++;
} while (!values.All(v => string.IsNullOrEmpty(v)));
if (worksheet.Name.Equals("Commands"))
{
data.AddCommands(dataValues);
}
else if (worksheet.Name.Equals("Timers"))
{
data.AddTimers(dataValues);
}
else if (worksheet.Name.Equals("Quotes") || worksheet.Name.Equals("Extra Quotes"))
{
data.AddQuotes(dataValues);
}
else if (worksheet.Name.Equals("Ranks"))
{
data.AddRanks(dataValues);
}
else if (worksheet.Name.Equals("Currency"))
{
data.AddViewers(dataValues);
}
else if (worksheet.Name.Equals("Events"))
{
data.AddEvents(dataValues);
}
}
}
}
application.Quit();
}
});
return(data);
}
catch (Exception ex)
{
Logger.Log(ex);
}
return(null);
}
public Int32 WorkbookNewChart(NetOffice.ExcelApi.Workbook wb, NetOffice.ExcelApi.Chart ch)
{
return(Factory.ExecuteInt32MethodGet(this, "WorkbookNewChart", wb, ch));
}
public Int32 WorkbookAfterXmlImport(NetOffice.ExcelApi.Workbook wb, NetOffice.ExcelApi.XmlMap map, bool isRefresh, NetOffice.ExcelApi.Enums.XlXmlImportResult result)
{
return(Factory.ExecuteInt32MethodGet(this, "WorkbookAfterXmlImport", wb, map, isRefresh, result));
}
public Int32 WindowDeactivate(NetOffice.ExcelApi.Workbook wb, NetOffice.ExcelApi.Window wn)
{
return(Factory.ExecuteInt32MethodGet(this, "WindowDeactivate", wb, wn));
}
