http://nfex.ru/index.php?action=history&feed=atom&title=Csharp%2FC_Sharp%2FOffice%2FOffice_Event 2026-04-29T17:30:21Z История изменений этой страницы в вики MediaWiki 1.30.0 http://nfex.ru/index.php?title=Csharp/C_Sharp/Office/Office_Event&diff=1517&oldid=prev 2010-05-26T15:31:19Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 15:31, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table>

http://nfex.ru/index.php?title=Csharp/C_Sharp/Office/Office_Event&diff=1518&oldid=prev 2010-05-26T11:47:15Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>==Using Office Events==<br /> <br /> <br /> <br /> &lt;source lang=&quot;csharp&quot;&gt;<br /> /*<br /> * C# Programmers Pocket Consultant<br /> * Author: Gregory S. MacBeth<br /> * Email: gmacbeth@comporium.net<br /> * Create Date: June 27, 2003<br /> * Last Modified Date:<br /> * Version: 1<br /> */<br /> using System;<br /> using Excel;<br /> using System.Reflection;<br /> namespace Client.Chapter_19___Office_Integration<br /> {<br /> public class UsingOfficeEvents<br /> {<br /> public static AppEvents_WorkbookBeforeCloseEventHandler Event_BeforeBookClose;<br /> public static DocEvents_ChangeEventHandler Event_ChangeEvent;<br /> static void Main(string[] args)<br /> {<br /> Application MyExcel = new ApplicationClass();<br /> Workbook MyWorkbook = MyExcel.Workbooks.Add(Missing.Value);<br /> MyWorkbook.Windows.get_Item(1).Caption = &quot;Using Delegates&quot;;<br /> Worksheet MyWorksheet1 = (Worksheet)MyWorkbook.Worksheets.get_Item(1);<br /> Worksheet MyWorksheet2 = (Worksheet)MyWorkbook.Worksheets.get_Item(2);<br /> Worksheet MyWorksheet3 = (Worksheet)MyWorkbook.Worksheets.get_Item(3);<br /> MyWorksheet1.Activate();<br /> //Add Event Handler for the BeforeClose Event<br /> Event_BeforeBookClose = new AppEvents_WorkbookBeforeCloseEventHandler(BeforeBookClose);<br /> MyExcel.WorkbookBeforeClose += Event_BeforeBookClose;<br /> //Add Event Handler for the change Event<br /> Event_ChangeEvent = new DocEvents_ChangeEventHandler(CellChange);<br /> MyWorksheet1.Change += Event_ChangeEvent;<br /> MyWorksheet2.Change += Event_ChangeEvent;<br /> MyWorksheet3.Change += Event_ChangeEvent;<br /> MyExcel.Visible = true;<br /> MyExcel.UserControl = true;<br /> }<br /> private static void CellChange(Range Target)<br /> {<br /> //Gets called when you change a cell<br /> }<br /> private static void BeforeBookClose(Workbook MyWorkbook, ref bool Cancel)<br /> {<br /> //Gets called before closing a workbook<br /> }<br /> }<br /> }<br /> <br /> &lt;/source&gt;</div>

Admin