from __future__ import absolute_import # Copyright (c) 2010-2016 openpyxl from openpyxl import __version__ VERSION = ".".join(__version__.split(".")[:2]) from openpyxl.compat import unicode from openpyxl.descriptors.serialisable import Serialisable from openpyxl.descriptors import ( Typed, ) from openpyxl.descriptors.nested import ( NestedText, ) from openpyxl.xml.constants import XPROPS_NS class DigSigBlob(Serialisable): __elements__ = __attrs__ = () class VectorLpstr(Serialisable): __elements__ = __attrs__ = () class VectorVariant(Serialisable): __elements__ = __attrs__ = ()
def _get_value(self, cls, req, **kwargs): return kwargs.get('mimetype') class filename_ext(ExpectedValuePredicate): """ a selector for converters """ def _get_value(self, cls, req, **kwargs): fname = kwargs.get('filename') if fname: return osp.splitext(fname)[1] return fname if utils.HANDLE_XLSX: from openpyxl import __version__ _old_openpyxl_version = __version__.split('.') < (1, 9, 0) def rows(sheet): if _old_openpyxl_version: return sheet.iter_rows() else: return sheet.rows def value(cell): if _old_openpyxl_version: return cell.internal_value else: return cell.value # importers ####################################################################
def get_version(): from openpyxl import __version__ VERSION = ".".join(__version__.split(".")[:2]) return VERSION
def get_version(): from openpyxl import __version__ VERSION = ".".join(__version__.split(".")[:2]) return VERSION
from __future__ import absolute_import # Copyright (c) 2010-2016 openpyxl from openpyxl import __version__ VERSION = ".".join(__version__.split(".")[:2]) from openpyxl.compat import basestring from openpyxl.descriptors.serialisable import Serialisable from openpyxl.descriptors import ( Typed, ) from openpyxl.descriptors.nested import ( NestedText, ) from openpyxl.xml.constants import XPROPS_NS class DigSigBlob(Serialisable): __elements__ = __attrs__ = () class VectorLpstr(Serialisable): __elements__ = __attrs__ = () class VectorVariant(Serialisable):
# coding: utf-8 from collections import OrderedDict from openpyxl import load_workbook, Workbook from openpyxl import __version__ openpyxl_version = int(__version__.split(".")[0]) class UnicodeReader(object): def __init__(self, filename, sheet_name_or_num=0): """ Iterate quickly row-by-row through an Excel file. If you want to access a specific row, simply read the whole file with: rows = [row for row in UnicodeReader('myfile.xls')] ... and then access the intended row in the usual fashion. """ self.__wb = load_workbook(filename=filename, read_only=True) self._sheet = None self.change_sheet(sheet_name_or_num) def change_sheet(self, sheet_name_or_num): """ Calling this method changes the sheet in anticipation for the next time you create an iterator.