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: