For an internal database I'm building, I have a开发者_如何学C sqlite database, and I want to use python to export it into a tsv file. The current problem is that some of my dates are being replaced with '######', and when double-clicked, become actual dates. Could somebody please help?
Note: Nothing else changes, including type (they're both date, as excel 2007 indicates).
If anyone wants to see the python source code, please comment, but I don't currently see a reason as to why I need to post it.
you mean the ####
appear in Excel?
This is a common issue: when Excel cannot display the whole value of a cell, it displays ###
until it can show the whole value. This is display only.
STFW for more explanation.
精彩评论