o ]oi @sfddlZddlZddlZddlZddlmZddlmZddlm Z ddlm Z iZ iddd d d d d ddddddddddd dd dddddddd dddd ddiddd dd!dd"dd#dd$dd%dd&dd'dd(dd)dd*dd+dd,dd-dd.d/d0d1id2d3d4d3d5d1d6dd7dd8d1d9d1d:dd;d dd?d@ddAddBd3dCddDd3idEddFddGd1dHd1dId/dJd3dKddLddMd dNd dOd dPddQddRddSddTd3dUd idVd3dWd3dXd dYddZd3d[dd\dd]dd^dd_d?d`d3dad3dbd3dcd3ddd ded dfd d3ddddd d dd ddg Z e dhZe diZe djZddldmZdndoZddpdqZdrdsZdtduZdvdwZdxdyZdzd{Zd|d}Zd~dZddZddZddZddZddZddZ ddZ!ddZ"ddZ#ddZ$ddZ%ddZ&ddZ'ddZ(dS)Nunpack)warn)UndefinedImageSize)UnsupportedImageFormat !"#$% & '()*+,-./0123456789:;<=>?@ A BCDEFGHIJKLM NOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrst) uvwxyz{|}~z^\sz\s$z(\$?)([A-Z]{1,3})(\$?)(\d+)FcCs^|dkr td|dS|dkrtd|dS|d7}|r dnd}t||}||t|S)aU Convert a zero indexed row and column cell reference to a A1 style string. Args: row: The cell row. Int. col: The cell column. Int. row_abs: Optional flag to make the row absolute. Bool. col_abs: Optional flag to make the column absolute. Bool. Returns: A1 style string. rzRow number %d must be >= 0NCol number %d must be >= 0rr)rxl_col_to_namestr)rowcolrow_abscol_abscol_strr{Z/var/www/html/kuke-dev/django-kuke/venv/lib/python3.10/site-packages/xlsxwriter/utility.pyxl_rowcol_to_cell{s    r}cCs2|tvr t|}nt|}|t|<|t|dS)z Optimized version of the xl_rowcol_to_cell function. Only used internally. Args: row: The cell row. Int. col: The cell column. Int. Returns: A1 style string. r) COL_NAMESrtru)rvrwrzr{r{r|xl_rowcol_to_cell_fasts  rcCs|}|dkrtd|dS|d7}d}|rdnd}|r>|d}|dkr&d}ttd|d}||}t|dd}|s||S) z Convert a zero indexed column cell reference to a string. Args: col: The cell column. Int. col_abs: Optional flag to make the column absolute. Bool. Returns: Column style string. rrrNrrsrr1)rchrordint)rwryZcol_numrz remainderZ col_letterr{r{r|rts    rtcCs|sdSt|}|d}|d}d}d}t|D]}|t|tddd|7}|d7}qt|d}|d8}||fS)z Convert a cell reference in A1 notation to a zero indexed row and column. Args: cell_str: A1 style string. Returns: row, col: Zero indexed cell row and column indices. )rrrrr1rrre_range_partsmatchgroupreversedrr)cell_strrrzrow_strexpnrwcharrvr{r{r|xl_cell_to_rowcols        rc Cs|sdSt|}|d}|d}|d}|d}|r"d}nd}|r)d}nd}d}d}t|D]}|t|td dd |7}|d7}q3t|d} |d8}| |||fS) a! Convert an absolute cell reference in A1 notation to a zero indexed row and column, with True/False values for absolute rows or columns. Args: cell_str: A1 style string. Returns: row, col, row_abs, col_abs: Zero indexed cell row and column indices. )rrFFrrr rTFrr1rr) rrryrzrxrrrwrrvr{r{r|xl_cell_to_rowcol_abss*           rcCsHt||}t||}|dus|durtddS||kr|S|d|S)aG Convert zero indexed row and col cell references to a A1:B1 range string. Args: first_row: The first cell row. Int. first_col: The first cell column. Int. last_row: The last cell row. Int. last_col: The last cell column. Int. Returns: A1:B1 style range string. N#Row and column numbers must be >= 0r)r}r first_row first_collast_rowlast_colZrange1Zrange2r{r{r|xl_range$s   rcCsPt||dd}t||dd}|dus|durtddS||kr"|S|d|S)a\ Convert zero indexed row and col cell references to a $A$1:$B$1 absolute range string. Args: first_row: The first cell row. Int. first_col: The first cell column. Int. last_row: The last cell row. Int. last_col: The last cell column. Int. Returns: $A$1:$B$1 style range string. TNrr)rrr{r{r| xl_range_abs?s rcCs"t||||}t|}|d|S)a Convert worksheet name and zero indexed row and col cell references to a Sheet1!A1:B1 range formula string. Args: sheetname: The worksheet name. String. first_row: The first cell row. Int. first_col: The first cell column. Int. last_row: The last cell row. Int. last_col: The last cell column. Int. Returns: A1:B1 style range string. r )rquote_sheetname) sheetnamerrrrZ cell_ranger{r{r|xl_range_formula[s rcCs*|s|ds|dd}d|}|S)z Convert a worksheet name to a quoted name if it contains spaces or special characters. Args: sheetname: The worksheet name. String. Returns: A quoted worksheet string. rz''z'%s')isalnum startswithreplace)rr{r{r|rqs rcCs"d}|D] }|t|d7}q|S)a} Get the pixel width of a string based on individual character widths taken from Excel. UTF8 characters, and other unhandled characters, are given a default width of 8. Args: string: The string to calculate the width for. String. Returns: The string width in pixels. Note, Excel adds an additional 7 pixels of padding in the cell. rr4) CHAR_WIDTHSget)stringlengthrr{r{r|xl_pixel_widthsrcCsiddddddddd d d d d ddddddddddddddddddd}||vr:||}td |sFtd!|d"|d#S)$Nblackz#000000bluez#0000FFZbrownz#800000cyanz#00FFFFgrayz#808080greenz#008000Zlimez#00FF00magentaz#FF00FFZnavyz#000080Zorangez#FF6600Zpinkpurplez#800080redz#FF0000silverz#C0C0C0whitez#FFFFFFyellowz#FFFF00z#[0-9a-fA-F]{6}z$Color '%s' isn't a valid Excel colorZFFr)rerrlstripupper)colorZ named_colorsr{r{r|xl_colorsL       rcCst|}tdd|}|S)Nz^FFrs)rrsub)rZ rgb_colorr{r{r| get_rgb_colorsrc Cs(gdddddidddddddddddiddiddddddidddddddddddiddiddddddidddddddddddiddidddddd idddddddddddiddidd dddd id ddd ddd dddd idd idd dddd id ddd ddd dddd idd idd ddddid ddd ddd dddd idd iddd dddidd ddd ddd ddd ddd dddd dddidd ddd ddd ddd ddd dddd ddd id d dd d dd d dd d dd d ddd d ddd id d dd d dd d dd d dd d ddd d ddd id d dd d dd d dd d dd d ddd d dddidd ddd ddd ddd ddd ddddiddidd ddd ddd ddd ddd ddddiddidd ddd ddd ddd ddd ddddidd idd ddd ddd ddd ddd dddd idd id d dd d dd d dd d dd d dddd idd id d dd d dd d dd d dd d dddd iddid d dd d dd d dd d dd d dddddd ddddddd ddd dddddddddddd ddddddd ddd dddddddddddd ddddddd ddd ddddddddd ddd ddd ddd d dd d dd ddd dddd ddd ddd ddd d dd d dd ddd dddd ddd ddd ddd d dd d dd ddd ddddddddddddddddddddddddddddd d dd d dd d dd d dd d dd d ddddiddiddiddiddiddiddidddiddiddiddiddiddiddidddiddiddiddiddiddiddidddiddiddiddiddiddiddidddiddiddiddiddiddiddidddiddiddidd iddiddiddiddd!idd"idd#idd$idd%idd&idd'iddd(idd)iddidd*idd*idd(idd)iddd+idd idd iddiddiddidd idddidd idd iddiddiddidd id}||S),Nr#z-0.499984740745262)themeZtintrr$z0.39997558519241921)Zseriesnegativemarkersfirstlasthighlowr%r&r'r(z-0.249977111117893rz0.79998168889431442r z0.499984740745262z0.249977111117893z0.34998626667073579rgbZFF323232ZFFD00000ZFF000000ZFF0070C0ZFF376092ZFF5F5F5FZFFFFB620ZFFD70077ZFF5687C2ZFF359CEBZFF56BE79ZFFFF5055ZFF777777ZFFC6EFCEZFFFFC7CEZFF8CADD6ZFFFFDC47ZFFFFEB9CZFF60D276ZFFFF5367ZFF00B050ZFFFF0000ZFFFFC000r"r{)style_idstylesr{r{r|get_sparkline_styles &/8AJS\enw %.7@IR[dmv $-6?HRrcCst|tjtjtjtjfS)N) isinstancedatetimedatetime timedelta)dtr{r{r|supported_datetimesrcCs&|r |jdd}|S|jrtd|S)N)tzinfozExcel doesn't support timezones in datetimes. Set the tzinfo in the datetime/time object to None or use the 'remove_timezone' Workbook() option)rr TypeError)dt_objremove_timezoner{r{r|remove_datetime_timezone#s  rcCs|}d}|rtddd}ntddd}t|tjr%t||}||}n9t|tjr8tj|}||}n&t|tjrOtj||}t||}||}nt|tjrZd}|}nt d|j t |j t |j d d }t|tjr|d kr|d8}|s|s|d kr|d7}|S) NFiprikr@Tz$Unknown or unsupported datetime typeg.AiQ)ilrr;)rrrr fromordinal toordinalrcombinerrdaysfloatseconds microseconds isocalendar)rZ date_1904rZ date_typeZ is_timedeltaepochdeltaZ excel_timer{r{r|datetime_to_excel_datetime4s8         rcCst|s t|r dSdS)NTF) re_leadingsearch re_trailing)rr{r{r|preserve_whitespacejsrcCsd}d}d}d}|st|d}|}n|}t|}tj|} t d|ddd} t d|ddd} t d |ddd} t d |ddd} t d |d d d}t d |ddd}d}d}d}d}| |kr}t |\}}}}}nN| dkrt |\}}}}}n@| |krt |\}}}n4| dkrt |\}}}}}n&| dkr||krt|\}}}}}n||krt|\}}}}}ntd||r|std||s||dkrd}|dkrd}|||| |||fS)Nr`rbZ3srr>HrZ2sIrrsIHDRr@spHYsrUrg F%u?sIENDTZpnglenr) roffset data_length end_markerrrrrrmarker x_density y_densityunitsr{r{r|rs4   rc Csd}t|}d}d}d}d}d}|s||krtd||d|dd}td||d|dd} |d@dkrd|d krd|d krd|d krdtd||d |d d}td||d |dd}|dkrtd||d|dd} td||d|dd} td||d|dd} | dkr| }| }| dkr| d}| d}|dkrd}|dkrd}|dkrd}q|| d}|s||ksd||||fS)NrFrrrriiiiir rr2irUrr@rrgRQ@iTZjpegr) rrrrrrrrrrr rrr{r{r|rsH    )rcCsBd}d}td|ddd}td|ddd}d||||fS)Nr
s          !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUV c    ( .! V6 H(7