/usr/lib/python2.6/site-packages/tablib/packages/openpyxl3
Edit: /usr/lib/python2.6/site-packages/tablib/packages/openpyxl3/cell.pyc (13661B)
Ñò
}DVc @ s¿ d Z d Z d d k Z d d k Z d d k l Z d d k l Z l Z l Z d d k
l Z e i d ƒ Z
e i d ƒ Z d
„ Z d „ Z e d „ Z d
„ Z d e f d „ ƒ YZ d S( sü Manage individual cells in a spreadsheet.
The Cell class is required to know its value and type, display options,
and any other features of an Excel cell. Utilities for referencing
cells using Excel's 'A1' column/row nomenclature are also provided.
s restructuredtext eniÿÿÿÿNi ( t
SharedDate( t CellCoordinatesExceptiont ColumnStringIndexExceptiont DataTypeException( t NumberFormats ^[$]?([A-Z]+)[$]?(\d+)$s0 ^[$]?([A-Z]+)[$]?(\d+)(:[$]?([A-Z]+)[$]?(\d+))?$c C sX t i | i ƒ ƒ } | p d | } t | ƒ ‚ n | i ƒ \ } } | t | ƒ f S( s; Convert a coordinate string like 'B12' to a tuple ('B', 12)s Invalid cell coordinates (%s)( t COORD_REt matcht upperR t groupst int( t coord_stringR t msgt columnt row( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyt coordinate_from_string3 s
c C se t i | ƒ i ƒ } t | d ƒ o% d | d | d | d | d f Sd | d | d f Sd S( sD Convert a coordinate to an absolute coordinate string (B12 -> $B$12)iþÿÿÿs
$%s$%s:$%s$%si i i i s $%s$%sN( t ABSOLUTE_RER R t all( R
t parts( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyt absolute_coordinate= s %c C s- | i ƒ } t | ƒ } | o2 t d „ | Dƒ ƒ o d | } t | ƒ ‚ n | d j o t | d ƒ d S| d j o- d t | d ƒ d d t | d ƒ d S| d j oG d t | d ƒ d d
d t | d ƒ d d t | d ƒ d S| d j o t d ƒ ‚ n
t d ƒ ‚ d
S( sG Convert a column letter into a column number (e.g. B -> 2)
Excel only supports 1-3 letter column names from A -> ZZZ, so we
restrict our column names to 1-3 characters, each in the range A-Z.
.. note::
Fast mode is faster but does not check that all letters are capitals between A and Z
c s s0 x) | ]" } d | j o
d j n Vq Wd S( t At ZN( ( t .0t char( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pys
V s s6 Column string must contain only characters A-Z: got %si i i@ i iA i i i¤ s7 Column string index can not be longer than 3 characterss$ Column string index can not be emptyN( R t lenR R t ord( R t fastt clenR ( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyt column_index_from_stringG s
-
G
c C sØ d | j o
d j n p d | } t | ƒ ‚ n g } | } xY | oQ t | d ƒ \ } } | d j o | d 8} d } n | i | d ƒ | } qG W| i ƒ d i g } | D] } | t | ƒ q» ~ ƒ S( sé Convert a column number into a column letter (3 -> 'C')
Right shift the column col_idx by 26 to find column letters in reverse
order. These numbers are 1-based, and can be converted to ASCII
ordinals by adding 64.
i ifG s Column index out of bounds: %si i i@ t ( R t divmodt appendt reverset joint chr( t col_idxR t ordinalst tempt quotientt remaindert _[1]t ordinal( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyt get_column_letterf s
t Cellc B sÑ e Z d Z d9 Z h d d 6d
d 6d d
6d d 6d d 6d d 6d d 6Z d Z d Z d Z d Z d Z d Z
d Z e e e e e e
e g Z h e
i d ƒ d 6e
i d ƒ d 6e
i d ƒ d! 6Z d: d" „ Z d# „ Z d$ „ Z d% „ Z d: e d& „ Z d' „ Z d( „ Z d) „ Z d* „ Z e e e d+ d, ƒZ d- „ Z d. „ Z e e e d+ d/ ƒZ e d0 „ ƒ Z d1 „ Z e d2 „ ƒ Z! e d3 „ ƒ Z" e d4 „ ƒ Z# d5 „ Z$ e d6 „ ƒ Z% d d d7 „ Z& d8 „ Z' RS(; sp Describes cell associated properties.
Properties of interest include style, type, value, and address.
R R
t _valuet
_data_typet parentt xf_indext _hyperlink_reli s #NULL!i s #DIV/0!i s #VALUE!i s #REF!i s #NAME?i s #NUM!i s #N/At st ft nt bt inlineStrt es ^\-?[0-9]*\.?[0-9]*\s?\%$t
percentages( ^(\d|[0-1]\d|2[0-3]):[0-5]\d(:[0-5]\d)?$t times7 ^\-?([0-9]+\.?[0-9]*|[0-9]*\.?[0-9]+)((E|e)\-?[0-9]+)?$t numericc C s` | i ƒ | _ | | _ d | _ d | _ | i | _ | o
| | _ n | | _ d | _
d S( Ni ( R R R
t NoneR+ R/ t TYPE_NULLR, t valueR- R. ( t selft worksheetR R
R; ( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyt __init__§ s
c C s d | i i | i ƒ f S( Ns ( R- t titlet get_coordinate( R< ( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyt __repr__³ s c C s, t | ƒ } | d } | i d d ƒ } | S( s5 Check string coding, length, and line break characteriÿ s
s
( t strt replace( R< R; ( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyt check_string¶ s
c C sP t | t t f ƒ p6 y t | ƒ } WqL t j
o t | ƒ } qL Xn | S( s' Cast value to int or float if necessary( t
isinstanceR t floatt
ValueError( R< R; ( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyt
check_numeric s c C s¥ h | i | i 6| i | i 6t | i 6| i | i 6t | i 6} y | | | ƒ | _ Wn= t
j
o1 | | i j o d | } t | ƒ ‚ q˜ n X| | _
d S( s. Coerce values according to their explicit types Invalid data type: %sN( RD t TYPE_INLINEt TYPE_STRINGRB t TYPE_FORMULARH t TYPE_NUMERICt boolt TYPE_BOOLR+ t KeyErrort VALID_TYPESR R, ( R< R; t data_typet type_coercion_mapR ( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyt set_value_explicitË s
c C s# | d j o
| i } n| t j p
| t j o
| i } nß t | t t f ƒ o
| i } n¼ | p
| i } n¨ t | t
i
t
i f ƒ o
| i } n t | t ƒ o | d d j o
| i
} nQ | i d i | ƒ o
| i } n- | i ƒ | i j o
| i } n
| i } | S( s* Given a value, infer the correct data typei t =R8 N( R9 R: t Truet FalseRN RE R RF RL RJ t datetimet dateRB RK t RE_PATTERNSR t stript ERROR_CODESt
TYPE_ERROR( R< R; RQ ( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyt data_type_for_valueÛ s$
!
c C s‹ | i | ƒ | _ | d j o | i d | i ƒ t S| i | i j o}| i d i | ƒ } | oW | i ƒ d j oD t
| i d d ƒ ƒ d } | i | | i ƒ | i
t i ƒ t S| i d i | ƒ } | oè | i d ƒ } | d j o@ g } | i d ƒ D] } | t | ƒ q ~ \ } } d } nK | d j o= g }
| i d ƒ D] } |
t | ƒ qX~
\ } } } n | d
| d | d } | i | | i ƒ | i
t i ƒ t Sn | i | i j oš t | t i ƒ o3 t | t i ƒ o t i i | t i ƒ ƒ } n t | t i ƒ o= t ƒ i d
| ƒ } | i | | i ƒ | i
t i ƒ t Sn | i | | i ƒ d S( s. Given a value, infer type and display options.R R6 t %g Y@R7 t :i i i g 8@g €–@g õ@RX N( R] R, R9 RS R: RU RJ RY R RZ RF RC RL t _set_number_formatR t FORMAT_PERCENTAGEt countt splitR t FORMAT_DATE_TIME3RE RW RX t combineR7 R t datetime_to_juliant FORMAT_DATE_YYYYMMDD2( R< R; t percentage_searcht time_searcht sep_countR' t bitt hourst minutest secondst _[2]t days( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyt
bind_valueñ sD
6
= c C s0 | i } | i ƒ o t ƒ i | ƒ } n | S( s/ Return the value, formatted as a date if needed( R+ t is_dateR t from_julian( R< R; ( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyt
_get_value s
c C s | i | ƒ d S( s1 Set the value and infer type and display options.N( Rq ( R< R; ( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyt
_set_value# s t docsw Get or set the value held in the cell.
:rtype: depends on the value (string, float, int or :class:`datetime.datetime`)c C sb | i d j o | i i d ƒ | _ n | | i _ d | i _ | i d j o
| | _ n d S( s. Set value and display for hyperlinks in a cellt hyperlinkt ExternalN( R/ R9 R- t create_relationshipt targett target_modeR+ R; ( R< t val( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyt _set_hyperlink, s c C s! | i d j o
| i i p d S( s. Return the hyperlink target or an empty stringR N( R/ R9 Rz ( R< ( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyt _get_hyperlink5 s s× Get or set the hyperlink held in the cell. Automatically sets the `value` of the cell with link text, but you can modify it afterwards by setting the `value` property, and the hyperlink will remain.
:rtype: stringc C s! | i d j o
| i i p d S( s2 Return the id pointed to by the hyperlink, or NoneN( R/ R9 t id( R< ( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyt hyperlink_rel_idA s c C s | | i i _ d S( s, Set a new formatting code for numeric valuesN( t stylet
number_formatt format_code( R< Rƒ ( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyR` G s c C s | i ƒ | i i j S( s7 Check if the parent worksheet has a style for this cell( R@ R- t _styles( R< ( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyt has_styleK s c C s | i i | i ƒ ƒ S( s6 Returns the :class:`.style.Style` object for this cell( R- t get_styleR@ ( R< ( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyR P s c C s | i S( s- Return the data type represented by this cell( R, ( R< ( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyRQ U s c C s d | i | i f S( sX Return the coordinate string for this cell (e.g. 'B12')
:rtype: string
s %s%s( R R
( R< ( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyR@ Z s c C s
| i ƒ S( sX Return the coordinate string for this cell (e.g. 'B12')
:rtype: string
( R@ ( R< ( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyt addressa s c C sC t t d | i ƒ | ƒ } | i | } | i i d | | f ƒ S( sï Returns a cell location relative to this cell.
:param row: number of rows to offset
:type row: int
:param column: number of columns to offset
:type column: int
:rtype: :class:`.cell.Cell`
R s %s%s( R) R R R
R- t cell( R< R
R t
offset_columnt
offset_row( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyt offseti s
c C s3 | i o) | i i i ƒ o t | i t t f ƒ S( s\ Returns whether the value is *probably* a date or not
:rtype: bool
( R… R R‚ t is_date_formatRE R+ R RF ( R< ( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyRr y s
( s columns rows _values
_data_types parents xf_indexs _hyperlink_relN(( t __name__t
__module__t __doc__t __slots__R[ RJ RK RL RN R: RI R\ RP t ret compileRY R9 R> RA RD RH RS R] Rq Rt Ru t propertyR; R} R~ Rw R€ R` R… R RQ R@ R‡ R‹ Rr ( ( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyR* sh
+ ( R t
__docformat__RW R‘ t shared.date_timeR t
shared.excR R R R R R’ R R R R RV R R) t objectR* ( ( ( s> /tmp/pip-build-lt8jXN/tablib/tablib/packages/openpyxl3/cell.pyt s
|