On 2008-07-28 22:22, Fabio Oikawa wrote:
Hello.
I am trying to open an .xls (excel) file using xlrd, but an error message
occurs when I open the workbook.
I can open any other .xls file made by myself (either by MS Excel 2003 SP3
in Windows Vista or by OpenOffice 2.0 in Debian) using the
*open_workbook*function:
wb = xlrd.open_workbook('myworkbook.xls')
but when I try to open a file from one specific site, I get the error
message:
In [2]: wb = xlrd.open_workbook('balanco.xls')
WARNING *** file size (81192) not 512 + multiple of sector size (512)
WARNING *** OLE2 inconsistency: SSCS size is 0 but SSAT size is non-zero
This looks like a broken XLS file.
In any case, you're probably better off asking this question on
the python-excel mailing list:
http://groups.google.com.au/group/python-excel?lnk=li&hl=en
You might also want to try pyExcelerator:
http://sourceforge.net/projects/pyexcelerator
---------------------------------------------------------------------------
struct.error Traceback (most recent call
last)
/home/oikawa/DB/<ipython console>
/usr/lib/python2.4/site-packages/xlrd/__init__.py in open_workbook(filename,
logfile, verbos ity, pickleable, use_mmap, file_contents, encoding_override,
formatting_info)
380 bk.parse_globals()
381 else:
--> 382 bk.parse_globals()
383 bk.get_sheets()
384 bk.nsheets = len(bk._sheet_list)
/usr/lib/python2.4/site-packages/xlrd/__init__.py in parse_globals(self)
1309 self.handle_name(data)
1310 elif rc == XL_PALETTE:
-> 1311 self.handle_palette(data)
1312 elif rc == XL_STYLE:
1313 self.handle_style(data)
/usr/lib/python2.4/site-packages/xlrd/formatting.py in handle_palette(book,
data)
550 "PALETTE record with %d colours\n", n_colours)
551 fmt = '<xx%di' % n_colours # use i to avoid long integers
--> 552 colours = unpack(fmt, data)
553 assert book.palette_record == [] # There should be only 1
PALETTE record
554 # a colour will be 0xbbggrr
error: unpack str size does not match format
I ran the xlrd in both Windows Vista / Python 2.5 and Debian / Python 2.4.4
and got the same problem, so I suppose there is something wrong with the
.xls files (which can be downloaded at www.fundamentus.com.br --> "Dados
Históricos" menu --> "Balancos em Excel" --> choose any company). However, I
need the files in order to create my database system. Actually I want to
build all companies' informations in a mySQL database, and the fastest and
easiest way I found is to download .xls files, to get the data using
xlrd-Python and to add them in the mySQL database. Any sugestions for both
questions? Thanks in advance.
--
Marc-Andre Lemburg
eGenix.com
Professional Python Services directly from the Source (#1, Jul 29 2008)
>>> Python/Zope Consulting and Support ... http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/
________________________________________________________________________
:::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! ::::
eGenix.com Software, Skills and Services GmbH Pastor-Loeh-Str.48
D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
Registered at Amtsgericht Duesseldorf: HRB 46611
--
http://mail.python.org/mailman/listinfo/python-list
