/usr/lib/python2.6/site-packages/tablib/packages/xlwt3
Edit: /usr/lib/python2.6/site-packages/tablib/packages/xlwt3/BIFFRecords.pyc (112961B)
Ñò
}DVc @ s d d k l Z d d k l Z l Z d d k Z d e f d „ ƒ YZ d e f d „ ƒ YZ d e f d
„ ƒ YZ d e f d „ ƒ YZ
d
e f d „ ƒ YZ d e f d „ ƒ YZ d e f d „ ƒ YZ
d e f d „ ƒ YZ d e f d „ ƒ YZ d e f d „ ƒ YZ d e f d „ ƒ YZ d e f d „ ƒ YZ d e f d „ ƒ YZ d e f d „ ƒ YZ d! e f d" „ ƒ YZ d# e f d$ „ ƒ YZ d% e f d& „ ƒ YZ d' e f d( „ ƒ YZ d) e f d* „ ƒ YZ d+ e f d, „ ƒ YZ d- e f d. „ ƒ YZ d/ e f d0 „ ƒ YZ d1 e f d2 „ ƒ YZ d3 e f d4 „ ƒ YZ d5 e f d6 „ ƒ YZ d7 e f d8 „ ƒ YZ d9 e f d: „ ƒ YZ! d; e f d< „ ƒ YZ" d= e f d> „ ƒ YZ# d? e f d@ „ ƒ YZ$ dA e f dB „ ƒ YZ% dC e f dD „ ƒ YZ& dE e f dF „ ƒ YZ' dG e f dH „ ƒ YZ( dI e f dJ „ ƒ YZ) dK e f dL „ ƒ YZ* dM e f dN „ ƒ YZ+ dO e f dP „ ƒ YZ, dQ e f dR „ ƒ YZ- dS e f dT „ ƒ YZ. dU e f dV „ ƒ YZ/ dW e f dX „ ƒ YZ0 dY e f dZ „ ƒ YZ1 d[ e f d\ „ ƒ YZ2 d] e f d^ „ ƒ YZ3 d_ e f d` „ ƒ YZ4 da e f db „ ƒ YZ5 dc e f dd „ ƒ YZ6 de e f df „ ƒ YZ7 dg e f dh „ ƒ YZ8 di e f dj „ ƒ YZ9 dk e f dl „ ƒ YZ: dm e f dn „ ƒ YZ; do e f dp „ ƒ YZ< dq e f dr „ ƒ YZ= ds e f dt „ ƒ YZ> du e f dv „ ƒ YZ? dw e f dx „ ƒ YZ@ dy e f dz „ ƒ YZA d{ e f d| „ ƒ YZB d} e f d~ „ ƒ YZC d e f d€ „ ƒ YZD d e f d‚ „ ƒ YZE dƒ e f d„ „ ƒ YZF d… e f d† „ ƒ YZG d‡ e f dˆ „ ƒ YZH d‰ e f dŠ „ ƒ YZI d‹ e f dŒ „ ƒ YZJ d e f dŽ „ ƒ YZK d e f d „ ƒ YZL d‘ e f d’ „ ƒ YZM d“ e f d” „ ƒ YZN d• e f d– „ ƒ YZO d— e f d˜ „ ƒ YZP d™ e f dš „ ƒ YZQ d› ZR dœ e f d „ ƒ YZS dž e f dŸ „ ƒ YZT d eT f d¡ „ ƒ YZU d¢ eT f d£ „ ƒ YZV d¤ e f d¥ „ ƒ YZW d S(¦ iÿÿÿÿ( t packi ( t upack1t upack2Nt SharedStringTablec B se e Z d Z d Z d „ Z d „ Z d „ Z d „ Z d „ Z d „ Z d „ Z
d „ Z d
„ Z RS( iü i< c C sC | | _ h | _ g | _ d | _ d | _ d | _ d | _ d S( Ni ( t encodingt _str_indexest _tallyt
_add_callst Nonet _sst_recordt
_continuest _current_piece( t selfR ( ( sA /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt3/BIFFRecords.pyt __init__ s c C sª | i d j o' t | t ƒ o t | | i ƒ } n | i d 7_ | | i j o0 t | i ƒ } | | i | <| i i d ƒ n! | i | } | i | c d 7<| S( Nt asciii ( R t
isinstancet strR R t lenR t append( R t st idx( ( sA /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt3/BIFFRecords.pyt add_str s !
c C sA | i | d j p t ‚ | i | c d 8<| i d 8_ d S( Ni i ( R t AssertionErrorR ( R R ( ( sA /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt3/BIFFRecords.pyt del_str" s c C s | i | S( N( R ( R R ( ( sA /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt3/BIFFRecords.pyt str_index( s c C s> d | _ d d g | _ t d d d ƒ | _ g } t | i i ƒ ƒ D] \ } } | | | f qG ~ } | i ƒ x? | D]7 \ } } | i | d j o
d } n | i
| ƒ qz W~ | i ƒ t d | i t
| i ƒ | i t
| i ƒ ƒ | i d <| i d | i d
} | d @} | d @} | d ?} | | B} | | N} q% W| t | ƒ N} | d N} | S( sP
Based on the algorithm provided by Daniel Rentz of OpenOffice.
R i i iÿ i iKÎ i €ÿ?( t enumeratet ordR ( R t plaintextt passwd_hashR. t chart ct low_15t high_15( ( sA /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt3/BIFFRecords.pyRj G s
R c C s t d | i | ƒ ƒ | _ d S( Ns | i d @d >Bƒ } n t d d ƒ } t d | i d @d >| i d @d >B| i d @d >Bƒ } t d | i ƒ }
t d | i d
@d >| i d @d >B| i d @d >B| i
d @d >Bƒ } | d j o t d d
ƒ } n t d d ƒ } | i | i j o
d | _
n | i | i j o
d | _ n | i | i j o
d | _ n | i | i j o
d | _ n | i | i j o
d | _ n t d | i d
@d >| i d
@d >B| i d
@d >B| i d
@d >B| i
d @d >B| i d @d >B| i d @d >B| i d @d >Bƒ } t d | i d @d >| i d @d >B| i d @d >B| i d
@d >B| i d @d >Bƒ } t d | i d @d >| i d @d >Bƒ } | |
| | |
| | | | | | _ d S( Ns
t | | ƒ } t | ƒ } t d | | | d | ƒ | _ d S( Ns =8
2 var. List of OFFSET structures for all portions. Each OFFSET contains the following data:
Offset Size Contents
0 4 Absolute stream position of first string of the portion
4 2 Position of first string of the portion inside of current record,
including record header. This counter restarts at zero, if the SST
record is continued with a CONTINUE record.
6 2 Not used
iÿ c C s h } | } d } d } xy | t | ƒ j oe | | \ } } | | j o | } | | | d 7} n | | d }
| |
f | | <| d 7} q Wt d t | ƒ d d ƒ } t d | ƒ | _ d } xP | t | ƒ j o< | i t d | | d | | d d ƒ 7_ | | 7} qÌ Wd S( Ni i i i i s c
C sZ t d | | | | d | | d ƒ | _ | o t d d d | d ƒ | _ n
d | _ d S( Ns <7HLi s <4Hi i id R ( R R8 t _scl_rec( R RŽ t first_visible_rowt first_visible_colt grid_colourt preview_magnt normal_magnt scl_magn( ( sA /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt3/BIFFRecords.pyR
Ý s c C s | i ƒ | i | i S( N( R9 R8 Rç ( R ( ( sA /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt3/BIFFRecords.pyR? ê s ( R3 R4 RG R6 R
R? ( ( ( sA /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt3/BIFFRecords.pyRæ ¥ s 5
t PanesRecordc B s e Z d Z d Z d „ Z RS( sÍ
This record stores the position of window panes. It is part of the Sheet
View Settings Block. If the sheet does not contain any splits, this
record will not occur.
A sheet can be split in two different ways, with unfrozen panes or with
frozen panes. A flag in the WINDOW2 record specifies, if the panes are
frozen, which affects the contents of this record.
Record PANE, BIFF2-BIFF8:
Offset Size Contents
0 2 Position of the vertical split
(px, 0 = No vertical split):
Unfrozen pane: Width of the left pane(s)
(in twips = 1/20 of a point)
Frozen pane: Number of visible
columns in left pane(s)
2 2 Position of the horizontal split
(py, 0 = No horizontal split):
Unfrozen pane: Height of the top pane(s)
(in twips = 1/20 of a point)
Frozen pane: Number of visible
rows in top pane(s)
4 2 Index to first visible row
in bottom pane(s)
6 2 Index to first visible column
in right pane(s)
8 1 Identifier of pane with active
cell cursor
[9] 1 Not used (BIFF5-BIFF8 only, not written
in BIFF2-BIFF4)
If the panes are frozen, pane 0 is always active, regardless
of the cursor position. The correct identifiers for all possible
combinations of visible panes are shown in the following pictures.
px = 0, py = 0 px = 0, py > 0
-------------------------- ------------|-------------
| | | |
| | | 3 |
| | | |
- 3 - --------------------------
| | | |
| | | 2 |
| | | |
-------------------------- ------------|-------------
px > 0, py = 0 px > 0, py > 0
------------|------------- ------------|-------------
| | | | | |
| | | | 3 | 2 |
| | | | | |
- 3 | 1 - --------------------------
| | | | | |
| | | | 1 | 0 |
| | | | | |
------------|------------- ------------|-------------
iA c C s@ t d t | ƒ t | ƒ t | ƒ t | ƒ t | ƒ ƒ | _ d S( Ns <5H( R t intR8 ( R t pxt pyt first_row_bottomt first_col_rightt active_pane( ( sA /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt3/BIFFRecords.pyR
) s !( R3 R4 RG R6 R
( ( ( sA /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt3/BIFFRecords.pyRî î s 9t RowRecordc B s e Z d Z d Z d „ Z RS( s¦
This record contains the properties of a single row in a sheet. Rows
and cells in a sheet are divided into blocks of 32 rows.
Record ROW, BIFF3-BIFF8:
Offset Size Contents
0 2 Index of this row
2 2 Index to column of the first cell which is described by a cell record
4 2 Index to column of the last cell which is described by a cell record,
increased by 1
6 2 Bit Mask Contents
14-0 7FFFH Height of the row, in twips = 1/20 of a point
15 8000H 0 = Row has custom height; 1 = Row has default height
8 2 Not used
10 2 In BIFF3-BIFF4 this field contains a relative offset
to calculate stream position of the first cell record
for this row. In BIFF5-BIFF8 this field is not used
anymore, but the DBCELL record instead.
12 4 Option flags and default row formatting:
Bit Mask Contents
2-0 00000007H Outline level of the row
4 00000010H 1 = Outline group starts or ends here (depending
on where the outline buttons are located,
see WSBOOL record), and is collapsed
5 00000020H 1 = Row is hidden (manually, or by a filter or outline group)
6 00000040H 1 = Row height and default font height do not match
7 00000080H 1 = Row has explicit default format (fl)
8 00000100H Always 1
27-16 0FFF0000H If fl=1: Index to default XF record
28 10000000H 1 = Additional space above the row. This flag is set,
if the upper border of at least one cell in this row
or if the lower border of at least one cell in the row
above is formatted with a thick line style.
Thin and medium line styles are not taken into account.
29 20000000H 1 = Additional space below the row. This flag is set,
if the lower border of at least one cell in this row
or if the upper border of at least one cell in the row
below is formatted with a medium or thick line style.
Thin line styles are not taken into account.
i c C s, t d | | | d | d d | ƒ | _ d S( Ns <6HLi i ( R R8 ( R t indext first_colt last_colt height_optionsRŽ ( ( sA /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt3/BIFFRecords.pyR
[ s ( R3 R4 RG R6 R
( ( ( sA /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt3/BIFFRecords.pyRõ . s )t LabelSSTRecordc B s e Z d Z d Z d „ Z RS( sˆ
This record represents a cell that contains a string. It replaces the
LABEL record and RSTRING record used in BIFF2-BIFF7.
iý c C s t d | | | | ƒ | _ d S( Ns <3HL( R R8 ( R t rowt colt xf_idxt sst_idx( ( sA /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt3/BIFFRecords.pyR
h s ( R3 R4 RG R6 R
( ( ( sA /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt3/BIFFRecords.pyRú a s t MergedCellsRecordc B s& e Z d Z d Z d „ Z d „ Z RS( s„
This record contains all merged cell ranges of the current sheet.
Record MERGEDCELLS, BIFF8:
Offset Size Contents
0 var. Cell range address list with all merged ranges
------------------------------------------------------------------
A cell range address list consists of a field with the number of ranges
and the list of the range addresses.
Cell range address list, BIFF8:
Offset Size Contents
0 2 Number of following cell range addresses (nm)
2 8*nm List of nm cell range addresses
---------------------------------------------------------------------
Cell range address, BIFF8:
Offset Size Contents
0 2 Index to first row
2 2 Index to last row
4 2 Index to first column
6 2 Index to last column
iå c C sÌ t | ƒ d } xµ | d j o§ d } d } xe | d j oW | d j oJ | | \ } } } } | t d | | | | ƒ 7} | d 8} | d 7} q/ W| i t d | i t | ƒ d | ƒ | 7_ q Wd S( Ni i R i s <4Hs <3Hi ( R R R8 R6 ( R t merged_listR. t jt mergedt r1t r2t c1t c2( ( sA /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt3/BIFFRecords.pyR
Πs
&c C s | i S( N( R8 ( R ( ( sA /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt3/BIFFRecords.pyR? š s ( R3 R4 RG R6 R
R? ( ( ( sA /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt3/BIFFRecords.pyRÿ l s t MulBlankRecordc B s e Z d Z d Z d „ Z RS( sq
This record represents a cell range of empty cells. All cells are
located in the same row.
Record MULBLANK, BIFF5-BIFF8:
Offset Size Contents
0 2 Index to row
2 2 Index to first column (fc)
4 2*nc List of nc=lc-fc+1 16-bit indexes to XF records
4+2*nc 2 Index to last column (lc)
i¾ c C sX | | d } t d | | g | Œ | _ t d | | ƒ | i t d | ƒ | _ d S( Ni s %dHs <2Hs " Set new font
&","
Set new font with specified style .
The style is in most cases one of
"Regular", "Bold", "Italic", or "Bold Italic".
But this setting is dependent on the used font,
it may differ (localised style names, or "Standard",
"Oblique", ...). (BIFF5-BIFF8)
& Set font height in points ( is a decimal value).
If this command is followed by a plain number to be printed
in the header, it will be separated from the font height
with a space character.
i c C s t | ƒ | _ d S( N( R R8 ( R t
header_str( ( sA /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt3/BIFFRecords.pyR
’ s ( R3 R4 RG R6 R
( ( ( sA /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt3/BIFFRecords.pyR6 S s <t FooterRecordc B s e Z d Z d Z d „ Z RS( s,
Semantic is equal to HEADER record
i c C s t | ƒ | _ d S( N( R R8 ( R t
footer_str( ( sA /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt3/BIFFRecords.pyR
› s ( R3 R4 RG R6 R
( ( ( sA /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt3/BIFFRecords.pyR8 • s t
HCenterRecordc B s e Z d Z d Z d „ Z RS( s,
This record is part of the Page Settings Block. It specifies if the
sheet is centred horizontally when printed.
Record HCENTER, BIFF3-BIFF8:
Offset Size Contents
0 2 0 = Print sheet left aligned
1 = Print sheet centred horizontally
iƒ c C s t d | ƒ | _ d S( Ns à s t RightMarginRecordc B s e Z d Z d Z d „ Z RS( s
This record is part of the Page Settings Block. It contains the right
page margin of the current worksheet.
Offset Size Contents
0 8 Right page margin in inches
(IEEE 754 floating-point value, 64?bit double precision)
i' c C s t d | ƒ | _ d S( Ns 0) Menu text (Unicode string without length field, 3.4)
[var.] var. (optional, only if ld > 0) Description text (Unicode string without length field, 3.4)
[var.] var. (optional, only if lh > 0) Help topic text (Unicode string without length field, 3.4)
[var.] var. (optional, only if ls > 0) Status bar text (Unicode string without length field, 3.4)
i R c
C s· t | ƒ t j o t | ƒ }
n t | ƒ d }
t |
ƒ } t d | t | ƒ f | | | t | ƒ d | d t | ƒ t | ƒ t | ƒ t | ƒ |
| ƒ | | | | | _ d S( Ni s ", see 3.9.1)
c C s t d | d d ƒ | _ d S( Ns R@ RA RB RC RN RY RW R_ R` Rb Rc ( ( ( sA /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt3/BIFFRecords.pyt s¦ w'#
8#P>Å'.!!-I@3 1
,"B
¦A'