Xlrd2

Latest version: v1.3.4

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

Scan your dependencies

Page 5 of 7

0.6.1a1

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

+ Added formatting information for cells (font, "number format",
background, border, alignment and protection) and rows/columns
(height/width etc). To save memory and time for those who don't need
it, this information is extracted only if formatting_info=1 is
supplied to the open_workbook() function. The cell records BLANK and
MULBLANKS which contain no data, only formatting information, will
continue to be ignored in the default (no formatting info) case.
+ Ralph Heimburger reported a problem with xlrd being intolerant about
an Excel 4.0 file (created by "some web app") with a DIMENSIONS record
that omitted Microsoft's usual padding with 2 unused bytes. Fixed.

0.6.0a4

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

+ Added extraction of human-readable formulas from NAME records.
+ Worked around OOo Calc writing 9-byte BOOLERR records instead of 8.
Reported by Rory Campbell-Lange.
+ This history file converted to descending chronological order and
HTML format.

0.6.0a3

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

+ Names: minor bugfixes; added script xlrdnameAPIdemo.py
+ ROW records were being used as additional hints for sizing memory
requirements. In some files the ROW records overstate the number of
used columns, and/or there are ROW records for rows that have no data
in them. This would cause xlrd to report sheet.ncols and/or
sheet.nrows as larger than reasonably expected. Change: ROW records
are ignored. The number of columns/rows is based solely on the highest
column/row index seen in non-empty data records. Empty data records
(types BLANK and MULBLANKS) which contain no data, only formatting
information, have always been ignored, and this will continue.
Consequence: trailing rows and columns which contain only empty cells
will vanish.

0.6.0a2

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


+ Fixed a bug reported by Rory Campbell-Lange.: "open failed";
incorrect assumptions about the layout of array formulas which return
strings.
+ Further work on defined names, especially the API.

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.

Page 5 of 7

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.