Datetime data-- openpyxl doesn't support NaT
Created originally on Bitbucket by Charlie Heitzig
Hi, this may be similar to #1249 or may not even be considered a bug, but wanted to share
If you have dates that are “None” or “NaT” before trying to copy to excel sheet, you get a KeyError, which struck me as a bit strange. I think #1249 suggests a change that may fix this.
I fixed it in my code with a try/except and just continued since the cells that had NaT in the value could just be skipped.
Issue is illustrated in attached code, line 30-34
Attachments: openpyxl_NaT_KeyError.py