How do I read Excel file in Python?
Steve Holden
steve at holdenweb.com
Thu Oct 5 14:25:59 EDT 2006
Matimus wrote:
>>the date( 8/9/2006 ) in Excel file, i am getting the value as 38938.0,
>>which I get when I convert date values to general format in Excel. I
>>want the actual date value. How do get that?
>
>
> 38938 appears to be the date in days since 1/1/1900. I'm sure someone
> can help you figure out how to convert that to a more useful value.
>
I believe the win32all extension contains functionality to help with
that, thought it's a long time since I even ran PythonWin (sorry, Mark).
regards
Steve
--
Steve Holden +44 150 684 7255 +1 800 494 3119
Holden Web LLC/Ltd http://www.holdenweb.com
Skype: holdenweb http://holdenweb.blogspot.com
Recent Ramblings http://del.icio.us/steve.holden
More information about the Python-list
mailing list