Xlrd

Latest version: v2.0.1

Safety actively analyzes 638437 Python packages for vulnerabilities to keep your Python projects secure.

Scan your dependencies

Page 6 of 7

0.6.0a1

---------------------

+ Sheet objects have two new convenience methods: col_values(colx,
start_rowx=0, end_rowx=None) and the corresponding col_types.
Suggested by Dennis O'Brien.
+ BIFF 8 file missing its CODEPAGE record: xlrd will now assume
utf_16_le encoding (the only possibility) and keep going.
+ Older files missing a CODEPAGE record: an exception will be raised.
Thanks to Sergey Krushinsky for a sample file. The open_workbook()
function has a new argument (encoding_override) which can be used if
the CODEPAGE record is missing or incorrect (for example,
codepage=1251 but the data is actually encoded in koi8_r). The
runxlrd.py script takes a corresponding -e argument, for example -e
cp1251
+ Further work done on parsing "number formats". Thanks to Chris
Withers for the ``"General_)"`` example.
+ Excel 97 introduced the concept of row and column labels, defined by
Insert > Name > Labels. The ranges containing the labels are now
exposed as the Sheet attributes row_label_ranges and col_label_ranges.
+ The major effort in this 0.6.0 release has been the provision of
access to named cell ranges and named constants (Excel:
Insert/Name/Define). Juan C. Mendez provided very useful real-world
sample files.

0.5.3a1

---------------------

+ John Popplewell and Richard Sharp provided sample files which caused
any reliance at all on DIMENSIONS records and ROW records to be
abandoned.
+ If the file size is not a whole number of OLE sectors, a warning
message is logged. Previously this caused an exception to be raised.

0.5.2

---------------------

+ public release
+ Updated version numbers, README, HISTORY.

0.5.2a3

-----------------------

+ Gnumeric writes user-defined formats with format codes starting at
50 instead of 164; worked around.
+ Thanks to Didrik Pinte for reporting the need for xlrd to be more
tolerant of the idiosyncracies of other software, for supplying sample
files, and for performing alpha testing.
+ '_' character in a format should be treated like an escape
character; fixed.
+ An "empty" formula result means a zero-length string, not an empty
cell! Fixed.

0.5.2a2

----------------------

+ Found that Gnumeric writes all DIMENSIONS records with nrows and
ncols each 1 less than they should be (except when it clamps ncols at
256!), and pyXLwriter doesn't write ROW records. Cell memory pre-
allocation was generalised to use ROW records if available with fall-
back to DIMENSIONS records.

0.5.2a1

----------------------


+ pyXLwriter writes DIMENSIONS record with antique opcode 0x0000
instead of 0x0200; worked around
+ A file written by Gnumeric had zeroes in DIMENSIONS record but data
in cell A1; worked around

Page 6 of 7

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.