4 ms·
What in spreadsheets is not testable? It's trivial to write a test that opens the spreadsheet in excel and tests any formula calculations via Excel Automation A
by kyberias 7y ago
What in spreadsheets is not testable? It's trivial to write a test that opens the spreadsheet in excel and tests any formula calculations via Excel Automation API.
- hprotagonist 7y agoand where do i store my tests? how do i version them, and the data? can i put it in travis? how many people ever even try?
- kyberias 7y agoYou store them in the same place where you place other tests. It's just code. You version the data as you version any other test data. Never used travis myself, I guess it's some kind of CI. Many people do this. It's perfectly normal. Of course if you don't even use Excel in the first place, I don't know why you're asking.