o ]oiícã@sddlZddlZddlZddlZddlZddlmZddlmZddlm Z ddl m Z ddl m Z ddlmZddlmZdd lmZdd lmZd d lmZd d lmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlm Z d dlm!Z!d dlm"Z"d dlm#Z#d dlm$Z$d dlm%Z%d dlm&Z&d dlm'Z'd dlm(Z(d dlm)Z)d dlm*Z*d dl+m,Z,d dl+m-Z-e .d ej/¡Z0d!d"„Z1d#d$„Z2d%d&„Z3ed'd(ƒZ4ed)d*ƒZ5ed+d,ƒZ6ed-d.ƒZ7ed/d0ƒZ8ed1d*ƒZ9ed2d3ƒZ:ed4d5ƒZ;ed6d7ƒZ.cell_wrapperr©r+r.r,r*r-Úconvert_cell_argsXs r0cr")zo Decorator function to convert A1 notation in range method calls to the default row/col notation. c s²z |r t|dƒWnCtyMd|dvr-|d d¡\}}t|ƒ\}}t|ƒ\}}n t|dƒ\}}||}}||||g} |  |dd…¡| }Ynwˆ|g|¢Ri|¤ŽS)Nrú:r ©r$r%ÚsplitrÚextend) r&r'r(Úcell_1Úcell_2Zrow_1Úcol_1Zrow_2Úcol_2r)r*r,r-r.ws  €     ôz(convert_range_args..cell_wrapperrr/r,r*r-Úconvert_range_argspsr9cr")zq Decorator function to convert A1 notation in columns method calls to the default row/col notation. c sz |r t|dƒWn2ty<dd„|d d¡Dƒ\}}t|ƒ\}}t|ƒ\}}||g}| |dd…¡|}Ynwˆ|g|¢Ri|¤ŽS)NrcSsg|]}|d‘qS)Ú1r,)Ú.0Úcolr,r,r-Ú Ÿsz?convert_column_args..column_wrapper..r1r r2) r&r'r(r5r6Ú_r7r8r)r*r,r-Úcolumn_wrapper—s €   ù z+convert_column_args..column_wrapperr)r+r?r,r*r-Úconvert_column_argssr@ÚStringzstring, formatÚNumberznumber, formatÚBlankÚformatÚBooleanzboolean, formatÚFormulazformula, format, valueÚDatetimeÚ ArrayFormulaz$formula, format, value, range, atypeÚ RichStringzstring, format, raw_stringÚErrorzerror, format, valuecs¶ eZdZdZ‡fdd„Zdd„Zedd„ƒZdd „ZedÛd d „ƒZ dÛd d„Z edÛdd„ƒZ dÛdd„Z edÛdd„ƒZ dÛdd„ZedÜdd„ƒZdÜdd„Ze dÜdd„ƒZe dÜdd„ƒZdÝd!d"„Z  #dÞd$d%„ZedÛd&d'„ƒZdÛd(d)„ZedÛd*d+„ƒZdÛd,d-„Zedßd.d/„ƒZdßd0d1„Zed2d3„ƒZd4d5„Zd6d7„ZedÛd8d9„ƒZedÛd:d;„ƒZ edÛdd?„ƒZ"edÛd@dA„ƒZ#edÛdBdC„ƒZ$edÛdDdE„ƒZ%dFdG„Z&dÝdHdI„Z'dJdK„Z(dLdM„Z)dNdO„Z*dPdQ„Z+dRdS„Z,dTdU„Z-dVdW„Z.e/ dßdXdY„ƒZ0e/ dßdZd[„ƒZ1d\d]„Z2dßd^d_„Z3dßd`da„Z4dàdbdc„Z5e dÛddde„ƒZ6edfdg„ƒZ7dhdi„Z8djdk„Z9edÛdldm„ƒZ:e dÛdndo„ƒZ;edÛdpdq„ƒZedádvdw„ƒZ? dâdydz„Z@edãd{d|„ƒZAedäd}d~„ƒZBdåd€d„ZCd‚dƒ„ZDd„d…„ZEd†d‡„ZFdæd‰dŠ„ZGdäd‹dŒ„ZHedÛddŽ„ƒZIdd„ZJd‘d’„ZKdçd“d”„ZLdçd•d–„ZMd—d˜„ZNd™dš„ZOd›dœ„ZPdèdŸd „ZQdéd¡d¢„ZRdéd£d¤„ZSdÛd¥d¦„ZTe/dÛd§d¨„ƒZUdçd©dª„ZVd«d¬„ZWd­d®„ZXed¯d°„ƒZYd±d²„ZZd³d´„Z[dµd¶„Z\d·d¸„Z]d¹dº„Z^d»d¼„Z_d½d¾„Z`dÛd¿dÀ„ZadÛdÁd„ZbdÃdÄ„ZcdÅdÆ„ZddêdÇdÈ„ZedÉdÊ„ZfdËdÌ„ZgdÍd΄ZhdÏdЄZidÑdÒ„ZjdÓdÔ„ZkdÕdÖ„Zld×dØ„ZmdÙdÚ„ZndÛdÜ„ZodÝdÞ„Zpdßdà„Zqdádâ„Zrdãdä„Zsdëdådæ„Ztdëdçdè„Zudédê„Zvdëdì„Zwdídî„Zxdïdð„Zydñdò„Zzdódô„Z{dõdö„Z|d÷dø„Z}dùdú„Z~dûdü„Zdýdþ„Z€dÿd„ZdÛdd„Z‚dÛdd„Zƒdd„Z„dd„Z…d d „Z†d d „Z‡d d„Zˆdd„Z‰dd„ZŠdÛdd„Z‹dd„ZŒdd„Zdd„ZŽdd„Zdd„Zdd „Z‘d!d"„Z’d#d$„Z“d%d&„Z”d'd(„Z•d)d*„Z–d+d,„Z—d-d.„Z˜d/d0„Z™d1d2„Zšd3d4„Z›dëd5d6„Zœd7d8„Zdàd9d:„ZždÛd;d<„ZŸd=d>„Z d?d@„Z¡dAdB„Z¢dCdD„Z£dEdF„Z¤dGdH„Z¥dIdJ„Z¦dKdL„Z§dMdN„Z¨dOdP„Z©dQdR„ZªdSdT„Z«dUdV„Z¬ dßdWdX„Z­ dßdYdZ„Z®d[d\„Z¯d]d^„Z°d_d`„Z±dadb„Z²dcdd„Z³dedf„Z´dgdh„Zµdidj„Z¶dkdl„Z·dmdn„Z¸dodp„Z¹dqdr„Zºdsdt„Z»dudv„Z¼dwdx„Z½dydz„Z¾d{d|„Z¿d}d~„ZÀdd€„ZÁdd‚„ZÂdƒd„„ZÃd…d†„ZÄd‡dˆ„ZÅd‰dŠ„ZÆd‹dŒ„ZÇddŽ„ZÈdd„ZÉdÛd‘d’„ZÊd“d”„ZËd•d–„ZÌd—d˜„ZÍd™dš„ZÎd›dœ„ZÏddž„ZÐdŸd „ZÑd¡d¢„ZÒd£d¤„ZÓd¥d¦„ZÔd§d¨„ZÕd©dª„ZÖd«d¬„Z×d­d®„ZØd¯d°„ZÙd±d²„ZÚd³d´„ZÛdµd¶„ZÜd·d¸„ZÝd¹dº„ZÞd»d¼„Zßd½d¾„Zàd¿dÀ„ZádÁd„ZâdÃdÄ„ZãdÅdÆ„ZädÇdÈ„ZådÉdÊ„ZædËdÌ„ZçdÍd΄ZèdÏdЄZédÑdÒ„ZêdÓdÔ„ZëdÕdÖ„Zìd×dØ„ZídÙdÚ„Zî‡ZïS(ìÚ Worksheetz= A class for writing the Excel XLSX Worksheet file. cs<tt|ƒ ¡d|_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 |_0d |_1d |_2d |_3d|_4d|_5d|_6d|_7d|_8d|_9d|_:d|_;d|_d|_?d|_@g|_Ag|_Bi|_Cg|_Dd|_Ei|_FtGtHƒ|_Id|_Jd |_Kd|_Ld|_Md |_Nd|_Od|_Pd|_Qd|_Rd |_Sd |_Td |_Ud|_Vd|_Wd|_Xd|_Yd|_Zd|_[d|_\d|_]i|_^g|__tGtHƒ|_`g|_ai|_bi|_ci|_dd|_ed|_fd|_gtGtHƒ|_hg|_id|_jd|_kd|_lg|_md|_nd|_od|_pg|_qd|_ri|_si|_ti|_ui|_vd|_wd|_xd |_yd|_zd|_{g|_|g|_}g|_~g|_g|_€g|_g|_‚g|_ƒg|_„g|_…g|_†g|_‡g|_ˆg|_‰i|_Šd|_‹i|_Œd|_i|_Žd|_d|_d|_‘d|_’d|_“g|_”i|_•g|_–d|_—d |_˜d|_™d|_šd|_›tGtHƒ|_œd|_d |_žd|_Ÿd |_ d|_¡d|_¢d|_£d|_¤d|_¥d|_¦d|_§d|_¨d|_ld|_¥d|_¦d|_©d|_ªd|_«i|_¬d|_­d|_®d|_¯d|_°dS)z Constructor. NrFi×ii@éÿÚér Tçffffffæ?çè?ç333333Ó?édééç\Âõ(Ü @é@éDéi)±ÚsuperrKÚ__init__ÚnameÚindexÚ str_tableÚpaletteÚconstant_memoryÚtmpdirÚ is_chartsheetZ ext_sheetsZ fileclosedÚ excel_versionÚexcel2003_styleÚ xls_rowmaxÚ xls_colmaxÚ xls_strmaxÚ dim_rowminÚ dim_rowmaxÚ dim_colminÚ dim_colmaxÚcol_infoÚ selectionsÚhiddenZactiveÚ tab_colorÚ top_left_cellÚpanesÚ active_paneÚselectedÚpage_setup_changedÚ paper_sizeÚ orientationÚprint_options_changedÚhcenterÚvcenterÚprint_gridlinesÚscreen_gridlinesÚ print_headersÚrow_col_headersÚheader_footer_changedÚheaderÚfooterÚheader_footer_alignsÚheader_footer_scalesÚ header_imagesÚ footer_imagesÚheader_images_listÚ margin_leftÚ margin_rightÚ margin_topÚ margin_bottomÚ margin_headerÚ margin_footerÚrepeat_row_rangeÚrepeat_col_rangeÚprint_area_rangeÚ page_orderÚ black_whiteZ draft_qualityZprint_commentsÚ page_startÚfit_pageÚ fit_widthÚ fit_heightÚhbreaksÚvbreaksÚprotect_optionsÚprotected_rangesÚnum_protected_rangesZset_colsrÚdictÚset_rowsÚzoomÚzoom_scale_normalÚ print_scaleÚis_right_to_leftÚ show_zerosZ leading_zerosÚoutline_row_levelÚoutline_col_levelÚ outline_styleÚ outline_belowÚ outline_rightÚ outline_onÚoutline_changedÚoriginal_row_heightÚdefault_row_heightÚdefault_row_pixelsÚdefault_col_widthÚdefault_col_pixelsÚdefault_date_pixelsÚdefault_row_zeroedÚnamesZ write_matchÚtableÚmergeÚ merged_cellsÚ table_cellsÚ row_spansÚhas_vmlÚhas_header_vmlÚ has_commentsÚcommentsÚ comments_listÚcomments_authorÚcomments_visibleÚ vml_shape_idÚ buttons_listÚ vml_header_idÚautofilter_areaÚautofilter_refÚ filter_rangeÚ filter_onÚ filter_colsÚ filter_typeÚ filter_cellsÚ row_sizesÚcol_size_changedÚrow_size_changedZ last_shape_idÚ rel_countÚ hlink_countÚ hlink_refsÚexternal_hyper_linksÚexternal_drawing_linksÚexternal_comment_linksÚexternal_vml_linksÚexternal_table_linksÚexternal_background_linksÚ drawing_linksÚvml_drawing_linksÚchartsÚimagesÚtablesÚ sparklinesÚshapesZ shape_hashÚdrawingÚ drawing_relsÚdrawing_rels_idÚvml_drawing_relsÚvml_drawing_rels_idÚbackground_imageÚbackground_bytesÚrstringÚ previous_rowÚ validationsÚ cond_formatsÚdata_bars_2010Úuse_data_bars_2010Ú dxf_priorityÚ page_viewÚ vba_codenameÚ date_1904Ú hyperlinksÚstrings_to_numbersÚstrings_to_urlsÚnan_inf_to_errorsÚstrings_to_formulasÚdefault_date_formatÚdefault_url_formatÚremove_timezoneÚmax_url_lengthÚrow_data_filenameÚ row_data_fhÚworksheet_metaÚ vml_data_idÚrow_data_fh_closedÚ vertical_dpiÚhorizontal_dpiÚwrite_handlersÚignored_errorsÚhas_dynamic_arraysÚuse_future_functionsÚignore_write_string©r&©Ú __class__r,r-rZÎs`     zWorksheet.__init__cGs2|dkr|j||g|¢RŽS|jr | d¡r |j||g|¢RŽS| d¡r4| d¡r4|j||g|¢RŽSd|vrW|jrWt d|¡sMt d|¡sMt d|¡rW|j||g|¢RŽS|j rz!t |ƒ}|j sjt |ƒszt |ƒsz|j|||g|d d…¢RŽWSWn ty„Ynw|j||g|¢RŽS|j||g|¢RŽS) NrMú=z{=Ú}r1ú(ftp|http)s?://úmailto:z(in|ex)ternal:r )Ú _write_blankríÚ startswithÚ_write_formulaÚendswithrëÚreÚmatchÚ _write_urlrêÚfloatrìr r Ú _write_numberr%Ú _write_string)r&ÚtokenÚrowr<r'Úfr,r,r-Ú_write_token_as_string¨s6ÿ ý ü û € þz Worksheet._write_token_as_stringcGó|j||g|¢RŽS)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. ©Ú_write©r&rr<r'r,r,r-ÚwriteÍszWorksheet.writec Gs|stdƒ‚|d}|j}||jvr(|j|}||||g|¢RŽ}|dur&n|S|dur6|j||g|¢RŽS|turD|j||g|¢RŽS|tttt fvrV|j ||g|¢RŽS|t ure|j |||g|¢RŽS|t j t jt jt jfvr{|j||g|¢RŽSt|tttt fƒrŽ|j ||g|¢RŽSt|t ƒrž|j |||g|¢RŽSt|tƒr­|j||g|¢RŽSt|ƒr»|j||g|¢RŽSzt|ƒ}|j |||g|dd…¢RŽWStyØYntyætdt|ƒƒ‚wzt |ƒ|j||g|¢RŽWStytdt|ƒƒ‚w)Nz,write() takes at least 4 arguments (3 given)rr zUnsupported type %s in write())Ú TypeErrorrrùrÚboolÚ_write_booleanr r$rrr ÚstrrÚdatetimeÚdateÚtimeÚ timedeltaÚ_write_datetimeÚ isinstancerr%Útyper) r&rr<r'rÚ token_typeZ write_handlerZfunction_returnrr,r,r-rás^  ü     ÿÿzWorksheet._writeNcCó| ||||¡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. )r)r&rr<ÚstringÚ cell_formatr,r,r-Ú write_string1ózWorksheet.write_stringcCs~d}| ||¡r dSt|ƒ|jkr|d|j…}d}|js$|j |¡}n|}|jr3||jkr3| |¡t||ƒ|j ||<|S©Nréÿÿÿÿéþÿÿÿ) Ú_check_dimensionsÚlenrfr_r]Ú_get_shared_string_indexràÚ_write_single_rowÚcell_string_tupler¯)r&rr<r%r&Ú str_errorÚ string_indexr,r,r-rEs  zWorksheet._write_stringcCr$)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. )r ©r&rr<Únumberr&r,r,r-Ú write_number`ózWorksheet.write_numbercCs¶t|ƒst|ƒr:|jr6t|ƒr| ||d|d¡S|tjkr&| ||d|d¡S|tj kr5| ||d|d¡Sntdƒ‚| ||¡rBdS|jrO||j krO|  |¡t ||ƒ|j ||<dS)Nú#NUM!z1/0ú#DIV/0!z-1/0zUNAN/INF not supported in write_number() without 'nan_inf_to_errors' Workbook() optionr*r) r r rìrÚmathÚinfrr,r_ràr/Úcell_number_tupler¯r3r,r,r-r ss$  ÿÿ  zWorksheet._write_numbercCr$)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©r&rr<Úblankr&r,r,r-Ú write_blankr(zWorksheet.write_blankcCsL|durdS| ||¡rdS|jr||jkr| |¡t|ƒ|j||<dS)Nrr*)r,r_ràr/Úcell_blank_tupler¯r<r,r,r-r£s  zWorksheet._write_blankrcCs| |||||¡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©r&rr<Úformular&Úvaluer,r,r-Ú write_formulaµszWorksheet.write_formulac Cs´| ||¡rdS|dus|dkrtdƒdSt |¡r&| |||||||¡S| d¡r;| d¡r;| |||||||¡S| |¡}|j rM||j krM|  |¡t |||ƒ|j ||<dS)Nr*rMzFormula can't be None or emptyÚ{rr)r,r Úre_dynamic_functionÚsearchÚwrite_dynamic_array_formularrÚ_write_array_formulaÚ_prepare_formular_ràr/Úcell_formula_tupler¯r@r,r,r-rËs$  ÿÿ  zWorksheet._write_formulac Cs8t |¡r| |||||||¡S| |||||||d¡S)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)rErFrGrH)r&Ú first_rowÚ first_colÚlast_rowÚlast_colrAr&rBr,r,r-Úwrite_array_formulaës ÿøzWorksheet.write_array_formulac Cs*| |||||||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)rHrû) r&rLrMrNrOrAr&rBÚerrorr,r,r-rGsø z%Worksheet.write_dynamic_array_formulaFcCsT | d¡r |dd…}| d¡r|dd…}| d¡r!|dd…}d|vr'|St dd|¡}t d d |¡}t d d |¡}t d d|¡}t dd|¡}t dd|¡}t dd|¡}t dd|¡}t dd|¡}t dd|¡}t dd|¡}t dd|¡}t dd |¡}t d!d"|¡}t d#d$|¡}t d%d&|¡}t d'd(|¡}t d)d*|¡}t d+d,|¡}t d-d.|¡}t d/d0|¡}t d1d2|¡}t d3d4|¡}t d5d6|¡}t d7d8|¡}t d9d:|¡}t d;d<|¡}t d=d>|¡}t d?d@|¡}|jsù|sù|St dAdB|¡}t dCdD|¡}t dEdF|¡}t dGdH|¡}t dIdJ|¡}t dKdL|¡}t dMdN|¡}t dOdP|¡}t dQdR|¡}t dSdT|¡}t dUdV|¡}t dWdX|¡}t dYdZ|¡}t d[d\|¡}t d]d^|¡}t d_d`|¡}t dadb|¡}t dcdd|¡}t dedf|¡}t dgdh|¡}t didj|¡}t dkdl|¡}t dmdn|¡}t dodp|¡}t dqdr|¡}t dsdt|¡}t dudv|¡}t dwdx|¡}t dydz|¡}t d{d||¡}t d}d~|¡}t dd€|¡}t dd‚|¡}t dƒd„|¡}t d…d†|¡}t d‡dˆ|¡}t d‰dŠ|¡}t d‹dŒ|¡}t ddŽ|¡}t dd|¡}t d‘d’|¡}t d“d”|¡}t d•d–|¡}t d—d˜|¡}t d™dš|¡}t d›dœ|¡}t ddž|¡}t dŸd |¡}t d¡d¢|¡}t d£d¤|¡}t d¥d¦|¡}t d§d¨|¡}t d©dª|¡}t d«d¬|¡}t d­d®|¡}t d¯d°|¡}t d±d²|¡}t d³d´|¡}t dµd¶|¡}t d·d¸|¡}t d¹dº|¡}t d»d¼|¡}t d½d¾|¡}t d¿dÀ|¡}t dÁdÂ|¡}t dÃdÄ|¡}t dÅdÆ|¡}t dÇdÈ|¡}t dÉdÊ|¡}t dËdÌ|¡}t dÍdÎ|¡}t dÏdÐ|¡}t dÑdÒ|¡}t dÓdÔ|¡}t dÕdÖ|¡}t d×dØ|¡}t dÙdÚ|¡}t dÛdÜ|¡}t dÝdÞ|¡}t dßdà|¡}t dádâ|¡}t dãdä|¡}t dådæ|¡}t dçdè|¡}t dédê|¡}t dëdì|¡}t dídî|¡}t dïdð|¡}t dñdò|¡}t dódô|¡}t dõdö|¡}t d÷dø|¡}t dùdú|¡}t dûdü|¡}t dýdþ|¡}t dÿd|¡}t dd|¡}t dd|¡}t dd|¡}t dd|¡}t d d |¡}t d d |¡}t d d|¡}t dd|¡}t dd|¡}t dd|¡}t dd|¡}t dd|¡}t dd|¡}t dd|¡}t dd|¡}t dd |¡}t d!d"|¡}t d#d$|¡}t d%d&|¡}t d'd(|¡}t d)d*|¡}t d+d,|¡}t d-d.|¡}t d/d0|¡}t d1d2|¡}t d3d4|¡}t d5d6|¡}t d7d8|¡}t d9d:|¡}t d;d<|¡}|S(=NrDr rrr*z_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()rrr Úsubrü)r&rAZexpand_future_functionsr,r,r-rIFsT       ÿÿzWorksheet._prepare_formularKc Cs||kr ||}}||kr||}}| ||¡rdS| ||¡r"dS||kr0||kr0t||ƒ} n t||ƒdt||ƒ} | |¡}|jrN||jkrN| |¡t|||| |ƒ|j||<|js‚t||dƒD]} t||dƒD]} | |ksx| |kr€|  | | d|¡qnqedS)Nr*r1r r) r,rrIr_ràr/Úcell_arformula_tupler¯Úranger ) r&rLrMrNrOrAr&rBÚatypeÚ cell_rangerr<r,r,r-rHüs<     ÿþÿ   ÿ€þzWorksheet._write_array_formulacCr$)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. )r )r&rr<rr&r,r,r-Úwrite_datetime2r6zWorksheet.write_datetimecCsZ| ||¡rdS|jr||jkr| |¡| |¡}|dur!|j}t||ƒ|j||<dS)Nr*r)r,r_ràr/Ú_convert_date_timerîÚcell_datetime_tupler¯)r&rr<rr&r4r,r,r-r Es   zWorksheet._write_datetimecCr$)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)r&rr<Úbooleanr&r,r,r-Ú write_booleanZr6zWorksheet.write_booleancCsP| ||¡rdS|jr||jkr| |¡|rd}nd}t||ƒ|j||<dS)Nr*r r)r,r_ràr/Úcell_boolean_tupler¯)r&rr<r[r&rBr,r,r-rms  zWorksheet._write_booleancCs| ||||||¡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. )r )r&rr<Úurlr&r%Útipr,r,r-Ú write_urlˆszWorksheet.write_urlc Csæ| ||¡rdS|dur|}d}| d¡r#| dd¡}| dd¡}d}d}| d¡rD| dd¡}| dd ¡}| dd¡}| dd ¡}d }| d d¡}d } t|ƒ|jkrYtd ƒdS|} |dkr•d|vrl| dd¡\}} nd} | |¡}| dur~|s~| | ¡} t  d|¡sŠt  d|¡rŽd|}t  dd|¡}| p˜d} |j } t|ƒ| ks¨t| ƒ| kr²td|| fƒdS|j d7_ |j dkrÆtd|ƒdS|durÍ|j }|jså|jrÝ||jkrÝ| |¡| ||||¡||| |dœ|j||<| S)Nr*r ú internal:rMéFú external:ú/ú\TrrzFIgnoring URL since it exceeds Excel's string limit of 32767 charactersr+ú#ú\w:ú\\úfile:///z^\.\\zfIgnoring URL '%s' with link or location/anchor > %d characters since it exceeds Excel's limit for URLSéýÿÿÿiúÿzNIgnoring URL '%s' since it exceeds Excel's limit of 65,530 URLS per worksheet.éüÿÿÿ)Ú link_typer^rr_)r,rÚreplacer-rfr r3Ú _escape_urlr r rSrñrÉrïrýr_ràr/rré) r&rr<r^r&r%r_rlZexternalr1Zurl_strZ tmp_url_strZmax_urlr,r,r-r žs~          ÿ   ÿÿ ÿÿ üzWorksheet._write_urlcGr)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_stringrr,r,r-Úwrite_rich_string szWorksheet.write_rich_stringcGsüt|ƒ}d}d}d}| ||¡rdSt|dtƒr| ¡}tƒ}tƒ|_|j |¡tƒ} g} d} d} t |ƒdkr?t dƒdS|D]G} t| tƒsn| dkrW|   | ¡|   | ¡n|   | ¡| dkrgt dƒd S|| 7}d } n| dkr}| dkr}t d ƒd S|   | ¡d} | d 7} qAt| dtƒs–|j  d¡| D],} t| tƒr«|j  d¡|  | ¡q˜g}t| ƒr¶|  d¡|j d| |¡|j d¡q˜|jj ¡}t |ƒ|jkrØt dƒdS|jsâ|j |¡}n|}|jrñ||jkrñ| |¡t|||ƒ|j||<dS)NrrMr*rDrbzfYou must specify more than 2 format/fragments for rich strings. Ignoring input in write_rich_string().éûÿÿÿzYExcel doesn't allow empty strings in rich strings. Ignoring input in write_rich_string().rkr%zaExcel doesn't allow 2 consecutive formats in rich strings. Ignoring input in write_rich_string().rjr Úr)z xml:spaceÚpreserveÚtzfString length must be less than or equal to Excel's limit of 32,767 characters in write_rich_string().r+)Úlistr,r!rÚpoprrrßZ_set_filehandler-r ÚappendÚ_xml_start_tagÚ _write_fontrÚ_xml_data_elementÚ _xml_end_tagÚfhÚgetvaluerfr_r]r.ràr/Úcell_rich_string_tupler¯)r&rr<r'Útokensr&r2Ú raw_stringr|ÚdefaultÚ fragmentsÚpreviousÚposrÚ attributesr%r,r,r-ro!s†   ÿ    ÿÿ        ÿ ÿzWorksheet._write_rich_stringcCs||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ù)r&Z user_typeÚ user_functionr,r,r-Úadd_write_handleršs zWorksheet.add_write_handlercCs2|D]}| ||||¡}|r|S|d7}qdS)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. r rr©r&rr<Údatar&rrRr,r,r-Ú write_row©ó  zWorksheet.write_rowcCs2|D]}| ||||¡}|r|S|d7}qdS)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. r rrrˆr,r,r-Ú write_columnÀr‹zWorksheet.write_columncCsþ| ||dd¡rtd||fƒdS|duri}| dd¡}| dd¡}| dd ¡}| d d ¡}| d d¡} | d d¡} | d d¡} | dd¡} | dd¡} | dd¡}| d| ¡} | sjtj |¡sjtd|ƒdS|j |||||||| | | | | |g ¡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). filename: Path and filename for in supported formats. options: Position, scale, url and data stream of the image. Returns: 0: Success. -1: Row or column is out of worksheet bounds. Tz Cannot insert image at (%d, %d).r*NÚx_offsetrÚy_offsetÚx_scaler Úy_scaler^r_Úobject_positionrbÚ image_dataÚ descriptionÚ decorativeFZ positioningúImage file '%s' not found.)r,r ÚgetÚosÚpathÚexistsrÔrw)r&rr<ÚfilenameÚoptionsrrŽrrr^r_Úanchorr’r“r”r,r,r-Ú insert_image×sH            óÿzWorksheet.insert_imagecCs| ||¡rtd||fƒdS|duri}| dd¡}| dd¡}| dd¡}| dd¡}| dd¡} | d d ¡} |sJtj |¡sJtd |ƒdS|rc|durS|j}d |_| ||||d|¡d |_t ||ƒ\} } } } } } } || || | g}|j   || ¡}t d ||ƒ|j ||<dS)a Embed an image in a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). filename: Path and filename for in supported formats. options: Url and data stream of the image. Returns: 0: Success. -1: Row or column is out of worksheet bounds. zCannot embed image at (%d, %d).r*Nr^r_r&r’r“r”Fr•Tú#VALUE!r)r,r r–r—r˜r™rïrýr`rÚembedded_imagesZget_image_indexÚcell_error_tupler¯)r&rr<ršr›r^r_r&r’r“r”Ú image_typer>ÚdigestÚimageZ image_indexr,r,r-Ú embed_imagesB         øzWorksheet.embed_imagec Cs¶| ||dd¡rtd||fƒdS|durd}|duri}| dd¡}| dd¡}| d d ¡}| d d ¡}| d d ¡} | d d¡} | dd¡} |j |||||||| || | g ¡dS)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. Tz"Cannot insert textbox at (%d, %d).r*NrMrrrŽrr rr‘r“r”F)r,r r–r×rw) r&rr<Útextr›rrŽrrrœr“r”r,r,r-Úinsert_textboxRs:       õÿzWorksheet.insert_textboxc Cs| ||dd¡rtd||fƒdS|duri}|js"|jr(|jjr(tdƒdSd|_|jr2d|j_| dd¡}| dd¡}| d d ¡}| d d ¡}| d d ¡} | d d¡} | dd¡} |jd krd|j}|jd krl|j}|jrr|j}|jrx|j}|j   |||||||| | | g ¡dS)a„ Insert an chart with its top-left corner in a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). chart: Chart object. options: Position and scale of the chart. Returns: 0: Success. -1: Row or column is out of worksheet bounds. Tz Cannot insert chart at (%d, %d).r*Nz7Chart cannot be inserted in a worksheet more than once.rrrŽrr rr‘r“r”F) r,r Zalready_insertedÚcombinedr–rrrrŽrÓrw) r&rr<Úchartr›rrŽrrrœr“r”r,r,r-Ú insert_chart†sP         öÿzWorksheet.insert_chartcCsT|duri}| ||¡rdSt|ƒ|jkrdSd|_d|_||||g|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. Nr*r+r r)r,r-rfr´r¶r·)r&rr<Úcommentr›r,r,r-Ú write_commentÍs zWorksheet.write_commentcCó d|_dS)z† Make any comments in the worksheet visible. Args: None. Returns: Nothing. r N)rºrþr,r,r-Ú show_commentsñó zWorksheet.show_commentscCs0|stj |¡std|ƒdS||_||_dS)zî Set a background image for a worksheet. Args: filename: Path and filename for in supported formats. is_byte_stream: File is a stream of bytes. Returns: Nothing. r•r*N)r—r˜r™r rÞrÝ)r&ršZis_byte_streamr,r,r-Úset_backgroundþs   zWorksheet.set_backgroundcCó ||_dS)z¦ Set the default author of the cell comments. Args: author: Comment author name. String. Returns: Nothing. N)r¹)r&Úauthorr,r,r-Úset_comments_authorr®zWorksheet.set_comments_authorcCs|jS)zw Retrieve the worksheet name. Args: None. Returns: Nothing. )r[rþr,r,r-Úget_names zWorksheet.get_namecCsd|_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. rr N)rmrrr\rôZ activesheetrþr,r,r-Úactivate,szWorksheet.activatecCó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. r rN)rrrmrþr,r,r-Úselect>s zWorksheet.selectcCrµ)zv Hide the current worksheet. Args: None. Returns: Nothing. r rN©rmrrrþr,r,r-ÚhideOó zWorksheet.hidecCrµ)z˜ Hide the current worksheet. This can only be unhidden by VBA. Args: None. Returns: Nothing. rbrNr·rþr,r,r-Ú very_hidden_r¹zWorksheet.very_hiddencCsd|_|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)rmr\rôZ firstsheetrþr,r,r-Úset_first_sheetoszWorksheet.set_first_sheetc Csà|duri}||kr||}}d}| dd¡}| dd¡}| dd¡} |s)|r,|r,d} nd} | d||| ¡r8dS| d||| ¡rBdS| dkrHd} | d krNd } | |jkrV| |_t||d ƒD] } |||| |dg|j| <q]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. NTrmFÚ collapsedÚlevelrr*ér )r–r,r¡rUrkrÆ) r&rMrOÚwidthr&r›Ú ignore_rowrmr¼r½Ú ignore_colr<r,r,r-Ú set_columns2      zWorksheet.set_columncCs$|dur | |¡}| |||||¡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. N)Ú_pixels_to_widthrÂ)r&rMrOr¿r&r›r,r,r-Úset_column_pixelsÂs zWorksheet.set_column_pixelscCsº|jr tdƒdS|jdurdSi}t|jj|jjjd}t|j|jdƒD]Ò}|j   |¡s/q&t|j |j dƒD]¿}||j |vr÷|j ||}|j j}d}|dvr}|dkr^|j}||} n|j} d| vrjt| ƒ}no|  d¡D] } t| ƒ} | |kr{| }qon\|d kr‹d tt|jƒƒ}nN|d kr“|j}nF|d kr |jrd }n|j  ||||g¡|  ||||¡t||dƒD]}t||dƒD]} ||kr¯| |kr¯q¤|  || d|¡q¤q›dS) 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 cellNr*r z4Merge range '%s' overlaps previous merge range '%s'.z4Merge range '%s' overlaps previous table range '%s'.rMr) r r,rrUr±r–r!r²r°rwrr) r&rLrMrNrOr‰r&rWrr<Úprevious_ranger,r,r-Ú merge_rangeÕsN    ÿÿÿÿòýzWorksheet.merge_rangecCs~||kr ||}}||kr||}}| ||||¡}t||||ƒ}||_||_||g|_t||dƒD] }d|j||f<q3dS)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. r TN)Ú_convert_name_arearr¾r¿rÀrUrÄ)r&rLrMrNrOÚareaÚrefr<r,r,r-Ú autofilter! s   ÿzWorksheet.autofiltercCsT|js tdƒdSzt|ƒWn!ty0|}t|dƒ\}}||jkr.td|ƒYdSYnw|j\}}||ks>||krItd|||fƒdS| |¡}t|ƒdvrZtd|ƒ|  ||¡}t|ƒdkrv|d dkrv|  ||d g¡n/t|ƒd kr›|d dkr›|dd kr›|d dkr›|  ||d |d g¡n ||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()Nr:úInvalid column '%s'z6Column '%d' outside autofilter() column range (%d, %d))rNr¾z+Incorrect number of tokens in criteria '%s'rbrr rËrNé)r¾r r$r%rrerÀÚ_extract_filter_tokensr-Ú_parse_filter_expressionÚfilter_column_listrÂrÃrÁ)r&r<ÚcriteriaÚ col_letterr>Ú col_firstÚcol_lastrr,r,r-Ú filter_columnB s@     þû ÿÿ    0   zWorksheet.filter_columncCs°|js tdƒdSzt|ƒWn!ty0|}t|dƒ\}}||jkr.td|ƒYdSYnw|j\}}||ks>||krItd|||fƒ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. râNr:rãz5Column '%d' outside autofilter() column range (%d,%d)r ) r¾r r$r%rrerÀrÂrÃrÁ)r&r<Úfiltersrér>rêrër,r,r-rç~ s0     þû ÿÿ   zWorksheet.filter_column_listc Cs¶| ||dd¡r dS| ||dd¡rdS|duri}n| ¡}hd£}| ¡D]}||vr6td|ƒdSq'd|vrA|d|d<d |vrK|d |d<d |vrUtd ƒdSd d d d d ddddddddœ }|d |vrttd|d ƒdS||d |d <|d d kr’| d¡dur’| d¡dur’dS|d d ks¤|d dks¤|d dkr¬d|d<d|d<d|vr¶tdƒdSidd“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/d0“d1d0“} |d| vrøtd2|dƒdS| |d|d<|ddks|ddkrd|vrtd3ƒdSnd|d<d4d5d6d7œ} d8|vr.d4|d8<n|d8| vr?td9|d8ƒdS| |d8|d8<|d d:vr€|dr€t|dƒr€| |d¡} d;| |d<|dr€t|dƒr€| |d¡} d;| |d<| d¡r™t|dƒd¡r²t|d>ƒdƒdS| d¡rËt|dƒd@krËtdA|dƒdS| dB¡rät|dBƒd@krätdC|dBƒdS|d dkr t|dt ƒr |j |dŽ} t| ƒd@kr tdD| ƒdSdE|vrd5|dE<dF|vrd5|dF<dG|vr$d5|dG<dH|vr-d5|dH<||||gg|dI<dJ|vrD|dI  |dJ¡dK|vrS|dK  dLdM¡|dK<|j  |¡d4S)Na 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. Tr*N>Ú error_typeÚdropdownÚ input_titleÚminimumÚmaximumÚ input_messageÚ show_errorÚ error_titleÚ show_inputÚvalidaterBÚ error_messageÚ other_cellsÚ multi_rangeÚ ignore_blankrèÚsourcez+Unknown parameter '%s' in data_validation()r+rürBrñr÷z5Parameter 'validate' is required in data_validation()ÚnoneÚwholeÚdecimalrurrÚ textLengthÚcustom) Úanyz any valuez whole numberrþÚintegerrÿrurrz text lengthrÕrzJUnknown validation type '%s' for parameter 'validate' in data_validation()rðróÚbetweenrèròz5Parameter 'criteria' is required in data_validation()ú not betweenÚ notBetweenúequal toÚequalrú==ú not equal toÚnotEqualú!=ú<>ú greater thanÚ greaterThanú>ú less thanÚlessThanú<úgreater than or equal toÚgreaterThanOrEqualú>=úless than or equal toÚlessThanOrEqualú<=zHUnknown criteria type '%s' for parameter 'criteria' in data_validation()zcParameter 'maximum' is required in data_validation() when using 'between' or 'not between' criteriarr rb)ÚstopÚwarningÚ informationrîzJUnknown criteria type '%s' for parameter 'error_type' in data_validation()©rrú%.16gé z6Length of input title '%s' exceeds Excel's limit of 32rõz6Length of error title '%s' exceeds Excel's limit of 32éÿz9Length of input message '%s' exceeds Excel's limit of 255røz9Length of error message '%s' exceeds Excel's limit of 255zSLength of list items '%s' exceeds Excel's limit of 255, use a formula range insteadrûrïrörôÚcellsrùrúú$rM)r,ÚcopyÚkeysr r–rrYr-r!ruÚ _csv_joinr4rmrárw) r&rLrMrNrOr›Úvalid_parametersÚ param_keyÚ valid_typesZcriteria_typesZ error_typesÚ date_timerAr,r,r-Údata_validation¨ sd  þ  ô ÿÿ    ÿþýüûúùø ÷ ö õ ô óòñð ÿÿ ÿûý  ÿÿÿ þ  ÿÿÿÿÿÿÿÿÿÿ       zWorksheet.data_validationcCs€ | ||dd¡r dS| ||dd¡rdS|duri}n| ¡}hd£}| ¡D]}||vr6td|ƒdSq'd|vrAtdƒdSid d “d d “d d “d d“dd“dd“dd“dd“dd“dd“dd“dd“dd“dd “d!d!“d"d"“d#d$“d%d&d'œ¥}|d|vr‹td(|dƒdS|ddkr•d|d)<||d|d<id*d*“d+d,“d-d.“d/d.“d0d.“d1d2“d3d2“d4d2“d5d6“d7d6“d8d9“d:d9“d;d<“d=d<“d>d?“d@d?“dAdB“dCdDdEdFdGdHdIdJdKdLdMdNdKdNdOœ¥} dP|vrõ|dP| vrõ| |dP|dP<|ddQvr]d |d<dR|vrt|dRƒstdSƒdS| |dR¡} dT| |dR<dU|vr>t|dUƒs1tdVƒdS| |dU¡} dT| |dU<dW|vr]t|dWƒsPtdXƒdS| |dW¡} dT| |dW<idYdZ“d[d\“d]d^“d_d`“dadb“dcdd“dedf“dgdh“didj“dkdl“dmdn“dodp“dqdr“dsdt“dudv“dwdx“dydz“} |dd&kré| d{¡s¥td|ƒd}S|d{| vr¶td~|d{ƒdS| |d{|d{<d|d€<|d{ d¡rÏd‚|d€<n |d{ dƒ¡rÛd„|d€<| | d€¡| d…¡¡|d…<||kró||}}||krý||}}t ||||ƒ} t ||ƒ} d†|vr|d†} |   d‡dˆ¡} d‰|vr*|d‰r*|d‰  ¡|d‰<|j |dŠ<|j d‹7_ |js|| dŒ¡s|| d¡s|| dŽ¡s|| d¡s|| d¡s|| d‘¡s|| d’¡s|| d“¡s|| d”¡s|| d•¡s|| d–¡r€d|d—<|ddkrñ|dPdBkrdB|d<d˜|dR| f|d™<nT|dPdCkr³dš|d<d›|dR| f|d™<n>|dPdDkrÎdD|d<dœ| t|dRƒ|dRf|d™<n#|dPdEkrédE|d<d| t|dRƒ|dRf|d™<ntdž|dPƒ|ddkr|dPdFkrdŸ| |d™<n—|dPdGkrd | |d™<n‰|dPd¡kr"d¢| |d™<n{|dPdHkr2d£| | f|d™<nk|dPdIkrBd¤| | f|d™<n[|dPdJkrRd¥| | f|d™<nK|dPdKkrbd¦| | f|d™<n;|dPdLkrsd§| | | f|d™<n*|dPdMkrƒd¨| | f|d™<n|dPdNkr•d©| | | | f|d™<ntdª|dPƒ|ddkrªd«| |d™<|ddkr·d¬| |d™<|ddkrÄd­| |d™<|dd krÑd®| |d™<|dd!krd¯|d<d|d‰<d|d°<d|d±<| d²d³¡| d´dµ¡| d¶d·¡| d¸d·¡| d¹dº¡| d»d¼¡t|d¹ƒ|d¹<t|d»ƒ|d»<|dd"kr|d¯|d<d|d‰<| d²d³¡| d°d½¡| d´dµ¡| d¶d·¡| d¸d·¡| d¹d¾¡| d±d¿¡| d»dÀ¡t|d¹ƒ|d¹<t|d±ƒ|d±<t|d»ƒ|d»<dÁ|vr|dÂ|dÁ<|dd$kr/d|d‰<| d²¡s–d³|d²<dÃ|dÄ<n|d²|dÄ<| d´¡s«dµ|d´<dÅ|dÆ<n|d´|dÆ<| d¶d·¡| d¸d·¡| dÇdÈ¡| dŽ|dÇ¡| dÉdÊ¡| d“dÊ¡| ddÊ¡| d–dˆ¡| ddË¡| d‘dË¡| ddÊ¡| d’dÊ¡| d”dˆ¡| d•dÌ¡t|dǃ|dÇ<t|dŽƒ|dŽ<t|d•ƒ|d•<t|dƒ|d<t|d‘ƒ|d‘<| d—¡r`dÍ|_|d²d³krJ|d¶d·krJd|d¶<|d´dµkr\|d¸d·kr\d|d¸<| |dÎ<z |d¶ d/¡|d¶<Wn ttfywYnwz |dÁ d/¡|dÁ<Wn ttfyYnwz |d¸ d/¡|d¸<Wn ttfy§Ynw| |jvr¸|j|  |¡d·S|g|j| <d·S)Ï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. Tr*N>$Ú mid_valueròÚ mid_colorÚ icon_styleÚ bar_solidÚ min_colorÚ bar_directionÚbar_negative_color_sameÚ min_lengthrBÚbar_negative_colorÚ icons_onlyÚmax_typeÚ bar_colorÚ data_bar_2010Úbar_negative_border_colorÚbar_axis_colorÚ max_colorÚmin_typerúÚbar_border_colorÚ max_lengthÚbar_negative_border_color_sameÚ reverse_iconsrèÚbar_onlyÚbar_axis_positionÚ bar_no_borderrDrñÚ min_valueÚ stop_if_truer"Úmid_typeÚiconsÚ max_valuez.Unknown parameter '%s' in conditional_format()r+r"z4Parameter 'type' is required in conditional_format()rÓÚcellIsrrÚaverageÚ aboveAverageZ duplicateÚduplicateValuesÚuniqueÚ uniqueValuesÚtopÚtop10Úbottomr¥Z time_periodÚ timePeriodÚblanksÚcontainsBlanksZ no_blanksÚnotContainsBlanksÚerrorsÚcontainsErrorsZ no_errorsÚnotContainsErrorsZ 2_color_scaleZ 3_color_scaleÚdata_barÚdataBarÚ expressionÚiconSet)rAZicon_setz?Unknown value '%s' for parameter 'type' in conditional_format()Ú directionrrrrrrr r r r r rrrrrrrrrrrrZ containingÚ containsTextZ notContainsÚ beginsWithÚendsWithÚ yesterdayÚtodayZ last7DaysZlastWeekZthisWeekZnextWeekZ lastMonthZ thisMonthZ nextMonth)znot containingz begins withz ends withr`raz last 7 daysz last weekz this weekz next weekz last monthz this monthz next monthz continue weekzcontinue monthrèrrBz5Conditional format 'value' must be a datetime object.rrñz7Conditional format 'minimum' must be a datetime object.ròz7Conditional format 'maximum' must be a datetime object.Z3_arrowsZ3ArrowsZ3_flagsZ3FlagsZ3_traffic_lights_rimmedZ3TrafficLights2Z3_symbols_circledZ3SymbolsZ4_arrowsZ4ArrowsZ4_red_to_blackZ 4RedToBlackZ4_traffic_lightsZ4TrafficLightsZ 5_arrows_grayZ 5ArrowsGrayZ 5_quartersZ 5QuartersZ 3_arrows_grayZ 3ArrowsGrayZ3_traffic_lightsÚ3TrafficLightsZ3_signsZ3SignsZ 3_symbolsZ 3Symbols2Z 4_arrows_grayZ 4ArrowsGrayZ 4_ratingsZ4RatingZ5_arrowsZ5ArrowsZ 5_ratingsZ5Ratingr-z^The 'icon_style' parameter must be specified when 'type' == 'icon_set' in conditional_format()rjz/Unknown icon_style '%s' in conditional_format()rNÚ total_iconsÚ4räÚ5rËrFrúr"rMrDÚpriorityr r7r.r<r3r1r8r>rBrAr9r0Úis_data_bar_2010zNOT(ISERROR(SEARCH("%s",%s)))rAÚnotContainsTextzISERROR(SEARCH("%s",%s))zLEFT(%s,%d)="%s"zRIGHT(%s,%d)="%s"z2Invalid text criteria '%s' in conditional_format()zFLOOR(%s,1)=TODAY()-1zFLOOR(%s,1)=TODAY()ZtomorrowzFLOOR(%s,1)=TODAY()+1z0AND(TODAY()-FLOOR(%s,1)<=6,FLOOR(%s,1)<=TODAY())z]AND(TODAY()-ROUNDDOWN(%s,0)>=(WEEKDAY(TODAY())),TODAY()-ROUNDDOWN(%s,0)<(WEEKDAY(TODAY())+7))z\AND(TODAY()-ROUNDDOWN(%s,0)<=WEEKDAY(TODAY())-1,ROUNDDOWN(%s,0)-TODAY()<=7-WEEKDAY(TODAY()))z_AND(ROUNDDOWN(%s,0)-TODAY()>(7-WEEKDAY(TODAY())),ROUNDDOWN(%s,0)-TODAY()<(15-WEEKDAY(TODAY())))zdAND(MONTH(%s)=MONTH(TODAY())-1,OR(YEAR(%s)=YEAR(TODAY()),AND(MONTH(%s)=1,YEAR(A1)=YEAR(TODAY())-1)))z4AND(MONTH(%s)=MONTH(TODAY()),YEAR(%s)=YEAR(TODAY()))zeAND(MONTH(%s)=MONTH(TODAY())+1,OR(YEAR(%s)=YEAR(TODAY()),AND(MONTH(%s)=12,YEAR(%s)=YEAR(TODAY())+1)))z9Invalid time_period criteria '%s' in conditional_format()zLEN(TRIM(%s))=0zLEN(TRIM(%s))>0z ISERROR(%s)zNOT(ISERROR(%s))Ú colorScalerEr,r;Úminr5ÚmaxrCrrGr/z#FF7128r:z#FFEF9CÚ percentilez#F8696Bz#FFEB84z#63BE7Br+é2ÚautoMinÚ x14_min_typeÚautoMaxÚ x14_max_typer6z#638EC6r@Fz#FF0000z#000000éÚrU)r,r#r$r rrYr–rÚ_set_icon_propsrrrmÚ_get_dxf_indexrårär-Ú setdefaultrrbÚlstripÚKeyErrorÚAttributeErrorrârw)r&rLrMrNrOr›Úvalid_parameterr'Z valid_typeZ criteria_typer)Z valid_iconsrWÚ start_cellr,r,r-Úconditional_format« s* ( þÿþýüûúùø ÷ ö õ ô óòñðïí ÿÿ ÿþýüûúùø ÷ ö õ ô óòñðïà$      ÿþýüûúùø ÷ ö õ ô óòñðï ÿÿÿ ÿ        ÿþýüûúùø ÷ ö õ ô þ þ  ý  ýÿÿÿÿþÿþÿþÿþÿÿÿ þÿÿÿ                                      ÿ ÿÿÿ  þzWorksheet.conditional_formatc$ Cs>i}i}|dur i}n| ¡}|jrtdƒdS| ||dd¡r"dS| ||dd¡r,dS||kr5||}}||kr>||}}t||||ƒ}t||dƒD]C} t||dƒD]9} |j | | f¡ro|j | | f¡} td|| fƒ‚|j  | | f¡r‡|j  | | f¡} td|| fƒ‚||j| | f<qUqLhd £} |  ¡D]} | | vr§td | ƒd Sq˜| d d¡|d <| d d¡|d <| dd¡|d<||}|d rÌ|d8}|dkrÖtdƒd S| dd¡|d<| dd¡|d<| d d¡|d<| dd¡|d<| d d¡|d<| dd¡|d<d|vr]|d}||d<d|vr td|ƒd St   d|t j ¡r0t   d |¡r8td!|ƒd St   d"|¡rGtd#|ƒd St   d$|¡sUt   d%|¡r]td&|ƒd Sd'|vr~|d'|d'<|d'dursd(|d'<|d' dd(¡|d'<nd)|d'<|}|}| d ¡r|d7}| d¡rš|d8}t||||ƒ|d*<t||||ƒ|d+<|d sµd|d<|drÀ|d+|d<d}g|d,<i}t||dƒD]}|d-t|ƒd(d(d(dd(ddd.œ }d,|vrÐ|t|d,ƒkrù|d,|d}nd}|rÐ| d/d¡}| d0¡r|d0|d<|d}| ¡}||vr&td1|ƒd Sd||<| d2¡|d3<d4|vrZ|d4rZ|d4}| d5¡rJ| d5¡}| d6d7¡}| |d¡}||d4<| d8¡r¦|d8}|d9krkd:}|d;krrd<}tgd=¢ƒ}||vr†| ||d¡}n | |d¡}||d><d?}||d8<| d@d¡}| |||||¡n| dA¡r¿|dA}||dA<| |||| d/¡¡|durÊ| ¡|d/<|||d<|d, |¡|d rè| |||d|d3¡|d7}qÏdB|vrG|dB}d}t||dƒD]F} d} t||dƒD]5} |t|ƒkr;| t||ƒkr;||| }!| |vr3| | | |!|| ¡n| | | |!d¡| d7} q |d7}qtt||dƒƒD]/\}}|d,|}"|"r~|"d4r~| |¡}#|"d4}t||dƒD] } | | |||#¡qrqP|j |¡|drt||dƒD] } d|j|| f<q’dS)CaY 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' moderjTr*r z4Table range '%s' overlaps previous table range '%s'.z4Table range '%s' overlaps previous merge range '%s'.> ráÚstyleÚ total_rowÚcolumnsÚ last_columnr‰Úbanded_columnsÚ first_columnÚ banded_rowsÚ header_rowr[z%Unknown parameter '%s' in add_table()r+r‚rƒrárz1Must have at least one data row in in add_table()rFZshow_first_colrZ show_last_colZshow_row_stripesr€Zshow_col_stripesZheader_row_countr}Ztotals_row_shownr[ú z.Name '%s' in add_table() cannot contain spacesz^[\w\\][\w\\.]*$z^\dz-Invalid Excel characters in add_table(): '%s'z^[a-zA-Z][a-zA-Z]?[a-dA-D]?\d+$z0Name looks like a cell name in add_table(): '%s'z^[rcRC]$z^[rcRC]\d+[rcRC]\d+$z3Invalid name '%s' like a RC cell ref in add_table()r|rMZTableStyleMedium9rUZa_ranger~ÚColumn) Úidr[Ú total_stringÚtotal_functionÚ custom_totalÚ total_valuerArDÚ name_formatrDr~z*Duplicate header name in add_table(): '%s'Z header_formatr‹rArú@z [#This Row],rˆZ count_numsÚ countNumsZstd_devÚstdDev©rIrÚcountrkrjrŽÚsumÚvarr‰rrŠr‡r‰)r#r_r r,rrUr²r–r!r±r$r r ÚUNICODErmrr-ÚlowerrrvrIÚsetÚ_table_function_to_formularrrtrwrÚ enumeraterÕrÄ)$r&rLrMrNrOr›r¯Z col_formatsrWrr<rÜryr'Znum_rowsr[Zfirst_data_rowZ last_data_rowÚcol_idZ seen_namesrÒZcol_dataÚ user_dataZxformatÚ header_namerAÚfunctionÚ subtotalsrBr‡r‰ÚiÚjrZ column_dataZformula_formatr,r,r-Ú add_table¬ sv  ÿÿÿÿò  þ   ÿ           ÷             ÿ ÿ   ÿ    ÿ         €  zWorksheet.add_tablecCs´| ||dd¡r dSdt||ƒgi}|duri}hd£}| ¡D]}||vr/td|ƒdSq d|vr:tdƒd S| d d ¡}|d vrJtd ƒd S|dkrPd}||d <d|vrmt|dtƒrf|d|d<n|dg|d<t|dtƒr{|d|d<n|dg|d<t|dƒ}t|dƒ} || kr˜tdƒd St|dƒ|d<t|j ƒ} g} |dD]} |   dd¡} |   d¡} d| vrÂ| d| } |   | ¡q«| |d<g} |dD] }|  dd¡}|   |¡qÒ| |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+krHd,|d-<n|d.krRd/|d-<nd0|d-<| d1¡}|rid|vri| d|}||d1<| d2d,¡}t |ƒ}|d3|d4<|d|d5<|d"|d6<|d|d7<|d!|d8<|d|d9<|d|d:<| ||d4¡| ||d5¡| ||d6¡| ||d7¡| ||d8¡| ||d9¡| ||d:¡|j  |¡d,S);ap Add sparklines to the worksheet. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). options: Sparkline formatting options. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: Incorrect parameter or option. Tr*Ú locationsN>Ú first_pointr|Ú low_colorÚlocationÚ high_pointÚ high_colorÚ last_pointÚreverserUÚ series_colorZ plot_hiddenÚ markers_colorÚ date_axisrkÚmarkersÚ low_pointÚnegative_pointsÚweightÚ last_colorrjÚ show_hiddenÚaxisÚnegative_colorÚ empty_cellsr"Ú first_colorz)Unknown parameter '%s' in add_sparkline()rUz0Parameter 'range' is required in add_sparkline()r+r"Úline)rµÚcolumnÚwin_losszJParameter 'type' must be 'line', 'column' or 'win_loss' in add_sparkline()r·Zstackedr£ÚrangeszMMust have the same number of location and range parameters in add_sparkline()rr"rMrú!r¤Úhighr¬Úlowr­Únegativer¡Úfirstr¦Úlastr«rjrkr±r§r°rmr®r³ÚzerorÚemptyÚconnectÚspanÚgaprªr|Zseriesr¨r²r©r´r¯r¥r¢)r,rr$r r–r!rur-rr[rmrvrwrÚ_set_spark_colorrÖ)r&rr<r›Ú sparkliner&r'Z spark_typeZ range_countZlocation_countÚ sheetnameZ new_rangesÚ spark_rangeZ new_locationsr£rÀZ date_rangeÚstyle_idr|r,r,r-Ú add_sparklineø s¸  þ ÿ  ÿ                         zWorksheet.add_sparklinecCs^d}t||ƒ}||kr||}}||kr||}}t||||ƒ}|dkr&dS|||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. NÚA1)rrrl)r&rLrMrNrOÚpaneÚ active_cellÚsqrefr,r,r-Ú set_selection¸s   zWorksheet.set_selectioncCs$|dkr |dkr dSt||ƒ|_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)rro)r&rr<r,r,r-Úset_top_left_cellÛs zWorksheet.set_top_left_cellr cCs"||_||_||_||_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)r¥r£r¤r¢r¦)r&ÚvisibleZ symbols_belowZ symbols_rightZ auto_styler,r,r-Úoutline_settingsís  zWorksheet.outline_settingscCs,|dur|}|dur |}|||||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)rp)r&rr<Útop_rowÚleft_colÚ pane_typer,r,r-Ú freeze_paness zWorksheet.freeze_panescCs| ||||d¡dS)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. rbN)rÕ)r&ÚxÚyrÒrÓr,r,r-Ú split_panesszWorksheet.split_panesrRcCs.|dks|dkrtd|ƒd}t|ƒ|_dS)zš Set the worksheet zoom factor. Args: zoom: Scale factor: 10 <= zoom <= 400. Returns: Nothing. é éz/Zoom factor %d outside range: 10 <= zoom <= 400rRN)r r$r›)r&r›r,r,r-Úset_zoom.s zWorksheet.set_zoomcCr¬)zš Display the worksheet right to left for some versions of Excel. Args: None. Returns: Nothing. r N)ržrþr,r,r-Ú right_to_left@r®zWorksheet.right_to_leftcCr¬)z Hide zero values in worksheet cells. Args: None. Returns: Nothing. rN)rŸrþr,r,r-Ú hide_zeroMr®zWorksheet.hide_zerocCst|ƒ|_dS)z“ Set the color of the worksheet tab. Args: color: A #RGB color index. Returns: Nothing. N)rrn©r&Úcolorr,r,r-Ú set_tab_colorZs zWorksheet.set_tab_colorrMcCsÆ|dkr | |¡}|s i}idd“dd“dd“dd“dd“d d“d d“d d“d d“d d“dd“dd“dd“dd“dd“dd“dd“}| ¡D]}||vrS||||<qFtd|ƒqF||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. rMÚsheetTÚcontentFÚobjectsÚ scenariosÚ format_cellsÚformat_columnsÚ format_rowsÚinsert_columnsÚ insert_rowsÚinsert_hyperlinksÚdelete_columnsÚ delete_rowsÚselect_locked_cellsÚsortráÚ pivot_tablesÚselect_unlocked_cellszUnknown protection object: '%s'ÚpasswordN)Ú_encode_passwordr$r r–)r&rñr›ÚdefaultsrÅr,r,r-ÚprotectgsZ ÿþýüûúùø ÷ ö õ ô óòñðï  zWorksheet.protectcCsr|dur tdƒdS| d¡}| dd¡}|jd7_|dur'dt|jƒ}|r.| |¡}|j |||f¡dS) a0 Unprotect ranges within a protected worksheet. Args: cell_range: The cell or cell range to unprotect. range_name: An optional name for the range. password: An optional password string. (undocumented) Returns: Nothing. Nz1Cell range must be specified in unprotect_range()r*rr"rMr ÚRange)r rvrmr˜rròr—rw©r&rWÚ range_namerñr,r,r-Úunprotect_rangešs    zWorksheet.unprotect_rangecCsT| ||dd¡rtd||fƒdS|duri}| |||¡}|j |¡d|_dS)aM Insert a button form object into the worksheet. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). options: Button formatting options. Returns: 0: Success. -1: Row or column is out of worksheet bounds. Tz!Cannot insert button at (%d, %d).r*Nr r)r,r Ú_button_paramsr¼rwr´)r&rr<r›Úbuttonr,r,r-Ú insert_button¹s zWorksheet.insert_buttoncCrµ)z Set the page orientation as landscape. Args: None. Returns: Nothing. rTN©rursrþr,r,r-Ú set_landscapeÝó zWorksheet.set_landscapecCrµ)z€ Set the page orientation as portrait. Args: None. Returns: Nothing. r TNrürþr,r,r-Ú set_portraitërþzWorksheet.set_portraitcCr°)zÐ Set the page view mode. Args: 0: Normal view mode 1: Page view mode (the default) 2: Page break view mode Returns: Nothing. N©ræ©r&Úviewr,r,r-Ú set_page_viewùs zWorksheet.set_page_viewcCr¬)zr Set the page view mode. Args: None. Returns: Nothing. rbNrrr,r,r-Úset_pagebreak_viewr®zWorksheet.set_pagebreak_viewcCs|r ||_d|_dSdS)z˜ Set the paper type. US Letter = 1, A4 = 9. Args: paper_size: Paper index. Returns: Nothing. TN)rtrs)r&rtr,r,r-Ú set_papers  þzWorksheet.set_papercCrµ)zx Center the page horizontally. Args: None. Returns: Nothing. Tr N)rvrwrþr,r,r-Úcenter_horizontally$rþzWorksheet.center_horizontallycCrµ)zv Center the page vertically. Args: None. Returns: Nothing. Tr N)rvrxrþr,r,r-Úcenter_vertically2rþzWorksheet.center_verticallyrOrPcCs||_||_||_||_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)r…r†r‡rˆ)r&ÚleftÚrightrNrPr,r,r-Ú set_margins@s zWorksheet.set_marginscCóf|}| dd¡}t|ƒdkrtdƒdS|dur"t|tƒs!d|i}ni}| ¡}|dur0||d<g|_| d¡rG|j | d¡| d¡d g¡| d ¡r[|j | d ¡| d ¡d g¡| d ¡ro|j | d ¡| d¡dg¡|  d¡}t|jƒ}||kr‹td|||fƒ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]ú&Gr zCHeader string cannot be longer than Excel's limit of 255 charactersNÚmarginÚ image_leftÚimage_data_leftZLHÚ image_centerÚimage_data_centerZCHÚ image_rightÚimage_data_rightZRHzONumber of header images (%s) doesn't match placeholder count (%s) in string: %sÚalign_with_marginsÚscale_with_docrQT)rmr-r r!r™r#r‚r–rwrr€rr~r‰r}rµ)r&r~r›rZ header_origÚplaceholder_countÚ image_countr,r,r-Ú set_headerSó\   € ÿ ÿ ÿ  þÿ   ÿzWorksheet.set_headercCr )zù Set the page footer caption and optional margin. Args: footer: Footer string. margin: Footer margin. options: Footer options, mainly for images. Returns: Nothing. r r r zCFooter string cannot be longer than Excel's limit of 255 charactersNrrrZLFrrZCFrrZRFzONumber of footer images (%s) doesn't match placeholder count (%s) in string: %srrrQT)rmr-r r!r™r#rƒr–rwrr€rrrŠr}rµ)r&rr›rZ footer_origrrr,r,r-Ú set_footer rzWorksheet.set_footercCsD|dur|}|d7}|d7}d||f}t|jƒ}|d||_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. Nr z$%d:$%dr¹)rr[r‹)r&rLrNrßrÆr,r,r-Ú repeat_rowsís   zWorksheet.repeat_rowscCsH|dur|}t|dƒ}t|dƒ}|d|}t|jƒ}|d||_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. Nr r1r¹)rrr[rŒ)r&rMrOrßrÆr,r,r-Úrepeat_columnss     zWorksheet.repeat_columnscCsF|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. rr TN)ryrzrv)r&Úoptionr,r,r-Úhide_gridlines"s    zWorksheet.hide_gridlinescCód|_d|_dS)z¢ Set the option to print the row and column headers on the printed page. Args: None. Returns: Nothing. TN)r{rvrþr,r,r-Úprint_row_col_headers:rþzWorksheet.print_row_col_headerscCr¬)zž Set the option to hide the row and column headers on the worksheet. Args: None. Returns: Nothing. TN)r|rþr,r,r-Úhide_row_col_headersHr®zWorksheet.hide_row_col_headerscCsJ|dkr|dkr||jdkr||jdkrdS| ||||¡}||_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. rr N)rdrerÞr)r&rLrMrNrOrßr,r,r-Ú print_areaUszWorksheet.print_areacCrµ)z„ Set the order in which pages are printed. Args: None. Returns: Nothing. r TN)rŽrsrþr,r,r-Ú print_acrossvrþzWorksheet.print_acrosscCsd|_||_||_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. r TN)r‘r’r“rs)r&r¿r×r,r,r-Ú fit_to_pages„s  zWorksheet.fit_to_pagescCr°)zœ Set the start page number when printing. Args: start_page: Start page number. Returns: Nothing. N)r)r&Z start_pager,r,r-Úset_start_page–r®zWorksheet.set_start_pagecCs:|dks|dkrtd|ƒdSd|_t|ƒ|_d|_dS)z§ Set the scale factor for the printed page. Args: scale: Print scale. 10 <= scale <= 400. Returns: Nothing. rÙrÚz2Print scale '%d' outside range: 10 <= scale <= 400NrT)r r‘r$rrs)r&Úscaler,r,r-Úset_print_scale£s    zWorksheet.set_print_scalecCr )z” Set the option to print the worksheet in black and white. Args: None. Returns: Nothing. TN)rrsrþr,r,r-Úprint_black_and_white¹rþzWorksheet.print_black_and_whitecCr°)z¿ Set the horizontal page breaks on a worksheet. Args: breaks: List of rows where the page breaks should be added. Returns: Nothing. N)r”©r&Úbreaksr,r,r-Úset_h_pagebreaksÇr®zWorksheet.set_h_pagebreakscCr°)z Set the horizontal page breaks on a worksheet. Args: breaks: List of columns where the page breaks should be added. Returns: Nothing. N)r•r*r,r,r-Úset_v_pagebreaksÔr®zWorksheet.set_v_pagebreakscCs*|dur ||_dSdt|jdƒ|_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. NZSheetr )rçrr\)r&r[r,r,r-Ú set_vba_nameás zWorksheet.set_vba_namecCsN|durdS| ¡}hd£}| ¡D]}||vr!td|ƒdSq||_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. Nr*> Ú formula_rangeÚ eval_errorÚempty_cell_referenceÚformula_differsÚcalculated_columnÚlist_data_validationÚnumber_stored_as_textÚtwo_digit_text_yearÚformula_unlockedz)Unknown parameter '%s' in ignore_errors()r)r#r$r rú)r&r›r&r'r,r,r-Ú ignore_errorsòs   þzWorksheet.ignore_errorscCs>|d|_|d|_|d|_|d|_|d|_|d|_|d|_|d|_|d |_|d |_ |d |_ |d |_ |d |_ |d|_ |d|_|d|_|d|_|d|_|j r{d|_d|_d|_d|_d|_d|_d|_d|_d|_d|_|jrtj|jd\}}t |¡||_ t!|ddd|_"|j"|_#dSdS)Nr[r\r]rôr_r`rèrêrírërìrîrïrcrðrñrürŸg€)@érPr çà?F)Údirzw+úutf-8©ÚmodeÚencoding)$r[r\r]rôr_r`rèrêrírërìrîrïrcrðrñrürŸr§r¨r©r…r†r‡rˆr‰rŠr€ÚtempfileÚmkstempr—ÚcloseròÚopenrór|)r&Z init_dataÚfdršr,r,r-Ú _initialize!sH                    ÷zWorksheet._initializecCs| ¡| ¡| ¡| ¡| ¡| ¡| ¡|js$| ¡n|  ¡|  ¡|  ¡|j r7|  ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡|  d¡| !¡dS)NÚ worksheet)"Z_xml_declarationÚ_write_worksheetÚ_write_sheet_prÚ_write_dimensionÚ_write_sheet_viewsÚ_write_sheet_format_prÚ _write_colsr_Ú_write_sheet_dataÚ_write_optimized_sheet_dataÚ_write_sheet_protectionÚ_write_protected_rangesrcÚ_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{Z _xml_closerþr,r,r-Ú_assemble_xml_fileMsD   zWorksheet._assemble_xml_filecCs¼|dks|dkr dS||jks||jkrdS|s$|s$|jr$||jkr$dS|s@|jdus0||jkr3||_|jdus=||jkr@||_|s\|jdusL||jkrO||_|jdusY||jkr\||_dSr))rdrer_ràrgrhrirj)r&rr<rÀrÁr,r,r-r,±s$ zWorksheet._check_dimensionscCst||j|jƒS©N)rrèrð)r&Zdt_objr,r,r-rYÒózWorksheet._convert_date_timecCsÔd}d}d}d}t|dƒ} t|dƒ} dt|dƒ} dt|dƒ} |dkr4||jdkr4| }| }d}n|dkrF||jdkrF| }| }d}n| | }| | }||krW|sW|}n|d|}t|jƒ} | d|}|S)NrMrr r"r1r¹)rrrdrerr[)r&Z row_num_1Z col_num_1Z row_num_2Z col_num_2Zrange1Zrange2rßZ row_col_onlyZ col_char_1Z col_char_2Z row_char_1Z row_char_2rÆr,r,r-rÞÖs0      zWorksheet._convert_name_areacCsR|sdSt|ƒ}d|vr| d¡t|ƒ}| ¡d}t|ƒ|kr'|d|…}|S)Nriÿ)r•Úremoverurîr-)r&r+Z breaks_setZ breaks_listZmax_num_breaksr,r,r-Ú_sort_pagebreaksþs   zWorksheet._sort_pagebreakscCsp|sgSt d¡}| |¡}g}|D]#}| d¡r|dd…}| d¡r*|dd…}| dd¡}| |¡q|S)Nz"(?:[^"]|"")*"|\S+ú"r r*z"")r ÚcompileÚfindallrrrmrw)r&rZZtoken_rerZ new_tokensrr,r,r-rås         z Worksheet._extract_filter_tokenscCsŠt|ƒdkr?|d}t d|¡rd}nt d|¡rd}ntd||fƒ| ||dd…¡}| ||dd…¡}||g|S| ||¡S) Nr¾rNz(and|&&)rz (or|\|\|)r z?Token '%s' is not a valid conditional in filter expression '%s'rä)r-r r r Ú_parse_filter_tokens)r&rZrZ conditionalZ expression_1Z expression_2r,r,r-ræ9s   ÿÿ z"Worksheet._parse_filter_expressionc Cs€dddddddddddddœ }| |dd¡}|d}t d|d  ¡¡rjt|dƒ}|dks3|d kr;td ||fƒ| ¡}|d krO|d krOtd||fƒ|d  ¡dkrZd}nd}|dd krf|d7}t|ƒ}|sz|d rztd|d |fƒt d| ¡¡r°|dkr”|dkr”td|d|fƒ| ¡}|dkr£|dkr¢d}n |dkr¬d}d}nd}d}|dkr¼t d|¡r¼d}||gS)NrbrËr rNräé) r rz=~Úeqr z!~Úner rrrrz top|bottomriôz?The value '%d' in expression '%s' must be in the range 1 to 500rÏú%z?The type '%s' in expression '%s' must be either 'items' or '%%'rNérzd@B}|t|ƒN}q |d?d@|d>d@B}|t|ƒN}|dN}d|S)Nrr*ér rLiKÎz%X)Úordr-)r&rñÚhashÚcharr,r,r-rò¯s zWorksheet._encode_passwordc  Cs†d} |j|\ } } }}}}}}}}}}}||9}||9}|d|9}|d| 9}| | | |||||¡}td|dƒ}td|dƒ}|js_tƒ}d|_||_|j ddt|ƒddg¡n|j}|  ¡}| |d <||d <||d <||d <||d <d|d<||d<d|d<d|d<||d<||d<|durš||d <|r#d}d}d}t   d|¡r®|  |¡}t   d|¡r¹|  |¡}t   d|¡rç|  dd¡}|  |¡}|  dd¡}t   d|¡sÜt   d|¡rád|}n|  d d!¡}t   d"|¡rõ|  d"d¡}d}|dur#t|ƒ|jkr td#||jfƒn|j |¡s|j |||g¡| |¡|d<|j | ¡s:|j d$d%t|ƒd&|g¡| | ¡|d<dS)'NrbgX@r:é5%r ú/drawingú../drawings/drawingú.xmlr"Ú dimensionsr¿r×r“ÚshaperœrÚ rel_indexÚ url_rel_indexr_r”ú /hyperlinkÚExternalrú^mailto:rcrMrfú%23rgrhrirerdraúaIgnoring URL '%s' with link and/or anchor > %d characters since it exceeds Excel's limit for URLSú/imageú../media/imageÚ.)rÔÚ_position_object_emusr$rØrÚembeddedrÌrwrÚ_add_drawing_objectr r rnrmr-rñr rÙr–rÑÚ_get_drawing_rel_index)r&r\Úimage_idÚ drawing_idr¿r×r[r¡Úx_dpiÚy_dpir¢Ú drawing_typerr<r>rrŽrrr^r_rœr“r”r}rØÚdrawing_objectÚtargetÚrel_typeÚ target_moder,r,r-Ú_prepare_imageÀs ò  ÿÿ             þÿÿzWorksheet._prepare_imagec CsBd}|j|\ }}}}}} } } } } }|  d|jd¡}|  d|jd¡}||9}|| 9}| ||||||| ¡}td|dƒ}td|dƒ}|jsctƒ}d|_||_|j   dd t |ƒd dg¡n|j}t d d | ƒ}| |_ | ¡}||d <||d<||d<||d<| |d<||d<| |d<d|d<d|d<|  d¡|d<||d<|  dd¡}|rd}d}d}t d|¡r¼| |¡}t d|¡rÇ| |¡}t d|¡rÞ| dd¡}| |¡}| dd¡}t d |¡rì| d d¡}d}|durt|ƒ|jkrtd!||jfƒdS|j |¡s|j  |||g¡| |¡|d<dSdSdS)"NrNr¿r×rmr:ryr rzr{r|ÚrectZTextBoxr"r}r“r~rœrrr€r_r”r^rr‚rrƒrcrirfr„rar…)r×r–r«r©r‰r$rØrrŠrÌrwrrr¥r‹r r rnrmr-rñr rÙrÑrŒ)r&r\rŽr‘rr<rrŽrrr¥rœr›r“r”r¿r×r}rØr~r’r^r“r”r•r,r,r-Ú_prepare_shape7s’ôÿÿ             þÿàzWorksheet._prepare_shapec Csbt dd|¡}|j | ¡s|j ddt|ƒd|g¡| | ¡} |j ||||||| g¡dS)Nz\..*$rMr†r‡rˆ) r rSrÛr–rÒrwrÚ_get_vml_drawing_rel_indexr„) r&rr¿r×r[r¡Úpositionrrr¢Zref_idr,r,r-Ú_prepare_header_image–s ÿ ÿzWorksheet._prepare_header_imagecCs$|j ddt|ƒd|g¡dS)Nr†r‡rˆ)rÐrwr)r&rr¡r,r,r-Ú_prepare_background©sÿzWorksheet._prepare_backgroundc Cs4d}|j|\ }}}}} } } } } }|d|_td|j| ƒ}td|j| ƒ}| |||| ||| ¡}|j}|jsQtƒ}d|_ ||_|j   ddt |ƒdg¡n|j}|  ¡}||d<||d<||d<||d <||d <d|d <| |d <| ¡|d <d|d<d|d<| |d<||d<|j  ddt |ƒdg¡dS)Nr r:rzr{r|r"r}r¿r×r[r~rœrrr€r_r“r”z/chartz../charts/chart)rÓr†r$r¿r×r‰Z chart_namerØrrŠrÌrwrr‹rŒrÑ)r&r\Zchart_idrŽr‘rr<r¨rrŽrrrœr“r”r¿r×r}r[rØr’r,r,r-Ú_prepare_chart¯sX õ ÿÿ ÿzWorksheet._prepare_chartc Cs¢| |||||||¡\ }}}}}} } } } } tdd|ƒ}tdd|ƒ}tdd| ƒ} tdd| ƒ} tdd| ƒ} tdd| ƒ} |||||| | | | | f S)Nr:ry)Ú_position_object_pixelsr$)r&Ú col_startÚ row_startÚx1Úy1r¿r×rœÚcol_endÚrow_endÚx2Úy2Úx_absÚy_absr,r,r-r‰ës*ÿõzWorksheet._position_object_emusc Cs>d}d} |dkr!|dkr!|| |d¡7}|d8}|dkr!|dks |dkr>|dkr>|| |d¡7}|d8}|dkr>|dks)|dkrDd}|dkrJd}|jr\t|ƒD] } || | ¡7}qQn||j|7}||7}|jryt|ƒD] } | | | ¡7} qnn| |j|7} | |7} || ||¡krŸ|| |¡8}|d7}|| ||¡ksŒ|| ||¡krº|| |¡8}|d7}|| ||¡ks§|} |} | ||¡dkrÊ||}| ||¡dkrÖ||}|| | |¡krò|| | |¡8}| d7} || | |¡ksÞ|| | |¡kr|| | |¡8}| d7} || | |¡ksû|}|}||||| | |||| g Sr#)Ú _size_colÚ _size_rowrÆrUr«rÇr©)r&rŸr r¡r¢r¿r×rœr§r¨r˜Zrow_idr£r¤r¥r¦r,r,r-rž/sfþþ ÿ ÿþþþþz!Worksheet._position_object_pixelscCs–d}d}d}||jvrF|j|d}|j|d}|dur |j}|r*|dkr*d}|S|dkr:t|||dƒ}|St||dƒ|}|S|j}|S)Nr¾rËrrbrär r:)rkrªr$r«)r&r<rœÚmax_digit_widthÚpaddingÚpixelsr¿rmr,r,r-r©s$  ùüþzWorksheet._size_colcCs`d}||jvr'|j|d}|j|d}|r|dkrd}|Std|ƒ}|Std|jƒ}|S)Nrr rägUUUUUUõ?)rÅr$r¨)r&rrœr­r×rmr,r,r-rª­s   üþzWorksheet._size_rowcCs0d}d}|dkr|||}|S|||}|S)Ng@g@é r,)r&r­r«r¬r¿r,r,r-rÃÂs  þzWorksheet._pixels_to_widthcCsd|S)NrPr,)r&r­r,r,r-rÙÎszWorksheet._pixels_to_heightcCsVd}d}d}dddddd||dddddddd œ}| ¡D]} || || <q|d s-||d <|d s5||d <t|d ƒ ¡|d <|d  d dd¡|d <|ddur`t|dƒ\} } | |d<| |d<|j} |j} |ddur¢|dkrud|d<n-|| dkr‚| d|d<n || dkr| d|d<n|| dkrœ| d|d<n|d|d<|ddurÖ|dkr±d|d<n%|| dkr¼d|d<n|| dkrÇd|d<n|| dkrÒd|d<nd|d<|ddur || dkrê| d|d<n!|| dkr÷| d|d<n|| dkr| d|d<n|d|d<|ddur:|| dkrd|d<n|| dkr*d|d<n|| dkr6d|d<nd|d<|drI|d |d|d <|drX|d |d|d <td |d ƒ|d <td |d ƒ|d <| |d|d|d|d|d |d |¡}|  |d ¡|  |d ¡||||d!|d"|d |d#|d$|d%g |gS)&Né€éJrz#ffffe1r ZTahomaérb)r±rßrzÚ start_colÚ start_rowrÐr¿r×rrrŽrÚ font_nameÚ font_sizeÚ font_familyr¿r×rßÚffrfrzr³r²rNr¾rmrËrŽrÊrurÙräré1rSrrr:r±rÐr´rµr¶) r$rr”rmrrdrer$ržrw)r&rr<r%r›Ú default_widthÚdefault_heightrœÚparamsrÅr³r²Úrow_maxÚcol_maxÚverticesr,r,r-Ú_comment_paramsÒsÄñ                        ù ÷ özWorksheet._comment_paramsc Cs¢|j}|j}d}dt|jƒ}||idœ}i} | ¡D]} || | | <q|  d¡} | dur1d|} | |dd<|  d¡rEd| d|d<nd ||d<|  d ¡|d <|  d |¡| d <|  d |¡| d <|  d d¡| d <|  dd¡| d<| d |  dd¡| d <| d |  dd¡| d <td| d ƒ| d <td| d ƒ| d <|| d<|| d<| | d| d| d | d| d | d |¡} |  | d ¡|  | d ¡| |d<|S)Nrr )rr<ÚfontÚcaptionz Button %drÀÚmacroz[0]!z[0]!Button%d_Clickr“r¿r×rrŽrrr:r³r²r¾) r©r«r-r¼r$r–r$ržrw) r&rr<r›rºr¹rœZ button_numberrúr»rÅrÁr¾r,r,r-rù[sN      ù zWorksheet._button_paramscCsTg}t|j ¡ƒ}|D]Y}t|j| ¡ƒ}|D]K} |j|| } |j| Ž} | |j|| <|jrD|j|| ddurDd|j|| d<|j|| ddurY|j|j|| d<| |j|| ¡qq |j ddt|ƒdg¡|j r‡||_ |j  ddt|ƒd g¡t |ƒ} |} t t| d ƒƒD] }d || |df}q•||_||_| S) Nrär rNú /vmlDrawingú../drawings/vmlDrawingú.vmlz /commentsz ../commentsr|rXz%s,%d)rÌr·r$r¿rºr¹rwrÎrr¶r¸rÍr-rUr$rõr»)r&rõr»Úvml_drawing_idZ comment_idr·Úrow_numsrÚcol_numsr<Z user_optionsr»rZ start_data_idrr,r,r-Ú_prepare_vml_objects¤s< òÿÿzWorksheet._prepare_vml_objectscCs&||_|j ddt|ƒdg¡dS)NrÃrÄrÅ)r½rÎrwr)r&r½rÆr,r,r-Ú_prepare_header_vml_objects×sÿz%Worksheet._prepare_header_vml_objectscCs†|jD]=}||d<| d¡durdt|ƒ|d<|d ¡}||vr*td|dƒ‚d||<|j ddt|ƒdg¡|d 7}qdS) Nr†r[ÚTablez2Duplicate name '%s' used in worksheet.add_table().Tz/tablez../tables/tabler|r )rÕr–rr”r rÏrw)r&Ztable_idÚseenr¯r[r,r,r-Ú_prepare_tablesàs   ÿÿ ëzWorksheet._prepare_tablesc Cszd}| dd¡}| dd¡}| dd¡}| dd ¡}d d d d dddddœ}||vr5||}d||f}|Std|ƒ|S)NrMú'z''rfz'#ú]z']ú[z'[éeéfégéhéiékéménrzSUBTOTAL(%s,[%s])z(Unsupported function '%s' in add_table())rmr )r&r›Zcol_namerArœZfunc_numr,r,r-r–ùs(    ø   þz$Worksheet._table_function_to_formulacCs$||vrdSdt||ƒi||<dS)NÚrgbr)r&rÅr›Z user_colorr,r,r-rÄszWorksheet._set_spark_colorc Csø|jrdSg}t||dƒD]k}||jvr| d¡qt||dƒD]V}||j|vrs|j||}|jj} | dvrC| d|j¡q"| dkrV|j} |j  | ¡} | | ¡q"| dvri|j } | durcd} | | ¡q"| dkrr| d ¡q"| d¡q"q|S) Nr,r ©rBrGrrA)rFrHrrCrM) r_rUr¯rwrrÎr4r%r]Z_get_shared_stringrB) r&r rŸr¤r£r‰rÑrÒrÓrÔr\r%rBr,r,r-Ú_get_range_datas8      € á!zWorksheet._get_range_datacGsdd„|Dƒ}d |¡S)NcSs"g|] }t|tƒs t|ƒn|‘qSr,)r!r)r;Úitemr,r,r-r=Vs"z'Worksheet._csv_join..ú,)Újoin)r&rÏr,r,r-r%Rs zWorksheet._csv_joincCs˜t d|¡r|S| dd¡}| dd¡}| dd¡}| dd ¡}| d d ¡}| d d ¡}| dd¡}| dd¡}| dd¡}| dd¡}| dd¡}|S)Nz%[0-9a-fA-F]{2}rpz%25riz%22r„z%20rz%3crz%3erÐz%5brÏz%5dú^z%5eú`z%60rDz%7brz%7d)r rFrm)r&r^r,r,r-rnZs            zWorksheet._escape_urlcCsR|dur|jd7_|jS|j |¡r|j|S|jd7_|j|j|<|jS©Nr )rÚrÙr–©r&r“r,r,r-rŒns   z Worksheet._get_drawing_rel_indexcCs6|j |¡r |j|S|jd7_|j|j|<|jSrá)rÛr–rÜrâr,r,r-r™zs   z$Worksheet._get_vml_drawing_rel_indexcCsl|j}| d¡|jr| d¡|jr| d¡|jr | d¡|jr(| d¡|jr0| d¡|jr9|  |j¡|j dkrC|  d¡|j d krM|  d ¡| d d |j fg¡|j d kr]n,|j rh| d|j ¡n!|jrs| d|j¡n|jrƒ| |j¡}| d|¡n| dd¡| dd |jfg¡| dd |jfg¡|jdkr¯|js¯| dd |jfg¡| d¡dS)NZrPrÚbrÚstrikeÚoutlineZshadowr Z superscriptrbZ subscriptÚszÚvalr*ÚthemeZindexedrÙZrFontÚfamilyZCalibriÚscheme)rßrxÚboldÚ_xml_empty_tagÚitalicZfont_strikeoutZ font_outlineZ font_shadowÚ underlineÚ_write_underlineZ font_scriptÚ_write_vert_alignrµrèÚ _write_colorZ color_indexedZ font_colorÚ_get_palette_colorÚ_write_rstring_colorr´r¶Ú hyperlinkZ font_schemer{)r&Z xf_formatZ xml_writerrßr,r,r-ry‰sD              zWorksheet._write_fontcCsDg}|dkr dg}n|dkrdg}n|dkrdg}|j d|¡dS)Nrb)rçÚdoubleé!)rçZsingleAccountingé")rçZdoubleAccountingÚu©rßrì)r&rîr…r,r,r-rï¿szWorksheet._write_underlinecCsd|fg}|j d|¡dS)NrçZ vertAlignrù©r&rçr…r,r,r-rðÍó zWorksheet._write_vert_aligncCs||fg}|j d|¡dS©Nrßrù©r&r[rBr…r,r,r-róÓrûzWorksheet._write_rstring_colorcCs$|ddkr |dd…}d| ¡S)Nrrfr ZFF)ÚupperrÞr,r,r-ròÙs   zWorksheet._get_palette_colorcCs|js |j ¡d|_dSdS)NT)rörórBrþr,r,r-Ú _opt_closeàs  þzWorksheet._opt_closecCs2|jr|j}t|ddd|_d|_|j|_dSdS)Nza+r<r=F)röròrCrór|)r&ršr,r,r-Ú _opt_reopenæs  üzWorksheet._opt_reopenc Cs¼g}t|ƒD] }| ddddœ¡q|dkr"d|dd<d|d d<|d kr8d |dd<d |d d<d |dd<|dkrTd|dd<d|d d<d|dd<d|dd<|rÜt|ƒ}||krb|d }t|ƒD]u}|| d¡dur”||d||d<||d}t|tƒr”| d¡r”| d¡||d<|| d¡rÈd}||d|vr°td||dƒn||d||d<||ddkrÈd||d<|| d¡} | rÛ| dkrÛd||d<qf|S)NFrÚpercent)rèrBr"rNéCrBrör räéKrmérbrËéPé<é(rTrr")rrlr4rAzOUnknown icon property type '%s' for sub-property 'type' in conditional_format()r4ÚnumrèrT) rUrwr-r–r!rrrvr ) r&rcZ user_propsÚpropsr>Zmax_datarÚtmpr(rèr,r,r-rsîsR             þÿ   €zWorksheet._set_icon_propscCsxd}|d}|d}|d}d}|d}d|fd|fg}|jd kr4| 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/acÚxmlnszxmlns:rrrzxmlns:mcz xmlns:x14ac)z mc:IgnorableZx14acrF)rbrwrx)r&Úschemar Zxmlns_rZxmlns_mcZ ms_schemaZ xmlns_x14acr…r,r,r-rG4s  zWorksheet._write_worksheetcCsÔ|jdur |jdur d}nR|jdur7|jdur7|j|jkr$td|jƒ}n;td|jƒ}td|jƒ}|d|}n(|j|jkrK|j|jkrKt|j|jƒ}nt|j|jƒ}t|j|jƒ}|d|}| dd|fg¡dS)NrÊrr1Ú dimensionrà)rgrirjrrhrì)r&ràr5r6r,r,r-rIHs    zWorksheet._write_dimensioncCs | d¡| ¡| d¡dS)NZ sheetViews)rxÚ_write_sheet_viewr{rþr,r,r-rJks zWorksheet._write_sheet_viewscCsjg}|js | d¡|jr| d¡|js| d¡|jr"| d¡|jr*| d¡|js2| d¡|jdkr=| d¡n |jd krG| d ¡|jd krT| d |jf¡|j d kr‹| d|j f¡|jdkrq|j rq| d|j f¡|jdkr~| d|j f¡|jd kr‹| d|j f¡| d¡|j s˜t |j ƒr­| d|¡| ¡| ¡| d¡dS| d|¡dS)N)Z showGridLinesr)ZshowRowColHeadersr)Z showZerosr©Ú rightToLeftr )Z tabSelectedr ©ZshowOutlineSymbolsrr )rZ pageLayoutrb)rZpageBreakPreviewrMÚ topLeftCellrRZ zoomScalerZzoomScaleNormalZzoomScalePageLayoutViewZzoomScaleSheetLayoutView)ZworkbookViewIdrZ sheetView)rzrwr|rŸržrrr¥ræror›rœrpr-rlrxÚ _write_panesÚ_write_selectionsr{rì©r&r…r,r,r-rtsD                zWorksheet._write_sheet_viewcCsŠ|j}|j}|j}d|fg}|j|jkr| d¡|jr!| d¡|r*| d|f¡|r3| d|f¡|jdkr=| d¡| d|¡dS) NZdefaultRowHeight©Z customHeightr )Z zeroHeightr ZoutlineLevelRowZoutlineLevelColrr©zx14ac:dyDescentz0.25Z sheetFormatPr)r¨r r¡r§rwr­rbrì)r&r¨Z row_levelZ col_levelr…r,r,r-rK¯s      z Worksheet._write_sheet_format_prcCs¼|jsdS| d¡t|j ¡ƒd}|}|j|}|j|=|}|}t|j ¡ƒD]!}|j|}||dkr=||kr=|}q)| |||¡|}|}|}q)| |||¡||j|<| d¡dS)NÚcolsrr )rkrxrÌr$Ú_write_col_infor{)r&rMrOZprev_col_optionsZ deleted_colZdeleted_col_optionsr<Z col_optionsr,r,r-rLÇs(    zWorksheet._write_colscCsD|\}}}}}} d} d} |r| ¡} |dur |sd}d} n d}n|dkr&d} |dkr[d} d} |dkrGtt|| | dƒt| ƒdƒd}ntt|| dƒ| t| ƒdƒd}d|dfd |dfd d |fg}| ru| d | f¡|r|| d ¡| rƒ| d¡| rŠ| d¡|r“| d|f¡|rš| d¡| d|¡dS)Nr rrUr¾rËr:gp@rjrkr¿rr|)rmr:)ZbestFitr:)Z customWidthr:Ú outlineLevel)r¼r:r<)Ú _get_xf_indexr$r rwrì)r&Úcol_minr½rkr¿r&rmr½r¼rÖZ custom_widthÚxf_indexr«r¬r…r,r,r-rïsjÿþÿûÿ ÿþÿûÿ  ý    zWorksheet._write_col_infocCs8|jdur | d¡dS| d¡| ¡| d¡dS)NÚ sheetData)rgrìrxÚ _write_rowsr{rþr,r,r-rM3s  zWorksheet._write_sheet_datacCs‚|jdur | d¡dS| d¡d}|j d¡|j |¡}|r/|j |¡|j |¡}|s!|j ¡t   |j ¡|  d¡dS)Nrir) rgrìrxróÚseekÚreadr|rrBr—Úunlinkròr{)r&Z buff_sizer‰r,r,r-rN=s      þ  z%Worksheet._write_optimized_sheet_datacCsDd|jfd|jfd|jfd|jfd|jfd|jfg}| d|¡dS)Nrr rNrPr~rZ pageMargins)r…r†r‡rˆr‰rŠrìrr,r,r-rXUsú zWorksheet._write_page_marginscCsXg}|jsdS|jr| d|jf¡|jdkr| d|jf¡|jr/|jdkr/| d|jf¡|jr?|jdkr?| d|jf¡|jrG| d¡|jdkrT| d|jf¡|j r]| d ¡n| d ¡|j rj| d ¡|jd krt| d ¡|j rŽ|j r‚| d|j f¡|j r| d|j f¡n|j r™| d|j f¡|j r¤| d|j f¡| d|¡dS)NZ paperSizerRr'r Z fitToWidthZ fitToHeight)Z pageOrderZ overThenDownZfirstPageNumber)ruZportrait)ruZ landscape)Z blackAndWhiter:r)ZuseFirstPageNumberr:Z horizontalDpiZ verticalDpiZ pageSetup)rsrtrwrr‘r’r“rŽrrurrarør÷rìrr,r,r-rYbsB        €zWorksheet._write_page_setupcCs^g}|jsdS|jr| d¡|jr| d¡|jr| d¡|jr'| d¡| d|¡dS)N)ZhorizontalCenteredr )ZverticalCenteredr )Zheadingsr )Z gridLinesr Z printOptions)rvrwrwrxr{ryrìrr,r,r-rW°s    zWorksheet._write_print_optionscCszg}|js | d¡|js| d¡|jr0| d|¡|jr"| ¡|jr)| ¡|  d¡dS|j r;|  d|¡dSdS)N)Z scaleWithDocr)ZalignWithMarginsrZ headerFooter) rrwr€r}rxr~Ú_write_odd_headerrÚ_write_odd_footerr{rcrìrr,r,r-rZÉs   ÿzWorksheet._write_header_footercCó| d|j¡dS)NZ oddHeader)rzr~rþr,r,r-r#ÝózWorksheet._write_odd_headercCr%)NZ oddFooter)rzrrþr,r,r-r$ár&zWorksheet._write_odd_footercCs | ¡t|j|jdƒD]€}||jvs||jvs|j|rt|dƒ}||jvr/|j|}nd}|j|rs||jvrB|  ||¡n |  |||j|¡t|j |j dƒD]}||j|vrl|j||}|  |||¡qU|  d¡q ||jvrƒ| |||j|¡q | |||j|¡q dS)Nr rÊr)Ú_calculate_spansrUrgrhršr·r¯r$r³Ú _write_rowrirjÚ _write_cellr{Ú_write_empty_row)r&rÑÚ span_indexrÂrÒÚcol_refr,r,r-rås2  ÿ     €  €ÞzWorksheet._write_rowscCsÔ|j}||_||jvs||jvs|j|rcd}|j|rY||jvr(| ||¡n | |||j|¡t|j|jdƒD]}||j|vrR|j||}| |||¡q;|  d¡n |  |||j|¡|j  ¡dS)Nr r) ràršr·r¯r(rUrirjr)r{r*Úclear)r&Zcurrent_row_numrÑrÂrÒr,r,r,r-r/ s   € zWorksheet._write_single_rowcCs>i}d}d}t|j|jdƒD]Š}||jvr>t|j|jdƒD]}||j|vr=|dur1|}|}q||kr7|}||kr=|}q||jvrpt|j|jdƒD]#}||jvro||j|vro|durc|}|}qL||kri|}||kro|}qL|dddks}||jkr™t|dƒ}|dur™|d7}|d7}d||f||<d}q||_dS)Nr rÊrz%s:%s) rUrgrhr¯rirjr·r$r³)r&ÚspansZspan_minZspan_maxrÑrÒr+r,r,r-r'2sF € € € zWorksheet._calculate_spansc Csd}|r |\}}}} } nd\}}}} } |dur|j}d|dfg} |r'| ¡}|r0|  d|f¡|r9|  d|f¡|r@|  d¡||jkrN|  dd |f¡|rU|  d ¡||jkr_|  d ¡| rh|  d | f¡| ro|  d ¡|jdkry|  d¡|rƒ| d| ¡dS| d| ¡dS)Nr)NNrrrrrr r.Ús)Z customFormatr Zhtz%g)rmr rr)r¼r rrrr)r¨rrwr§rbZ_xml_empty_tag_unencodedZ_xml_start_tag_unencoded) r&rr.Ú propertiesÚ empty_rowrr×r&rmr½r¼r…r,r,r-r(as<        zWorksheet._write_rowcCs|j|||dddS)NT)r1)r()r&rr.r0r,r,r-r*”szWorksheet._write_empty_rowcCsÖt||ƒ}d|fg}|jr|j ¡}| d|f¡n6||jvr7|j|dr7|j|d}| d| ¡f¡n||jvrP|j|d}|durP| d| ¡f¡|jj} | dvra| |j |¡dS| dvr—|j } |j ss|  | |¡dS|  | ¡} |  d¡rŠ|  d¡rŠ| | |¡dSt| ƒ} | | | |¡dS| dkrÚ|j} t|jtƒr²| d ¡|jr¯d} n!d } nt|jtƒrÐd } |jd krÀn|j| vrË| d ¡n| d¡| |j| |¡dS| dkr|jdkré| d¡zt|jƒWntyþ| d¡Ynw| d|¡| |j|j¡| |j¡|  d¡dS| dkr'| !d|¡dS| dkrD| d ¡| d|¡| |j"¡|  d¡dS| dkri| d ¡| d|jf¡| d|¡| |j#¡|  d¡dSdS)Nrrr/r rÚrÆzzrF)rtrãr)r8z#N/Az#NAME?z#NULL!r7z#REF!ržrM)rtÚe)rtrrHrQ)Úcmr ÚcrCrErJÚvm)$rrDrrwršrkrrÎZ_xml_number_elementr4r%r_Z_xml_string_elementZ_escape_control_charactersrrZ_xml_rich_inline_stringrZ_xml_inline_stringrBr!rrZ_xml_formula_elementrArVr r%rxÚ_write_cell_array_formularUÚ_write_cell_valuer{rìr[rR)r&rr<rÓrWr…rZrow_xfZcol_xfZtype_cell_namer%rsrBZ error_codesr,r,r-r)˜s‚                ÿ           úzWorksheet._write_cellcCs|durd}| d|¡dS)NrMÚv©rz)r&rBr,r,r-r7szWorksheet._write_cell_valuecCsdd|fg}| d||¡dS)N)rtÚarrayràrr9)r&rArWr…r,r,r-r6s z#Worksheet._write_cell_array_formulacCs g}|js|js|js|js|jsdS|jr| d|jf¡|jr&| d¡|js/|js/|jrH| d|¡| ¡| ¡|  ¡|  d¡dS|  d|¡dS)NZcodeName)Z filterModer ZsheetPr) r‘rÁrnr¦rçrwrxÚ_write_tab_colorÚ_write_outline_prÚ_write_page_set_up_prr{rìrr,r,r-rHs.ÿþýüû  zWorksheet._write_sheet_prcCs |jsdSdg}| d|¡dS)N)Z fitToPager Z pageSetUpPr)r‘rìrr,r,r-r=7szWorksheet._write_page_set_up_prcCs(|j}|sdSd|fg}| d|¡dS)NrÙZtabColor)rnrì)r&rßr…r,r,r-r;?s  zWorksheet._write_tab_colorcCs^g}|jsdS|jr| d¡|js| d¡|js| d¡|js'| d¡| d|¡dS)N)Z applyStylesr )Z summaryBelowr)Z summaryRightrrZ outlinePr)r¦r¢rwr£r¤r¥rìrr,r,r-r<Js    zWorksheet._write_outline_prcCó\| |j¡}|s dSt|ƒ}d|fd|fg}| d|¡|D]}| |d¡q| d¡dS)NrÚmanualBreakCountZ rowBreaksiÿ?)rhr”r-rxÚ _write_brkr{)r&Ú page_breaksrr…rÑr,r,r-r[\ó þ zWorksheet._write_row_breakscCr>)Nrr?Z colBreaksiÿÿ)rhr•r-rxr@r{)r&rArr…rÒr,r,r-r\qrBzWorksheet._write_col_breakscCs"d|fd|fdg}| d|¡dS)Nr†rk)Úmanr Zbrk©rì)r&Zbrk_idZbrk_maxr…r,r,r-r@†szWorksheet._write_brkcCóN|j}t|ƒ}|s dSd|fg}| d|¡|D]}| |¡q| d¡dS)NrZ mergeCells)r°r-rxÚ_write_merge_cellr{)r&r±rr…Ú merged_ranger,r,r-rSŒó   zWorksheet._write_merge_cellsc CsF|\}}}}t||ƒ}t||ƒ}|d|}d|fg} | d| ¡dS)Nr1ràZ mergeCell)rrì) r&rGZrow_minrr¼r½r5r6ràr…r,r,r-rFžs     zWorksheet._write_merge_cellc Cs^g}d}t|j ¡ƒ}|sdS|D]t}t|j| ¡ƒ}|D]f}|j||}|d}|jrK|j|rK|j||rK|j||} | jjdkrK|d}|dkrs|jd7_| ||||j|d||dg¡|j d|ddg¡q| ||||d|d|dg¡qq|  d ¡|D]} |   d ¡}|dkrž|j | Žq|d kr§|j | Žq|  d ¡dS) NrlrAr^r rr_rr‚rérrb)rÌrér$r¯rrÎrÈrwrËrxrvÚ_write_hyperlink_externalÚ_write_hyperlink_internalr{) r&rÊÚdisplayrÇrÑrÈrÒÚlinkrlrÓr'r,r,r-rV«s` ùÿ ÿúÿÞ .   €zWorksheet._write_hyperlinksc Csxt||ƒ}dt|ƒ}d|fd|fg} |dur|  d|f¡|dur)|  d|f¡|dur4|  d|f¡| d| ¡dS)NÚrIdràúr:idr£rKÚtooltiprô)rrrwrì) r&rr<Zid_numr£rKrOràÚr_idr…r,r,r-rIùs  z#Worksheet._write_hyperlink_externalcCsNt||ƒ}d|fd|fg}|dur| d|f¡| d|f¡| d|¡dS)Nràr£rOrKrô)rrwrì)r&rr<r£rKrOràr…r,r,r-rJ s z#Worksheet._write_hyperlink_internalcCsN|jsdSd|jfg}|jr| d|¡| ¡| d¡dS| d|¡dS)NràÚ autoFilter)r¿rÁrxÚ_write_autofiltersr{rìrr,r,r-rRs  zWorksheet._write_auto_filtercCsT|j\}}t||dƒD]}||jvrq |j|}|j|}| ||||¡q dSrá)rÀrUrÂrÃÚ_write_filter_column)r&Zcol1Zcol2r<rrÃr,r,r-rR*s    özWorksheet._write_autofilterscCsBd|fg}| d|¡|dkr| |¡n| |¡| d¡dS)NZcolIdZ filterColumnr )rxÚ_write_filtersÚ_write_custom_filtersr{)r&r˜rÃrír…r,r,r-rS;s    zWorksheet._write_filter_columncCs‚dd„|Dƒ}g}t|ƒt|ƒkrdg}t|ƒdkr(t|ƒdkr(| d|¡dS| d|¡t|ƒD]}| |¡q2| d¡dS)NcSs g|] }t|ƒ ¡dkr|‘qS)rR)rr”)r;Úfilterr,r,r-r=Ls z,Worksheet._write_filters..)r=r r rrí)r-rìrxrÌÚ _write_filterr{)r&ríZ non_blanksr…rár,r,r-rTJs   zWorksheet._write_filterscCód|fg}| d|¡dS)NrçrVrDrúr,r,r-rW^ó zWorksheet._write_filtercCsŽt|ƒdkr| d¡|j|Ž| d¡dSg}|ddkr#dg}ndg}| d|¡| |d|d¡| |d|d¡| d¡dS) NrbZ customFiltersr)Úandr )rZrr rNrä)r-rxÚ_write_custom_filterr{)r&rr…r,r,r-rUds     zWorksheet._write_custom_filterscCsng}ddddddddœ}||dur||}ntd|ƒ|dkr(| d |f¡| d |f¡| d |¡dS) Nrrrrr r)r rbrNrärËrmrrzUnknown operator = %srtrçZ customFilter)r rwrì)r&rtrçr…rsr,r,r-r[{s ù  zWorksheet._write_custom_filtercCspg}|jsdS|j}|dr| d|df¡|dr | d¡|dr)| d¡|ds2| d¡|ds;| d ¡|d rD| d ¡|d rM| d ¡|drV| d¡|dr_| d¡|drh| d¡|drq| d¡|drz| d¡|drƒ| d¡|dsŒ| d¡|dr•| d¡|drž| d¡|d r§| d!¡|d"s°| d#¡| d$|¡dS)%Nrñrá)rár râ)râr rã)rãr rä)rär rå)Z formatCellsrræ)Z formatColumnsrrç)Z formatRowsrrè)Z insertColumnsrré)Z insertRowsrrê)ZinsertHyperlinksrrë)Z deleteColumnsrrì)Z deleteRowsrrí)ZselectLockedCellsr rî)rîrrá)rQrrï)Z pivotTablesrrð)ZselectUnlockedCellsr ZsheetProtection)r–rwrì)r&r…r›r,r,r-rO–sR                 z!Worksheet._write_sheet_protectioncCsF|jdkrdS| d¡|jD] \}}}| |||¡q| d¡dS)NrZprotectedRanges)r˜rxr—Ú_write_protected_ranger{rör,r,r-rPÆs  z!Worksheet._write_protected_rangescCsBg}|r | d|f¡| d|f¡| d|f¡| d|¡dS)NrñrÍr[ZprotectedRange©rwrì)r&rWr÷rñr…r,r,r-r\Òs z Worksheet._write_protected_rangecCs(|jsdS|jd7_| |j¡dSrá)rØrÈÚ_write_drawingrþr,r,r-r^ÞszWorksheet._write_drawingscCs&dt|ƒ}d|fg}| d|¡dS)NrMrNrØ©rrì)r&rŽrPr…r,r,r-r^æs  zWorksheet._write_drawingcCó@|jsdS|jd7_dt|jƒ}d|fg}| d|¡dS)Nr rMrNZ legacyDrawing)r´rÈrrì©r&rPr…r,r,r-r_îó  zWorksheet._write_legacy_drawingcCr`)Nr rMrNZlegacyDrawingHF)rµrÈrrìrar,r,r-r`ûrbz"Worksheet._write_legacy_drawing_hfcCr`)Nr rMrNZpicture)rÝrÈrrìrar,r,r-rarbzWorksheet._write_picturecCrE)NrZdataValidations)rár-rxÚ_write_data_validationr{)r&rárr…Z validationr,r,r-rUrHz!Worksheet._write_data_validationsc Csd}g}|dD]+}|dkr|d7}|\}}}}||kr!||}}||kr*||}}|t||||ƒ7}q| d¡r=|d}|ddkr[| d|df¡|dd kr[| d |df¡d |vru|d d krj| d ¡|d dkru| d¡|dr~| d¡|ds‡| d¡|dr| d¡|dr™| d¡d|vr¦| d|df¡d|vr³| d|df¡d|vrÀ| d|df¡d|vrÍ| d|df¡| d |f¡|ddkrâ| d!|¡dS| d!|¡| |d"¡|d#durü| |d#¡| d!¡dS)$NrMr!r„rúr÷rýr"rèrrtrîr )Ú errorStylerrb)rdrrû)Z allowBlankr rï)Z showDropDownr rö)ZshowInputMessager rô)ZshowErrorMessager rõZ errorTitlerørRrðZ promptTitleróÚpromptrÍZdataValidationrBrò)rr–rwrìrxÚ_write_formula_1Ú_write_formula_2r{) r&r›rÍr…r!Z row_firstrêZrow_lastrër,r,r-rc's\                  z Worksheet._write_data_validationcCsbt|tƒr|j|Ž}d|}nzt|ƒWnty(| d¡r&| d¡}Ynw| d|¡dS)Nz"%s"rZformula1)r!rur%r r%rrvrz©r&rAr,r,r-rfts       €ýzWorksheet._write_formula_1cCóDzt|ƒWnty| d¡r| d¡}Ynw| d|¡dS)NrZformula2©r r%rrvrzrhr,r,r-rg…ó    €ýzWorksheet._write_formula_2cCs6t|j ¡ƒ}|s dS|D] }| ||j|¡q dSre)rÌrâr$Ú_write_conditional_formatting)r&r¸Ú cond_ranger,r,r-rT’s ÿÿz$Worksheet._write_conditional_formatscCs8d|fg}| d|¡|D]}| |¡q | d¡dS)NrÍZconditionalFormatting)rxÚ_write_cf_ruler{)r&rmr»r…Úparamr,r,r-rlžs   z'Worksheet._write_conditional_formattingcCsd|dfg}d|vr|ddur| d|df¡| d|df¡| d¡r-| d¡|ddkrg| d|d f¡| d |¡d |vrYd |vrY| |d ¡| |d ¡n| |d ¡| d ¡dS|ddkr©t d|d ¡rz| d¡t d|d ¡r‡| d¡t d|d ¡r¡t d|d ¡}| d| d¡f¡| d |¡dS|ddkrÜd |vr¾|d dkr¾| d¡d|vrÇ| d¡|d pÌd}| 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&kr^| d&|d f¡| d |¡| |d%¡| d ¡dS|dd'ksz|dd(ksz|dd)ksz|dd*krŽ| d |¡| |d%¡| d ¡dS|dd+kr§| d |¡|  |¡| d ¡dS|dd,krË| d |¡|  |¡| d-¡rÄ|  |¡| d ¡dS|dd.kræ| d |¡| |d ¡| d ¡dS|dd/krÿ| d |¡|  |¡| d ¡dSdS)0Nr"rDZdxfIdrfrD)Z stopIfTruer rHrtrèZcfRulerñròrBrJZbelow)rJrr)Z equalAverager z [123] std devz([123]) std devrŽr rOrp)rr r\)rPr rÙÚrankrKrMr]rhr^r_r¥rArQrSrTrVrWrirYrgrZr[) rwr–rxÚ_write_formula_elementr{r rFÚgrouprìÚ_write_color_scaleÚ_write_data_barÚ_write_data_bar_extÚ_write_icon_set)r&r»r…r rpr,r,r-rn§s–                         ýzWorksheet._write_cf_rulecCri)NrrArjrhr,r,r-rqrkz Worksheet._write_formula_elementcCsœ| d¡| |d|d¡|ddur| |d|d¡| |d|d¡| d|d ¡|d dur?| d|d ¡| d|d ¡| d¡dS) Nrir;rCrEr+r5rGrÙr/r,r:)rxÚ _write_cfvorñr{)r&ror,r,r-rs s   zWorksheet._write_color_scalecCs¢g}| d¡r| d|df¡| d¡r| d|df¡| d¡r(| d¡| d|¡| |d|d ¡| |d |d ¡| d |d ¡| d¡dS)Nr2Ú minLengthr=Ú maxLengthr@©Z showValuerrYr;rCr5rGrÙr6)r–rwrxrwrñr{)r&ror…r,r,r-rt5s     zWorksheet._write_data_barcCsp|jd}t|jƒd}d||f}||d<|j |¡| d¡| d¡| d|¡| d¡| d¡dS)Nr z{DA7ABA51-AAAA-BBBB-%04X-%012X}ÚguidÚextLstz&{B025F937-C7B1-47D3-B67F-A62EFF666E3E}zx14:idÚext)r\r-rãrwrxÚ _write_extrzr{)r&roZworksheet_countZdata_bar_countr{r,r,r-ruLs       zWorksheet._write_data_bar_extcCsŒg}|ddkrd|dfg}| d¡r| d¡| d¡r#| d¡| d|¡t|dƒD]}| |d |d |d ¡q/| d¡dS) Nr-rbr[r4rzr?)r§r rFr"rBrè)r–rwrxÚreversedrwr{)r&ror…Úiconr,r,r-rv^s      zWorksheet._write_icon_setcCs>d|fg}|dur| d|f¡|r| d¡| d|¡dS)Nr"rç)ZgterZcfvor])r&Zcf_typerçrèr…r,r,r-rwts  zWorksheet._write_cfvocCs||fg}| d|¡dSrürDrýr,r,r-rñ€rYzWorksheet._write_colorcCs|jD]}|j|ŽqdSre)rlÚ_write_selection)r&Ú selectionr,r,r-r†s  ÿzWorksheet._write_selectionscCsJg}|r | d|f¡|r| d|f¡|r| d|f¡| d|¡dS)NrËZ activeCellrÍr‚r])r&rËrÌrÍr…r,r,r-r‹szWorksheet._write_selectioncCs:|j}t|ƒs dS|ddkr|j|ŽdS|j|ŽdS)Nrärb)rpr-Ú_write_split_panesÚ_write_freeze_panes)r&rpr,r,r-ršs  zWorksheet._write_panescCsJg}|}|}t||ƒ} d} d} d} d} |jr!|jd\}} } g|_|rM|rMd} t|dƒ}td|ƒ}|j d||g¡|j d||g¡|j d| | g¡n|r[d} |j d| | g¡n d} |j d| | g¡|dkrmd} n |dkrtd} nd } |r| d |f¡|rˆ| d |f¡| d | f¡| d | f¡| d| f¡| d|¡dS)NrMrÚ bottomRightÚtopRightÚ bottomLeftÚfrozenr Z frozenSplitr3ÚxSplitÚySplitrÚ activePaneÚstaterË)rrlrwrì)r&rr<rÒrÓrÔr…Úy_splitÚx_splitrorqrŒrÌrÍr>Úrow_cellÚcol_cellr,r,r-r„¦sH   zWorksheet._write_freeze_panescCs¢g}d}d}d} d} |} |} |jr|jd\} } } g|_d}| r(td| dƒ} | r/| | ¡} ||krS||krStd| dddƒ}td| ddd d d ƒ}t||ƒ}|s^|} |} |rŠ|rŠd }t|dƒ}td|ƒ}|j d ||g¡|j d||g¡|j d | | g¡n|r˜d }|j d | | g¡n d}|j d| | g¡| r®| dd| f¡| r¹| dd| f¡| d|f¡|rÉ| d|f¡| d|¡dS)NrrMr rTi,r:rSé†rNrärVr…r†r‡r‰rrŠrr‹rË)rlr$Ú_calculate_x_split_widthrrwrì)r&rr<rÒrÓrÔr…Z has_selectionrqrÌrÍrrŽr>rorrr,r,r-rƒÞsT     zWorksheet._write_split_panescCsZd}d}|dkrt|||dƒ}n t||dƒ|}|dd}|d}|d}|S) Nr¾rËr r:rNrärTr‘)r$)r&r¿r«r¬r­ZpointsZtwipsr,r,r-r’%s z"Worksheet._calculate_x_split_widthcCs^|j}t|ƒ}|s dSd|fg}| d|¡|D]}|jd7_| |j¡q| d¡dS)NrZ tablePartsr )rÕr-rxrÈÚ_write_table_partr{)r&rÕrr…r>r,r,r-rb<sþÿ zWorksheet._write_table_partscCs&dt|ƒ}d|fg}| d|¡dS)NrMrNZ tablePartr_rar,r,r-r“Us þÿzWorksheet._write_table_partcCsPt|jƒ}t|jƒ}|s|sdS| d¡|r| ¡|r!| ¡| d¡dS)Nr|)r-rãrÖrxÚ_write_ext_list_data_barsÚ_write_ext_list_sparklinesr{)r&Z has_data_barsZhas_sparklinesr,r,r-rccs   zWorksheet._write_ext_listcCsB| d¡| d¡|jD]}| |¡q | d¡| d¡dS)Nz&{78C0D931-6437-407d-A8EE-F0AAD7539E65}zx14:conditionalFormattingsr})r~rxrãÚ"_write_conditional_formatting_2010r{)r&rXr,r,r-r”vs     z#Worksheet._write_ext_list_data_barscCsìd}d|fg}| d|¡| |¡| |¡| |d|d¡| |d|d¡|ds6| |d ¡|d sA| |d ¡|dsP|d sP| |d ¡|ddkr]| |d¡| d¡| d¡|  d|d¡| d¡dS)Nú3http://schemas.microsoft.com/office/excel/2006/mainúxmlns:xmzx14:conditionalFormattingrorCrqrGrBr<r1r3r>r8rArýr9ú x14:dataBarú x14:cfRuleúxm:sqrefrU) rxÚ_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_colorr{rz)r&rXÚxmlns_xmr…r,r,r-r–„s,    ÿþ   z,Worksheet._write_conditional_formatting_2010cCs,d}|d}d|fd|fg}| d|¡dS)NrYr{r"r†rš©rx)r&rXÚ rule_typer{r…r,r,r-rœ±szWorksheet._write_x14_cf_rulecCsÐd}d}d|fd|fg}|ds| d¡|dr| d¡|d d kr)| d ¡|d d kr4| d ¡|dr=| d¡|dsJ|dsJ| d¡|ddkrU| d¡|ddkr`| d¡| d|¡dS)NrrRrxryrB)Úborderr r.)Zgradientrr0r)r\Z leftToRightr )r\rr1)ZnegativeBarColorSameAsPositiver r>)Z$negativeBarBorderColorSameAsPositiverrAÚmiddle)Ú axisPositionr§rý)r¨rýr™)rwrx)r&rXr2r=r…r,r,r-r¹s2þ       ÿþ     zWorksheet._write_x14_data_barcCsHd|fg}|dvr| d|¡dS| d|¡| d|¡| d¡dS)Nr")rjrkrnrpzx14:cfvoúxm:f)rìrxrzr{)r&r¥rBr…r,r,r-ržàs   zWorksheet._write_x14_cfvocCrX)NrÙzx14:borderColorrD©r&rÙr…r,r,r-rŸëó z!Worksheet._write_x14_border_colorcCrX)NrÙzx14:negativeFillColorrDrªr,r,r-r ðr«z(Worksheet._write_x14_negative_fill_colorcCrX)NrÙzx14:negativeBorderColorrDrªr,r,r-r¡õr«z*Worksheet._write_x14_negative_border_colorcCrX)NrÙz x14:axisColorrDrªr,r,r-r¢úr«zWorksheet._write_x14_axis_colorcCsÚ| d¡| ¡t|jƒD]R}| |¡| |d¡| |d¡| ¡| |d¡|  |d¡|  |d¡|  |d¡|  |d¡|d rV|  d |d ¡| |¡| d ¡q| d ¡| d ¡dS)Nz&{05C60535-1F16-4fd2-B633-F4F36F0B64E0}r¨r²r©r´r¯r¥r¢rªr©úx14:sparklineGroupúx14: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_lowrzÚ_write_sparklinesr{)r&rÅr,r,r-r•ÿs$     z$Worksheet._write_ext_list_sparklinescCsn| d¡t|dƒD]$}|d|}|d|}| d¡| d|¡| d|¡| d¡q | d¡dS)Nzx14:sparklinesrr¸r z x14:sparkliner©r›)rxrUrzr{)r&rÅrrÇr£r,r,r-r¸- s       zWorksheet._write_sparklinescCs,d}|d}d|fd|fg}| d|¡dS)Nz$http://schemas.microsoft.com/office/zspreadsheetml/2009/9/mainz xmlns:x14Úurir}r¤)r&r¹r Z xmlns_x14r…r,r,r-r~> s þzWorksheet._write_extcCsd}d|fg}| d|¡dS)Nr—r˜r­r¤)r&r£r…r,r,r-r®J s z!Worksheet._write_sparkline_groupscCsæ| d¡}g}| d¡dur&|ddkrd|d<n | d|df¡d|d<| d¡durE|ddkr8d|d<n | d |df¡d|d<|d d krT| d |d f¡| d ¡rb| d |d f¡| d¡rl| d¡|ru| d|f¡| d¡r| d¡| d¡r‰| d¡| d¡r“| d¡| d¡r| d¡| d¡r§| d¡| d¡r±| d¡| d¡r»| d¡| d¡rÅ| d ¡| d¡rÓ| d!|df¡| d¡rá| d"|df¡| d#¡rë| d$¡| d%|¡dS)&NrÀrkrrZcust_maxZ manualMaxrrjZcust_minZ manualMinr"rµr®Z lineWeightrª)ZdateAxisr ZdisplayEmptyCellsAsr«)r«r rº)rºr r»)r»r r½)r½r r¾)r¾r r¼)r¼r r±)Z displayXAxisr rm)Z displayHiddenr Z minAxisTypeZ maxAxisTyper§rr¬)r–rwrx)r&r›rÀr…r,r,r-r¯R sV                             z Worksheet._write_sparkline_groupcCshg}| d¡r| d|df¡| d¡r| d|df¡| d¡r,| d|df¡| ||¡dS)NrÙrèZtint)r–rwrì)r&Úelementrßr…r,r,r-Ú_write_spark_color« s   zWorksheet._write_spark_colorcCó| d|¡dS)Nzx14:colorSeries©r»rÞr,r,r-r°º rfzWorksheet._write_color_seriescCr¼)Nzx14:colorNegativer½rÞr,r,r-r±¾ rfzWorksheet._write_color_negativecCs| dddi¡dS)Nz x14:colorAxisrÙZFF000000r½rþr,r,r-r² szWorksheet._write_color_axiscCr¼)Nzx14:colorMarkersr½rÞr,r,r-r³Æ rfzWorksheet._write_color_markerscCr¼)Nzx14:colorFirstr½rÞr,r,r-r´Ê rfzWorksheet._write_color_firstcCr¼)Nz x14:colorLastr½rÞr,r,r-rµÎ rfzWorksheet._write_color_lastcCr¼)Nz x14:colorHighr½rÞr,r,r-r¶Ò rfzWorksheet._write_color_highcCr¼)Nz x14:colorLowr½rÞr,r,r-r·Ö rfzWorksheet._write_color_lowcCsddg}| d|¡dS)N)ZfontIdÚ0)r"Z noConversionZ phoneticPrrDrr,r,r-rQÚ sþzWorksheet._write_phonetic_prcCsT|jsdS| d¡|j d¡r|jd}| d|¡|j d¡r,|jd}| d|¡|j d¡r=|jd}| d|¡|j d¡rN|jd}| d |¡|j d ¡r_|jd }| d |¡|j d ¡rp|jd }| d |¡|j d¡r|jd}| d|¡|j d¡r’|jd}| d|¡|j d¡r£|jd}| d|¡| d¡dS)NZ ignoredErrorsr5ZnumberStoredAsTextr0Z evalErrorr2rAr/Z formulaRanger7ZunlockedFormular1ZemptyCellReferencer4ZlistDataValidationr3ZcalculatedColumnr6ZtwoDigitTextYear)rúrxr–Ú_write_ignored_errorr{)r&Ú ignored_ranger,r,r-r]ã s>                            zWorksheet._write_ignored_errorscCs d|f|dfg}| d|¡dS)NrÍr Z ignoredErrorrD)r&r"rÀr…r,r,r-r¿!sþzWorksheet._write_ignored_errorre)Nr)F)NrrK)NNN)NF)rr)r r r r)NNr)NN)rR)rMN)r )rOrOrPrP)rMNN)FF)r)ðrÎÚ __module__Ú __qualname__Ú__doc__rZrr0rrr'rr5r r>rrCrr9rPrGrIrHrXr r\rr`r rpror‡rŠrŒrr¤r¦r©r«r­r¯r²r³r´r¶r¸rºr»r@rÂrÄrÖrØrÚrÛrÝrárìrçr*r{rŸrÉrÎrÏrÑrÕrØrÛrÜrÝràrôrørûrýrÿrrrrrr rrrrrr!r"r#r$r%r&r(r)r,r-r.r8rErdr,rYrÞrhrårærlròr–r˜r›rœrr‰ržr©rªrÃrÙr¿rùrÉrÊrÍr–rÄrÛr%rnrŒr™ryrïrðróròrÿrrsrGrIrJrrKrLrrMrNrXrYrWrZr#r$rr/r'r(r*r)r7r6rHr=r;r<r[r\r@rSrFrVrIrJrRrRrSrTrWrUr[rOrPr\r^r^r_r`rarUrcrfrgrTrlrnrqrsrtrurvrwrñrrrr„rƒr’rbr“rcr”r–rœrržrŸr r¡r¢r•r¸r~r®r¯r»r°r±r²r³r´rµr¶r·rQr]r¿Ú __classcell__r,r,rÿr-rKÂsL [% P     ø,ø -> ÷6   k y<=3F#  ÿ@ÿ  = ÿK  <*ÿM@ " ÿ   3#      M M     /, d!(!Xw_<D `   I3 5   6      F  # ;  ( D  N    ( %/3  v          Oÿÿ         0    M  l       8 G      -  '     .   Y          -rK)>rr9r—r r@Ú collectionsrrrÿrÚ fractionsrÚ functoolsrÚiorr r Úwarningsr rMr rDrrØrr~rrZutilityrrrrrrrrrrrrrÚ exceptionsr r!rjÚVERBOSErEr0r9r@r0r;r?r]rJrZrTr~r rKr,r,r,r-Úsj                              á(     ÿ