CSV文件如何下载 [英] How CSV File Download

问题描述

你好先生
我正在使用以下代码下载.csv文件，但它将转换为XML文档(.xml)
当我将其ContentType设置为msexcel时，它会将我的数据存储在单列中

hello Sir
I am downloading a .csv file using following code but it''s convert into XML Document (.xml)
when i set it''s ContentType to msexcel it get my data in single column

Response.ClearHeaders();
        Response.ClearContent();
        Response.ContentType = Path.GetExtension(Path.GetFileName(path));
        Response.AddHeader("content-disposition", "attachment; filename=" + path);
        Response.WriteFile(path);

所以请告诉我我必须用来下载csv文件
谢谢

so plz tell me i have to use to download csv file
thank you

推荐答案

尝试使用此代码:

try to use this code:

Response.ClearHeaders();
Response.ClearContent();
Response.ContentType = "text/csv";
Response.AddHeader("content-disposition", "attachment; filename=" + Path.GetFileName(path));
Response.WriteFile(path)

这篇关于CSV文件如何下载的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！