Re: Question about available python lib for a task

[Tim Roberts]

cesium5...@yahoo.ca wrote:
>
>I would like to build a database of all the MS-Excel file on a LAN. I 
>would like to get the files metadata : filename, summary, location, 
>size, etc.
>
>Is there a dedicated python lib for the task?

No.  The file name, location, and size are all completely generic.  You can
do that with standard Python and the os.walk command.

The document properties (like the summary) can be accessed in a couple of
ways.  You can do it in Excel by opening the application, opening the
document, and using the BuiltinDocumentProperties collection.  Or, you can
do it without Excel, using the COM interfaces for "structured storage",
like IPropertySetStorage and IPropertyStorage.

>Is pywin32 one of the possible lib available?

You will need PyWin32 in order to use COM to launch Excel, or use the
structured storage interfaces.
-- 
Tim Roberts, t...@probo.com
Providenza & Boekelheide, Inc.
-- 
http://mail.python.org/mailman/listinfo/python-list

Re: Question about available python lib for a task

[Terry Reedy]

On 5/14/2011 11:11 AM, cesium5...@yahoo.ca wrote:


I would like to build a database of all the MS-Excel file on a LAN. I
would like to get the files metadata : filename, summary, location,
size, etc.


You subject line is about a non-specific as can be, which means that the 
person who can answer would not know and would likely skip over it. 
Something like


"Wanted: a module to catalog Excel files on a LAN"

would grab attention better.


Is there a dedicated python lib for the task? Is pywin32 one of the
possible lib available?


Sorry, I have no idea.

--
Terry Jan Reedy

--
http://mail.python.org/mailman/listinfo/python-list