jiang_jiajia10漂亮姐姐帮帮我

[wokan_woxihuan]

直接从数据库查询数据导出到ＥＸＣＥＬ和．ＣＳＶ文件
编码如：２００８０００００００１变成科学记数法
供应商编号：００００１变成1
我现在在他们前面加了＂'＂,可这样不利于数据再导入
帮帮忙漂亮，姐姐，我代码如下：
SqlConnection conn = new SqlConnection(Session["conString"].ToString());
SqlDataAdapter da = new SqlDataAdapter(Session["sql"].ToString(), conn);
DataSet ds = new DataSet();
da.Fill(ds, "table1");
DataTable dt = ds.Tables["table1"];
//存放到web.config中downloadurl指定的路径，文件格式为当前日期+4位随机数
string name = System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["downloadurl"]) + DateTime.Today.ToString("yyyyMMdd") + new Random(DateTime.Now.Millisecond).Next(10000).ToString();
if (this.drotype.SelectedIndex == 1)
{
name = name + ".xls";
}
if (this.drotype.SelectedIndex == 2)
{
name = name + ".csv";
}

FileStream fs = new FileStream(name, FileMode.Create, FileAccess.Write);
StreamWriter sw = new StreamWriter(fs, System.Text.Encoding.GetEncoding("gb2312"));
if (this.drotype.SelectedIndex == 1)
{
sw.WriteLine("报价单号\t供应商编号\t供应商名称\t编号\t商品条码\t商品名称\t单位\t规格\t包装\t供货价\t建议售价\t创建日期\t审核日期\t单据属性\t备注");
foreach (DataRow dr in dt.Rows)
{
sw.WriteLine(" '" + dr["id"].ToString() + "\t" + " '" + dr["vendorid"].ToString() + "\t" + dr["vendorname"].ToString() + "\t" + dr["no"].ToString() + "\t" + " '" + dr["barcode"].ToString() + "\t" + dr["comname"].ToString() + "\t" + dr["unit"].ToString() + "\t" + dr["standards"].ToString() + "\t" + dr["package"].ToString() + "\t" + dr["price"].ToString() + "\t" + dr["saleprice"].ToString() + "\t" + " " + dr["createdate"].ToString() + "\t" + " " + dr["makedate"].ToString() + "\t" + dr["flag"].ToString() + "\t" + dr["remark"].ToString());
}
}

if (this.drotype.SelectedIndex == 2)
{
sw.WriteLine("报价单号,供应商编号,供应商名称,编号,商品条码,商品名称,单位,规格,包装,供货价,建议售价,创建日期,审核日期,单据属性,备注");
foreach (DataRow dr in dt.Rows)
{
sw.WriteLine(" '" + dr["id"].ToString() + "," + " '" + dr["vendorid"].ToString() + "," + dr["vendorname"].ToString() + "," + dr["no"].ToString() + "," + " '" + dr["barcode"].ToString() + "," + dr["comname"].ToString() + "," + dr["unit"].ToString() + "," + dr["standards"].ToString() + "," + dr["package"].ToString() + "," + dr["price"].ToString() + "," + dr["saleprice"].ToString() + "," + " " + dr["createdate"].ToString() + "," + " " + dr["makedate"].ToString() + "," + dr["flag"].ToString() + "," + dr["remark"].ToString());
}
}
sw.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(name));
// 指定返回的是一个不能被客户端读取的流，必须被下载
Response.ContentType = "application/ms-excel";
// 把文件流发送到客户端
Response.WriteFile(name);
Response.End();

[clever_yang]

我上面的方法有给你解决科学记数法的问题的:
请注意: vnd.ms-excel.numberformat:@ 就是起这个作用的~...

[sjt000]

[Quote=引用 6 楼 zxy98 的回复:]
把excel对应列设置为文本格式，就没问题了
[/Quote]
同意

[kingcsx666]

没看到美女过来啊

[空心兜兜]

关注下

[wangping_li]

你可以导出前设置：
文本：vnd.ms-excel.numberformat:@
日期：vnd.ms-excel.numberformat:yyyy/mm/dd
数字：vnd.ms-excel.numberformat:#,##0.00
货币：vnd.ms-excel.numberformat:￥#,##0.00
百分比：vnd.ms-excel.numberformat: #0.00%

这里有一个孟老大给的例子，可以参考下：

http://dotnet.aspx.cc/article/8a4cbf47-b888-4832-3389-ed3a3a3c8aab/read.aspx

[wangping_li]

上面的格式你根据实际情况来设定的,并不是全部都要

[lovehongyun]

我来看漂亮佳佳的

[igelf]

冲漂亮姐姐来的..

[wuyq11]

用com组件
Excel.Range r1;
r1=yourexcel.get_Range(myexcel.Cells[i,n],myexcel.Cells[j,n]);
r1.NumberFormatLocal= "@";

参考
http://www.cnblogs.com/codingsilence/articles/1133003.html

[zjybushiren88888]

帮顶个， 吼吼

[dd__dd]

漂亮姐姐没来啊，哈哈

[sxmonsy]

漂亮姐姐在哪

[lanxingxing]

楼上是个漂亮姐姐

[jiang_jiajia10]

[Quote=引用 13 楼 wangping_li 的回复:]
你可以导出前设置：
文本：vnd.ms-excel.numberformat:@
日期：vnd.ms-excel.numberformat:yyyy/mm/dd
数字：vnd.ms-excel.numberformat:#,##0.00
货币：vnd.ms-excel.numberformat:￥#,##0.00
百分比：vnd.ms-excel.numberformat: #0.00%

这里有一个孟老大给的例子，可以参考下：

http://dotnet.aspx.cc/article/8a4cbf47-b888-4832-3389-ed3a3a3c8aab/read.aspx
[/Quote]
说的挺好啊。你照着看看

[gongsun]

这称呼叫的太恶心...

[Jinglecat]

foreach (DataRow dr in dt.Rows)
{
sw.WriteLine(" '" + Convert.ToInt64(dr["id"]).ToString("E") + "," + " '" + Convert.ToInt32(dr["vendorid"]).ToString() + "," + dr["vendorname"].ToString() + "," + dr["no"].ToString() + "," + " '" + dr["barcode"].ToString() + "," + dr["comname"].ToString() + "," + dr["unit"].ToString() + "," + dr["standards"].ToString() + "," + dr["package"].ToString() + "," + dr["price"].ToString() + "," + dr["saleprice"].ToString() + "," + " " + dr["createdate"].ToString() + "," + " " + dr["makedate"].ToString() + "," + dr["flag"].ToString() + "," + dr["remark"].ToString());
}

[lxl_sports]

嘿嘿~~！！！
顶顶更健康。。。
jiajia 你是man or woman？？？？


我感觉应该是佳佳哥哥或者弟弟吧 ^_^。。。

[jhdxhj]

这个漂亮姐姐是个男的好不好！！

[jiang_jiajia10]

LS2位，明确告诉你本人现在是女性。这号三个人在上。你们以后的帖子不会回了哦。你们也用不着我回能力都那么强。

[lovehongyun]

[Quote=引用 27 楼 jiang_jiajia10 的回复:]
LS2位，明确告诉你本人现在是女性。这号三个人在上。你们以后的帖子不会回了哦。你们也用不着我回能力都那么强。
[/Quote]