dataset导出excel格式遇到的问题
我想把查询出来的dataset的数据用IO流导出成excel格式,代码如下public void dataTableToCsv(DataTable table, string file)
{
string title = "";
FileStream fs = new FileStream(file, FileMode.OpenOrCreate);
//FileStream fs1 = File.Open(file, FileMode.Open, FileAccess.Read);
StreamWriter sw = new StreamWriter(new BufferedStream(fs), System.Text.Encoding.Default);
for (int i = 0; i < table.Columns.Count; i++)
{
title += table.Columns[i].ColumnName + "\t"; //栏位:自动跳到下一单元格
}
title = title.Substring(0, title.Length - 1) + "\n";
sw.Write(title);
foreach (DataRow row in table.Rows)
{
string line = "";
for (int i = 0; i < table.Columns.Count; i++)
{
line += row[i].ToString().Trim() + "\t"; //内容:自动跳到下一单元格
}
line = line.Substring(0, line.Length - 1) + "\n";
sw.Write(line);
}
sw.Close();
fs.Close();
}
导出之后遇到一个问题,如果数字类型的太大的话,在excel中就变成了科学计数法,请问这个怎么解决啊?? --------------------编程问答-------------------- 转为字符串写入,可加= "'" + ...... --------------------编程问答-------------------- 楼上方式可行。
补充:.NET技术 , C#