unit testing - DbUnit excel nullable foreign key -

I try to set a null qualified BIGINT foreign key in my Excel file to fill the data I am doing my DbUnit exam but I am getting the following exception when leaving the cell empty:

  Reason by: org.dbunit.dataset.datatype.TypeCastException : Unable to type typed & lt; & Gt; Type & lt; Java.lang.String & gt;  

I have set the input to Excel in number etc. But it did not help.

Tried:

  [NULL], [null], & lt; Null & gt;  

The only exception is the change in "value" ...

Fixed it with adding:

  replacementdetsetsetdateDetateSet = new replacementDataset (dataset); Replaced DataSet.addReplacementObject ("[NULL]", tap);