/dports/textproc/py-xlutils/xlutils-2.0.0/xlutils/ |
H A D | display.py | 7 import xlrd 20 if cty == xlrd.XL_CELL_EMPTY: 22 if cty == xlrd.XL_CELL_BLANK: 24 if cty == xlrd.XL_CELL_NUMBER: 26 if cty == xlrd.XL_CELL_DATE: 29 % xlrd.xldate_as_tuple(cell.value, datemode) 30 except xlrd.xldate.XLDateError: 32 if cty == xlrd.XL_CELL_TEXT: 34 if cty == xlrd.XL_CELL_ERROR: 35 if cell.value in xlrd.error_text_from_code: [all …]
|
H A D | filter.py | 10 import xlrd,xlwt 46 xlrd.open_workbook( 544 if cty == xlrd.XL_CELL_EMPTY: 574 if cty == xlrd.XL_CELL_TEXT: 576 elif cty == xlrd.XL_CELL_NUMBER or cty == xlrd.XL_CELL_DATE: 578 elif cty == xlrd.XL_CELL_BLANK: 580 elif cty == xlrd.XL_CELL_BOOLEAN: 582 elif cty == xlrd.XL_CELL_ERROR: 779 xlrd.open_workbook( 794 if cell.ctype == xlrd.XL_CELL_EMPTY: [all …]
|
/dports/textproc/py-agate-excel/agate-excel-0.2.5/agateexcel/ |
H A D | table_xls.py | 13 import xlrd 16 xlrd.biffh.XL_CELL_EMPTY: agate.Boolean(), 17 xlrd.biffh.XL_CELL_TEXT: agate.Text(), 18 xlrd.biffh.XL_CELL_NUMBER: agate.Number(), 19 xlrd.biffh.XL_CELL_DATE: agate.DateTime(), 20 xlrd.biffh.XL_CELL_BOOLEAN: agate.Boolean(), 21 xlrd.biffh.XL_CELL_ERROR: agate.Text(), 22 xlrd.biffh.XL_CELL_BLANK: agate.Boolean(), 48 except xlrd.compdoc.CompDocError: 160 return xlrd.biffh.XL_CELL_TEXT [all …]
|
/dports/textproc/py-xlrd/xlrd-2.0.1/ |
H A D | README.rst | 1 xlrd chapter 6 .. |Build Status| image:: https://circleci.com/gh/python-excel/xlrd/tree/master.svg?style=shield 7 .. _Build Status: https://circleci.com/gh/python-excel/xlrd/tree/master 10 .. _Coverage Status: https://codecov.io/gh/python-excel/xlrd 12 .. |Documentation| image:: https://readthedocs.org/projects/xlrd/badge/?version=latest 13 .. _Documentation: http://xlrd.readthedocs.io/en/latest/?badge=latest 15 .. |PyPI version| image:: https://badge.fury.io/py/xlrd.svg 16 .. _PyPI version: https://badge.fury.io/py/xlrd 19 xlrd is a library for reading data and formatting information from Excel 42 import xlrd [all …]
|
H A D | PKG-INFO | 2 Name: xlrd 9 Description: xlrd 15 .. _Build Status: https://circleci.com/gh/python-excel/xlrd/tree/master 18 .. _Coverage Status: https://codecov.io/gh/python-excel/xlrd 20 .. |Documentation| image:: https://readthedocs.org/projects/xlrd/badge/?version=latest 21 .. _Documentation: http://xlrd.readthedocs.io/en/latest/?badge=latest 23 .. |PyPI version| image:: https://badge.fury.io/py/xlrd.svg 24 .. _PyPI version: https://badge.fury.io/py/xlrd 27 xlrd is a library for reading data and formatting information from Excel 50 import xlrd [all …]
|
/dports/textproc/py-xlrd/xlrd-2.0.1/scripts/ |
H A D | runxlrd.py | 34 import xlrd 41 from xlrd.timemachine import xrange, REPR 61 null_cell = xlrd.empty_cell 90 if cty == xlrd.XL_CELL_DATE: 93 except xlrd.XLDateError as e: 95 cty = xlrd.XL_CELL_ERROR 96 elif cty == xlrd.XL_CELL_ERROR: 147 % (title, xlrd.cellname(rlo, clo), xlrd.cellname(rhi-1, chi-1))) 292 xlrd.count_records(args[1]) 303 mmap_arg = xlrd.USE_MMAP [all …]
|
/dports/textproc/py-xlrd/xlrd-2.0.1/xlrd.egg-info/ |
H A D | PKG-INFO | 2 Name: xlrd 9 Description: xlrd 15 .. _Build Status: https://circleci.com/gh/python-excel/xlrd/tree/master 18 .. _Coverage Status: https://codecov.io/gh/python-excel/xlrd 20 .. |Documentation| image:: https://readthedocs.org/projects/xlrd/badge/?version=latest 21 .. _Documentation: http://xlrd.readthedocs.io/en/latest/?badge=latest 23 .. |PyPI version| image:: https://badge.fury.io/py/xlrd.svg 24 .. _PyPI version: https://badge.fury.io/py/xlrd 27 xlrd is a library for reading data and formatting information from Excel 50 import xlrd [all …]
|
/dports/textproc/py-xlutils/xlutils-2.0.0/docs/ |
H A D | api.rst | 33 >>> import xlrd 34 >>> from xlrd.sheet import Cell 38 >>> cell_display(Cell(xlrd.XL_CELL_EMPTY, '')) 41 >>> cell_display(Cell(xlrd.XL_CELL_BLANK, '')) 55 >>> from xlrd import open_workbook 146 >>> from xlrd.sheet import Cell,empty_cell 153 >>> from xlrd import XL_CELL_NUMBER 161 >>> from xlrd import XL_CELL_EMPTY 167 >>> from xlrd import XL_CELL_BLANK 173 >>> from xlrd import XL_CELL_NUMBER [all …]
|
H A D | copy.rst | 4 The function in this module copies :class:`xlrd.Book` objects into 9 You would start by opening the file with :mod:`xlrd`: 12 >>> from xlrd import open_workbook 19 You would then use :mod:`xlutils.copy` to copy the :class:`xlrd.Book` 39 This file can now be loaded using :mod:`xlrd` to see the changes: 47 .. note:: You should always pass `on_demand=True` to :func:`~xlrd.open_workbook` as this
|
H A D | changes.rst | 40 - Support for :mod:`xlrd` 0.9.1, which no longer has pickleable 45 :mod:`xlrd` versions earlier that 0.9.1. 55 - As a minimum, :mod:`xlrd` 0.7.2 and :mod:`xlwt` 0.7.4 are now required. 65 - Take advantage of "ragged rows" optimisation in xlrd 0.7.3 96 - Added support for :mod:`xlrd` Books opened with ``on_demand`` as ``True`` passed to 97 :func:`~xlrd.open_workbook`. 101 - Requires the latest versions of :mod:`xlrd` (0.7.1) and :mod:`xlwt` (0.7.2). 120 source workbooks opened by xlrd 0.7.0 and above where 164 - tighten up version requirements for xlrd and xlwt
|
H A D | styles.rst | 7 provided by :mod:`xlrd` relating and expressed in the Excel file as styles. 9 To use these tools, you need to open the workbook with :mod:`xlrd` and make 13 >>> from xlrd import open_workbook 16 Once you have a :class:`~xlrd.Book` object, you can extract the relevent style 46 <xlrd.formatting.XF ...>
|
H A D | filter.rst | 29 >>> from xlrd import open_workbook 148 >>> from xlrd import open_workbook 168 ((<xlrd...Book object at ...>, 'foo.xls'),) 191 >>> from xlrd import XL_CELL_NUMBER 202 call.sheet(<xlrd.sheet.Sheet...>, 'Sheet1'), 209 call.sheet(<xlrd.sheet.Sheet...>, 'Sheet2'), 354 call.sheet(<xlrd.sheet.Sheet...>, 'Sheet1'), 364 call.sheet(<xlrd.sheet.Sheet...>, 'Sheet2'), 367 call.sheet(<xlrd.sheet.Sheet...>, 'Sheet3'), 476 >>> from xlrd import XL_CELL_ERROR [all …]
|
H A D | index.rst | 5 files. Since these utilities may require either or both of the :mod:`xlrd` 11 Tools for copying :class:`xlrd.Book` objects to :class:`xlwt.Workbook` objects. 14 Utility functions for displaying information about :mod:`xlrd`-related 25 Tools for serializing :class:`xlrd.Book` objects back to Excel files.
|
H A D | development.rst | 17 :mod:`xlrd` and :mod:`xlwt`. The following example will set up local 22 git clone git://github.com/python-excel/xlrd.git 39 You will now also need to install xlrd and xlwt into the virtualenv:: 42 $ cd ../xlrd
|
/dports/textproc/py-tablib/tablib-3.1.0/src/tablib/formats/ |
H A D | _xls.py | 6 import xlrd 8 from xlrd.xldate import xldate_as_datetime 25 xlrd.open_workbook(file_contents=stream) 30 xlrd.open_workbook(file_contents=stream.read()) 35 xlrd.open_workbook(filename=stream) 74 xls_book = xlrd.open_workbook(file_contents=in_stream.read()) 80 if type_ == xlrd.XL_CELL_ERROR: 81 return xlrd.error_text_from_code[value] 82 elif type_ == xlrd.XL_CELL_DATE: 103 xls_book = xlrd.open_workbook(file_contents=in_stream)
|
/dports/devel/py-tabulator/tabulator-1.53.5/tabulator/parsers/ |
H A D | xls.py | 9 import xlrd 50 self.__book = xlrd.open_workbook( 57 self.__book = xlrd.open_workbook( 70 except (xlrd.XLRDError, IndexError): 106 if ctype == xlrd.XL_CELL_BOOLEAN: 111 if ctype == xlrd.XL_CELL_NUMBER and value == value // 1: 115 if ctype == xlrd.XL_CELL_DATE: 116 return xlrd.xldate.xldate_as_datetime(value, self.__book.datemode)
|
/dports/textproc/py-xlutils/xlutils-2.0.0/ |
H A D | PKG-INFO | 4 Summary: Utilities for working with Excel files that require both xlrd and xlwt 27 files. Since these utilities may require either or both of the xlrd 34 Tools for copying xlrd.Book objects to xlwt.Workbook objects. 37 Utility functions for displaying information about xlrd-related 48 Tools for serializing xlrd.Book objects back to Excel files. 80 Keywords: excel xls xlrd xlwt
|
H A D | README.rst | 19 files. Since these utilities may require either or both of the xlrd 26 Tools for copying xlrd.Book objects to xlwt.Workbook objects. 29 Utility functions for displaying information about xlrd-related 40 Tools for serializing xlrd.Book objects back to Excel files.
|
/dports/textproc/py-xlutils/xlutils-2.0.0/xlutils.egg-info/ |
H A D | PKG-INFO | 4 Summary: Utilities for working with Excel files that require both xlrd and xlwt 27 files. Since these utilities may require either or both of the xlrd 34 Tools for copying xlrd.Book objects to xlwt.Workbook objects. 37 Utility functions for displaying information about xlrd-related 48 Tools for serializing xlrd.Book objects back to Excel files. 80 Keywords: excel xls xlrd xlwt
|
/dports/textproc/py-xlutils/xlutils-2.0.0/xlutils/tests/ |
H A D | fixtures.py | 10 from xlrd import XL_CELL_TEXT,Book 11 from xlrd.biffh import FUN 12 from xlrd.formatting import XF, Format, Font, XFAlignment, XFBorder, XFBackground, XFProtection 14 from xlrd.sheet import Sheet
|
/dports/textproc/py-pyexcel-xls/pyexcel-xls-0.7.0/pyexcel_xls/ |
H A D | xlsw.py | 12 import xlrd 53 value = xlrd.xldate.xldate_from_datetime_tuple(tmp_array, 0) 62 value = xlrd.xldate.xldate_from_date_tuple(tmp_array, 0) 67 value = xlrd.xldate.xldate_from_time_tuple(tmp_array)
|
H A D | xlsr.py | 12 import xlrd 94 if cell_type == xlrd.XL_CELL_DATE: 96 elif cell_type == xlrd.XL_CELL_NUMBER and self.__auto_detect_int: 99 elif cell_type == xlrd.XL_CELL_ERROR: 165 xls_book = xlrd.open_workbook(**xlrd_params) 199 date_tuple = xlrd.xldate_as_tuple(value, date_mode)
|
/dports/math/py-pandas/pandas-1.2.5/pandas/io/excel/ |
H A D | _xlrd.py | 29 from xlrd import Book 34 from xlrd import open_workbook 55 from xlrd import (
|
/dports/devel/py-frictionless/frictionless-4.18.2/frictionless/plugins/ |
H A D | excel.py | 305 xlrd = helpers.import_from_plugin("xlrd", plugin="excel") 311 book = xlrd.open_workbook( 318 book = xlrd.open_workbook( 331 except (xlrd.XLRDError, IndexError): 342 if ctype == xlrd.XL_CELL_BOOLEAN: 347 if ctype == xlrd.XL_CELL_NUMBER and value == value // 1: 351 if ctype == xlrd.XL_CELL_DATE: 352 return xlrd.xldate.xldate_as_datetime(value, book.datemode)
|
/dports/math/py-pandas/pandas-1.2.5/pandas/tests/io/excel/ |
H A D | __init__.py | 33 import xlrd 35 xlrd_version = LooseVersion(get_version(xlrd))
|