Hi
I need a code to export data into excel using C#.
Any one can send the code?

Hi
See this
oControl.Page.Response.Clear();
oControl.Page.Response.Buffer=true;
oControl.Page.Response.ContentType = "application/vnd.ms-excel";
oControl.Page.Response.Charset = "";
oControl.Page.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
oControl.RenderControl(oHtmlTextWriter);
oControl.Page.Response.Write(oStringWriter.ToStrin g());
oControl.Page.Response.End();

oControl is any server control (datagrid, table etc)

Avanish

I have already tried with this code but this displays pagewise and when i click for exporting only current page is exporting to Excel,I need to do whole record from database.

hi
Import office web component and use this

Dim oXL As New Excel.Application
Dim oBooks As Excel.Workbooks = oXL.Workbooks
Dim oWB As Excel.Workbook = oBooks.Add
Dim oSheet As Excel.Worksheet = oXL.ActiveSheet
oSheet.Cells(1, 1).value = "A"
oSheet.Cells(2, 1).value = "B"
oSheet.Cells(3, 1).value = "C"
oSheet.Cells(1, 2).value = "D"
oSheet.Cells(2, 2).value = "E"
oSheet.Cells(3, 2).value = "F"
oXL.ActiveWorkbook.SaveAs(SaveAsPath)
NAR(oSheet)
oWB.Close(False)
NAR(oWB)
oBooks.Close()
NAR(oBooks)
oXL.Application.Quit()
NAR(oXL)
oXL = Nothing

Avanish

what are all these:

Dim oXL As New Excel.Application
Dim oBooks As Excel.Workbooks = oXL.Workbooks
Dim oWB As Excel.Workbook = oBooks.Add
Dim oSheet As Excel.Worksheet = oXL.ActiveSheet


I imported office web component,but getting error. I need the code in C#.

Very strange that no one has replied correctly for this query.
I need it very urgently.

What u mean by "What are all these"-----

Do u have set the rerences

Go to Add Refrences--> Com

Add Microsoft Excel object lib 11 or 10 .....

Exporting datagrid to excel might sounds complex but its pretty simple. Let's see how this can be done.

Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");

Response.Charset = "";

Response.Cache.SetCacheability(HttpCacheability.No Cache);

Response.ContentType = "application/vnd.xls";

System.IO.StringWriter stringWrite = new System.IO.StringWriter();

System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

myDataGrid.RenderControl(htmlWrite);

Response.Write(stringWrite.ToString());

Response.End();


Gokulan Ethiraj

the coding is juat can send the first page of the data(if data grid in paing). It can not export all the data to excel.
Any solution please. Thanx very much