代码笔记:
public void Export2Excel()
{
if (this.GridView_logData.Rows.Count > 0)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.DefaultExt = "xls";
saveFileDialog.Filter = "Excel文件(*.xls)|*.xls";
saveFileDialog.FileName = "log的查询结果" + DateTime.Now.ToString("yyyy-MM-dd-hh-mm-ss");
saveFileDialog.RestoreDirectory = true;
saveFileDialog.Title = "导出到EXCEL";
saveFileDialog.ShowDialog();
if (saveFileDialog.FileName == "")
{
return;
}
Stream myStream;
myStream = saveFileDialog.OpenFile();
StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
StringBuilder sb = new StringBuilder();
try
{
//导出列标头
for (int i = 0; i < resultTable.Columns.Count; i++)
{
if (i > 0)
{
sb.Append("\t");
}
sb.Append(resultTable.Columns[i].ColumnName);
}
//输入Excle数据
foreach (DataRow row in resultTable.Rows)
{
sb.Append("\r\n");
for (int i = 0; i < resultTable.Columns.Count; i++)
{
if (i > 0)
{
sb.Append("\t");
}
sb.Append(row[i].ToString().Replace("\r\n", ""));
}
}
sw.Write(sb);
sw.Flush();
sw.Dispose();
MessageBox.Show("导出成功!","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
catch
{
MessageBox.Show("导出失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
sw.Close();
myStream.Close();
}
}
}