Excel --> MS SQL; skip blank calculated rows
I would import the entire spreadsheet into an empty "temp" table, then run a sql statement to copy the rows I want across to my permanent table.

This way it is easy to setup rules so that you only get the rows you want and it is easy to test both the import and the copy jobs separately.