pyexcel-io

updated

1. #115: Pathnames with . cause file_name error in get_writer.

2. #117: fix a typo in license.

updated

1. #112: Log Empty Row Warning instead 'print'

updated

1. #109: enable ods3 to have datetime

updated

1. #102: skip columns from imported excel sheet.

fixed

1. #96: regression: unknown file type shall trigger NoSupportingPluginFound

updated

1. extra dependencies uses 0.6.0 based plugins

fix #96

updated extra dependencies to use 0.6.0 line of plugins.

updated

1. #70: when the given file is a root directory, the error shall read it is not a file

updated

1. pyexcel#185: handle stream conversion if file type(html) needs string content then bytes to handle

updated

1. #69: Force file type(force_file_type) on write

updated

1. #68: Raise IOError when the data file does not exist

updated

1. #67: fix conversion issue for long type on python 2.7 for ods

updated

1. #65: add tests/__init__.py because python2.7 setup.py test needs it

updated

1. #63: Version 0.5.12 prevents xslx and ods plugin from being loaded

updated

1. #59: Please use scan_plugins_regex, which lml 0.7 complains about

added

1. #57, long type will not be written in ods. please use string type. And if the integer is equal or greater than 10 to the power of 16, it will not be written either in ods. In both situation, IntegerPrecisionLossError will be raised. And this version enables pyexcel-ods and pyexcel-ods3 to do so.

updated

1. #53, upgrade lml dependency to at least 0.0.2

added

1. pyexcel#148, support force_file_type

added

1. #49, support additional options when detecting float values in csv format. default_float_nan, ignore_nan_text

fixed

1. #48, turn off pep 0515

2. #47, csv reader cannot handle relative file names

fixed

1. #46, expose bulk_save to developer

fixed

1. Issue #45, csv reader throws exception because google app engine does not support mmap. People who are not working with google app engine, need not to take this update. Enjoy your Christmas break.

updated

1. PR #44, use unicodewriter for csvz writers.

updated

1. pyexcel pyexcel#105, remove gease from setup_requires, introduced by 0.5.2.

2. remove python2.6 test support

added

1. pyexcel#103, include LICENSE file in MANIFEST.in, meaning LICENSE file will appear in the released tar ball.

Fixed

1. pyexcel-ods#25, Unwanted dependency on pyexcel.

Updated

1. #42, raise exception if database table name does not match the sheet name

Updated

1. #41, walk away gracefully when mmap is not available.

Updated

1. #37, permanently fix the residue folder pyexcel by release all future releases in a clean clone.

Updated

1. #31, support pyinstaller

Updated

1. #29, change skip_empty_rows to False by default

Added

1. updated versions of extra packages

Updated

1. #23, provide helpful message when old pyexcel plugin exists

2. restored previously available diagnosis message for missing libraries

Added

1. lazy loading of plugins. for example, pyexcel-xls is not entirely loaded until xls format is used at its first attempted reading or writing. Since it is loaded, it will not be loaded in the second io action.

2. pyexcel-xls#11, make case-insensitive for file type

Updated

1. #24, pass on batch_size

Updated

1. #26, performance issue with getting the number of columns.

Updated

1. #23, Failed to convert long integer string in python 2 to its actual value

Added

1. #21, choose subset from data base tables for export

2. #22, custom renderer if given row_renderer as parameter.

Added

1. support pagination. two pairs: start_row, row_limit and start_column, column_limit help you deal with large files.

2. skip_empty_rows=True was introduced. To include empty rows, put it to False.

Updated

1. #20, pyexcel-io attempts to parse cell contents of 'infinity' as a float/int, crashes

Added

1. csv format: handle utf-16 encoded csv files. Potentially being able to decode other formats if correct "encoding" is provided

2. csv format: write utf-16 encoded files. Potentially other encoding is also supported

3. support stdin as input stream and stdout as output stream

Updated

1. Attention, user of pyexcel-io! No longer io stream validation is performed in python 3. The guideline is: io.StringIO for csv, tsv only, otherwise BytesIO for xlsx, xls, ods. You can use RWManager.get_io to produce a correct stream type for you.

2. #15, support foreign django/sql foreign key

Added

1. autoload of pyexcel-io plugins

2. auto detect datetime, float and int. Detection can be switched off by auto_detect_datetime, auto_detect_float, auto_detect_int

Added

1. yield key word to return generator as content