110,532
社区成员
发帖
与我相关
我的任务
分享
string delimiter = ",";
string outputFilename = "Robot";
string fullFilename = Path.Combine("D:\\11",outputFilename);//路径的选择
StreamWriter csvStreamWriter = new StreamWriter(fullFilename, false, System.Text.Encoding.UTF8);
//output header data
string strHeader = "";
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
strHeader += dataGridView1.Columns[i].HeaderText + delimiter;
}
csvStreamWriter.WriteLine(strHeader);
//output rows data
for (int j = 0; j < dataGridView1.Rows.Count; j++)
{
string strRowValue = "";
for (int k = 0; k < dataGridView1.Columns.Count; k++)
{
strRowValue += dataGridView1.Rows[j].Cells[k].Value + delimiter;
}
csvStreamWriter.WriteLine(strRowValue);
}
csvStreamWriter.Close();
var lines = dataGridView1.Rows.OfType<DataGridViewRow>().Select(r => string.Join(",", r.Cells.OfType<DataGridViewCell>().Select(c => c.Value.ToString()).ToArray())).ToList();
lines.Insert(0, string.Join(",", dataGridView1.Columns.OfType<DataGridViewColumn>().Select(c => c.HeaderText).ToArray()));
File.WriteAllLines(outputFilename, lines.ToArray());