Research on Method of Export Data into Excel in C# .NET

In C#.NET,the commonly method of export the data in the component of DataGridView into Excel uses the Excel's COM component to achieve it.But because the vision of Excel between the development machine and user's machine installed maybe different,this method often leads to the phenomenon of incompatible.To solve this problem,the reflection technique is proposed to implement the interaction of C# and Excel.Through the experiment on the computer with different visions of Excel,the results show that this method can solve the problem of version compatibility very well.