導出數據到Excel.

private void ExportToExcel()
{
string strExlAddr = ConfigurationSettings.AppSettings["ExlAddress"].Trim();
StringBuilder sb = new StringBuilder();
sb.Append("<Script Language=VBScript>");
sb.Append("<!--\r\n");
sb.Append("dim xls\r\n");
sb.Append("Set xls=CreateObject(\"Excel.Application\")\r\n");
sb.Append("xls.WorkBooks.Open(\"" + strExlAddr + "ContractorDocument.xls\")\r\n");
sb.Append("xls.visible=true\r\n");
sb.Append("xls.Sheets(1).Select\r\n");
DataTable dtContractorDocument = contractorDocument.DTContractorDocumentByFieldAndValue(this.ddlSearchType.SelectedValue.Trim(),this.tbSearchKeyWord.Text.Trim());
DataRow[] drs = dtContractorDocument.Select("valid=true");
for(int i=0;i<drs.Length;i++)
{
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",1)=\"" + drs[i]["companyname"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",2)=\"" + drs[i]["address"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",3)=\"" + drs[i]["postcode"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",4)=\"" + drs[i]["comptel"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",5)=\"" + drs[i]["fax"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",6)=\"" + drs[i]["found_year"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\" \r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",7)=\"" + drs[i]["capital"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + " \" \r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",8)=\"" + drs[i]["businesslicenceno"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",9)=\"" + drs[i]["ownership"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",10)=\"" + drs[i]["registerdept"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",11)=\"" + drs[i]["designqua"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",12)=\"" + drs[i]["designno"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",13)=\"" + drs[i]["designdept"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",14)=\"" + drs[i]["confixqua"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",15)=\"" + drs[i]["confixno"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",16)=\"" + drs[i]["confixdept"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",17)=\"" + drs[i]["tradequa"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",18)=\"" + drs[i]["tradeno"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",19)=\"" + drs[i]["tradedept"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",20)=\"" + drs[i]["producequa"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",21)=\"" + drs[i]["produceno"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",22)=\"" + drs[i]["producedept"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",23)=\"" + drs[i]["businessscope"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",24)=\"" + drs[i]["legalrepre"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",25)=\"" + drs[i]["repretel"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",26)=\"" + drs[i]["legaldelegate"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",27)=\"" + drs[i]["delegatetel"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",28)=\"" + drs[i]["prjmanager"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",29)=\"" + drs[i]["managertel"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",30)=\"" + drs[i]["email"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",31)=\"" + drs[i]["taxno"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",32)=\"" + drs[i]["taxtype"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",33)=\"" + drs[i]["taxdept"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",34)=\"" + drs[i]["isoqua"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
//與該公司開始合作年份（與PM_PlanOut表聯合查詢得出）
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",35)=\"" + drs[i]["cooperatestartyear"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",36)=\"" + drs[i]["cooperateproject"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n");
sb.Append("xls.Sheets(1).Cells(" +( i+3) + ",37)=\"" + drs[i]["badrecord"].ToString().Replace("\"", "'").Trim().Replace("\r\n","") + "\"\r\n"); }
sb.Append("Set xls=nothing\r\n");
sb.Append("-->\r\n");
sb.Append("</script>");
Page.RegisterClientScriptBlock("", sb.ToString());
}