/usr/lib/python2.6/site-packages/tablib/packages/xlwt
Edit: /usr/lib/python2.6/site-packages/tablib/packages/xlwt/BIFFRecords.pyc (112667B)
Ñò
}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 d/ „ ƒ YZ d0 e f d1 „ ƒ YZ d2 e f d3 „ ƒ YZ d4 e f d5 „ ƒ YZ d6 e f d7 „ ƒ YZ d8 e f d9 „ ƒ YZ! d: e f d; „ ƒ YZ" d< e f d= „ ƒ YZ# d> e f d? „ ƒ YZ$ d@ e f dA „ ƒ YZ% dB e f dC „ ƒ YZ& dD e f dE „ ƒ YZ' dF e f dG „ ƒ YZ( dH e f dI „ ƒ YZ) dJ e f dK „ ƒ YZ* dL e f dM „ ƒ YZ+ dN e f dO „ ƒ YZ, dP e f dQ „ ƒ YZ- dR e f dS „ ƒ YZ. dT e f dU „ ƒ YZ/ dV e f dW „ ƒ YZ0 dX e f dY „ ƒ YZ1 dZ e f d[ „ ƒ YZ2 d\ e f d] „ ƒ YZ3 d^ e f d_ „ ƒ YZ4 d` e f da „ ƒ YZ5 db e f dc „ ƒ YZ6 dd e f de „ ƒ YZ7 df e f dg „ ƒ YZ8 dh e f di „ ƒ YZ9 dj e f dk „ ƒ YZ: dl e f dm „ ƒ YZ; dn e f do „ ƒ YZ< dp e f dq „ ƒ YZ= dr e f ds „ ƒ YZ> dt e f du „ ƒ YZ? dv e f dw „ ƒ YZ@ dx e f dy „ ƒ YZA dz 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 pack( 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 ( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/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 unicodeR R t lenR t append( R t st idx( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/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 ( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyt del_str# s c C s | i | S( N( R ( R R ( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyt str_index) s c C s8 d | _ d d g | _ t d d d ƒ | _ g } | i i ƒ D] \ } } | | | f qA ~ } | i ƒ x? | D]7 \ } } | i | d j o
d } n | i | ƒ qt W~ | i
ƒ t d | i t | i ƒ | i
t | i ƒ ƒ | i d <| i d | i d
( ( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyR4 } s t Biff8BOFRecordc B sA e Z d Z d Z d Z d Z d Z d Z d Z d Z d „ Z
RS( s
Offset Size Contents
0 2 Version, contains 0600H for BIFF8 and BIFF8X
2 2 Type of the following data:
0005H = Workbook globals
0006H = Visual Basic module
0010H = Worksheet
0020H = Chart
0040H = Macro sheet
0100H = Workspace file
4 2 Build identifier
6 2 Build year
8 4 File history flags
12 4 Lowest Excel version that can read all records in this file
i i i i i i@ i c C sC d } d } d } d } d } t d | | | | | | ƒ | _ d S( Ni i»
iÌ l l s <4H2I( R R7 ( R t rec_typet versiont buildt yeart file_hist_flagst ver_can_read( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyR
½ s ( R2 R3 t __doc__R5 t BOOK_GLOBALt VB_MODULEt WORKSHEETt CHARTt
MACROSHEETt WORKSPACER
( ( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyR? ¤ s t InteraceHdrRecordc B s e Z d Z d „ Z RS( iá c C s t d d d ƒ | _ d S( Nt BBi° i ( R R7 ( R ( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyR
Ê s ( R2 R3 R5 R
( ( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyRM Ç s t InteraceEndRecordc B s e Z d Z d „ Z RS( iâ c C s
d | _ d S( NR ( R7 ( R ( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyR
Ñ s ( R2 R3 R5 R
( ( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyRO Î s t MMSRecordc B s e Z d Z d „ Z RS( iÁ c C s t d d ƒ | _ d S( Ns } | 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( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyRf 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 l s <4Hi i id R ( R R7 t _scl_rec( R RŠ t first_visible_rowt first_visible_colt grid_colourt preview_magnt normal_magnt scl_magn( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyR
Ý s c C s | i ƒ | i | i S( N( R8 R7 Rã ( R ( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyR> ê s ( R2 R3 RF R5 R
R> ( ( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/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 | | | | | ƒ | _ d S( Ns <5H( R R7 ( R t pxt pyt first_row_bottomt first_col_rightt active_pane( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyR
) s ( R2 R3 RF R5 R
( ( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/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 R7 ( R t indext first_colt last_colt height_optionsRŠ ( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyR
] s ( R2 R3 RF R5 R
( ( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyRð 0 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 R7 ( R t rowt colt xf_idxt sst_idx( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyR
j s ( R2 R3 RF R5 R
( ( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyRõ c 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 R7 R5 ( R t merged_listR- t jt mergedt r1t r2t c1t c2( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyR
Ž s
&c C s | i S( N( R7 ( R ( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyR> œ s ( R2 R3 RF R5 R
R> ( ( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyRú n 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 R7 ( R t
header_str( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyR
” s ( R2 R3 RF R5 R
( ( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyR1 U 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 R7 ( R t
footer_str( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyR
s ( R2 R3 RF R5 R
( ( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyR3 — 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
NameRecordc B s) e Z d Z d Z d d d d d „ Z RS( s
This record is part of a Link Table. It contains the name and the token
array of an internal defined name. Token arrays of defined names
contain tokens with aberrant token classes.
Record NAME, BIFF5/BIFF7:
Offset Size Contents
0 2 Option flags, see below
2 1 Keyboard shortcut (only for command macro names, see below)
3 1 Length of the name (character count, ln)
4 2 Size of the formula data (sz)
6 2 0 = Global name, otherwise index to EXTERNSHEET record (one-based)
8 2 0 = Global name, otherwise index to sheet (one-based)
10 1 Length of menu text (character count, lm)
11 1 Length of description text (character count, ld)
12 1 Length of help topic text (character count, lh)
13 1 Length of status bar text (character count, ls)
14 ln Character array of the name
14+ln sz Formula data (RPN token array without size field, 4)
14+ln+sz lm Character array of menu text
var. ld Character array of description text
var. lh Character array of help topic text
var. ls Character array of status bar text
Record NAME, BIFF8:
Offset Size Contents
0 2 Option flags, see below
2 1 Keyboard shortcut (only for command macro names, see below)
3 1 Length of the name (character count, ln)
4 2 Size of the formula data (sz)
6 2 Not used
8 2 0 = Global name, otherwise index to sheet (one-based)
10 1 Length of menu text (character count, lm)
11 1 Length of description text (character count, ld)
12 1 Length of help topic text (character count, lh)
13 1 Length of status bar text (character count, ls)
14 var. Name (Unicode string without length field, 3.4)
var. sz Formula data (RPN token array without size field, 4)
[var.] var. (optional, only if lm > 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 s
5( R2 R3 RF R5 R
R> ( ( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyRS í s t
SupBookRecordc B s e Z d Z d Z RS( s8
This record mainly stores the URL of an external document
and a list of sheet names inside this document. Furthermore
it is used to store DDE and OLE object links, or to indicate
an internal 3D reference or an add-in function. See 5.10.3
for details about external references in BIFF8.
i® ( R2 R3 RF R5 ( ( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyR\ s t InternalReferenceSupBookRecordc B s e Z d Z d „ Z RS( st
In each file occurs a SUPBOOK that is used for internal 3D
references. It stores the number of sheets of the own document.
Record SUPBOOK for 3D references, BIFF8:
Offset Size Contents
0 2 Number of sheets in this document
2 2 01H 04H (relict of BIFF5/BIFF7, the byte string "<04H>", see 3.9.1)
c C s t d | d d ƒ | _ d S( Ns RI RV RS R\ R] R_ R` ( ( ( s@ /tmp/pip-build-lt8jXN/tablib/tablib/packages/xlwt/BIFFRecords.pyt s¦ w'#
8#P>Å'.!!-IB3 1
,"B
¦@'