Re: Question about available python lib for a task
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
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
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 -- http://mail.python.org/mailman/listinfo/python-list