Xlrd2

Latest version: v1.3.4

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

Scan your dependencies

Page 4 of 7

0.7.0

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

+ colname utility function now supports more than 256 columns.
+ Fix bug where BIFF record type 0x806 was being regarded as a formula
opcode.
+ Ignore PALETTE record when formatting_info is false.
+ Tolerate up to 4 bytes trailing junk on PALETTE record.
+ Fixed bug in unused utility function xldate_from_date_tuple which
affected some years after 2099.
+ Added code for inspecting as-yet-unused record types: FILEPASS, TXO,
NOTE.
+ Added inspection code for add_in function calls.
+ Added support for unnumbered biff_dump (better for doing diffs).
+ ignore distutils cruft
+ Avoid assertion error in compdoc when -1 used instead of -2 for
first_SID of empty SCSS
+ Make version numbers match up.
+ Enhanced recovery from out-of-order/missing/wrong CODEPAGE record.
+ Added Name.area2d convenience method.
+ Avoided some checking of XF info when formatting_info is false.
+ Minor changes in preparation for XLSX support.
+ remove duplicate files that were out of date.

0.6.1

+ Documented runxlrd.py commands in its usage message. Changed
commands: dump to biff_dump, count_records to biff_count.

0.6.1a5

-------

+ Bug fixed: Missing "<" in a struct.unpack call means can't open
files on bigendian platforms. Discovered by "Mihalis".
+ Removed antique undocumented Book.get_name_dict method and
experimental "trimming" facility.
+ Meaningful exception instead of IndexError if a SAT (sector
allocation table) is corrupted.
+ If no CODEPAGE record in pre-8.0 file, assume ascii and keep going
(instead of raising exception).

0.6.1a4

-------

+ At least one source of XLS files writes parent style XF records
*after* the child cell XF records that refer to them, triggering
IndexError in 0.5.2 and AssertionError in later versions. Reported
with sample file by Todd O'Bryan. Fixed by changing to two-pass
processing of XF records.
+ Formatting info in pre-BIFF8 files: Ensured appropriate defaults and
lossless conversions to make the info BIFF8-compatible. Fixed bug in
extracting the "used" flags.
+ Fixed problems discovered with opening test files from Planmaker
2006 (http://www.softmaker.com/english/ofwcomp_en.htm): (1) Four files
have reduced size of PALETTE record (51 and 32 colours; Excel writes
56 always). xlrd now emits a NOTE to the logfile and continues. (2)
FORMULA records use the Excel 2.x record code 0x0021 instead of
0x0221. xlrd now continues silently. (3) In two files, at the OLE2
compound document level, the internal directory says that the length
of the Short-Stream Container Stream is 16384 bytes, but the actual
contents are 11264 and 9728 bytes respectively. xlrd now emits a
WARNING to the logfile and continues.
+ After discussion with Daniel Rentz, the concept of two lists of XF
(eXtended Format) objects (raw_xf_list and computed_xf_list) has been
abandoned. There is now a single list, called xf_list

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.

Page 4 of 7

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.