public void RestoreData() { string resFD = tb_RestoreFolder.Text.Trim(); string resDataFile = tb_RestoreDataFile.Text.Trim(); if (!Directory.Exists(resFD)) { MessageBox.Show("文件夹不存在。"); return; } if (!File.Exists(resDataFile)) { MessageBox.Show("数据文件不存在。"); return; } if (StaticValues.ExcelOperator == null) { ExcelOperator eo = new ExcelOperator(this.ShowStatus); StaticValues.ExcelOperator = eo; } if (StaticValues.ExcelOperator.App == null) { ShowStatus("正在开启Excel..."); StaticValues.ExcelOperator.OpenApplication(); } StaticValues.ExcelOperator.RestoreBackData(resFD, resDataFile); ShowStatus("导回数据完成"); }
/// <summary> /// 合并实际方法 /// </summary> public void MergeIntoExcel() { string fdPath = tb_ExcelsFolderPath.Text.Trim(); if (!Directory.Exists(fdPath)) { MessageBox.Show("文件夹不存在..."); return; } string[] files = Directory.GetFiles(fdPath, "*", SearchOption.AllDirectories).Where(x => Regex.IsMatch(x.ToLower(), @".*?\.xls|.*?\.xlsx")).ToArray(); if (files.Length <= 0) { MessageBox.Show("文件夹内没有 excel 文件"); return; } if (StaticValues.ExcelOperator == null) { ExcelOperator eo = new ExcelOperator(this.ShowStatus); StaticValues.ExcelOperator = eo; } if (StaticValues.ExcelOperator.App == null) { StaticValues.ExcelOperator.OpenApplication(); } string mainFile = Path.Combine(fdPath, "_Merged.xlsx"); string diffFile = Path.Combine(fdPath, "_Report_DiffernetFont.xlsx"); StaticValues.ExcelOperator.MergeIntoMainExcel(mainFile, files, string.IsNullOrEmpty(tb_PosInfo.Text.Trim()) ? "" : tb_PosInfo.Text.Trim(), cb_GenerateDifferFont.Checked?diffFile:""); }