o ^g= @sddlZddlZddlZddlZddlmZddlmZddlm Z m Z iZ idddd d d d d dd dddddddd dd dd dd dddd dddd dd idd dd d d 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/d0id1d2d3d2d4d0d5d d6d d7d0d8d0d9dd:d d;d2dd?dd@ddAd2dBddCd2idDd dEd dFd0dGd0dHd.dId2dJd dKd dLd dMd dNd dOd dPd dQddRd dSd2dTd idUd2dVd2dWd dXd dYd2dZdd[dd\d d]dd^d>d_d2d`d2dad2dbd2dcd ddd ded d2d dd d d d d d d df Z dgZ edhZediZedjZedke dNZedle dNZedmZednZedoZddqdrZdsdtZddudvZdwdxZdydzZd{d|Zd}d~ZddZddZddZ ddZ!ddZ"ddZ#ddZ$ddZ%ddZ&ddZ'ddZ(ddZ)ddZ*ddZ+ddZ,ddZ-ddZ.ddZ/dS)Nunpack)warn)UndefinedImageSizeUnsupportedImageFormat !"#$% & '()*+,-./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+)FcCsf|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 >= 0N Col number 'rr)rxl_col_to_namestr)rowcolrow_abscol_abscol_strr|l/var/www/eduai.edurigo.com/doc_train/edurigo_ai/Puru/venv/lib/python3.10/site-packages/xlsxwriter/utility.pyxl_rowcol_to_cells  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_NAMESrurv)rwrxr{r|r|r}xl_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. rrsrrNrrtrr1)rchrordint)rxrzcol_numr{ remainder col_letterr|r|r}rus   rucCs|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. )rrrrr1rr)RE_RANGE_PARTSmatchgroupreversedrr)cell_strrr{row_strexpnrxcharrwr|r|r}xl_cell_to_rowcols        rc Cs|sdSt|}t|d}|d}t|d}|d}d}d}t|D]}|t|tddd|7}|d7}q)t|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 rrr1r)rrboolrrrr) rrrzr{ryrrrxrrwr|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_colrange1range2r|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_absFs 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) sheetnamerrrr cell_ranger|r|r}xl_range_formulabs rc CsJ|}d}d}d}|dst|rd}n~t|rd}nvt|rOt|}|d}t|\}}d|kr>|krNnnUd|krJ|krNnnId}nFt |rot |}t |d}d|krj|krnnn)d}n&t |rt |}t |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@irTrr)rEr5RCz'') upper startswithRE_QUOTE_RULE1searchRE_QUOTE_RULE2RE_QUOTE_RULE3rrrRE_QUOTE_RULE4_ROWrRE_QUOTE_RULE4_COLUMNreplace) ruppercase_sheetnamerequires_quotingcol_maxrow_maxrcellrwrxr|r|r}rxsD        0      rcCs |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_widthstringr|r|r}cell_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)rlengthrr|r|r}rsrcCsiddddddddd 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)color named_colorsr|r|r} _xl_colorsJ       rcCst|}tdd|}|S)Nz^FFrt)rrsub)r 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)themetintrr$z0.39997558519241921)seriesnegativemarkersfirstlasthighlowr%r&r'r(z-0.249977111117893rz0.79998168889431442r z0.499984740745262z0.249977111117893z0.34998626667073579rgbFF323232FFD00000FF000000FF0070C0FF376092FF5F5F5FFFFFB620FFD70077FF5687C2FF359CEBFF56BE79FFFF5055FF777777FFC6EFCEFFFFC7CEFF8CADD6FFFFDC47FFFFEB9CFF60D276FFFF5367FF00B050FFFF0000FFFFC000r"r|)style_idstylesr|r|r}_get_sparkline_style!s &/8AJS\enw %.7@IR[dmv $-6?HRrcCst|tjtjtjtjfSN) isinstancedatetimedatetime timedelta)dtr|r|r}_supported_datetimeusrcCs&|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)r date_1904r date_type is_timedeltaepochdelta excel_timer|r|r}_datetime_to_excel_datetimes8         rcCst|p t|Sr)RE_LEADING_WHITESPACErRE_TRAILING_WHITESPACErr|r|r}_preserve_whitespacesrcCsd}d}d}d}|s$t|d }|}Wdn1swYn|}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}| |krt |\}}}}}nO| dkrt |\}}}}}nA| |krt |\}}}n5| dkrt |\}}}}}n'| dkr||krt|\}}}}}n||krt|\}}}}}nt|d|r|st|d|s||dkrd}|dkrd}|||| |||fS)Nr`rb3srr>Hr2sIrrsIHDRr@spHYsrUrg F%u?sIENDTpngrr) r8offset data_length end_markerr4r3r5r6rmarker x_density y_densityunitsr|r|r}r*s4   r*c 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@rGrgRQ@iTjpegrJ) r8rKrLrMr4r3r5r6rNrrQrOrPr|r|r}r+9sH    )r+cCsBd}d}td|ddd}td|ddd}d||||fS)Nr
s        !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVk        ( $X  V6H(7