No announcement yet.

Excel - multiple sheets

  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel - multiple sheets

    When comparing Excel files, only the first sheet is loaded in Beyond Compare. I did not realize that there were other sheets, which may have had differences when I was comparing. If multiple sheets are not supported for comparison, I would recommend displaying some kind of warning to alert the user that a spreadsheet contains more than one sheet.

  • #2

    Thanks for the suggestion. Our Data Compare does only currently support 1 sheet, and we do not currently support a scan for multiple sheets as an error condition.

    If you are dealing with multisheet Excel files, I recommend this KB article, which goes into detail on how you can use our Text Compare as the default Rules-based comparison, or combine the two into a single, large sheet:
    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