columncount; columi++) {
strb.Append(\
style=\\\<b>\ }
strb.Append(\ //写数据
for (int i = 0; i < dt.Rows.Count; i++) {
strb.Append(\style=\\\
for (int j = 0; j < dt.Columns.Count; j++)
{
strb.Append(\style=\\\dt.Rows[i][j].ToString() + \ }
strb.Append(\ } }
strb.Append(\ strb.Append(\
string ExcelFileName = fileName; //string ExcelFileName =
Path.Combine(page.Request.PhysicalApplicationPath, path+\
//报表文件存在则先删除 if (File.Exists(ExcelFileName)) {
File.Delete(ExcelFileName); }
StreamWriter writer = new StreamWriter(ExcelFileName, false);
writer.WriteLine(strb.ToString()); writer.Close();
//如果需下载则提示下载对话框 if (IsDown) {
DownloadExcelFile(page, ExcelFileName); } }
---------
/// <summary> /// web下提示下载 /// </summary>
/// <param name=\ /// <param name=\文件名，全路径</param>
public static void
DownloadExcelFile(System.Web.UI.Page page, string FileName) {
page.Response.Write(\ if (!System.IO.File.Exists(FileName)) {
MessageBox.ShowAndRedirect(page, \文件不存在！\ } else {
FileInfo f = new FileInfo(FileName); HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader(\n\
HttpContext.Current.Response.AddHeader(\f.Length.ToString());
HttpContext.Current.Response.AddHeader(\ncoding\
HttpContext.Current.Response.ContentType = \
HttpContext.Current.Response.WriteFile(f.FullName); HttpContext.Current.Response.End(); } }