SaveFileDialog save = new
SaveFileDialog();
save.Title
= "保存";
save.Filter = "Excel(*.xls)|*.xls|文本(*.txt)|*.txt";
string
path = string.Empty;
if
(save.ShowDialog() == DialogResult.OK)
{
path = save.FileName;
}
FileStream
fs = new FileStream(path, FileMode.OpenOrCreate);
StreamWriter sw = new StreamWriter(fs, Encoding.Default);
string
strLine = string.Empty;
//列标题
for (int i
= 0; i < dataGridView2.ColumnCount; i++)
{
strLine +=
dataGridView2.Columns[i].HeaderText + "\t";
}
sw.WriteLine(strLine);
for (int i
= 0; i < dataGridView2.Rows.Count; i++)
{
strLine = string.Empty;
for (int j = 0; j <
dataGridView2.ColumnCount; j++)
{
//如果单元格是空,设置一个空格
if
(dataGridView1.Rows[i].Cells[j].Value == null)
{
strLine = strLine + " "
+"\t";
}
else
{
strLine +=
dataGridView1.Rows[i].Cells[j].Value.ToString() +
Convert.ToChar(9);
}
}
sw.WriteLine(strLine);
}
sw.Close();
fs.Close();
MessageBox.Show("保存成功", "提示", MessageBoxButtons.OK,
MessageBoxIcon.Information);
加载中,请稍候......