OleFileIO_PL is a Python module to read Microsoft OLE2 files (also called Structured Storage or Compound Document File Format), such as Microsoft Office documents, Image Composer and FlashPix files, Outlook messages, ... This is an improved version of the OleFileIO module from PIL, the excellent Python Imaging Library v1.1.6 (See: http://www.pythonware.com/products/pil/index.htm), created and maintained by Fredrik Lundh.
As far as I know, this module is now the most complete and robust Python implementation to read MS OLE2 files, portable on several OSes. (please tell me if you know other similar Python modules)
WARNING: THIS IS (STILL) WORK IN PROGRESS.
OleFileIO_PL changes are Copyright (c) 2005-2010 by Philippe Lagadec.
The Python Imaging Library (PIL) is
- Copyright (c) 1997-2005 by Secret Labs AB
- Copyright (c) 1995-2005 by Fredrik Lundh
By obtaining, using, and/or copying this software and/or its associated documentation, you agree that you have read, understood, and will comply with the following terms and conditions:
Permission to use, copy, modify, and distribute this software and its associated documentation for any purpose and without fee is hereby granted, provided that the above copyright notice appears in all copies, and that both that copyright notice and this permission notice appear in supporting documentation, and that the name of Secret Labs AB or the author not be used in advertising or publicity pertaining to distribution of the software without specific, written prior permission.
SECRET LABS AB AND THE AUTHOR DISCLAIMS ALL WARRANTIES WITH REGARD TO THIS SOFTWARE, INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL SECRET LABS AB OR THE AUTHOR BE LIABLE FOR ANY SPECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
Pick zip file below on this page.
See sample code at the end of the module, and also docstrings.
Here are a few examples:
import OleFileIO_PL
# Test if a file is an OLE container:
assert OleFileIO_PL.isOleFile('myfile.doc')
# Open OLE file:
ole = OleFileIO_PL.OleFileIO('myfile.doc')
# Get list of streams:
print ole.listdir()
# Test if known streams/storages exist:
if ole.exists('worddocument'):
print "This is a Word document."
print "size :", ole.get_size('worddocument')
if ole.exists('macros/vba'):
print "This document seems to contain VBA macros."
# Extract the "Pictures" stream from a PPT file:
if ole.exists('Pictures'):
pics = ole.openstream('Pictures')
data = pics.read()
f = open('Pictures.bin', 'w')
f.write(data)
f.close()
It can also be used as a script from the command-line to display the structure of an OLE file, for example:
OleFileIO_PL.py myfile.doc
If you would like to help us improve this module, or simply provide feedback, please send an e-mail to decalage(at)laposte.net. You can also help in many ways:
To report a bug, for example a normal file which is not parsed correctly, please send an e-mail with an attachment containing the debugging output of OleFileIO_PL.
For this, launch the following command :
OleFileIO_PL.py -d -c file >debug.txt
| Attachment | Size |
|---|---|
| OleFileIO_PL-0.18.zip | 23.04 KB |
| OleFileIO_PL-0.19.zip | 23.22 KB |
| OleFileIO_PL-0.20.zip | 23.61 KB |
| OleFileIO_PL-0.21.zip | 23.9 KB |
Comments
question
My question is: Can I extract all images from MS OLE2 documents with OleFileIO_PL ?
Extracting images from MS OLE2 documents
Not directly: images are not always stored the same way, and it also depends on the format.
For example in Powerpoint presentations, you may find a stream named "Pictures" when running "OleFileIO_PL yourfile.ppt". You may extract the stream by using the openstream() method on the OleFileIO object, but you will usually get a binary stream containing several picture files. You may also extract it manually using tools such as SSView (http://www.mitec.cz/ssv.html).
Then the only way I've found so far is to use file carving tools which are able to determine the beginning and the end of each picture in a binary file. These tools are not always easy to use but if you're interested have a look at http://pypi.python.org/pypi/hachoir-subfile and http://www.forensicswiki.org/wiki/Tools:Data_Recovery#Carving.
If you really need to automate the process then you have to study Microsoft specifications (at http://www.microsoft.com/interop/docs/officebinaryformats.mspx) and find the right way to parse MS Office documents...
A lot of people (including me) would be very interested if you find a solution! ;-)
array.array should use 'I' for 64-bit compatibility
On 64-bit systems, array.array('L', ...) expects the buffer to be 64-bit aligned, so OleFileIO_PL doesn't work there.
The fix is to change all calls like array.array('L', ...) to array.array('I', ...).
Small bug
Hoi,
Nice library. Did find a problem with it while using it on a 64-bit system. The construct
a = array.array("L", string)
is used often and doesn't work on 64-bit system where for some reason the above eats chunks of 8-bytes. Replacing all the occurrences with array.array("I", string) fixes the issue.
Works perfectly otherwise.
v0.19 fixed for 64 bits platforms
Thanks a lot Ben and Martijn for reporting that bug.
I have made the suggested change in v0.19. Please tell me if it works.
Philippe.
Tested ok
On the 64-bit systems I have access to it works fine, thanks.
Reading MSGraph workbook data
Hi,
First, thanks for writing this, it is much helpful.
I need to get the data values (sheet) from MSGraph.
I did:
f=OleFileIO_PL.OleFileIO('mygraphfile')
f.listdir()
output: [['\x01CompObj'], ['\x01Ole'], ['Workbook']]
and now:
f.openstream('Workbook').read()
gave me a binary stream, where I recognized the data in.
Is there a way to grep the data from the binary stream?
Thanks again,
Naor.
reading Excel data
Naor, OleFileIO is only meant to parse the OLE2 structure, not the binary streams inside which are different for each application (MS Word, Excel, Powerpoint, etc). Here are a few potential solutions: