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)); }