CSFrameworkV6旗舰版 - 导入导出Excel文件数据开发教程

        /// <summary>
        /// 初始化界面按钮
        /// </summary>
        public override void InitButtons()
        {
            base.InitButtons();

            if (this.ButtonAuthorized(ButtonAuthority.ADD))
            {
                var btnExportFile = this.ToolbarRegister.CreateButton(ButtonNameList.btnExportFile,
                      LanLib.Get("导出模版文件"), ToolBarGroup.数据操作, Globals.LoadBitmap("32_excel_template.png"), new Size(57, 28), false, true,
                      DoExportTemplate);
                var btnImportFile = this.ToolbarRegister.CreateButton(ButtonNameList.btnImportFile,
                    LanLib.Get("导入模版数据"), ToolBarGroup.数据操作, Globals.LoadBitmap("32_excel_import.png"), new Size(57, 28), false, true,
                    DoImportExcelData);

                //添加子按钮
                var btnOwner = _buttons.GetButtonByName(ButtonNameList.btnExportDataDict);//父级按钮：导入/导出按钮

                btnOwner.AddSubButton(btnExportFile);
                btnOwner.AddSubButton(btnImportFile);
            }
        }

        public virtual void DoExportTemplate(IButtonInfo sender)
        {
            var file = Path.Combine(Globals.ApplicationPath, @"excel_templates\语言资料模板.xlsx");
            if (File.Exists(file))
            {
                SaveFileDialog dlg = new SaveFileDialog();
                dlg.Filter = "Excel文件|*.xlsx";
                dlg.FileName = DateTime.Today.ToString("yyyyMMdd") + " - 语言资料模板.xlsx";
                if (dlg.ShowDialog() == DialogResult.OK)
                {
                    File.Copy(file, dlg.FileName, true);
                    if (File.Exists(dlg.FileName))
                        Msg.ShowInformation("导出模版文件成功！");
                    else
                        Msg.Warning("导出失败！");
                }
            }
            else
            {
                Msg.Warning("模版文件丢失(语言资料模板.xlsx)，请联系管理员！");
            }
        }

        public virtual void DoImportExcelData(IButtonInfo sender)
        {
            IImporterSource source = new ImporterDataSource_Excel_NPOI(typeof(ImportLanguageData_ExcelModel));
            IImporterTarget target = new ImportLanguageDataFromExcel();
            var count = frmImportExcel.ExecuteImporter(source, target);
            if (count > 0)
            {
                btnQuery.PerformClick();//刷新数据
            }
        }