예제 #1
0
        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);
                }
            }
        }