Brett Hoerner wrote: > I'm not sure what you mean, really, do you need an official Python > "Null" value? Try None? > > In [6]: myCells = ['Mary', 'Bob', None, 'Joe'] > > In [7]: for cell in myCells: > ...: if cell: > ...: print cell > ...: else: > ...: print "NULL VALUE" > ...: > Mary > Bob > NULL VALUE > Joe > > -- > > As far as having a Null value to put into the DB, most (SQL) DB's I've > used have a specific SQL command like "INSERT INTO ROW VALUE NULL()", > kind of like the SQL DATE(), etc. I'm really rusty on my syntax etc > right now btw so don't copy and paste that. :P > And besides that, Excel is a spreadsheet not a database :-)
regards Steve -- Steve Holden +44 150 684 7255 +1 800 494 3119 Holden Web LLC www.holdenweb.com PyCon TX 2006 www.python.org/pycon/ -- http://mail.python.org/mailman/listinfo/python-list