Using unmanaged code

^ What is Interoperation for?
There might be many lines of legacy code left for companies. If they had to rewrite and retest thiese codes prior to launching any new application developed in .NET, they would have never made the switch. Using an "all or nothing" approach with migrating to .NET is simply too expensive and time consuming for many companies with investments in legacy code.
By taking advantage of Interoperation, they are able to migrate their existing applications little by little, in a manner that was virtually transparent to clients. Were it not for Interoperation, they would have never made the migration.

^ Prior to advent of the .NET Framework, the COM Framework was the primary framework for developers to interact with the Windows operating system.

d The mechanism that serves as proxy so that the .NET runtime can communicate with a COM component is known as a Runtime Callable Wrapper (RCW), which handles the majority of the work between .NET and COM for you, including marshaling data types, handling events, and handling interfaces.

d Unlike pure .NET components, COM components must be registered before they can be used.
d Every COM components must have an entry in the Windows registry.

d After importing it, using an object contained in a given COM library is virtually identical to using ne created purely in .NET.

d What is Platform Invoke? and when to use it?

d Use Platform Invoke through the System.Runtime.InteropServices namespace:

1. Create a static/shared external method with the name of the function you want to call.
2. Decorate it with the DllImport attribute specifying the library that it should call.
3. Call the method from your code.

Imports System.Runtime.InteropServices

Public Class InterExample


      Private Shared Function GetForeWindow() As IntPtr
      End Function

      Public Shared Sub GetScreenDemo()
            Dim DemoHandle = GetForeWindow()
      End Sub

End Class

d Encapsulating DLL Functions: Because Platform Invoke calls is not elegant, it's often beneficial to create a class that exposes them and wraps this functionality. After all, much of the .NET Framework is composed of precisely this methodology.

@ You need to call an unmanaged function from your managed code by using Platform Invoke services. What should you do?
Create a class to hold DLL functions and then create prototype methods by using managed code.

Auto searching and merging cells of same value.

/// 

  /// 把指定栏中的相同内容的cells合并成一个cell。
  /// 
  /// 
  /// 
  public void MergeIdenticalCells(int _rowIndexOfStartCell, int _columnIndexOfStartCell)
  {
   // 首先把returnedEndCell设为与startCell一样。
   int rowIndexOfReturnedEndCell = _rowIndexOfStartCell;
   int columnIndexOfReturnedEndCell = _columnIndexOfStartCell;
  
   int rowIndexOfWholeColumn = _rowIndexOfStartCell - 1 + oSheet.UsedRange.Rows.Count;
   try
   {
    while(rowIndexOfReturnedEndCell < rowindexofendcell =" _rowIndexOfStartCell;" columnindexofendcell =" _columnIndexOfStartCell;" rangeofstartcell =" (Range)(oSheet.Cells[_rowIndexOfStartCell," i =" _rowIndexOfStartCell;" selectedcell =" (Range)(oSheet.Cells[i," rowindexofendcell =" i;" rangeofendcell =" (Range)(oSheet.Cells[rowIndexOfEndCell," valueofendcell =" rangeOfEndCell.Value2.ToString();" themergedrange =" oSheet.get_Range(rangeOfStartCell," value2 =" Type.Missing;" value2 =" valueOfEndCell;" _rowindexofstartcell =" rangeOfEndCell.Row">

Manipulating Microsoft Office

Excel How to
Office Wiki
Joe Andreshak (MS) http://blogs.officezealot.com/joe/
Clinick's Clinic http://weblogs.asp.net/andrewclinick/
John Durant (MS) http://blogs.msdn.com/johnrdurant
Mark Harrison (MS) http://blog.markharrison.co.uk/
Laura John (MS) http://blogs.msdn.com/lauraj
Eric Lippert (MS) http://blogs.msdn.com/ericlippert
Andrew May (MS): http://blogs.msdn.com/andrew_may
Chris Kunicki http://blogs.officezealot.com/chris
Charles Maxson http://blogs.officezealot.com/charles
Office Zealot Blogz http://www.officezealot.com/BlogHome.aspx
Frank Rice (MS) http://blogs.msdn.com/frice
Peter's Blog: http://blog.jausovec.net/
Peter Torr: http://weblogs.asp.net/ptorr/

Exporting Data to Excel

Original Address: http://www.developer.com/net/asp/article.php/3633891

A common request of users is to be able to download data for use in Microsoft Excel. This is actually fairly easy to accomplish without a lot of extra work.

I do most of my database work with DataTable objects, as I don't need the overhead of a DataSet. I also have a Database wrapper class that is able to easily retrieve data from a SQL Server database. Once I use my function to get my DataTable, I can start exporting the data. For this example, however, I'll use the traditional SqlDataAdapter method to retrieve the data initially.

There are a few tricks to making this work.
First, you have to create an ASPX page with no HTML content in it. The only thing that should be in the ASPX page is the Page directive at the top.
The second trick is to clear the existing content and send down a new content type. For Excel, you use a content type of application/vnd.ms-excel. This tells your Web browser to expect something that can be handled within Excel.
The third trick is to send down the data tab-delimited per column and a newline at the end of each row.
After that, Excel does the rest of the work for you.