ó 0Ó›Yc@s™ddlmZddlmZmZd„Zd„Zd„Zdefd„ƒYZd „Z d „Z d efd „ƒYZ d e fd„ƒYZ dS(i(t BiffRecordiÿÿÿÿ(tpacktunpackcCs |j|ƒS(N(t col_width(tsheettcol((s*lib/python2.7/site-packages/xlwt/Bitmap.pyt _size_col scCs |j|ƒS(N(t row_height(Rtrow((s*lib/python2.7/site-packages/xlwt/Bitmap.pyt _size_rowsc Cs x6|t||ƒkr8|t||ƒ8}|d7}qWx6|t||ƒkrq|t||ƒ8}|d7}q<W|}|}||d}||d}x6|t||ƒkrÒ|t||ƒ8}|d7}qWx6|t||ƒkr |t||ƒ8}|d7}qÖWt||ƒdks`t||ƒdks`t||ƒdks`t||ƒdkrddStt|ƒt||ƒdƒ}tt|ƒt||ƒdƒ}tt|ƒt||ƒdƒ} tt|ƒt||ƒdƒ} |||||| || fS(súCalculate the vertices that define the position of the image as required by the OBJ record. +------------+------------+ | A | B | +-----+------------+------------+ | |(x1,y1) | | | 1 |(A1)._______|______ | | | | | | | | | | | +-----+----| BITMAP |-----+ | | | | | | 2 | |______________. | | | | (B2)| | | | (x2,y2)| +---- +------------+------------+ Example of a bitmap that covers some of the area from cell A1 to cell B2. Based on the width and height of the bitmap we need to calculate 8 vars: col_start, row_start, col_end, row_end, x1, y1, x2, y2. The width and height of the cells are also variable and have to be taken into account. The values of col_start and row_start are passed in from the calling function. The values of col_end and row_end are calculated by subtracting the width and height of the bitmap from the width and height of the underlying cells. The vertices are expressed as a percentage of the underlying cell width as follows (rhs values are in pixels): x1 = X / W *1024 y1 = Y / H *256 x2 = (X-1) / W *1024 y2 = (Y-1) / H *256 Where: X is distance from the left side of the underlying cell Y is distance from the top of the underlying cell W is the width of the cell H is the height of the cell Note: the SDK incorrectly states that the height should be expressed as a percentage of 1024. col_start - Col containing upper left corner of object row_start - Row containing top left corner of object x1 - Distance to left side of object y1 - Distance to top of object width - Width of image frame height - Height of image frame iiNii(RR tinttfloat( Rt row_startt col_starttx1ty1twidththeighttrow_endtcol_endtx2ty2((s*lib/python2.7/site-packages/xlwt/Bitmap.pyt_position_images05**####t ObjBmpRecordcBseZdZd„ZRS(i]c 3CsM|j|} |j|} t|||||| | ƒ} | \} } }}}}}}d}d}d}d}| }| }|}|}|}|}|}|}d} d}!d}"d}#d}$d}%d}&d}'d}(d})d}*d}+d},d}-d}.d}/d}0d}1td|ƒ}2|2td|ƒ7}2|2td|ƒ7}2|2td|ƒ7}2|2td|ƒ7}2|2td|ƒ7}2|2td|ƒ7}2|2td|ƒ7}2|2td|ƒ7}2|2td|ƒ7}2|2td|ƒ7}2|2td|ƒ7}2|2td| ƒ7}2|2td|!ƒ7}2|2td|"ƒ7}2|2td |#ƒ7}2|2td |$ƒ7}2|2td |%ƒ7}2|2td |&ƒ7}2|2td |'ƒ7}2|2td |(ƒ7}2|2td |)ƒ7}2|2td |*ƒ7}2|2td|+ƒ7}2|2td|,ƒ7}2|2td|-ƒ7}2|2td|.ƒ7}2|2td|/ƒ7}2|2td|0ƒ7}2|2td|1ƒ7}2|2|_dS( Niiiii iÿs((s*lib/python2.7/site-packages/xlwt/Bitmap.pyt_process_bitmap¼scCs¶t|ƒdkr!tdƒ‚n|d dkr@tdƒ‚n|d}td|d ƒd}|d8}|d 7}|d}|d }td |d ƒ\}}|d }|d krÇtd ƒ‚n|d krâtdƒ‚ntd|d ƒ\}}|d}|dkr tdƒ‚n|dkr;tdƒ‚ntd|d ƒd}|d}|dkrwtdƒ‚n|d}tdd ||ddƒ}||}||||fS(Ni6s#bitmap doesn't contain enough data.itBMs4bitmap doesn't appear to to be a valid bitmap image.stsizeRRtplanestbitcountt compressiontheader((s*lib/python2.7/site-packages/xlwt/Bitmap.pyRFÈs<               tImRawDataBmpRecordcBs eZdZd„Zd„ZRS(icCs?tj|ƒt|ƒ\|_|_|_}|j|ƒdS(s¡Insert a 24bit bitmap image in a worksheet. The main record required is IMDATA but it must be proceeded by a OBJ record to define its position. N(RR?RFRRRMt _write_imdata(RR>((s*lib/python2.7/site-packages/xlwt/Bitmap.pyR?øs !cCs5d}d}|j}td|||ƒ||_dS(Ni isR8tenvtlcb((s*lib/python2.7/site-packages/xlwt/Bitmap.pyRSs (R@RARBR?RS(((s*lib/python2.7/site-packages/xlwt/Bitmap.pyRRõs tImDataBmpRecordcBseZd„ZRS(cCs?tj|ƒt|ƒ\|_|_|_}|j|ƒdS(s¡Insert a 24bit bitmap image in a worksheet. The main record required is IMDATA but it must be proceeded by a OBJ record to define its position. N(RR?RIRRRMRS(RtfilenameR>((s*lib/python2.7/site-packages/xlwt/Bitmap.pyR? s !(R@RAR?(((s*lib/python2.7/site-packages/xlwt/Bitmap.pyRV sN( t BIFFRecordsRtstructRRRR RRRIRFRRRV(((s*lib/python2.7/site-packages/xlwt/Bitmap.pyts   XQ -