Recent Releases of pyexcel
pyexcel - drop chardet as requirement
see change log for more details
- Python
Published by chfw over 1 year ago
pyexcel - Maintenance release
dropped the support for pyexcel.ext.* fixed #250
- Python
Published by chfw about 4 years ago
pyexcel - Add chardet as explicit dependency
No material change apart from saving you from the failure to use csvz with chardet.
- Python
Published by chfw over 4 years ago
pyexcel - Maintenance release to work with pyexcel-io 0.6.2 update
Queryset sources was updated to work with pyexcel-io.
Meaning: if you pass on a query set to pyexcel, you would expect this version to keep our promise, given that you have installed pyexcel-io 0.6.2
- Python
Published by chfw over 5 years ago
pyexcel - Maintenance release
delivers #219 and some minor documentation updates.
- Python
Published by chfw over 5 years ago
pyexcel - Breaking release
Permanently dropped python 2 support.
Delivered #214.
- Python
Published by chfw over 5 years ago
pyexcel - Emergency fix
0.6.0 will fail some of pyexcel users who uses interactive shell to print out a sheet or table.
- Python
Published by chfw almost 6 years ago
pyexcel - Python 3.6+ release
This release will draw the line between python 2 and python 3.
see change log for more details
- Python
Published by chfw almost 6 years ago
pyexcel - maintenance release
include version limit on pyexcel-io v0.5.19, to solve #185 . if you use python 2, no need to take action. for python3 users, if you use http source, you will need this upgrade. otherwise, it is unlikely you get affected.
- Python
Published by chfw over 6 years ago
pyexcel - Maintenance release
fix #100
and bring pyexce-io v0.5.1 with pyexcel 0.5.4.
- Python
Published by chfw over 8 years ago
pyexcel - enable pyexcel-htmlr with http source
with pyexcel-cli, 'pyexcel view https://nssdc.gsfc.nasa.gov/planetary/factsheet/' would work out of box
- Python
Published by chfw over 8 years ago
pyexcel - Quick fix for 0.5.1
Due to a test miss in django-excel, some code was left dangling.
- Python
Published by chfw over 8 years ago
pyexcel - Maintenance release
support isaveas and isavebookas to import data into sqlalchemy table and django models. This is an enabler for pyexcel-webio's isavetodatabase and isavebooktodatabase.
- Python
Published by chfw over 8 years ago
pyexcel - Major plugin interface update
See more details in changelog
- Python
Published by chfw over 8 years ago
pyexcel - Maintenance release
68 #74
more details in change log.
- Python
Published by chfw about 9 years ago
pyexcel - Maintenance release
Proper response to #68, exposing internal stream to outside world and user could choose stream type using dot format.
- Python
Published by chfw about 9 years ago
pyexcel - Maintenance release
. raise exception when saving sheet with row names into database. simply transpose it and use column names, will work around it.
. fix array, dict and record source so that they inherit pyexcel-io's sheet interface. in other words, startrow, rowlimit etc. could be applied to those three sources.
. #69 provide clearer documentation for signature functions.
- Python
Published by chfw about 9 years ago
pyexcel - support lazy loading
see change log for details
- Python
Published by chfw about 9 years ago
pyexcel - File type as Sheet/Book attribute
Major release. 1. Formatting, Filtering and Iterator were reduced to minimum. 2. File type as Sheet/Book attribute 3. bug fixes
Details are in change log.
- Python
Published by chfw over 9 years ago
pyexcel - followup bug fix for 0.2.3
pyexcel-cli in python raise IOError when transcoding to sys.stdout
- Python
Published by chfw over 9 years ago
pyexcel - support pyexcel-cli
see changelog.rst for details.
- Python
Published by chfw over 9 years ago
pyexcel - Maintenance release for 0.2.0
Added:
- add pyexcel-text file types as attributes of pyexcel.Sheet and pyexcel.Book, related to #31
- auto import pyexcel-text if it is pip installed
Updated:
- code refactored sources for easy addition of sources.
- bug fix #29 , Even if the format is a string it is displayed as a float
- pyexcel-text is no longer a plugin to pyexcel-io but to pyexcel.sources, see https://github.com/pyexcel/pyexcel-text/issues/22
Removed:
- pyexcel.presentation is removed. No longer the internal decorate @outsource is used. related to #31
- Python
Published by chfw almost 10 years ago
pyexcel - Performance release
adapt pyexcel-io 0.1.0 which uses yield keyword
- Python
Published by chfw almost 10 years ago
pyexcel - Performance optimization release
- the performance optimization is surrounding 'yield' keyword to mimize overhead brought by pyexcel
- This release introduces compatibility break for those who use Writer and BookWriter. Please read the migration guide
- To evaluate it, you will need 0.1.0-rc1 releases of pyexcel-io and its plugins.
- Please try it and give me your feedback.
- Python
Published by chfw about 10 years ago
pyexcel - Support for pyramid-excel
pass "auto_commit" option for pyexcel-io
- Python
Published by chfw over 10 years ago
pyexcel - Get data from a url source
- 'url' option is enabled for getters and saver functions. Note that no write to http source.
- optmized sheet.format function and formatters module so that either variable type or a custom function are feed in.
- Python
Published by chfw over 10 years ago
pyexcel - Make a sheet from database query
- Make a sheet from database query
- database related parameters in getter and saver functions are changed
- Python
Published by chfw almost 11 years ago
pyexcel - Optimization for loading single sheet from a multiple book
- Loads only one sheet from a multiple sheet book
- Use New BSD License
- Bug fix on #9
- Python
Published by chfw almost 11 years ago
pyexcel - Database: Support data import to and export from Django
- Support Django models
- Externalized texttable
- bug fixes on saveas where filetype should be destfiletype, session should be destsession, table should be desttable, and savebookas where filetype should be destfiletype, session should be destsession, tables should be dest_tables,
- bug fix on loadfromsql where index of bound exception could be raised
- Python
Published by chfw about 11 years ago
pyexcel - Database: Support data import to and export from
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.
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.
Simpler interface to write data structures to file system, memory and databases and vice versa.
- Python
Published by chfw about 11 years ago
pyexcel - 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
- loadfromdict, loadfromrecords were added
- Python
Published by chfw about 11 years ago
pyexcel - 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
- Python
Published by chfw about 11 years ago
pyexcel - Load from SQL
- pyexcel.loadfromsql(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
- Python
Published by chfw about 11 years ago
pyexcel - 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
- Python
Published by chfw about 11 years ago
pyexcel - 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.
- Python
Published by chfw over 11 years ago
pyexcel - 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
- Python
Published by chfw over 11 years ago
pyexcel - Add missing support for CSV dialect and utf-8
- Support custom CSV dialect, e.g. delimiter, quotechar
- Support UTF-8 csv files
- Support Sheet.setnamedcolumnat(..) in addition to Matrix.setcolumn_at (..)
- Python
Published by chfw over 11 years ago
pyexcel - 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
- Python
Published by chfw over 11 years ago
pyexcel - Formatting Support
This release support custom formatting for rows, columns or the whole sheet
- xls date formatted value will be rendered as date or time instances.
- Convert cell values to known formats: int, float, string
- Custom format handler can be easily added
- The scope can be individial column, row or the whole sheet
- Python
Published by chfw over 11 years ago
pyexcel - Support Multiple Sheets
- Excel Book Writer and Reader
- Merge sheets into one Excel Book
- Split an Excel Book into individual files
- Python
Published by chfw over 11 years ago
pyexcel - One milestone in reading, writing different sheets via one common interface.
Features: 1. read and write csv, ods, xls, xlsx and xlsm files(which are referred later as excel files) 2. various iterators for the reader 3. row and column filters for the reader 4. utilities to get array and dictionary out from excel files. 5. cookbok receipes for some common and simple usage of this library.
- Python
Published by chfw over 11 years ago