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