Announcement

Collapse
No announcement yet.

Command line for comparing two Microsoft Excel workbooks(text only)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Command line for comparing two Microsoft Excel workbooks(text only)

    What is the command line for comparing two Microsoft Excel workbooks(text only) in bc3 ?

  • #2
    Compare in what way? Do you wish to launch the graphical interface from the command line, to return an ErrorLevel value on the command line, or launch a script which then generates a Report automatically?

    To launch the interface, you can use bcompare.exe "c:\excel.xls" "c:\excel2.xls"
    To get an error level, use bcomp.com /qc "c:\excel.xls" "c:\excel2.xls"
    For script, bcompare.exe "@c:\bcscript.txt" "c:\excel.xls" "c:\excel2.xls" "c:\bcreport.txt"

    where bcscript.txt is:
    data-report layout:side-by-side output-to:"%3" "%1" "%2"

    Scripting can generate a wide variety of reports with many more options. I would suggest finding the report you want to use first in the graphical interface, then find the corresponding script which can generate that report. We can help with a full screen screenshot showing the Report dialog in the GUI.

    If you want to open your Excel files in the Text Compare instead of the Data Compare, you would need to install that format from our Alternatives section of the File Formats Download page.
    Beyond Compare is a multi-platform utility that combines directory compare and file compare functions in one package. Use it to manage source code, keep directories in sync, compare program output, etc.
    Aaron P Scooter Software

    Comment


    • #3
      Thanks for the reply..
      I am using below command line to compare the excel files .

      bcomp /qc "c:\excel.xls" "c:\excel2.xls"

      But it is taking time (Almost 3 min. ) to compare the small excel files. Is there any faster way to compare the excel files ?

      Comment


      • #4
        How long does the comparison take in the graphical interface using the default Data Compare session type? How small are the files?

        The rules-based compare could take longer than a binary scan. If you want to use a binary scan, you can use /qc=binary
        Aaron P Scooter Software

        Comment


        • #5
          Comparison takes 3 min s using in the graphical interface using the default Data Compare session type.

          I cant use binary compare option as I want to compare text only.

          Is there any way to convert excel data into text and then compare ?

          Comment


          • #6
            We have an additional download to open the files in the Text Compare:
            Beyond Compare is a multi-platform utility that combines directory compare and file compare functions in one package. Use it to manage source code, keep directories in sync, compare program output, etc.


            It uses a similar conversion as the Data Compare. You could also pre-convert by using Excel to save your files as CSV, then compare the CSV.

            What is the file size of your Excel files?
            Aaron P Scooter Software

            Comment


            • #7
              I have downloaded the format ‘MS Excel workbooks (*.xls, *.xlsm, *.xlsx)’ from below link http://www.scootersoftware.com/downl...oreformats_alt
              But while importing i am getting error could not able to find XLS_to_CSV.vbs .Then I Renamed the XLS_to_CSV_Single.vbs file to XLS_to_CSV.vbs then it is comparing only single sheet.
              But I want to compare all the sheet inside excel workbook . Please let me know from where I could get XLS_to_CSV.vbs file.

              Comment


              • #8
                Hello,

                When installing from the Alternative File Formats download page, you should end up with an MS Excel .bcpkg. This package is a renamed .zip, and inside is both the necessary XML Config files and the .vbs helper functions that need to be copied into the Helper/ subdirectory.

                Using the BC3 Toosl menu -> Import and pointing at the bcpkg should handle all of this for you automatically. If it is failing, try running BC3 with "Run As Administrator", in case your normal user does not have access to perform this import.
                Aaron P Scooter Software

                Comment


                • #9
                  Thanks a lot, it worked for me ..

                  Comment

                  Working...
                  X