????ASP.NET??????????????

???????????? ???????[ 2012/7/13 10:46:10 ] ????????

????//??棺?????????

PrintClass myP = new PrintClass();
Response.Write(myP.DGPrint(Bind());

???????DataGrid?????????HTML?????????????????л?????e?????????????????????????С???????????????????????????????????????????

??????????Excel??Word??????

?????? ???????????????????С?

?????? ????????????????????????????????á?

?????? ???????????????????????????Word??Excel????????????????

????????????IE??????????????????

???????????￡?

protected void btnMIME_Click(object sender?? System.EventArgs e)
{
     BindData();

     Response.ContentType = "application/vnd.ms-excel";
     Response.AddHeader("Content-Disposition"?? "inline;filename="+HttpUtility.UrlEncode("???????.xls"??Encoding.UTF8));

     //???????Word?????????′???
     //Response.ContentType = "application/ms-word"
     //Response.AddHeader("Content-Disposition"?? "inline;filename=test.doc")
     StringBuilder sb=new StringBuilder();
     System.IO.StringWriter sw = new System.IO.StringWriter(sb);
     System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
     sb.Append("<html><body>");
     dgShow.RenderControl(hw);
     sb.Append("</body></html>");
     Response.Write(sb.ToString());
     Response.End();
}

protected void btnCom_Click(object sender?? System.EventArgs e)
{
     ExportToExcel(BindData()??Server.MapPath("ComExcel.xls"));

}
//??DataSet??????Excel
#region??DataSet??????Excel
///?????????Excel???
public void ExportToExcel(DataSet ds??string strExcelFileName)
{
     if (ds.Tables.Count==0 || strExcelFileName=="") return;
     doExport(ds??strExcelFileName);
}
///??е???
private void doExport(DataSet ds??string strExcelFileName)
{
     excel.Application excel= new excel.Application();
     int rowIndex=1;
     int colIndex=0;
     excel.Application.Workbooks.Add(true);
     System.Data.DataTable table=ds.Tables[0] ;
     foreach(DataColumn col in table.Columns)
     {
         colIndex++;
         excel.Cells[1??colIndex]=col.ColumnName;
     }

     foreach(DataRow row in table.Rows)
     {
         rowIndex++;
         colIndex=0;
         foreach(DataColumn col in table.Columns)
         {
              colIndex++;
              excel.Cells[rowIndex??colIndex]=row[col.ColumnName].ToString();
         }
     }
     excel.Visible=false;
     excel.ActiveWorkbook.SaveAs(strExcelFileName+".XLS"??Excel.XlFileFormat.xlExcel9795??null??null??false??false??Excel.XlSaveAsAccessMode.xlNoChange??null??null??null??null??null);
     excel.Quit();
     excel=null;
     GC.Collect();//????????
}
#endregion