html怎么调用csv文件,HTML代码显示在CSV文件中

我们想要从数据创建一个CSV文件。它显示的是HTML标签。对于xlx文件，这个工作正常。

下面是代码。

Dim response As System.Web.HttpResponse = System.Web.HttpContext.Current.Response

response.Clear()

response.ClearHeaders()

response.Write("")

'Chose what type of file needed ie.e CSV /XLS

If _exportType = ExportTypeEnum.CSV Then

response.ContentType = "application/vnd.xls"

Else

response.ContentType = "application/vnd.xls"

End If

response.AddHeader("Content-Disposition", "attachment;filename=" & FileNameToExport)

Dim sw As System.IO.StringWriter = New StringWriter()

Dim htw As HtmlTextWriter = New HtmlTextWriter(sw)

Dim dg As DataGrid = New DataGrid()

Dim dv1 As DataView = data

dg.DataSource = dv1

dg.BorderStyle = BorderStyle.None

dg.DataBind()

dg.RenderControl(htw)

response.Write(sw.ToString())

response.End()

请建议为什么它不能用于CSV文件，尽管它适用于xls文件。

非常感谢提前