Patch to recognize another date format
Created originally on Bitbucket by codeape (Bernt R. Brenna)
Ran into a xlsx file with a cell formatted as 'dd mmmm yyyy' (ie. 26 January 2011).
In openpyxl, style.numberformat was
{{{ [$-809]dd\ mmmm\ yyyy;@ }}}
, and the cell was not recognized as a date.
The attached patch adds a regex to recognize this as a date.
I wonder, could the date format recognition be rewritten? Is there a robust way to catch all the different styles of date formats?
Attachments: new_dateformat.patch