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