Export data from datagrid to Excel

[kvsmsubramanyam]

Hi

I am doing an application in which the search results are made to be displayed on datagrid. Now I should have the same results to be exported to excel sheet.

Can anyone guide me in this. My application is window based using C# .Net and Oracle database.

[c83]

Hi

I am doing an application in which the search results are made to be displayed on datagrid. Now I should have the same results to be exported to excel sheet.

Can anyone guide me in this. My application is window based using C# .Net and Oracle database.

This si called Office Automation, google this and you will find a lot of results.

First you must add a com reference to your project - Microsoft Excel 11.0 Object Library (or other version).
And here is a piece of code of mine:

Excel.Application app = null;              
// change culture information for the current thread  
System.Globalization.CultureInfo oldCI = System.Threading.Thread.CurrentThread.CurrentCulture;  System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");         
  app = new Excel.Application();      
app.Visible = false;      
app.DisplayAlerts = false;  
    Excel.Workbooks books = app.Workbooks;      
Excel.Workbook book = (Excel.Workbook) books.Add("templ.xlt");
     Excel.Worksheet sheet = (Excel.Worksheet)book.Worksheets[1];