Exemplo n.º 1
0
 private void CompareWorkSheets(string pWbName, PairFiles[] pPairSheets, bool pCompValue, bool pCompStyle, bool pCompShape)
 {
     //copy files to the temp folder
     int nbWorksheets = pPairSheets.Length;
     int wsi = 0;
     foreach (PairFiles pairSheet in pPairSheets)
     {
         this.InfoEvent("Compare workbook " + pWbName + " sheet " + pairSheet.A.Name);
         Worksheet wsA = (Worksheet)pairSheet.A.Object;
         Worksheet wsB = (Worksheet)pairSheet.B.Object;
         Range rgA = wsA.Range[wsA.Cells[1, 1], wsA.UsedRange.SpecialCells(XlCellType.xlCellTypeLastCell)];
         Range rgB = wsB.Range[wsB.Cells[1, 1], wsB.UsedRange.SpecialCells(XlCellType.xlCellTypeLastCell)];
         CompareRanges(pWbName, pairSheet.A.Name, rgA, rgB, pCompValue, pCompStyle, pCompShape);
         if (this.WsProgressEvent != null) this.WsProgressEvent(++wsi, nbWorksheets);
     }
 }
Exemplo n.º 2
0
        private void CompareWorkBooks(PairFiles[] pWorkbooksMatch, bool pCompValue, bool pCompStyle, bool pCompShape)
        {
            Application oExcel = CreateExcelApplication();
            if (oExcel != null)
            {
                try
                {
                    int nbWorkbooks = pWorkbooksMatch.Length;
                    int wbi = 0;
                    //int CptWb = 0;
                    foreach (PairFiles wbmatch in pWorkbooksMatch)
                    {
                        //if (CptWb++ == cNbWbRestriction && this.isForeignDomain) {
                        //    System.Windows.Forms.MessageBox.Show("This version is restricted to a maximum of " + cNbWbRestriction + " workbooks.   ", "Info", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Exclamation);
                        //    break;
                        //}
                        string pathA = (string)wbmatch.A.Object;
                        string pathB = (string)wbmatch.B.Object;
                        string pathAtmp = CopyFileToTempFolder(pathA, ".a");
                        string pathBtmp = CopyFileToTempFolder(pathB, ".b");
                        if (pathAtmp != null && pathBtmp != null)
                        {
                            Workbook wbA = null;
                            Workbook wbB = null;
                            wbA = OpenWorkbook(oExcel, pathAtmp, wbmatch.A.Name);
                            if (wbA != null)
                            {
                                wbB = OpenWorkbook(oExcel, pathBtmp, wbmatch.B.Name);
                                if (wbB != null)
                                {
                                    ResComp wscomp = Ext.Compare(wbA.Worksheets, wbB.Worksheets);
                                    this.nbSheets += wscomp.lenAandB;
                                    report.add_workbook_top(wbmatch.A.Name, wbA.Name, wbB.Name, wscomp);
                                    CompareWorkSheets(wbmatch.A.Name, wscomp.AandB, pCompValue, pCompStyle, pCompShape);
                                }
                            }
                            if (wbA != null) wbA.Close(false);
                            if (wbB != null) wbB.Close(false);
                            releaseObject((object)wbA);
                            releaseObject((object)wbB);
                        }
                        if (this.WbProgressEvent != null) this.WbProgressEvent(++wbi, nbWorkbooks);
                    }

                }
                catch (Exception)
                {

                }
                finally
                {
                    oExcel.Quit();
                    releaseObject((object)oExcel);
                }
            }
        }