/// <summary> /// 执行导出 /// </summary> public virtual void Execute() { var excelConfig = new ExportExcelConfig(); excelConfig.Properties.AddRange(GetProperties()); excelConfig.CreateExcelFile(List, ExcelName); }
protected void Page_Load(object sender, EventArgs e) { //Response.Clear(); //清空无关信息 //Response.BufferOutput = false; //完成整个响应后再发送 //Response.Charset = "utf-8";//设置输出流的字符集 //Response.AppendHeader("Content-Disposition", "attachment;filename=test.xls");//追加头信息 //Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//设置输出流的字符集 //Response.ContentType = "application/vnd.ms-excel";// //创建2007的Excel //Response.Write("<html xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns=\"http://www.w3.org/TR/REC-html40\"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head>><body><table>"); //for (int i = 0; i < 100; i++) //{ // Response.Write($"<tr><td>{i}</td></tr>"); // //var bytes = Encoding.UTF8.GetBytes(i.ToString()); // //Response.BinaryWrite(bytes); //} //Response.Write("</table></body></html>"); // Response.End();//停止输出 var list = new List <ClassA>(); list.Add(new ClassA() { Title = "2" }); var excelConfig = new ExportExcelConfig(); excelConfig.Properties.Add(new ExportExcelProperty() { Caption = "标题", EntityProp = "Title" }); //var excelName = DateTime.Now.ToString("yyyyMMddHHmmss_fff") + ".xls"; var excelName = "20180918155457_019.xls"; excelConfig.CreateExcelFile(list, excelName); //excelConfig.CreateExcelFile(list, excelName); }