Problem exporting Data to Excel with java
 

Please I need a help.

I am trying to export JTable data to excel, it works perfectly if the JTble doesn't contain a null. But once there is a null in the JTable my code throws an exception and the data doesn't eport.

Please can anybody help me correct this error?

Thanks in advance!!!

Since you already have it working I'd suggest simply removing the nulls and replacing them with empty Strings. If you don't want to do it with the original data, take a copy of it during export or alter the export to catch the nulls and replace them with empty strings. You could also write it to completely forbid null to start with and take only an empty string.