Export the page (chart + Table + gridview) to excel

Protected   Void Button3_click ( Object Sender, eventargs E)
{
Response. Clear ();
Response. Buffer =   True ;
Response. charset =   " Gb2312 " ;
Response. appendheader ( " Content-Disposition " , " Attachment?filename=filename.xls " );
// If it is set to getencoding ("gb2312"), the exported file will contain garbled characters !!!
Response. contentencoding = System. Text. encoding. utf7;
Response. contenttype =   " Application/MS-Excel " ; // Set the output file type to an Excel file.

System. Io. stringwriter ostringwriter =   New System. Io. stringwriter ();
System. Web. UI. htmltextwriter ohtmltextwriter =   New System. Web. UI. htmltextwriter (ostringwriter );

String ImagePath = Server. mappath ( This . Daxontechchartweb1.imagepath) +   " \\ "   +   This . Daxontechchartweb1.id +   " . "   +   This . Daxontechchartweb1.imagetype. tostring ();
Ohtmltextwriter. addattribute (htmltextwriterattribute. SRC, ImagePath );

Tableexcel. rendercontrol (ohtmltextwriter );
Response. Output. Write (ostringwriter. tostring ());

Response. Flush ();
Response. End ();


}

Gridview: Protected   Void Button_toexcel_click ( Object Sender, eventargs E)
{
Response. Clear ();
Response. Buffer =   True ;
Response. charset =   " Gb2312 " ;
Response. appendheader ( " Content-Disposition " , " Attachment?filename=filename.xls " );
// If it is set to getencoding ("gb2312"), the exported file will contain garbled characters !!!
Response. contentencoding = System. Text. encoding. utf7;
Response. contenttype =   " Application/MS-Excel " ; // Set the output file type to an Excel file.
System. Io. stringwriter ostringwriter =   New System. Io. stringwriter ();
System. Web. UI. htmltextwriter ohtmltextwriter =   New System. Web. UI. htmltextwriter (ostringwriter );
// Turn Off Paging

Gridview1.allowpaging =   False ;
Gridview1.columns [ 0 ]. Visible =   False ;
Gridview1.databind ();
Gridview1.rendercontrol (ohtmltextwriter );
Response. Output. Write (ostringwriter. tostring ());
Response. Flush ();
Response. End ();
// Turn the paging on again
Gridview1.allowpaging =   True ;
Gridview1.databind ();

}