/usr/lib/python2.6/site-packages/tablib/packages/xlwt
Edit: /usr/lib/python2.6/site-packages/tablib/packages/xlwt/Utils.pyc (5494B)
Ñò
}DVc @ s d Z d d k Z d d k l Z d d k l Z l Z e i d e i ƒ Z e i d ƒ Z
e i d e i ƒ Z e i d e i ƒ Z e i d e i ƒ Z
d
„ Z d „ Z d „ Z e e d
„ Z e e e e d „ Z d „ Z d „ Z d „ Z d „ Z d S( s2 $Id: Utils.py 3844 2009-05-20 01:02:54Z sjmachin $iÿÿÿÿN( t pack( t MAX_ROWt MAX_COLs (\$?)([A-I]?[A-Z])(\$?)(\d+)s \$?(\d+):\$?(\d+)s! \$?([A-I]?[A-Z]):\$?([A-I]?[A-Z])s- \$?([A-I]?[A-Z]\$?\d+):\$?([A-I]?[A-Z]\$?\d+)s \$?([A-I]?[A-Z]\$?\d+)c C sq d } d } xZ t t | ƒ d d d ƒ D]< } | | } | t | ƒ t d ƒ d | 7} | d 9} q) W| d S( s
i i iÿÿÿÿt Ai ( t xranget lent ord( t colnamet colt powt it ch( ( s: /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/Utils.pyt col_by_name- s
"c C sŒ t i | ƒ } | p t d | ƒ ‚ n | i ƒ \ } } } } t | ƒ } t | ƒ } t | ƒ d } t | i ƒ ƒ } | | | | f S( s… Convert an Excel cell reference string in A1 notation
to numeric row/col notation.
Returns: row, col, row_abs, col_abs
s$ Ill-formed single_cell reference: %si ( t _re_cell_ext matcht Exceptiont groupst boolt intR t upper( t cellt mt col_absR t row_abst row( ( s: /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/Utils.pyt cell_to_rowcol9 s c C sj t i | ƒ } | p t d ƒ ‚ n | i ƒ \ } } } } t | ƒ d } t | i ƒ ƒ } | | f S( ss Convert an Excel cell reference string in A1 notation
to numeric row/col notation.
Returns: row, col
s Error in cell formati ( R
R R R R R R ( R R R R R R ( ( s: /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/Utils.pyt cell_to_rowcol2K s c C sñ d | j o
t j n p t ‚ d | j o
t j n p t ‚ | d } | d } d } | o
d } n d } | o
d } n d } | d j o t t d ƒ | d ƒ } n t t d ƒ | ƒ } | | | | t | d ƒ S( s\ Convert numeric row/col notation to an Excel cell reference string in
A1 notation.
i i t t $R i ( R t AssertionErrorR t chrR t str( R R R R t dR t chr1t chr2( ( s: /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/Utils.pyt rowcol_to_cell] s %%
c C sR | | j p t ‚ | | j p t ‚ t | | | | ƒ d t | | | | ƒ S( ss Convert two (row,column) pairs
into a cell range string in A1:B2 notation.
Returns: cell range string
t :( R R# ( t row1t col1t row2t col2t row1_abst col1_abst row2_abst col2_abs( ( s: /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/Utils.pyt rowcol_pair_to_cellrangeu s c C s | i ƒ } t i | ƒ } | oO t | i d ƒ ƒ d } d } t | i d ƒ ƒ d } d } | | | | f St i | ƒ } | oS t | i d ƒ i ƒ ƒ } d } t | i d ƒ i ƒ ƒ } d } | | | | f St i | ƒ } | oG t | i d ƒ ƒ \ } } t | i d ƒ ƒ \ } } | | | | f St i | ƒ } | o, t | i d ƒ ƒ \ } } | | | | f St
d t ƒ ‚ d S( sp Convert cell range string in A1 notation to numeric row/col
pair.
Returns: row1, col1, row2, col2
i i i iÿÿÿÿs Unknown cell reference %sN( R t
_re_row_rangeR R t groupt
_re_col_rangeR t _re_cell_rangeR t _re_cell_refR R ( t cellranget resR% R& R' R( ( ( s: /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/Utils.pyt cellrange_to_rowcol_pair„ s2 c C s” t | ƒ \ } } } } | t j o t d | ƒ ‚ n | t j o t d | t f ƒ ‚ n | t | ƒ d >O} | t | ƒ d >O} | | f S( s5 pack row and column into the required 4 byte format s$ Column %s greater than IV in formulas! Row %s greater than %d in formulai i ( R R R R R ( R R R R R ( ( s: /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/Utils.pyt cell_to_packed_rowcol« s
c C s] | d j p$ | d d j p t | ƒ d j o t Sx | D] } | d j o t Sq= Wt S( Nu i u 'i u []:\?/* ( R t Falset True( t
sheet_namet c( ( s: /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/Utils.pyt valid_sheet_name¸ s 1
c C s9 t | ƒ p t d | ƒ ‚ n d | i d d ƒ d S( Ns- attempt to quote an invalid worksheet name %ru 'u ''( R; R t replace( t unquoted_sheet_name( ( s: /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/Utils.pyt quote_sheet_nameÀ s
( t
__rev_id__t ret structR t
ExcelMagicR R t compilet
IGNORECASER
R. R0 R1 R2 R R R R7 R# R- R5 R6 R; R> ( ( ( s: /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/Utils.pyt
s" '