Changelogs » Pyexcel

Pyexcel

20.11.2014

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

Initial release





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


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.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
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. `182 <https://github.com/pyexcel/pyexcel/issues/182>`_: support
dest_force_file_type on save_as and save_book_as

0.5.13

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

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

. `176 <https://github.com/pyexcel/pyexcel/issues/176>`_: get_sheet
{IndexError}list index out of range // XLSX can't be opened

0.5.12

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

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

. `174 <https://github.com/pyexcel/pyexcel/issues/174>`_: include examples in
tarbar

0.5.11


      

0.5.10

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

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

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

0.5.9.1

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

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

0.5.9

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

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

. support __len__. len(book) returns the number of sheets and len(sheet)
returns the number of rows
. `144 <https://github.com/pyexcel/pyexcel/issues/144>`_: memory-efficient way
to read sheet names.
. `148 <https://github.com/pyexcel/pyexcel/issues/148>`_: force_file_type is
introduced. When reading a file on a disk, this parameter allows you to
choose a reader. i.e. csv reader for a text file. xlsx reader for a xlsx file
but with .blob file suffix.
. finally, pyexcel got import pyexcel.__version__

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

. Sheet.to_records() returns a generator now, saving memory
. `115 <https://github.com/pyexcel/pyexcel/issues/115>`_, Fix set membership
test to run faster in python2
. `140 <https://github.com/pyexcel/pyexcel/issues/140>`_, Direct writes to
cells yield weird results

0.5.8

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

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

. `pyexcel151 <https://github.com/pyexcel/pyexcel/issues/151>`_, read cell
error as N/A.

0.5.7

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

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

. `pyexcel54 <https://github.com/pyexcel/pyexcel/issues/54>`_, Book.datemode
attribute of that workbook should be passed always.

0.5.6

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

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

. `32 <https://github.com/pyexcel/pyexcel-ods/issues/32>`_, fix odfpy pinning
. `33 <https://github.com/pyexcel/pyexcel-ods/issues/33>`_, fix
IntegerAccuracyLossError on i586

0.5.5

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

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

. `32 <https://github.com/pyexcel/pyexcel-ods/issues/32>`_, fix odfpy pinning

0.5.4

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

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

. `30 <https://github.com/pyexcel/pyexcel-ods/issues/30>`_, 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.

0.5.3

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

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

. `24 <https://github.com/pyexcel/pyexcel-ods/issues/24>`_, ignore
comments(<office:comment>) in cell
. `27 <https://github.com/pyexcel/pyexcel-ods/issues/27>`_, exception raised
when currency type is missing
. fix odfpy version on 1.3.5.

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.

Relocated
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. All ods type conversion code lives in pyexcel_io.service module

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
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

. `68 <https://github.com/pyexcel/pyexcel/issues/68>`_: regression
save_to_memory() should have returned a stream instance which has been reset
to zero if possible. The exception is sys.stdout, which cannot be reset.
. `74 <https://github.com/pyexcel/pyexcel/issues/74>`_: Not able to handle
decimal.Decimal

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

. remove get_{{file_type}}_stream functions from pyexcel.Sheet and pyexcel.Book
introduced since 0.4.3.

0.4.3

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

. `4 <https://github.com/pyexcel/pyexcel-odsr/issues/4>`_, handle unseekable
stream given by http response.

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

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

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

. pyexcel-io plugin interface now updated to use
`lml <https://github.com/chfw/lml>`_.

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

* Support wheels and python3

0.3.1

* File-like objects utilisation improved

0.3.0

* Maitainer changed
* Simple variables and user fields support added
* Tests system changed to nose
* Travis CI support added
* Python 2.6 - 3.4 support added

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

* Alpha version
* license changed to MIT license
* development stopped - for now

0.2.4

* Alpha version
* can open tables with many repeated rows/cols, 3 opening strategies are supported
* tested: on Win7/Ubuntu 32-Bit with CPython 2.7 and CPython 3.2

0.2.3

* Alpha version
* tested: on Windows7 32 Bit with CPython 2.7 and CPython 3.2

0.2.2

* Alpha version
* Spreadsheet: added cell-span management
* tested with Python 3.2 - OK
* added tobytes() method to all document classes
* opendoc() accept the zip-file content as 'bytes' instead of the filename
as parameter 'filename'
* newdoc() accept the zip-file content as 'bytes' instead of the filename
as parameter 'template'

0.2.1

* Alpha version
* added basic spreadsheet support
* Spreadsheet: added sheet, row, column and cell management

0.2.0

* Alpha version
* create new empty odt, ods, odp, odg file
* added template support - can create ott, ots, otp, otg files
* open documents - ezodf.opendoc(filename)
* create new documents - ezdof.newdoc(doctype, filename, template)
* Text: added Paragraph, Heading, Span, Hyperlink, List, Section objects

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


      

0.1.0

* Pre-Alpha version
* open/saveas ODF documents
* modify meta data


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

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

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

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

. Bug fix: utf-8 string throw unicode exceptions

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
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

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


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

0.0.2

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

Added
********************************************************************************

. turn query sets into a response

0.0.1

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

Initial release