WEB C#/VB 生成报表文件csv文件）

最新推荐文章于 2022-09-30 11:22:50 发布

dicongtuo4349

最新推荐文章于 2022-09-30 11:22:50 发布

阅读量130

点赞数

原文链接：http://www.cnblogs.com/huangjihua/archive/2011/01/20/4125196.html

版权

利用FileStream 和StreamWriter生成csv文件:

'利用生成csv文件实现Web自定义报表 public shared Function WriteCsv(ByVal dt As DataTable, ByVal strTitle As String, ByVal filename As String) As String Dim path As String = HttpContext.Current.Server.MapPath("~/csv/" & filename & ".csv") Dim fw As New FileStream(path, FileMode.CreateNew, FileAccess.Write) Dim sw As New StreamWriter(fw, Text.Encoding.Default) sw.WriteLine(strTitle) Dim strRow As String = "" For i As Integer = 0 To dt.Rows.Count For j As Integer = 0 To dt.Columns.Count strRow += dt.Rows(i)(j) + "," Next j sw.WriteLine(strRow.Substring(0, strRow.Length - 1)) strRow = "" Next i sw.Close() fw.Close() sw.Dispose() fw.Dispose() Return path end Function

转载于:https://www.cnblogs.com/huangjihua/archive/2011/01/20/4125196.html