Unit Testing VS 2008 Using Excel

Posted by David on Stack Overflow See other posts from Stack Overflow or by David
Published on 2010-05-02T15:22:46Z Indexed on 2010/05/02 15:27 UTC
Read the original article Hit count: 203

Filed under:

unit-testing

When using Excel (2003) to provide data for my unit tests it seems to think that when a cell has TRUE / FALSE value that it is null when there has been no preceding cell values e.g.

 if (TestContext.DataRow["SatisfactionExtremelySatisfied"] != DBNull.Value)
      model.SatisfactionExtremelySatisfied = (bool)TestContext.DataRow
      ["SatisfactionExtremelySatisfied"];

Sample Excel Data

DataRow  SatisfactionExtremelySatisfied
0
1
2                 TRUE
3                 TRUE

When reading the test data using OLEDB the cells with TRUE hold no value but when the preceding cells have the value FALSE entered it correctly gets the values TRUE.

Am I missing something?

Related posts about unit-testing

Unit testing best practices for a unit testing newbie

as seen on Programmers - Search for 'Programmers'
In recent years, I have only written small components for people in larger projects or small tools. I have never written a unit test and it always seems like learning how to write them and actually making one takes a lot longer than simply firing up the program and testing for real. I am just about… >>> More
About unit testing a function in the zend framework and unit testing in general

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello people, I am diving into the world of unit testing. And i am sort of lost. I learned today that unit testing is testing if a function works. I wanted to test the following function: public function getEventById($id) { return $this->getResource('Event')->getEventById($id); } So… >>> More
Unit testing a database connection and general questions on database-dependent code and unit testing

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, If I have a method which establishes a database connection, how could this method be tested? Returning a bool in the event of a successful connection is one way, but is that the best way? From a testability method, is it best to have the connection method as one method and the method to get… >>> More
What is the objective of unit testing?

as seen on Programmers - Search for 'Programmers'
I've been working with C# for the last 2 years, and I've never done any unit testing. I just need to know what the objective of unit testing is. What kind of results do we expect from unit testing? Is code quality checked by unit testing? In my view, unit testing is the job of testers; if that is… >>> More
Unit testing newbie team needs to unit test

as seen on Programmers - Search for 'Programmers'
I'm working with a new team that has historically not done ANY unit testing. My goal is for the team to eventually employ TDD (Test Driven Development) as their natural process. But since TDD is such a radical mind shift for a non-unit testing team I thought I would just start off with writing unit… >>> More

Developer IT

Unit Testing VS 2008 Using Excel - Developer IT

Unit Testing VS 2008 Using Excel

unit-testing

Related posts about unit-testing

Unit testing best practices for a unit testing newbie

About unit testing a function in the zend framework and unit testing in general

Unit testing a database connection and general questions on database-dependent code and unit testing

What is the objective of unit testing?

Unit testing newbie team needs to unit test

Categories cloud