Problem reported by James Hyde 8 years ago
This kinda works, but is very fussy with file types.
- The header cannot have any blank data (e.g. ,,,,,,,,,)
- You cannot have thousand separators e.g. "12,234","5,567" (this is still a valid csv format)
- The date header must be 01-2012 which is corrupted to a date integer in Excel straight away (suggest you use something else which Excel doesn't identify as a date).