Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #5370 > unrolled thread

Question about available python lib for a task

Back to article view | Back to comp.lang.python

Contents

  Question about available python lib for a task cesium5500@yahoo.ca - 2011-05-14 11:11 -0400
    Re: Question about available python lib for a task Tim Roberts <timr@probo.com> - 2011-05-15 17:50 -0700

#5370 — Question about available python lib for a task

Hello,

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? Is pywin32 one of the 
possible lib available?

I would prefer to not building everything from scratch testing, etc.

ETL software could also is a solution maybe...

Thanks

[toc] | [next] | [standalone]

#5453

cesium5500@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, timr@probo.com
Providenza & Boekelheide, Inc.

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web