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) 檔案格式只能儲存使用中工作表中的儲存格所顯示的文本和數值。工作表中所有的資料行和字元都

將儲存。資料列以逗號分隔，每一行資料都以斷行符號符結束。如果儲存格中包含逗號，則該儲存格中的內容以雙

引號引起。