You shouldn't have any problems with Null values. Here's how it works: you can create an Excel Sheet with multiple columns, like this:
1| fName | lName |
2| Tom | Roger |
3| Dick | Foreman |
4| | Paul |
5| Harry | |
And lets say you bind a test to this excel. Your test handles a login - it writes a first and last name to two Input boxes. The two "Set Text To"
steps for these text boxes are bound to the excel $(fName)
When you execute this it will be broken down into 4 iterations. Each iteration will use the values from one row. The empty (null) values will be treated as simply empty - you won't get a nullpointer exception even if you don't check for it in a coded step. For the specific example shown above the four iterations will look like this value-wise:
and $(lName)=Paul --> won't write anything to First Name Field
and $(lName)= --> won't write anything to Last Name Field
And this test run will be completely successful - so no need to handle anything. Any null values are treated as an empty string ( "" ).
I hope I've managed to answer your question please don't hesitate to contact us if there's anything else!
the Telerik team