Data Driven Excel data source Unit Testing Using VS 2013

 

Introduction:- We're using excel as data source for data driven unit testing.

1. Create Unit test Project using option given above.


2. Add following code , this is demo code for reference.


Test Data:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Trobleshooting Issues:

Probable Error: "Excel microsoft.ace.oledb.12.0 provider is not registered"

Download and install

2007 Office System Driver: Data Connectivity Components

http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734