public void Analyze()
{
MainTool maintool = new MainTool(MdbFilePath);
maintool.Doing();
Console.WriteLine("完成GYYD表数据合并生成....................");
MergeTool mergetool = new MergeTool(MdbFilePath);
mergetool.Working();
Console.WriteLine("完成GYYD_YDDW表数据合并生成...............");
ITool tool = null;
foreach (SheetEnum sheet in Enum.GetValues(typeof(SheetEnum)))
{
switch (sheet)
{
case SheetEnum.one:
tool = new ToolOne(MdbFilePath);
break;
case SheetEnum.two:
tool = new ToolTwo(MdbFilePath);
break;
case SheetEnum.three:
tool = new ToolThree(MdbFilePath);
break;
case SheetEnum.four:
tool = new ToolFour(MdbFilePath);
break;
case SheetEnum.five:
tool = new ToolFive(MdbFilePath);
break;
case SheetEnum.six:
tool = new ToolSix(MdbFilePath);
break;
}
Console.WriteLine(string.Format("开始对{0}数据生成工作", tool.GetSheetName()));
ISheet Bsheet = WorkBook.GetSheet(tool.GetSheetName());
if (Bsheet != null)
{
tool.Doing();
Console.WriteLine(string.Format("完成对{0}数据的采集", tool.GetSheetName()));
tool.Write(ref Bsheet);
Console.WriteLine(string.Format("成功保存{0}的数据到Sheet中", tool.GetSheetName()));
}
}
Save();
Console.WriteLine("完成结果表格的生成");
}
public void Analyze2(string SaveFolder)
{
MainTool maintool = new MainTool(MdbFilePath);
maintool.Doing();
Console.WriteLine("完成GYYD表数据合并生成....................");
MergeTool mergetool = new MergeTool(MdbFilePath);
mergetool.Working();
Console.WriteLine("完成GYYD_YDDW表数据合并生成...............");
ITool tool = null;
foreach (SheetEnum sheet in Enum.GetValues(typeof(SheetEnum)))
{
switch (sheet)
{
case SheetEnum.one:
tool = new ToolOne(MdbFilePath);
break;
case SheetEnum.two:
tool = new ToolTwo(MdbFilePath);
break;
case SheetEnum.three:
tool = new ToolThree(MdbFilePath);
break;
case SheetEnum.four:
tool = new ToolFour(MdbFilePath);
break;
case SheetEnum.five:
tool = new ToolFive(MdbFilePath);
break;
case SheetEnum.six:
tool = new ToolSix(MdbFilePath);
break;
}
Console.WriteLine(string.Format("开始对{0}数据生成工作", tool.GetSheetName()));
IWorkbook ModelWorkbook = tool.GetCurrentName().GetSourcesPath().OperWorkbook();
if (ModelWorkbook != null)
{
ISheet Asheet = ModelWorkbook.GetSheet(tool.GetSheetName());
if (Asheet != null)
{
tool.Doing();
Console.WriteLine(string.Format("完成对{0}数据的采集", tool.GetSheetName()));
tool.Write(ref Asheet);
Console.WriteLine(string.Format("成功保存{0}的数据到Sheet中", tool.GetSheetName()));
string excelFilepath = System.IO.Path.Combine(SaveFolder, tool.GetCurrentName());
Save(excelFilepath, ModelWorkbook);
Console.WriteLine(string.Format("成功保存文件:{0}", excelFilepath));
}
else
{
Console.WriteLine("未找到Sheet");
}
}
}
Console.WriteLine("完成结果表格的生成");
}