Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package python-agate-excel for
openSUSE:Factory checked in at 2021-08-16 10:11:24
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Comparing /work/SRC/openSUSE:Factory/python-agate-excel (Old)
and /work/SRC/openSUSE:Factory/.python-agate-excel.new.1899 (New)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "python-agate-excel"
Mon Aug 16 10:11:24 2021 rev:6 rq:911882 version:0.2.5
Changes:
--------
--- /work/SRC/openSUSE:Factory/python-agate-excel/python-agate-excel.changes
2020-04-16 23:07:15.947889106 +0200
+++
/work/SRC/openSUSE:Factory/.python-agate-excel.new.1899/python-agate-excel.changes
2021-08-16 10:17:29.498665884 +0200
@@ -1,0 +2,13 @@
+Fri Aug 13 05:07:21 UTC 2021 - Steve Kowalik <steven.kowa...@suse.com>
+
+- Update to 0.2.5:
+ * Add ``six`` to ``install_requires``.
+ * Add ``row_limit`` keyword argument to ``from_xls`` and ``from_xlsx``. (#40)
+ * Preserve column types from XLS files. (#36)
+ * Add support for Compound File Binary File (CFBF) XLS files. (#44)
+ * Close XLSX file before raising error for non-existent sheet. (#34)
+ * Use less memory and close XLS files. (#39)
+ * Drop support for Python 3.4 (end-of-life was March 18, 2019).
+- Update {Build,}Requires.
+
+-------------------------------------------------------------------
Old:
----
0.2.3.tar.gz
New:
----
0.2.5.tar.gz
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Other differences:
------------------
++++++ python-agate-excel.spec ++++++
--- /var/tmp/diff_new_pack.f7VMNN/_old 2021-08-16 10:17:29.922665374 +0200
+++ /var/tmp/diff_new_pack.f7VMNN/_new 2021-08-16 10:17:29.926665370 +0200
@@ -1,7 +1,7 @@
#
# spec file for package python-agate-excel
#
-# Copyright (c) 2020 SUSE LLC
+# Copyright (c) 2021 SUSE LLC
#
# All modifications and additions to the file contributed by third parties
# remain the property of their copyright owners, unless otherwise agreed
@@ -19,22 +19,25 @@
%{?!python_module:%define python_module() python-%{**} python3-%{**}}
%define skip_python2 1
Name: python-agate-excel
-Version: 0.2.3
+Version: 0.2.5
Release: 0
Summary: Read support for Excel files (xls and xlsx) for agate
License: MIT
-Group: Development/Languages/Python
URL: https://github.com/wireservice/agate-excel
Source:
https://github.com/wireservice/agate-excel/archive/%{version}.tar.gz
BuildRequires: %{python_module agate >= 1.5.0}
+BuildRequires: %{python_module olefile}
BuildRequires: %{python_module openpyxl >= 2.3.0}
BuildRequires: %{python_module pytest}
BuildRequires: %{python_module setuptools}
+BuildRequires: %{python_module six}
BuildRequires: %{python_module xlrd >= 0.9.4}
BuildRequires: fdupes
BuildRequires: python-rpm-macros
Requires: python-agate >= 1.5.0
+Requires: python-olefile
Requires: python-openpyxl >= 2.3.0
+Requires: python-six
Requires: python-xlrd >= 0.9.4
BuildArch: noarch
%python_subpackages
++++++ 0.2.3.tar.gz -> 0.2.5.tar.gz ++++++
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/agate-excel-0.2.3/.github/workflows/ci.yml
new/agate-excel-0.2.5/.github/workflows/ci.yml
--- old/agate-excel-0.2.3/.github/workflows/ci.yml 1970-01-01
01:00:00.000000000 +0100
+++ new/agate-excel-0.2.5/.github/workflows/ci.yml 2021-08-09
00:07:03.000000000 +0200
@@ -0,0 +1,29 @@
+name: CI
+on: [push, pull_request]
+jobs:
+ build:
+ runs-on: ${{ matrix.os }}
+ strategy:
+ matrix:
+ os: [macos-latest, windows-latest, ubuntu-latest]
+ python-version: [2.7, 3.6, 3.7, 3.8, 3.9, pypy-2.7, pypy-3.6, pypy-3.7]
+ steps:
+ - uses: actions/checkout@v2
+ - uses: actions/setup-python@v2
+ with:
+ python-version: ${{ matrix.python-version }}
+ #
https://github.com/actions/cache/blob/main/examples.md#using-a-script-to-get-cache-location
+ - id: pip-cache
+ run: python -c "from pip._internal.locations import USER_CACHE_DIR;
print('::set-output name=dir::' + USER_CACHE_DIR)"
+ - uses: actions/cache@v1
+ with:
+ path: ${{ steps.pip-cache.outputs.dir }}
+ key: ${{ runner.os }}-pip-${{ hashFiles('**/setup.py') }}
+ restore-keys: |
+ ${{ runner.os }}-pip-
+ - run: pip install --upgrade check-manifest flake8 isort setuptools
+ - run: check-manifest
+ - run: flake8 .
+ - run: isort . --check-only
+ - run: pip install .[test]
+ - run: nosetests
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/agate-excel-0.2.3/.gitignore
new/agate-excel-0.2.5/.gitignore
--- old/agate-excel-0.2.3/.gitignore 2019-03-16 17:10:42.000000000 +0100
+++ new/agate-excel-0.2.5/.gitignore 2021-08-09 00:07:03.000000000 +0200
@@ -2,7 +2,6 @@
*.pyc
*.swp
*.swo
-.tox
*.egg-info
docs/_build
dist
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/agate-excel-0.2.3/.travis.yml
new/agate-excel-0.2.5/.travis.yml
--- old/agate-excel-0.2.3/.travis.yml 2019-03-16 17:10:42.000000000 +0100
+++ new/agate-excel-0.2.5/.travis.yml 1970-01-01 01:00:00.000000000 +0100
@@ -1,14 +0,0 @@
-dist: xenial
-language: python
-python:
- - "2.7"
- - "3.4"
- - "3.5"
- - "3.6"
- - "3.7"
-# command to install dependencies
-install:
- - if [[ $TRAVIS_PYTHON_VERSION == 3* ]]; then pip install -r
requirements-py3.txt; else pip install -r requirements-py2.txt; fi
-# command to run tests
-script: nosetests tests
-sudo: false
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/agate-excel-0.2.3/AUTHORS.rst
new/agate-excel-0.2.5/AUTHORS.rst
--- old/agate-excel-0.2.3/AUTHORS.rst 2019-03-16 17:10:42.000000000 +0100
+++ new/agate-excel-0.2.5/AUTHORS.rst 2021-08-09 00:07:03.000000000 +0200
@@ -1,10 +1,10 @@
The following individuals have contributed code to agate-excel:
* `Christopher Groskopf <https://github.com/onyxfish>`_
-* `James McKinney <https://github.com/jpmckinney>`_
* `Ben Welsh <https://github.com/palewire>`_
+* `James McKinney <https://github.com/jpmckinney>`_
* `Peter M. Landwehr <https://github.com/pmlandwehr>`_
-* `Tim Freund <https://github.com/timfreund>`_
* `Jani Mikkonen <https://github.com/rasjani>`_
+* `Tim Freund <https://github.com/timfreund>`_
* `Lo??c Corbasson <https://github.com/lcorbasson>`_
* `Robert Sch??tz <https://github.com/dotlambda>`_
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/agate-excel-0.2.3/CHANGELOG.rst
new/agate-excel-0.2.5/CHANGELOG.rst
--- old/agate-excel-0.2.3/CHANGELOG.rst 2019-03-16 17:10:42.000000000 +0100
+++ new/agate-excel-0.2.5/CHANGELOG.rst 2021-08-09 00:07:03.000000000 +0200
@@ -1,5 +1,20 @@
-0.2.3
------
+0.2.5 - August 8, 2021
+----------------------
+
+* Add ``six`` to ``install_requires``.
+
+0.2.4 - July 13, 2021
+---------------------
+
+* Add ``row_limit`` keyword argument to ``from_xls`` and ``from_xlsx``. (#40)
+* Preserve column types from XLS files. (#36)
+* Add support for Compound File Binary File (CFBF) XLS files. (#44)
+* Close XLSX file before raising error for non-existent sheet. (#34)
+* Use less memory and close XLS files. (#39)
+* Drop support for Python 3.4 (end-of-life was March 18, 2019).
+
+0.2.3 - March 16, 2019
+----------------------
* Fix bug in accepting ``column_names`` as keyword argument.
* Add a ``reset_dimensions`` argument to :meth:`.Table.from_xlsx` to
recalculate the data's dimensions, instead of trusting those in the file's
properties.
@@ -24,8 +39,8 @@
* Fix bug in handling an empty XLS.
* Fix bug in handling non-string column names in XLSX.
-0.2.0
------
+0.2.0 - December 19, 2016
+-------------------------
* Fix bug in handling of ``None`` in boolean columns for XLS. (#11)
* Removed usage of deprecated openpyxl method ``get_sheet_by_name``.
@@ -33,7 +48,7 @@
* Upgrade required agate version to ``1.5.0``.
* Ensure columns with numbers for names (e.g. years) are parsed as strings.
-0.1.0
------
+0.1.0 - February 5, 2016
+------------------------
* Initial version.
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/agate-excel-0.2.3/MANIFEST.in
new/agate-excel-0.2.5/MANIFEST.in
--- old/agate-excel-0.2.3/MANIFEST.in 2019-03-16 17:10:42.000000000 +0100
+++ new/agate-excel-0.2.5/MANIFEST.in 2021-08-09 00:07:03.000000000 +0200
@@ -1,5 +1,9 @@
+include *.py
+include *.rst
include COPYING
-include AUTHORS.rst
-include README.rst
+recursive-include docs *.py
+recursive-include docs *.rst
+recursive-include docs Makefile
+recursive-include examples *.xls
+recursive-include examples *.xlsx
recursive-include tests *.py
-graft examples
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/agate-excel-0.2.3/README.rst
new/agate-excel-0.2.5/README.rst
--- old/agate-excel-0.2.3/README.rst 2019-03-16 17:10:42.000000000 +0100
+++ new/agate-excel-0.2.5/README.rst 2021-08-09 00:07:03.000000000 +0200
@@ -1,7 +1,11 @@
-.. image:: https://travis-ci.org/wireservice/agate-excel.png
- :target: https://travis-ci.org/wireservice/agate-excel
+.. image:: https://github.com/wireservice/agate-excel/workflows/CI/badge.svg
+ :target: https://github.com/wireservice/agate-excel/actions
:alt: Build status
+.. image:: https://img.shields.io/pypi/dm/agate-excel.svg
+ :target: https://pypi.python.org/pypi/agate-excel
+ :alt: PyPI downloads
+
.. image:: https://img.shields.io/pypi/v/agate-excel.svg
:target: https://pypi.python.org/pypi/agate-excel
:alt: Version
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/agate-excel-0.2.3/agateexcel/table_xls.py
new/agate-excel-0.2.5/agateexcel/table_xls.py
--- old/agate-excel-0.2.3/agateexcel/table_xls.py 2019-03-16
17:10:42.000000000 +0100
+++ new/agate-excel-0.2.5/agateexcel/table_xls.py 2021-08-09
00:07:03.000000000 +0200
@@ -8,11 +8,22 @@
from collections import OrderedDict
import agate
+import olefile
import six
import xlrd
+EXCEL_TO_AGATE_TYPE = {
+ xlrd.biffh.XL_CELL_EMPTY: agate.Boolean(),
+ xlrd.biffh.XL_CELL_TEXT: agate.Text(),
+ xlrd.biffh.XL_CELL_NUMBER: agate.Number(),
+ xlrd.biffh.XL_CELL_DATE: agate.DateTime(),
+ xlrd.biffh.XL_CELL_BOOLEAN: agate.Boolean(),
+ xlrd.biffh.XL_CELL_ERROR: agate.Text(),
+ xlrd.biffh.XL_CELL_BLANK: agate.Boolean(),
+}
-def from_xls(cls, path, sheet=None, skip_lines=0, header=True,
encoding_override=None, **kwargs):
+
+def from_xls(cls, path, sheet=None, skip_lines=0, header=True,
encoding_override=None, row_limit=None, **kwargs):
"""
Parse an XLS file.
@@ -25,70 +36,104 @@
The number of rows to skip from the top of the sheet.
:param header:
If :code:`True`, the first row is assumed to contain column names.
+ :param row_limit:
+ Limit how many rows of data will be read.
"""
if not isinstance(skip_lines, int):
raise ValueError('skip_lines argument must be an int')
+ def open_workbook(f):
+ try:
+ book = xlrd.open_workbook(file_contents=f.read(),
encoding_override=encoding_override, on_demand=True)
+ except xlrd.compdoc.CompDocError:
+ # This is not a pure XLS file; we'll try to read it though.
+ # Let's try the Compound File Binary Format:
+ ole = olefile.OleFileIO(f)
+ if ole.exists('Workbook'):
+ d = ole.openstream('Workbook')
+ book = xlrd.open_workbook(file_contents=d.read(),
on_demand=True)
+ else:
+ raise IOError('No Workbook stream found in OLE file')
+ return book
+
if hasattr(path, 'read'):
- book = xlrd.open_workbook(file_contents=path.read(),
encoding_override=encoding_override)
+ book = open_workbook(path)
else:
with open(path, 'rb') as f:
- book = xlrd.open_workbook(file_contents=f.read(),
encoding_override=encoding_override)
-
- multiple = agate.utils.issequence(sheet)
- if multiple:
- sheets = sheet
- else:
- sheets = [sheet]
+ book = open_workbook(f)
- tables = OrderedDict()
-
- for i, sheet in enumerate(sheets):
- if isinstance(sheet, six.string_types):
- sheet = book.sheet_by_name(sheet)
- elif isinstance(sheet, int):
- sheet = book.sheet_by_index(sheet)
- else:
- sheet = book.sheet_by_index(0)
-
- if header:
- offset = 1
- column_names = []
+ try:
+ multiple = agate.utils.issequence(sheet)
+ if multiple:
+ sheets = sheet
else:
- offset = 0
- column_names = None
+ sheets = [sheet]
- columns = []
+ tables = OrderedDict()
- for i in range(sheet.ncols):
- data = sheet.col_values(i)
- values = data[skip_lines + offset:]
- types = sheet.col_types(i)[skip_lines + offset:]
- excel_type = determine_excel_type(types)
-
- if excel_type == xlrd.biffh.XL_CELL_BOOLEAN:
- values = normalize_booleans(values)
- elif excel_type == xlrd.biffh.XL_CELL_DATE:
- values = normalize_dates(values, book.datemode)
+ for i, sheet in enumerate(sheets):
+ if isinstance(sheet, six.string_types):
+ sheet = book.sheet_by_name(sheet)
+ elif isinstance(sheet, int):
+ sheet = book.sheet_by_index(sheet)
+ else:
+ sheet = book.sheet_by_index(0)
if header:
- name = six.text_type(data[skip_lines]) or None
- column_names.append(name)
+ offset = 1
+ column_names = []
+ else:
+ offset = 0
+ column_names = None
+
+ columns = []
+ column_types = []
+
+ for i in range(sheet.ncols):
+ if row_limit is None:
+ values = sheet.col_values(i, skip_lines + offset)
+ types = sheet.col_types(i, skip_lines + offset)
+ else:
+ values = sheet.col_values(i, skip_lines + offset,
skip_lines + offset + row_limit)
+ types = sheet.col_types(i, skip_lines + offset, skip_lines
+ offset + row_limit)
+ excel_type = determine_excel_type(types)
+ agate_type = determine_agate_type(excel_type)
+
+ if excel_type == xlrd.biffh.XL_CELL_BOOLEAN:
+ values = normalize_booleans(values)
+ elif excel_type == xlrd.biffh.XL_CELL_DATE:
+ values, with_date, with_time = normalize_dates(values,
book.datemode)
+ if not with_date:
+ agate_type = agate.TimeDelta()
+ if not with_time:
+ agate_type = agate.Date()
+
+ if header:
+ name = six.text_type(sheet.cell_value(skip_lines, i)) or
None
+ column_names.append(name)
+
+ columns.append(values)
+ column_types.append(agate_type)
+
+ rows = []
+
+ if columns:
+ for i in range(len(columns[0])):
+ rows.append([c[i] for c in columns])
+
+ if 'column_names' in kwargs:
+ if not header:
+ column_names = kwargs['column_names']
+ del kwargs['column_names']
+
+ if 'column_types' in kwargs:
+ column_types = kwargs['column_types']
+ del kwargs['column_types']
- columns.append(values)
+ tables[sheet.name] = agate.Table(rows, column_names, column_types,
**kwargs)
- rows = []
-
- if columns:
- for i in range(len(columns[0])):
- rows.append([c[i] for c in columns])
-
- if 'column_names' in kwargs:
- if not header:
- column_names = kwargs['column_names']
- del kwargs['column_names']
-
- tables[sheet.name] = agate.Table(rows, column_names, **kwargs)
+ finally:
+ book.release_resources()
if multiple:
return agate.MappedSequence(tables.values(), tables.keys())
@@ -96,6 +141,13 @@
return tables.popitem()[1]
+def determine_agate_type(excel_type):
+ try:
+ return EXCEL_TO_AGATE_TYPE[excel_type]
+ except KeyError:
+ return agate.Text()
+
+
def determine_excel_type(types):
"""
Determine the correct type for a column from a list of cell types.
@@ -130,6 +182,8 @@
Normalize a column of date cells.
"""
normalized = []
+ with_date = False
+ with_time = False
for v in values:
if not v:
@@ -141,13 +195,18 @@
if v_tuple[3:6] == (0, 0, 0):
# Date only
normalized.append(datetime.date(*v_tuple[:3]))
+ with_date = True
elif v_tuple[:3] == (0, 0, 0):
+ # Time only
normalized.append(datetime.time(*v_tuple[3:6]))
+ with_time = True
else:
# Date and time
normalized.append(datetime.datetime(*v_tuple[:6]))
+ with_date = True
+ with_time = True
- return normalized
+ return (normalized, with_date, with_time)
agate.Table.from_xls = classmethod(from_xls)
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/agate-excel-0.2.3/agateexcel/table_xlsx.py
new/agate-excel-0.2.5/agateexcel/table_xlsx.py
--- old/agate-excel-0.2.3/agateexcel/table_xlsx.py 2019-03-16
17:10:42.000000000 +0100
+++ new/agate-excel-0.2.5/agateexcel/table_xlsx.py 2021-08-09
00:07:03.000000000 +0200
@@ -14,8 +14,8 @@
NULL_TIME = datetime.time(0, 0, 0)
-def from_xlsx(cls, path, sheet=None, skip_lines=0, header=True,
read_only=True,
- reset_dimensions=False, **kwargs):
+def from_xlsx(cls, path, sheet=None, skip_lines=0, header=True, read_only=True,
+ reset_dimensions=False, row_limit=None, **kwargs):
"""
Parse an XLSX file.
@@ -29,8 +29,10 @@
:param header:
If :code:`True`, the first row is assumed to contain column names.
:param reset_dimensions:
- If :code:`True`, do not trust the dimensions in the file's properties,
+ If :code:`True`, do not trust the dimensions in the file's properties,
and recalculate them based on the data in the file.
+ :param row_limit:
+ Limit how many rows of data will be read.
"""
if not isinstance(skip_lines, int):
raise ValueError('skip_lines argument must be an int')
@@ -52,23 +54,38 @@
for i, sheet in enumerate(sheets):
if isinstance(sheet, six.string_types):
- sheet = book[sheet]
+ try:
+ sheet = book[sheet]
+ except KeyError:
+ f.close()
+ raise
elif isinstance(sheet, int):
- sheet = book.worksheets[sheet]
+ try:
+ sheet = book.worksheets[sheet]
+ except IndexError:
+ f.close()
+ raise
else:
sheet = book.active
column_names = None
+ offset = 0
rows = []
if reset_dimensions:
sheet.reset_dimensions()
- for i, row in enumerate(sheet.iter_rows(min_row=skip_lines + 1)):
- if i == 0 and header:
- column_names = [None if c.value is None else
six.text_type(c.value) for c in row]
- continue
+ if header:
+ sheet_header = sheet.iter_rows(min_row=1 + skip_lines, max_row=1 +
skip_lines)
+ column_names = [None if c.value is None else
six.text_type(c.value) for row in sheet_header for c in row]
+ offset = 1
+ if row_limit is None:
+ sheet_rows = sheet.iter_rows(min_row=1 + skip_lines + offset)
+ else:
+ sheet_rows = sheet.iter_rows(min_row=1 + skip_lines + offset,
max_row=1 + skip_lines + offset + row_limit)
+
+ for i, row in enumerate(sheet_rows):
values = []
for c in row:
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/agate-excel-0.2.3/docs/conf.py
new/agate-excel-0.2.5/docs/conf.py
--- old/agate-excel-0.2.3/docs/conf.py 2019-03-16 17:10:42.000000000 +0100
+++ new/agate-excel-0.2.5/docs/conf.py 2021-08-09 00:07:03.000000000 +0200
@@ -1,7 +1,5 @@
# -*- coding: utf-8 -*-
#
-# flake8: noqa
-#
# This file is execfile()d with the current directory set to its containing
dir.
#
# Note that not all possible configuration values are present in this
@@ -54,9 +52,9 @@
# built documents.
#
# The short X.Y version.
-version = '0.2.3'
+version = '0.2.5'
# The full version, including alpha/beta/rc tags.
-release = '0.2.3'
+release = version
# The language for content autogenerated by Sphinx. Refer to documentation
# for a list of supported languages.
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/agate-excel-0.2.3/example.py
new/agate-excel-0.2.5/example.py
--- old/agate-excel-0.2.3/example.py 2019-03-16 17:10:42.000000000 +0100
+++ new/agate-excel-0.2.5/example.py 2021-08-09 00:07:03.000000000 +0200
@@ -1,7 +1,8 @@
#!/usr/bin/env python
import agate
-import agateexcel # noqa
+
+import agateexcel
table = agate.Table.from_xls('examples/test.xls')
Binary files old/agate-excel-0.2.3/examples/test_skip_lines.xls and
new/agate-excel-0.2.5/examples/test_skip_lines.xls differ
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/agate-excel-0.2.3/requirements-py2.txt
new/agate-excel-0.2.5/requirements-py2.txt
--- old/agate-excel-0.2.3/requirements-py2.txt 2019-03-16 17:10:42.000000000
+0100
+++ new/agate-excel-0.2.5/requirements-py2.txt 1970-01-01 01:00:00.000000000
+0100
@@ -1,10 +0,0 @@
-unittest2==0.5.1
-nose>=1.1.2
-tox>=1.3
-Sphinx>=1.2.2
-sphinx_rtd_theme>=0.1.6
-wheel>=0.24.0
-ordereddict>=1.1
-xlrd>=0.9.4
-openpyxl>=2.3.0
-agate>=1.2.2
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/agate-excel-0.2.3/requirements-py3.txt
new/agate-excel-0.2.5/requirements-py3.txt
--- old/agate-excel-0.2.3/requirements-py3.txt 2019-03-16 17:10:42.000000000
+0100
+++ new/agate-excel-0.2.5/requirements-py3.txt 1970-01-01 01:00:00.000000000
+0100
@@ -1,8 +0,0 @@
-nose>=1.1.2
-tox>=3.1.0
-Sphinx>=1.2.2
-sphinx_rtd_theme>=0.1.6
-wheel>=0.24.0
-xlrd>=0.9.4
-openpyxl>=2.3.0
-agate>=1.2.2
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/agate-excel-0.2.3/setup.cfg
new/agate-excel-0.2.5/setup.cfg
--- old/agate-excel-0.2.3/setup.cfg 2019-03-16 17:10:42.000000000 +0100
+++ new/agate-excel-0.2.5/setup.cfg 2021-08-09 00:07:03.000000000 +0200
@@ -1,2 +1,14 @@
+[flake8]
+max-line-length = 119
+per-file-ignores =
+ # imported but unused
+ agateexcel/__init__.py: F401
+ example.py: F401
+ # block comment should start with '# '
+ docs/conf.py: E265
+
+[isort]
+line_length = 119
+
[bdist_wheel]
universal = 1
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/agate-excel-0.2.3/setup.py
new/agate-excel-0.2.5/setup.py
--- old/agate-excel-0.2.3/setup.py 2019-03-16 17:10:42.000000000 +0100
+++ new/agate-excel-0.2.5/setup.py 2021-08-09 00:07:03.000000000 +0200
@@ -1,18 +1,14 @@
-#!/usr/bin/env python
+from setuptools import find_packages, setup
-from setuptools import setup
-
-install_requires = [
- 'agate>=1.5.0',
- 'xlrd>=0.9.4',
- 'openpyxl>=2.3.0'
-]
+with open('README.rst') as f:
+ long_description = f.read()
setup(
name='agate-excel',
- version='0.2.3',
+ version='0.2.5',
description='agate-excel adds read support for Excel files (xls and xlsx)
to agate.',
- long_description=open('README.rst').read(),
+ long_description=long_description,
+ long_description_content_type='text/x-rst',
author='Christopher Groskopf',
author_email='chrisgrosk...@gmail.com',
url='http://agate-excel.readthedocs.org/',
@@ -26,19 +22,30 @@
'Operating System :: OS Independent',
'Programming Language :: Python',
'Programming Language :: Python :: 2.7',
- 'Programming Language :: Python :: 3.4',
- 'Programming Language :: Python :: 3.5',
'Programming Language :: Python :: 3.6',
'Programming Language :: Python :: 3.7',
+ 'Programming Language :: Python :: 3.8',
+ 'Programming Language :: Python :: 3.9',
'Programming Language :: Python :: Implementation :: CPython',
'Programming Language :: Python :: Implementation :: PyPy',
- 'Topic :: Multimedia :: Graphics',
'Topic :: Scientific/Engineering :: Information Analysis',
- 'Topic :: Scientific/Engineering :: Visualization',
'Topic :: Software Development :: Libraries :: Python Modules',
],
- packages=[
- 'agateexcel'
+ packages=find_packages(exclude=['tests', 'tests.*']),
+ install_requires=[
+ 'agate>=1.5.0',
+ 'olefile',
+ 'openpyxl>=2.3.0',
+ 'six',
+ 'xlrd>=0.9.4',
],
- install_requires=install_requires
+ extras_require={
+ 'test': [
+ 'nose>=1.1.2',
+ ],
+ 'docs': [
+ 'Sphinx>=1.2.2',
+ 'sphinx_rtd_theme>=0.1.6',
+ ],
+ }
)
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/agate-excel-0.2.3/tests/test_table_xls.py
new/agate-excel-0.2.5/tests/test_table_xls.py
--- old/agate-excel-0.2.3/tests/test_table_xls.py 2019-03-16
17:10:42.000000000 +0100
+++ new/agate-excel-0.2.5/tests/test_table_xls.py 2021-08-09
00:07:03.000000000 +0200
@@ -4,7 +4,8 @@
import datetime
import agate
-import agateexcel # noqa
+
+import agateexcel # noqa: F401
class TestXLS(agate.AgateTestCase):
@@ -31,7 +32,8 @@
self.table = agate.Table(self.rows, self.column_names,
self.column_types)
def test_from_xls_with_column_names(self):
- table = agate.Table.from_xls('examples/test.xls', header=False,
skip_lines=1, column_names=self.user_provided_column_names )
+ table = agate.Table.from_xls('examples/test.xls', header=False,
skip_lines=1,
+
column_names=self.user_provided_column_names)
self.assertColumnNames(table, self.user_provided_column_names)
self.assertColumnTypes(table, [agate.Number, agate.Text,
agate.Boolean, agate.Date, agate.DateTime])
@@ -135,3 +137,17 @@
self.assertRows(table, [
['Canada', 35160000, 'value'],
])
+
+ def test_row_limit(self):
+ table = agate.Table.from_xls('examples/test.xls', row_limit=2)
+
+ self.assertColumnNames(table, self.column_names)
+ self.assertColumnTypes(table, [agate.Number, agate.Text,
agate.Boolean, agate.Date, agate.DateTime])
+ self.assertRows(table, [r.values() for r in self.table.rows][:2])
+
+ def test_row_limit_too_high(self):
+ table = agate.Table.from_xls('examples/test.xls', row_limit=200)
+
+ self.assertColumnNames(table, self.column_names)
+ self.assertColumnTypes(table, [agate.Number, agate.Text,
agate.Boolean, agate.Date, agate.DateTime])
+ self.assertRows(table, [r.values() for r in self.table.rows])
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/agate-excel-0.2.3/tests/test_table_xlsx.py
new/agate-excel-0.2.5/tests/test_table_xlsx.py
--- old/agate-excel-0.2.3/tests/test_table_xlsx.py 2019-03-16
17:10:42.000000000 +0100
+++ new/agate-excel-0.2.5/tests/test_table_xlsx.py 2021-08-09
00:07:03.000000000 +0200
@@ -4,7 +4,9 @@
import datetime
import agate
-import agateexcel # noqa
+import six
+
+import agateexcel # noqa: F401
class TestXLSX(agate.AgateTestCase):
@@ -31,7 +33,8 @@
self.table = agate.Table(self.rows, self.column_names,
self.column_types)
def test_from_xlsx_with_column_names(self):
- table = agate.Table.from_xlsx('examples/test.xlsx', header=False,
skip_lines=1, column_names=self.user_provided_column_names)
+ table = agate.Table.from_xlsx('examples/test.xlsx', header=False,
skip_lines=1,
+
column_names=self.user_provided_column_names)
self.assertColumnNames(table, self.user_provided_column_names)
self.assertColumnTypes(table, [agate.Number, agate.Text,
agate.Boolean, agate.Date, agate.DateTime])
@@ -103,10 +106,16 @@
def test_ambiguous_date(self):
table = agate.Table.from_xlsx('examples/test_ambiguous_date.xlsx')
+ # openpyxl >= 3 fixes a bug, but Python 2 is constrained to openpyxl <
3.
+ if six.PY2:
+ expected = datetime.date(1899, 12, 31)
+ else:
+ expected = datetime.date(1900, 1, 1)
+
self.assertColumnNames(table, ['s'])
self.assertColumnTypes(table, [agate.Date])
self.assertRows(table, [
- [datetime.date(1899, 12, 31)],
+ [expected],
])
def test_empty(self):
@@ -124,3 +133,17 @@
self.assertRows(table, [
['Canada', 35160000, 'value'],
])
+
+ def test_row_limit(self):
+ table = agate.Table.from_xlsx('examples/test.xlsx', row_limit=2)
+
+ self.assertColumnNames(table, self.column_names)
+ self.assertColumnTypes(table, [agate.Number, agate.Text,
agate.Boolean, agate.Date, agate.DateTime])
+ self.assertRows(table, [r.values() for r in self.table.rows][:2])
+
+ def test_row_limit_too_high(self):
+ table = agate.Table.from_xlsx('examples/test.xlsx', row_limit=200)
+
+ self.assertColumnNames(table, self.column_names)
+ self.assertColumnTypes(table, [agate.Number, agate.Text,
agate.Boolean, agate.Date, agate.DateTime])
+ self.assertRows(table, [r.values() for r in self.table.rows])
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/agate-excel-0.2.3/tox.ini
new/agate-excel-0.2.5/tox.ini
--- old/agate-excel-0.2.3/tox.ini 2019-03-16 17:10:42.000000000 +0100
+++ new/agate-excel-0.2.5/tox.ini 1970-01-01 01:00:00.000000000 +0100
@@ -1,32 +0,0 @@
-[tox]
-envlist = py27,py34,py35,py36,py37,pypy
-
-[testenv]
-deps=
- nose>=1.1.2
- six>=1.6.1
-commands=nosetests
-
-[testenv:py27]
-deps=
- {[testenv]deps}
-
-[testenv:py34]
-deps=
- {[testenv]deps}
-
-[testenv:py35]
-deps=
- {[testenv:py33]deps}
-
-[testenv:py36]
-deps=
- {[testenv:py33]deps}
-
-[testenv:py37]
-deps=
- {[testenv:py33]deps}
-
-[testenv:pypy]
-deps=
- {[testenv:py33]deps}
