http://nfex.ru/index.php?action=history&feed=atom&title=Csharp%2FCSharp_Tutorial%2FWindows%2FExcel 2026-04-29T16:34:07Z История изменений этой страницы в вики MediaWiki 1.30.0 http://nfex.ru/index.php?title=Csharp/CSharp_Tutorial/Windows/Excel&diff=6696&oldid=prev 2010-05-26T15:31:53Z

<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/CSharp_Tutorial/Windows/Excel&diff=6697&oldid=prev 2010-05-26T12:20:15Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>==BindToMoniker Excel==<br /> <br /> <br /> <br /> &lt;source lang=&quot;csharp&quot;&gt;using System;<br /> using System.Runtime.InteropServices;<br /> using System.Windows.Forms;<br /> using Excel;<br /> class MainClass<br /> {<br /> [STAThread]<br /> static void Main(string[] args)<br /> {<br /> Excel.Workbook MyWorkBook;<br /> Excel.Worksheet MyWorkSheet;<br /> string FileName = @&quot;C:\Mybook.xls&quot;;<br /> MyWorkBook = (Excel.Workbook)Marshal.BindToMoniker(FileName);<br /> MyWorkSheet = (Excel.Worksheet)MyWorkBook.ActiveSheet;<br /> System.Windows.Forms.Application.Run();<br /> }<br /> }&lt;/source&gt;<br /> <br /> ==Excel Interop Example==<br /> <br /> <br /> <br /> &lt;source lang=&quot;csharp&quot;&gt;using System;<br /> using System.Runtime.InteropServices;<br /> class MainClass<br /> {<br /> [STAThread]<br /> static void Main(string[] args)<br /> {<br /> Excel.Application app = new Excel.ApplicationClass();<br /> app.Visible = true;<br /> app.Workbooks.Add( VarEnum.VT_NULL );<br /> app.ActiveCell.set_Value( Excel.XlRangeValueDataType.xlRangeValueDefault, &quot;Hello excel&quot; );<br /> }<br /> }&lt;/source&gt;<br /> <br /> ==Excel workbook event handlers==<br /> <br /> <br /> <br /> &lt;source lang=&quot;csharp&quot;&gt;using System;<br /> using Excel;<br /> using System.Reflection;<br /> public class MainClass<br /> {<br /> public static AppEvents_WorkbookBeforeCloseEventHandler Event_BeforeBookClose;<br /> public static DocEvents_ChangeEventHandler Event_ChangeEvent;<br /> public static void Main(string[] args)<br /> {<br /> Application excelApp = new ApplicationClass();<br /> Workbook MyWorkbook = excelApp.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 /> Event_BeforeBookClose = new AppEvents_WorkbookBeforeCloseEventHandler(BeforeBookClose);<br /> excelApp.WorkbookBeforeClose += Event_BeforeBookClose;<br /> Event_ChangeEvent = new DocEvents_ChangeEventHandler(CellChange);<br /> MyWorksheet1.Change += Event_ChangeEvent;<br /> MyWorksheet2.Change += Event_ChangeEvent;<br /> MyWorksheet3.Change += Event_ChangeEvent;<br /> excelApp.Visible = true;<br /> excelApp.UserControl = true;<br /> }<br /> private static void CellChange(Range Target)<br /> {<br /> MessageBox.Show(&quot;cell changed&quot;);<br /> }<br /> private static void BeforeBookClose(Workbook MyWorkbook, ref bool Cancel)<br /> {<br /> MessageBox.Show(&quot;before closing a workbook&quot;);<br /> }<br /> }&lt;/source&gt;</div>

Admin