Export data to excel

Export data to excel button event

View code

 
Private VoidBtnexporttoexcelclick (ObjectSender, eventargs E)
{
//How to export data to excel
Exporttoexcel ("Application/MS-Excel","Registry.x.xls");
}
 

How to export data to excel

View code

 ///     <Summary>  
  ///  Export data to excel
  ///     </Summary>  
  ///     <Param name = "filetype">  Export format </Param>  
  ///     <Param name = "FILENAME">  File Name  </Param>  
    Private     Void  Exporttoexcel (  String  Filetype,  String Filename)
{
Response. charset  =     "  Gb2312  "  ;

Response. contentencoding  =  Encoding. utf8;

Response. appendheader (  "  Content-Disposition  "  ,  "  Attachment; filename = "     +  Httputility. urlencode (filename, encoding. utf8 ));

Response. contenttype  =  Filetype;

Enableviewstate  =     False  ;

VaR TW  =     New  Stringwriter ();

VaR HW  =    New  Htmltextwriter (TW );

Datarepeater. rendercontrol (HW );  //  Datarepeater: the data source to export data. It can be in other forms, such as dataview.  
  
Response. Write (TW. tostring ());

Response. End ();

} 

Page Effect

Click "export data to excel". The following dialog box is displayed.

Open the Excel file after downloading. The effect is as follows: