WPF实现将表格控件中的数据导出为CSV文件或其他文件类型以及将再文件导入的方法

该示例主要以WPF导出DataGrid控件中数据源为CSV文件以及将CSV文件再导入的方法编写，如果需要导出为其他类型请自行在代码中更改导出类型，具体实现可根据代码注释查找，导入/导出都有详细注释：
示例图片：

.Cs示例代码如下：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using System.Data;
using System.IO;
using Microsoft.Win32;

namespace WpfApp1
{
    /// <summary>
    /// MainWindow.xaml 的交互逻辑
    /// </summary>
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();

            // 创建数据源
            List<DataModel> data = new List<DataModel>
            {
               // 自己随机添加的每一行数据，数据源根据实际情况自行绑定
            new DataModel { Column1 = "1", Column2 = "2", Column3 = "3" },
            new DataModel { Column1 = "4", Column2 = "5", Column3 = "6" },
            new DataModel { Column1 = "Value4", Column2 = "Value5", Column3 = "Value6" },
            new DataModel { Column1 = "Value4", Column2 = "Value5", Column3 = "Value6" },
            new DataModel { Column1 = "4", Column2 = "5", Column3 = "6" },
            // 可根据需要添加更多数据项
             };

            // 将数据源绑定到表格控件
            DataTable.ItemsSource = data;
        }

        #region 导出文件相关代码

        //建立导出按钮事件
        private void ExportButton_Click(object sender, RoutedEventArgs e)
        {
            SaveFileDialog saveFileDialog = new SaveFileDialog();
            saveFileDialog.Filter = "CSV Files (*.csv)|*.csv";   //确定导出的文件类型，类型可根据需要自行定义
            if (saveFileDialog.ShowDialog() == true)   //弹出通用对话框
            {
                ExportToCsv(saveFileDialog.FileName, DataTable); // DataTable为你的表格控件数据源
            }
        }

        private void ExportToCsv(string filePath, DataGrid dataGrid)
        {
            StringBuilder sb = new StringBuilder();

            // 获取所有列的列名
            List<string> columnNames = new List<string>();
            foreach (DataGridColumn column in dataGrid.Columns)
            {
                columnNames.Add(column.Header.ToString());
            }
            sb.AppendLine(string.Join(",", columnNames));

            // 获取所有行的数据
            foreach (var item in dataGrid.ItemsSource)
            {
                DataGridRow row = (DataGridRow)dataGrid.ItemContainerGenerator.ContainerFromItem(item);

                List<string> cellValues = new List<string>();
                foreach (DataGridColumn column in dataGrid.Columns)
                {
                    // 获取cell的元素
                    FrameworkElement element = column.GetCellContent(item);  
                    if (element is TextBlock text) // TextBlock控件类型
                    {
                        cellValues.Add(text.Text);
                    }
                    else if (element is CheckBox checkBox)  //CheckBox控件类型
                    {
                        cellValues.Add(checkBox.IsChecked.ToString());
                    }
                    else if (element is TextBox textBox)  //TextBox控件类型
                    {
                        cellValues.Add(textBox.Text.ToString());
                    }
                    // 其他控件类型的处理类似
                }

                sb.AppendLine(string.Join(",", cellValues));
            }

            File.WriteAllText(filePath, sb.ToString());  //创建文件
            MessageBox.Show("导出成功！");
        }

        #endregion


        #region 导入文件相关代码

        private List<DataModel> data; // 数据源

        private void ImportButton_Click(object sender, RoutedEventArgs e)
        {
            OpenFileDialog openFileDialog = new OpenFileDialog();
            openFileDialog.Filter = "CSV Files (*.csv)|*.csv|All Files (*.*)|*.*";  //确定导入的文件类型，类型可根据需要自行定义
            if (openFileDialog.ShowDialog() == true)
            {
                string filePath = openFileDialog.FileName;
                ReadCSVFile(filePath);
            }
        }

        private void ReadCSVFile(string filePath)
        {
            List<DataModel> importedData = new List<DataModel>();  //创建表存放数据

            using (StreamReader reader = new StreamReader(filePath))
            {
                // 跳过第一个列名行
                reader.ReadLine();

                string line;
                while ((line = reader.ReadLine()) != null)  //读取每一行的值
                {
                    string[] values = line.Split(',');

                    if (values.Length >= 3) // CSV文件至少包含3列，根据数据源实际情况设定
                    {
                        DataModel item = new DataModel
                        {
                            Column1 = values[0],
                            Column2 = values[1],
                            Column3 = values[2]
                        };
                        importedData.Add(item);
                    }
                }
            }

            // 更新数据源
            data = importedData;

            // 刷新表格控件
            DataTable.ItemsSource = data;
        }

        #endregion
    }

    // 自定义数据模型
    public class DataModel
    {
        public string Column1 { get; set; }
        public string Column2 { get; set; }
        public string Column3 { get; set; }
    }
}

Xaml示例界面代码如下：

<Window x:Class="WpfApp1.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
        xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
        xmlns:local="clr-namespace:WpfApp1"
        mc:Ignorable="d"
        Title="MainWindow" Height="400" Width="400">
    <Grid>
        <Grid.RowDefinitions>
            <RowDefinition Height="Auto"/>
            <RowDefinition Height="*"/>
        </Grid.RowDefinitions>
        
        <!--导出按钮-->
        <Button Grid.Row="0" HorizontalAlignment="Left" Margin="10" VerticalAlignment="Center" 
                Content="导出" Click="ExportButton_Click"/>

        <!--导入按钮-->
        <Button Grid.Row="0" HorizontalAlignment="Left" Margin="80,10,0,10" VerticalAlignment="Center" 
                Content="导入" Click="ImportButton_Click"/>

        <DataGrid Grid.Row="1" x:Name="DataTable" Margin="10" AutoGenerateColumns="False">
            <!--当AutoGenerateColumns="true"时会双倍显示6个列-->
            
            <!-- 定义表格的列 -->
            <DataGrid.Columns>
                <DataGridTextColumn Header="列1" Binding="{Binding Column1}"/>
                <DataGridTextColumn Header="列2" Binding="{Binding Column2}"/>
                <DataGridTextColumn Header="列3" Binding="{Binding Column3}"/>
                <!-- 可以根据实际需要添加更多的列 -->
            </DataGrid.Columns>
        </DataGrid>
    </Grid>
</Window>

作者：freesheep720