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

第一篇：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();

}

}