Xlrd

Latest version: v2.0.1

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

Scan your dependencies

Page 5 of 7

0.6.1a3

-------

+ Added Book.sheets ... for sheetx, sheet in enumerate(book.sheets):
+ Formatting info: extraction of sheet-level flags from WINDOW2
record, and sheet.visibility from BOUNDSHEET record. Added Macintosh-
only Font attributes "outline" and "shadow'.

0.6.1a2

-------

+ Added extraction of merged cells info.
+ pyExcelerator uses "general" instead of "General" for the generic
"number format". Worked around.
+ Crystal Reports writes "WORKBOOK" in the OLE2 Compound Document
directory instead of "Workbook". Changed to case-insensitive directory
search. Reported by Vic Simkus.

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.

Page 5 of 7

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.