c#保存DataGridView中表格为csv（自用）

²⁰²¹40

已于 2024-05-31 16:41:29 修改

阅读量579

点赞数 5

文章标签： c#

于 2024-05-31 16:26:26 首次发布

本文链接：https://blog.youkuaiyun.com/qq_62693717/article/details/139356012

版权

public void tablesave(DataGridView dataGridView1)
{

    string path = "";
    FolderBrowserDialog fdg = new FolderBrowserDialog();
    fdg.Description = "请选择文件路径";

    try
    {
        if (fdg.ShowDialog() == DialogResult.OK)
        {
            path = fdg.SelectedPath + "\\正算表格.csv";

        }
        else
        {
            throw new Exception();
        }

        using (StreamWriter sw = new StreamWriter(path))
        {
            sw.WriteLine(string.Join(",", dataGridView1.Columns.Cast<DataGridViewColumn>()
                                             .Select(x => x.HeaderText)));

            foreach (DataGridViewRow row in dataGridView1.Rows)
            {
                sw.WriteLine(string.Join(",", row.Cells.Cast<DataGridViewCell>()
                                            .Select(x => x.Value)));
            }
        }
    }
    catch(Exception)
    {

    }
}