layouts/framework/FrameExcelView.xaml.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Windows;
using System.Windows.Controls;
using tablegen2.logic;

namespace tablegen2.layouts
{
    /// <summary>
    /// FrameExcelView.xaml 的交互逻辑
    /// </summary>
    public partial class FrameExcelView : UserControl
    {
        private TableExcelData data_;
        private string filePath_;

        public FrameExcelView()
        {
            InitializeComponent();
        }

        public void setFilePath(string filePath)
        {
            filePath_ = filePath;
        }

        public void refreshUIByTableExcelData(TableExcelData data)
        {
            data_ = data;

            DataTable dt = new DataTable();

            //columns
            foreach (var hdr in data.Headers)
            {
                dt.Columns.Add(new DataColumn(hdr.FieldName, typeof(string)));
            }

            //rows
            foreach (var row in data.Rows)
            {
                DataRow dr = dt.NewRow();
                for (int i = 0; i < data.Headers.Count; i++)
                {
                    var hdr = data.Headers[i];
                    dr[hdr.FieldName] = row.StrList[i];
                }
                dt.Rows.Add(dr);
            }

            dataGrid1.ItemsSource = dt.DefaultView;
        }

        public void updateDataFromDataGrid()
        {
            var dv = dataGrid1.ItemsSource as DataView;
            var dt = dv.Table;

            data_.Rows.Clear();