Changelogs » Pyexcel

Pyexcel

20.11.2014

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

Initial release





Change log
===========

18.0.1

. NotImplementedError will be raised if parameters to core functions are not
supported, e.g. get_sheet(cannot_find_me_option="will be thrown out as
NotImplementedError")

2.6.0


      

1.3.0


      

0.5.19

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

updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. `pyexcel185 <https://github.com/pyexcel/pyexcel/issues/185>`_: handle stream
conversion if file type(html) needs string content then bytes to handle

0.5.18

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

updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. `69 <https://github.com/pyexcel/pyexcel-io/issues/69>`_: Force file
type(force_file_type) on write

0.5.17

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

updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. `68 <https://github.com/pyexcel/pyexcel-io/issues/68>`_: Raise IOError when
the data file does not exist

0.5.16

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

updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. `67 <https://github.com/pyexcel/pyexcel-io/issues/67>`_: fix conversion
issue for long type on python 2.7 for ods

0.5.15

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

updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. `pyexcel-ods33 <https://github.com/pyexcel/pyexcel-ods/issues/33>`_: fix
integer comparision error on i586

0.5.14

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

updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. `65 <https://github.com/pyexcel/pyexcel-io/issues/65>`_: add
tests/__init__.py because python2.7 setup.py test needs it

0.5.13

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

updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

0.5.12

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

updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. `60 <https://github.com/pyexcel/pyexcel-io/issues/60>`_: include tests in
tar ball
. `61 <https://github.com/pyexcel/pyexcel-io/issues/61>`_: enable python
setup.py test

0.5.11

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

updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. `59 <https://github.com/pyexcel/pyexcel-io/issues/59>`_: Please use
scan_plugins_regex, which lml 0.7 complains about

0.5.10

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

added
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. `57 <https://github.com/pyexcel/pyexcel-io/issues/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.

0.5.9.1

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

updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. `53 <https://github.com/pyexcel/pyexcel-io/issues/53>`_, upgrade lml
dependency to at least 0.0.2

0.5.9

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

added
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. `pyexcel148 <https://github.com/pyexcel/pyexcel/issues/148>`_, support
force_file_type

0.5.8

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

added
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. `49 <https://github.com/pyexcel/pyexcel-io/issues/49>`_, support additional
options when detecting float values in csv format. default_float_nan,
ignore_nan_text

0.5.7

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

Added
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

0.5.6

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

Added
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. `24 <https://github.com/pyexcel/pyexcel-xlsx/issues/24>`_, remove deprecated
warning from merged_cell_ranges and get_sheet_by_name

0.5.5

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

Added
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. `22 <https://github.com/pyexcel/pyexcel-xlsx/issues/22>`_, to detect merged
cell in xlsx - fast tracked patreon request.

0.5.4

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

Updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. Align the behavior of skip_hidden_row_and_column. Default it to True.

0.5.3


      

0.5.2

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

updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. pyexcel `pyexcel105 <https://github.com/pyexcel/pyexcel/issues/105>`_,
remove gease from setup_requires, introduced by 0.5.1.
. remove python2.6 test support

0.5.1

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

added
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. `pyexcel103 <https://github.com/pyexcel/pyexcel/issues/103>`_, include
LICENSE file in MANIFEST.in, meaning LICENSE file will appear in the released
tar ball.

0.5.0

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

Updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. put dependency on pyexcel-io 0.5.0, which uses cStringIO instead of StringIO.
Hence, there will be performance boost in handling files in memory.

Removed
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. `18 <https://github.com/pyexcel/pyexcel-xlsx/issues/18>`_, is handled in
pyexcel-io

0.5.0rc1

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

first release
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. read data out from xlsb format but to pyexcel-io's standard



NEWS
====

0.4.5

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

Updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. `80 <https://github.com/pyexcel/pyexcel/issues/80>`_: remove pyexcel-chart
import from v0.4.x

0.4.4

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

Updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. `42 <https://github.com/pyexcel/pyexcel-io/issues/42>`_, raise exception if
database table name does not match the sheet name

0.4.3

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

Updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. `41 <https://github.com/pyexcel/pyexcel-io/issues/41>`_, walk away
gracefully when mmap is not available.

0.4.2

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

updated
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
. pyexcel `105 <https://github.com/pyexcel/pyexcel/issues/105>`_, remove gease
from setup_requires, introduced by 0.4.1.
. remove python2.6 test support

0.4.1

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

added
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

. `103 <https://github.com/pyexcel/pyexcel/issues/103>`_, include LICENSE file
in MANIFEST.in, meaning LICENSE file will appear in the released tar ball.

0.4.0


      

0.3.4

* added CONTRIBUTORS.rst into tar ball

0.3.3

Package name is now changed to pyexcel-ezodf but you do not need to
change your code. You stiil import it as `ezodf`

* `issue 1 <https://github.com/pyexcel/pyexcel-ezodf/issues/1>`_,
stream alike object(except StringIO) cannot be handled
* `issue 3 <https://github.com/pyexcel/pyexcel-ezodf/issues/3>`_,
`ezodf PR 21 <https://github.com/T0ha/ezodf/pull/21>`_ license.rst -> license.txt
* `issue 4 <https://github.com/pyexcel/pyexcel-ezodf/issues/4>`_,
`ezodf PR 20 <https://github.com/T0ha/ezodf/pull/20>`_ cell.value_as()
* `issue 5 <https://github.com/pyexcel/pyexcel-ezodf/issues/5>`_,
`ezodf issue 23 <https://github.com/T0ha/ezodf/pull/23>`_
restore the support for fodt and fods
* `issue 6 <https://github.com/pyexcel/pyexcel-ezodf/issues/6>`_,
`ezodf PR 17 <https://github.com/T0ha/ezodf/pull/17>`_ add Python 3.5 to test matrix
* `PR 18 <https://github.com/T0ha/ezodf/pull/18>`_,
Use cStringIO as default but keep StringIO as optional

0.3.2

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

. Remove the false claim that this library writes xlsm

0.3.1

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

. `1 <https://github.com/pyexcel/pyexcel-xlsxw/issues/1>`_,
Feature request: support Workbook options in XLSXWriter.open()

0.3.0


      

0.2.7

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

Updated:
********************************************************************************

. Read specific data structure from pure json format: two dimensional
array, a dicionary of list or two dimensional list and a list of records.
. Read newline delimited json. two dimensional arrays, a a dicionary of list
or two dimensional list and a list of records are supported.

0.2.6

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

Updated:
********************************************************************************

. Support pyexcel v0.5.0. Plugin interface updated to Renderer
. removed deprecated save_as and save_to_memory functions

0.2.5

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

Updated:
********************************************************************************

0.2.4

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

Added:
********************************************************************************

0.2.3

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

Added:
********************************************************************************

. json format: serialize date and datetime

Updated:
********************************************************************************

. if a sheet has row_names, its json output become records(a list of dictionary)
instead of a dictionary of row name vs the rest of row values.

0.2.2


      

0.2.1

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

0.2.0


      

0.1.7

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

Added
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. Support pyramid-excel which does the database commit on its own.

0.1.6

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

Added
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. get excel data from a http url

0.1.1

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

Updated
********************************************************************************

. `2 <https://github.com/pyexcel/pyexcel-text/issues/2>`_, fix a typo in setup.py

0.1.0

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

Updated
********************************************************************************

0.0.13

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

Added
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. Support django
. texttable as default renderer

0.0.12

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

Updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. Bug fix: excessive trailing columns with empty values

0.0.11

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

Updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. Complete fix for libreoffice datetime field

0.0.10

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

Updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. Bug fix: date field could have datetime from libreoffice

0.0.9


      

0.0.8

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

Updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

0.0.7

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

Updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. Bug fix: "number-columns-repeated" is now respected

0.0.6

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

Updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. get_data and save_data are seen across pyexcel-* extensions. remember them
once and use them across all extensions.

0.0.5

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

Added
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. Loads only one sheet from a multiple sheet book
. Use New BSD License

0.0.4

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

Updated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. IO interface update as pyexcel-io introduced keywords.
. initial release

0.0.3

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

Updated
********************************************************************************

. `1 <https://github.com/pyexcel/pyexcel-text/issues/1>`_, align api interface
with other pyexcel plugins, e.g. save_as, save_book_as

0.0.2

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

Updated
********************************************************************************

0.0.1

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

Initial release