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 AddSmartTagToWorkbook(Excel.Workbook workbook)
{
Microsoft.Office.Tools.Excel.SmartTag smartTagDemo =
// Create a smart tag for .NET Framework 3.5 projects.
// new Microsoft.Office.Tools.Excel.SmartTag(
// "www.microsoft.com/Demo#DemoSmartTag",
// "Demonstration Smart Tag");
// Create a smart tag for .NET Framework 4 projects.
Globals.Factory.CreateSmartTag(
"www.microsoft.com/Demo#DemoSmartTag",
"Demonstration Smart Tag");
// Specify a term and an expression to recognize.
smartTagDemo.Terms.Add("sale");
smartTagDemo.Expressions.Add(
new System.Text.RegularExpressions.Regex(
@"[I|i]ssue\s\d{5,6}"));
// Create the action for .NET Framework 3.5 projects.
// displayAddress = new Microsoft.Office.Tools.Excel.Action(
// "To be replaced");
// Create the action for .NET Framework 4 projects.
displayAddress = Globals.Factory.CreateAction("To be replaced");
// Add the action to the smart tag.
smartTagDemo.Actions = new
Microsoft.Office.Tools.Excel.Action[] { displayAddress };
// Get the host item for the workbook in .NET Framework 3.5 projects.
// Microsoft.Office.Tools.Excel.Workbook vstoWorkbook =
// workbook.GetVstoObject();
// Get the host item for the workbook in .NET Framework 4 projects.
Microsoft.Office.Tools.Excel.Workbook vstoWorkbook =
Globals.Factory.GetVstoObject(workbook);
// Add the smart tag to the active workbook.
vstoWorkbook.VstoSmartTags.Add(smartTagDemo);
displayAddress.BeforeCaptionShow += new
Microsoft.Office.Tools.Excel.BeforeCaptionShowEventHandler(
DisplayAddress_BeforeCaptionShow);
displayAddress.Click += new
Microsoft.Office.Tools.Excel.ActionClickEventHandler(
DisplayAddress_Click);
}
