dgExport.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
dgExport.RenderControl(oHtmlTextWriter);
string HtmlInfo = oStringWriter.ToString().Trim();
string DocFileName = "JobOrder"+DateTime.Now.ToFileTime()+".xls";
string FilePathName = Server.MapPath("upload");
//得到Excel文件的物理地址
FilePathName = FilePathName +"\\" + DocFileName; System.IO.File.Delete(FilePathName);
FileStream Fs = new FileStream(FilePathName, FileMode.Create);
BinaryWriter BWriter= new BinaryWriter(Fs,System.Text.Encoding.Default);
//将DataGrid的信息写入Excel文件
BWriter.Write(HtmlInfo);
BWriter.Close();
Fs.Close();excel:如下
第一行:輬
第二行:任务单单号 任务单运费 工作单单号 承运商 发货城市
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
dgExport.RenderControl(oHtmlTextWriter);
string HtmlInfo = oStringWriter.ToString().Trim();
string DocFileName = "JobOrder"+DateTime.Now.ToFileTime()+".xls";
string FilePathName = Server.MapPath("upload");
//得到Excel文件的物理地址
FilePathName = FilePathName +"\\" + DocFileName; System.IO.File.Delete(FilePathName);
FileStream Fs = new FileStream(FilePathName, FileMode.Create);
BinaryWriter BWriter= new BinaryWriter(Fs,System.Text.Encoding.Default);
//将DataGrid的信息写入Excel文件
BWriter.Write(HtmlInfo);
BWriter.Close();
Fs.Close();excel:如下
第一行:輬
第二行:任务单单号 任务单运费 工作单单号 承运商 发货城市
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货