|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
//author: walker
//date: 2014-01-07
//function: 将DataTable导出到csv文件
public
static
bool
datatableToCSV(DataTable dt,
string
pathFile)
{
string
strLine =
""
;
StreamWriter sw;
try
{
sw =
new
StreamWriter(pathFile,
false
, System.Text.Encoding.GetEncoding(-0));
//覆盖
//表头
for
(
int
i = 0; i < dt.Columns.Count; i++)
{
if
(i > 0)
strLine +=
","
;
strLine += dt.Columns[i].ColumnName;
}
strLine.Remove(strLine.Length - 1);
sw.WriteLine(strLine);
strLine =
""
;
//表的内容
for
(
int
j = 0; j < dt.Rows.Count; j++)
{
strLine =
""
;
int
colCount = dt.Columns.Count;
for
(
int
k = 0; k < colCount; k++)
{
if
(k > 0 && k < colCount)
strLine +=
","
;
if
(dt.Rows[j][k] ==
null
)
strLine +=
""
;
else
{
string
cell = dt.Rows[j][k].ToString().Trim();
//防止里面含有特殊符号
cell = cell.Replace(
"\""
,
"\"\""
);
cell =
"\""
+ cell +
"\""
;
strLine += cell;
}
}
sw.WriteLine(strLine);
}
sw.Close();
string
msg =
"数据被成功导出到："
+ pathFile;
Console.WriteLine(msg);
}
catch
(Exception ex)
{
string
msg =
"导出错误："
+ pathFile;
Console.WriteLine(msg);
return
false
;
}
return
true
;
}
|
相关阅读：
1、关于特殊符号和分隔符。
*** walker ***
本文转自walker snapshot博客51CTO博客，原文链接http://blog.51cto.com/walkerqt/1349301如需转载请自行联系原作者
RQSLT
