private void button1_Click(object sender, EventArgs e)
{
SaveFileDialog save = new SaveFileDialog();
save.Filter = "Excel files (*.xls)|*.xls";
save.FileName = "管理系统咨询知识库";
save.FilterIndex = 0;
save.RestoreDirectory = true;//关闭对话框后返回之前的目录
save.CreatePrompt = false;//当目标地无该文件时,不提示是否保存
save.Title = "导出Excel文件到";//
save.ShowDialog();
Stream myStream;
myStream = save.OpenFile();
StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("utf-8"));
string str = "";
//写标题
for (int i = 0; i < listView1.Columns.Count; i++)
{
str += listView1.Columns[i].Text;
}
sw.WriteLine(str);
//写内容
foreach (ListViewItem item in listView1.Items)
{
string tempStr = "";
for (int j = 0; j < listView1.Columns.Count; j++)
{
tempStr += item.SubItems[j].Text.ToString();
}
sw.WriteLine(tempStr);
}
MessageBox.Show("导出成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
sw.Close();
myStream.Close();
}