From c219972ccdf70c7ba0d4762e222b5404f3794b2e Mon Sep 17 00:00:00 2001 From: Kenneth Reitz Date: Fri, 18 Feb 2011 04:28:50 -0500 Subject: added pypy location to tox config --- tox.ini | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/tox.ini b/tox.ini index 9cef9b3..ba10930 100644 --- a/tox.ini +++ b/tox.ini @@ -4,6 +4,8 @@ envlist = py24,py25,py26,py27 [testenv] commands=py.test --junitxml=junit-{envname}.xml deps = - nose simplejson - pytest \ No newline at end of file + pytest + +[testenv:pypy] +basepython=/usr/bin/pypy-c -- cgit v1.2.1 From bccf0d1ba1adac259e0ffe5687455f6aadade7fd Mon Sep 17 00:00:00 2001 From: Kenneth Reitz Date: Fri, 18 Feb 2011 04:37:00 -0500 Subject: no more test suite. --- test_suite.sh | 5 ----- 1 file changed, 5 deletions(-) delete mode 100755 test_suite.sh diff --git a/test_suite.sh b/test_suite.sh deleted file mode 100755 index 5a1e7be..0000000 --- a/test_suite.sh +++ /dev/null @@ -1,5 +0,0 @@ -rm -fr nosetests.xml -tox -# coverage xml -rm -fr pylint.txt -# pylint -d W0312 -d W0212 -d E1101 -d E0202 -d W0102 -d E0102 -f parseable ./tablib > pylint.txt || true \ No newline at end of file -- cgit v1.2.1 From c2331f7a23ff0531d96baeb79e8769e5531c986c Mon Sep 17 00:00:00 2001 From: Kenneth Reitz Date: Mon, 21 Feb 2011 02:11:59 -0500 Subject: Updated pythons list. --- docs/intro.rst | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/docs/intro.rst b/docs/intro.rst index c2d75b2..9a00a8e 100644 --- a/docs/intro.rst +++ b/docs/intro.rst @@ -44,8 +44,10 @@ Pythons Supported At this time, the following Python platforms are officially supported: -* Python 2.6 -* Python 2.7 +* cPython 2.5 +* cPython 2.6 +* cPython 2.7 +* PyPy-c 1.4 Support for other Pythons will be rolled out soon. -- cgit v1.2.1 From 1cf9bd14b451fd56c06416fde71ee5f8bc0beef2 Mon Sep 17 00:00:00 2001 From: Kenneth Reitz Date: Mon, 21 Feb 2011 02:12:41 -0500 Subject: ci.kennethreitz.com now --- docs/development.rst | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/docs/development.rst b/docs/development.rst index 77af330..6255d5e 100644 --- a/docs/development.rst +++ b/docs/development.rst @@ -87,7 +87,7 @@ Adding New Formats Tablib welcomes new format additions! Format suggestions include: -* Tab Seperated Values +* Tab Separated Values * MySQL Dump * HTML Table @@ -178,7 +178,7 @@ Every commit made to the **develop** branch is automatically tested and inspecte Anyone may view the build status and history at any time. - http://git.kennethreitz.com/ci/ + http://ci.kennethreitz.com/ If you are trustworthy and plan to contribute to tablib on a regular basis, please contact `Kenneth Reitz`_ to get an account on the Hudson Server. -- cgit v1.2.1 From 23c183114433f69415431c498d799b78b7f688f0 Mon Sep 17 00:00:00 2001 From: Kenneth Reitz Date: Mon, 21 Feb 2011 02:15:00 -0500 Subject: Added HACKING file. --- HACKING | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 HACKING diff --git a/HACKING b/HACKING new file mode 100644 index 0000000..018f9b7 --- /dev/null +++ b/HACKING @@ -0,0 +1,14 @@ +Where possible, please follow PEP8 with regard to coding style. Sometimes the line +length restriction is too hard to follow, so don't bend over backwards there. + +Triple-quotes should always be """, single quotes are ' unless using " +would result in less escaping within the string. + +All modules, functions, and methods should be well documented reStructuredText for +Sphinx AutoDoc. + +All functionality should be available in pure Python. Optional C (via Cython) +implementations may be written for performance reasons, but should never +replace the Python implementation. + +Lastly, don't take yourself too seriously :) \ No newline at end of file -- cgit v1.2.1 From 9ab277a4682546b64363ba308ef551fde3c4051d Mon Sep 17 00:00:00 2001 From: Kenneth Reitz Date: Mon, 21 Feb 2011 02:32:20 -0500 Subject: docs: Python 2.5 is supported now. --- docs/install.rst | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/docs/install.rst b/docs/install.rst index 9b9a519..b6c3f31 100644 --- a/docs/install.rst +++ b/docs/install.rst @@ -55,7 +55,7 @@ However, if performance is important to you (and it should be), you can install $ pip install PyYAML -If you're using Python 2.5 (currently unsupported), you should also install the **simplejson** module. If you're using Python 2.6+, the built-in **json** module is already optimized and in use. :: +If you're using Python 2.5, you should also install the **simplejson** module (pip will do this for you). If you're using Python 2.6+, the built-in **json** module is already optimized and in use. :: $ pip install simplejson -- cgit v1.2.1 From d11c09febefbe6150f4e5b168d46970b232ee452 Mon Sep 17 00:00:00 2001 From: Kenneth Reitz Date: Mon, 21 Feb 2011 02:37:29 -0500 Subject: Added License text. --- docs/intro.rst | 25 +++++++++++++++++++++++++ 1 file changed, 25 insertions(+) diff --git a/docs/intro.rst b/docs/intro.rst index 9a00a8e..bc4256a 100644 --- a/docs/intro.rst +++ b/docs/intro.rst @@ -36,6 +36,31 @@ Tablib is released under terms of `The MIT License`_. .. _`The MIT License`: http://www.opensource.org/licenses/mit-license.php +.. _license: + +Tablib License +-------------- + +Copyright (c) 2011 Kenneth Reitz. + +Permission is hereby granted, free of charge, to any person obtaining a copy +of this software and associated documentation files (the "Software"), to deal +in the Software without restriction, including without limitation the rights +to use, copy, modify, merge, publish, distribute, sublicense, and/or sell +copies of the Software, and to permit persons to whom the Software is +furnished to do so, subject to the following conditions: + +The above copyright notice and this permission notice shall be included in +all copies or substantial portions of the Software. + +THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR +IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, +FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE +AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER +LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, +OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN +THE SOFTWARE. + .. _pythonsupport: -- cgit v1.2.1 From 76f09cd3b35f8cda1a8f081d81fd0f83d19fd2e0 Mon Sep 17 00:00:00 2001 From: Kenneth Reitz Date: Mon, 21 Feb 2011 02:37:53 -0500 Subject: Added release number to documentation. --- docs/index.rst | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/docs/index.rst b/docs/index.rst index 4726d7b..77ce7cf 100644 --- a/docs/index.rst +++ b/docs/index.rst @@ -3,8 +3,10 @@ You can adapt this file completely to your liking, but it should at least contain the root `toctree` directive. -Tablib: Pythonic Tabular Data -============================= +Tablib: Pythonic Tabular Datasets +================================= + +Release |version|. .. Contents: .. -- cgit v1.2.1 From 22cddbcd6354dc87af9b2797849329a20500966b Mon Sep 17 00:00:00 2001 From: Kenneth Reitz Date: Mon, 21 Feb 2011 02:55:24 -0500 Subject: well then --- hi | 0 1 file changed, 0 insertions(+), 0 deletions(-) create mode 100644 hi diff --git a/hi b/hi new file mode 100644 index 0000000..e69de29 -- cgit v1.2.1 From e1734f2315bdb87f894911b1e031de39e7297bb6 Mon Sep 17 00:00:00 2001 From: Kenneth Reitz Date: Mon, 21 Feb 2011 14:07:42 -0500 Subject: added __docformat__ --- hi | 0 tablib/core.py | 1 + 2 files changed, 1 insertion(+) delete mode 100644 hi diff --git a/hi b/hi deleted file mode 100644 index e69de29..0000000 diff --git a/tablib/core.py b/tablib/core.py index dfbcb6a..548de55 100644 --- a/tablib/core.py +++ b/tablib/core.py @@ -26,6 +26,7 @@ __build__ = 0x000904 __author__ = 'Kenneth Reitz' __license__ = 'MIT' __copyright__ = 'Copyright 2011 Kenneth Reitz' +__docformat__ = 'restructuredtext' class Row(object): -- cgit v1.2.1 From 2f331cee8ece577b54644efb7e2219ed61d75380 Mon Sep 17 00:00:00 2001 From: Igor Davydenko Date: Tue, 1 Mar 2011 19:36:19 +0200 Subject: Fix #24, add support of spaces in CSV files. --- tablib/formats/_csv.py | 2 +- test_tablib.py | 13 +++++++++++++ 2 files changed, 14 insertions(+), 1 deletion(-) diff --git a/tablib/formats/_csv.py b/tablib/formats/_csv.py index 2c74a1c..b71755b 100644 --- a/tablib/formats/_csv.py +++ b/tablib/formats/_csv.py @@ -31,7 +31,7 @@ def import_set(dset, in_stream, headers=True): dset.wipe() - rows = csv.reader(in_stream.split()) + rows = csv.reader(in_stream.splitlines()) for i, row in enumerate(rows): if (i == 0) and (headers): diff --git a/test_tablib.py b/test_tablib.py index e4a4d11..4079809 100755 --- a/test_tablib.py +++ b/test_tablib.py @@ -295,6 +295,19 @@ class TablibTestCase(unittest.TestCase): self.assertEqual(_csv, data.csv) + def test_csv_import_set_with_spaces(self): + """Generate and import CSV set serialization when row values have + spaces.""" + data.append(('Bill Gates', 'Microsoft')) + data.append(('Steve Jobs', 'Apple')) + data.headers = ('Name', 'Company') + + _csv = data.csv + + data.csv = _csv + + self.assertEqual(_csv, data.csv) + def test_tsv_import_set(self): """Generate and import TSV set serialization.""" data.append(self.john) -- cgit v1.2.1 From c8493ff047ddfbfa9d0231cd395d3645faedce80 Mon Sep 17 00:00:00 2001 From: Matthew Hooker Date: Tue, 22 Mar 2011 17:12:02 -0400 Subject: fixes issue #38: python 2.5 support --- tablib/helpers.py | 1 + 1 file changed, 1 insertion(+) diff --git a/tablib/helpers.py b/tablib/helpers.py index 718d159..f8a5351 100644 --- a/tablib/helpers.py +++ b/tablib/helpers.py @@ -2,6 +2,7 @@ """ Tablib - General Helpers. """ +from __future__ import with_statement import sys -- cgit v1.2.1 From e8ba7654263c1f3cddfe63dea3d282a739c9778f Mon Sep 17 00:00:00 2001 From: Kenneth Reitz Date: Wed, 23 Mar 2011 00:03:33 -0400 Subject: tablib.helpers is not longer needed :cake: --- tablib/helpers.py | 38 -------------------------------------- 1 file changed, 38 deletions(-) delete mode 100644 tablib/helpers.py diff --git a/tablib/helpers.py b/tablib/helpers.py deleted file mode 100644 index f8a5351..0000000 --- a/tablib/helpers.py +++ /dev/null @@ -1,38 +0,0 @@ -# -*- coding: utf-8 -*- - -""" Tablib - General Helpers. -""" -from __future__ import with_statement - -import sys - - -class Struct(object): - """Your attributes are belong to us.""" - - def __init__(self, **entries): - self.__dict__.update(entries) - - def __getitem__(self, key): - return getattr(self, key, None) - - def dictionary(self): - """Returns dictionary representation of object.""" - return self.__dict__ - - def items(self): - """Returns items within object.""" - return self.__dict__.items() - - def keys(self): - """Returns keys within object.""" - return self.__dict__.keys() - - - -def piped(): - """Returns piped input via stdin, else False.""" - with sys.stdin as stdin: - # TTY is only way to detect if stdin contains data - return stdin.read() if not stdin.isatty() else None - -- cgit v1.2.1 From 8b5b29fc90ca4e222b2f2e9c0ceb6038b53fb0d6 Mon Sep 17 00:00:00 2001 From: Kenneth Reitz Date: Wed, 23 Mar 2011 00:20:39 -0400 Subject: added Dataset.add_formatter --- tablib/core.py | 26 ++++++++++++++++++++++++++ 1 file changed, 26 insertions(+) diff --git a/tablib/core.py b/tablib/core.py index 548de55..0915ee3 100644 --- a/tablib/core.py +++ b/tablib/core.py @@ -137,6 +137,9 @@ class Dataset(object): # ('title', index) tuples self._separators = [] + + # (column, callback) tuples + self._formatters = [] try: self.headers = kwargs['headers'] @@ -386,6 +389,7 @@ class Dataset(object): """ pass + @property def tsv(): """A TSV representation of the :class:`Dataset` object. The top row will contain @@ -470,6 +474,26 @@ class Dataset(object): self.insert_separator(index, text) + def add_formatter(col, handler): + """Adds a :ref:`formatter` to the :class:`Dataset`. + + .. versionadded:: 0.9.5 + :param col: column to. Accepts index int or header str. + :param handler: reference to callback function to execute + against each cell value. + """ + + if isinstance(col, basestring): + if col in self.headers: + col = self.headers.index(key) # get 'key' index from each data + else: + raise KeyError + + self._formatters.append((col, handler)) + + return True + + def insert(self, index, row=None, col=None, header=None, tags=list()): """Inserts a row or column to the :class:`Dataset` at the given index. @@ -659,12 +683,14 @@ class Dataset(object): return _dset + def wipe(self): """Removes all content and headers from the :class:`Dataset` object.""" self._data = list() self.__headers = None + class Databook(object): """A book of :class:`Dataset` objects. """ -- cgit v1.2.1 From 3803a7a21b68633b0e54c6c01824647973ffa95d Mon Sep 17 00:00:00 2001 From: Kenneth Reitz Date: Wed, 23 Mar 2011 00:32:56 -0400 Subject: formatter execution in place upon export --- tablib/core.py | 21 +++++++++++++++++---- 1 file changed, 17 insertions(+), 4 deletions(-) diff --git a/tablib/core.py b/tablib/core.py index 0915ee3..6c17bc3 100644 --- a/tablib/core.py +++ b/tablib/core.py @@ -240,13 +240,26 @@ class Dataset(object): def _package(self, dicts=True): """Packages Dataset into lists of dictionaries for transmission.""" + _data = list(self._data) + + # Execute formatters + if self._formatters: + for row_i, row in enumerate(_data): + for col, callback in self._formatters: + if col is None: + for j, c in enumerate(row): + _data[row_i][j] = callback(c) + else: + _data[row_i][col] = callback(row[col]) + + if self.headers: if dicts: - data = [OrderedDict(zip(self.headers, data_row)) for data_row in self ._data] + data = [OrderedDict(zip(self.headers, data_row)) for data_row in _data] else: - data = [list(self.headers)] + list(self._data) + data = [list(self.headers)] + list(_data) else: - data = [list(row) for row in self._data] + data = [list(row) for row in _data] return data @@ -474,7 +487,7 @@ class Dataset(object): self.insert_separator(index, text) - def add_formatter(col, handler): + def add_formatter(self, col, handler): """Adds a :ref:`formatter` to the :class:`Dataset`. .. versionadded:: 0.9.5 -- cgit v1.2.1 From 65c73dfc42ec2012dcc5c91dff43de25936095b1 Mon Sep 17 00:00:00 2001 From: Kenneth Reitz Date: Wed, 23 Mar 2011 00:38:45 -0400 Subject: do some internal validation for adding formatters --- tablib/core.py | 25 +++++++++++++++++-------- 1 file changed, 17 insertions(+), 8 deletions(-) diff --git a/tablib/core.py b/tablib/core.py index 6c17bc3..c4efce3 100644 --- a/tablib/core.py +++ b/tablib/core.py @@ -246,12 +246,15 @@ class Dataset(object): if self._formatters: for row_i, row in enumerate(_data): for col, callback in self._formatters: - if col is None: - for j, c in enumerate(row): - _data[row_i][j] = callback(c) - else: - _data[row_i][col] = callback(row[col]) - + try: + if col is None: + for j, c in enumerate(row): + _data[row_i][j] = callback(c) + else: + _data[row_i][col] = callback(row[col]) + except IndexError: + raise InvalidDatasetIndex + if self.headers: if dicts: @@ -501,8 +504,11 @@ class Dataset(object): col = self.headers.index(key) # get 'key' index from each data else: raise KeyError - - self._formatters.append((col, handler)) + + if not col > self.width: + self._formatters.append((col, handler)) + else: + raise InvalidDatasetIndex return True @@ -798,6 +804,9 @@ class InvalidDatasetType(Exception): class InvalidDimensions(Exception): "Invalid size" + +class InvalidDatasetIndex(Exception): + "Outside of Dataset size" class HeadersNeeded(Exception): "Header parameter must be given when appending a column in this Dataset." -- cgit v1.2.1 From 2d2ac9b708a44bd7d6e22752c2afa71d1d848e3b Mon Sep 17 00:00:00 2001 From: Kenneth Reitz Date: Wed, 23 Mar 2011 00:49:25 -0400 Subject: col not key --- tablib/core.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/tablib/core.py b/tablib/core.py index c4efce3..69a684b 100644 --- a/tablib/core.py +++ b/tablib/core.py @@ -501,7 +501,7 @@ class Dataset(object): if isinstance(col, basestring): if col in self.headers: - col = self.headers.index(key) # get 'key' index from each data + col = self.headers.index(col) # get 'key' index from each data else: raise KeyError -- cgit v1.2.1 From dc14a16e04a526b8c2f5a978d8b094760aca05ed Mon Sep 17 00:00:00 2001 From: Kenneth Reitz Date: Wed, 23 Mar 2011 00:49:32 -0400 Subject: added formatter tests --- test_tablib.py | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/test_tablib.py b/test_tablib.py index 4079809..4e49c50 100755 --- a/test_tablib.py +++ b/test_tablib.py @@ -470,6 +470,17 @@ class TablibTestCase(unittest.TestCase): data.append(new_row) self.assertTrue(data.width == len(new_row)) self.assertTrue(data[0] == new_row) + + def test_formatters(self): + """Confirm formatters are being triggered.""" + + def _formatter(cell_value): + return str(cell_value).upper() + + self.founders.add_formatter('last_name', _formatter) + + for name in [r['last_name'] for r in self.founders.dict]: + self.assertTrue(name.isupper()) if __name__ == '__main__': -- cgit v1.2.1 From b9002361577e5b64c74d3e5734cc6b10e5682aeb Mon Sep 17 00:00:00 2001 From: Kenneth Reitz Date: Wed, 23 Mar 2011 00:50:27 -0400 Subject: testing whitespace cleanup --- test_tablib.py | 13 ++++++++++++- 1 file changed, 12 insertions(+), 1 deletion(-) diff --git a/test_tablib.py b/test_tablib.py index 4e49c50..568d3d8 100755 --- a/test_tablib.py +++ b/test_tablib.py @@ -295,6 +295,7 @@ class TablibTestCase(unittest.TestCase): self.assertEqual(_csv, data.csv) + def test_csv_import_set_with_spaces(self): """Generate and import CSV set serialization when row values have spaces.""" @@ -308,6 +309,7 @@ class TablibTestCase(unittest.TestCase): self.assertEqual(_csv, data.csv) + def test_tsv_import_set(self): """Generate and import TSV set serialization.""" data.append(self.john) @@ -320,6 +322,7 @@ class TablibTestCase(unittest.TestCase): self.assertEqual(_tsv, data.tsv) + def test_csv_format_detect(self): """Test CSV format detection.""" @@ -335,6 +338,7 @@ class TablibTestCase(unittest.TestCase): self.assertTrue(tablib.formats.csv.detect(_csv)) self.assertFalse(tablib.formats.csv.detect(_bunk)) + def test_tsv_format_detect(self): """Test TSV format detection.""" @@ -350,6 +354,7 @@ class TablibTestCase(unittest.TestCase): self.assertTrue(tablib.formats.tsv.detect(_tsv)) self.assertFalse(tablib.formats.tsv.detect(_bunk)) + def test_json_format_detect(self): """Test JSON format detection.""" @@ -387,6 +392,7 @@ class TablibTestCase(unittest.TestCase): self.assertEqual(tablib.detect(_json)[0], tablib.formats.json) self.assertEqual(tablib.detect(_bunk)[0], None) + def test_transpose(self): """Transpose a dataset.""" @@ -401,6 +407,7 @@ class TablibTestCase(unittest.TestCase): self.assertEqual(second_row, ("gpa",90, 67, 50)) + def test_row_stacking(self): """Row stacking.""" @@ -418,6 +425,7 @@ class TablibTestCase(unittest.TestCase): expected_data = original_data + original_data self.assertEqual(row_stacked[column], expected_data) + def test_column_stacking(self): """Column stacking""" @@ -438,6 +446,7 @@ class TablibTestCase(unittest.TestCase): self.assertEqual(column_stacked[0], ("John", "Adams", 90, "John", "Adams", 90)) + def test_sorting(self): """Sort columns.""" @@ -455,6 +464,7 @@ class TablibTestCase(unittest.TestCase): self.assertEqual(second_row, expected_second) self.assertEqual(third_row, expected_third) + def test_wipe(self): """Purge a dataset.""" @@ -470,7 +480,8 @@ class TablibTestCase(unittest.TestCase): data.append(new_row) self.assertTrue(data.width == len(new_row)) self.assertTrue(data[0] == new_row) - + + def test_formatters(self): """Confirm formatters are being triggered.""" -- cgit v1.2.1 From 4c8b5e72e33a44b7df39529d22225deed05407b1 Mon Sep 17 00:00:00 2001 From: Kenneth Reitz Date: Wed, 23 Mar 2011 01:12:48 -0400 Subject: remove 2.x xlwt --- tablib/packages/xlwt/doc/xlwt.html | 199 ----------- tablib/packages/xlwt/examples/big-16Mb.py | 35 -- tablib/packages/xlwt/examples/big-35Mb.py | 34 -- tablib/packages/xlwt/examples/blanks.py | 36 -- tablib/packages/xlwt/examples/col_width.py | 19 -- tablib/packages/xlwt/examples/country.py | 10 - tablib/packages/xlwt/examples/dates.py | 37 -- tablib/packages/xlwt/examples/format.py | 38 --- tablib/packages/xlwt/examples/formula_names.py | 34 -- tablib/packages/xlwt/examples/formulas.py | 47 --- tablib/packages/xlwt/examples/hyperlinks.py | 28 -- tablib/packages/xlwt/examples/image.py | 12 - tablib/packages/xlwt/examples/merged.py | 39 --- tablib/packages/xlwt/examples/merged0.py | 30 -- tablib/packages/xlwt/examples/merged1.py | 102 ------ tablib/packages/xlwt/examples/mini.py | 9 - tablib/packages/xlwt/examples/num_formats.py | 60 ---- tablib/packages/xlwt/examples/numbers.py | 25 -- tablib/packages/xlwt/examples/outline.py | 113 ------- tablib/packages/xlwt/examples/panes.py | 58 ---- tablib/packages/xlwt/examples/parse-fmla.py | 12 - tablib/packages/xlwt/examples/protection.py | 122 ------- tablib/packages/xlwt/examples/python.bmp | Bin 37446 -> 0 bytes tablib/packages/xlwt/examples/row_styles.py | 17 - tablib/packages/xlwt/examples/row_styles_empty.py | 18 - tablib/packages/xlwt/examples/simple.py | 24 -- tablib/packages/xlwt/examples/sst.py | 52 --- tablib/packages/xlwt/examples/unicode0.py | 12 - tablib/packages/xlwt/examples/unicode1.py | 28 -- tablib/packages/xlwt/examples/unicode2.py | 19 -- tablib/packages/xlwt/examples/wsprops.py | 155 --------- .../xlwt/examples/xlwt_easyxf_simple_demo.py | 46 --- tablib/packages/xlwt/excel-formula.g | 374 --------------------- 33 files changed, 1844 deletions(-) delete mode 100644 tablib/packages/xlwt/doc/xlwt.html delete mode 100644 tablib/packages/xlwt/examples/big-16Mb.py delete mode 100644 tablib/packages/xlwt/examples/big-35Mb.py delete mode 100644 tablib/packages/xlwt/examples/blanks.py delete mode 100644 tablib/packages/xlwt/examples/col_width.py delete mode 100644 tablib/packages/xlwt/examples/country.py delete mode 100644 tablib/packages/xlwt/examples/dates.py delete mode 100644 tablib/packages/xlwt/examples/format.py delete mode 100644 tablib/packages/xlwt/examples/formula_names.py delete mode 100644 tablib/packages/xlwt/examples/formulas.py delete mode 100644 tablib/packages/xlwt/examples/hyperlinks.py delete mode 100644 tablib/packages/xlwt/examples/image.py delete mode 100644 tablib/packages/xlwt/examples/merged.py delete mode 100644 tablib/packages/xlwt/examples/merged0.py delete mode 100644 tablib/packages/xlwt/examples/merged1.py delete mode 100644 tablib/packages/xlwt/examples/mini.py delete mode 100644 tablib/packages/xlwt/examples/num_formats.py delete mode 100644 tablib/packages/xlwt/examples/numbers.py delete mode 100644 tablib/packages/xlwt/examples/outline.py delete mode 100644 tablib/packages/xlwt/examples/panes.py delete mode 100644 tablib/packages/xlwt/examples/parse-fmla.py delete mode 100644 tablib/packages/xlwt/examples/protection.py delete mode 100644 tablib/packages/xlwt/examples/python.bmp delete mode 100644 tablib/packages/xlwt/examples/row_styles.py delete mode 100644 tablib/packages/xlwt/examples/row_styles_empty.py delete mode 100644 tablib/packages/xlwt/examples/simple.py delete mode 100644 tablib/packages/xlwt/examples/sst.py delete mode 100644 tablib/packages/xlwt/examples/unicode0.py delete mode 100644 tablib/packages/xlwt/examples/unicode1.py delete mode 100644 tablib/packages/xlwt/examples/unicode2.py delete mode 100644 tablib/packages/xlwt/examples/wsprops.py delete mode 100644 tablib/packages/xlwt/examples/xlwt_easyxf_simple_demo.py delete mode 100644 tablib/packages/xlwt/excel-formula.g diff --git a/tablib/packages/xlwt/doc/xlwt.html b/tablib/packages/xlwt/doc/xlwt.html deleted file mode 100644 index 6efb698..0000000 --- a/tablib/packages/xlwt/doc/xlwt.html +++ /dev/null @@ -1,199 +0,0 @@ - - - - -The xlwt Module - - -

The xlwt Module

-

A Python package for generating Microsoft Excel ™ spreadsheet files. -

- -

General information

- -

State of Documentation

- -

-This documentation is currently incomplete. There may be methods and -classes not included and any item marked with a [NC] is not complete and may have further -parameters, methods, attributes and functionality that are not -documented. In these cases, you'll have to refer to the source if the -documentation provided is insufficient. -

- -

- -

Module Contents [NC]

-
-
easyxf (function)
-
-

- This function is used to create and configure XFStyle objects - for use with (for example) the Worksheet.write method. -

-
-
strg_to_parse
-
-

- A string to be parsed to obtain attribute values for Alignment, Borders, Font, - Pattern and Protection objects. Refer to the examples - in the file .../examples/xlwt_easyxf_simple_demo.py and to the xf_dict - dictionary in Style.py. Various synonyms including color/colour, center/centre and gray/grey - are allowed. Case is irrelevant (except maybe in font names). '-' may be used instead - of '_'.
- Example: "font: bold on; align: wrap on, vert centre, horiz center" -

-
-
num_format_str
-
-

- To get the "number format string" of an existing cell whose format you want to reproduce, - select the cell and click on Format/Cells/Number/Custom. Otherwise, refer to Excel help.
- Examples: "#,##0.00", "dd/mm/yyyy" -

-
-
Returns:
-
- An object of the XFstyle class -
-
-
- -
- -
Workbook (class) [#]
-
-

The class to instantiate to create a workbook

-

For more information about this class, see The Workbook Class.

-
-
Worksheet (class) [#]
-
-

A class to represent the contents of a sheet in a workbook.

-

For more information about this class, see The Worksheet Class.

-
-
- -

The Workbook Class[NC]

-
-
Workbook(encoding='ascii',style_compression=0) (class) [#]
-
-

- This is a class representing a workbook and all its contents. - When creating Excel files with xlwt, you will normally start by - instantiating an object of this class. -

-
-
encoding
-
- [NC] -
-
style_compression
-
- [NC] -
-
Returns:
-
- An object of the Workbook class -
-
-
-
-
add_sheet(sheetname) [#]
-
-

- This method is used to create Worksheets in a Workbook. -

-
-
sheetname
-
- The name to use for this sheet, as it will appear in the tabs at - the bottom of the Excel application. -
-
Returns:
-
- An object of the Worksheet class -
-
-
-
-
save(filename_or_stream) [#]
-
-

- This method is used to save Workbook to a file in native Excel format. -

-
-
filename_or_stream
-
-

- This can be a string containing a filename of the file, in which case - the excel file is saved to disk using the name provided. -

-

- It can also be a stream object with a write method, such as a - StringIO, in which case the data for the excel file is written - to the stream. -

-
-
-
-
-
- -

The Worksheet Class[NC]

-
-
Worksheet(sheetname, parent_book) (class) [#]
-
-

- This is a class representing the contents of a sheet in a workbook. -

-

- WARNING: You don't normally create instances of this class - yourself. They are returned from calls to Workbook.add_sheet -

-
-
write(r, c, label="", style=Style.default_style) [#]
-
-

- This method is used to write a cell to a Worksheet.. -

-
-
r
-
- The zero-relative number of the row in the worksheet to which the cell should be written. -
-
c
-
- The zero-relative number of the column in the worksheet to which the cell should be written. -
-
label
-
- The data value to be written. - An int, long, or decimal.Decimal instance is converted to float. - A unicode instance is written as is. - A str instance is converted to unicode using the encoding (default: 'ascii') specified - when the Workbook instance was created. - A datetime.datetime, datetime.date, or datetime.time instance is converted into Excel date format - (a float representing the number of days since (typically) 1899-12-31T00:00:00, - under the pretence that 1900 was a leap year). - A bool instance will show up as TRUE or FALSE in Excel. - None causes the cell to be blank -- no data, only formatting. - An xlwt.Formula instance causes an Excel formula to be written. - [NC] -
-
style
-
- A style -- also known as an XF (extended format) -- is an XFStyle object, which encapsulates - the formatting applied to the cell and its contents. XFStyle objects are best set up using the - easyxf function. They may also be set up by setting attributes in - Alignment, Borders, Pattern, Font and Protection objects - then setting those objects and a format string as attributes of an XFStyle object. - [NC] -
-
-
-
-
- - diff --git a/tablib/packages/xlwt/examples/big-16Mb.py b/tablib/packages/xlwt/examples/big-16Mb.py deleted file mode 100644 index 91db123..0000000 --- a/tablib/packages/xlwt/examples/big-16Mb.py +++ /dev/null @@ -1,35 +0,0 @@ -#!/usr/bin/env python -# tries stress SST, SAT and MSAT - -from time import * -from xlwt.Workbook import * -from xlwt.Style import * - -style = XFStyle() - -wb = Workbook() -ws0 = wb.add_sheet('0') - -colcount = 200 + 1 -rowcount = 6000 + 1 - -t0 = time() -print "\nstart: %s" % ctime(t0) - -print "Filling..." -for col in xrange(colcount): - print "[%d]" % col, - for row in xrange(rowcount): - #ws0.write(row, col, "BIG(%d, %d)" % (row, col)) - ws0.write(row, col, "BIG") - -t1 = time() - t0 -print "\nsince starting elapsed %.2f s" % (t1) - -print "Storing..." -wb.save('big-16Mb.xls') - -t2 = time() - t0 -print "since starting elapsed %.2f s" % (t2) - - diff --git a/tablib/packages/xlwt/examples/big-35Mb.py b/tablib/packages/xlwt/examples/big-35Mb.py deleted file mode 100644 index 74be5a7..0000000 --- a/tablib/packages/xlwt/examples/big-35Mb.py +++ /dev/null @@ -1,34 +0,0 @@ -#!/usr/bin/env python -# tries stress SST, SAT and MSAT - -from time import * -from xlwt import * - -style = XFStyle() - -wb = Workbook() -ws0 = wb.add_sheet('0') - -colcount = 200 + 1 -rowcount = 6000 + 1 - -t0 = time() -print "\nstart: %s" % ctime(t0) - -print "Filling..." -for col in xrange(colcount): - print "[%d]" % col, - for row in xrange(rowcount): - ws0.write(row, col, "BIG(%d, %d)" % (row, col)) - #ws0.write(row, col, "BIG") - -t1 = time() - t0 -print "\nsince starting elapsed %.2f s" % (t1) - -print "Storing..." -wb.save('big-35Mb.xls') - -t2 = time() - t0 -print "since starting elapsed %.2f s" % (t2) - - diff --git a/tablib/packages/xlwt/examples/blanks.py b/tablib/packages/xlwt/examples/blanks.py deleted file mode 100644 index 056a3ec..0000000 --- a/tablib/packages/xlwt/examples/blanks.py +++ /dev/null @@ -1,36 +0,0 @@ -#!/usr/bin/env python -# -*- coding: windows-1251 -*- -# Copyright (C) 2005 Kiseliov Roman - -from xlwt import * - -font0 = Font() -font0.name = 'Times New Roman' -font0.struck_out = True -font0.bold = True - -style0 = XFStyle() -style0.font = font0 - - -wb = Workbook() -ws0 = wb.add_sheet('0') - -ws0.write(1, 1, 'Test', style0) - -for i in range(0, 0x53): - borders = Borders() - borders.left = i - borders.right = i - borders.top = i - borders.bottom = i - - style = XFStyle() - style.borders = borders - - ws0.write(i, 2, '', style) - ws0.write(i, 3, hex(i), style0) - -ws0.write_merge(5, 8, 6, 10, "") - -wb.save('blanks.xls') diff --git a/tablib/packages/xlwt/examples/col_width.py b/tablib/packages/xlwt/examples/col_width.py deleted file mode 100644 index 6e6cb33..0000000 --- a/tablib/packages/xlwt/examples/col_width.py +++ /dev/null @@ -1,19 +0,0 @@ -#!/usr/bin/env python -# -*- coding: windows-1251 -*- -# Copyright (C) 2005 Kiseliov Roman -__rev_id__ = """$Id: col_width.py 3315 2008-03-14 14:44:52Z chris $""" - - -from xlwt import * - -w = Workbook() -ws = w.add_sheet('Hey, Dude') - -for i in range(6, 80): - fnt = Font() - fnt.height = i*20 - style = XFStyle() - style.font = fnt - ws.write(1, i, 'Test') - ws.col(i).width = 0x0d00 + i -w.save('col_width.xls') diff --git a/tablib/packages/xlwt/examples/country.py b/tablib/packages/xlwt/examples/country.py deleted file mode 100644 index cb26e29..0000000 --- a/tablib/packages/xlwt/examples/country.py +++ /dev/null @@ -1,10 +0,0 @@ -#!/usr/bin/env python -# -*- coding: windows-1252 -*- -# Copyright (C) 2007 John Machin - -from xlwt import * - -w = Workbook() -w.country_code = 61 -ws = w.add_sheet('AU') -w.save('country.xls') diff --git a/tablib/packages/xlwt/examples/dates.py b/tablib/packages/xlwt/examples/dates.py deleted file mode 100644 index 389b93b..0000000 --- a/tablib/packages/xlwt/examples/dates.py +++ /dev/null @@ -1,37 +0,0 @@ -#!/usr/bin/env python -# -*- coding: windows-1251 -*- -# Copyright (C) 2005 Kiseliov Roman - -from xlwt import * -from datetime import datetime - -w = Workbook() -ws = w.add_sheet('Hey, Dude') - -fmts = [ - 'M/D/YY', - 'D-MMM-YY', - 'D-MMM', - 'MMM-YY', - 'h:mm AM/PM', - 'h:mm:ss AM/PM', - 'h:mm', - 'h:mm:ss', - 'M/D/YY h:mm', - 'mm:ss', - '[h]:mm:ss', - 'mm:ss.0', -] - -i = 0 -for fmt in fmts: - ws.write(i, 0, fmt) - - style = XFStyle() - style.num_format_str = fmt - - ws.write(i, 4, datetime.now(), style) - - i += 1 - -w.save('dates.xls') diff --git a/tablib/packages/xlwt/examples/format.py b/tablib/packages/xlwt/examples/format.py deleted file mode 100644 index fd49e0a..0000000 --- a/tablib/packages/xlwt/examples/format.py +++ /dev/null @@ -1,38 +0,0 @@ -#!/usr/bin/env python -# -*- coding: windows-1251 -*- -# Copyright (C) 2005 Kiseliov Roman - -from xlwt import * - -font0 = Font() -font0.name = 'Times New Roman' -font0.struck_out = True -font0.bold = True - -style0 = XFStyle() -style0.font = font0 - - -wb = Workbook() -ws0 = wb.add_sheet('0') - -ws0.write(1, 1, 'Test', style0) - -for i in range(0, 0x53): - fnt = Font() - fnt.name = 'Arial' - fnt.colour_index = i - fnt.outline = True - - borders = Borders() - borders.left = i - - style = XFStyle() - style.font = fnt - style.borders = borders - - ws0.write(i, 2, 'colour', style) - ws0.write(i, 3, hex(i), style0) - - -wb.save('format.xls') diff --git a/tablib/packages/xlwt/examples/formula_names.py b/tablib/packages/xlwt/examples/formula_names.py deleted file mode 100644 index f0354bc..0000000 --- a/tablib/packages/xlwt/examples/formula_names.py +++ /dev/null @@ -1,34 +0,0 @@ -#!/usr/bin/env python -# -*- coding: windows-1251 -*- -# Copyright (C) 2005 Kiseliov Roman - -from xlwt import * -from xlwt.ExcelFormulaParser import FormulaParseException - -w = Workbook() -ws = w.add_sheet('F') - -## This example is a little silly since the formula building is -## so simplistic that it often fails because the generated text -## has the wrong number of parameters for the function being -## tested. - -i = 0 -succeed_count = 0 -fail_count = 0 -for n in sorted(ExcelMagic.std_func_by_name): - ws.write(i, 0, n) - text = n + "($A$1)" - try: - formula = Formula(text) - except FormulaParseException,e: - print "Could not parse %r: %s" % (text,e.args[0]) - fail_count += 1 - else: - ws.write(i, 3, formula) - succeed_count += 1 - i += 1 - -w.save('formula_names.xls') - -print "succeeded with %i functions, failed with %i" % (succeed_count,fail_count) diff --git a/tablib/packages/xlwt/examples/formulas.py b/tablib/packages/xlwt/examples/formulas.py deleted file mode 100644 index b89f5f5..0000000 --- a/tablib/packages/xlwt/examples/formulas.py +++ /dev/null @@ -1,47 +0,0 @@ -#!/usr/bin/env python -# -*- coding: windows-1251 -*- -# Copyright (C) 2005 Kiseliov Roman - -from xlwt import * - -w = Workbook() -ws = w.add_sheet('F') - -ws.write(0, 0, Formula("-(1+1)")) -ws.write(1, 0, Formula("-(1+1)/(-2-2)")) -ws.write(2, 0, Formula("-(134.8780789+1)")) -ws.write(3, 0, Formula("-(134.8780789e-10+1)")) -ws.write(4, 0, Formula("-1/(1+1)+9344")) - -ws.write(0, 1, Formula("-(1+1)")) -ws.write(1, 1, Formula("-(1+1)/(-2-2)")) -ws.write(2, 1, Formula("-(134.8780789+1)")) -ws.write(3, 1, Formula("-(134.8780789e-10+1)")) -ws.write(4, 1, Formula("-1/(1+1)+9344")) - -ws.write(0, 2, Formula("A1*B1")) -ws.write(1, 2, Formula("A2*B2")) -ws.write(2, 2, Formula("A3*B3")) -ws.write(3, 2, Formula("A4*B4*sin(pi()/4)")) -ws.write(4, 2, Formula("A5%*B5*pi()/1000")) - -############## -## NOTE: parameters are separated by semicolon!!! -############## - - -ws.write(5, 2, Formula("C1+C2+C3+C4+C5/(C1+C2+C3+C4/(C1+C2+C3+C4/(C1+C2+C3+C4)+C5)+C5)-20.3e-2")) -ws.write(5, 3, Formula("C1^2")) -ws.write(6, 2, Formula("SUM(C1;C2;;;;;C3;;;C4)")) -ws.write(6, 3, Formula("SUM($A$1:$C$5)")) - -ws.write(7, 0, Formula('"lkjljllkllkl"')) -ws.write(7, 1, Formula('"yuyiyiyiyi"')) -ws.write(7, 2, Formula('A8 & B8 & A8')) -ws.write(8, 2, Formula('now()')) - -ws.write(10, 2, Formula('TRUE')) -ws.write(11, 2, Formula('FALSE')) -ws.write(12, 3, Formula('IF(A1>A2;3;"hkjhjkhk")')) - -w.save('formulas.xls') diff --git a/tablib/packages/xlwt/examples/hyperlinks.py b/tablib/packages/xlwt/examples/hyperlinks.py deleted file mode 100644 index 8de611b..0000000 --- a/tablib/packages/xlwt/examples/hyperlinks.py +++ /dev/null @@ -1,28 +0,0 @@ -#!/usr/bin/env python -# -*- coding: windows-1251 -*- -# Copyright (C) 2005 Kiseliov Roman - -from xlwt import * - -f = Font() -f.height = 20*72 -f.name = 'Verdana' -f.bold = True -f.underline = Font.UNDERLINE_DOUBLE -f.colour_index = 4 - -h_style = XFStyle() -h_style.font = f - -w = Workbook() -ws = w.add_sheet('F') - -############## -## NOTE: parameters are separated by semicolon!!! -############## - -n = "HYPERLINK" -ws.write_merge(1, 1, 1, 10, Formula(n + '("http://www.irs.gov/pub/irs-pdf/f1000.pdf";"f1000.pdf")'), h_style) -ws.write_merge(2, 2, 2, 25, Formula(n + '("mailto:roman.kiseliov@gmail.com?subject=pyExcelerator-feedback&Body=Hello,%20Roman!";"pyExcelerator-feedback")'), h_style) - -w.save("hyperlinks.xls") diff --git a/tablib/packages/xlwt/examples/image.py b/tablib/packages/xlwt/examples/image.py deleted file mode 100644 index f926b8d..0000000 --- a/tablib/packages/xlwt/examples/image.py +++ /dev/null @@ -1,12 +0,0 @@ -#!/usr/bin/env python -# -*- coding: windows-1251 -*- -# Copyright (C) 2005 Kiseliov Roman - -from xlwt import * - -w = Workbook() -ws = w.add_sheet('Image') -ws.insert_bitmap('python.bmp', 2, 2) -ws.insert_bitmap('python.bmp', 10, 2) - -w.save('image.xls') diff --git a/tablib/packages/xlwt/examples/merged.py b/tablib/packages/xlwt/examples/merged.py deleted file mode 100644 index f7f9c57..0000000 --- a/tablib/packages/xlwt/examples/merged.py +++ /dev/null @@ -1,39 +0,0 @@ -#!/usr/bin/env python -# -*- coding: windows-1251 -*- -# Copyright (C) 2005 Kiseliov Roman - -from xlwt import * - -fnt = Font() -fnt.name = 'Arial' -fnt.colour_index = 4 -fnt.bold = True - -borders = Borders() -borders.left = 6 -borders.right = 6 -borders.top = 6 -borders.bottom = 6 - -al = Alignment() -al.horz = Alignment.HORZ_CENTER -al.vert = Alignment.VERT_CENTER - -style = XFStyle() -style.font = fnt -style.borders = borders -style.alignment = al - - -wb = Workbook() -ws0 = wb.add_sheet('sheet0') -ws1 = wb.add_sheet('sheet1') -ws2 = wb.add_sheet('sheet2') - -for i in range(0, 0x200, 2): - ws0.write_merge(i, i+1, 1, 5, 'test %d' % i, style) - ws1.write_merge(i, i, 1, 7, 'test %d' % i, style) - ws2.write_merge(i, i+1, 1, 7 + (i%10), 'test %d' % i, style) - - -wb.save('merged.xls') diff --git a/tablib/packages/xlwt/examples/merged0.py b/tablib/packages/xlwt/examples/merged0.py deleted file mode 100644 index 93496c6..0000000 --- a/tablib/packages/xlwt/examples/merged0.py +++ /dev/null @@ -1,30 +0,0 @@ -#!/usr/bin/env python -# -*- coding: windows-1251 -*- -# Copyright (C) 2005 Kiseliov Roman - -from xlwt import * - -wb = Workbook() -ws0 = wb.add_sheet('sheet0') - - -fnt = Font() -fnt.name = 'Arial' -fnt.colour_index = 4 -fnt.bold = True - -borders = Borders() -borders.left = 6 -borders.right = 6 -borders.top = 6 -borders.bottom = 6 - -style = XFStyle() -style.font = fnt -style.borders = borders - -ws0.write_merge(3, 3, 1, 5, 'test1', style) -ws0.write_merge(4, 10, 1, 5, 'test2', style) -ws0.col(1).width = 0x0d00 - -wb.save('merged0.xls') diff --git a/tablib/packages/xlwt/examples/merged1.py b/tablib/packages/xlwt/examples/merged1.py deleted file mode 100644 index 813530b..0000000 --- a/tablib/packages/xlwt/examples/merged1.py +++ /dev/null @@ -1,102 +0,0 @@ -#!/usr/bin/env python -# -*- coding: windows-1251 -*- -# Copyright (C) 2005 Kiseliov Roman - -from xlwt import * - -wb = Workbook() -ws0 = wb.add_sheet('sheet0') - -fnt1 = Font() -fnt1.name = 'Verdana' -fnt1.bold = True -fnt1.height = 18*0x14 - -pat1 = Pattern() -pat1.pattern = Pattern.SOLID_PATTERN -pat1.pattern_fore_colour = 0x16 - -brd1 = Borders() -brd1.left = 0x06 -brd1.right = 0x06 -brd1.top = 0x06 -brd1.bottom = 0x06 - -fnt2 = Font() -fnt2.name = 'Verdana' -fnt2.bold = True -fnt2.height = 14*0x14 - -brd2 = Borders() -brd2.left = 0x01 -brd2.right = 0x01 -brd2.top = 0x01 -brd2.bottom = 0x01 - -pat2 = Pattern() -pat2.pattern = Pattern.SOLID_PATTERN -pat2.pattern_fore_colour = 0x01F - -fnt3 = Font() -fnt3.name = 'Verdana' -fnt3.bold = True -fnt3.italic = True -fnt3.height = 12*0x14 - -brd3 = Borders() -brd3.left = 0x07 -brd3.right = 0x07 -brd3.top = 0x07 -brd3.bottom = 0x07 - -fnt4 = Font() - -al1 = Alignment() -al1.horz = Alignment.HORZ_CENTER -al1.vert = Alignment.VERT_CENTER - -al2 = Alignment() -al2.horz = Alignment.HORZ_RIGHT -al2.vert = Alignment.VERT_CENTER - -al3 = Alignment() -al3.horz = Alignment.HORZ_LEFT -al3.vert = Alignment.VERT_CENTER - -style1 = XFStyle() -style1.font = fnt1 -style1.alignment = al1 -style1.pattern = pat1 -style1.borders = brd1 - -style2 = XFStyle() -style2.font = fnt2 -style2.alignment = al1 -style2.pattern = pat2 -style2.borders = brd2 - -style3 = XFStyle() -style3.font = fnt3 -style3.alignment = al1 -style3.pattern = pat2 -style3.borders = brd3 - -price_style = XFStyle() -price_style.font = fnt4 -price_style.alignment = al2 -price_style.borders = brd3 -price_style.num_format_str = '_(#,##0.00_) "money"' - -ware_style = XFStyle() -ware_style.font = fnt4 -ware_style.alignment = al3 -ware_style.borders = brd3 - - -ws0.merge(3, 3, 1, 5, style1) -ws0.merge(4, 10, 1, 6, style2) -ws0.merge(14, 16, 1, 7, style3) -ws0.col(1).width = 0x0d00 - - -wb.save('merged1.xls') diff --git a/tablib/packages/xlwt/examples/mini.py b/tablib/packages/xlwt/examples/mini.py deleted file mode 100644 index 61bb30c..0000000 --- a/tablib/packages/xlwt/examples/mini.py +++ /dev/null @@ -1,9 +0,0 @@ -#!/usr/bin/env python -# -*- coding: windows-1251 -*- -# Copyright (C) 2005 Kiseliov Roman - -from xlwt import * - -w = Workbook() -ws = w.add_sheet('xlwt was here') -w.save('mini.xls') diff --git a/tablib/packages/xlwt/examples/num_formats.py b/tablib/packages/xlwt/examples/num_formats.py deleted file mode 100644 index 3a56f6c..0000000 --- a/tablib/packages/xlwt/examples/num_formats.py +++ /dev/null @@ -1,60 +0,0 @@ -#!/usr/bin/env python -# -*- coding: windows-1251 -*- -# Copyright (C) 2005 Kiseliov Roman - -from xlwt import * - -w = Workbook() -ws = w.add_sheet('Hey, Dude') - -fmts = [ - 'general', - '0', - '0.00', - '#,##0', - '#,##0.00', - '"$"#,##0_);("$"#,##', - '"$"#,##0_);[Red]("$"#,##', - '"$"#,##0.00_);("$"#,##', - '"$"#,##0.00_);[Red]("$"#,##', - '0%', - '0.00%', - '0.00E+00', - '# ?/?', - '# ??/??', - 'M/D/YY', - 'D-MMM-YY', - 'D-MMM', - 'MMM-YY', - 'h:mm AM/PM', - 'h:mm:ss AM/PM', - 'h:mm', - 'h:mm:ss', - 'M/D/YY h:mm', - '_(#,##0_);(#,##0)', - '_(#,##0_);[Red](#,##0)', - '_(#,##0.00_);(#,##0.00)', - '_(#,##0.00_);[Red](#,##0.00)', - '_("$"* #,##0_);_("$"* (#,##0);_("$"* "-"_);_(@_)', - '_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)', - '_("$"* #,##0.00_);_("$"* (#,##0.00);_("$"* "-"??_);_(@_)', - '_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)', - 'mm:ss', - '[h]:mm:ss', - 'mm:ss.0', - '##0.0E+0', - '@' -] - -i = 0 -for fmt in fmts: - ws.write(i, 0, fmt) - - style = XFStyle() - style.num_format_str = fmt - - ws.write(i, 4, -1278.9078, style) - - i += 1 - -w.save('num_formats.xls') diff --git a/tablib/packages/xlwt/examples/numbers.py b/tablib/packages/xlwt/examples/numbers.py deleted file mode 100644 index 524d9fc..0000000 --- a/tablib/packages/xlwt/examples/numbers.py +++ /dev/null @@ -1,25 +0,0 @@ -#!/usr/bin/env python -# -*- coding: windows-1251 -*- -# Copyright (C) 2005 Kiseliov Roman - -from xlwt import * - -w = Workbook() -ws = w.add_sheet('Hey, Dude') - -ws.write(0, 0, 1) -ws.write(1, 0, 1.23) -ws.write(2, 0, 12345678) -ws.write(3, 0, 123456.78) - -ws.write(0, 1, -1) -ws.write(1, 1, -1.23) -ws.write(2, 1, -12345678) -ws.write(3, 1, -123456.78) - -ws.write(0, 2, -17867868678687.0) -ws.write(1, 2, -1.23e-5) -ws.write(2, 2, -12345678.90780980) -ws.write(3, 2, -123456.78) - -w.save('numbers.xls') diff --git a/tablib/packages/xlwt/examples/outline.py b/tablib/packages/xlwt/examples/outline.py deleted file mode 100644 index 45b8df9..0000000 --- a/tablib/packages/xlwt/examples/outline.py +++ /dev/null @@ -1,113 +0,0 @@ -#!/usr/bin/env python -# -*- coding: windows-1251 -*- -# Copyright (C) 2005 Kiseliov Roman - -from xlwt import * - -fnt = Font() -fnt.name = 'Arial' -fnt.colour_index = 4 -fnt.bold = True - -borders = Borders() -borders.left = 6 -borders.right = 6 -borders.top = 6 -borders.bottom = 6 - -style = XFStyle() -style.font = fnt -style.borders = borders - -wb = Workbook() - -ws0 = wb.add_sheet('Rows Outline') - -ws0.write_merge(1, 1, 1, 5, 'test 1', style) -ws0.write_merge(2, 2, 1, 4, 'test 1', style) -ws0.write_merge(3, 3, 1, 3, 'test 2', style) -ws0.write_merge(4, 4, 1, 4, 'test 1', style) -ws0.write_merge(5, 5, 1, 4, 'test 3', style) -ws0.write_merge(6, 6, 1, 5, 'test 1', style) -ws0.write_merge(7, 7, 1, 5, 'test 4', style) -ws0.write_merge(8, 8, 1, 4, 'test 1', style) -ws0.write_merge(9, 9, 1, 3, 'test 5', style) - -ws0.row(1).level = 1 -ws0.row(2).level = 1 -ws0.row(3).level = 2 -ws0.row(4).level = 2 -ws0.row(5).level = 2 -ws0.row(6).level = 2 -ws0.row(7).level = 2 -ws0.row(8).level = 1 -ws0.row(9).level = 1 - - -ws1 = wb.add_sheet('Columns Outline') - -ws1.write_merge(1, 1, 1, 5, 'test 1', style) -ws1.write_merge(2, 2, 1, 4, 'test 1', style) -ws1.write_merge(3, 3, 1, 3, 'test 2', style) -ws1.write_merge(4, 4, 1, 4, 'test 1', style) -ws1.write_merge(5, 5, 1, 4, 'test 3', style) -ws1.write_merge(6, 6, 1, 5, 'test 1', style) -ws1.write_merge(7, 7, 1, 5, 'test 4', style) -ws1.write_merge(8, 8, 1, 4, 'test 1', style) -ws1.write_merge(9, 9, 1, 3, 'test 5', style) - -ws1.col(1).level = 1 -ws1.col(2).level = 1 -ws1.col(3).level = 2 -ws1.col(4).level = 2 -ws1.col(5).level = 2 -ws1.col(6).level = 2 -ws1.col(7).level = 2 -ws1.col(8).level = 1 -ws1.col(9).level = 1 - - -ws2 = wb.add_sheet('Rows and Columns Outline') - -ws2.write_merge(1, 1, 1, 5, 'test 1', style) -ws2.write_merge(2, 2, 1, 4, 'test 1', style) -ws2.write_merge(3, 3, 1, 3, 'test 2', style) -ws2.write_merge(4, 4, 1, 4, 'test 1', style) -ws2.write_merge(5, 5, 1, 4, 'test 3', style) -ws2.write_merge(6, 6, 1, 5, 'test 1', style) -ws2.write_merge(7, 7, 1, 5, 'test 4', style) -ws2.write_merge(8, 8, 1, 4, 'test 1', style) -ws2.write_merge(9, 9, 1, 3, 'test 5', style) - -ws2.row(1).level = 1 -ws2.row(2).level = 1 -ws2.row(3).level = 2 -ws2.row(4).level = 2 -ws2.row(5).level = 2 -ws2.row(6).level = 2 -ws2.row(7).level = 2 -ws2.row(8).level = 1 -ws2.row(9).level = 1 - -ws2.write_merge(1, 1, 1, 5, 'test 1', style) -ws2.write_merge(2, 2, 1, 4, 'test 1', style) -ws2.write_merge(3, 3, 1, 3, 'test 2', style) -ws2.write_merge(4, 4, 1, 4, 'test 1', style) -ws2.write_merge(5, 5, 1, 4, 'test 3', style) -ws2.write_merge(6, 6, 1, 5, 'test 1', style) -ws2.write_merge(7, 7, 1, 5, 'test 4', style) -ws2.write_merge(8, 8, 1, 4, 'test 1', style) -ws2.write_merge(9, 9, 1, 3, 'test 5', style) - -ws2.col(1).level = 1 -ws2.col(2).level = 1 -ws2.col(3).level = 2 -ws2.col(4).level = 2 -ws2.col(5).level = 2 -ws2.col(6).level = 2 -ws2.col(7).level = 2 -ws2.col(8).level = 1 -ws2.col(9).level = 1 - - -wb.save('outline.xls') diff --git a/tablib/packages/xlwt/examples/panes.py b/tablib/packages/xlwt/examples/panes.py deleted file mode 100644 index 9fd83b0..0000000 --- a/tablib/packages/xlwt/examples/panes.py +++ /dev/null @@ -1,58 +0,0 @@ -#!/usr/bin/env python -# -*- coding: windows-1251 -*- -# Copyright (C) 2005 Kiseliov Roman - -from xlwt import * - -w = Workbook() -ws1 = w.add_sheet('sheet 1') -ws2 = w.add_sheet('sheet 2') -ws3 = w.add_sheet('sheet 3') -ws4 = w.add_sheet('sheet 4') -ws5 = w.add_sheet('sheet 5') -ws6 = w.add_sheet('sheet 6') - -for i in range(0x100): - ws1.write(i/0x10, i%0x10, i) - -for i in range(0x100): - ws2.write(i/0x10, i%0x10, i) - -for i in range(0x100): - ws3.write(i/0x10, i%0x10, i) - -for i in range(0x100): - ws4.write(i/0x10, i%0x10, i) - -for i in range(0x100): - ws5.write(i/0x10, i%0x10, i) - -for i in range(0x100): - ws6.write(i/0x10, i%0x10, i) - -ws1.panes_frozen = True -ws1.horz_split_pos = 2 - -ws2.panes_frozen = True -ws2.vert_split_pos = 2 - -ws3.panes_frozen = True -ws3.horz_split_pos = 1 -ws3.vert_split_pos = 1 - -ws4.panes_frozen = False -ws4.horz_split_pos = 12 -ws4.horz_split_first_visible = 2 - -ws5.panes_frozen = False -ws5.vert_split_pos = 40 -ws4.vert_split_first_visible = 2 - -ws6.panes_frozen = False -ws6.horz_split_pos = 12 -ws4.horz_split_first_visible = 2 -ws6.vert_split_pos = 40 -ws4.vert_split_first_visible = 2 - -w.save('panes.xls') - diff --git a/tablib/packages/xlwt/examples/parse-fmla.py b/tablib/packages/xlwt/examples/parse-fmla.py deleted file mode 100644 index 06f68eb..0000000 --- a/tablib/packages/xlwt/examples/parse-fmla.py +++ /dev/null @@ -1,12 +0,0 @@ -from xlwt import ExcelFormulaParser, ExcelFormula -import sys - -f = ExcelFormula.Formula( -""" -((1.80 + 2.898 * 1)/(1.80 + 2.898))* -AVERAGE((1.80 + 2.898 * 1)/(1.80 + 2.898); - (1.80 + 2.898 * 1)/(1.80 + 2.898); - (1.80 + 2.898 * 1)/(1.80 + 2.898)) + -SIN(PI()/4)""") - -#for t in f.rpn(): -# print "%15s %15s" % (ExcelFormulaParser.PtgNames[t[0]], t[1]) diff --git a/tablib/packages/xlwt/examples/protection.py b/tablib/packages/xlwt/examples/protection.py deleted file mode 100644 index db54cb0..0000000 --- a/tablib/packages/xlwt/examples/protection.py +++ /dev/null @@ -1,122 +0,0 @@ -# Copyright (C) 2005 Kiseliov Roman - -from xlwt import * - -fnt = Font() -fnt.name = 'Arial' -fnt.colour_index = 4 -fnt.bold = True - -borders = Borders() -borders.left = 6 -borders.right = 6 -borders.top = 6 -borders.bottom = 6 - -style = XFStyle() -style.font = fnt -style.borders = borders - -wb = Workbook() - -ws0 = wb.add_sheet('Rows Outline') - -ws0.write_merge(1, 1, 1, 5, 'test 1', style) -ws0.write_merge(2, 2, 1, 4, 'test 1', style) -ws0.write_merge(3, 3, 1, 3, 'test 2', style) -ws0.write_merge(4, 4, 1, 4, 'test 1', style) -ws0.write_merge(5, 5, 1, 4, 'test 3', style) -ws0.write_merge(6, 6, 1, 5, 'test 1', style) -ws0.write_merge(7, 7, 1, 5, 'test 4', style) -ws0.write_merge(8, 8, 1, 4, 'test 1', style) -ws0.write_merge(9, 9, 1, 3, 'test 5', style) - -ws0.row(1).level = 1 -ws0.row(2).level = 1 -ws0.row(3).level = 2 -ws0.row(4).level = 2 -ws0.row(5).level = 2 -ws0.row(6).level = 2 -ws0.row(7).level = 2 -ws0.row(8).level = 1 -ws0.row(9).level = 1 - - -ws1 = wb.add_sheet('Columns Outline') - -ws1.write_merge(1, 1, 1, 5, 'test 1', style) -ws1.write_merge(2, 2, 1, 4, 'test 1', style) -ws1.write_merge(3, 3, 1, 3, 'test 2', style) -ws1.write_merge(4, 4, 1, 4, 'test 1', style) -ws1.write_merge(5, 5, 1, 4, 'test 3', style) -ws1.write_merge(6, 6, 1, 5, 'test 1', style) -ws1.write_merge(7, 7, 1, 5, 'test 4', style) -ws1.write_merge(8, 8, 1, 4, 'test 1', style) -ws1.write_merge(9, 9, 1, 3, 'test 5', style) - -ws1.col(1).level = 1 -ws1.col(2).level = 1 -ws1.col(3).level = 2 -ws1.col(4).level = 2 -ws1.col(5).level = 2 -ws1.col(6).level = 2 -ws1.col(7).level = 2 -ws1.col(8).level = 1 -ws1.col(9).level = 1 - - -ws2 = wb.add_sheet('Rows and Columns Outline') - -ws2.write_merge(1, 1, 1, 5, 'test 1', style) -ws2.write_merge(2, 2, 1, 4, 'test 1', style) -ws2.write_merge(3, 3, 1, 3, 'test 2', style) -ws2.write_merge(4, 4, 1, 4, 'test 1', style) -ws2.write_merge(5, 5, 1, 4, 'test 3', style) -ws2.write_merge(6, 6, 1, 5, 'test 1', style) -ws2.write_merge(7, 7, 1, 5, 'test 4', style) -ws2.write_merge(8, 8, 1, 4, 'test 1', style) -ws2.write_merge(9, 9, 1, 3, 'test 5', style) - -ws2.row(1).level = 1 -ws2.row(2).level = 1 -ws2.row(3).level = 2 -ws2.row(4).level = 2 -ws2.row(5).level = 2 -ws2.row(6).level = 2 -ws2.row(7).level = 2 -ws2.row(8).level = 1 -ws2.row(9).level = 1 - -ws2.col(1).level = 1 -ws2.col(2).level = 1 -ws2.col(3).level = 2 -ws2.col(4).level = 2 -ws2.col(5).level = 2 -ws2.col(6).level = 2 -ws2.col(7).level = 2 -ws2.col(8).level = 1 -ws2.col(9).level = 1 - - -ws0.protect = True -ws0.wnd_protect = True -ws0.obj_protect = True -ws0.scen_protect = True -ws0.password = "123456" - -ws1.protect = True -ws1.wnd_protect = True -ws1.obj_protect = True -ws1.scen_protect = True -ws1.password = "abcdefghij" - -ws2.protect = True -ws2.wnd_protect = True -ws2.obj_protect = True -ws2.scen_protect = True -ws2.password = "ok" - -wb.protect = True -wb.wnd_protect = True -wb.obj_protect = True -wb.save('protection.xls') diff --git a/tablib/packages/xlwt/examples/python.bmp b/tablib/packages/xlwt/examples/python.bmp deleted file mode 100644 index bd1ba3f..0000000 Binary files a/tablib/packages/xlwt/examples/python.bmp and /dev/null differ diff --git a/tablib/packages/xlwt/examples/row_styles.py b/tablib/packages/xlwt/examples/row_styles.py deleted file mode 100644 index dd6d494..0000000 --- a/tablib/packages/xlwt/examples/row_styles.py +++ /dev/null @@ -1,17 +0,0 @@ -#!/usr/bin/env python -# -*- coding: windows-1251 -*- -# Copyright (C) 2005 Kiseliov Roman - -from xlwt import * - -w = Workbook() -ws = w.add_sheet('Hey, Dude') - -for i in range(6, 80): - fnt = Font() - fnt.height = i*20 - style = XFStyle() - style.font = fnt - ws.write(i, 1, 'Test') - ws.row(i).set_style(style) -w.save('row_styles.xls') diff --git a/tablib/packages/xlwt/examples/row_styles_empty.py b/tablib/packages/xlwt/examples/row_styles_empty.py deleted file mode 100644 index cf6a65c..0000000 --- a/tablib/packages/xlwt/examples/row_styles_empty.py +++ /dev/null @@ -1,18 +0,0 @@ -#!/usr/bin/env python -# -*- coding: windows-1251 -*- -# Copyright (C) 2005 Kiseliov Roman -__rev_id__ = """$Id: row_styles_empty.py 3309 2008-03-14 11:04:30Z chris $""" - - -from pyExcelerator import * - -w = Workbook() -ws = w.add_sheet('Hey, Dude') - -for i in range(6, 80): - fnt = Font() - fnt.height = i*20 - style = XFStyle() - style.font = fnt - ws.row(i).set_style(style) -w.save('row_styles_empty.xls') diff --git a/tablib/packages/xlwt/examples/simple.py b/tablib/packages/xlwt/examples/simple.py deleted file mode 100644 index 44f7622..0000000 --- a/tablib/packages/xlwt/examples/simple.py +++ /dev/null @@ -1,24 +0,0 @@ -import xlwt -from datetime import datetime - -font0 = xlwt.Font() -font0.name = 'Times New Roman' -font0.colour_index = 2 -font0.bold = True - -style0 = xlwt.XFStyle() -style0.font = font0 - -style1 = xlwt.XFStyle() -style1.num_format_str = 'D-MMM-YY' - -wb = xlwt.Workbook() -ws = wb.add_sheet('A Test Sheet') - -ws.write(0, 0, 'Test', style0) -ws.write(1, 0, datetime.now(), style1) -ws.write(2, 0, 1) -ws.write(2, 1, 1) -ws.write(2, 2, xlwt.Formula("A3+B3")) - -wb.save('example.xls') diff --git a/tablib/packages/xlwt/examples/sst.py b/tablib/packages/xlwt/examples/sst.py deleted file mode 100644 index b91c2f5..0000000 --- a/tablib/packages/xlwt/examples/sst.py +++ /dev/null @@ -1,52 +0,0 @@ -#!/usr/bin/env python -# -*- coding: windows-1251 -*- -# Copyright (C) 2005 Kiseliov Roman - -from xlwt import * - -font0 = Formatting.Font() -font0.name = 'Arial' -font1 = Formatting.Font() -font1.name = 'Arial Cyr' -font2 = Formatting.Font() -font2.name = 'Times New Roman' -font3 = Formatting.Font() -font3.name = 'Courier New Cyr' - -num_format0 = '0.00000' -num_format1 = '0.000000' -num_format2 = '0.0000000' -num_format3 = '0.00000000' - -st0 = XFStyle() -st1 = XFStyle() -st2 = XFStyle() -st3 = XFStyle() -st4 = XFStyle() - -st0.font = font0 -st0.num_format = num_format0 - -st1.font = font1 -st1.num_format = num_format1 - -st2.font = font2 -st2.num_format = num_format2 - -st3.font = font3 -st3.num_format = num_format3 - -wb = Workbook() - -wb.add_style(st0) -wb.add_style(st1) -wb.add_style(st2) -wb.add_style(st3) - -ws0 = wb.add_sheet('0') -ws0.write(0, 0, 'Olya'*0x4000, st0) - -#for i in range(0, 0x10): -# ws0.write(i, 2, ('%d'%i)*0x4000, st1) - -wb.save('sst.xls') diff --git a/tablib/packages/xlwt/examples/unicode0.py b/tablib/packages/xlwt/examples/unicode0.py deleted file mode 100644 index 3651ec9..0000000 --- a/tablib/packages/xlwt/examples/unicode0.py +++ /dev/null @@ -1,12 +0,0 @@ -#!/usr/bin/env python -import xlwt - -# Strings passed to (for example) Worksheet.write can be unicode objects, -# or str (8-bit) objects, which are then decoded into unicode. -# The encoding to be used defaults to 'ascii'. This can be overridden -# when the Workbook instance is created: - -book = xlwt.Workbook(encoding='cp1251') -sheet = book.add_sheet('cp1251-demo') -sheet.write(0, 0, '\xce\xeb\xff') -book.save('unicode0.xls') diff --git a/tablib/packages/xlwt/examples/unicode1.py b/tablib/packages/xlwt/examples/unicode1.py deleted file mode 100644 index 90e99cc..0000000 --- a/tablib/packages/xlwt/examples/unicode1.py +++ /dev/null @@ -1,28 +0,0 @@ -#!/usr/bin/env python -# -*- coding: windows-1251 -*- -# Copyright (C) 2005 Kiseliov Roman - -from xlwt import * - -w = Workbook() -ws1 = w.add_sheet(u'\N{GREEK SMALL LETTER ALPHA}\N{GREEK SMALL LETTER BETA}\N{GREEK SMALL LETTER GAMMA}') - -ws1.write(0, 0, u'\N{GREEK SMALL LETTER ALPHA}\N{GREEK SMALL LETTER BETA}\N{GREEK SMALL LETTER GAMMA}') -ws1.write(1, 1, u'\N{GREEK SMALL LETTER DELTA}x = 1 + \N{GREEK SMALL LETTER DELTA}') - -ws1.write(2,0, u'A\u2262\u0391.') # RFC2152 example -ws1.write(3,0, u'Hi Mom -\u263a-!') # RFC2152 example -ws1.write(4,0, u'\u65E5\u672C\u8A9E') # RFC2152 example -ws1.write(5,0, u'Item 3 is \u00a31.') # RFC2152 example -ws1.write(8,0, u'\N{INTEGRAL}') # RFC2152 example - -w.add_sheet(u'A\u2262\u0391.') # RFC2152 example -w.add_sheet(u'Hi Mom -\u263a-!') # RFC2152 example -one_more_ws = w.add_sheet(u'\u65E5\u672C\u8A9E') # RFC2152 example -w.add_sheet(u'Item 3 is \u00a31.') # RFC2152 example - -one_more_ws.write(0, 0, u'\u2665\u2665') - -w.add_sheet(u'\N{GREEK SMALL LETTER ETA WITH TONOS}') -w.save('unicode1.xls') - diff --git a/tablib/packages/xlwt/examples/unicode2.py b/tablib/packages/xlwt/examples/unicode2.py deleted file mode 100644 index 18904b0..0000000 --- a/tablib/packages/xlwt/examples/unicode2.py +++ /dev/null @@ -1,19 +0,0 @@ -#!/usr/bin/env python -# -*- coding: windows-1251 -*- -# Copyright (C) 2005 Kiseliov Roman - -from xlwt import * - -w = Workbook() -ws1 = w.add_sheet(u'\N{GREEK SMALL LETTER ALPHA}\N{GREEK SMALL LETTER BETA}\N{GREEK SMALL LETTER GAMMA}\u2665\u041e\u041b\u042f\u2665') - -fnt = Font() -fnt.height = 26*20 -style = XFStyle() -style.font = fnt - -for i in range(0x10000): - ws1.write(i/0x10, i%0x10, unichr(i), style) - -w.save('unicode2.xls') - diff --git a/tablib/packages/xlwt/examples/wsprops.py b/tablib/packages/xlwt/examples/wsprops.py deleted file mode 100644 index adc5a04..0000000 --- a/tablib/packages/xlwt/examples/wsprops.py +++ /dev/null @@ -1,155 +0,0 @@ -props = \ -[ - 'name', - 'parent', - 'rows', - 'cols', - 'merged_ranges', - 'bmp_rec', - 'show_formulas', - 'show_grid', - 'show_headers', - 'panes_frozen', - 'show_empty_as_zero', - 'auto_colour_grid', - 'cols_right_to_left', - 'show_outline', - 'remove_splits', - 'selected', - 'hidden', - 'page_preview', - 'first_visible_row', - 'first_visible_col', - 'grid_colour', - 'preview_magn', - 'normal_magn', - 'row_gut_width', - 'col_gut_height', - 'show_auto_page_breaks', - 'dialogue_sheet', - 'auto_style_outline', - 'outline_below', - 'outline_right', - 'fit_num_pages', - 'show_row_outline', - 'show_col_outline', - 'alt_expr_eval', - 'alt_formula_entries', - 'row_default_height', - 'col_default_width', - 'calc_mode', - 'calc_count', - 'RC_ref_mode', - 'iterations_on', - 'delta', - 'save_recalc', - 'print_headers', - 'print_grid', - 'grid_set', - 'vert_page_breaks', - 'horz_page_breaks', - 'header_str', - 'footer_str', - 'print_centered_vert', - 'print_centered_horz', - 'left_margin', - 'right_margin', - 'top_margin', - 'bottom_margin', - 'paper_size_code', - 'print_scaling', - 'start_page_number', - 'fit_width_to_pages', - 'fit_height_to_pages', - 'print_in_rows', - 'portrait', - 'print_not_colour', - 'print_draft', - 'print_notes', - 'print_notes_at_end', - 'print_omit_errors', - 'print_hres', - 'print_vres', - 'header_margin', - 'footer_margin', - 'copies_num', -] - -from xlwt import * - -wb = Workbook() -ws = wb.add_sheet('sheet') - -print ws.name -print ws.parent -print ws.rows -print ws.cols -print ws.merged_ranges -print ws.bmp_rec -print ws.show_formulas -print ws.show_grid -print ws.show_headers -print ws.panes_frozen -print ws.show_empty_as_zero -print ws.auto_colour_grid -print ws.cols_right_to_left -print ws.show_outline -print ws.remove_splits -print ws.selected -# print ws.hidden -print ws.page_preview -print ws.first_visible_row -print ws.first_visible_col -print ws.grid_colour -print ws.preview_magn -print ws.normal_magn -#print ws.row_gut_width -#print ws.col_gut_height -print ws.show_auto_page_breaks -print ws.dialogue_sheet -print ws.auto_style_outline -print ws.outline_below -print ws.outline_right -print ws.fit_num_pages -print ws.show_row_outline -print ws.show_col_outline -print ws.alt_expr_eval -print ws.alt_formula_entries -print ws.row_default_height -print ws.col_default_width -print ws.calc_mode -print ws.calc_count -print ws.RC_ref_mode -print ws.iterations_on -print ws.delta -print ws.save_recalc -print ws.print_headers -print ws.print_grid -#print ws.grid_set -print ws.vert_page_breaks -print ws.horz_page_breaks -print ws.header_str -print ws.footer_str -print ws.print_centered_vert -print ws.print_centered_horz -print ws.left_margin -print ws.right_margin -print ws.top_margin -print ws.bottom_margin -print ws.paper_size_code -print ws.print_scaling -print ws.start_page_number -print ws.fit_width_to_pages -print ws.fit_height_to_pages -print ws.print_in_rows -print ws.portrait -print ws.print_colour -print ws.print_draft -print ws.print_notes -print ws.print_notes_at_end -print ws.print_omit_errors -print ws.print_hres -print ws.print_vres -print ws.header_margin -print ws.footer_margin -print ws.copies_num diff --git a/tablib/packages/xlwt/examples/xlwt_easyxf_simple_demo.py b/tablib/packages/xlwt/examples/xlwt_easyxf_simple_demo.py deleted file mode 100644 index 2afa69f..0000000 --- a/tablib/packages/xlwt/examples/xlwt_easyxf_simple_demo.py +++ /dev/null @@ -1,46 +0,0 @@ - -# Write an XLS file with a single worksheet, containing -# a heading row and some rows of data. - -import xlwt -import datetime -ezxf = xlwt.easyxf - -def write_xls(file_name, sheet_name, headings, data, heading_xf, data_xfs): - book = xlwt.Workbook() - sheet = book.add_sheet(sheet_name) - rowx = 0 - for colx, value in enumerate(headings): - sheet.write(rowx, colx, value, heading_xf) - sheet.set_panes_frozen(True) # frozen headings instead of split panes - sheet.set_horz_split_pos(rowx+1) # in general, freeze after last heading row - sheet.set_remove_splits(True) # if user does unfreeze, don't leave a split there - for row in data: - rowx += 1 - for colx, value in enumerate(row): - sheet.write(rowx, colx, value, data_xfs[colx]) - book.save(file_name) - -if __name__ == '__main__': - import sys - mkd = datetime.date - hdngs = ['Date', 'Stock Code', 'Quantity', 'Unit Price', 'Value', 'Message'] - kinds = 'date text int price money text'.split() - data = [ - [mkd(2007, 7, 1), 'ABC', 1000, 1.234567, 1234.57, ''], - [mkd(2007, 12, 31), 'XYZ', -100, 4.654321, -465.43, 'Goods returned'], - ] + [ - [mkd(2008, 6, 30), 'PQRCD', 100, 2.345678, 234.57, ''], - ] * 100 - - heading_xf = ezxf('font: bold on; align: wrap on, vert centre, horiz center') - kind_to_xf_map = { - 'date': ezxf(num_format_str='yyyy-mm-dd'), - 'int': ezxf(num_format_str='#,##0'), - 'money': ezxf('font: italic on; pattern: pattern solid, fore-colour grey25', - num_format_str='$#,##0.00'), - 'price': ezxf(num_format_str='#0.000000'), - 'text': ezxf(), - } - data_xfs = [kind_to_xf_map[k] for k in kinds] - write_xls('xlwt_easyxf_simple_demo.xls', 'Demo', hdngs, data, heading_xf, data_xfs) diff --git a/tablib/packages/xlwt/excel-formula.g b/tablib/packages/xlwt/excel-formula.g deleted file mode 100644 index d98d9b9..0000000 --- a/tablib/packages/xlwt/excel-formula.g +++ /dev/null @@ -1,374 +0,0 @@ -header { - import struct - import Utils - from UnicodeUtils import upack1 - from ExcelMagic import * - - _RVAdelta = {"R": 0, "V": 0x20, "A": 0x40} - _RVAdeltaRef = {"R": 0, "V": 0x20, "A": 0x40, "D": 0x20} - _RVAdeltaArea = {"R": 0, "V": 0x20, "A": 0x40, "D": 0} - - - class FormulaParseException(Exception): - """ - An exception indicating that a Formula could not be successfully parsed. - """ -} - -header "ExcelFormulaParser.__init__" { - self.rpn = "" - self.sheet_references = [] - self.xcall_references = [] -} - -options { - language = "Python"; -} - -class ExcelFormulaParser extends Parser; -options { - k = 2; - defaultErrorHandler = false; - buildAST = false; -} - - -tokens { - TRUE_CONST; - FALSE_CONST; - STR_CONST; - NUM_CONST; - INT_CONST; - - FUNC_IF; - FUNC_CHOOSE; - NAME; - QUOTENAME; - - EQ; - NE; - GT; - LT; - GE; - LE; - - ADD; - SUB; - MUL; - DIV; - - POWER; - PERCENT; - - LP; - RP; - - LB; - RB; - - COLON; - COMMA; - SEMICOLON; - REF2D; - REF2D_R1C1; - BANG; -} - -formula - : expr["V"] - ; - -expr[arg_type] - : // {print "\n**expr %s" % arg_type} - prec0_expr[arg_type] - ( - ( - EQ { op = struct.pack('B', ptgEQ) } - | NE { op = struct.pack('B', ptgNE) } - | GT { op = struct.pack('B', ptgGT) } - | LT { op = struct.pack('B', ptgLT) } - | GE { op = struct.pack('B', ptgGE) } - | LE { op = struct.pack('B', ptgLE) } - ) - prec0_expr[arg_type] { self.rpn += op } - )* - ; - -prec0_expr[arg_type] - : prec1_expr[arg_type] - ( - ( - CONCAT { op = struct.pack('B', ptgConcat) } - ) - prec1_expr[arg_type] { self.rpn += op } - )* - ; - -prec1_expr[arg_type] - : // {print "**prec1_expr1 %s" % arg_type} - prec2_expr[arg_type] - // {print "**prec1_expr2 %s" % arg_type} - ( - ( - ADD { op = struct.pack('B', ptgAdd) } - | SUB { op = struct.pack('B', ptgSub) } - ) - // {print "**prec1_expr3 %s" % arg_type} - prec2_expr[arg_type] - { self.rpn += op; - // print "**prec1_expr4 %s" % arg_type - } - )* - ; - - -prec2_expr[arg_type] - : prec3_expr[arg_type] - ( - ( - MUL { op = struct.pack('B', ptgMul) } - | DIV { op = struct.pack('B', ptgDiv) } - ) - prec3_expr[arg_type] { self.rpn += op } - )* - ; - -prec3_expr[arg_type] - : prec4_expr[arg_type] - ( - ( - POWER { op = struct.pack('B', ptgPower) } - ) - prec4_expr[arg_type] { self.rpn += op } - )* - ; - -prec4_expr[arg_type] - : prec5_expr[arg_type] - ( - PERCENT { self.rpn += struct.pack('B', ptgPercent) } - )? - ; - -prec5_expr[arg_type] - : primary[arg_type] - | SUB primary[arg_type] { self.rpn += struct.pack('B', ptgUminus) } - ; - -primary[arg_type] - : TRUE_CONST - { - self.rpn += struct.pack("2B", ptgBool, 1) - } - | FALSE_CONST - { - self.rpn += struct.pack("2B", ptgBool, 0) - } - | str_tok:STR_CONST - { - self.rpn += struct.pack("B", ptgStr) + upack1(str_tok.text[1:-1].replace("\"\"", "\"")) - } - | int_tok:INT_CONST - { - // print "**int_const", int_tok.text - int_value = int(int_tok.text) - if int_value <= 65535: - self.rpn += struct.pack("