datagrid导出excel的两种方法
private void ResponseExcel(){
//1、将当前datagrid读入DataTable
//2、写html
//3、将变量输出 excel导出
//StringBuilder hw = new StringBuilder() ;
Response.ContentType="application/vnd.ms-excel";
Response.Charset="GB2312";
this.EnableViewState=false;
StringWriter sw = new StringWriter();
System.Web.UI.HtmlTextWriter hw = new HtmlTextWriter(sw);
this.DingDanGrid.Columns[0].Visible =false;
this.DingDanGrid.RenderControl(hw);
//sw.WriteLine(hw);
Response.Write(sw.ToString());
Response.End();
}
private void ResponseExcel2(){
//StringBuilder hw = new StringBuilder();
StringWriter sw = new StringWriter();
sw.WriteLine("流水号,制单人,制单时间,业务联系人,要求交货期,评审交期,实际入库,是否准时,品名,型号,数量,备注,K3单号,已出货量,时间,未出货量,出货时间");
//sw.WriteLine("流水号