#region Smart Tag Example
private Microsoft.Office.Tools.Excel.Action DisplayAddress;
private void AddSmartTag()
{
Microsoft.Office.Tools.Excel.SmartTag SmartTagDemo =
new Microsoft.Office.Tools.Excel.SmartTag(
"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.
DisplayAddress = new Microsoft.Office.Tools.Excel.Action(
"To be replaced");
// Add the action to the smart tag.
SmartTagDemo.Actions = new
Microsoft.Office.Tools.Excel.Action[] {
DisplayAddress };
// Add the smart tag to the workbook.
this.VstoSmartTags.Add(SmartTagDemo);
DisplayAddress.BeforeCaptionShow += new
Microsoft.Office.Tools.Excel.BeforeCaptionShowEventHandler(
DisplayAddress_BeforeCaptionShow);
DisplayAddress.Click += new
Microsoft.Office.Tools.Excel.ActionClickEventHandler(
DisplayAddress_Click);
}
void DisplayAddress_BeforeCaptionShow(object sender,
Microsoft.Office.Tools.Excel.ActionEventArgs e)
{
DisplayAddress.Caption = "Display the address of " +
e.Text;
}
void DisplayAddress_Click(object sender,
Microsoft.Office.Tools.Excel.ActionEventArgs e)
{
string smartTagAddress = e.Range.get_Address(missing,
missing, Excel.XlReferenceStyle.xlA1, missing, missing);
MessageBox.Show("The recognized text '" + e.Text +
"' is at range " + smartTagAddress);
}
#endregion