C#窗体实现导入Excel表格数据，实现窗体预览，保存

第一步， 窗体按钮点击事件

 /// <summary>
        /// 导入Excel表格按钮事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ButtonImportExcel_type_Click(object sender, EventArgs e)
        {
            //DataSet dataSet = new DataSet();

            //DataTable dt = OpenCSVData();
            //dataSet.Tables.Add(dt);
            //DataGridViewType.DataSource = dataSet.Tables[0];

            dsAllRecord.Tables.Add(RenderFromExcel());

            MessageBox.Show(dsAllRecord.Tables[0].Columns[1].ColumnName);
            int AllRecord = dsAllRecord.Tables[0].Rows.Count;//总记录数
           // MessageBox.Show("总记录数:" + AllRecord);
            int nowPage = Convert.ToInt32(this.TextBoxnowPage.Text.Trim());//当前页数
            int AllPage = AllRecord / 50;//总页数
            if (nowPage >= AllPage)
            {
                nowPage = AllPage;
            }
            Page(AllRecord, AllPage, nowPage, dsAllRecord);


           // DataGridViewType.DataSource=RenderFromExcel();
        }

第二步：实现读取导入表格的数据，需要引用NPOI.dl等下载链接： https://download.csdn.net/download/baidu_38995168/11856480

        /// <summary>
        /// 读取导入的Excel表格数据
        /// </summary>
        /// <returns></returns>
        static DataTable RenderFromExcel()
        {
            OpenFileDialog ofd = new OpenFileDialog();

            // ofd.Filter = "工作表|*.xlsx";