http://www.cnblogs.com/lovecherry/archive/2005/03/25/125519.html?Pending=true#Post
StringWriter sw=new StringWriter();
sw.WriteLine("自动编号,姓名,年龄");
foreach(DataRow dr in dt.Rows)
{
sw.WriteLine(dr["ID"]+","+dr["vName"]+","+dr["iAge"]);
}
sw.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=test.csv");
Response.ContentType = "application/ms-excel";
Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");
Response.Write(sw);
Response.End();
我用这个方法写了excel,显示很好,可是我需要把我写的excel再导入别的程序执行,可是导入后结果就为空值了,而用原来的asp里实现的
Dim xls, ws, es , MYear, MMonth, MDay, fs, i
Set xls = Server.CreateObject("Excel.Application")
Set fs = server.CreateObject("scripting.filesystemobject")
Set ws = xls.Workbooks.Add
Set es = ws.ActiveSheet
insert "","","","",""
insert MYear & "年" & MMonth & "月" & MDay &"日","","","","" 就可以导入生成数据,我发现的就存储的格式不一样,.net里要怎么处理才能是excel原来的格式呢
StringWriter sw=new StringWriter();
sw.WriteLine("自动编号,姓名,年龄");
foreach(DataRow dr in dt.Rows)
{
sw.WriteLine(dr["ID"]+","+dr["vName"]+","+dr["iAge"]);
}
sw.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=test.csv");
Response.ContentType = "application/ms-excel";
Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");
Response.Write(sw);
Response.End();
我用这个方法写了excel,显示很好,可是我需要把我写的excel再导入别的程序执行,可是导入后结果就为空值了,而用原来的asp里实现的
Dim xls, ws, es , MYear, MMonth, MDay, fs, i
Set xls = Server.CreateObject("Excel.Application")
Set fs = server.CreateObject("scripting.filesystemobject")
Set ws = xls.Workbooks.Add
Set es = ws.ActiveSheet
insert "","","","",""
insert MYear & "年" & MMonth & "月" & MDay &"日","","","","" 就可以导入生成数据,我发现的就存储的格式不一样,.net里要怎么处理才能是excel原来的格式呢
你里边也不带有非用EXCLE的功能!
如果你想用它来导入导出数据的话,EXCLE和TXT有区别么?
sw.WriteLine("自动编号\t姓名\t年龄");
foreach(DataRow dr in dt.Rows)
{
sw.WriteLine(dr["ID"]+"\t"+dr["vName"]+"\t"+dr["iAge"]);
}
另外,修改输出的文件扩展名为xls即可。