========
xlutils
========
This package provides a collection of utilities for working with Excel
files. Since these utilities may require either or both of the xlrd
and xlwt packages, they are collected together seperately here.
Installation
============
The easyiest way to install xlutils is:
easy_install xlutils
Or, if you're using zc.buildout, just specify 'xlutils' as
a required egg.
However, you can also install in the usual python fashion of unpacking
the source distribution and running::
python setup.py install
If you do not install using easy_install or zc.buildout, you will
also need to make sure the following python packages are available
on your PYTHONPATH:
- **xlrd**
This can be found here:
http://pypi.python.org/pypi/xlrd
- **xlwt**
This can be found here:
http://pypi.python.org/pypi/xlwt
- **errorhandler**
This can be found here:
http://pypi.python.org/pypi/errorhandler
This package is only required if you wish to use
xlutils.filter.ErrorFilter.
The Utilities
=============
Each of the utilities in described in its own file found in the 'docs'
directory of the package:
*copy.txt*
Tools for copying xlrd.Book objects to xlwt.Workbook objects.
*display.txt*
Utility functions for displaying information about xlrd-related
objects in a user-friendly and safe fashion.
*filter.txt*
A mini framework for splitting and filtering Excel files into new
Excel files.
*margins.txt*
Tools for finding how much of an Excel file contains useful data.
*save.txt*
Tools for serializing xlrd.Book objects back to Excel files.
*styles.txt*
Tools for working with formatting information expressed in styles.
Development and Testing
=======================
If you wish to develop or add utilities, please see the documentation
in the comment at the top of buildout.cfg in the subversion
repository for details of how to set up an appropriate buildout and
run the tests.
The subversion repository lives here:
https://secure.simplistix.co.uk/svn/xlutils/
Licensing
=========
Copyright (c) 2008-2009 Simplistix Ltd
This Software is released under the MIT License:
http://www.opensource.org/licenses/mit-license.html
See license.txt for more details.
Credits
=======
**Chris Withers**
Inception and development
**John Machin**
The excellent xlrd and xlwt libraries
Changes
=======
1.5.1 (5 March 2012)
--------------------
- Include non-.py files that got skipped as a result of the move from
subversion to git.
1.5.0 (5 March 2012)
--------------------
- Take advantage of "ragged rows" optimisation in xlrd 0.7.3
- Add support for PANE records to xlutils.copy, which means that zoom
factors are now copied.
1.4.1 (6 September 2009)
------------------------
- Removal of references in the `finish` methods of several filters,
easing memory usage in large filtering runs
- Speed optimisations for xlutils.filter.BaseFilter, bringing those
benefits to all subclasses.
- Memory usage reduction when using MemoryLogger
1.4.0 (18 August 2009)
----------------------
- Add sheet density information and onesheet option to
xlutils.margins.
- Reduced the memory footprint of xlutils.filter.ColumnTrimmer at the
expense of speed.
- Fixed incorrect warnings about boolean cells in
xlutils.filter.ErrorFilter. xlwt has always supported boolean
cells.
- xlutils.filter.BaseReader now opens workbooks with on_demand = True
- Added support for xlrd Books opened with on_demand as True passed to
open_workbook.
- Fixed bug when copying error cells.
- Requires the latest versions of xlrd (0.7.1) and xlwt (0.7.2).
1.3.2 (18 June 2009)
-------------------
- Made installation work when `setuptools` isn't present.
- Made `errorhandler` an optional dependency.
1.3.1 (22 May 2009)
-------------------
- In xlutils.styles, handle there case where two names were mapped to the
same xfi, but the first one was empty.
1.3.0 (18 Mar 2009)
-------------------
- fix bug that cause BaseWriter to raise exceptions when handling
source workbooks opened by xlrd 0.7.0 and above where
formatting_info had been passed as False
- add xlutils.copy
1.2.1 (19 Dec 2008)
-------------------
- add extremely limited formatting_info support to DummyBook and TestReader
- move to testfixtures 1.5.3 for tests
1.2.0 (10 Dec 2008)
-------------------
- add and implement `start` method to components in xlutils.filter.
- fixed bug when using set_rdsheet with ColumnTrimmer.
- improved installation documentation.
- renamed xlutils.styles.CellStyle to more appropriate
xlutils.styles.NamedStyle.
- improved documentation for xlutils.styles.
- moved to using TestFixtures and Mock for tests.
- moved to using ErrorHandler rather than duplicating code.
1.1.1 (20 Nov 2008)
-------------------
- prevented generation of excessively long sheet names that cause
Excel to complain.
- added test that will fail if the filesystem used doesn't support
filenames with +'s in them.
1.1.0 (14 Nov 2008)
-------------------
- link to the documentation for xlutils.display
- tighten up version requirements for xlrd and xlwt
- use style compression in xlutils.filter.BaseWriter
- prevent generation of bogus sheet names in xlutils.filter.BaseWriter
- xlutils.filter.BaseFilter now keeps track of rdbook, simplifying the
implementation of filters.
- add another example for xlutils.filter
- add xlutils.filter.XLRDReader
- add xlutils.filter.StreamWriter
- add xlutils.styles
- add xlutils.save
1.0.0 (8 Nov 2008)
------------------
- initial public release
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
Python Excel读写库.rar (75个子文件)
Python Excel读写库
xlrd xlwt python
xlrd-0.7.1.win32.exe 306KB
xlwt-0.7.2.win32.exe 188KB
xlutils-1.4.1.win32.exe 111KB
xlutils-1.5.2
xlutils-1.5.2
PKG-INFO 3KB
xlutils
styles.py 1KB
save.py 680B
copy.py 370B
docs
styles.txt 2KB
copy.txt 1KB
display.txt 2KB
save.txt 534B
description.txt 2KB
filter.txt 19KB
margins.txt 5KB
display.py 1KB
license.txt 1KB
tests
test_copy.py 1KB
test_filter.py 53KB
date.xls 18KB
fixtures.py 2KB
test.xls 63KB
test_docs.py 1KB
testnoformatting.xls 6KB
ragged.xls 6KB
test_styles.py 2KB
__init__.py 179B
testall.xls 7KB
test_save.py 2KB
version.txt 6B
margins.py 7KB
__init__.py 179B
filter.py 29KB
readme.txt 5KB
bootstrap.py 2KB
dist
xlutils-1.5.2-py2.7.egg 91KB
setup.cfg 59B
setup.py 2KB
.gitignore 121B
xlutils.egg-info
PKG-INFO 3KB
requires.txt 75B
not-zip-safe 1B
SOURCES.txt 952B
entry_points.txt 50B
top_level.txt 8B
dependency_links.txt 1B
buildout.cfg 507B
build
bdist.win32
lib
xlutils
styles.py 1KB
save.py 680B
copy.py 370B
docs
styles.txt 2KB
copy.txt 1KB
display.txt 2KB
save.txt 534B
description.txt 2KB
filter.txt 19KB
margins.txt 5KB
display.py 1KB
license.txt 1KB
tests
test_copy.py 1KB
test_filter.py 53KB
date.xls 18KB
fixtures.py 2KB
test.xls 63KB
test_docs.py 1KB
testnoformatting.xls 6KB
ragged.xls 6KB
test_styles.py 2KB
__init__.py 179B
testall.xls 7KB
test_save.py 2KB
version.txt 6B
margins.py 7KB
__init__.py 179B
filter.py 29KB
readme.txt 5KB
共 75 条
- 1
资源评论
tangcpp
- 粉丝: 1
- 资源: 6
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功