Database: Support data import to and export from Django

• Support Django models
• Externalized texttable
• bug fixes on save_as where file_type should be dest_file_type, session should be dest_session, table should be dest_table, and save_book_as where file_type should be dest_file_type, session should be dest_session, tables should be dest_tables,
• bug fix on load_from_sql where index of bound exception could be raised

Database: Support data import to and export from

1. Data export from database:

   a. Export data tables as an Excel Book
   b. Export a single table as a single sheet Book or a single csv file.

2. Import data into database:

   a. Import a single sheet into a database table
   b. Import multiple sheet book to database tables: one sheet per table
   c. Import data that contains one to many relationship to database tables.

3. Simpler interface to write data structures to file system, memory and databases and vice versa.

Maintenance Update

• Bug fix:
  • Fix leaked bug in csv module in python 3.
  • Date type in representation would crash unless text type is handed over to texttable
• New Features:
  • cherry pick a named or indexed columns or rows to be deleted
  • select rows or columns to be kept
  • load_from_dict, load_from_records were added

Read/Write multiple sheet excel in csvz and tsvz format

• Read/Write mutiple sheets in csvz and tsvz format
• Bug fix(Issue#3): sheet name is kept if a single sheet is saved as any other supported formats than csv and tsv.
• Being able to cut and paste content

Load from SQL

• pyexcel.load_from_sql(session, table) would help you get your database table into any of the supported excel formats, as well as rst, json
• early preview of region(copy), cut, and paste functionalities
• series names are made unique. When two name should be the same, the second one is appended "-1".
• support for zipped csv and tsv formats

Zero dependencies and more plugins

Now users of pyexcel have to install plugins for the file formats they are handling. For xls, xlsm and xlsx support, please install pyexcel-xl.

• text presentation is added and external presentation hook is added
• pyexcel-text plugin is created to allow richer text presentation
• xlwt and xlrd dependecies moved to pyexcel-xl

Developer friendly API

• Re-organized code surrounding two core classes: Sheet and Book
• SeriesReader, Reader and BookReader are now deprecated.
• Examples in documents were mostly tested.
• Use any row or column to make SeriesReader
• Use both row and column would lead to a dataframe.
• Bug fix to support tsv and other csv dialets. Thank goes to jnothman.

Support for StringIO and row and column based manipulations

• Support for reading from and writing to StringIO
• Matrix.row, Matrix.column were made to represent row and column respectively, e.g. m.row[0] refers to the first row of the matrix
• Static formatter and fitler feature

Add missing support for CSV dialect and utf-8

• Support custom CSV dialect, e.g. delimiter, quotechar
• Support UTF-8 csv files
• Support Sheet.set_named_column_at(..) in addition to Matrix.set_column_at (..)

Python 3 Support

• Python 3.4 and 3.3 are supported as the test succeeds
• Pypy is supported as test succeeds
• It is possible to do book merge like this: book3 = book1 + book2
• Plugin supported as ods is spawn out as an external plugin, because odfpy does not support py3