2i*ddlmZddlmZmZdZdZdZGddeZd Z d Z Gd d eZ Gd de Z y)) BiffRecord)packunpackc$|j|SN) col_width)sheetcols B/var/www/html/acx/venv/lib/python3.12/site-packages/xlwt/Bitmap.py _size_colr s ??3 c$|j|Sr) row_height)r rows r _size_rowrs   C  rcp|t||k\r$|t||z}|dz }|t||k\r$|t||k\r$|t||z}|dz }|t||k\r$|}|}||zdz }||zdz }|t||k\r$|t||z}|dz }|t||k\r$|t||k\r$|t||z}|dz }|t||k\r$t||dk(s-t||dk(st||dk(st||dk(rytt|t||z dz}tt|t||z dz}tt|t||z dz} tt|t||z dz} |||||| || fS)aCalculate 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 rrNi)r rintfloat) r row_start col_startx1y1widthheightrow_endcol_endx2y2s r _position_imager!sj %+ + iy))Q  %+ + %+ + iy))Q  %+ +GG BJNE b[1_F IeW- - 5'**1  IeW- - Yug. .)E7++1  Yug. . 5) $ )y/HA/M%+q0iw6OST6T U2Y5)4 4t ; 2y"gr7B          D$ T2 T2 T5!! T4   T3 T3 T3 T4   T3 T3 T3 T7## T9%% T9%% T7## T7## T3 T5!! T3 T3 T3 T6"" T3 T2 T9%% T:&& T9%% T6"" T9%%rN)__name__ __module__ __qualname___REC_IDrQrr r#r#ks GLrr#ct|d5}|j}dddt|S#1swYtSxYw)zConvert a 24 bit bitmap into the modified internal format used by Windows. This is described in BITMAPCOREHEADER and BITMAPCOREINFO structures in the MSDN library. rbN)openread_process_bitmap_data)bitmapfhrPs r _process_bitmapr^sE fd rwwy  %%  %%s 1Act|dkr td|dddk7r td|dd}td|ddd}|dz}|d z }|dd}|d d}td |dd \}}|d d}|d kDr td |d kDr tdtd|dd\}}|dd}|dk7r td|dk7r tdtd|ddd}|dd}|dk7r td|dd}tdd ||dd}||z}||||fS)N6z#bitmap doesn't contain enough data.sBMz4bitmap doesn't appear to to be a valid bitmap image.r)r z> RaENOO 8D $Ra !! $DTMDTMD 8D 9D5$r(+ME6 8D GHHHIIeT"1X.FH 8DBABB! IJJtBQx(+K 8DqLMM 9D (FE64 >F D=D 64 &&rceZdZdZdZdZy)ImRawDataBmpRecordctj|t|\|_|_|_}|j |yzInsert 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)rrQr[rrrh _write_imdata)r+rPs r rQzImRawDataBmpRecord.__init__s9 D!3G3M0 DKD 4 rcPd}d}|j}td||||z|_y)Nr'rzr|sR$ !UDpO:Ob &*'Z;;( !( !r