I recently sorted out a class for exporting excel, which is quite helpful! Now, I hope that the experts will help you improve it!
Class file: export_excel
Call method:
Appdto2.export _ Excel exportexcel = new appdto2.export _ Excel ();
Exportexcel. _ startcount = 1;
If (rbtall. Checked)
{
Exportexcel. _ dt = gridviewdatasource;
}
Else
{
Exportexcel. _ gridview = gridview1;
}
Exportexcel. _ headertext = "personal exam Statistics ";
Exportexcel. _ filename = "personal examination statistical table ";
Arraylist alist = new arraylist ();
Alist. Add (appdto2.htmltablecellx. additem ("Exam name", "center", "", "20% ","",""));
Alist. Add (appdto2.htmltablecellx. additem ("effective time", "center", "", "20% ","",""));
Alist. Add (appdto2.htmltablecellx. additem ("Exam Times", "center", "", "20% ","",""));
Alist. Add (appdto2.htmltablecellx. additem ("unevaluated", "center", "", "20% ","",""));
Response. Write (exportexcel. exporttoexcel (this, alist ));
Response. End ();