o ,hʼn @sUddlZddlZddlmZmZmZmZddlmZiZ ee e fe d<iddddd d d d d d dddddddddddd dd dddddddd dd idd dd dd d d d!d d"d d#d d$d d%d d&dd'dd(d d)d d*d d+d d,d-d.d/id0d1d2d1d3d/d4d d5d d6d/d7d/d8dd9dd:d1d;d ddd?dd@d1dAddBd1idCd dDd dEd/dFd/dGd-dHd1dId dJd dKddLd dMddNd dOd dPddQd dRd1dSd idTd1dUd1dVddWd dXd1dYddZdd[d d\dd]d=d^d1d_d1d`d1dad1dbddcd dddd1d dd d d dd dd de Z dfZedgZedhZediZedjedMZedkedMZedlZedmZednZ o oddpe dqe dredsedte f dudvZdpe dqe dte fdwdxZddqe dsedte fdydzZd{e dtee e ffd|d}Zd{e dtee e eeffd~dZde de de de dte f ddZde de de de dte f ddZde de de de de dte f ddZ de dte fddZ!de dte fddZ"de dte fddZ#de dte fddZ$de dte fddZ%de dtee ee e fffddZ&deejej'ej(fdtefddZ)dejdedtejfddZ*deej'ejej+ej(fdededte,fddZ-de dteej.fddZ/dS)N)DictOptionalTupleUnion)warn COL_NAMES !"#$% & '()*+,-./0123456789:;<=>?@ A BCDEFGHIJKLM NOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrst) uvwxyz{|}~uC©®‼⁉™ℹ↔-↙↩↪⌚⌛⌨⏏⏩-⏳⏸-⏺Ⓜ▪▫▶◀◻-◾☀-☄☎☑☔☕☘☝☠☢☣☦☪☮☯☸-☺♀♂♈-♓♟♠♣♥♦♨♻♾♿⚒-⚗⚙⚛⚜⚠⚡⚧⚪⚫⚰⚱⚽⚾⛄⛅⛈⛎⛏⛑⛓⛔⛩⛪⛰-⛵⛷-⛺⛽✂✅✈-✍✏✒✔✖✝✡✨✳✴❄❇❌❎❓-❕❗❣❤➕-➗➡➰➿⤴⤵⬅-⬇⬛⬜⭐⭕〰〽㊗㊙🀄🃏🅰🅱🅾🅿🆎🆑-🆚🇦-🇿🈁🈂🈚🈯🈲-🈺🉐🉑🌀-🌡🌤-🎓🎖🎗🎙-🎛🎞-🏰🏳-🏵🏷-📽📿-🔽🕉-🕎🕐-🕧🕯🕰🕳-🕺🖇🖊-🖍🖐🖕🖖🖤🖥🖨🖱🖲🖼🗂-🗄🗑-🗓🗜-🗞🗡🗣🗨🗯🗳🗺-🙏🚀-🛅🛋-🛒🛕-🛗🛜-🛥🛩🛫🛬🛰🛳-🛼🟠-🟫🟰🤌-🤺🤼-🥅🥇-🧿🩰-🩼🪀-🪈🪐-🪽🪿-🫅🫎-🫛🫠-🫨🫰-🫸z^\sz\s$z(\$?)([A-Z]{1,3})(\$?)(\d+)z[^\w\.z^[\d\.z^([A-Z]{1,3}\d+)$z^R(\d+)z ^R?C(\d+)Frowcolrow_abscol_absreturncCsf|dkrtd|ddS|dkrtd|ddS|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. rz Row number '' must be >= 0 Col number 'r)rxl_col_to_namestr)rrrsrtru row_abs_strcol_strrH/var/www/html/rh/venv/lib/python3.10/site-packages/xlsxwriter/utility.pyxl_rowcol_to_cells  rcCs2|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. rz)rr{r|)rrrsr~rrrxl_rowcol_to_cell_fasts  rcCs|}|dkrtd|ddS|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. rryrwrxrzrr1)rchrordint)rsrucol_numr~ col_abs_str remainder col_letterrrrr{s   r{cell_strcCs|sdSt|}|durtd|ddS|d}|d}d}d}t|D]}|t|tdd d |7}|d 7}q)t|d }|d 8}||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. )rrNInvalid cell reference 'rrrr1rzr)RE_RANGE_PARTSmatchrgroupreversedrr)rrr~row_strexpnrscharrrrrrxl_cell_to_rowcols         rc Cs|sdSt|}|durtd|ddSt|d}|d}t|d}|d}d }d }t|D]}|t|td dd |7}|d7}q7t|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. )rrFFNrrrzrr rrr1r)rrrboolrrrr) rrrur~rtrrrsrrrrrrxl_cell_to_rowcol_abs s$         r first_row first_collast_rowlast_colcCsHt||}t||}|dks|dkrtddS||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. rx#Row and column numbers must be >= 0r)rrrrrrrange1range2rrrxl_range3s   rcCsPt||dd}t||dd}|dks|dkrtddS||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. Trxrr)rrrrr xl_range_absNs r sheetnamecCs"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)rrrrr cell_rangerrrxl_range_formulajs rc Cs8|}d}d}d}|dst|}t|}t|}t|r&d}nft|r.d}n^|rV| d}t |\} } d| krE|krUnnEd| krQ|krUnn9d}n6|rnt | d} d| kri|krmnn!d}n|rt | d} d| kr|krnn d}n|dvrd}|r| dd }d|d}|S) a, Sheetnames used in references should be quoted if they contain any spaces, special characters or if they look like a A1 or RC cell reference. The rules are shown inline below. Args: sheetname: The worksheet name. String. Returns: A quoted worksheet string. Fi@irTrzr)rEr5RCz'') upper startswithRE_QUOTE_RULE3rRE_QUOTE_RULE4_ROWRE_QUOTE_RULE4_COLUMNRE_QUOTE_RULE1searchRE_QUOTE_RULE2rrrreplace) ruppercase_sheetnamerequires_quotingcol_maxrow_max match_rule3match_rule4_rowmatch_rule4_columncellrrrsrrrrsD         0  rstringcCs |rt|dkr dSt|dS)z Calculate the width required to auto-fit a string in a cell. Args: string: The string to calculate the cell width for. String. Returns: The string autofit width in pixels. Returns 0 if the string is empty. rr)lenxl_pixel_widthrrrrcell_autofit_widths  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)rlengthrrrrrsrcolorcCsiddddddddd d d d d ddddddddddddddddddd}|||}td |sFtd!|d"d#|d$S)%Nblackz#000000bluez#0000FFbrownz#800000cyanz#00FFFFgrayz#808080greenz#008000limez#00FF00magentaz#FF00FFnavyz#000080orangez#FF6600pinkpurplez#800080redz#FF0000silverz#C0C0C0whitez#FFFFFFyellowz#FFFF00z#[0-9a-fA-F]{6}zColor 'z' isn't a valid Excel colorFFr)rrerrlstripr)r named_colorsrrr _xl_colorsJ       rcCst|}tdd|}|S)Nz^FFrx)rrsub)r rgb_colorrrr_get_rgb_color"srstyle_idc 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)themetintrr$z0.39997558519241921)seriesnegativemarkersfirstlasthighlowr%r&r'r(z-0.249977111117893rz0.79998168889431442r z0.499984740745262z0.249977111117893z0.34998626667073579rgbFF323232FFD00000FF000000FF0070C0FF376092FF5F5F5FFFFFB620FFD70077FF5687C2FF359CEBFF56BE79FFFF5055FF777777FFC6EFCEFFFFC7CEFF8CADD6FFFFDC47FFFFEB9CFF60D276FFFF5367FF00B050FFFF0000FFFFC000r"r)rstylesrrr_get_sparkline_style,s &/8AJS\enw %.7@IR[dmv $-6?HRrdtcCst|tjtjtjtjfSN) isinstancedatetimedatetime timedelta)rrrr_supported_datetimesrdt_objremove_timezonecCs&|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)rrrrr_remove_datetime_timezones  r  date_1904cCs&|}d}|rtddd}ntddd}t|tjr%t||}||}n9t|tjr8tj|}||}n&t|tjrOtj||}t||}||}nt|tjrZd}|}nt d|j t |j t |j d d }t|tjrt|tjs|d kr|d8}|s|s|d kr|d7}|S) NFiprzikr@Tz$Unknown or unsupported datetime typeg.AiQ)ilrzrz;)rrr r fromordinal toordinalrcombinerr daysfloatseconds microseconds isocalendar)rr r date_type is_timedeltaepochdelta excel_timerrr_datetime_to_excel_datetimesD           rcCst|p t|Sr)RE_LEADING_WHITESPACErRE_TRAILING_WHITESPACErrrr_preserve_whitespacesr)FF)F)0rrtypingrrrrwarningsrrrr|__annotations__rEMOJIScompilerrrrrrrrrrrr{rrrrrrrrrrrrrrr rrrMatchrrrrrs        !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVk       #($' Y " V    ?