Import and Export data from Excel

Hi,

To add Microsoft.Office.Interop.Excel Reference in your project.

For Export to Excel...http://support.microsoft.com/kb/306023

For Import from Excel..http://www.dotnetfunda.com/codes/code972-read-a-excel-file-with-sheet-wise-into-dataset-using-csharp.aspx


Cheers :)

Thanks,
T.Saravanan

Sathya4260, if this helps please login to Mark As Answer. | Alert Moderator

hi saravanan thanks fr ur timely response,

Wen i tried to use the below code to export the result of grid view to excel i got error as

RegisterForEventValidation can only be called during Render();

protected void Button1_Click(object sender, EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
Response.Charset = "";
// If you want the option to open the Excel file without saving than
// comment out the line below
// Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite =
new HtmlTextWriter(stringWrite);
GridView1.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
public override void VerifyRenderingInServerForm(Control control)
{
}

Help me to solve this.....

Sathish Kumar S

Sathya4260, if this helps please login to Mark As Answer. | Alert Moderator

Hi Sathish,

Sorry for the delay....
Same error is discuss in this link...http://www.aspsnippets.com/Articles/RegisterForEventValidation-can-only-be-called-during-Render.aspx
and also look this link for export to excel...http://www.c-sharpcorner.com/uploadfile/dipalchoksi/exportxl_asp2_dc11032006003657am/exportxl_asp2_dc.aspx

Cheers :)

Thanks,
T.Saravanan

Sathya4260, if this helps please login to Mark As Answer. | Alert Moderator

I got the answer,

since i used firefox as the browser,

Just insert the below code

Response.Cache.SetCacheability(HttpCacheability.NoCache);

Sathish Kumar S

Sathya4260, if this helps please login to Mark As Answer. | Alert Moderator

Hi Sathish,

Thanks for your answer sharing....

Thanks,
T.Saravanan

Sathya4260, if this helps please login to Mark As Answer. | Alert Moderator

Hi Sathish,

Great to know that you got the answer, could you please mark appropriate post as Answer so that it will help others?

Thanks

Best regards,
Webmaster
http://www.dotnetfunda.com

Sathya4260, if this helps please login to Mark As Answer. | Alert Moderator