asp.net 保存xls 格式

OracleConnection conn = new OracleConnection(strsql.ConnectionString);

 DataTable dt = querysql(sql, conn); Response.Clear();

 Response.BufferOutput = true; Response.ContentType = "application/x-msexcel";//设置文件类型为excel

Response.Charset = "GB2312";//设置类型为中文防止乱码的出现

Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文

 Response.AppendHeader("content-disposition", "attachment;filename=CUSTPARAQuery.xls"); Response.Cache.SetCacheability(HttpCacheability.NoCache);

Response.Cache.SetNoStore(); Response.Cache.SetExpires(DateTime.Now);

string sTemp = ""; sTemp += "\"SITE\"\t";

sTemp += "\"RT_DATE\"\t"; sTemp += "\"RT_NO\"\t";

 sTemp += "\"RT_SEQ\"\t"; sTemp += "\"PART_NO\"\t";

sTemp += "\"RT_QTY \"\t"; sTemp += "\"UNIT_PRICE\"\t";

 sTemp += "\"VENDOR\"\t"; sTemp += "\" CURRENCY\"\t";

sTemp += "\"UNIT\"\t"; sTemp += "\"PO_NO\"\t";

sTemp += "\"PO_SEQ\"\t"; sTemp += "\"MTL_CATEGORY\"\t";

 sTemp += "\"NEW_PART\"\t"; sTemp += "\"SITE_UID\"\t";

sTemp += "\"NEW_VENDOR \"\t";

sTemp += "\"PART_DESC\"\t";

sTemp += "\"PO_BADGENO \"\t";

sTemp += "\n";

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

{ sTemp += "\"" + dt.Rows[i]["SITE"].ToString() + "\"\t";

 sTemp += "\"" + dt.Rows[i]["RT_DATE"].ToString() + "\"\t";

sTemp += "\"" + dt.Rows[i]["RT_NO"].ToString() + "\"\t";

sTemp += "\"" + dt.Rows[i]["RT_SEQ"].ToString() + "\"\t";

sTemp += "\"" + dt.Rows[i]["PART_NO"].ToString() + "\"\t";

 sTemp += "\"" + dt.Rows[i]["RT_QTY"].ToString() + "\"\t";

sTemp += "\"" + dt.Rows[i]["UNIT_PRICE"].ToString() + "\"\t";

 sTemp += "\"" + dt.Rows[i]["VENDOR"].ToString() + "\"\t";

sTemp += "\"" + dt.Rows[i]["CURRENCY"].ToString() + "\"\t";

sTemp += "\"" + dt.Rows[i]["UNIT"].ToString() + "\"\t";

sTemp += "\"" + dt.Rows[i]["PO_NO"].ToString() + "\"\t";

 sTemp += "\"" + dt.Rows[i]["PO_SEQ"].ToString() + "\"\t";

sTemp += "\"" + dt.Rows[i]["MTL_CATEGORY"].ToString() + "\"\t";

 sTemp += "\"" + dt.Rows[i]["NEW_PART"].ToString() + "\"\t";

sTemp += "\"" + dt.Rows[i]["SITE_UID"].ToString() + "\"\t";

sTemp += "\"" + dt.Rows[i]["NEW_VENDOR"].ToString() + "\"\t";

 sTemp += "\"" + dt.Rows[i]["PART_DESC"].ToString() + "\"\t";

sTemp += "\"" + dt.Rows[i]["PO_BADGENO"].ToString() + "\"\t";

 sTemp += "\n"; Response.Write(sTemp); sTemp = "";

 } Response.End(); }

 

 

 

若要保存成csv 格式，将filename=CUSTPARAQuery.xls 改成CUSTPARAQuery.csv ，将"\t" 改成"\,"

csv格式的文件是一种文本文件，只能保存字符和数字，而不能保存字符格式、对象、宏之类的东东,

CSV (*.csv) 文件格式只能保存活动工作表中的单元格所显示的文本和数值。工作表中所有的数据行和字符都

将保存。数据列以逗号分隔，每一行数据都以回车符结束。如果单元格中包含逗号，则该单元格中的内容以双

引号引起。