I was recently wandering around StackOverflow and PyPI and wondering why the only solutions to make MS Office documents from Python seemed to be based around either COM automation,
OpenOffice automation, or calling Java or .net libraries.
So I made this module, which reads and writes Microsoft Office Word 2007 docx files. These are referred to as 'WordML', 'Office Open XML' and 'Open XML' by Microsoft.
They can be opened in Microsoft Office 2007, Microsoft Mac Office 2008, OpenOffice.org 2.2, and Apple iWork 08.
The docx module has the following features:
Making documents
• Paragraphs
• Bullets
• Numbered lists
• Multiple levels of headings
• Tables
Editing documents
Thanks to lxml module, we can:
• Search and replace
• Extract plain text of document
• Add and delete items anywhere within the document
• Run xpath queries against particular locations in the document - useful for retrieving data from user-completed templates.
It's only a couple of hundred lines - lxml does most of the heavy work - but it's incredibly simple to use, check out example.py in the link.
This is great! I'm already using lxml for my project and using ReportLab to create pdf reports of data I'm mining from the Web. This will be perfect for me and now I can generate Microsoft Word reports.
Glad you like it. A great deal of the credit belongs to the lxml authors (Stephan Behnel in particular). Though this only took a day or do, I've been using lxml for projects for years and always loved it - in particular, the xpath makes modifying and querying trees really easy.
If more people used LXML and saw how easy it was, the whole idea of modifying serialized XML 'Cthulu style' would be seen as being as odd as modifying other data by manipulating their pickled forms.
Thank you, nailer! I've been putting up with Word randomly crashing when using it's COM object in long running processes. Now I can skip Word altogether and work on the file level. THANKS!
Some plans I have to add to this module (if you don't plan too already):
Add support for:
* Pass a font-size, bold, italic, bold+italic and spacing to paragraph method to modify font
* Pass a table row header to table method
* Specify table column widths
* Change text alignment for table rows/headers, etc.
* Change text style in table cells
* Ability to change background color for every other table row
* Create method to insert a page/section break
* Create a method to add an image at a specific position in document page
On one other note:
I'm not 100% positive, but thumbnail.jpg/thumbnail.wmf may result in inadvertent disclosure of sensitive data if using this to generate report documents...
docx has been a real boon to people writing things like search engines and want to use the text inside of the files.
We've been using http://b2xtranslator.sourceforge.net/blog/ to convert legacy binary office formats to openXML, then using XSLT to transform the XML into our preferred schema for text extraction.
Python also has a native Python module for reading and writing Excel files. It's pretty simple to use and also doesn't require any COM nastiness. http://www.python-excel.org/
An even worse hack, that unfortunately has worked really well for me in the past: generate a simple HTML file (em, b, u, ul/ol, etc.), rename it to .doc, and Word will open it without appearing to notice or comment. This saved my butt once when I discovered mid-project that the Textile library I was using couldn't generate RTF... I felt more than a little bit dirty, but it worked without a hitch.
.mht uses MIME/Base64 to store all of the HTML and external files together, but IIRC it's not exactly the same as an email because the headers are different/missing (i.e. I wouldn't make sense to have a To:/Reply-To:/Cc:/etc header)
We are wholesaler of Nike Jordan and Other Shoes. We are a professional exporting company . We supply many kinds of Shoes, such as Nike Shoes, Jordan 1-23, Air Jordan, AF1, DUNK, Air max series etc. Most of them are in stock and can be supplied surely on time. All these shoes are packed with original-boxes and cards.
====> free shipping <====
====>competitive price<====
====>any size available<====
====>accept Credit Card payment<====
HTTP://WWW.WOWHOTSALE.COM
jordan air max oakland raiders $34--39;
Ed Hardy AF JUICY POLO Bikini $25;
Christan Audigier BIKINI JACKET $30;
gstar coogi evisu true jeans $35-39;
coach chanel gucci LV handbags $36;
coogi DG edhardy gucci t-shirts $18;
CA edhardy vests.paul smith shoes $32;
jordan dunk af1 max gucci shoes $37;
EDhardy gucci ny New Era cap $16;
coach okely Adidas CHANEL DG Sunglass $18;
Thanks! I've had to deal with docx files from time to time. I'm going to try this out.
Does anyone know of a good way to read xlsx files with Python? I think I tried one library and it didn't quite work for this 20,000 row file, and I wound up using OpenOffice to convert it to csv. If not, hopefully this can be used as a starting point for developing a nice xlsx library.
I've never tried it on a 20,000 row file. I suspect it would work. A really large file might need to switch to a streaming XML parser, but probably Excel itself wouldn't handle that use case too well.
A while ago, I wrote a little Python script to read from xlsx Excel files. It's nice that these Microsoft Office XML files can be processed in pure Python.
26 comments
[ 5.1 ms ] story [ 72.6 ms ] threadI was recently wandering around StackOverflow and PyPI and wondering why the only solutions to make MS Office documents from Python seemed to be based around either COM automation, OpenOffice automation, or calling Java or .net libraries.
So I made this module, which reads and writes Microsoft Office Word 2007 docx files. These are referred to as 'WordML', 'Office Open XML' and 'Open XML' by Microsoft.
They can be opened in Microsoft Office 2007, Microsoft Mac Office 2008, OpenOffice.org 2.2, and Apple iWork 08.
The docx module has the following features:
Making documents
• Paragraphs
• Bullets
• Numbered lists
• Multiple levels of headings
• Tables
Editing documents
Thanks to lxml module, we can:
• Search and replace
• Extract plain text of document
• Add and delete items anywhere within the document
• Run xpath queries against particular locations in the document - useful for retrieving data from user-completed templates.
It's only a couple of hundred lines - lxml does most of the heavy work - but it's incredibly simple to use, check out example.py in the link.
Hope you find it useful.
Mike
If more people used LXML and saw how easy it was, the whole idea of modifying serialized XML 'Cthulu style' would be seen as being as odd as modifying other data by manipulating their pickled forms.
Some plans I have to add to this module (if you don't plan too already):
Add support for:
* Pass a font-size, bold, italic, bold+italic and spacing to paragraph method to modify font
* Pass a table row header to table method
* Specify table column widths
* Change text alignment for table rows/headers, etc.
* Change text style in table cells
* Ability to change background color for every other table row
* Create method to insert a page/section break
* Create a method to add an image at a specific position in document page
On one other note:
I'm not 100% positive, but thumbnail.jpg/thumbnail.wmf may result in inadvertent disclosure of sensitive data if using this to generate report documents...
I'm already working on images and 100% nose coverage. I'm intending to do document properties after that.
Re: zebra striping for tables, we already have that via the inbuilt styles. But more options to control styles would be useful.
Coding style is:
* Functional
* Google style - http://code.google.com/p/soc/wiki/PythonStyleGuide
* Unit tests are handled with nose / coverage
I couldn't find anything about a license or copyright on your project's github page.
We've been using http://b2xtranslator.sourceforge.net/blog/ to convert legacy binary office formats to openXML, then using XSLT to transform the XML into our preferred schema for text extraction.
PS, .eml and .mht are actually the same format.
.mht uses MIME/Base64 to store all of the HTML and external files together, but IIRC it's not exactly the same as an email because the headers are different/missing (i.e. I wouldn't make sense to have a To:/Reply-To:/Cc:/etc header)
http://www.wowhotsale.com
jordan air max oakland raiders $34--39; Ed Hardy AF JUICY POLO Bikini $25; Christan Audigier BIKINI JACKET $30; gstar coogi evisu true jeans $35-39; coach chanel gucci LV handbags $36; coogi DG edhardy gucci t-shirts $18; CA edhardy vests.paul smith shoes $32; jordan dunk af1 max gucci shoes $37; EDhardy gucci ny New Era cap $16; coach okely Adidas CHANEL DG Sunglass $18;HTTP://WWW.WOWHOTSALE.COM
http://www.wowhotsale.com/productlist.asp?id=s81 (Hoody)
http://www.wowhotsale.com/productlist.asp?id=s17 (Shox)
http://www.wowhotsale.com/productlist.asp?id=n516 (AF jacket)
http://www.wowhotsale.com/productlist.asp?id=s32 (women boot)
http://www.wowhotsale.com/productlist.asp?id=s74 (Tshirt)
http://www.wowhotsale.com/productlist.asp?id=s79 (Jean)
http://www.wowhotsale.com/productlist.asp?id=s72 (Handbag)
http://www.wowhotsale.com/productlist.asp?id=s62 (Tiffany_Ring)
Does anyone know of a good way to read xlsx files with Python? I think I tried one library and it didn't quite work for this 20,000 row file, and I wound up using OpenOffice to convert it to csv. If not, hopefully this can be used as a starting point for developing a nice xlsx library.
http://github.com/brendano/tsvutils/blob/master/xlsx2tsv
I've never tried it on a 20,000 row file. I suspect it would work. A really large file might need to switch to a streaming XML parser, but probably Excel itself wouldn't handle that use case too well.
A while ago, I wrote a little Python script to read from xlsx Excel files. It's nice that these Microsoft Office XML files can be processed in pure Python.
http://github.com/brendano/tsvutils/blob/master/xlsx2tsv