Home
last modified time | relevance | path

Searched refs:xlrd (Results 1 – 25 of 112) sorted by relevance

12345

/dports/textproc/py-xlutils/xlutils-2.0.0/xlutils/
H A Ddisplay.py7 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 Dfilter.py10 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 Dtable_xls.py13 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 DREADME.rst1 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 DPKG-INFO2 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 Drunxlrd.py34 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 DPKG-INFO2 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 Dapi.rst33 >>> 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 Dcopy.rst4 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 Dchanges.rst40 - 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 Dstyles.rst7 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 Dfilter.rst29 >>> 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 Dindex.rst5 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 Ddevelopment.rst17 :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.py6 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 Dxls.py9 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 DPKG-INFO4 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 DREADME.rst19 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 DPKG-INFO4 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 Dfixtures.py10 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 Dxlsw.py12 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 Dxlsr.py12 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.py29 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 Dexcel.py305 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__.py33 import xlrd
35 xlrd_version = LooseVersion(get_version(xlrd))

12345