iZddlZddlZddlZddlZddlZddlmZmZddlm Z ddl m Z ddl m Z ddlmZmZddlmZmZddlmZmZmZmZmZmZdd lmZdd lmZdd lmZdd l m!Z!dd l"m#Z#ddl$m%Z%m&Z&ddl'm(Z(ddl)m*Z*ddl+m,Z,m-Z-m.Z.ddl/m0Z0m1Z1ddl2m3Z3ddl4m5Z5ddl6m7Z7m8Z8m9Z9m:Z:m;Z;mZ>m?Z?m@Z@mAZAddl*mBZBejCdejDZEdZFdZGdZHeddZIeddZJed d!ZKed"d#ZLed$d%ZMed&d'ZNed(d!ZOed)d*ZPed+d,ZQGd-d.e*jBZRdS)/N) defaultdict namedtuple)Decimal)Fractionwraps)BytesIOStringIO)isinfisnan)AnyDictListLiteralOptionalUnion)warn)Chart)Color) CommentType)Image)UrlUrlTypes) ButtonType) xmlwriter)Drawing DrawingInfo DrawingTypes)DuplicateTableNameOverlappingRange)Format)Shape) _datetime_to_excel_datetime_get_sparkline_style_preserve_whitespace_supported_datetimequote_sheetnamexl_cell_to_rowcolxl_col_to_namexl_pixel_widthxl_rangexl_rowcol_to_cellxl_rowcol_to_cell_fast) XMLwritera \bANCHORARRAY\( | \bBYCOL\( | \bBYROW\( | \bCHOOSECOLS\( | \bCHOOSEROWS\( | \bDROP\( | \bEXPAND\( | \bFILTER\( | \bHSTACK\( | \bLAMBDA\( | \bMAKEARRAY\( | \bMAP\( | \bRANDARRAY\( | \bREDUCE\( | \bSCAN\( | \bSEQUENCE\( | \bSINGLE\( | \bSORT\( | \bSORTBY\( | \bSWITCH\( | \bTAKE\( | \bTEXTSPLIT\( | \bTOCOL\( | \bTOROW\( | \bUNIQUE\( | \bVSTACK\( | \bWRAPCOLS\( | \bWRAPROWS\( | \bXLOOKUP\(c<tfd}|S)zn Decorator function to convert A1 notation in cell method calls to the default row/col notation. c |r|d}t|n,#t$rt|}||ddz}YnwxYw|g|Ri|SNrr)int ValueErrorr))selfargskwargs first_argnew_argsmethods L/srv/django_bis/venv311/lib/python3.11/site-packages/xlsxwriter/worksheet.py cell_wrapperz'convert_cell_args..cell_wrapperfs '  G I ' ' '(33Hd122h&DDD ' vd,T,,,V,,,s&AArr:r<s` r;convert_cell_argsr>_s6 6]] - - - -] - c<tfd}|S)zo Decorator function to convert A1 notation in range method calls to the default row/col notation. c |rt|dn#t$rd|dvrC|dd\}}t|\}}t|\}}nt|d\}}||}}||||g} | |dd| }YnwxYw |g|Ri|S)Nr:rr3r4splitr)extend) r5r6r7cell_1cell_2row_1col_1row_2col_2r9r:s r;r<z(convert_range_args..cell_wrapper~s  DG    d1g~~!%as!3!3088 u088 uu0a99 u$euueU3H OODH % % %DDD vd,T,,,V,,,sBB65B6rr=s` r;convert_range_argsrLws6 6]]----]-* r?c<tfd}|S)zq Decorator function to convert A1 notation in columns method calls to the default row/col notation. cL |rt|dn#t$rrd|ddD\}}t|\}}t|\}}||g}||dd|}YnwxYw |g|Ri|S)Nrcg|]}|dzS)1).0cols r; z?convert_column_args..column_wrapper..sFFFCcCiFFFr?rBrrC) r5r6r7rFrG_rIrKr9r:s r;column_wrapperz+convert_column_args..column_wrappers  DG    FF47==3E3EFFFNFF(00HAu(00HAuu~H OODH % % %DDD vd,T,,,V,,,sA9BBr)r:rVs` r;convert_column_argsrWs6 6]]----]- r?BlankformatErrorzerror, format, valueNumberznumber, formatStringzstring, formatBooleanzboolean, formatFormulazformula, format, valueDatetime RichStringzstring, format, raw_string ArrayFormulaz$formula, format, value, range, atypeceZdZdZd:fd ZdedefdZedededee de ffd Z dedefd Z e d;deded e d eede d f dZ d;deded e d eede d f dZe d;dededeeeefd eede df dZ d;dededeeeefd eede df dZe d;dedede d eefdZ d;deded eede dfdZe dde dfd$Z e d;deded%e!j!d eede df d&Z"d;dededefd'Z#e d;deded(e$d eefd)Z%d;dededefd*Z&e d?deded+e d eed ee d,ee f d-Z' d?dededefd.Z(ededed/ee efde d0fd1Z)dededefd2Z*d:d3Z+e d;deded eedee de ffd4Z,e d;deded eedee de ffd5Z-e d;deded6ee e.e/fd7ee0e e fde df d8Z1e d;deded6ee e.e/fd7ee0e e fde df d9Z2e d;deded:e d7ee0e e fde df d;Z3e d;dedede d7ee0e e fde d f d?Z6d:d@Z7 d=d6ee e.e/fdAe$de dfdBZ8d:dCZ9dDZ:d:dEZ;d:dFZ<d:dGZ=d:dHZ>d:dIZ?e@ d?dededJeed eed7ee0e e fde df dKZAe@ d?dededJeed eed7ee0e e fde df dLZBd@dNeddfdOZC d?dedPeed eed7ee0e e fde df dQZD d?dedPeed eed7ee0e e fde df dRZE dAdPeedSe$ddfdTZFe d;dededededUe d eedefdVZGedededededdf dWZHdedXe ddfdYZIdedZeJe ddfd[ZKe d;dedededed7ee0e e fde d f d\ZLe d;dedededed7ee0e e fde d f d]ZMe d;dedededed7ee0e e fde d^f d_ZNe d;deded7ee0e e fde d fd`ZOedededededdf daZPedBdededdfdbZQ dCdde$dee$dfe$dge$ddf dhZRe dDdededieedjeedkeddf dlZSe dEdmednedieedjeeddf doZTdFdqeddfdrZUd:dsZVd:dtZWduee eXfddfdvZY dGdxe d7ee0e e fddfdyZZ dEdze d{ee dxee defd|Z[e d;deded7ee0e e fde dfd}Z\e d;deded(e$d eefd~Z]d:dZ^d:dZ_dHde dddfdZ`d:dZadee defddfdZbd:dZcd:dZd dIdededededdf dZe dJde d7ee0e e fddfdZf dJde d7ee0e e fddfdZgd;dedeeddfdZhe@d;dedeeddfdZidHde dddfdZjd:dZkd:dZlededededede df dZmd:dZndJedPeddfdZodeddfdZpdeddfdZqd:dZrdeJeddfdZsdeJeddfdZtd;dee ddfdZud;d7ee0e e fde dfdZvd:dZwd:dZx dKdededefdZydZzdZ{dZ|dZ}dZ~dZde fdZd;d7ee0e e ffdZde/dededdfdZd:dZd:dZd:dZd:dZdZdZdLdefdZdLdefdZdZdZd>efd„ZdefdĄZdńZd:dƄZd:dDŽZdȄZd:dɄZdʄZd˄Zd̄Zd;d̈́Zd;d΄Zd:dτZd:dЄZd:dфZd:d҄Zd:dӄZd:dԄZd;dՄZd:dքZd:dׄZd:d؄Zd:dلZd:dڄZd:dۄZd:d܄Zd:d݄Zd:dބZd:d߄Zd:dZd:dZd:dZd:dZd:dZd:dZdLd:dZd:dZdAdeddfdZd;deddfdZdededdfdZd:dZd:dZd:dZd:dZd:dZd:dZd:dZd:dZd:dZd:dZd:dZd:dZdededed+eddf dZdeded+eddfdZŐd:dZƐd:dZǐd:dZȐd:dZɐd:dZʐd:dZːd:dZ̐d:dZ͐d:dZΐd:dZϐd:dZАd:dZѐd:dZҐd:dZӐd:dZԐd:d ZՐd:d Z֐d:d Zאd:d Zؐd:d Zِd:dZڐd:dZېd:dZܐd:dZݐd:dZސd:dZߐd:dZd;d:dZd:dZd:dZd:dZd:dZdededdfdZdededdfdZdZd:dZd:dZd:dZd:d Zd:d!Zd:d"Zd:d#Zd:d$Zd:d%Zd:d&Zd:d'Zd:d(Zd:d)Zd:d*Zd:d+Zd:d,Zd:d-Zd:d.Zd:d/Zd:d0Zd:d1Zd:d2Zd:d3Zd:d4Zd:d5Zd:d6Zd:d7Zd:d8Zd:d9ZxZS(M Worksheetz= A class for writing the Excel XLSX Worksheet file. returnNc td|_d|_d|_d|_d|_d|_d|_g|_ d|_ d|_ d|_ d|_ d|_d|_d|_d|_d|_d|_i|_g|_d|_d|_d|_d|_g|_d |_d|_d|_d|_d |_d|_ d|_!d|_"d|_#d |_$d|_%d|_&d|_'d|_(d|_)d |_*d |_+g|_,g|_-g|_.d |_/d |_0d |_1d |_2d|_3d|_4d|_5d|_6d|_7d|_8d|_9d|_:d|_;d|_<d|_=d|_>d|_?g|_@g|_Ai|_Bg|_Cd|_Di|_Ett|_Hd|_Id |_Jd|_Kd|_Ld |_Md|_Nd|_Od|_Pd|_Qd |_Rd |_Sd |_Td|_Ud|_Vd|_Wd|_Xd|_Yd|_Zd|_[d|_\i|_]g|_^tt|__g|_`i|_ai|_bi|_cd|_dd|_ed|_ftt|_gg|_hd|_id|_jd|_kg|_ld|_md|_nd|_oddg|_pd|_qi|_ri|_si|_ti|_ud|_vd|_wd |_xd|_yd|_zg|_{g|_|g|_}g|_~g|_g|_g|_g|_g|_g|_g|_g|_g|_g|_i|_d|_i|_d|_i|_d|_d|_d|_d|_g|_i|_g|_d|_d |_d|_d|_d|_tt|_d|_d |_d|_d |_d|_d|_d|_d|_d|_d|_d|_d|_d|_d|_d|_kd|_d|_d|_d|_d|_i|_d|_d|_d|_d|_d|_dS)z Constructor. NrFiii@rTffffff??333333?d\( @@D i)super__init__nameindex str_tablepaletteconstant_memorytmpdir is_chartsheet ext_sheets fileclosed excel_versionexcel2003_style xls_rowmax xls_colmax xls_strmax dim_rowmin dim_rowmax dim_colmin dim_colmaxcol_info selectionshiddenactive tab_color top_left_cellpanes active_paneselectedpage_setup_changed paper_size orientationprint_options_changedhcentervcenterprint_gridlinesscreen_gridlines print_headersrow_col_headersheader_footer_changedheaderfooterheader_footer_alignsheader_footer_scales header_images footer_imagesheader_images_list margin_left margin_right margin_top margin_bottom margin_header margin_footerrepeat_row_rangerepeat_col_rangeprint_area_range page_order black_white draft_qualityprint_comments page_startfit_page fit_width fit_heighthbreaksvbreaksprotect_optionsprotected_rangesnum_protected_rangesset_colsrdictset_rowszoomzoom_scale_normal print_scaleis_right_to_left show_zeros leading_zerosoutline_row_leveloutline_col_level outline_style outline_below outline_right outline_onoutline_changedoriginal_row_heightdefault_row_heightdefault_row_pixelsdefault_col_widthdefault_col_pixelsdefault_date_pixelsdefault_row_zeroednames write_matchtablemerge merged_cells table_cells row_spanshas_vmlhas_header_vml has_commentscomments comments_listcomments_authorcomments_visible vml_shape_id buttons_list vml_header_idautofilter_areaautofilter_ref filter_range filter_on filter_cols filter_type filter_cells row_sizescol_size_changedrow_size_changed last_shape_id rel_count hlink_count hlink_refsexternal_hyper_linksexternal_drawing_linksexternal_comment_linksexternal_vml_linksexternal_table_linksexternal_background_links drawing_linksvml_drawing_linkschartsimagestables sparklinesshapes shape_hashdrawing drawing_relsdrawing_rels_idvml_drawing_relsvml_drawing_rels_idbackground_imagerstring previous_row validations cond_formatsdata_bars_2010use_data_bars_2010 dxf_priority page_view vba_codename date_1904 hyperlinksstrings_to_numbersstrings_to_urlsnan_inf_to_errorsstrings_to_formulasdefault_date_formatdefault_url_formatdefault_checkbox_formatworkbook_add_formatremove_timezonemax_url_lengthrow_data_filename row_data_fhworksheet_meta vml_data_idrow_data_fh_closed vertical_dpihorizontal_dpiwrite_handlersignored_errorshas_dynamic_arraysuse_future_functionsignore_write_stringembedded_images)r5 __class__s r;ruzWorksheet.__init__s      "!$!     "'%*"  $ $"$%*"  $(!$(!"$!   " " "   ! "$%! #D))  !" %!"!"$#% "$"$!%"$#% "#  &&   #!#D)) ! % !"F % %$&!&(#&(#"$$&!)+&!#       "#$ $  "' %d++"'#!&#' #' "&'+$#' $"!%" !%"' ""'$)!#( #r?rowrSc|dkr|j||g|RS|jr$|dr|j||g|RS|dr$|dr|j||g|RSd|vrj|jrct jd|s?t jd|s*t jd|st jd |r|j||g|RS|j rm t|}|j st|s't|s|j|||g|d dRSn#t$rYnwxYw|j||g|RS|j||g|RS) Nrg=z{=}rBz(ftp|http)s?://zmailto:z(in|ex)ternal:zfile://r) _write_blankr startswith_write_formulaendswithrrematch _write_urlrfloatrr r _write_numberr4 _write_string)r5tokenr&rSr6fs r;_write_token_as_stringz Worksheet._write_token_as_strings B;;$4$S#5555 5  # 8(8(8(=(= 8&4&sC7$777 7   D ! ! 8ennS&9&9 8&4&sC7$777 7 5LL$ *E22 8Iu--  8,e44  8Iu-- #4?33d333 3  " 7 %LL)F%((F588F-4-c3EDHEEEE    &4%c36666 6"t!#s2T2222s0A D== E  E )rc |j||g|RS)a Write data to a worksheet cell by calling the appropriate write_*() method based on the type of data being passed. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). *args: Args to pass to sub functions. Returns: 0: Success. -1: Row or column is out of worksheet bounds. other: Return value of called method. _writer5r&rSr6s r;writezWorksheet.writes "t{3+d++++r?c|std|d}|j}||jvr|j|}||||g|R}|n|S||j||g|RS|tur|j||g|RS|t tttfvr|j ||g|RS|tur|j |||g|RS|tj tjtjtjfvr|j||g|RSt%|t tttfr|j ||g|RSt%|tr|j |||g|RSt%|tr|j||g|RSt'|r|j||g|RSt%|t(r|j||g|RS t |}|j |||g|ddRS#t,$rYn-t$r!tdt/|dwxYw t||j||g|RS#t,$r!tdt/|dwxYw)Nz,write() takes at least 4 arguments (3 given)rrzUnsupported type z in write()) TypeErrorr%rr*bool_write_booleanr1r3rrr2strr6datetimedatetime timedelta_write_datetime isinstancer'rr0r4typer3) r5r&rSr6r4 token_type write_handlerfunction_returnr5s r;r:zWorksheet._writesb LJKK KQ_  , , , / ;M+mD#sBTBBBO &&& =$4$S#5555 5   &4&sC7$777 7 %gx8 8 8%4%c36666 6   .4.uc3FFFF F    M M      (4'S84888 8 eeS'8< = = 7%4%c36666 6 eS ! ! G.4.uc3FFFF F eT " " 8&4&sC7$777 7 u % % 9'4'S84888 8 eS ! ! 4"4?33d333 3 Je A%4%c3=DH=== =    D J J JHU HHHII I J J JJJ%4%c36666 6 J J JHU HHHII I Js6&G H)*HH55+I string cell_format)rr7c2|||||S)a Write a string to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). string: Cell data. Str. format: An optional cell Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: String truncated to 32k characters. )r3)r5r&rSrLrMs r; write_stringzWorksheet.write_string@s&!!#sFK@@@r?c^d}|||rdSt||jkr|d|j}d}|js|j|}n|}|jr ||jkr||t|||j ||<|SNrr7rN) _check_dimensionslenrrzrx_get_shared_string_indexr_write_single_rowCellStringTupler)r5r&rSrLrM str_error string_indexs r;r3zWorksheet._write_stringVs   ! !#s + + 2 v;; ( (-do-.FI# ">BB6JJLL!L   (C$*;$;$;  " "3 ' ' ' /|[II 3r?numberc2|||||S)a Write a number to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). number: Cell data. Int or float. cell_format: An optional cell Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. )r2r5r&rSrZrMs r; write_numberzWorksheet.write_numberss,!!#sFK@@@r?cZt|st|r|jr|t|r|||d|dS|tjkr|||d|dS|tj kr|||d|dSnt d|jturt|}| ||rdS|j r ||j kr| |t|||j||<dS)N#NUM!z1/0#DIV/0!z-1/0zUNAN/INF not supported in write_number() without 'nan_inf_to_errors' Workbook() optionr7r)r r rr,mathinfr>r%rr1rSrzrrVCellNumberTuplerr\s r;r2zWorksheet._write_numbersQ == E&MM % ==X..sC+wWWWTX%%..sC YWWWdhY&&..sCiXXX' D  x ' '6]]F  ! !#s + + 2   (C$*;$;$;  " "3 ' ' ' /v{CC 3qr?blankc2|||||S)a Write a blank cell with formatting to a worksheet cell. The blank token is ignored and the format only is written to the cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). blank: Any value. It is ignored. cell_format: An optional cell Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. )r*)r5r&rSrdrMs r; write_blankzWorksheet.write_blanks&  c5+>>>r?c|dS|||rdS|jr ||jkr||t ||j||<dS)Nrr7)rSrzrrVCellBlankTupler)r5r&rSrUrMs r;r*zWorksheet._write_blanks{  1  ! !#s + + 2   (C$*;$;$;  " "3 ' ' ' .k:: 3qr?rformulac4||||||S)a Write a formula to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). formula: Cell formula. cell_format: An optional cell Format object. value: An optional value for the formula. Default is 0. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: Formula can't be None or empty. )r,r5r&rSrirMvalues r; write_formulazWorksheet.write_formulas 4""3Wk5IIIr?c |||rdS||dkrtddSt|r||||||||S|dr0|dr||||||||S||}|j r ||j kr| |t||||j ||<dS)Nr7rgzFormula can't be None or empty{r)r)rSrre_dynamic_functionsearchwrite_dynamic_array_formular+r-_write_array_formula_prepare_formularzrrVCellFormulaTuplerrks r;r,zWorksheet._write_formulas;  ! !#s + + 2 ?gmm 1 2 2 22  % %g . . 33S#sG[%    c " " w'7'7'<'< ,,S#sG[%  ''00   (C$*;$;$;  " "3 ' ' ' 0eLL 3qr? first_row first_collast_rowlast_colc t|r||||||||S||||||||dS)an Write a formula to a worksheet cell/range. Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. formula: Cell formula. cell_format: An optional cell Format object. value: An optional value for the formula. Default is 0. Returns: 0: Success. -1: Row or column is out of worksheet bounds. static)rprqrrrs)r5rvrwrxryrirMrls r;write_array_formulazWorksheet.write_array_formula!st:  % %g . . 339h';PU ((           r?c X||||||||d}|dkrd|_|S)a| Write a dynamic array formula to a worksheet cell/range. Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. formula: Cell formula. cell_format: An optional cell Format object. value: An optional value for the formula. Default is 0. Returns: 0: Success. -1: Row or column is out of worksheet bounds. dynamicrT)rsr!) r5rvrwrxryrirMrlerrors r;rrz%Worksheet.write_dynamic_array_formulaNsI8))            A::&*D # r?Fc|dr |dd}|dr |dd}|dr |dd}d|vr|Stjdd|}tjd d |}tjd d |}tjd d|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd |}tjd!d"|}tjd#d$|}tjd%d&|}tjd'd(|}tjd)d*|}tjd+d,|}tjd-d.|}tjd/d0|}tjd1d2|}tjd3d4|}tjd5d6|}tjd7d8|}tjd9d:|}tjd;d<|}tjd=d>|}tjd?d@|}|js|s|StjdAdB|}tjdCdD|}tjdEdF|}tjdGdH|}tjdIdJ|}tjdKdL|}tjdMdN|}tjdOdP|}tjdQdR|}tjdSdT|}tjdUdV|}tjdWdX|}tjdYdZ|}tjd[d\|}tjd]d^|}tjd_d`|}tjdadb|}tjdcdd|}tjdedf|}tjdgdh|}tjdidj|}tjdkdl|}tjdmdn|}tjdodp|}tjdqdr|}tjdsdt|}tjdudv|}tjdwdx|}tjdydz|}tjd{d||}tjd}d~|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjd d |}tjd d |}tjd d|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd |}tjd!d"|}tjd#d$|}tjd%d&|}tjd'd(|}tjd)d*|}tjd+d,|}tjd-d.|}tjd/d0|}tjd1d2|}tjd3d4|}tjd5d6|}tjd7d8|}tjd9d:|}tjd;d<|}|S(=Nrorr(r)r7z_xlfn.z\bANCHORARRAY\(z_xlfn.ANCHORARRAY(z \bBYCOL\(z _xlfn.BYCOL(z \bBYROW\(z _xlfn.BYROW(z\bCHOOSECOLS\(z_xlfn.CHOOSECOLS(z\bCHOOSEROWS\(z_xlfn.CHOOSEROWS(z\bDROP\(z _xlfn.DROP(z \bEXPAND\(z _xlfn.EXPAND(z \bFILTER\(z_xlfn._xlws.FILTER(z \bHSTACK\(z _xlfn.HSTACK(z \bLAMBDA\(z _xlfn.LAMBDA(z \bMAKEARRAY\(z_xlfn.MAKEARRAY(z\bMAP\(z _xlfn.MAP(z \bRANDARRAY\(z_xlfn.RANDARRAY(z \bREDUCE\(z _xlfn.REDUCE(z\bSCAN\(z _xlfn.SCAN(z \SINGLE\(z _xlfn.SINGLE(z \bSEQUENCE\(z_xlfn.SEQUENCE(z\bSORT\(z_xlfn._xlws.SORT(z \bSORTBY\(z _xlfn.SORTBY(z \bSWITCH\(z _xlfn.SWITCH(z\bTAKE\(z _xlfn.TAKE(z \bTEXTSPLIT\(z_xlfn.TEXTSPLIT(z \bTOCOL\(z _xlfn.TOCOL(z \bTOROW\(z _xlfn.TOROW(z \bUNIQUE\(z _xlfn.UNIQUE(z \bVSTACK\(z _xlfn.VSTACK(z \bWRAPCOLS\(z_xlfn.WRAPCOLS(z \bWRAPROWS\(z_xlfn.WRAPROWS(z \bXLOOKUP\(z_xlfn.XLOOKUP(z \bACOTH\(z _xlfn.ACOTH(z\bACOT\(z _xlfn.ACOT(z \bAGGREGATE\(z_xlfn.AGGREGATE(z \bARABIC\(z _xlfn.ARABIC(z\bARRAYTOTEXT\(z_xlfn.ARRAYTOTEXT(z\bBASE\(z _xlfn.BASE(z \bBETA.DIST\(z_xlfn.BETA.DIST(z \bBETA.INV\(z_xlfn.BETA.INV(z\bBINOM.DIST.RANGE\(z_xlfn.BINOM.DIST.RANGE(z\bBINOM.DIST\(z_xlfn.BINOM.DIST(z \bBINOM.INV\(z_xlfn.BINOM.INV(z \bBITAND\(z _xlfn.BITAND(z \bBITLSHIFT\(z_xlfn.BITLSHIFT(z \bBITOR\(z _xlfn.BITOR(z \bBITRSHIFT\(z_xlfn.BITRSHIFT(z \bBITXOR\(z _xlfn.BITXOR(z\bCEILING.MATH\(z_xlfn.CEILING.MATH(z\bCEILING.PRECISE\(z_xlfn.CEILING.PRECISE(z\bCHISQ.DIST.RT\(z_xlfn.CHISQ.DIST.RT(z\bCHISQ.DIST\(z_xlfn.CHISQ.DIST(z\bCHISQ.INV.RT\(z_xlfn.CHISQ.INV.RT(z \bCHISQ.INV\(z_xlfn.CHISQ.INV(z\bCHISQ.TEST\(z_xlfn.CHISQ.TEST(z \bCOMBINA\(z_xlfn.COMBINA(z \bCONCAT\(z _xlfn.CONCAT(z\bCONFIDENCE.NORM\(z_xlfn.CONFIDENCE.NORM(z\bCONFIDENCE.T\(z_xlfn.CONFIDENCE.T(z\bCOTH\(z _xlfn.COTH(z\bCOT\(z _xlfn.COT(z\bCOVARIANCE.P\(z_xlfn.COVARIANCE.P(z\bCOVARIANCE.S\(z_xlfn.COVARIANCE.S(z\bCSCH\(z _xlfn.CSCH(z\bCSC\(z _xlfn.CSC(z\bDAYS\(z _xlfn.DAYS(z \bDECIMAL\(z_xlfn.DECIMAL(z\bERF.PRECISE\(z_xlfn.ERF.PRECISE(z\bERFC.PRECISE\(z_xlfn.ERFC.PRECISE(z\bEXPON.DIST\(z_xlfn.EXPON.DIST(z \bF.DIST.RT\(z_xlfn.F.DIST.RT(z \bF.DIST\(z _xlfn.F.DIST(z \bF.INV.RT\(z_xlfn.F.INV.RT(z \bF.INV\(z _xlfn.F.INV(z \bF.TEST\(z _xlfn.F.TEST(z \bFILTERXML\(z_xlfn.FILTERXML(z\bFLOOR.MATH\(z_xlfn.FLOOR.MATH(z\bFLOOR.PRECISE\(z_xlfn.FLOOR.PRECISE(z\bFORECAST.ETS.CONFINT\(z_xlfn.FORECAST.ETS.CONFINT(z\bFORECAST.ETS.SEASONALITY\(z_xlfn.FORECAST.ETS.SEASONALITY(z\bFORECAST.ETS.STAT\(z_xlfn.FORECAST.ETS.STAT(z\bFORECAST.ETS\(z_xlfn.FORECAST.ETS(z\bFORECAST.LINEAR\(z_xlfn.FORECAST.LINEAR(z\bFORMULATEXT\(z_xlfn.FORMULATEXT(z\bGAMMA.DIST\(z_xlfn.GAMMA.DIST(z \bGAMMA.INV\(z_xlfn.GAMMA.INV(z\bGAMMALN.PRECISE\(z_xlfn.GAMMALN.PRECISE(z \bGAMMA\(z _xlfn.GAMMA(z \bGAUSS\(z _xlfn.GAUSS(z\bHYPGEOM.DIST\(z_xlfn.HYPGEOM.DIST(z\bIFNA\(z _xlfn.IFNA(z\bIFS\(z _xlfn.IFS(z \bIMAGE\(z _xlfn.IMAGE(z \bIMCOSH\(z _xlfn.IMCOSH(z \bIMCOT\(z _xlfn.IMCOT(z \bIMCSCH\(z _xlfn.IMCSCH(z \bIMCSC\(z _xlfn.IMCSC(z \bIMSECH\(z _xlfn.IMSECH(z \bIMSEC\(z _xlfn.IMSEC(z \bIMSINH\(z _xlfn.IMSINH(z \bIMTAN\(z _xlfn.IMTAN(z \bISFORMULA\(z_xlfn.ISFORMULA(z \bISOMITTED\(z_xlfn.ISOMITTED(z\bISOWEEKNUM\(z_xlfn.ISOWEEKNUM(z\bLET\(z _xlfn.LET(z\bLOGNORM.DIST\(z_xlfn.LOGNORM.DIST(z\bLOGNORM.INV\(z_xlfn.LOGNORM.INV(z \bMAXIFS\(z _xlfn.MAXIFS(z \bMINIFS\(z _xlfn.MINIFS(z \bMODE.MULT\(z_xlfn.MODE.MULT(z \bMODE.SNGL\(z_xlfn.MODE.SNGL(z \bMUNIT\(z _xlfn.MUNIT(z\bNEGBINOM.DIST\(z_xlfn.NEGBINOM.DIST(z \bNORM.DIST\(z_xlfn.NORM.DIST(z \bNORM.INV\(z_xlfn.NORM.INV(z\bNORM.S.DIST\(z_xlfn.NORM.S.DIST(z\bNORM.S.INV\(z_xlfn.NORM.S.INV(z\bNUMBERVALUE\(z_xlfn.NUMBERVALUE(z \bPDURATION\(z_xlfn.PDURATION(z\bPERCENTILE.EXC\(z_xlfn.PERCENTILE.EXC(z\bPERCENTILE.INC\(z_xlfn.PERCENTILE.INC(z\bPERCENTRANK.EXC\(z_xlfn.PERCENTRANK.EXC(z\bPERCENTRANK.INC\(z_xlfn.PERCENTRANK.INC(z\bPERMUTATIONA\(z_xlfn.PERMUTATIONA(z\bPHI\(z _xlfn.PHI(z\bPOISSON.DIST\(z_xlfn.POISSON.DIST(z\bQUARTILE.EXC\(z_xlfn.QUARTILE.EXC(z\bQUARTILE.INC\(z_xlfn.QUARTILE.INC(z\bQUERYSTRING\(z_xlfn.QUERYSTRING(z \bRANK.AVG\(z_xlfn.RANK.AVG(z \bRANK.EQ\(z_xlfn.RANK.EQ(z\bRRI\(z _xlfn.RRI(z\bSECH\(z _xlfn.SECH(z\bSEC\(z _xlfn.SEC(z \bSHEETS\(z _xlfn.SHEETS(z \bSHEET\(z _xlfn.SHEET(z \bSKEW.P\(z _xlfn.SKEW.P(z \bSTDEV.P\(z_xlfn.STDEV.P(z \bSTDEV.S\(z_xlfn.STDEV.S(z \bT.DIST.2T\(z_xlfn.T.DIST.2T(z \bT.DIST.RT\(z_xlfn.T.DIST.RT(z \bT.DIST\(z _xlfn.T.DIST(z \bT.INV.2T\(z_xlfn.T.INV.2T(z \bT.INV\(z _xlfn.T.INV(z \bT.TEST\(z _xlfn.T.TEST(z \bTEXTAFTER\(z_xlfn.TEXTAFTER(z\bTEXTBEFORE\(z_xlfn.TEXTBEFORE(z \bTEXTJOIN\(z_xlfn.TEXTJOIN(z \bUNICHAR\(z_xlfn.UNICHAR(z \bUNICODE\(z_xlfn.UNICODE(z\bVALUETOTEXT\(z_xlfn.VALUETOTEXT(z \bVAR.P\(z _xlfn.VAR.P(z \bVAR.S\(z _xlfn.VAR.S(z\bWEBSERVICE\(z_xlfn.WEBSERVICE(z\bWEIBULL.DIST\(z_xlfn.WEIBULL.DIST(z \bXMATCH\(z _xlfn.XMATCH(z\bXOR\(z _xlfn.XOR(z \bZ.TEST\(z _xlfn.Z.TEST()r+r-r.subr")r5riexpand_future_functionss r;rtzWorksheet._prepare_formula|s   c " " "abbkG   c " " "abbkG   C  #crclG w  N&+-A7KK&~w??&~w??&*,?II&*,?II&mW==&AA&(=wGG&AA&AA&)+=wGG&\7;;&)+=wGG&AA&mW==&@@&*;WEE&&97CC&AA&AA&mW==&)+=wGG&~w??&~w??&AA&AA&*;WEE&*;WEE&)97CC( 1H N&~w??&mW==&)+=wGG&AA&+-A7KK&mW==&)+=wGG&*;WEE&02KWUU&*,?II&)+=wGG&AA&)+=wGG&~w??&)+=wGG&AA&,.CWMM&/1I7SS&-/EwOO&*,?II&,.CWMM&)+=wGG&*,?II&)97CC&AA&/1I7SS&,.CWMM&mW==&\7;;&,.CWMM&,.CWMM&mW==&\7;;&mW==&)97CC&+-A7KK&,.CWMM&*,?II&)+=wGG&AA&*;WEE&~w??&AA&)+=wGG&*,?II&-/EwOO& ')F  & +-NPW  &13MwWW&,.CWMM&/1I7SS&+-A7KK&*,?II&)+=wGG&/1I7SS&~w??&~w??&,.CWMM&mW==&\7;;&~w??&AA&~w??&AA&~w??&AA&~w??&AA&~w??&)+=wGG&)+=wGG&*,?II&\7;;&,.CWMM&+-A7KK&AA&AA&)+=wGG&)+=wGG&~w??&-/EwOO&)+=wGG&*;WEE&+-A7KK&*,?II&+-A7KK&)+=wGG&.0GQQ&.0GQQ&/1I7SS&/1I7SS&,.CWMM&\7;;&,.CWMM&,.CWMM&,.CWMM&+-A7KK&*;WEE&)97CC&\7;;&mW==&\7;;&AA&~w??&AA&)97CC&)97CC&)+=wGG&)+=wGG&AA&*;WEE&~w??&AA&)+=wGG&*,?II&*;WEE&)97CC&)97CC&+-A7KK&~w??&~w??&*,?II&,.CWMM&AA&\7;;&AAr?cd|vr|Sg}d}|D]T}|dkr| }|r||#|dkr|d?||Ud|S)N@F"z [#This Row],rg)appendjoin)riescaped_formulain_string_literalchars r;_prepare_table_formulaz Worksheet._prepare_table_formula3s g  N! - -Ds{{(9$9!! &&t,,,s{{&&~6666&&t,,,,yy)))r?r{c x||kr||}}||kr||}}|||rdS|||rdS||kr||krt||} n$t||dzt||z} ||}|jr ||jkr||t |||| ||j||<|jsPt||dzD]<} t||dzD]&} | |ks| |kr| | | d|'=dS)Nr7rBrr) rSr-rtrzrrVCellArrayFormulaTuplerranger2) r5rvrwrxryrirMrlatype cell_ranger&rSs r;rszWorksheet._write_array_formulaQs x  "*IxI x  "*IxI  ! !)Y 7 7 2  ! !(H 5 5 2  Y(%:%:*9i@@JJ")Y77#Hh778 ''00   .I0A$A$A  " "9 - - -,A [%U, ,  9i( # EY1 55 E E HqL99EECi''3)+;+;**3Q DDDEqr?rCc2|||||S)a Write a date or time to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). date: Date and/or time as a datetime object. cell_format: A cell Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. )rF)r5r&rSrCrMs r;write_datetimezWorksheet.write_datetimes,##CdK@@@r?c|||rdS|jr ||jkr||||}||j}t |||j||<dS)Nr7r)rSrzrrV_convert_date_timerCellDatetimeTupler)r5r&rSrCrMrZs r;rFzWorksheet._write_datetimes  ! !#s + + 2   (C$*;$;$;  " "3 ' ' '((..  2K 1EE 3qr?booleanc2|||||S)a Write a boolean value to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). boolean: Cell data. bool type. cell_format: An optional cell Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. )r@r5r&rSrrMs r; write_booleanzWorksheet.write_booleans$""3WkBBBr?c|||rdS|jr ||jkr|||rd}nd}t |||j||<dS)Nr7rr)rSrzrrVCellBooleanTupler)r5r&rSrrMrls r;r@zWorksheet._write_booleans  ! !#s + + 2   (C$*;$;$;  " "3 ' ' '  EEE 0{CC 3qr?urltipc6|||||||S)a Write a hyperlink to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). url: Hyperlink url. format: An optional cell Format object. string: An optional display string for the hyperlink. tip: An optional tooltip. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: String longer than 32767 characters. -3: URL longer than Excel limit of 255 characters. -4: Exceeds Excel limit of 65,530 urls per worksheet. )r0)r5r&rSrrMrLrs r; write_urlzWorksheet.write_urls 6sCk63GGGr?c|||rdSt|ts|j}d|vr|dd\}} n|}d} t ||kst | |krt d|d|ddSt|}|||_|||_|xj dz c_ |j d krt d|j d d S||j }|j sD|j r ||jkr||||||j|||j||<d S) Nr7#rrgzIgnoring URL 'z!' with link or location/anchor > z4 characters since it exceeds Excel's limit for URLs.iz>' since it exceeds Excel's limit of 65,530 URLs per worksheet.r)rSrGrrrDrTr_text_tipr _original_urlrr#rzrrVr3textr ) r5r&rSrrMrLrmax_urlurl_str anchor_strs r;r0zWorksheet._write_urls  ! !#s + + 2#s## )Gczz&)iiQ&7&7# 7||g%%Z7)B)BKSKK7KKKrc((C!"  A  e # # .!2...   2  1K' @# ,d.?(?(?&&s+++   sC; ? ? ?%(S!qr?r6)rr7rNrrc |j||g|RS)aI Write a "rich" string with multiple formats to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). string_parts: String and format pairs. cell_format: Optional Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: String truncated to 32k characters. -3: 2 consecutive formats used. -4: Empty string used. -5: Insufficient parameters. )_write_rich_stringr;s r;write_rich_stringzWorksheet.write_rich_string@s!.'t&sC7$7777r?c0t|}d}d}d}|||rdSt|dtr|}t }t |_|j|t} g} d} d} t|dkrtddS|D]} t| tsf| dkr+| | | | n| | | dkrtdd S|| z }d } n5| dkr| dkrtd d S| | d} | d z } t| dts|j d| D]} t| tr0|j d| | Gg}t| r| d|jd| ||jd|jj}t||jkrtddS|js|j|}n|}|jr ||jkr||t3||||j||<dS)Nrrgr7rYzfYou must specify more than 2 format/fragments for rich strings. Ignoring input in write_rich_string().rzYExcel doesn't allow empty strings in rich strings. Ignoring input in write_rich_string().rrLzaExcel doesn't allow 2 consecutive formats in rich strings. Ignoring input in write_rich_string().rrr)z xml:spacepreservetzfString length must be less than or equal to Excel's limit of 32,767 characters in write_rich_string().rN)listrSrGr"popr r/r_set_filehandlerTrr_xml_start_tag _write_fontr&_xml_data_element _xml_end_tagfhgetvaluerrzrxrUrrVCellRichStringTupler)r5r&rSr6tokensrMrY raw_stringrdefault fragmentspreviousposr4 attributesrLs r;rzWorksheet._write_rich_stringZsd     ! !#s + + 2 fRj& ) ) ' **,,KZZ {{  $$R(((((   v;;!   B   2" " EeV,, $x''$$W---$$U++++$$U+++B;;A22e# #x''C!GGJ22  '''# 1HCC)A,// - L ' ' , , , / /E%(( / ++C000  '''' '..A%%&?@@@ ..sE:FFF ))#....))++ z??T_ , , ?   2# ">BB6JJLL!L   (C$*;$;$;  " "3 ' ' ' 3 +z   3qr?c||j|<dS)a" Add a callback function to the write() method to handle user defined types. Args: user_type: The user type() to match on. user_function: The user defined function to write the type data. Returns: Nothing. N)r)r5 user_type user_functions r;add_write_handlerzWorksheet.add_write_handlers*7I&&&r?cV|D]%}|||||}|r|cS|dz }&dS)a Write a row of data starting from (row, col). Args: row: The cell row (zero indexed). col: The cell column (zero indexed). data: A list of tokens to be written with write(). format: An optional cell Format object. Returns: 0: Success. other: Return value of write() method. rrr9r5r&rSdatarMr4rs r; write_rowzWorksheet.write_rowK"  EKKS%==E  1HCCqr?cV|D]%}|||||}|r|cS|dz }&dS)a Write a column of data starting from (row, col). Args: row: The cell row (zero indexed). col: The cell column (zero indexed). data: A list of tokens to be written with write(). format: An optional cell Format object. Returns: 0: Success. other: Return value of write() method. rrr9rs r; write_columnzWorksheet.write_columnrr?sourceoptionsc |||ddrtd|d|ddS|||}||_||_|||j|dS)a Insert an image with its top-left corner in a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). source: Filename, BytesIO, or Image object. options: Position, scale, url and data stream of the image. Returns: 0: Success. -1: Row or column is out of worksheet bounds. TzCannot insert image at (, ).r7r)rSr_image_from_source_row_col_set_user_optionsrr)r5r&rSrrimages r; insert_imagezWorksheet.insert_images.  ! !#sD$ 7 7  :C::3::: ; ; ;2''88   ((( 5!!!qr?c|||rtd|d|ddS|i}|||}|||dd}|jr4||j}d|_||||j|d|_|j |}td |||j ||<d S) a Embed an image in a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). source: Filename, BytesIO, or Image object. options: Url and data stream of the image. Returns: 0: Success. -1: Row or column is out of worksheet bounds. zCannot embed image at (rrr7NrMTF#VALUE!r) rSrrrgetrrr#rr$get_image_indexCellErrorTupler)r5r&rSrrrrM image_indexs r; embed_imagezWorksheet.embed_image:s.  ! !#s + +  9399#999 : : :2 ?G''88 (((kk-66 9 -""5 '+D $ NN3UY < < <',D $*::5AA  .ikRR 3qr?rc |||ddrtd|d|ddS|d}|i}|dd }|d d }|d d }|d d }|dd } |dd} |dd} |j|||||||| || | g d S)a Insert an textbox with its top-left corner in a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). text: The text for the textbox. options: Textbox options. Returns: 0: Success. -1: Row or column is out of worksheet bounds. TzCannot insert textbox at (rrr7Nrgx_offsetry_offsetx_scalery_scaleobject_position description decorativeF)rSrrrr) r5r&rSrrrrrranchorrrs r;insert_textboxzWorksheet.insert_textboxms(&  ! !#sD$ 7 7   3.2EN +;;z1--;;z1--++i++++i++.22kk-66 [[u55  =A  mG =A  mG > &~H > &~H   qr?commentc|||rdSt||jkrdSd|_d|_t ||||}||j||<dS)a Write a comment to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). comment: Cell comment. Str. options: Comment formatting options. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: String longer than 32k characters. r7rNTr)rSrTrrrrr)r5r&rSrrs r; write_commentzWorksheet.write_commentsu(  ! !#s + + 2 w<<$/ ) )2  c399") c3qr?cd|_dS)z Make any comments in the worksheet visible. Args: None. Returns: Nothing. TN)rr5s r; show_commentszWorksheet.show_comments!%r?is_byte_streamc`||}||_|rtddS)z Set a background image for a worksheet. Args: source: Filename, BytesIO, or Image object. is_byte_stream: Deprecated. Use a BytesIO object instead. Returns: 0: Success. zThe `is_byte_stream` parameter in `set_background()` is deprecated. This argument can be omitted if you are using a BytesIO object.r)rrr)r5rrrs r;set_backgroundzWorksheet.set_backgroundsF''// %   R    qr?c||_dS)z Set the default author of the cell comments. Args: author: Comment author name. String. Returns: Nothing. N)r)r5authors r;set_comments_authorzWorksheet.set_comments_author8s &r?c|jS)zw Retrieve the worksheet name. Args: None. Returns: Nothing. )rvrs r;get_namezWorksheet.get_nameEs yr?cDd|_d|_|j|j_dS)a Set this worksheet as the active worksheet, i.e. the worksheet that is displayed when the workbook is opened. Also set it as selected. Note: An active worksheet cannot be hidden. Args: None. Returns: Nothing. rrN)rrrwr activesheetrs r;activatezWorksheet.activateSs%  *.*'''r?c"d|_d|_dS)z Set current worksheet as a selected worksheet, i.e. the worksheet has its tab highlighted. Note: A selected worksheet cannot be hidden. Args: None. Returns: Nothing. rrN)rrrs r;selectzWorksheet.selectes  r?c"d|_d|_dS)zv Hide the current worksheet. Args: None. Returns: Nothing. rrNrrrs r;hidezWorksheet.hidev  r?c"d|_d|_dS)z Hide the current worksheet. This can only be unhidden by VBA. Args: None. Returns: Nothing. rrNrrs r; very_hiddenzWorksheet.very_hiddenrr?c6d|_|j|j_dS)aJ Set current worksheet as the first visible sheet. This is necessary when there are a large number of worksheets and the activated worksheet is not visible on the screen. Note: A selected worksheet cannot be hidden. Args: None. Returns: Nothing. rN)rrwr firstsheetrs r;set_first_sheetzWorksheet.set_first_sheets )-&&&r?widthc|i}||kr||}}d}|dd}|dd}|dd} |s|r|rd} nd} |d||| rdS|d||| rdSt| d} t| d } t|j| |_t ||d zD]} |||| |dg|j| <d|_dS) a Set the width, and other properties of a single column or a range of columns. Args: first_col: First column (zero-indexed). last_col: Last column (zero-indexed). Can be same as first_col. width: Column width. (optional). cell_format: Column cell_format. (optional). options: Dict of options such as hidden and level. Returns: 0: Success. -1: Column number is out of worksheet bounds. NTrF collapsedlevelrr7r)rrSmaxminrrrr) r5rwryrrMr ignore_rowrrr ignore_colrSs r; set_columnzWorksheet.set_columnsL2 ?G x  %-yY Xu--KK U33  GQ''  5 V JJJ  ! !!Xz: F F 2  ! !!Y J G G 2E1 E1 !$T%;U!C!CHqL11 W WC"'feYPU!VDM#  !%qr?cb|||}||||||S)a; Set the width, and other properties of a single column or a range of columns, where column width is in pixels. Args: first_col: First column (zero-indexed). last_col: Last column (zero-indexed). Can be same as first_col. width: Column width in pixels. (optional). cell_format: Column cell_format. (optional). options: Dict of options such as hidden and level. Returns: 0: Success. -1: Column number is out of worksheet bounds. )_pixels_to_widthr)r5rwryrrMrs r;set_column_pixelszWorksheet.set_column_pixelss72  ))%00Ey(E;PPPr? max_widthc"|jrtddS|jdSi}t||d}t |jj|jjj}t|j |jdzD]}|j |st|j |jdzD]}||j |vr|j ||}|jj}d}|dvrj|dkr|j} || } n|j} d | vrt'| }n.| d D]!} t'| } t+|| }"n|d kr%d t-t/|jz}n|d kr|j}n|d kr |jrd}nd}n|dvrt7|jt:t<fr0|jdkr$d t-t/|jz}nUt7|jt.rt'|j}n&t7|jt>r |jrd}nd}|j ||fr |dkr|dz }| |d} || kr|||<|!D]\}} || d z}t||}|j" |rv|j" |}|d}|d}|)|s'||kr ||j"|d<d|j"|d<||j"|d<d|j"|d<|dddddg|j"|<dS)z Simulate autofit based on the data, and datatypes in each column. Args: max_width (optional): max column width to autofit, in pixels. Returns: Nothing. z1Autofit is not supported in constant_memory mode.Ngo@)keyrrr\r`r\ r[rr_r]$r^raTF)#rzrrrrsortedrx string_table __getitem__rrrrrrr%__name__rLrr+rDrrTrArZrrrGrlr1r3r?ritemsr)r5r col_width_maxstringsrow_numcol_numcell cell_typelength string_idrL seg_length width_max pixel_widthrr user_widthrs r;autofitzWorksheet.autofit s'    D E E E F ? " F --i88%@@  N 'T^-H-T   T_do.ABBV 8V 8G:>>'**  $/A2EFFR 8R 8dj111:g.w7D $ 7IF $<<<%00(, I%,Y%7FF%)_Fv--%3F%;%;FF+1,,t*<*<AA-;F-C-C ),VZ)@)@A#h.."#ST[)9)9%:%:!:"j00 "&!9"i// <(%'FF%'FF"&AAA &dj5#,?? ,#zA~~)*STZ-A-A)A' C88,%3DJ%?%?FF' D99,#z,)+)+(,,gw-?@@%VaZZ" !. 1 1'1 = =I ))17 g.eR 8j%2$7$7$9$9 N N G[))+/::Ey))E}  )) N =,,W55%a[ !!)&)z))49 g.q148 g.q105DM'*1-04DM'*1--*/ua)M g&&3 N Nr?heightc|i}|j|j}nd}|||rdS||j}|dd}|dd}|dd}|dkr d}|j}t |d}t |d }t |j||_|||||g|j|<d |_||g|j |<dS) a Set the width, and other properties of a row. Args: row: Row number (zero-indexed). height: Row height. (optional). cell_format: Row cell_format. (optional). options: Dict of options such as hidden, level and collapsed. Returns: 0: Success. -1: Row number is out of worksheet bounds. Nrr7rFrrrrT) rrSrrrrrrrr) r5r&r8rMrmin_colrrrs r;set_rowzWorksheet.set_rows* ?G ? &oGGG  ! !#w / / 2 >,FXu--KK U33  GQ'' Q;;F,FE1 E1 !$T%;U!C!C%k65)L c!% &v.sqr?c`|||}|||||S)a Set the width (in pixels), and other properties of a row. Args: row: Row number (zero-indexed). height: Row height in pixels. (optional). cell_format: Row cell_format. (optional). options: Dict of options such as hidden, level and collapsed. Returns: 0: Success. -1: Row number is out of worksheet bounds. )_pixels_to_heightr;)r5r&r8rMrs r;set_row_pixelszWorksheet.set_row_pixelss5*  ++F33F||Cg>>>r?hide_unused_rowsc`||j}||jkrd|_||_|r d|_dSdS)z Set the default row properties. Args: height: Default height. Optional, defaults to 15. hide_unused_rows: Hide unused rows. Optional, defaults to False. Returns: Nothing. NTr)rrrr)r5r8r?s r;set_default_rowzWorksheet.set_default_rowsO >,F T- - -$(D !&,D #  (&'D # # # ( (r?rc ||kr||krtddS||kr||}}||kr||}}|||rdS|||rdSt||||}t||dzD]}t||dzD]} |j|| fr2|j|| f} t d|d| d|j|| fr2|j|| f} t d|d| d||j|| f<|j ||||g| ||||t||dzD]=}t||dzD]'} ||kr| |kr| || d|(>d S) a3 Merge a range of cells. Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. data: Cell data. cell_format: Cell Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. other: Return value of write(). zCan't merge single cellr7rz Merge range '!' overlaps previous merge range ''.!' overlaps previous table range 'rgr) rrSr,rrrr!rrrr:r*) r5rvrwrxryrrMrr&rSprevious_ranges r; merge_rangezWorksheet.merge_range s>  Y(%:%: * + + +2 x  %-yY x  %-yY  ! !)Y 7 7 2  ! !(H 5 5 2iHhGG HqL11 ; ;CY1 55 ; ;$((#s44%)%6%:%:C:%F%FN*5 55"0555 #''c 33%)%5%9%93*%E%EN*5 55"0555 1;!3*-- ;$ 9i8DEEE Iy$ <<<HqL11 = =CY1 55 = =)##y(8(8!!#sB <<<< = qr?c||kr||}}||kr||}}|||||}t||||}||_||_||g|_t ||dzD]g}|j||fr;|j||f\}} |dkrtd|d| dd|f|j||f<hdS)a Set the autofilter area in the worksheet. Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. Returns: Nothing. rrzWorksheet autofilter range 'z,' overlaps previous Table autofilter range 'rD worksheetN) _convert_name_arear,rrrrrrr!) r5rvrwrxryarearefrSrrs r; autofilterzWorksheet.autofilterd sD$ i  %-yY i  %-yY&&y)XxPPy)Xx@@#!&1HqL11 E EC $$i%566 ,0,=,A,A9cBR,S,S) \'))*DsDD3?DDD 4?2DD y#. / / E Er?criteriac P|jstddS t|nH#t$r;|}t |dz\}}||jkrtd|dYdSYnwxYw|j\}}||ks||krtd|d|d|d dS||}t|d vrtd |d| ||}t|d kr*|d d kr| ||dgnpt|dkrI|d d kr=|d dkr1|dd kr%| ||d|dgn||j |<d |j |<d|_ dS)z Set the column filter criteria. Args: col: Filter column (zero-indexed). criteria: Filter criteria. Returns: Nothing. -Must call autofilter() before filter_column()NrPInvalid column ''Column '%' outside autofilter() column range (r))rhrz(Incorrect number of tokens in criteria 'rrrr%rh)rrr3r4r)rr_extract_filter_tokensrT_parse_filter_expressionfilter_column_listrrr)r5rSrN col_letterrU col_firstcol_lastrs r; filter_columnzWorksheet.filter_column s#  @ A A A F  HHHH   J(s33HQdo%%5 555666&%  !% 1H ??cHnn 3333#33'/333    F,,X66 v;;f $ $ GHGGG H H H..x@@ v;;!  q Q  # #C&) 5 5 5 5 [[A  &)q..VAY!^^q UV  # #C&)VAY)? @ @ @ @%+D S !$%D S !*?A/.A/filtersc |jstddS t|nH#t$r;|}t |dz\}}||jkrtd|dYdSYnwxYw|j\}}||ks||krtd|d|d|d dS||j|<d |j|<d |_ dS) z Set the column filter criteria in Excel 2007 list style. Args: col: Filter column (zero-indexed). filters: List of filter criteria to match. Returns: Nothing. rPNrPrQrRrSrT,rUr) rrr3r4r)rrrrr)r5rSr_rZrUr[r\s r;rYzWorksheet.filter_column_list s0#  @ A A A F  HHHH   J(s33HQdo%%5 555666&%  !% 1H ??cHnn ,3,,,, (,,,    F ' !r^c  |||ddrdS|||ddrdS|i}n|}hd}|D]}||vrtd|ddSd|vr |d|d <d |vr |d |d <d |vrtd dSd d ddddddddddd }|d |vrtd|d ddS||d |d <|d d kr,|d|ddS|d d ks|d dks |d dkr d|d<d|d<d|vrtddSiddddd d!d"d!d#d!d$d%d&d%d'd%d(d)d*d)d+d,d-d,d.d/d0d/d1d2d3d2} |d| vrtd4|dd5dS| |d|d<|ddks |ddkrd|vrtd6dSnd|d<d7d8d9d:} d;|vrd7|d;<n6|d;| vrtd4|d;d<dS| |d;|d;<|d d=vr~|d rvt |d ra||d } | d>|d <|dr7t |dr"||d} | d>|d<|dr4t|dd?krtd@|ddAdS|dBr4t|dBd?krtdC|dBdAdS|dr4t|ddDkrtdE|ddFdS|dGr4t|dGdDkrtdH|dGdFdS|d dkrSt|d tr8|j |d } t| dDkrtdI| dJdSdK|vrd8|dK<dL|vrd8|dL<dM|vrd8|dM<dN|vrd8|dN<||||gg|dO<dP|vr!|dO |dPdQ|vr|dQ dRdS|dQ<|j |d7S)Ta Add a data validation to a worksheet. Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. options: Data validation options. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: Incorrect parameter or option. Tr7N>rlrmaximumminimumrNdropdownvalidate error_type show_error show_input error_title input_title multi_range other_cells ignore_blank error_message input_messageUnknown parameter 'z' in data_validation()rNrrlrdrfz5Parameter 'validate' is required in data_validation()nonewholedecimalrrCrD textLengthcustom) anyz any valuez whole numberrsintegerrtrrCrDz text lengthr1rvzUnknown validation type 'z/' for parameter 'validate' in data_validation()rkrpbetweenrNrcz5Parameter 'criteria' is required in data_validation() not between notBetweenequal toequalr(== not equal tonotEqual!=<> greater than greaterThan> less thanlessThan<greater than or equal togreaterThanOrEqual>=less than or equal tolessThanOrEqual<=zUnknown criteria type 'z/' for parameter 'criteria' in data_validation()zcParameter 'maximum' is required in data_validation() when using 'between' or 'not between' criteriarrr)stopwarning informationrgz' for parameter 'error_type'.rCrD.16g zLength of input title 'z' exceeds Excel's limit of 32rjzLength of error title 'zLength of input message 'z' exceeds Excel's limit of 255rozLength of error message 'zLength of list items 'z;' exceeds Excel's limit of 255, use a formula range insteadrnrerirhcellsrmrl$rg)rScopykeysrrr'rrTrGr _csv_joinrEreplacerr) r5rvrwrxryrvalid_parameters param_key valid_typescriteria_types error_types date_timeris r;data_validationzWorksheet.data_validation s2  ! !)Yd C C 2  ! !(HdD A A 2 ?GGllnnG   *!  I 000L9LLLMMMrr1 w  &x0GG    &y1GG  W $ $ H I I I2# '"   : k 1 1 3GJ,?333   2)'**=>  J 6 ) ) M**2 O,,42 J 6 ) )z"f,,z"h.."+GJ !%GI  W $ $ H I I I2 y <      '  J   *  *  M        '(<  &  $%6 #! ( : n 4 4 3'**=333   2,WZ-@A  : ) + +wz/Bl/R/R''Er ("&GI    w & &$%GL ! ! \ "+ 5 5 /',*?///   2$/ 0E$FGL ! J #3 3 3  4#GG$455 4//0@AAI"+22GG y! 9&9'):L&M&M 9 33GI4FGG (1%8%8 " ;;} % % #gm.D*E*E*J*J /'-*@///   2 ;;} % % #gm.D*E*E*J*J /'-*@///   2 ;; ' ' C0H,I,IC,O,O 0GO,D000   2 ;; ' ' C0H,I,IC,O,O 0GO,D000   2 : & ( (Z8H$-O-O ($dngg&67G7||c!!8W888r  ( (&'GN # W $ $"#GJ  w & &$%GL ! w & &$%GL !' 8XFG G # # G  # #GM$: ; ; ; G # #%,]%;%C%CC%L%LGM " (((qr?c|||ddrdS|||ddrdS|i}n|}hd}|D]}||vrtd|ddSd|vrtd dSid d d d d d ddddddddddddddddddddd d!d"d"d#d#d$d%d&d'd(}|d|vrtd)|dd*dS|ddkrd|d+<||d|d<id,d,d-d.d/d0d1d0d2d0d3d4d5d4d6d4d7d8d9d8d:d;dd?d>d@dAdBdAdCdDdEdFdGdHdIdJdKdLdMdNdOdPdMdPdQ} dR|vr|dR| vr| |dR|dR<dS|vrEt |dSt r*t |dS|dS<|ddTvrd |d<dS|vrHt|dSstdUdS| |dS} | dV|dS<dW|vrHt|dWstdXdS| |dW} | dV|dW<dY|vrHt|dYstdZdS| |dY} | dV|dY<id[d\d]d^d_d`dadbdcdddedfdgdhdidjdkdldmdndodpdqdrdsdtdudvdwdxdydzd{d|} |dd'kr| d}std~dS|d}| vrtd|d}ddS| |d}|d}<d|d<|d} drd|d<n |d} drd|d<| | d| d|d<||kr||}}||kr||}}t||||} t||} d|vr|d} | dd} d|vr%|dr|d|d<|j|d<|xjdz c_|js| ds| ds| ds| ds| ds~| dsi| dsT| ds?| ds*| ds| drd|d<|ddkr|dS}t'|}|dR}|dRdDkrdD|d<d|d| d|d<ns|dRdEkrd|d<d|d| d|d<nU|dRdFkrdF|d<d| d|d|d|d<n4|dRdGkrdG|d<d| d|d|d|d<ntd|d|ddkr|dRdHkr d| d|d<n|dRdIkr d| d|d<n|dRdkr d| d|d<n|dRdJkr d| d| d|d<n|dRdKkr d| d| d|d<n|dRdLkr d| d| d|d<n|dRdMkr d| d| d|d<nm|dRdNkrd| d| d| d|d<nQ|dRdOkr d| d| d|d<n8|dRdPkrd| d| d| d| d |d<ntd|dRd|ddkr d| dÝ|d<|ddkr d| dĝ|d<|ddkr d| dƝ|d<|dd!kr d| d|d<|dd"krd|d<d|d<d|d<d|d<|dd̦|ddΦ|ddЦ|ddЦ|dt+dӦ|dt+dզt+j|d|d<t+j|d|d<|dd#krAd|d<d|d<|dd̦|dd֦|ddΦ|ddЦ|ddЦ|dt+dצ|dt+dئ|dt+d٦t+j|d|d<t+j|d|d<t+j|d|d<d|vrd|d<|dd%krZd|d<| d˦s d|d<d|d<n |d|d<| dͦs d|d<d|d<n |d|d<|ddЦ|ddЦ|dt+d|d|d|dd|dd|dd|dd|dt+d|dt+d|dd|dd|dd|dt+dt+j|d|d<t+j|d|d<t+j|d|d<t+j|d|d<t+j|d|d<| drFd|_|ddkr|ddkrd|d<|ddkr|ddkrd|d<| |d< |dd1|d<n#t2t4f$rYnwxYw |dd1|d<n#t2t4f$rYnwxYw |dd1|d<n#t2t4f$rYnwxYw| |jvr!|j| |n |g|j| <dS)a# Add a conditional format to a worksheet. Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. options: Conditional format options. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: Incorrect parameter or option. Tr7N>$rHiconsrlrYrcrdbar_onlyrNmax_typemid_typemin_type bar_color bar_solid max_color max_value mid_color mid_value min_color min_value icon_style icons_only max_length min_lengthrl stop_if_true bar_direction bar_no_border data_bar_2010 reverse_iconsbar_axis_colorbar_border_colorbar_axis_positionbar_negative_colorbar_negative_color_samebar_negative_border_colorbar_negative_border_color_samerqz' in conditional_format()rNrHz4Parameter 'type' is required in conditional_format()r/cellIsrCrDaverage aboveAverage duplicateduplicateValuesunique uniqueValuestoptop10bottomr time_period timePeriodblankscontainsBlanks no_blanksnotContainsBlankserrorscontainsErrors no_errorsnotContainsErrors 2_color_scale 3_color_scaledata_bardataBar expressioniconSet)riicon_setzUnknown value 'z.' for parameter 'type' in conditional_format() directionryrzr{r|r}r(r~rrrrrrrrrrrrrrrr containing containsText notContains beginsWithendsWith yesterdaytoday last7DayslastWeekthisWeeknextWeek lastMonth thisMonth nextMonth)znot containingz begins withz ends withrrz last 7 daysz last weekz this weekz next weekz last monthz this monthz next monthz continue weekzcontinue monthrNrlrz5Conditional format 'value' must be a datetime object.rrdz7Conditional format 'minimum' must be a datetime object.rcz7Conditional format 'maximum' must be a datetime object.3_arrows3Arrows3_flags3Flags3_traffic_lights_rimmed3TrafficLights23_symbols_circled3Symbols4_arrows4Arrows4_red_to_black 4RedToBlack4_traffic_lights4TrafficLights 5_arrows_gray 5ArrowsGray 5_quarters 5Quarters 3_arrows_gray 3ArrowsGray3_traffic_lights3TrafficLights3_signs3Signs 3_symbols 3Symbols2 4_arrows_gray 4ArrowsGray 4_ratings4Rating5_arrows5Arrows 5_ratings5Ratingrz_The 'icon_style' parameter must be specified when 'type' == 'icon_set' in conditional_format().rzUnknown icon_style 'z' in conditional_format().rh total_icons4rV5r%rrlrrgrYpriorityrrrrrrrrrrrris_data_bar_2010zNOT(ISERROR(SEARCH("z",z)))rinotContainsTextzISERROR(SEARCH("z))zLEFT(raz)="rzRIGHT(zInvalid text criteria 'zFLOOR(z ,1)=TODAY()-1z ,1)=TODAY()tomorrowz ,1)=TODAY()+1zAND(TODAY()-FLOOR(z ,1)<=6,FLOOR(z ,1)<=TODAY())zAND(TODAY()-ROUNDDOWN(z*,0)>=(WEEKDAY(TODAY())),TODAY()-ROUNDDOWN(z,0)<(WEEKDAY(TODAY())+7))z",0)<=WEEKDAY(TODAY())-1,ROUNDDOWN(z ,0)-TODAY()<=7-WEEKDAY(TODAY()))zAND(ROUNDDOWN(z+,0)-TODAY()>(7-WEEKDAY(TODAY())),ROUNDDOWN(z",0)-TODAY()<(15-WEEKDAY(TODAY())))z AND(MONTH(z)=MONTH(TODAY())-1,OR(YEAR(z)=YEAR(TODAY()),AND(MONTH(z)=1,YEAR(A1)=YEAR(TODAY())-1)))z)=MONTH(TODAY()),YEAR(z)=YEAR(TODAY()))z)=MONTH(TODAY())+1,OR(YEAR(z )=12,YEAR(z)=YEAR(TODAY())+1)))zInvalid time_period criteria 'z LEN(TRIM(z))=0z))>0zISERROR(rUz NOT(ISERROR( colorScalerrrrrrrrrrz#FF7128rz#FFEF9C percentilez#F8696Bz#FFEB84z#63BE7Br2autoMin x14_min_typeautoMax x14_max_typerz#638EC6rFz#FF0000#000000r)rSrrrrGr?rAupperr'rrr+_set_icon_propsr,r-r_get_dxf_indexr rrT setdefaultr _from_valuerlstripKeyErrorAttributeErrorrr)r5rvrwrxryrvalid_parameterr valid_type criteria_typer valid_iconsr start_cellrlr1rNs r;conditional_formatzWorksheet.conditional_format s2  ! !)Yd C C 2  ! !(HdD A A 2 ?GGllnnG% % % P!  I//O9OOOPPPrr0  G H H H2 H F  F  ~  *  n   7  g  F  <  &  ,  &  ,  _ _! "  # $$!'   . 6?* , , +'&/+++   2 6?h & &#+GK $WV_5! y! <!  !   ! ' ! J !  *!  *!  M!  !  !  !  '(<!  &!  $%6! #!! " .#! $,'#$&###%%%')A! ! ! H  WZ%8M%I%I"/ 0C"DGJ  g  *WW-=t"D"D "77#344::<>RSSS2 33GI4FGG (1%8%8 "G##*79+=>>RSSS2 33GI4FGG (1%8%8 "   x  &'8      m    0  ]  +  ]   0  x    ]    ! " # * 6?i ' ';;|,, Dr|$K7707<+@000r$/ 0E$FGL !&'GM "|$//44 +)* &&&11#66 +)* &#33 M**GKK,@,@  GG  x  "*IxI x  "*IxIiHhGG &y)<<  G # # /J#++C44J w  78#4  ' 1 @ @ B BGH #/  Q  # /{{?++ /{{;'' /{{-..  / {{/00  / {{455  /{{677 /{{;<< /{{?++ /{{.// /{{+,, /{{?++ /+/G& ' 6?f $ $G$EZZFz*Hz"n44"0%TE%T%TZ%T%T%T ""$ 55"3%O%O%O%O%O%O ""$ 44".%MZ%M%M&%M%MU%M%M%M ""$ 22",%Nj%N%N6%N%Ne%N%N%N ""RxRRRSSS 6?l * *z"k11%Gj%G%G%G ""$//%Ej%E%E%E ""$ 22%Gj%G%G%G ""$ 33777'777 "" $ 22OZOO)3OOO "" $ 22NZNN!+NNN "" $ 22PZPP!+PPP "" $ 33VVV)VV*4VVV ""$ 33999&999 "" $ 33===)==*4=='=== ""/WZ5H/// 6?. . .!=Z!=!=!=GI  6?1 1 1!=Z!=!=!=GI  6?. . .!9J!9!9!9GI  6?1 1 1!> !>!>!>GI  6?o - -*GFO!%GH #'GJ #'GK   z5 1 1 1   z5 1 1 1   {A . . .   {A . . .   {E),<,< = = =   {E),<,< = = =#(#4W[5I#J#JGK #(#4W[5I#J#JGK  6?o - -*GFO!%GH    z5 1 1 1   z< 8 8 8   z5 1 1 1   {A . . .   {A . . .   {E),<,< = = =   {E),<,< = = =   {E),<,< = = =#(#4W[5I#J#JGK #(#4W[5I#J#JGK #(#4W[5I#J#JGK '))') $ 6?i ' ' $GH ;;z** >&+ #*3''*1**=';;z** >&+ #*3''*1**='   {A . . .   {A . . .   {E),<,< = = =   17;3G H H H   z5 1 1 1    6 6 6   {E 2 2 2    3 3 3   3U95E5E F F F   :E)#>s#C#CGK .)    D  #*;#7#>#>s#C#CGK .)    D  #*;#7#>#>s#C#CGK .)    D  * * *  j ) 0 0 9 9 9 9-4ID j )qs6#ssss99t  t t00uu)rr7rNrc i}i}|i}n|}|jrtddS|||ddrdS|||ddrdS||kr||}}||kr||}}t ||||}t ||dzD]} t ||dzD]} |j| | fr2|j| | f} td|d| d |j | | fr2|j | | f} td|d | d ||j| | f<hd } | D]} | | vrtd | d dS|dd|d<|dd|d<|dd|d<||z }|dr|dz}|dkrtddS|dd|d<|dd|d<|dd|d<|dd|d<|dd|d<|dd|d<d|vr|d}||d<d |vrtd!|d"dStj d#|tj rtj d$|rtd%|d&dStj d'|rtd(|d&dStj d)|stj d*|rtd+|d,dSd-|vr8|d-|d-<|d-d.|d-<|d-d d.|d-<nd/|d-<|}|}|dr|dz }|dr|dz}t |||||d0<t |||||d1<|dsd|d<|dr |d1|d<d}g|d2<i}t ||dzD]}|d3t|zd.d.d.dd.ddd4 }d2|vrF|t!|d2kr|d2|dz }nd}|r|d5d}|d6r |d6|d<|d}|}||vrtd7|d&dSd||<|d8|d9<d:|vrj|d:rb|d:}|d;r|d;}||}||d}||d:<|d<r|d<}|d=krd>}|d?krd@}t-gdA}||vr|||d}n||d}||dB<dC}||d<<|dDd}||||||nM|dEr8|dE}||dE<|||||d5|||d5<|||dz <|d2||dr$||||d|d9|dz }dF|vr|dF}d}t ||dzD]} d} t ||dzD]|} |t!|krb| t!||krI||| }!| |vr|| | |!|| n|| | |!d| dz } }|dz }t;t ||dzD]h\}}|d2|}"|"rS|"d:rK||}#|"d:}t ||dzD]} || |||#i|j||dr{t ||dzD]g} |j|| fr;|j|| f\}$}%|$dGkrtdH|dI|%d dJ|f|j|| f<hdS)KaY Add an Excel table to a worksheet. Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. options: Table format options. (Optional) Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: Incorrect parameter or option. -3: Not supported in constant_memory mode. Nz5add_table() isn't supported in 'constant_memory' moderTr7rz Table range 'rErDrC> rrvstylecolumns total_rowrM header_row banded_rows last_column first_columnbanded_columnsrq' in add_table()rNr0r/rMrz1Must have at least one data row in in add_table()r2Fshow_first_colr1 show_last_colshow_row_stripesr3show_col_stripesheader_row_countr.totals_row_shownrv zName 'z&' in add_table() cannot contain spacesz^[\w\\][\w\\.]*$z^\dz*Invalid Excel characters in add_table(): 'rRz^[a-zA-Z][a-zA-Z]?[a-dA-D]?\d+$z-Name looks like a cell name in add_table(): 'z^[rcRC]$z^[rcRC]\d+[rcRC]\d+$zInvalid name 'z#' like a RC cell ref in add_table()r,rgTableStyleMedium9ra_ranger-Column) idrv total_stringtotal_function custom_total total_valuerirY name_formatrYrz'Duplicate header name in add_table(): ' header_formatrDrir(rA count_nums countNumsstd_devstdDevrrGcountrrrIsumvarrBrvrCr@rrIzTable autofilter range 'z0' overlaps previous Worksheet autofilter range 'r) rrzrrSr,rrrr!rrr.r/UNICODErrArTlowerr+r"rrtset_table_function_to_formular,r3rrr: enumeraterr)&r5rvrwrxryrr col_formatsrr&rSrFr%rnum_rowsrvfirst_data_row last_data_rowcol_id seen_namesr.col_data user_dataxformat header_namerifunction subtotalsrlr@rijr4 column_dataformula_formatrrs& r; add_tablezWorksheet.add_table s 2 ?GGllnnG    H I I I2  ! !)Yd C C 2  ! !(HdD A A 2 x  %-yY x  %-yYiHhGG HqL11 : :CY1 55 : :#''c 33%)%5%9%93*%E%EN*; ;;(6;;; $((#s44%)%6%:%:C:%F%FN*; ;;(6;;; 0: #s,, :$    !  I//F9FFFGGGrr0 ")]D!A!A  ' L$ ? ?  ' L$ ? ? i' <   MH a<< D E E E2#*++ne"D"D!(]E!B!Bo$+KK u$E$E !$+KK0@%$H$H !$+KK a$@$@ !$+KK U$C$C ! W  6?D E&Md{{JdJJJKKKr8/rzBB bhGG I$IIIJJJrx:DAA LTLLLMMMrx T** bh7NPT.U.U OdOOOPPPr g  $W-E'NW~%!#g#7^33C<II $IW6'mmHd;;G!}}X..?+4X+>(#+6"2K&,,..Dz))NtNNNOOO!rr'+Jt$.7mmO.L.LH]+!I--)I2F-"+I"6#--c22:&-nnS&9&9G#'"="=g"F"F#'"7"7"F"F.5+!}}%566*#,-=#>#|33'2H#y00'/H$'    % % $y00&*&E&E ((6*:''GG'+&;&;Hd&K&KG7>H^4'/H5=!12 ) mQ ? ?++HgwQVWWWW"~66'0'@ 3?0**$g|Y]]8=T=T *-4-C-C-E-E*/6K + )  # #H - - -|$ ""w(8(=:Q aKFF W  6?DA^]Q->??   HqL99C3t99}}Sa\\)9)9 $Q  ++ KKS%QHHHH KKS%>>>FAAQ )y(Q,)G)GHH O OOFG *62K O{95 O!,!8!8%i0 1BCCOOC''Wg~NNNN 5!!! < LY1 55 L L$(()S)9::040A0E0EyRUFV0W0W-K"k11.LzLL;GLLL 8? 6K!9c"233qr?c |||ddrdSdt||gi}|i}hd}|D]}||vrtd|ddSd|vrtd d S|d d }|d vrtdd S|dkrd}||d <d|vr3t |dt r |d|d<n |dg|d<t |dt r |d|d<n |dg|d<t|d}t|d} || krtdd St|d|d<t|j } g} |dD]N} | dd} | d} d| vr| dz| z} | | O| |d<g} |dD]-}| dd}| |.| |d<|d|d<|d|d<|d|d<|d|d <|d!|d"<|d#|d#<|d$|d$<|d%|d%<|d&|d&<|d'|d'<|d(|d)<|d*|d*<|d+d}|d,krd-|d.<n|d/krd0|d.<nd1|d.<|d2}|r d|vr| dz|z}||d2<|d3d-}t|}|d4|d5<|d|d6<|d#|d7<|d |d8<|d"|d9<|d|d:<|d|d;<|||d5|||d6|||d7|||d8|||d9|||d:|||d;|j |d-S)rraxisrHrr,weightmarkersreverselocation date_axis low_color low_point high_color high_point last_color last_point empty_cells first_color first_point plot_hidden show_hidden series_color markers_colornegative_colornegative_pointsrqz' in add_sparkline()rz0Parameter 'range' is required in add_sparkline()rNrHline)r{columnwin_losszJParameter 'type' must be 'line', 'column' or 'win_loss' in add_sparkline()r}stackedrjrangeszMMust have the same number of location and range parameters in add_sparkline()rKrrgr(!rohighrmlowrznegativertfirstrqlastrhrrrfrirvrrgrrzeroremptyconnectspangaprkr,seriesrwryrxrsrprnrl)rSr-rrrrGrrTr(rvrr"rr%_set_spark_colorr)r5r&rSr sparklinerr spark_type range_countlocation_count sheetname new_ranges spark_range new_locationsrjr date_rangestyle_idr,s r; add_sparklinezWorksheet.add_sparkline[s(  ! !#sD$ 7 7 2 #4S##>#>"?@ ?G   <!  I 000J9JJJKKKrr1 ' ! ! C D D D2[[00 ; ; ; 3   2  # #"J& &  '*-t44 ?)0)< +&&*1**=)> +& gg& - - 5")'"2Ih  #*7#3"4Ih )H-.. Y{344 . ( ( 0   2!;!788 '$DI..  $X. + +K%--c266K&,,S11K+%%'#o ;   k * * * *( ( !+. + +H''R00H   * * * *!. +$KK 55 &";;{33 % ' ,= > > *$[[77 '#KK 55 &&{{955 )";;u-- %";;u-- %#KK// &&{{955 )%kk-88 (%kk(33 ( M2.. F??!"Ig   i  !'Ig  !&Ig [[--  6#Z//"S:5J!+ +;;w**$X..$)(O .!&+J&7 "#%*9%5 /"#(> - "'- ,"'- ,!&u + i.AAA i2BCCC i/BBB i-@@@ i,??? i,??? i+>>> y)))qr?cd}t||}||kr||}}||kr||}}t||||}|dkrdS|||gg|_dS)a Set the selected cell or cells in a worksheet Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. Returns: 0: Nothing. NA1)r-r,r)r5rvrwrxrypane active_cellsqrefs r; set_selectionzWorksheet.set_selections| ( 9==  x  %-yY x  %-yYIxBB D== F +u56r?cL|dkr|dkrdSt|||_dS)z Set the first visible cell at the top left of a worksheet. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). Returns: 0: Nothing. rN)r-r)r5r&rSs r;set_top_left_cellzWorksheet.set_top_left_cellBs2 !88q F.sC88r?rvisible symbols_below symbols_right auto_stylecL||_||_||_||_d|_dS)a Control outline settings. Args: visible: Outlines are visible. Optional, defaults to True. symbols_below: Show row outline symbols below the outline bar. Optional, defaults to True. symbols_right: Show column outline symbols to the right of the outline bar. Optional, defaults to True. auto_style: Use Automatic style. Optional, defaults to False. Returns: 0: Nothing. TN)rrrrr)r5rrrrs r;outline_settingszWorksheet.outline_settingsTs1*"**'#r?top_rowleft_col pane_typec.||}||}|||||g|_dS)at Create worksheet panes and mark them as frozen. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). top_row: Topmost visible row in scrolling region of pane. left_col: Leftmost visible row in scrolling region of pane. Returns: 0: Nothing. N)r)r5r&rSrrrs r; freeze_paneszWorksheet.freeze_panesps/, ?G  H39= r?xyc8|||||ddS)a Create worksheet panes and mark them as split. Args: x: The position for the vertical split. y: The position for the horizontal split. top_row: Topmost visible row in scrolling region of pane. left_col: Leftmost visible row in scrolling region of pane. Returns: 0: Nothing. rN)r)r5rrrrs r; split_paneszWorksheet.split_paness&, !Q155555r?rlrcp|dks|dkrtd|dd}t||_dS)z Set the worksheet zoom factor. Args: zoom: Scale factor: 10 <= zoom <= 400. Returns: Nothing. z Zoom factor 'z"' outside range: 10 <= zoom <= 400rlN)rr3r)r5rs r;set_zoomzWorksheet.set_zoomsE "99s IIII J J JDII r?cd|_dS)z Display the worksheet right to left for some versions of Excel. Args: None. Returns: Nothing. TN)rrs r; right_to_leftzWorksheet.right_to_leftrr?cd|_dS)z Hide zero values in worksheet cells. Args: None. Returns: Nothing. rN)rrs r; hide_zerozWorksheet.hide_zerosr?colorc8tj||_dS)z Set the color of the worksheet tab. Args: color: A #RGB color index. Returns: Nothing. N)rr!rr5rs r; set_tab_colorzWorksheet.set_tab_colors*511r?rgpasswordc:|dkr||}|si}iddddddddddd dd dd dd dd ddddddddddddddd}|D]%}||vr ||||<td|d&||d<||_dS)z Set the password and protection options of the worksheet. Args: password: An optional password string. options: A dictionary of worksheet objects to protect. Returns: Nothing. rgsheetTcontentFobjects scenarios format_cellsformat_columns format_rowsinsert_columns insert_rowsinsert_hyperlinksdelete_columns delete_rowsselect_locked_cellssortrM pivot_tablesselect_unlocked_cellszUnknown protection object: 'rRrN)_encode_passwordrrr)r5rrdefaultsrs r;protectzWorksheet.protectsd r>>,,X66H G T u  u    E  e   5  e  5    e  5  "4  E  % E! " $T# *<<>> < ||_||_||_||_dS)z Set all the page margins in inches. Args: left: Left margin. right: Right margin. top: Top margin. bottom: Bottom margin. Returns: Nothing. N)rrrr)r5rrrrs r; set_marginszWorksheet.set_marginss)( !#r?rc|}|dd}t|dkrtddS|t|tsd|i}ni}|}|||d<g|_|drb|d|d <||d|}d |_ |j ||d rb|d |d <||d |}d |_ |j ||drb|d|d <||d|}d|_ |j || d}t|j}||kr!td|d|d|g|_dSd|vr |d|_ d|vr |d|_ ||_|dd|_d|_|r d|_dSdS)z Set the page header caption and optional margin. Args: header: Header string. margin: Header margin. options: Header options, mainly for images. Returns: Nothing. &[Picture]&GrzCHeader string cannot be longer than Excel's limit of 255 charactersNmargin image_leftimage_data_left image_dataLH image_centerimage_data_centerCH image_rightimage_data_rightRHNumber of footer images '#' doesn't match placeholder count ' ' in string: align_with_marginsscale_with_docrkT)rrTrrGrrrrr_header_positionrrKrrrrrr)r5rrr header_origrplaceholder_count image_counts r; set_headerzWorksheet.set_header  d33 v;;   V W W W F  gt,, .#W-G,,..   &GH   ;;| $ $ -$+KK0A$B$BGL !++GKK ,E,EwOOE%)E "   % %e , , , ;;~ & & -$+KK0C$D$DGL !++GKK,G,GQQE%)E "   % %e , , , ;;} % % -$+KK0B$C$CGL !++GKK ,F,FPPE%)E "   % %e , , ,"LL..$,--  + + HKHH+HH:EHH   "$D  F 7 * *(/0D(ED % w & &(/0@(AD % $[[377%)"  '"&D    ' 'r?rc|}|dd}t|dkrtddS|t|tsd|i}ni}|}|||d<g|_|drb|d|d <||d|}d |_ |j ||d rb|d |d <||d |}d |_ |j ||drb|d|d <||d|}d|_ |j || d}t|j}||kr!td|d|d|g|_dSd|vr |d|_ d|vr |d|_ ||_|dd|_d|_|r d|_dSdS)z Set the page footer caption and optional margin. Args: footer: Footer string. margin: Footer margin. options: Footer options, mainly for images. Returns: Nothing. rrrzCFooter string cannot be longer than Excel's limit of 255 charactersNrrrrLFrrCFrrRFrrrrrrkT)rrTrrGrrrrrrrrKrrrrrr)r5rrr footer_origrr r s r; set_footerzWorksheet.set_footerTr r?ct||}|dz }|dz }d|d|}t|j}|dz|z|_dS)z Set the rows to repeat at the top of each printed page. Args: first_row: Start row for range. last_row: End row for range. Returns: Nothing. Nrrz:$r)r(rvr)r5rvrxrKrs r; repeat_rowszWorksheet.repeat_rowssb   H Q A +9****$DI.. )C$ 6r?c||}t|d}t|d}|dz|z}t|j}|dz|z|_dS)z Set the columns to repeat at the left hand side of each printed page. Args: first_col: Start column for range. last_col: End column for range. Returns: Nothing. NrrBr)r*r(rvr)r5rwryrKrs r;repeat_columnszWorksheet.repeat_columnssg   H#9a00 !(A..3)$DI.. )C$ 6r?optionc|dkrd|_d|_d|_dS|dkrd|_d|_dSd|_d|_dS)a1 Set the option to hide gridlines on the screen and the printed page. Args: option: 0 : Don't hide gridlines 1 : Hide printed gridlines only 2 : Hide screen and printed gridlines Returns: Nothing. rrTN)rrr)r5rs r;hide_gridlineszWorksheet.hide_gridliness` Q;;#$D $%D !)-D & & & q[[#$D $%D ! ! !#$D $%D ! ! !r?c"d|_d|_dS)z Set the option to print the row and column headers on the printed page. Args: None. Returns: Nothing. TN)rrrs r;print_row_col_headerszWorksheet.print_row_col_headerss"%)"""r?cd|_dS)z Set the option to hide the row and column headers on the worksheet. Args: None. Returns: Nothing. TN)rrs r;hide_row_col_headerszWorksheet.hide_row_col_headerss $r?c|dkr$|dkr||jdz kr||jdz krdS|||||}||_dS)a Set the print area in the current worksheet. Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. Returns: 0: Success. -1: Row or column is out of worksheet bounds. rrr7)rrrJr)r5rvrwrxryrKs r; print_areazWorksheet.print_area sg, NNQDOa///DOa///2&&y)XxPP $qr?c"d|_d|_dS)z Set the order in which pages are printed. Args: None. Returns: Nothing. rTN)rrrs r; print_acrosszWorksheet.print_across0s"&r?c>d|_||_||_d|_dS)a Fit the printed area to a specific number of pages both vertically and horizontally. Args: width: Number of pages horizontally. height: Number of pages vertically. Returns: Nothing. rTN)rrrr)r5rr8s r; fit_to_pageszWorksheet.fit_to_pages>s'  "&r? start_pagec||_dS)z Set the start page number when printing. Args: start_page: Start page number. Returns: Nothing. N)r)r5r$s r;set_start_pagezWorksheet.set_start_pagePs%r?scalec|dks|dkrtd|ddSd|_t||_d|_dS)z Set the scale factor for the printed page. Args: scale: Print scale. 10 <= scale <= 400. Returns: Nothing. rrz Print scale 'z#' outside range: 10 <= scale <= 400NrT)rrr3rr)r5r's r;set_print_scalezWorksheet.set_print_scale]sY 2:: KKKK L L L F u::"&r?c"d|_d|_dS)z Set the option to print the worksheet in black and white. Args: None. Returns: Nothing. TN)rrrs r;print_black_and_whitezWorksheet.print_black_and_whitess "&r?breaksc||_dS)z Set the horizontal page breaks on a worksheet. Args: breaks: List of rows where the page breaks should be added. Returns: Nothing. N)rr5r,s r;set_h_pagebreakszWorksheet.set_h_pagebreaks r?c||_dS)z Set the horizontal page breaks on a worksheet. Args: breaks: List of columns where the page breaks should be added. Returns: Nothing. N)rr.s r;set_v_pagebreakszWorksheet.set_v_pagebreaksr0r?rvcZ| ||_dSdt|jdzz|_dS)z Set the VBA name for the worksheet. By default this is the same as the sheet name: i.e., Sheet1 etc. Args: name: The VBA name for the worksheet. Returns: Nothing. NSheetr)r rArw)r5rvs r; set_vba_namezWorksheet.set_vba_names9   $D    '#dj1n*=*= =D   r?c|dS|}hd}|D]}||vrtd|ddS||_dS)a Ignore various Excel errors/warnings in a worksheet for user defined ranges. Args: options: A dict of ignore errors keys with cell range values. Returns: 0: Success. -1: Incorrect parameter or option. Nr7> eval_error formula_rangeformula_differsformula_unlockedcalculated_columntwo_digit_text_yearempty_cell_referencelist_data_validationnumber_stored_as_textrqz' in ignore_errors()r)rrrr )r5rrrs r; ignore_errorszWorksheet.ignore_errorss ?2,,..    !  I 000J9JJJKKKrr1&qr?cV|d|_|d|_|d|_|d|_|d|_|d|_|d|_|d|_|d |_|d |_ |d |_ |d |_ |d |_ |d|_ |d|_|d|_|d|_|d|_|d|_|jrFd|_d|_d|_d|_d|_d|_d|_d|_d|_d|_|jr]t;j|j\}}t?j |||_!tE|dd|_#|j#|_$dSdS)Nrvrwrxrrzr{r rrrrrrrrrrr"r$g)@rjr?F)dirzw+utf-8modeencoding)%rvrwrxrrzr{r rrrrrrrrrrr"r$rrrrrrrrrrtempfilemkstemposcloseropenrr)r5 init_datafdfilenames r; _initializezWorksheet._initializesf% w' ";/'(89():;) ";/"+,@"A#,-B#C ():;!*+>!?#,-B#C "+,@"A#,-B#C ():;():;'(89$-.D$E!():;   .',D $&+D #&(D ##D  $D DO!"D !$D !$D (-D %   '&-$+>>>NR HRLLL%-D "#H4'JJJD &DGGG ' 'r?c&||||||||js|n| | | |j r| ||||||||||||||||||| d|!dS)NrI)"_xml_declaration_write_worksheet_write_sheet_pr_write_dimension_write_sheet_views_write_sheet_format_pr _write_colsrz_write_sheet_data_write_optimized_sheet_data_write_sheet_protection_write_protected_rangesr_write_phonetic_pr_write_auto_filter_write_merge_cells_write_conditional_formats_write_data_validations_write_hyperlinks_write_print_options_write_page_margins_write_page_setup_write_header_footer_write_row_breaks_write_col_breaks_write_ignored_errors_write_drawings_write_legacy_drawing_write_legacy_drawing_hf_write_picture_write_table_parts_write_ext_listr _xml_closers r;_assemble_xml_filezWorksheet._assemble_xml_file s     !!! ##%%% # /  " " $ $ $ $  , , . . . $$&&& $$&&&   &  # # % % % !!! !!! ''))) $$&&&     !!###   """     !!###         ""$$$  ""$$$ %%'''  !!!  +&&& r?cR|dks|dkrdS||jks ||jkrdS|s|s|jr ||jkrdS|s2|j ||jkr||_|j ||jkr||_|s2|j ||jkr||_|j ||jkr||_dSrR)rrrzrrrrr)r5r&rSrrs r;rSzWorksheet._check_dimensionsms 77cAgg2 $/ ! !SDO%;%;2 * 1E T&&&r &&#*?*?"%&#*?*?"% &&#*?*?"%&#*?*?"%qr?c8t||j|jSN)r$r r)r5dt_objs r;rzWorksheet._convert_date_times*64>4CWXXXr?cd}d}d}d}t|d} t|d} dt|dzz} dt|dzz} |dkr||jdz kr| }| }d}n%|dkr||jdz kr| }| }d}n | | z}| | z}||kr|s|}n|dz|z}t |j} | dz|z}|S)NrgrrrrBr)r*rArrr(rv)r5 row_num_1 col_num_1 row_num_2 col_num_2range1range2rK row_col_only col_char_1 col_char_2 row_char_1 row_char_2rs r;rJzWorksheet._convert_name_areas $Iq11 #Iq11 3y1}--- 3y1}---  >>i4?Q+>>>FFLL !^^ T_q-@ @ @FFLL*,F*,F V  L DDC<&(D$DI.. 3% r?c|sgSt|}d|vr|dt|}|d}t ||kr |d|}|S)Nri)rPremoverrrT)r5r, breaks_set breaks_listmax_num_breakss r;_sort_pagebreakszWorksheet._sort_pagebreakss I[[ ??   a :&&  {  n , ,%o~o6Kr?c@|sgStjd}||}g}|D]k}|dr |dd}|dr |dd}|dd}||l|S)Nz"(?:[^"]|"")*"|\S+rrr7z"")r.compilefindallr+r-rr)r5rtoken_rer new_tokensr4s r;rWz Worksheet._extract_filter_tokenss I:344!!*--  % %E$$ "abb ~~c"" #crc MM$,,E   e $ $ $ $r?czt|dkr|d}tjd|rd}n.tjd|rd}ntd|d|d |||dd}|||d d}||gz|zS|||S) Nrrhz(and|&&)rz (or|\|\|)rToken 'z3' is not a valid conditional in filter expression 'rRrV)rTr.r/r_parse_filter_tokens)r5rr conditional expression_1 expression_2s r;rXz"Worksheet._parse_filter_expressions v;;!  !)Kx K00  , 44  ;k;;-7;;;  44Z!MML44Z!MML;-/,> >((V<<%> ',/00E%E  &MME r?rimage_id drawing_idc |j|jz}|j|jz}|d|jz z}|d|jz z}||j|j|j |j |||j }td|dzz}td|dzz}|j sMt}d|_||_ |jddt%|zdzdgn|j }t'}t(j|_||_|j|_||_||_d|_|j |_ d|_|j|_|j |j|_|jr|j} | } | } |j!"| j#s|j$d | | g|%| j#| _| |_|j!"|j&s7|j$d d t%|zd z|j'zg|%|j&|_|(|dS) NgX@rC5%r/drawing../drawings/drawing.xmlr /hyperlink/image../media/image.))_width_x_scale_height_y_scale_x_dpi_y_dpi_position_object_emusrr _x_offset _y_offset_anchorr3rrembeddedrrrArrIMAGE _drawing_type _dimensionsr _description_shape _rel_index _decorativer_url_target _target_moderr_linkr_get_drawing_rel_index_digest_image_extension_add_drawing_object) r5rrrrr8 dimensionsrdrawing_objectrtarget target_modes r;_prepare_imagezWorksheet._prepare_images u~-/  $$$%%// J J O O   M  C54<())SFTM*++| #iiG G "DL  ' . .2S__DvMtT    lG$'3'9$%/"&+&6# %!' $!&$%!%*%6"   (*/*;N ' : &*C[[]]F**,,K$((33 O"))<*MNNN!88CCCN"%N  $$U]33    % %$s8}}4s:U=SS   %)$?$? $N$N!##N33333r?c L|j|\ }}}}}}} } } } } | d|jdz}| d|jdz}||z}||z}|||||||| }t d|dzz}t d|dzz}|jsMt}d|_||_|j dd t|zd zdgn|j}td d | }| |_ t}tj|_||_||_||_| |_||_| |_d |_| |_t5j| }|r|}|}|j|js|j d||g|!|j|_||_"|#|dS)Nrrhr8rrCrrrrrrectTextBoxrr)$rrrrrr3rrrrrrAr#rrrSHAPErrrrrrrrrr from_optionsrrrrrrrr)r5rwrr&rSrrrrrrrrrrr8rrshaperrrrs r;_prepare_shapezWorksheet._prepare_shapesO K             GT%'BCC '// h%  C54<())SFTM*++| #iiG G "DL  ' . .2S__DvMtT    lGfi11 $'3'9$%/" %!'&1# %!'$%!%/"w''  &[[]]F**,,K$((33 O"))<*MNNN!88CCCN"%N ##N33333r?cdtjdd|j|_|j|js7|jddt|zdz|j zg| |j|_ |j |dS)Nz\..*$rgrrr) r.rrrrrrrrAr_get_vml_drawing_rel_index_ref_idr)r5rrs r;_prepare_header_imagezWorksheet._prepare_header_images6(B0@AA$((77   " ) )$s8}}4s:U=SS   77 FF  &&u-----r?cj|jddt|zdz|zgdS)Nrrr)rrrA)r5rimage_extensions r;_prepare_backgroundzWorksheet._prepare_background/sE &-- '#h--7#=O P     r?c |j|\ }}}}}} } } } } |dz |_td|j| zz}td|j| zz}|||||||| }|j}|jsLt}d|_ ||_|j ddt|zdzgn|j}t}tj|_||_||_||_||_d|_| |_||_| |_| |_|||j ddt|zdzgdS)NrrCrrrz/chartz../charts/chart)rr?r3rr8r chart_namerrrrrrArrCHARTrrrr_namerrrrrrrr)r5rwchart_idrr&rSrrrrrrrrrr8rrvrrs r;_prepare_chartzWorksheet._prepare_chart5s K           a<C5;0122SEL72344// h%  | #iiG G "DL  ' . .2S__DvMN    lG$'3'9$%/" %!'# $!'$($?$?$A$A!&1#%/"##N333 !! (3x==86A B     r?c b||||||||\ }}}}}} } } } } tdd|zz}tdd|zz}tdd| zz} tdd| zz} tdd| zz} tdd| zz} |||||| | | | | f S)NrCr)_position_object_pixelsr3)r5 col_start row_startx1y1rr8rcol_endrow_endx2y2x_absy_abss r;rzWorksheet._position_object_emusos(  ( ( y"b%             tby ! ! tby ! ! tby ! ! tby ! !C$,&''C$,&''9b"gwBuUUr?c jd}d} |dkr2|dkr,|||dz z }|dz}|dkr|dk,|dkr2|dkr,|||dz z }|dz}|dkr|dk,td|}td|}|jr+t |D]} ||| z }n ||j|zz }||z }|jr+t |D]} | || z } n | |j|zz } | |z } ||||kr7|||z}|dz }||||k7||||kr7|||z}|dz }||||k7|} |} |||dkr||z}|||dkr||z}||| |kr8||| |z}| dz } ||| |k8||| |kr8||| |z}| dz } ||| |k8|}|}||||| | |||| g Sr2) _size_col _size_rowrrrrrr)r5rrrrrr8rrrrWrow_idrrrrs r;rz!Worksheet._position_object_pixelssI(1ffQ $..Q// /B NI1ffQ 1ffQ $..Q// /B NI1ffQ BZZ BZZ   9 ** 0 0/// 0 T,y8 8E     9 ** 0 0/// 0 T,y8 8E  DNN9f5555 $..++ +B NIDNN9f5555 DNN9f5555 $..++ +B NIDNN9f5555  >>)V , ,q 0 0BJE >>)V , ,q 0 0b[Ft~~gv6666 T^^GV44 4E qLGt~~gv6666 w7777 dnnWf55 5F qLGw7777  9b"gwBuUUr?cd}d}d}||jvrr|j|d}|j|d}||j}|r |dkrd}n?|dkrt|||zzdz}n t||zdz|z}n|j}|S)Nrr%rrrVrrC)rrr3r)r5rSrmax_digit_widthpaddingpixelsrrs r;rzWorksheet._size_cols  $-  M#&q)E]3'*F}. F&A++Uo&?@3FGGU_4s:;;gE,F r?cd}||jvrD|j|d}|j|d}|r |dkrd}n*td|z}ntd|jz}|S)NrrrVgUUUUUU?)rr3r)r5r&rrr8rs r;rzWorksheet._size_row/s  $. ^C(+F^C(+F 1&A++Y/00T%<<==F r?c<d}d}|dkr |||zz }n||z |z }|S)Ng@g@ rQ)r5rrrrs r;rzWorksheet._pixels_to_widthDs: R<<o78EEg%8E r?c d|zS)NrjrQ)r5rs r;r=zWorksheet._pixels_to_heightPs f}r?c d}||j|j|j|j|j|j|}||j||j|SNr)r start_col start_rowrrrr8r)r5rrverticess r;_comment_verticeszWorksheet._comment_verticesTsp//         M N     &&&'''r?rc d}||j|j|j|j|j|j|}||j||j|Sr)rrSr&rrrr8r)r5rrrs r;_button_verticeszWorksheet._button_verticesgsl// J J O O L M     %%% &&&r?cRg}t|j}|D]}t|j|}|D]j} |j|| } || | _| j |j| _| j |j| _| | k|j D]} | | | _|j ddt|zdzg|jr6||_|j ddt|zdzgt#|} |} t%t'| dz D]}| |zdz}|d |}||_||_| S) N /vmlDrawing../drawings/vmlDrawing.vmlz /commentsz ../commentsrrrrra)r&rrrr is_visiblerrrrrrrrArrrrTrr3rr)r5rrvml_drawing_id comment_idrrow_numsr&col_numsrSrrrK start_data_idr_data_ids r;_prepare_vml_objectszWorksheet._prepare_vml_objectszs$-,,..// ) )CdmC0557788H ) )-,S1#'#9#9'#B#B %-)-)>G&>)%)%9GN(((( )' < 7J7JJVS T      !)D   ' . .mc*oo=FG   H # s54<(()) 5 5A#a'!+G(44744KK&( r?cr||_|jddt|zdzgdS)Nrrr)rrrrA)r5rrs r;_prepare_header_vml_objectsz%Worksheet._prepare_header_vml_objectssL+ && 4s>7J7JJVS T     r?cX|jD]}||d<|ddt|z|d<|d}||vrt d|ddd||<|jddt|zd zg|d z }dS) Nr?rvTablezDuplicate name 'z ' used in worksheet.add_table().Tz/tablez../tables/tablerr)rrrArOr rr)r5table_idseenrrvs r;_prepare_tableszWorksheet._prepare_tabless[  E"E$Kyy  ( '#h-- 7f =&&((Dt||(VuV}VVVDJ  % , ,,s8}}..s1TTTd*T3"7"7ATTTTTr?ra)r)r5r*s r;rzWorksheet._csv_join*s(UTeTTTxxr?ctjd|r|S|dd}|dd}|dd}|dd }|d d }|d d }|dd}|dd}|dd}|dd}|dd}|S)Nz%[0-9a-fA-F]{2}rz%25rz%22r;z%20rz%3crz%3erz%5brz%5d^z%5e`z%60roz%7br)z%7d)r.rqr)r5rs r; _escape_urlzWorksheet._escape_url2s 9& , , Jkk#u%%kk#u%%kk#u%%kk#u%%kk#u%%kk#u%%kk#u%%kk#u%%kk#u%%kk#u%%kk#u%% r?c||xjdz c_|jS|j|r |j|S|xjdz c_|j|j|<|jSNr)rrrr5rs r;rz Worksheet._get_drawing_rel_indexFsx >  A % ' '    ( ( -$V, , !$($8&!##r?c|j|r |j|S|xjdz c_|j|j|<|jSr0)rrrr1s r;rz$Worksheet._get_vml_drawing_rel_indexSsV  $ $V , , 1(0 0   A%  (,(@f%''r?c|j}|d|jr|d|jr|d|jr|d|jr|d|jr|d|jr| |j|j dkr| d|j d kr| d |d d |j fg|j d krn|j r|dd|j fgn{|jr|dd|jfgnU|jr7|j}|js(|d|n|ddg|dd |jfg|dd |jfg|jdkr%|js|dd |jfg|ddS)NrPrbr_strikeoutlineshadowr superscriptr subscriptszvalr7rthemeindexed)r=rrFontfamilyCalibrischeme)rrbold_xml_empty_tagitalicfont_strikeout font_outline font_shadow underline_write_underline font_script_write_vert_align font_sizer=_write_rstring_color color_indexed font_color _is_automatic _attributes font_name font_family hyperlink font_schemer)r5 xf_format xml_writerrs r;rzWorksheet._write_fontbs\ !!%((( > +  % %c * * *   +  % %c * * *  # 0  % %h / / /  ! 1  % %i 0 0 0   0  % %h / / /   7  ! !)"5 6 6 6  A % %  " "= 1 1 1  A % %  " "; / / / !!$%1D)E(FGGG ?b  _ ?  % %g)/0J/K L L L L  $ ?  % %gI > > !!'UI4G,H+IJJJ!!(eY5J-K,LMMM  ) + +I4G +  % %h%9N1O0P Q Q Q&&&&&r?czg}|dkrdg}n|dkrdg}n |dkrdg}|jd|dS)Nr)r<double!)r<singleAccounting")r<doubleAccountingurrD)r5rIrs r;rJzWorksheet._write_underlines^  >>+,JJ "__56JJ "__56J ##C44444r?cFd|fg}|jd|dS)Nr< vertAlignr`r5r<rs r;rLzWorksheet._write_vert_aligns+cl^  ##K<<<<E!HW% (7+C!#s++<s0C0C<,/JJsOOa)a=$$V,, 5"PK!!}V,K??P:a=;PPPP ,6a=+@a( 8F+x77/4E!HV,&a=,,Z880C+/E!HZ( r?cd}|dz}|dz}|dz}d}|dz}d|fd|fg}|jd krC|d |f|d |f|d |d |dS)Nz"http://schemas.openxmlformats.org/zspreadsheetml/2006/mainz!officeDocument/2006/relationshipszmarkup-compatibility/2006zhttp://schemas.microsoft.com/zoffice/spreadsheetml/2009/9/acxmlnszxmlns:rrzxmlns:mcz xmlns:x14ac)z mc:Ignorablex14acrI)rrr)r5schemarxxmlns_rxmlns_mc ms_schema xmlns_x14acrs r;rTzWorksheet._write_worksheets622>>773 "BB &G(<=    % %   z84 5 5 5   }k: ; ; ;   7 8 8 8 K44444r?c|j |jd}n|j`|jY|j|jkrtd|j}ntd|j}td|j}|dz|z}nw|j|jkr+|j|jkrt|j|j}nCC _ $)D $/11'4?;;+1do>>*1do>>slV+ _ / /DOt4V4V#DOT_EECC'tHHF&tHHF3,'C K5#,88888r?c|d||ddS)N sheetViews)r_write_sheet_viewrrs r;rWzWorksheet._write_sheet_views<sD L)))     ,'''''r?cg}|js|d|jr|d|js|d|jr|d|jr|d|js|d|jdkr|dn |jd kr|d |jd kr|d |jf|j d kr|d|j f|jdkr#|j r|d|j f|jdkr|d|j f|jd kr|d|j f|d|j s|j rU| d||||ddS|d|dS)N) showGridLinesr)showRowColHeadersr) showZerosr rightToLeftr) tabSelectedrshowOutlineSymbolsrr)r pageLayoutr)rpageBreakPreviewrg topLeftCellrl zoomScalerzoomScaleNormalzoomScalePageLayoutViewzoomScaleSheetLayoutView)workbookViewIdr sheetView)rrrrrrrr rrrrrr _write_panes_write_selectionsrrDr5rs r;rzWorksheet._write_sheet_viewEs $ 4   2 3 3 3   8   6 7 7 7 0   . / / /   2   0 1 1 1 = 2   0 1 1 1 9   7 8 8 8 >Q     4 5 5 5 5 ^q   : ; ; ;   # #   }d.@A B B B 9     {DI6 7 7 7~""t'="!!#4di"@AAA~""!!#?  "d&> > >   1 2 2 2  " 1   / 0 0 0  >   0)< = = =  >   0)< = = =   % %   9 : : : OZ88888r?c|jsdS|dt|jd}|}|j|}|j|=|}|}t|jD]>}|j|}||dzkr ||kr|}!|||||}|}|}?||||||j|<|ddS)Ncolsrr)rrr&r_write_col_infor)r5rwryprev_col_options deleted_coldeleted_col_optionsrS col_optionss r;rYzWorksheet._write_colss5}  F F###DM..001115 =3 M) $ .$-,,..// / /C-,Khl""{6F'F'F$$Y:JKKK $#.   Y2BCCC&9 k" &!!!!!r?c|\}}}}}} d} d} |r|} | |sd}d} n d}n|dkrd} |dkrd} d} |dkr   {DO< = = =  s " "   w(89 : : : = >T^q00   |T^< = = = = @T_11   }do> ? ? ? ? =   ; < < < ?Q     0$/B C C C   <   9 : : : :   : ; ; ;   6   4 5 5 5 ?a     9 : : :   J" J!!?D4G"HIII  F!!=$2C"DEEE  F!!=$2C"DEEE" J!!?D4G"HIII K44444r?c(g}|jsdS|jr|d|jr|d|jr|d|jr|d|d|dS)N)horizontalCenteredr)verticalCenteredr)headingsr) gridLinesr printOptions)rrrrrrrDrs r;rdzWorksheet._write_print_optionss )  F < 9   7 8 8 8 < 7   5 6 6 6   /   o . . .   0   . / / / NJ77777r?cg}|js|d|js|d|jrc|d||jr||jr|| ddS|j r| d|dSdS)N) scaleWithDocr)alignWithMarginsr headerFooter) rrrrrr_write_odd_headerr_write_odd_footerrrrDrs r;rgzWorksheet._write_header_footers ( 3   1 2 2 2( 7   5 6 6 6  % <    ; ; ;{ )&&((({ )&&(((   n - - - - -  ! <    ; ; ; ; ; < *5DDD:g&Qdm336666t}W7MNNN#($/A:M#N#NHH"dj&999&*j&9'&BG ,,WgwGGG%%e,,,, --))'4w9OPPPP))'4w9OPPPE" Q" Qr?cV|j}||_||jvs||jvs |j|rd}|j|r||jvr|||n"||||j|t |j|jdzD];}||j|vr*|j||}||||<| dn"| |||j||j dS)Nrr&) rrrrrrrrrrrclear)r5current_row_numr-rr.rs r;rVzWorksheet._write_single_rowsE#+ dm # #w$-'?'?4:gCV'?Dz'" M$-//OOGT2222OOGT4=3IJJJ$T_do6IJJDDG$*W"555"&*W"5g">(('7CCC!!%((((%%gtT]75KLLL r?cti}d}d}t|j|jdzD] }||jvrVt|j|jdzD]8}||j|vr'||}|}t ||}t||}9||jvr_t|j|jdzD]A}||jvr6||j|vr'||}|}!t ||}t||}B|dzdzdks ||jkr*t|dz }||dz }|dz }|d|||<d} ||_ dS)Nrr$rrB) rrrrrrrrrr3r)r5spansspan_minspan_maxr-r.rs r;rzWorksheet._calculate_spanss T_do.ABB $ $G$*$$$T_do6IJJ>>G$*W"555#+'.H'.HH'*8W'='=H'*8W'='=H$-''$T_do6IJJ>>G$-//Gt}W?U4U4U#+'.H'.HH'*8W'='=H'*8W'='=H1"a''Gt,F,F 2.. 'MHMH+3(@(@h(@(@E*%#Hr?cd}|r |\}}}} } nd\}}}} } ||j}d|dzfg} |r|}|r| d|f|r| d|f|r| d||jks||jkr$||jkr| d|d f|r| d ||jks||jkr ||jkr| d | r| d | f| r| d |jdkr| d|r|d| dS|d| dS)Nr)NNrrrrrrs) customFormatrhtg)rrrr)rrrrr&)rrrrr_xml_empty_tag_unencoded_xml_start_tag_unencoded) r5r&r properties empty_rowrr8rMrrrrs r;rzWorksheet._write_row.s   P,FC!Gn%   3"0022H  0   w. / / /  /   sHo . . .  3   1 2 2 2 T- - - d. . .6T=T3T3T   t]]3 4 4 4  -   m , , , T- - - d. . .6T=T3T3T   1 2 2 2  7   ~u5 6 6 6  0   . / / /   % %   9 : : :  =  ) )% < < < < <  ) )% < < < < |j|d}|)|d|f|jj} | dvr||j |dS| dvr|j } |j s| | |dS| | } | dr-| dr|| |dSt#| } || | |dS| dkr|j} t)|jt*r"|d |jrd} n_d } n\t)|jt,rBd } |jd krn4|j| vr|d n|d||j| |dS| dkr|jdkr|d t5|jn%#t6$r|dYnwxYw|d|||j|j||j| ddS| dkr|!d|dS| dkr\|d |d|||j"| ddS| dkrx|d |d|jf|d|||j#| ddSdS)Nrrrr%rzzr^)rr5r)r`z#N/Az#NAME?z#NULL!r_z#REF!rrg)re)rrArar~)cmrcrXr]rZvm)$r.rYrrrrr%r)_xml_number_elementrZrLrz_xml_string_element_escape_control_charactersr+r-_xml_rich_inline_stringr&_xml_inline_stringrlrGr?rA_xml_formula_elementrirr1r4r_write_cell_array_formular_write_cell_valuerrDrr)r5r&rSr/rrrrow_xfcol_xftype_cell_namerLrrl error_codess r;rzWorksheet._write_cellis,C55 J'( ; A{0022H   sHo . . . . DM ! !dmC&8&; !]3'*F   sF$8$8$:$:; < < < < DM ! !]3'*F!!!3(<(<(>(>"?@@@0 3 3 3  $ $T[* = = = = = 7 7 7[F' J((<<<<< 88@@$$U++J0G0GJ00DDDDD 4F;;H++FHjIIIII y ( (JE$*d++ 4!!*---:EEEEDJ,, 4 :##Z;..%%j1111%%l333  % %dlE: F F F F F ~ - -zY&&!!),,, 0dj!!!! 0 0 0!!,///// 0   Z 0 0 0  * *4< D D D  " "4: . . .   c " " " " " w & &   Z 0 0 0 0 0 y ( (   j ) ) )   Z 0 0 0  " "4< 0 0 0   c " " " " " w & &   j ) ) )   tTZ0 1 1 1   Z 0 0 0  " "4: . . .   c " " " " " ' &s.KK%$K%c:|d}|d|dS)Nrgvr)r5rls r;rzWorksheet._write_cell_values( =E sE*****r?c@dd|fg}|d||dS)N)rarrayrLr5r)r5rirrs r;rz#Worksheet._write_cell_array_formulas/$uj&9:  sGZ88888r?cg}|js|js|js|js |jsdS|jr|d|jf|jr|d|js|js|jri|d|||| | ddS| d|dS)NcodeName) filterModersheetPr) rrrrr rr_write_tab_color_write_outline_pr_write_page_set_up_prrrDrs r;rUzWorksheet._write_sheet_prs/   N N (   %   F   ?   z4+<= > > > > 1   / 0 0 0 = 7DN 7d.B 7    : 6 6 6  ! ! # # #  " " $ $ $  & & ( ( (   i ( ( ( ( (    : 6 6 6 6 6r?cJ|jsdSdg}|d|dS)N) fitToPager pageSetUpPr)rrDrs r;rzWorksheet._write_page_set_up_prs5}  F&'  M:66666r?cl|j}|sdS|d|dS)NtabColor)r _write_colorrRrs r;rzWorksheet._write_tab_colors>  F *e&7&7&9&9:::::r?c(g}|jsdS|jr|d|js|d|js|d|js|d|d|dS)N) applyStylesr) summaryBelowr) summaryRightrr outlinePr)rrrrrrrDrs r;rzWorksheet._write_outline_prs #  F   2   0 1 1 1! 3   1 2 2 2! 3   1 2 2 2 9   7 8 8 8 K44444r?c||j}|sdSt|}d|fd|fg}|d||D]}||d|ddS)NrKmanualBreakCount rowBreaksi?)rrrTr _write_brkr)r5 page_breaksrKrr-s r;rhzWorksheet._write_row_breaks+s++DL99   FK  e   ' K444" , ,G OOGU + + + + +&&&&&r?c||j}|sdSt|}d|fd|fg}|d||D]}||d|ddS)NrKr colBreaksi)rrrTrr r)r5r!rKrr.s r;rizWorksheet._write_col_breaks@s++DL99   FK  e   ' K444" . .G OOGW - - - - +&&&&&r?cDd|fd|fdg}|d|dS)Nr?r)manrbrkrD)r5brk_idbrk_maxrs r;r zWorksheet._write_brkUs3Vnug&6 C  E:.....r?c|j}t|}|sdSd|fg}|d||D]}|||ddS)NrK mergeCells)rrTr_write_merge_cellr)r5rrKr merged_ranges r;r`zWorksheet._write_merge_cells[sz L!!  F&'  L*555( 1 1L  " "< 0 0 0 0 ,'''''r?c|\}}}}t||}t||}|dz|z}d|fg} |d| dS)NrBrL mergeCell)r-rD) r5r-row_minrrow_maxrrFrGrLrs r;r,zWorksheet._write_merge_cellmse/;,'7G#7G44"7G44slV#cl^  K44444r?c t|j}|sdS|d|D]+}t|j|}|D]}|j||}|jrJ|j|r=|j||r*|j||}|jjdkrd|_|jtj tj fvr]|xj dz c_ | |||j ||jd|dg||||-|ddS)Nr r\TrrExternal)r&r rrrr%r)_is_object_link _link_typerURLEXTERNALr_write_hyperlink_externalrrr_write_hyperlink_internalr)r5r r-r r.rr/s r;rczWorksheet._write_hyperlinkszs $/..0011  F L)))  J JGdog6;;==>>H$ J Jog.w7:3$*W"53$*W:Mg:V3:g.w7D~.(::.2+>hlH4E%FFFNNa'NN22$.# -44%s{{}}jA 227GSIIII3 J6 ,'''''r?id_numcXt||}dt|z}d|fd|fg}|jr|d|jf|jr|d|jf|jr|d|jf|d|dS)NrIdrLr:idrjdisplaytooltiprU)r-rArrr4rrrD)r5r&rSr:rrLr_idrs r;r8z#Worksheet._write_hyperlink_externals S))s6{{"clVTN3 ; 9   z3;7 8 8 8   6   y#)4 5 5 5 8 5   y#(3 4 4 4 K44444r?ct||}d|fd|jfg}|jr|d|jf|d|jf|d|dS)NrLrjr?r>rU)r-rrrrrD)r5r&rSrrLrs r;r9z#Worksheet._write_hyperlink_internalsS))clZ$;< 8 5   y#(3 4 4 49ci0111 K44444r?c|jsdSd|jfg}|jrA|d|||ddS|d|dS)NrL autoFilter)rrr_write_autofiltersrrDrs r;r_zWorksheet._write_auto_filters"  Fd123 > :    j 9 9 9  # # % % %   l + + + + +    j 9 9 9 9 9r?c|j\}}t||dzD]@}||jvr |j|}|j|}|||z ||AdSr0)rrrr_write_filter_column)r5col1col2rSrrs r;rDzWorksheet._write_autofilterss( ttax(( G GC$***%c*F*3/K  % %cDj+v F F F F G Gr?cd|fg}|d||dkr||n|||ddS)NcolId filterColumnr)r_write_filters_write_custom_filtersr)r5rWrr_rs r;rFzWorksheet._write_filter_columnsw'(  NJ777 !      ( ( ( (  & &w / / / .)))))r?cd|D}g}t|t|krdg}t|dkr+t|dkr|d|dS|d|t|D]}|||ddS)Nc\g|])}t|dk'|*S)r)rArO)rRfilters r;rTz,Worksheet._write_filters..s4VVVc&kk6G6G6I6IX6U6Uf6U6U6Ur?)rdrrrr_)rTrDrr& _write_filterr)r5r_ non_blanksrrMs r;rLzWorksheet._write_filterssVV7VVV  w<<3z?? * *&J w<<1  ZA!5!5    : 6 6 6 6 6    : 6 6 6$Z00 / / "":....   i ( ( ( ( (r?c<d|fg}|d|dS)Nr<rPr'rcs r;rQzWorksheet._write_filters)cl^  Hj11111r?ct|dkr6|d|j||ddSg}|ddkrdg}ndg}|d|||d|d||d|d|ddS) Nr customFiltersr)andr)rVrrrhrV)rTr_write_custom_filterr)r5rrs r;rMzWorksheet._write_custom_filterss v;;!      0 0 0 %D %v . .   o . . . . .JayA~~(\ (\     < < <  % %fQi ; ; ;  % %fQi ; ; ;   o . . . . .r?cg}dddddddd}|| ||}ntd||dkr|d |f|d |f|d |dS) Nrr}rrrr)rrrhrVr%rrzUnknown operator = rr< customFilter)rrrD)r5rr<rrs r;rWzWorksheet._write_custom_filter/s  #   X  * *HH 1x11 2 2 2 w     z84 5 5 55#,''' NJ77777r?czg}|jsdS|j}|dr|d|df|dr|d|dr|d|ds|d|ds|d |d r|d |d r|d |dr|d|dr|d|dr|d|dr|d|dr|d|dr|d|ds|d|dr|d|dr|d|d r|d!|d"s|d#|d$|dS)%Nrr)rrr)rrr)rrr)rrr) formatCellsrr) formatColumnsrr) formatRowsrr) insertColumnsrr) insertRowsrr)insertHyperlinksrr) deleteColumnsrr) deleteRowsrr)selectLockedCellsrr)rrrM)rCrr) pivotTablesrr)selectUnlockedCellsrsheetProtection)rrrD)r5rrs r;r\z!Worksheet._write_sheet_protectionJs #  F& :  A   z7:+>? @ @ @ 7  ,   l + + + 9  .   n - - -y! .   n - - -{# 0   . / / / > " 2   0 1 1 1 # $ 4   2 3 3 3 = ! 1   / 0 0 0 # $ 4   2 3 3 3 = ! 1   / 0 0 0 & ' 7   5 6 6 6 # $ 4   2 3 3 3 = ! 1   / 0 0 0,- 8   6 7 7 7 6? +   k * * * <  1   / 0 0 0 > " 2   0 1 1 1./ :   8 9 9 9 -z:::::r?c|jdkrdS|d|jD]\}}}|||||ddS)NrprotectedRanges)rrr_write_protected_rangerrs r;r]z!Worksheet._write_protected_rangeszs{  $ ) ) F -...040E J J ,J H  ' ' J I I I I +,,,,,r?cg}|r|d|f|d|f|d|f|d|dS)NrrrvprotectedRangerrD)r5rrrrs r;riz Worksheet._write_protected_rangesw  6   z84 5 5 57J/0006:./// ,j99999r?cl|jsdS|xjdz c_||jdSr0)rr_write_drawingrs r;rkzWorksheet._write_drawingss=|  F ! DN+++++r?c`dt|z}d|fg}|d|dS)Nr<r=rrArD)r5rr@rs r;rnzWorksheet._write_drawings:s:&tn%  Iz22222r?c|jsdS|xjdz c_dt|jz}d|fg}|d|dS)Nrr<r= legacyDrawing)rrrArDr5r@rs r;rlzWorksheet._write_legacy_drawings_|  F !s4>***tn%  OZ88888r?c|jsdS|xjdz c_dt|jz}d|fg}|d|dS)Nrr<r=legacyDrawingHF)rrrArDrss r;rmz"Worksheet._write_legacy_drawing_hfsa"  F !s4>***tn%  -z:::::r?c|jsdS|xjdz c_dt|jz}d|fg}|d|dS)Nrr<r=picture)rrrArDrss r;rnzWorksheet._write_pictures`$  F !s4>***tn%  Iz22222r?c|j}t|}|sdSd|fg}|d||D]}|||ddS)NrKdataValidations)rrTr_write_data_validationr)r5rrKr validations r;rbz!Worksheet._write_data_validationss& K    F&'  -z:::% 4 4J  ' ' 3 3 3 3 +,,,,,r?c<d}g}|dD]=}|dkr|dz }|\}}}}||kr||}}||kr||}}|t||||z }>|dr|d}|ddkrF|d|df|dd kr|d |dfd |vrB|d d kr|d |d dkr|d|dr|d|ds|d|dr|d|dr|dd|vr|d|dfd|vr|d|dfd|vr|d|dfd|vr|d|df|d |f|ddkr|d!|dS|d!|||d"|d#||d#|d!dS)$Nrgrr;rlrfrrrHrNryrrgr) errorStylerr)r}rrn) allowBlankrre) showDropDownrri)showInputMessagerrh)showErrorMessagerrj errorTitlerorrk promptTitlerppromptrdataValidationrlrc)r,rrrDr_write_formula_1_write_formula_2r) r5rrrr row_firstr[row_lastr\s r;rzz Worksheet._write_data_validations< W% H HE{{ 9> 6Y 8X8##)19H8##)19H XiHhGG GEE ;;} % % +M*E : & ( (   vwz':; < < <z"i//!!:wz/B"CDDD 7 " "|$))!!";<<<|$))!!"?@@@ > " 1   / 0 0 0z" 3   1 2 2 2 <  7   5 6 6 6 <  7   5 6 6 6 G # #   |W]-CD E E E g % %   w(@A B B B G # #   }gm.DE F F F g % %   x)AB C C C7E*+++ : & ( (    0* = = = = =    0* = = =  ! !''"2 3 3 3y!-%%gi&8999   . / / / / /r?ct|tr|j|}d|d}nK t|n:#t$r-|dr|d}YnwxYw|d|dS)Nrr(formula1)rGrrr1r4r+r"rr5ris r;rzWorksheet._write_formula_1(s gt $ $ 2$dng.G$'nnnGG 2g 2 2 2%%c**2%nnS11G 2 z733333s84A/.A/c t|n:#t$r-|dr|d}YnwxYw|d|dS)Nr(formula2r1r4r+r"rrs r;rzWorksheet._write_formula_29sv . 'NNNN . . .!!#&& .!..-- . z7333334A A ct|j}|sdS|D]#}|||j|$dSru)r&rr_write_conditional_formatting)r5r cond_ranges r;raz$Worksheet._write_conditional_formatsFsn)..0011  F   J  . .D-j9      r?cd|fg}|d||D]}|||ddS)NrconditionalFormatting)r_write_cf_ruler)r5rparamsrparams r;rz'Worksheet._write_conditional_formattingRsg +,  3Z@@@ ' 'E    & & & & 122222r?c d|dfg}d|vr%|d|d|df|d|df|dr|d|ddkr|d|d f|d |d |vr;d |vr7||d ||d n||d |d dS|ddkrt jd|d r|dt jd|d r|dt jd|d rEt jd|d }|d|df|d |dS|ddkrwd |vr!|d dkr|dd|vr|d|d pd}|d|f|d |dS|ddkr|d |dS|ddkr|d |dS|dd ks$|dd!ks|dd"ks |dd#kr|d|d f|d$|d f|d |||d%|d dS|dd&kre|d&|d f|d |||d%|d dS|dd'ks$|dd(ks|dd)ks |dd*krH|d |||d%|d dS|dd+krB|d || ||d dS|dd,krl|d || ||d-r| ||d dS|dd.krH|d |||d |d dS|dd/krB|d || ||d dSdS)0NrHrYdxfIdrr) stopIfTruerrrrNcfRulerdrcrlrbelow)rrr}) equalAveragerz [123] std devz([123]) std devrIrrr)rkrr)rrrrankrrrrrrrrirrrrrrrrrr) rrr_write_formula_elementrr.rqgrouprD_write_color_scale_write_data_bar_write_data_bar_ext_write_icon_set)r5rrr/rs r;rzWorksheet._write_cf_rule[savf~./ v  &"2">   wx(89 : : ::vj'9:;;; ::n % % 1   / 0 0 0 &>X % %   z6*+=> ? ? ?   * 5 5 5F""yF':':++F9,=>>>++F9,=>>>>++F7O<<<   h ' ' ' ' ' F^~ - -y&"455 7!!"5666y&"455 7!!"5666y&*<== > "3VJ5GHH!!8U[[^^"<===   * 5 5 5 5 5 F^w & &V##z(:c(A(A!!.111f$$!!-000'?(bD   vtn - - -   * 5 5 5 5 5 F^0 0 0   * 5 5 5 5 5 F^~ - -   * 5 5 5 5 5 6Nn , ,f~!222f~--f~++   z6*+=> ? ? ?   vvg7 8 8 8   * 5 5 5  ' 'y(9 : : :   h ' ' ' ' ' F^| + +   |VJ-?@ A A A   * 5 5 5  ' 'y(9 : : :   h ' ' ' ' ' 6N. . .f~!444f~!111f~!444   * 5 5 5  ' 'y(9 : : :   h ' ' ' ' ' F^| + +   * 5 5 5  # #F + + +   h ' ' ' ' ' F^y ( (   * 5 5 5   ( ( (zz,-- 1((000   h ' ' ' ' ' F^| + +   * 5 5 5  ' 'z(: ; ; ;   h ' ' ' ' ' F^y ( (   * 5 5 5   ( ( (   h ' ' ' ' ') (r?c t|n:#t$r-|dr|d}YnwxYw|d|dS)Nr(rirrs r;rz Worksheet._write_formula_elementsv . 'NNNN . . .!!#&& .!..-- . y'22222rcZ|d||d|d|d"||d|d||d|d|d|d |d .|d|d |d|d |ddS) Nrrrrrrrrrrr)r _write_cfvorrRr)r5rs r;rzWorksheet._write_color_scales L))) z*E+,>???   (   U:.k0B C C C z*E+,>??? '5#5#A#A#C#CDDD   )   gu['9'E'E'G'G H H H '5#5#A#A#C#CDDD ,'''''r?cg}d|vr|d|dfd|vr|d|df|dr|d|d|||d|d ||d |d |d |d |ddS)Nr minLengthr maxLengthr showValuerrrrrrrr)rrrrrrRr)r5rrs r;rzWorksheet._write_data_bars  5   {E,,?@ A A A 5   {E,,?@ A A A 99Z  0   . / / / Iz222 z*E+,>??? z*E+,>??? '5#5#A#A#C#CDDD )$$$$$r?ch|jdz}t|jdz}d||fz}||d<|j||d|d|d||d|ddS)Nrz{DA7ABA51-AAAA-BBBB-%04X-%012X}guidextLstz&{B025F937-C7B1-47D3-B67F-A62EFF666E3E}zx14:idext)rwrTrrr _write_extrr)r5rworksheet_countdata_bar_countrs r;rzWorksheet._write_data_bar_exts*q.T011A50O^3TTf  ""5))) H%%% @AAA x... %    (#####r?cg}|ddkr d|dfg}|dr|d|dr|d|d|t|dD]+}||d |d |d ,|ddS) Nrrrrrr)rirrrHrlrN)rrrreversedrr)r5rricons r;rzWorksheet._write_icon_sets   "2 2 2$eL&9:;J 99\ " " 0   . / / / 99_ % % .   n - - - Iz222U7^,, L LD   T&\4=$z:J K K K K )$$$$$r?cd|fg}||d|f|r|d|d|dS)NrHr<)gtercfvorl)r5cf_typer<rNrs r;rzWorksheet._write_cfvo(sdw'( ?   ucl + + +  *   j ) ) ) FJ/////r?c2|||dSrur'res r;rzWorksheet._write_color4s D*-----r?c.|jD] }|j| dSru)r_write_selection)r5 selections r;rzWorksheet._write_selections8s0 . .I !D !9 - - - . .r?cg}|r|d|f|r|d|f|r|d|f|d|dS)Nr activeCellrrrl)r5rrrrs r;rzWorksheet._write_selection=s  .   vtn - - -  ;   |[9 : : :  0   w. / / / K44444r?c`|j}|sdS|ddkr |j|dS|j|dS)NrVr)r_write_split_panes_write_freeze_panes)r5rs r;rzWorksheet._write_panesLsO   F 8q== #D #U + + + + $D $e , , , ,r?c@g}|}|}t||} d} d} d} d} |jr|jd\}} } g|_|r||rzd} t|d}td|}|jd||g|jd||g|jd| | gnA|r d} |jd| | gnd} |jd| | g|dkrd} n |dkrd} nd } |r|d |f|r|d |f|d | f|d | f|d| f|d|dS)Nrgr bottomRighttopRight bottomLeftfrozenr frozenSplitrDxSplitySplitr activePanestater)r-rrrD)r5r&rSrrrry_splitx_splitrrrrrrUrow_cellcol_cells r;rzWorksheet._write_freeze_panesXs )'8<<    ? !&*oa&8 #Q U DO  G3 G'K(a00H(C00H O " "J(#C D D D O " "L(H#E F F F O " "M;#F G G G G  G$K O " "J U#C D D D D'K O " "L+u#E F F F >>EE !^^!EEE  3   x1 2 2 2  3   x1 2 2 2=-8999<56667E*+++ FJ/////r?cg}d}d}d} d} |} |} |jr|jd\}} } g|_d}| rtd| zdz} | r|| } ||krB||kr>h#oo#3" 4r 99::G3'C-2!5!9A!=!BBCCH)'8<<  "'K!E  G3 G'K(!44H(H55H O " "J(#C D D D O " "L(H#E F F F O " "M;#F G G G G  G$K O " "J U#C D D D D'K O " "L+u#E F F F  =   xG):):; < < <  =   xG):):; < < <=-8999  ;   |[9 : : : FJ/////r?cd}d}|dkrt|||zzdz}nt||zdz|z}|dzdz }|dz}|dz}|S) Nrr%rrCrhrVrnr)r3)r5rrrrpointstwipss r;rz"Worksheet._calculate_x_split_widths} 199/G"; 2 2 2 2 ,'''''r?c`dt|z}d|fg}|d|dS)Nr<r= tablePartrprss r;rzWorksheet._write_table_part sFs4yy    K44444r?ct|j}t|j}|s|sdS|d|r||r||ddS)Nr)rTrrr_write_ext_list_data_bars_write_ext_list_sparklinesr)r5 has_data_barshas_sparkliness r;rpzWorksheet._write_ext_listsD/00 T_-- ^  F H%%%  -  * * , , ,  .  + + - - - (#####r?c|d|d|jD]}|||d|ddS)Nz&{78C0D931-6437-407d-A8EE-F0AAD7539E65}zx14:conditionalFormattingsr)rrr"_write_conditional_formatting_2010r)r5rs r;rz#Worksheet._write_ext_list_data_bars*s @AAA 8999+ > >H  3 3H = = = = 6777 %     r?cd}d|fg}|d|||||||d|d||d|d|ds||d |d s||d |ds#|d s||d |ddkr||d|d|d| d|d|ddS)N3http://schemas.microsoft.com/office/excel/2006/mainxmlns:xmzx14:conditionalFormattingrrrrrrrrrrrrrr x14:dataBar x14:cfRulexm:sqrefr) r_write_x14_cf_rule_write_x14_data_bar_write_x14_cfvo_write_x14_border_color_write_x14_negative_fill_color _write_x14_negative_border_color_write_x14_axis_colorrr)r5rxmlns_xmrs r;rz,Worksheet._write_conditional_formatting_20108sH!8,-  7DDD )))   *** Xn5x 7LMMM Xn5x 7LMMM( G  ( (2D)E F F F12 P  / /9M0N O O O) Y=> Y  1 1(;V2W X X X ' (F 2 2  & &x0@'A B B B -((( ,''' z8G+<=== 566666r?cVd}|d}d|fd|fg}|d|dS)NrrrHr?rr)r5r rule_typerrs r;rzWorksheet._write_x14_cf_rulees@ y)D$<8  L*55555r?cJd}d}d|fd|fg}|ds|d|dr|d|d d kr|d |d d kr|d |dr|d|ds|ds|d|ddkr|d|ddkr|d|d|dS)Nrrlrrr)borderrr)gradientrrr)r leftToRightr)rrr)negativeBarColorSameAsPositiverr)$negativeBarBorderColorSameAsPositiverrmiddle) axisPositionrrr)rrrr)rr)r5rrrrs r;rzWorksheet._write_x14_data_barmsu  * % * % ( -   m , , , K  /   o . . . O $ . .   : ; ; ; O $ / /   : ; ; ; - . E   C D D D) K=> K   I J J J ' (H 4 4   8 9 9 9 ' (F 2 2   6 7 7 7 M:66666r?cd|fg}|dvr|d|dS|d||d||ddS)NrH)rrrrzx14:cfvoxm:f)rDrrr)r5rrlrs r;rzWorksheet._write_x14_cfvos}y)* < < <    J 7 7 7 7 7    J 7 7 7  " "65 1 1 1   j ) ) ) ) )r?cV|d|dS)Nzx14:borderColorrrRrs r;rz!Worksheet._write_x14_border_colors+ +U->->-@-@AAAAAr?cV|d|dS)Nzx14:negativeFillColorrDrRrs r;rz(Worksheet._write_x14_negative_fill_colors+ 3U5F5F5H5HIIIIIr?cV|d|dS)Nzx14:negativeBorderColorrrs r;rz*Worksheet._write_x14_negative_border_colors+ 5u7H7H7J7JKKKKKr?cV|d|dS)Nz x14:axisColorrrs r;rzWorksheet._write_x14_axis_colors* OU->->-@-@AAAAAr?cF|d|t|jD]7}||||d||d|||d| |d| |d| |d| |d|d r| d |d |||d 9|d |d dS)Nz&{05C60535-1F16-4fd2-B633-F4F36F0B64E0}rwryrxrsrprnrlrkrx14:sparklineGroupx14:sparklineGroupsr)r_write_sparkline_groupsrr_write_sparkline_group_write_color_series_write_color_negative_write_color_axis_write_color_markers_write_color_first_write_color_last_write_color_high_write_color_lowr_write_sparklinesr)r5rs r;rz$Worksheet._write_ext_list_sparkliness @AAA $$&&&"$/22! 4! 4I  ' ' 2 2 2  $ $Y~%> ? ? ?  & &y1A'B C C C  " " $ $ $  % %i&@ A A A  # #Im$< = = =  " "9\#: ; ; ;  " "9\#: ; ; ;  ! !)K"8 9 9 9% G&&vy/EFFF  " "9 - - -   2 3 3 3 3 /000 %     r?cn|dt|dD]t}|d|}|d|}|d|d||d||du|ddS)Nzx14:sparklinesrKrrez x14:sparklinerr)rrrr)r5rr_rrjs r;rzWorksheet._write_sparkliness ,---y)** / /A#H-a0K -a0H    0 0 0  " "6; 7 7 7  " ":x 8 8 8   o . . . . *+++++r?cPd}|dz}d|fd|fg}|d|dS)Nz$http://schemas.microsoft.com/office/zspreadsheetml/2009/9/mainz xmlns:x14urirr)r5rrz xmlns_x14rs r;rzWorksheet._write_extsH788 ) $ CL E:.....r?c@d}d|fg}|d|dS)Nrrr r)r5rrs r;r z!Worksheet._write_sparkline_groupss1H!8,-  1:>>>>>r?c||d}g}|d4|ddkrd|d<n"|d|dfd|d<|d4|ddkrd|d<n"|d |dfd|d<|d d kr|d |d f|d r|d |d f|dr|d|r|d|f|dr|d|dr|d|dr|d|dr|d|dr|d|dr|d|dr|d|dr|d |dr|d!|df|dr|d"|df|d#r|d$|d%|dS)&Nrrrcust_max manualMaxrvrcust_min manualMinrHr{rg lineWeightrk)dateAxisrdisplayEmptyCellsAsrh)rhrr)rrr)rrr)rrr)rrr)rrrf) displayXAxisrr) displayHiddenr minAxisType maxAxisTyperirr)rrr)r5rrrs r;r z Worksheet._write_sparkline_group s]0 G$$ ;;u   )u~((&- ##!!;"?@@@&. # ;;u   )u~((&- ##!!;"?@@@&. # 6?f $ $   vwv7 8 8 8 ;;x  A   |WX->? @ @ @ ;;{ # # /   o . . .  >   4e< = = = ;;y ! ! .   n - - - ;;v   +   k * * * ;;u   *   j ) ) ) ;;w   ,   l + + + ;;v   +   k * * * ;;z " " /   o . . . ;;v   3   1 2 2 2 ;;x  4   2 3 3 3 ;;z " " D   }gj.AB C C C ;;z " " D   }gj.AB C C C ;;y ! ! 2   0 1 1 1 0*=====r?c^|r*|||dSdSrur)r5tagrs r;_write_spark_colorzWorksheet._write_spark_color[ s<  8   c5#4#4#6#6 7 7 7 7 7 8 8r?c2|d|dS)Nzx14:colorSeriesr(rs r;r zWorksheet._write_color_series` s  1599999r?c2|d|dS)Nzx14:colorNegativer*rs r;r zWorksheet._write_color_negatived s  3U;;;;;r?cL|dtddS)Nz x14:colorAxisr)r(rrs r;rzWorksheet._write_color_axish s& y1A1ABBBBBr?c2|d|dS)Nzx14:colorMarkersr*rs r;rzWorksheet._write_color_markersl s  2E:::::r?c2|d|dS)Nzx14:colorFirstr*rs r;rzWorksheet._write_color_firstp s  0%88888r?c2|d|dS)Nz x14:colorLastr*rs r;rzWorksheet._write_color_lastt  77777r?c2|d|dS)Nz x14:colorHighr*rs r;rzWorksheet._write_color_highx r0r?c2|d|dS)Nz x14:colorLowr*rs r;rzWorksheet._write_color_low| s 66666r?c:ddg}|d|dS)N)fontId0)rH noConversion phoneticPrr'rs r;r^zWorksheet._write_phonetic_pr s/  $ L*55555r?c|jsdS|d|jdr#|jd}|d||jdr#|jd}|d||jdr#|jd}|d||jdr#|jd}|d ||jd r#|jd }|d ||jd r#|jd }|d ||jdr#|jd}|d||jdr#|jd}|d||jdr#|jd}|d||ddS)N ignoredErrorsr?numberStoredAsTextr7 evalErrorr9rir8 formulaRanger:unlockedFormular=emptyCellReferencer>listDataValidationr;calculatedColumnr<twoDigitTextYear)r rr_write_ignored_errorr)r5 ignored_ranges r;rjzWorksheet._write_ignored_errors sy"  F O,,,   " "#: ; ; K /0GHM  % %&:M J J J   " "< 0 0 B / =M  % %k= A A A   " "#4 5 5 @ /0ABM  % %i ? ? ?   " "? 3 3 E /@M  % %nm D D D   " "#5 6 6 H /0BCM  % %&7 G G G   " "#9 : : K /0FGM  % %&:M J J J   " "#9 : : K /0FGM  % %&:M J J J   " "#6 7 7 I /0CDM  % %&8- H H H   " "#8 9 9 I /0EFM  % %&8- H H H /*****r?cBd|f|dfg}|d|dS)Nrr ignoredErrorr')r5rgrCrs r;rBzWorksheet._write_ignored_error s8m $ O NJ77777r?)rdNrur)F)Nrr{)NNN)r)NF)rr)rrrr)NNr)NN)rl)rgN)r)ririrjrj)rgNN)FF)r(r) __module__ __qualname____doc__rur3r6r>rrr r<r:rArr"rPr3r1rr]r2rfr*rmr,rLr|rrrt staticmethodrrsrBrrFr?rr@rr0rrrrrr rrrrrrrrrrrrrrrr r rWrrr7r;r>rArGrMr]rrYrr*rcrrrrrrrrrrrrrrrrrrrrrrrr rrrrrrrr!r#r&r)r+r/r2r5r@rQrrrSrrJrrWrXrrrrrrrrrrrrrr=rrrrr rrrQrr'rr.rrrrJrLrNrgrirrTrVrWrrXrYrrZr[rerfrdrgrrrrVrrrrrrrUrrrrhrir r`r,rcrr8r9r_rDrFrLrQrMrWr\r]rirkrnrlrmrnrbrzrrrarrrrrrrrrrrrrrrrorrprrrrrrrrrrrrr r r(r r rrrrrrr^rjrB __classcell__)r%s@r;rcrcs$Y$Y$Y$Y$Y$Y$x$3$33$3$3$3$3L,,3,%8K2L,,,,&SJ#SJCSJSJSJSJjOSAAA A*-AFv>NCCCC(#Cs6 )- $!HH HH H f% H  Hc]HHHH<KO;;; ; ;;;;z88 8).sF{);8 & '88882wcwwswwwwr 7 7 7 7HL 5=f5E wqz3 0HL 5=f5E wqz3 0 -1 ## ##c7E)* # $sCx.) #  ####J -1 00 00c7E)* 0 $sCx.) 0  0000dQU333 3(+36>tCH~6N3 3333jTXFFF F).F9A$sCx.9QF  FFFFPTX!!! !+.!9A$sCx.9Q!  !!!!F % % % %JOC%/0BF 6 & & & &   5555$"  4444$ "&(,,0 @@@@ @ f% @ $sCx.) @ @@@@D "&(,,0 QQQQ Q f% Q $sCx.) Q QQQQ:SNSNSNSNSNSNSNp#'(,,0 >> >>f% > $sCx.) >  >>>>F#'(,,0 ?? ??f% ? $sCx.) ?  ????6HM((uo(@D( ((((2)-PPPP P  P  Pf%P PPPPd)E)E),)E8;)EGJ)E )E)E)E)EV:::::::x(c(DI($((((T-1 GGGG G  G $sCx.) G  GGGGR-1 {{{{ {  { $sCx.) {  {{{{z-1 ZZZZ Z  Z $sCx.) Z  ZZZZx FJ +3DcN+C  B"7"7),"78;"7GJ"7 "7"7"7"7H99S939t9999& $$$$ $  $  $$$$8 "&"& >> >># > 3- >  > >>>>: "&"& 66 6 6# 6 3- 6  6666.S4$ % % % %     25e#4 2 2 2 2 2GK3(3(3(+3DcN+C3( 3(3(3(3(p%)"& %%%SM%3- % %%%%NFJ### #+3DcN+C# ####JQUCCC C+/C>Fv>NCCCCJ ' ' ' ' ' ' ' '  ''"2 4         +E'$-*<$= +$ + + + +          $$$$ $  $  $$$$4RVO'O'O')1$sCx.)AO' O'O'O'O'dRVO'O'O')1$sCx.)AO' O'O'O'O'b77S7HSM7T77774777x}7PT77774&&WW%5&d&&&&0 * * * * $ $ $ $  ), 8; GJ      D ' ' ' ''#'s't''''$ % % % % % %'S'T'''', ' ' ' ' tCy T     tCy T    >>#>$>>>>"((Xd38n%=(QV((((^,',',','\bbbbJ@E!!! ! !!!!FYYY&&&P4B===:U!U!U!nC"  (4S>2J    L4L4L4 L4  L4L4L4L4\C4C4C4C4J....$    8 8 8 8 t V V VH\V\V\V|S<S*   &z&333j    2:GGGG333j( $ $ $ $((((5'5'5'5'n 5 5 5 5==== 6666++++ ''''====J5555(!9!9!9!9F((((99999999v99990&"&"&"&"PB/B/B/B/H++++++++0 7 7 7 7L5L5L5L5\88882<<<<(99999999&Q&Q&Q&QP#####J))))V5=5=c5=t5=5=5=5=n@@C@D@@@@t#st#t#tt#t#t#t#l++++9999 777787777;;;;5555$''''*''''*//// (((($ 5 5 5 50(0(0(0(d55 5*-5475 5555( 5S 5s 5 5 5 5 5 5::::"GGGG" * * * *))))(2222 ////.88886.;.;.;.;` - - - - : : : :,,,,3333 9 9 9 9 ; ; ; ; 3 3 3 3----$K0K0K0K0Z4444" 4 4 4 4    3333j(j(j(j(X 3 3 3 3((((*%%%%.$$$$$%%%%, 0 0 0 0 0........ 5 5 5 5 - - - -8080 80 80808080tE0cE0E0dE0E0E0E0N.((((2 5 5 5 5$$$$& ! ! ! !+7+7+7+7Z6666%7%7%7%7N * * * *BBBBJJJJLLLLBBBB,!,!,!,!\,,,," / / / /????W>W>W>W>r8888 ::::<<<<CCCC;;;;99998888888877776666++++++++Z88888888r?rc)SrBrarKr.rI collectionsrrrtr fractionsr functoolsrior r r r typingr rrrrrwarningsrxlsxwriter.chartrxlsxwriter.colorrxlsxwriter.commentsrxlsxwriter.imagerxlsxwriter.urlrrxlsxwriter.vmlrrgrrrrr exceptionsr r!rYr"rr#utilityr$r%r&r'r(r)r*r+r,r-r.r/rVERBOSErpr>rLrWrhrrcrWrrurrrrcrQr?r;rZs //////// <<<<<<<<<<<<<<<<""""""""""""++++++""""""((((((((%%%%%%7777777777<<<<<<<<                          !  bj<J?  P0@@GX..G%;<<*X'788*X'788:i):;;:i)ABBJz+;<< j/KLL" :t8t8t8t8t8 #t8t8t8t8t8r?