c# excel

using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using System.Web;
namespace GetPCInformation
{
class Excel
{
public void ExportExcel(DataTable dt)
{
//设置导出文件路径
string path = HttpContext.Current.Server.MapPath("Export/");

//设置新建文件路径及名称
string savePath = path + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss") + ".xls";

//创建文件
FileStream file = new FileStream(savePath, FileMode.CreateNew, FileAccess.Write);

//以指定的字符编码向指定的流写入字符
StreamWriter sw = new StreamWriter(file, Encoding.GetEncoding("GB2312"));

StringBuilder strbu = new StringBuilder();

//写入标题
for (int i = 0; i < dt.Columns.Count; i++)
{
strbu.Append(dt.Columns[i].ColumnName.ToString() + "\t");
}
//加入换行字符串
strbu.Append(Environment.NewLine);

//写入内容
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
strbu.Append(dt.Rows[i][j].ToString() + "\t");
}
strbu.Append(Environment.NewLine);
}

sw.Write(strbu.ToString());
sw.Flush();
file.Flush();

sw.Close();
sw.Dispose();

file.Close();
file.Dispose();
}
}
}