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:"");
}
