从ASP.NET打开含有CSV文本用Excel [英] Opening text containing CSV with Excel from ASP.NET
问题描述
我在转换旧的asp.net Intranet应用程序到.NET 4.5。有一个应该是打开包含CSV数据导入Excel字符串我有麻烦的部分。
无论我如何尝试做到这一点，由此产生的Excel文档中包含的网站，而不是我提供的文本的内容。
在一个额外的说明，我现在有一个web项目的ASPX，而公用事业/业务类位于另一个。我不知道这是否是问题的一部分。
请帮我出这个问题。
CSV示例：
字符串文本=\\年度\\，\\让\\，\\模式\\，\\长\\\\ n \\1997年\\，\\福特\\，\\E350 \\，\\2.34 \\\\ n \\2000 \\，\\水星\\，\\熟女\\，\\2.38 \\
code样品：</ STRONG>
私有静态无效OpenCsvFile（字符串文本，字符串名称）
{
VAR的HttpContext = HttpContext.Current;
httpContext.Response.Clear（）;
httpContext.Response.ContentType =应用程序/ vnd.ms-EXCEL;
httpContext.Response.Charset =;
httpContext.Response.AppendHeader（内容处置，附件;文件名=+名字+名为.csv）;
httpContext.Response.Write（文本）;
httpContext.Response.Flush（）;
httpContext.ApplicationInstance.CompleteRequest（）;
}
更新：生成的文件包含网站的内容，而不是CSV文本
＆LT;！DOCTYPE HTML PUBLIC - // W3C // DTD XHTML 1.0过渡// EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">
＆LT; HTML的xmlns =http://www.w3.org/1999/xhtml＆GT;
＆LT;头ID =头像1＆GT;
＆LT;标题＆GT;
我的网站
＆LT; /标题＆GT;
＆LT; META HTTP-EQUIV =Content-Type的CONTENT =text / html的;字符集= ISO-8859-1/＆GT;
＆LT;链接HREF =CSS / style.css文件类型=文/ CSS称号=网站的rel =stylesheet属性/＆GT;
＆LT; /头＆GT;
＆LT;身体GT;
＆LT;形式方法=邮报行动=Main.aspxID =form1的NAME =form1的＆GT;
＆LT;表格边框=0CELLSPACING =0的cellpadding =0ID =容器＆GT;
＆LT; TD类=标志的onclick =window.location的='Main.aspx';＆GT;
＆LT; DIV CLASS =logoDisplay＆GT;
＆LT; IMG SRC =图像/ logo.gifALT =WIDTH =280像素HEIGHT =67px/＆GT;
＆LT; / DIV＆GT;
＆LT; / TD＆GT;
...等
答案是重新启动您的计算机。
是的，它的工作，现在没有任何进一步的code的变化。我简直不敢相信我花了这么长时间试图让这个才能正常工作。
感谢您想帮助，蒂姆。
I'm converting an older asp.net intranet application over to .net 4.5. One of the parts I'm having trouble with is supposed to open a string containing CSV data into Excel.
No matter how I attempt to accomplish this, the resulting excel document contains the contents of the website rather than the text I supplied.
On an additional note, I currently have the aspx in a web project, while the utility/business classes reside in another. I don't know if that is part of the problem.
Please help me out with this issue.
CSV sample:
string text = "\"Year\", \"Make\", \"Model\", \"Length\"\n\"1997\", \"Ford\", \"E350\", \"2.34\"\n\"2000\", \"Mercury\", \"Cougar\", \"2.38\""
Code Sample:
private static void OpenCsvFile(string text, string name)
{
var httpContext = HttpContext.Current;
httpContext.Response.Clear();
httpContext.Response.ContentType = "application/vnd.ms-excel";
httpContext.Response.Charset = "";
httpContext.Response.AppendHeader("Content-Disposition", "attachment; filename=" + name + ".csv");
httpContext.Response.Write(text);
httpContext.Response.Flush();
httpContext.ApplicationInstance.CompleteRequest();
}
Update: The resulting file contains the website contents rather than the CSV text.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1">
<title>
"My WebSite"
</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="css/style.css" type="text/css" title="WebSite" rel="stylesheet" />
</head>
<body>
<form method="post" action="Main.aspx" id="form1" name="form1">
<table border="0" cellspacing="0" cellpadding="0" id="container">
<td class="logo" onclick="window.location='Main.aspx';">
<div class="logoDisplay">
<img src="images/logo.gif" alt="" width="280px" height="67px" />
</div>
</td>
... etc
The answer is to reboot your PC. Yes, it's working now without any further code changes. I just can't believe I spent so long trying to get this to work properly.
Thank you for trying to help, Tim.
这篇关于从ASP.NET打开含有CSV文本用Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
