can xlrd & xlwt support Excel 2007/2010?

2,529 views
Skip to first unread message

Yi Lin

unread,
May 14, 2012, 2:36:55 AM5/14/12
to python-excel
such as the title.
I hope I can work with excel 2007/2010 :)

Thomas Kluyver

unread,
May 14, 2012, 9:42:09 AM5/14/12
to python...@googlegroups.com
I guess you're talking about the xlsx file format that was introduced with Excel 2007?

xlrd and xlwt don't support it yet, but there's some initial work in xlrd (https://github.com/python-excel/xlrd ) towards reading xlsx files in a future release. If you're preparing files to open in Excel, you can keep writing xls files with xlwt, because new versions of Excel should still be able to open them.

You could also look at openpyxl, which is written for working with xlsx files:
http://pypi.python.org/pypi/openpyxl

Thomas

Yi Lin

unread,
May 15, 2012, 2:30:45 AM5/15/12
to python-excel
THX!

On 5月14日, 下午9时42分, Thomas Kluyver <tak...@gmail.com> wrote:
> I guess you're talking about the xlsx file format that was introduced with
> Excel 2007?
>
> xlrd and xlwt don't support it yet, but there's some initial work in xlrd
> (https://github.com/python-excel/xlrd) towards reading xlsx files in a
Reply all
Reply to author
Forward
0 new messages