pyexcel v0.3.0 Release Notes

  • โž• Added:

    ๐Ÿ“š #. file type setters for Sheet and Book, and its documentation

    . iget_records returns a generator for a list of records and should have

    better memory performance, especially dealing with large csv files.

    . iget_array returns a generator for a list of two dimensional array and

    should have better memory performance, especially dealing with large csv files. ๐Ÿ‘ #. Enable pagination support, and custom row renderer via pyexcel-io v0.2.3

    โšก๏ธ Updated

    . Take isave_as out from save_as. Hence two functions are there for save a

    sheet as

    . #60 <https://github.com/pyexcel/pyexcel/issues/60>_: encode 'utf-8' if the

    console is of ascii encoding.

    . #59 <https://github.com/pyexcel/pyexcel/issues/59>_: custom row renderer

    . #56 <https://github.com/pyexcel/pyexcel/issues/56>_: set cell value does

    not work

    . pyexcel.transpose becomes pyexcel.sheets.transpose

    . iterator functions of pyexcel.Sheet were converted to generator functions

    • pyexcel.Sheet.enumerate()
    • pyexcel.Sheet.reverse()
    • pyexcel.Sheet.vertical()
    • pyexcel.Sheet.rvertical()
    • pyexcel.Sheet.rows()
    • pyexcel.Sheet.rrows()
    • pyexcel.Sheet.columns()
    • pyexcel.Sheet.rcolumns()
    • pyexcel.Sheet.named_rows()
    • pyexcel.Sheet.named_columns()

    . ~pyexcel.Sheet.save_to_memory and ~pyexcel.Book.save_to_memory return the

    actual content. No longer they will return a io object hence you cannot call getvalue() on them.

    โœ‚ Removed:

    . content and out_file as function parameters to the signature functions

    are no longer supported. ๐Ÿšš #. SourceFactory and RendererFactory are removed ๐Ÿšš #. The following methods are removed

    • pyexcel.to_array
    • pyexcel.to_dict
    • pyexcel.utils.to_one_dimensional_array
    • pyexcel.dict_to_array
    • pyexcel.from_records
    • pyexcel.to_records

    ๐Ÿšš #. pyexcel.Sheet.filter has been re-implemented and all filters were removed:

    • pyexcel.filters.ColumnIndexFilter
    • pyexcel.filters.ColumnFilter
    • pyexcel.filters.RowFilter
    • pyexcel.filters.EvenColumnFilter
    • pyexcel.filters.OddColumnFilter
    • pyexcel.filters.EvenRowFilter
    • pyexcel.filters.OddRowFilter
    • pyexcel.filters.RowIndexFilter
    • pyexcel.filters.SingleColumnFilter
    • pyexcel.filters.RowValueFilter
    • pyexcel.filters.NamedRowValueFilter
    • pyexcel.filters.ColumnValueFilter
    • pyexcel.filters.NamedColumnValueFilter
    • pyexcel.filters.SingleRowFilter

    ๐Ÿšš #. the following functions have been removed

    • add_formatter
    • remove_formatter
    • clear_formatters
    • freeze_formatters
    • add_filter
    • remove_filter
    • clear_filters
    • freeze_formatters

    ๐Ÿšš #. pyexcel.Sheet.filter has been re-implemented and all filters were removed:

    • pyexcel.formatters.SheetFormatter