第一篇：C#導出生成excel文件的方法小結(xml,html方式)

C#導出生成excel文件的方法小結(xml,html方式)

///

///

生成報表的頁面，沒有傳null

///

數據表

///

報表標題，sheet1名

///

存盤文件名，全路徑

///

生成文件后是否提示下載,只有web下才有效

public static void CreateExcelByXml(System.Web.UI.Page page, DataTable dt, String TableTitle, string fileName, bool IsDown)

{

StringBuilder strb = new StringBuilder();

strb.Append(“

strb.Append(”xmlns:x=“urn:schemas-microsoft-com:office:excel”“);

strb.Append(”xmlns=“");

strb.Append(” “);

strb.Append(” “);

strb.Append(” “);

strb.Append(” “);

strb.Append(” “);

strb.Append(” “);

//設置工作表 sheet1的名稱

strb.Append(” “ + TableTitle + ” “);

strb.Append(” “);

strb.Append(” 285 “);

strb.Append(” “);

strb.Append(” “);

strb.Append(” “);

strb.Append(” 3 “);

strb.Append(” 1 “);

strb.Append(” “);

strb.Append(” “);

strb.Append(” False “);

strb.Append(” False “);

strb.Append(” False “);

strb.Append(” “);

strb.Append(” “);

strb.Append(” 6750 “);

strb.Append(” 10620 “);

strb.Append(” 480 “);

strb.Append(” 75 “);

strb.Append(” False “);

strb.Append(” False “);

strb.Append(” “);

strb.Append(” “);

strb.Append(”“);

strb.Append(” “);

strb.Append(”

//合格所有列并顯示標題

strb.Append(”

strb.Append(“

strb.Append(“

if(dt!= null)

{

//寫列標題

int columncount = dt.Columns.Count;

for(int columi = 0;columi < columncount;columi++)

{

strb.Append(“

}

strb.Append(“

//寫數據

for(int i = 0;i < dt.Rows.Count;i++)

{

strb.Append(“

for(int j = 0;j < dt.Columns.Count;j++)

{

strb.Append(“

}

strb.Append(“

}

}

strb.Append(“

strb.Append(“ ”);

string ExcelFileName = fileName;

//string ExcelFileName = Path.Combine(page.Request.PhysicalApplicationPath, path+“/guestData.xls”);

//報表文件存在則先刪除

if(File.Exists(ExcelFileName))

{

File.Delete(ExcelFileName);

}

StreamWriter writer = new StreamWriter(ExcelFileName, false);

writer.WriteLine(strb.ToString());

writer.Close();

//如果需下載則提示下載對話框

if(IsDown)

{

DownloadExcelFile(page, ExcelFileName);

}

}---------///

///

///

文件名，全路徑

public static void DownloadExcelFile(System.Web.UI.Page page, string FileName)

{

page.Response.Write(“path:” + FileName);

if(!System.IO.File.Exists(FileName))

{

MessageBox.ShowAndRedirect(page, “文件不存在！”, FileName);

}

else

{

FileInfo f = new FileInfo(FileName);

HttpContext.Current.Response.Clear();

HttpContext.Current.Response.AddHeader(“Content-Disposition”, “attachment;filename=” + f.Name);

HttpContext.Current.Response.AddHeader(“Content-Length”, f.Length.ToString());

HttpContext.Current.Response.AddHeader(“Content-Transfer-Encoding”, “binary”);

HttpContext.Current.Response.ContentType = “application/octet-stream”;

HttpContext.Current.Response.WriteFile(f.FullName);

HttpContext.Current.Response.End();

}

}