如何将文件输出流写进Excel模板呢？
我想把数据从sql中导出（asp.net）成excel文件，是以下面这种形式：
if (dt.Rows.Count > 0)
{

System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
///输出文件名
System.Web.HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + strFileName.Trim() + ".xls");
string colHeaders = "", ls_item = "";

string n = "";
string[] name = new string[dt.Columns.Count];
//根据字段名录入标题
for (int i = 0; i < dt.Columns.Count; i++)
{
n = dt.Columns[i].ColumnName.ToString();
name[i] = n.Trim();
if (i == dt.Columns.Count - 1)
{
colHeaders = n + "\n";
}
else
{ colHeaders = n + "\t"; }

System.Web.HttpContext.Current.Response.Write(colHeaders);
}

///循环输出该标题下的项目
for (int j = 0; j < dt.Rows.Count; j++)
{

for (int k = 0; k < name.Length; k++)
{
if (k == name.Length - 1)
{
ls_item += "" + dt.Rows[j][name[k].Trim()].ToString() + "\t\n";
}
else
{
ls_item += "" + dt.Rows[j][name[k].Trim()].ToString() + "\t";
}
}
System.Web.HttpContext.Current.Response.Write(ls_item);
ls_item = "";
}
System.Web.HttpContext.Current.Response.ContentType = "application/octet-stream";
System.Web.HttpContext.Current.Response.End();
}
dt.Clear();
dt.Dispose();
}
怎么才能吧他们写到一个制定格式的excel模板中去呢
急用！！！！！！！！

[解决办法]
告诉你一个笨方法,先在后台按照格式生成表格,然后再导出到EXCEL;


Response.Clear();
Response.Write(str);//str是生成表格的字符串
Response.ContentType = "application/vnd.ms-Excel";
Response.AddHeader("Content-Disposition", "inline;filename=Plan.xls");
Response.End();