public CompareExcel()
{
dir1 = SystemExtensions.GetInputStr("请拖入选定文件(.xls|xlsx):", "您选择的文件：");
dir2 = SystemExtensions.GetInputStr("请拖入选定文件(.xls|xlsx):", "您选择的文件：");
var vals1 = new ExcelByNpoi().ReadFromExcels(dir1);
var vals2 = new ExcelByNpoi().ReadFromExcels(dir2);
var index = 0;
foreach (KeyValuePair <string, List <List <object> > > keyValuePair in vals1)
{
List <List <object> > lst = new List <List <object> >();
if (vals2.TryGetValue(keyValuePair.Key, out lst))
{
var haha = keyValuePair.Value.Except(lst).ToList();
var newName = Path.GetDirectoryName(dir1) + "/" + Path.GetFileNameWithoutExtension(dir1) + "-" +
Path.GetFileNameWithoutExtension(dir2) + ".xlsx";
new ExcelByNpoi().WriteToExcel(newName, haha);
}
else
{
Console.WriteLine(dir2 + " 不存在的sheet：" + keyValuePair.Key);
}
}
}
