/// <summary> /// Fired when active workbook changes /// </summary> void Application_WorkbookDeactivate(Microsoft.Office.Interop.Excel.Workbook Wb) { if (m_AlfrescoPane != null) { m_AlfrescoPane.OnDocumentBeforeClose(); } }
/// <summary> /// Fired when active workbook changes /// </summary> void Application_WorkbookActivate(Microsoft.Office.Interop.Excel.Workbook Wb) { if (m_AlfrescoPane != null) { m_AlfrescoPane.OnDocumentChanged(); } }
/// <summary> /// Fired as a workbook is being closed /// </summary> /// <param name="Doc"></param> /// <param name="Cancel"></param> void Application_WorkbookBeforeClose(Microsoft.Office.Interop.Excel.Workbook Wb, ref bool Cancel) { if (m_AlfrescoPane != null) { m_AlfrescoPane.OnDocumentBeforeClose(); } }
/// <summary> /// Fired when the Excel Application loses focus /// </summary> /// <param name="Doc"></param> /// <param name="Wn"></param> void Application_WindowDeactivate(Microsoft.Office.Interop.Excel.Workbook Wb, Microsoft.Office.Interop.Excel.Window Wn) { if (m_AlfrescoPane != null) { m_AlfrescoPane.OnWindowDeactivate(); } }
private void ThisAddIn_Startup(object sender, System.EventArgs e) { //<snippet1> Microsoft.Office.Interop.Excel.Worksheet nativeWorksheet = Globals.ThisAddIn.Application.ActiveSheet; if (nativeWorksheet != null) { Microsoft.Office.Tools.Excel.Worksheet vstoSheet = Globals.Factory.GetVstoObject(nativeWorksheet); } //</snippet1> //<snippet2> Microsoft.Office.Interop.Excel.Workbook nativeWorkbook = Globals.ThisAddIn.Application.ActiveWorkbook; if (nativeWorkbook != null) { Microsoft.Office.Tools.Excel.Workbook vstoWorkbook = Globals.Factory.GetVstoObject(nativeWorkbook); } //</snippet2> //<snippet3> Microsoft.Office.Interop.Excel.Worksheet sheet = Globals.ThisAddIn.Application.ActiveSheet; if (sheet.ListObjects.Count > 0) { Excel.ListObject listObject = sheet.ListObjects[1]; Microsoft.Office.Tools.Excel.ListObject vstoListObject = Globals.Factory.GetVstoObject(listObject); } //</snippet3> }
private void ThisAddIn_Startup(object sender, System.EventArgs e) { //Instantiate the Application object. Excel.Application excelApp = Application; //Specify the template excel file path. string myPath = "Get Text of Specific Cell.xlsx"; //Open the excel file. Microsoft.Office.Interop.Excel.Workbook ThisWorkbook = excelApp.Workbooks.Open(myPath, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); String res = ""; res = ThisWorkbook.Worksheets["Sheet1"].Range("A1").Text; MessageBox.Show(res); //Save the file. excelApp.ActiveWorkbook.Save(); excelApp.Quit(); }
private void ThisAddIn_Startup(object sender, System.EventArgs e) { //Access vsto application Microsoft.Office.Interop.Excel.Application app = Globals.ThisAddIn.Application; //Access workbook Microsoft.Office.Interop.Excel.Workbook workbook = app.ActiveWorkbook; //Access worksheet Microsoft.Office.Interop.Excel.Worksheet m_sheet = workbook.Worksheets[1]; //Access vsto worksheet Microsoft.Office.Tools.Excel.Worksheet sheet = Globals.Factory.GetVstoObject(m_sheet); //Place some text in cell A1 without wrapping Microsoft.Office.Interop.Excel.Range cellA1 = sheet.Cells.get_Range("A1"); cellA1.Value = "Sample Text Unwrapped"; //Place some text in cell A5 with wrapping Microsoft.Office.Interop.Excel.Range cellA5 = sheet.Cells.get_Range("A5"); cellA5.Value = "Sample Text Wrapped"; cellA5.WrapText = true; //Save the workbook workbook.SaveAs("OutputVsto.xlsx"); //Quit the application app.Quit(); }
void Application_WorkbookBeforeSave(Microsoft.Office.Interop.Excel.Workbook Wb, bool SaveAsUI, ref bool Cancel) { //Excel.Worksheet activeWorksheet = ((Excel.Worksheet)Application.ActiveSheet); //Excel.Range firstRow = activeWorksheet.get_Range("A1"); //firstRow.EntireRow.Insert(Excel.XlInsertShiftDirection.xlShiftDown); //Excel.Range newFirstRow = activeWorksheet.get_Range("A1"); //newFirstRow.Value2 = "This text was added by using code"; }
public bool LimpiaExcel() { exHoja1 = null; exApli = null; exLibro = null; GC.Collect(); return(true); }
void btnCalc_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault) { object o = System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application"); Microsoft.Office.Interop.Excel._Application app = o as Microsoft.Office.Interop.Excel._Application; Microsoft.Office.Interop.Excel.Workbook workBook = app.ActiveWorkbook; ValiedateDialog dialog = new ValiedateDialog(); dialog.Show(); }
private void ListSheets(Microsoft.Office.Interop.Excel.Workbook workbook) { int index = 0; Excel.Range rng = this.Application.get_Range("A1", missing); foreach (Excel.Worksheet displayWorksheet in workbook.Worksheets) { rng.get_Offset(index, 0).Value2 = displayWorksheet.Name; index++; } }
void Application_WorkbookBeforeSave(Microsoft.Office.Interop.Excel.Workbook Wb, bool SaveAsUI, ref bool Cancel) { Excel.Application app = (Excel.Application)Globals.ThisAddIn.Application; Excel.Workbook wb3 = (Excel.Workbook)app.ActiveWorkbook; object s2 = wb3.Name; Excel.Worksheet wb2 = (Excel.Worksheet)app.ActiveSheet; object s = wb2.Name; Excel.Worksheet activeWorksheet = ((Excel.Worksheet)Application.ActiveSheet); Excel.Range firstRow = activeWorksheet.get_Range("A1"); firstRow.EntireRow.Insert(Excel.XlInsertShiftDirection.xlShiftDown); Excel.Range newFirstRow = activeWorksheet.get_Range("A1"); newFirstRow.Value2 = "This text was added by using code"; }
void app_WorkbookDeactivate(Microsoft.Office.Interop.Excel.Workbook wb) { string workbookName = ""; try { workbookName = wb.Name; } catch (Exception e) { string errorMsg = e.Message; workbookName = "error: " + errorMsg; } notifyWorkbookDeactivate(workbookName); }
void app_WorkbookBeforeSave(Microsoft.Office.Interop.Excel.Workbook wb, bool SaveAsUI, ref bool Cancel) { string workbookName = ""; try { workbookName = wb.Name; } catch (Exception e) { string errorMsg = e.Message; workbookName = "error: " + errorMsg; } notifyWorkbookBeforeSave(workbookName); }
public bool AbreExcel(bool vAdd) { exApli = new Microsoft.Office.Interop.Excel.Application(); exApli.Visible = false; if (_Fichero != "") { if (File.Exists(_Fichero)) { if (vAdd) { exLibro = exApli.Workbooks.Open(_Fichero, vk_update_links, vk_No_read_only, vk_format, vk_password, vk_write_res_password, vk_ignore_read_only_recommend, vk_origin, vk_delimiter, vk_editable, vk_notify, vk_converter, vk_add_to_mru, vk_local, vk_corrupt_load); } else { File.Delete(_Fichero); exLibro = exApli.Workbooks.Add(vk_missing); } } else { exLibro = exApli.Workbooks.Add(vk_missing); } } else { exLibro = exApli.Workbooks.Add(vk_missing); } //if (_Fichero != "") //{ // exApli.Visible = true; //} //else //{ // exApli.Visible = true; //} exApli.Visible = false; return(true); }
/// <summary> /// Método que crea un panel de validación de cruces por cada instancia de Excel /// </summary> /// <param name="wb"></param> private void Application_WorkbookActivate(Microsoft.Office.Interop.Excel.Workbook wb) { try { System.IO.FileInfo _ExcelFI = new System.IO.FileInfo(Globals.ThisAddIn.Application.ActiveWorkbook.Name); vdcUserControl = new VerificacionDeCruce(); myCustomTaskPane = CustomTaskPanes.Add(vdcUserControl, "Verificación " + _ExcelFI.Name); myCustomTaskPane.DockPosition = Office.MsoCTPDockPosition.msoCTPDockPositionRight; myCustomTaskPane.DockPositionRestrict = Office.MsoCTPDockPositionRestrict.msoCTPDockPositionRestrictNoChange; myCustomTaskPane.Width = 515; myCustomTaskPane.Visible = false; } catch (Exception ex) { throw new Exception($"Error al instanciar el Task Panel de Validacion. [ThisAddIn].[Application_WorkbookActivate].[26]: {ex.Message}"); } }
private void ThisAddIn_Startup(object sender, System.EventArgs e) { Excel.Application excelApp = Application; //Specify the template excel file path. string myPath = @"E:\Dropbox\Personal\aspose-for-vsto\Files\List All Worksheets in a Workbook.xlsx"; //Open the excel file. Microsoft.Office.Interop.Excel.Workbook ThisWorkbook = excelApp.Workbooks.Open(myPath, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); ListSheets(ThisWorkbook); }
void app_WorkbookBeforeXmlExport(Microsoft.Office.Interop.Excel.Workbook wb, Microsoft.Office.Interop.Excel.XmlMap map, string url, ref bool cancel) { string workbookName = ""; string mapName = map.Name; try { workbookName = wb.Name; } catch (Exception e) { string errorMsg = e.Message; workbookName = "error: " + errorMsg; } notifyWorkbookBeforeXmlExport(workbookName, mapName, url); }
private void ThisAddIn_Startup(object sender, System.EventArgs e) { //Instantiate the Application object. Excel.Application ExcelApp = Application; //Add a Workbook. Excel.Workbook objBook = ExcelApp.Workbooks.Add(System.Reflection.Missing.Value); // Access a Vsto Worksheet Microsoft.Office.Interop.Excel.Worksheet nativeWorksheet = Globals.ThisAddIn.Application.ActiveWorkbook.ActiveSheet; Microsoft.Office.Tools.Excel.Worksheet sheet = Globals.Factory.GetVstoObject(nativeWorksheet); //Add sample data for pie chart //Add headings in A1 and B1 sheet.Cells[1, 1] = "Products"; sheet.Cells[1, 2] = "Users"; //Add data from A2 till B4 sheet.Cells[2, 1] = "Aspose.Cells"; sheet.Cells[2, 2] = 10000; sheet.Cells[3, 1] = "Aspose.Slides"; sheet.Cells[3, 2] = 8000; sheet.Cells[4, 1] = "Aspose.Words"; sheet.Cells[4, 2] = 12000; //Chart reference Microsoft.Office.Tools.Excel.Chart productsChart; //Add a Pie Chart productsChart = sheet.Controls.AddChart(0, 105, 330, 200, "ProductUsers"); productsChart.ChartType = Microsoft.Office.Interop.Excel.XlChartType.xlPie; //Set chart title productsChart.HasTitle = true; productsChart.ChartTitle.Text = "Users"; //Gets the cells that define the data to be charted. Microsoft.Office.Interop.Excel.Range chartRange = sheet.get_Range("A2", "B4"); productsChart.SetSourceData(chartRange, missing); //Access the Active workbook from Vsto sheet Microsoft.Office.Interop.Excel.Workbook workbook = sheet.Application.ActiveWorkbook; //Save the copy of workbook as OutputVsto.xlsx workbook.SaveCopyAs("OutputVsto.xlsx"); }
public bool CierraExcel(bool vSave) { if (vSave) { //if (File.Exists(_Fichero)) { File.Delete(_Fichero); } exLibro.SaveAs(_Fichero + ".xls", Excel.XlFileFormat.xlWorkbookNormal, vk_missing, vk_missing, vk_missing, vk_missing, Excel.XlSaveAsAccessMode.xlExclusive, vk_missing, vk_missing, vk_missing, vk_missing, vk_missing); //csharp.net-informations.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue } exLibro.Close(vSave, vk_missing, vk_missing); exApli.Workbooks.Close(); exApli.Quit(); exHoja1 = null; exApli = null; exLibro = null; GC.Collect(); return(true); }
void app_WorkbookNewSheet(Microsoft.Office.Interop.Excel.Workbook wb, object Sh) { string workbookName = ""; string sheetName = ""; try { workbookName = wb.Name; Excel.Worksheet ws = (Excel.Worksheet)Sh; sheetName = ws.Name; } catch (Exception e) { string errorMsg = e.Message; workbookName = "error: " + errorMsg; } notifyWorkbookNewSheet(workbookName, sheetName); }
void Application_WorkbookBeforeSave(Microsoft.Office.Interop.Excel.Workbook Wb, bool SaveAsUI, ref bool Cancel) { /* an event handler for the WorkbookBeforeSave event, which is raised when a workbook is saved. * When the user saves a workbook, the event handler adds new text at the start of the active worksheet */ /* The Wb parameter is a Workbook object, which represents the saved workbook */ Excel.Worksheet activeWorksheet = ((Excel.Worksheet)Application.ActiveSheet); Excel.Range firstRow = activeWorksheet.get_Range("A1"); /* create string to insert with year month day hour minute second */ String insertTime = "'Saved at " + DateTime.Now.ToString(); /* check value for firstRow */ if (firstRow.Value != insertTime) { firstRow.EntireRow.Insert(Excel.XlInsertShiftDirection.xlShiftDown); Excel.Range newFirstRow = activeWorksheet.get_Range("A1"); newFirstRow.Value2 = insertTime; } }
//</Snippet5> //<Snippet6> void Application_WorkbookBeforeSave(Microsoft.Office.Interop.Excel.Workbook workbook, bool SaveAsUI, ref bool Cancel) { Excel.Worksheet worksheet = workbook.Worksheets[1] as Excel.Worksheet; if (Globals.Factory.HasVstoObject(worksheet) && Globals.Factory.GetVstoObject(worksheet).Controls.Count > 0) { Worksheet vstoWorksheet = Globals.Factory.GetVstoObject(worksheet); while (vstoWorksheet.Controls.Count > 0) { object vstoControl = vstoWorksheet.Controls[0]; vstoWorksheet.Controls.Remove(vstoControl); } } }
void Application_WorkbookBeforeSave(Microsoft.Office.Interop.Excel.Workbook workbook, bool SaveAsUI, ref bool Cancel) { /*Excel.Worksheet worksheet = * workbook.Worksheets[1] as Excel.Worksheet; * * if (Globals.Factory.HasVstoObject(worksheet) && * Globals.Factory.GetVstoObject(worksheet).Controls.Count > 0) * { * Worksheet vstoWorksheet = Globals.Factory.GetVstoObject(worksheet); * * * * while (vstoWorksheet.Controls.Count > 0) * { * object vstoControl = vstoWorksheet.Controls[1]; * vstoWorksheet.Controls.Remove(vstoControl); * } * * }*/ }
private void ThisAddIn_Startup(object sender, System.EventArgs e) { //Access vsto application Microsoft.Office.Interop.Excel.Application app = Globals.ThisAddIn.Application; //Access workbook Microsoft.Office.Interop.Excel.Workbook workbook = app.ActiveWorkbook; //Access worksheet Microsoft.Office.Interop.Excel.Worksheet m_sheet = workbook.Worksheets[1]; //Access vsto worksheet Microsoft.Office.Tools.Excel.Worksheet worksheet = Globals.Factory.GetVstoObject(m_sheet); //Access cells A1, A2, A3 , A4 Microsoft.Office.Interop.Excel.Range cellA1 = worksheet.Range["A1"]; Microsoft.Office.Interop.Excel.Range cellA2 = worksheet.Range["A2"]; Microsoft.Office.Interop.Excel.Range cellA3 = worksheet.Range["A3"]; Microsoft.Office.Interop.Excel.Range cellA4 = worksheet.Range["A4"]; //Set integer values in cells A1, A2 and A3 cellA1.Value = 10; cellA2.Value = 20; cellA3.Value = 30; //Add formula in cell A4 cellA4.Formula = "=Sum(A1:A3)"; //Set the font bold in cell A4 cellA4.Font.Bold = true; //Set the background color to Yellow in cell A4 cellA4.Interior.Color = Excel.XlRgbColor.rgbYellow; //Save the workbook workbook.SaveAs("OutputVsto.xlsx"); //Quit the application app.Quit(); }
void app_WorkbookBeforeXmlImport(Microsoft.Office.Interop.Excel.Workbook wb, Microsoft.Office.Interop.Excel.XmlMap map, string url, bool isRefresh, ref bool Cancel) { string workbookName = ""; string mapName = map.Name; string refresh = "false"; try { workbookName = wb.Name; if (isRefresh) { refresh = "true"; } } catch (Exception e) { string errorMsg = e.Message; workbookName = "error: " + errorMsg; } notifyWorkbookBeforeXmlImport(workbookName, mapName, refresh); }
private void ThisAddIn_Startup(object sender, System.EventArgs e) { Excel.Application excelApp = Application; //Specify the template excel file path. string myPath = "Book1.xls"; //Open the excel file. Microsoft.Office.Interop.Excel.Workbook ThisWorkbook = excelApp.Workbooks.Open(myPath, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); Excel.Worksheet Worksheet = ThisWorkbook.Worksheets["Sheet1"]; findNow(Worksheet, "test"); //Save the file. excelApp.ActiveWorkbook.Save(); excelApp.Quit(); }
void Application_WorkbookBeforeSave(Microsoft.Office.Interop.Excel.Workbook Wb, bool SaveAsUI, ref bool Cancel) { this.Application.Run("bulkrefresh"); }
void Application_WorkbookOpen(Microsoft.Office.Interop.Excel.Workbook Wb) { AddCustomXmlPartToWorkbook(Wb); }
void Application_WorkbookOpen(Microsoft.Office.Interop.Excel.Workbook Wb) { //new SynEstToolRibbon().Ribbon_Activation(); }