0

Is there an external driver for Excel (e.g., something roughly analogous to chromedriver) that would let me write end-to-end tests for a complex spreadsheet setup?

I have a script that generates a somewhat complex Excel spreadsheet, and I'd like to write automated tests to verify that the spreadsheet behaves as expected when opened in Excel.

In particular, I'd like to verify that

  1. The expected columns are hidden, and
  2. The expected cells are locked, and all remaining cells are unlocked.

I'd like to test by actually driving Excel. Although I could write tests using rubyXL to verify that the cell properties are set as expected, that does not verify that the way I set the properties does, in fact, produce the expected behavior when the spreadsheet is loaded into Excel.

Zack
  • 6,232
  • 8
  • 38
  • 68
  • 1
    This is old but might help: https://stackoverflow.com/questions/10963950/how-do-i-run-an-excel-macro-from-ruby. You could write your tests in VBA (excel macros) which can tell you the state of a given file's cell ranges ([e.g.](https://stackoverflow.com/questions/57801949/check-if-columns-is-visible-in-excel-using-vba)). – thedatadavis Dec 22 '22 at 06:09

0 Answers0