跳出路径选择框后将datatable中数据保存到用户指定路径:
private void ExportTableToExcel(DataTable dt, string FileName)
{
string title = "";
for (int i = 0; i < dt.Columns.Count; i++)
{
title += dt.Columns[i].ColumnName + ",";
}
title += "/n";
string content = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
string s = dt.Rows[i][j].ToString();
if (s.Trim() == " ")
{
s = "";
}
content += s + ",";
}
content += "/n";
}
string data = title + content;
Response.ClearHeaders();
string temp = string.Format("attachment;filename={0}", FileName);
Response.Charset = "gb2312";
Response.ContentEncoding = System.Text.Encoding.Default;
Response.AppendHeader("Content-disposition", temp);
Response.ContentType = "application/vnd.xls";
Response.Write(data);
Response.End();
}
直接将表格保存:
public static bool ExportCSV(GridView gv, string FileName)
{
if (gv.Rows.Count == 0)
{
return true;
}
string path = @"c:/SmsFile";
if (!System.IO.Directory.Exists(path))
{
System.IO.Directory.CreateDirectory(path);
}
FileName = path + "//" + FileName;
try
{
FileStream fs = new FileStream(FileName, FileMode.Create);
StreamWriter sw = new StreamWriter(fs, System.Text.Encoding.Unicode);
string title = "";
for (int i = 0; i < gv.Columns.Count; i++)
{
if (gv.Columns[i].Visible)
{
title = gv.Columns[i].HeaderText;
sw.Write(title);
sw.Write("/t");
}
}
sw.WriteLine("");
for (int i = 0; i < gv.Rows.Count; i++)
{
for (int j = 0; j < gv.Columns.Count; j++)
{
if (gv.Columns[j].Visible)
{
string s = gv.Rows[i].Cells[j].Text;
if (s.Trim() == " ")
{
s = "";
}
sw.Write(s);
sw.Write("/t");
}
}
sw.WriteLine("");
sw.Flush();
}
fs.Close();
return true;
}
catch
{
return false;
}
}
asp.net中gridview中数据保存为cvs格式,datatable中
最新推荐文章于 2024-08-07 15:27:33 发布