o öÑÐbZ*ã@s¾ddlZddlZddlZddlZddlZddlZddlmZddlmZddl m Z ddl m Z ddl m Z ddlmZdd lmZdd lmZmZdd lmZdd lmZdd lmZddlmZddlmZddlmZddlmZddlmZddlm Z ddlm!Z!ddlm"Z"ddlm#Z#ddlm$Z$ddlm%Z%ddlm&Z&ddl'm(Z(dd„Z)dd„Z*dd „Z+ed!d"ƒZ,ed#d$ƒZ-ed%d&ƒZ.ed'd(ƒZ/ed)d*ƒZ0ed+d,ƒZ1Gd-d.„d.ejƒZ2dS)/éN)Ú defaultdict)Ú namedtuple)Úisnan)Úisinf)Úwarné)ÚStringIO)Ú force_unicode)Ú num_typesÚ str_types)Ú xmlwriter)ÚFormat)ÚDrawing)ÚShape)Ú XMLwriter)Úxl_rowcol_to_cell)Úxl_rowcol_to_cell_fast)Úxl_cell_to_rowcol)Úxl_col_to_name)Úxl_range©Úxl_color)Úget_sparkline_style)Úsupported_datetime)Údatetime_to_excel_datetime)Úquote_sheetname)ÚDuplicateTableNamecó‡fdd„}|S)zn Decorator function to convert A1 notation in cell method calls to the default row/col notation. cs^zt|ƒr |d}t|ƒWnty#t|ƒ}||dd…}Ynwˆ|g|¢Ri|¤ŽS©Nrr)ÚlenÚintÚ ValueErrorr)ÚselfÚargsÚkwargsZ first_argÚnew_args©Úmethod©úS/var/www/secure340b-portal/env/lib/python3.10/site-packages/xlsxwriter/worksheet.pyÚ cell_wrapper9s€ ýz'convert_cell_args..cell_wrapperr(©r'r*r(r&r)Úconvert_cell_args3s r,cr)zo Decorator function to convert A1 notation in range method calls to the default row/col notation. c s¶z t|ƒr t|dƒWnCtyOd|dvr/|d d¡\}}t|ƒ\}}t|ƒ\}}n t|dƒ\}}||}}||||g} |  |dd…¡| }Ynwˆ|g|¢Ri|¤ŽS)Nrú:r©rr r!ÚsplitrÚextend) r"r#r$Úcell_1Úcell_2Zrow_1Úcol_1Zrow_2Úcol_2r%r&r(r)r*Ps  €     ôz(convert_range_args..cell_wrapperr(r+r(r&r)Úconvert_range_argsJs r5cr)zq Decorator function to convert A1 notation in columns method calls to the default row/col notation. c s”z t|ƒr t|dƒWn2ty>dd„|d d¡Dƒ\}}t|ƒ\}}t|ƒ\}}||g}| |dd…¡|}Ynwˆ|g|¢Ri|¤ŽS)NrcSsg|]}|d‘qS)Ú1r()Ú.0Úcolr(r(r)Ú wsz?convert_column_args..column_wrapper..r-rr.) r"r#r$r1r2Ú_r3r4r%r&r(r)Úcolumn_wrapperos €   ù z+convert_column_args..column_wrapperr()r'r;r(r&r)Úconvert_column_argsis r<ÚStringzstring, formatÚNumberznumber, formatÚBlankÚformatÚBooleanzboolean, formatÚFormulazformula, format, valueÚ ArrayFormulaz$formula, format, value, range, atypecsb 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!„Z  "dÑd#d$„ZedÏd%d&„ƒZdÏd'd(„ZedÏd)d*„ƒZdÏd+d,„Ze dÒd-d.„ƒZ dÒd/d0„Zed1d2„ƒZd3d4„Zd5d6„ZedÏd7d8„ƒZedÏd9d:„ƒZ edÏd;d<„ƒZ!edÏd=d>„ƒZ"edÏd?d@„ƒZ#edÏdAdB„ƒZ$dCdD„Z%dÓdFdG„Z&dHdI„Z'dJdK„Z(dLdM„Z)dNdO„Z*dPdQ„Z+dRdS„Z,e- dÒdTdU„ƒZ.e- dÒdVdW„ƒZ/dÒdXdY„Z0dÒdZd[„Z1dÔd\d]„Z2e dÏd^d_„ƒZ3ed`da„ƒZ4dbdc„Z5ddde„Z6e dÏdfdg„ƒZ7e dÏdhdi„ƒZ8e dÏdjdk„ƒZ9edÏdldm„ƒZ:edndo„ƒZ; p dÕdqdr„ZdØdxdy„Z?dzd{„Z@d|d}„ZAd~d„ZBdÙdd‚„ZCd×dƒd„„ZDedÏd…d†„ƒZEd‡dˆ„ZFd‰dŠ„ZGd‹dŒ„ZHddŽ„ZIdd„ZJd‘d’„ZKdÚd•d–„ZLdÛd—d˜„ZMdÛd™dš„ZNdÏd›dœ„ZOe-dÏddž„ƒZPdÜdŸd „ZQd¡d¢„ZRd£d¤„ZSed¥d¦„ƒZTd§d¨„ZUd©dª„ZVd«d¬„ZWd­d®„ZXd¯d°„ZYd±d²„ZZdÏd³d´„Z[dÏdµd¶„Z\d·d¸„Z]d¹dº„Z^dÝd»d¼„Z_d½d¾„Z`d¿dÀ„ZadÁd„ZbdÃdÄ„ZcdÅdÆ„ZddÇdÈ„ZedÉdÊ„ZfdËdÌ„ZgdÍd΄ZhdÏdЄZidÑdÒ„ZjdÓdÔ„ZkdÕdÖ„Zld×dØ„ZmdÞdÙdÚ„ZndÞdÛdÜ„ZodÝdÞ„Zpdßdà„Zqdádâ„Zrdãdä„Zsdådæ„Ztdçdè„Zudédê„Zvdëdì„Zwdídî„Zxdïdð„Zydñdò„Zzdódô„Z{dÏdõdö„Z|dÏd÷dø„Z}dùdú„Z~dûdü„Zdýdþ„Z€dÿd„Zdd„Z‚dd„Zƒdd„Z„dÏdd„Z…d d „Z†d d „Z‡d d„Zˆdd„Z‰dd„ZŠ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)d*„Z–d+d,„Z—dÔd-d.„Z˜dÏd/d0„Z™d1d2„Zšd3d4„Z›d5d6„Zœd7d8„Zd9d:„Zžd;d<„ZŸd=d>„Z d?d@„Z¡dAdB„Z¢dCdD„Z£dEdF„Z¤dGdH„Z¥dIdJ„Z¦ dÒdKdL„Z§ dÒdMdN„Z¨dOdP„Z©dQdR„ZªdSdT„Z«dUdV„Z¬dWdX„Z­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…d†„ZÄd‡dˆ„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Î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è‡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|_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|_?g|_@g|_Ai|_Bg|_Cd|_Di|_EtFtGƒ|_Hd|_Id |_Jd|_Kd|_Ld |_Md|_Nd|_Od|_Pd|_Qd |_Rd |_Sd |_Td|_Ud|_Vd|_Wd|_Xd|_Yd|_Zd|_[i|_\g|_]tFtGƒ|_^g|__i|_`d|_ad|_bd|_ctFtGƒ|_dg|_ed |_fd|_gd|_hg|_id|_jd |_kd|_lg|_md|_ni|_oi|_pi|_qi|_ri|_sd|_td|_ud |_vd|_wd|_xg|_yg|_zg|_{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|_˜tFtGƒ|_™d|_šd |_›d|_œd |_d|_žd|_Ÿd|_ d|_¡d|_¢d|_£d|_¤d|_¥d|_hd|_¢d|_£d|_¦d|_§d|_¨i|_©d|_ªd|_«d|_¬dS)z Constructor. NrFi×ii@éÿérTÚçffffffæ?çè?ç333333Ó?édééç\Âõ(Ü @é@éi)­ÚsuperrDÚ__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ÚcolinfoÚ selectionsÚhiddenÚactiveÚ tab_colorÚ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_orderZ 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_row_zeroedÚnamesZ write_matchÚtableÚmergeÚ 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Ú col_sizesÚ row_sizesÚ col_formatsÚ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©r"©Ú __class__r(r)rR¢sX     zWorksheet.__init__cGsf|dkr|j||g|¢RŽS|jr | d¡r |j||g|¢RŽS| d¡r4| d¡r4|j||g|¢RŽSd|vrq|jrKt d|¡rK|j||g|¢RŽS|jr^t d|¡r^|j||g|¢RŽS|jrqt d|¡rq|j||g|¢RŽS|j r©z!t |ƒ}|j s„t |ƒs”t |ƒs”|j|||g|d d…¢RŽWSWn tyžYnw|j||g|¢RŽS|j||g|¢RŽS) NrGú=z{=Ú}r-ú(ftp|http)s?://úmailto:z(in|ex)ternal:r)Ú _write_blankrâÚ startswithÚ_write_formulaÚendswithràÚreÚmatchÚ _write_urlrßÚfloatrárrÚ _write_numberr!Ú _write_string)r"ÚtokenÚrowr8r#Úfr(r(r)Ú_write_token_as_stringxs8ÿÿ € þ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"rr8r#r(r(r)Úwrite›szWorksheet.writec GsLt|ƒstdƒ‚|d}t|ƒ}||jvr+|j|}||||g|¢RŽ}|dur)n|S|dur9|j||g|¢RŽS|turG|j||g|¢RŽS|tvrU|j||g|¢RŽS|t urd|j |||g|¢RŽS|t j t j t j t jfvrz|j||g|¢RŽStjdkr|turz|j t |ƒ||g|¢RŽWSttfyœYnwt|tƒ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öYntytdt|ƒƒ‚wzt |ƒ|j||g|¢RŽWSty%tdt|ƒƒ‚w)Nz,write() takes at least 4 arguments (3 given)r)rFrrrzUnsupported type %s in write())rÚ TypeErrorÚtyperîrùÚboolÚ_write_booleanr rÚstrrÚdatetimeÚdateÚtimeÚ timedeltaÚ_write_datetimeÚsysÚ version_infoÚunicodeÚUnicodeEncodeErrorÚ NameErrorÚ isinstancer rrr!r) r"rr8r#rÚ token_typeZ write_handlerZfunction_returnrr(r(r)r ¯sr  ý  ÿ ÿÿ     ÿÿ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"rr8ÚstringÚ cell_formatr(r(r)Ú write_stringózWorksheet.write_stringcCs~d}| ||¡r dSt|ƒ|jkr|d|j…}d}|js$|j |¡}n|}|jr3||jkr3| |¡t||ƒ|j ||<|S©Nréÿÿÿÿéþÿÿÿ) Ú_check_dimensionsrr^rWrUÚ_get_shared_string_indexrÕÚ_write_single_rowÚcell_string_tupler¥)r"rr8rrÚ str_errorÚ string_indexr(r(r)rs  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"rr8Únumberrr(r(r)Ú write_number5ózWorksheet.write_numbercCs–t|ƒst|ƒr*|jr&t|ƒr| ||d|d¡St|ƒr%| ||d|d¡Sntdƒ‚| ||¡r2dS|jr?||jkr?| |¡t ||ƒ|j ||<dS)Nú#NUM!z1/0ú#DIV/0!zUNAN/INF not supported in write_number() without 'nan_inf_to_errors' Workbook() optionr#r) rrrárûr r%rWrÕr'Úcell_number_tupler¥r+r(r(r)rHs( ÿ ÿÿÿ  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"rr8Úblankrr(r(r)Ú write_blankdr!zWorksheet.write_blankcCsL|durdS| ||¡rdS|jr||jkr| |¡t|ƒ|j||<dS)Nrr#)r%rWrÕr'Úcell_blank_tupler¥r2r(r(r)rùxs  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"rr8ÚformularÚvaluer(r(r)Ú write_formulaŠszWorksheet.write_formulac Cs:| ||¡rdS|dus|dkrtdƒdSt d|¡s^t d|¡s^t d|¡s^t d|¡s^t d|¡s^t d |¡s^t d |¡s^t d |¡s^t d |¡s^t d |¡s^t d|¡s^t d|¡ri| |||||||¡S| d¡r~| d¡r~| |||||||¡S| |¡}|j r||j kr|  |¡t |||ƒ|j ||<dS)Nr#rGzFormula can't be None or emptyú\bSORT\(ú\bLET\(ú \bLAMBDA\(ú \bSINGLE\(ú \bSORTBY\(ú \bUNIQUE\(ú \bXMATCH\(ú \bFILTER\(ú \bXLOOKUP\(ú \bSEQUENCE\(ú \bRANDARRAY\(ú\bANCHORARRAY\(Ú{rör)r%rrýÚsearchÚwrite_dynamic_array_formularúrüÚ_write_array_formulaÚ_prepare_formularWrÕr'Úcell_formula_tupler¥r6r(r(r)rû sR   ÿ þ ý ü û ú ù ø ÷ ö õ þÿ  zWorksheet._write_formulac Cs¾t d|¡sHt d|¡sHt d|¡sHt d|¡sHt d|¡sHt d|¡sHt d|¡sHt d|¡sHt d |¡sHt d |¡sHt d |¡sHt d |¡rS| |||||||¡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. r:r;r<r=r>r?r@rArBrCrDrEÚstatic)rýrGrHrI)r"Ú first_rowÚ first_colÚlast_rowÚlast_colr7rr8r(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)rIrð) r"rMrNrOrPr7rr8Úerrorr(r(r)rHôs þz%Worksheet.write_dynamic_array_formulacCs | 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|¡}|js€|St 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@|¡}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 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 |¡}|S( NrFrrõrör#z_xlfn.r;z _xlfn.LET(r<z _xlfn.LAMBDA(r=z _xlfn.SINGLE(r>z _xlfn.SORTBY(r?z _xlfn.UNIQUE(r@z _xlfn.XMATCH(r:z_xlfn._xlws.SORT(rBz_xlfn.XLOOKUP(rCz_xlfn.SEQUENCE(rAz_xlfn._xlws.FILTER(rDz_xlfn.RANDARRAY(rEz_xlfn.ANCHORARRAY(z\bCOT\(z _xlfn.COT(z\bCSC\(z _xlfn.CSC(z\bIFS\(z _xlfn.IFS(z\bPHI\(z _xlfn.PHI(z\bRRI\(z _xlfn.RRI(z\bSEC\(z _xlfn.SEC(z\bXOR\(z _xlfn.XOR(z\bACOT\(z _xlfn.ACOT(z\bBASE\(z _xlfn.BASE(z\bCOTH\(z _xlfn.COTH(z\bCSCH\(z _xlfn.CSCH(z\bDAYS\(z _xlfn.DAYS(z\bIFNA\(z _xlfn.IFNA(z\bSECH\(z _xlfn.SECH(z \bACOTH\(z _xlfn.ACOTH(z \bBITOR\(z _xlfn.BITOR(z \bF.INV\(z _xlfn.F.INV(z \bGAMMA\(z _xlfn.GAMMA(z \bGAUSS\(z _xlfn.GAUSS(z \bIMCOT\(z _xlfn.IMCOT(z \bIMCSC\(z _xlfn.IMCSC(z \bIMSEC\(z _xlfn.IMSEC(z \bIMTAN\(z _xlfn.IMTAN(z \bMUNIT\(z _xlfn.MUNIT(z \bSHEET\(z _xlfn.SHEET(z \bT.INV\(z _xlfn.T.INV(z \bVAR.P\(z _xlfn.VAR.P(z \bVAR.S\(z _xlfn.VAR.S(z \bARABIC\(z _xlfn.ARABIC(z \bBITAND\(z _xlfn.BITAND(z \bBITXOR\(z _xlfn.BITXOR(z \bCONCAT\(z _xlfn.CONCAT(z \bF.DIST\(z _xlfn.F.DIST(z \bF.TEST\(z _xlfn.F.TEST(z \bIMCOSH\(z _xlfn.IMCOSH(z \bIMCSCH\(z _xlfn.IMCSCH(z \bIMSECH\(z _xlfn.IMSECH(z \bIMSINH\(z _xlfn.IMSINH(z \bMAXIFS\(z _xlfn.MAXIFS(z \bMINIFS\(z _xlfn.MINIFS(z \bSHEETS\(z _xlfn.SHEETS(z \bSKEW.P\(z _xlfn.SKEW.P(z \bSWITCH\(z _xlfn.SWITCH(z \bT.DIST\(z _xlfn.T.DIST(z \bT.TEST\(z _xlfn.T.TEST(z \bZ.TEST\(z _xlfn.Z.TEST(z \bCOMBINA\(z_xlfn.COMBINA(z \bDECIMAL\(z_xlfn.DECIMAL(z \bRANK.EQ\(z_xlfn.RANK.EQ(z \bSTDEV.P\(z_xlfn.STDEV.P(z \bSTDEV.S\(z_xlfn.STDEV.S(z \bUNICHAR\(z_xlfn.UNICHAR(z \bUNICODE\(z_xlfn.UNICODE(z \bBETA.INV\(z_xlfn.BETA.INV(z \bF.INV.RT\(z_xlfn.F.INV.RT(z \bNORM.INV\(z_xlfn.NORM.INV(z \bRANK.AVG\(z_xlfn.RANK.AVG(z \bT.INV.2T\(z_xlfn.T.INV.2T(z \bTEXTJOIN\(z_xlfn.TEXTJOIN(z \bAGGREGATE\(z_xlfn.AGGREGATE(z \bBETA.DIST\(z_xlfn.BETA.DIST(z \bBINOM.INV\(z_xlfn.BINOM.INV(z \bBITLSHIFT\(z_xlfn.BITLSHIFT(z \bBITRSHIFT\(z_xlfn.BITRSHIFT(z \bCHISQ.INV\(z_xlfn.CHISQ.INV(z \bF.DIST.RT\(z_xlfn.F.DIST.RT(z \bFILTERXML\(z_xlfn.FILTERXML(z \bGAMMA.INV\(z_xlfn.GAMMA.INV(z \bISFORMULA\(z_xlfn.ISFORMULA(z \bMODE.MULT\(z_xlfn.MODE.MULT(z \bMODE.SNGL\(z_xlfn.MODE.SNGL(z \bNORM.DIST\(z_xlfn.NORM.DIST(z \bPDURATION\(z_xlfn.PDURATION(z \bT.DIST.2T\(z_xlfn.T.DIST.2T(z \bT.DIST.RT\(z_xlfn.T.DIST.RT(z\bBINOM.DIST\(z_xlfn.BINOM.DIST(z\bCHISQ.DIST\(z_xlfn.CHISQ.DIST(z\bCHISQ.TEST\(z_xlfn.CHISQ.TEST(z\bEXPON.DIST\(z_xlfn.EXPON.DIST(z\bFLOOR.MATH\(z_xlfn.FLOOR.MATH(z\bGAMMA.DIST\(z_xlfn.GAMMA.DIST(z\bISOWEEKNUM\(z_xlfn.ISOWEEKNUM(z\bNORM.S.INV\(z_xlfn.NORM.S.INV(z\bWEBSERVICE\(z_xlfn.WEBSERVICE(z\bERF.PRECISE\(z_xlfn.ERF.PRECISE(z\bFORMULATEXT\(z_xlfn.FORMULATEXT(z\bLOGNORM.INV\(z_xlfn.LOGNORM.INV(z\bNORM.S.DIST\(z_xlfn.NORM.S.DIST(z\bNUMBERVALUE\(z_xlfn.NUMBERVALUE(z\bQUERYSTRING\(z_xlfn.QUERYSTRING(z\bCEILING.MATH\(z_xlfn.CEILING.MATH(z\bCHISQ.INV.RT\(z_xlfn.CHISQ.INV.RT(z\bCONFIDENCE.T\(z_xlfn.CONFIDENCE.T(z\bCOVARIANCE.P\(z_xlfn.COVARIANCE.P(z\bCOVARIANCE.S\(z_xlfn.COVARIANCE.S(z\bERFC.PRECISE\(z_xlfn.ERFC.PRECISE(z\bFORECAST.ETS\(z_xlfn.FORECAST.ETS(z\bHYPGEOM.DIST\(z_xlfn.HYPGEOM.DIST(z\bLOGNORM.DIST\(z_xlfn.LOGNORM.DIST(z\bPERMUTATIONA\(z_xlfn.PERMUTATIONA(z\bPOISSON.DIST\(z_xlfn.POISSON.DIST(z\bQUARTILE.EXC\(z_xlfn.QUARTILE.EXC(z\bQUARTILE.INC\(z_xlfn.QUARTILE.INC(z\bWEIBULL.DIST\(z_xlfn.WEIBULL.DIST(z\bCHISQ.DIST.RT\(z_xlfn.CHISQ.DIST.RT(z\bFLOOR.PRECISE\(z_xlfn.FLOOR.PRECISE(z\bNEGBINOM.DIST\(z_xlfn.NEGBINOM.DIST(z\bPERCENTILE.EXC\(z_xlfn.PERCENTILE.EXC(z\bPERCENTILE.INC\(z_xlfn.PERCENTILE.INC(z\bCEILING.PRECISE\(z_xlfn.CEILING.PRECISE(z\bCONFIDENCE.NORM\(z_xlfn.CONFIDENCE.NORM(z\bFORECAST.LINEAR\(z_xlfn.FORECAST.LINEAR(z\bGAMMALN.PRECISE\(z_xlfn.GAMMALN.PRECISE(z\bPERCENTRANK.EXC\(z_xlfn.PERCENTRANK.EXC(z\bPERCENTRANK.INC\(z_xlfn.PERCENTRANK.INC(z\bBINOM.DIST.RANGE\(z_xlfn.BINOM.DIST.RANGE(z\bFORECAST.ETS.STAT\(z_xlfn.FORECAST.ETS.STAT(z\bFORECAST.ETS.CONFINT\(z_xlfn.FORECAST.ETS.CONFINT(z\bFORECAST.ETS.SEASONALITY\(z_xlfn.FORECAST.ETS.SEASONALITY()rúrürýÚsubrñ©r"r7r(r(r)rJsL      ÿÿÿÿÿÿÿÿÿÿÿÿzWorksheet._prepare_formularLc 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#r-rr) r%rrJrWrÕr'Úcell_arformula_tupler¥Úranger) r"rMrNrOrPr7rr8ÚatypeÚ cell_rangerr8r(r(r)rI¼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"rr8rrr(r(r)Úwrite_datetimeêr.zWorksheet.write_datetimecCsZ| ||¡rdS|jr||jkr| |¡| |¡}|dur!|j}t||ƒ|j||<dS)Nr#r)r%rWrÕr'Ú_convert_date_timerãr1r¥)r"rr8rrr,r(r(r)rýs   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"rr8Úbooleanrr(r(r)Ú write_booleanr.zWorksheet.write_booleancCsP| ||¡rdS|jr||jkr| |¡|rd}nd}t||ƒ|j||<dS)Nr#rr)r%rWrÕr'Úcell_boolean_tupler¥)r"rr8r\rr8r(r(r)r&s  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"rr8ÚurlrrÚtipr(r(r)Ú write_urlBszWorksheet.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´tdt |ƒ| fƒdS|j d7_ |j dkrÊtdt |ƒƒdS|jr×||jkr×| |¡|durÞ|j}| ||||¡||| |dœ|j||<| S)Nr#rú internal:rGéFú external:ú/ú\TrørzFIgnoring 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úÚreplacerr^rr/Ú _escape_urlrýrþrTrær r¾rWrÕr'rärrÞ) r"rr8r_rrr`rmZexternalr)Zurl_strZ tmp_url_strZmax_urlr(r(r)rÿYsp              þ ÿ ü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_stringr r(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]I} t| tƒsp| dkrW|   | ¡|   | ¡n|   | ¡| dkrgt dƒd S|t | ƒ7}d } n| dkr| dkrt d ƒd S|   | ¡d} | d 7} qAt| dtƒs˜|j  d¡| D]4} t| tƒr­|j  d¡|  | ¡qšg}t d| ¡s»t d| ¡rÀ|  d¡|j d| |¡|j d¡qš|jj ¡}||jkràt dƒdS|jsê|j |¡}n|}|jrù||jkrù| |¡t||ƒ|j||<dS)Nrr#r@rczfYou must specify more than 2 format/fragments for rich strings. Ignoring input in write_rich_string().éûÿÿÿrGzYExcel doesn't allow empty strings in rich strings. Ignoring input in write_rich_string().rlrzaExcel doesn't allow 2 consecutive formats in rich strings. Ignoring input in write_rich_string().rkrÚrú^\sú\s$)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%rr ÚpoprrrÔZ_set_filehandlerrÚappendÚ_xml_start_tagÚ _write_fontrýrGÚ_xml_data_elementÚ _xml_end_tagÚfhÚgetvaluer^rWrUr&rÕr'r(r¥)r"rr8r#ÚtokensrZ str_lengthr*rÚdefaultÚ fragmentsÚpreviousÚposrÚ attributesrr(r(r)rpØsr                  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_handlerHs 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. rrr©r"rr8ÚdatarrrSr(r(r)Ú write_rowWó  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. rrrr‰r(r(r)Ú write_columnnrŒzWorksheet.write_columncCs| ||dd¡rtd||fƒdS|duri}| dd¡}| dd¡}| dd ¡}| d d ¡}| d d¡} | d d¡} | d d¡} | dd¡} | dd¡} | dd¡}| d| ¡} | sltj |¡sltdt|ƒƒ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_positionrcÚ image_dataÚ descriptionÚ decorativeFZ positioningúImage file '%s' not found.) r%rÚgetÚosÚpathÚexistsr rÉrz)r"rr8ÚfilenameÚoptionsrŽrrr‘r_r`Úanchorr“r”r•r(r(r)Ú insert_image…s0            þzWorksheet.insert_imagec Csš| ||dd¡rtd||fƒdS|durd}|duri}| dd¡}| dd¡}| d d ¡}| d d ¡}| d d ¡} |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#NrGrŽrrrrr‘r’)r%rr—rÌrz) r"rr8ÚtextrœrŽrrr‘rr(r(r)Úinsert_textbox´s       ÿzWorksheet.insert_textboxc Csø| ||dd¡rtd||fƒdS|duri}|js"|jr(|jjr(tdƒdSd|_|jr2d|j_| dd¡}| dd¡}| d d ¡}| d d ¡}| d d ¡} |jd krX|j}|jd kr`|j}|jrf|j}|jrl|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.rŽrrrrr‘r’) r%rZalready_insertedÚcombinedr—rr‘rŽrrÈrz) r"rr8ÚchartrœrŽrrr‘rr(r(r)Ú insert_chartÙs@ ÿ        ý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$rr)r%rr^r¨rªr«)r"rr8Úcommentrœr(r(r)Ú write_comments zWorksheet.write_commentcCó d|_dS)z† Make any comments in the worksheet visible. Args: None. Returns: Nothing. rN)r®ròr(r(r)Ú show_comments:ó zWorksheet.show_commentsFcCs4|stj |¡stdt|ƒƒ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šrr rÓrÒ)r"r›Zis_byte_streamr(r(r)Úset_backgroundGs   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_authorZr¨zWorksheet.set_comments_authorcCs|jS)zw Retrieve the worksheet name. Args: None. Returns: Nothing. )rSròr(r(r)Úget_namegs 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. rrN)rerjrTréZ activesheetròr(r(r)ÚactivateuszWorksheet.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. rrN)rjreròr(r(r)Úselect‡s zWorksheet.selectcCr¯)zv Hide the current worksheet. Args: None. Returns: Nothing. rrN)rerjròr(r(r)Úhide˜s zWorksheet.hidecCsd|_|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)rerTréZ firstsheetròr(r(r)Úset_first_sheet«szWorksheet.set_first_sheetc Cs|duri}||kr||}}d}| dd¡}| dd¡}| dd¡} |s)|r,|r,d} nd} | d||| ¡r8dS| d||| ¡rBdS| dkrHd} | d krNd } | |jkrV| |_|||||| |g|jd |<d|_|durn|j}t||d ƒD]} ||g|j| <|r…||j| <qudS) 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. NTreFÚ collapsedÚlevelrr#éz%05dr) r—r%r˜rcr»r¡rWr¸rº) r"rNrPÚwidthrrœÚ ignore_rowrer³r´Ú ignore_colr8r(r(r)Ú set_column½sD      þ €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"rNrPr¶rrœr(r(r)Úset_column_pixelss   ÿzWorksheet.set_column_pixelsc CsÊ|duri}|jdur|j}nd}| ||¡rdS|dur |j}| dd¡}| dd¡}| dd¡}|dkr;d}|j}|dkrAd}|d krGd }||jkrO||_|||||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. Nrr#reFr³r´rrµT)rar%rŸr—r—r‘r¼r¹) r"rÚheightrrœZmin_colrer³r´r(r(r)Úset_row!s2      zWorksheet.set_rowcCs"|dur | |¡}| ||||¡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. N)Ú_pixels_to_heightr½)r"rr¼rrœr(r(r)Úset_row_pixels^s zWorksheet.set_row_pixelscCs6|dur|j}||jkrd|_||_|rd|_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)rŸržr¼r£)r"r¼Zhide_unused_rowsr(r(r)Úset_default_rowrs   ÿzWorksheet.set_default_rowc CsÒ||kr||krtdƒdS||kr||}}||kr ||}}| ||¡r(dS| ||¡r0dS|j ||||g¡| ||||¡t||dƒD]}t||dƒD]}||kr]||kr]qR| ||d|¡qRqIdS)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#rrGr)rr%r¦rzr rWrù) r"rMrNrOrPrŠrrr8r(r(r)Ú merge_range‰s(    ýzWorksheet.merge_rangecCs\||kr ||}}||kr||}}| ||||¡}t||||ƒ}||_||_||g|_dS)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. N)Ú_convert_name_arearr²r³r´)r"rMrNrOrPÚareaÚrefr(r(r)Ú autofilterÀs  ÿzWorksheet.autofiltercCs`|js tdƒdSzt|ƒWn!ty0|}t|dƒ\}}||jkr.td|ƒYdSYnw|j\}}||ks>||krItd|||fƒdS| |¡}t|ƒdks`t|ƒdks`td|ƒ|  ||¡}t|ƒd kr||d d kr||  ||d g¡n/t|ƒd kr¡|d d kr¡|d d kr¡|dd kr¡|  ||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()Nr6úInvalid column '%s'z6Column '%d' outside autofilter() column range (%d, %d)rFrµz+Incorrect number of tokens in criteria '%s'rcrréé)r²rr r!rr]r´Ú_extract_filter_tokensrÚ_parse_filter_expressionÚfilter_column_listr¶r·rµ)r"r8ÚcriteriaÚ col_letterr:Ú col_firstÚcol_lastrr(r(r)Ú filter_columnÞs@     þû ÿ   $ ÿ   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ÆNr6rÇz5Column '%d' outside autofilter() column range (%d,%d)r) r²rr r!rr]r´r¶r·rµ)r"r8ÚfiltersrÎr:rÏrÐr(r(r)rÌs,     þû ÿ   zWorksheet.filter_column_listc Cs| ||dd¡r dS| ||dd¡rdS|duri}n| ¡}idd“dd“dd“dd“dd“d d“d d“d d“d d“d d“dd“dd“dd“dd“dd“dd“}| ¡D]}||vrdtd|ƒdSqUd|vro|d|d<d|vry|d|d<d|vrƒtdƒdSdddddddddddddœ }|d|vr¢td |dƒdS||d|d<|ddkrÀ| d ¡durÀ| d¡durÀdS|ddksÒ|ddksÒ|ddkrÚd!|d<d|d <d|vrätd"ƒdSid!d!“d#d$“d%d&“d'd&“d(d&“d)d*“d+d*“d,d*“d-d.“d/d.“d0d1“d2d1“d3d4“d5d4“d6d7“d8d7“} |d| vr'td9|dƒdS| |d|d<|dd!ks=|dd$krId |vrHtd:ƒdSnd|d <d;dœ} d|vr]d;|d<n|d| vrntd?|dƒdS| |d|d<|ddks„|ddkr¶|drt|dƒr| |d¡} d@| |d<|d r¶t|d ƒr¶| |d ¡} d@| |d <| d ¡rÑt|d ƒdAkrÑtdBt|d ƒƒdS| d¡rìt|dƒdAkrìtdCt|dƒƒdS| d¡rt|dƒdDkrtdEt|dƒƒdS| d¡r"t|dƒdDkr"tdFt|dƒƒdS|ddkrJt |dƒt urJ|j |dŽ} t| ƒdDkrJtdGt| ƒƒdSd |vrSd<|d <d |vr\d<|d <d |vred<|d <d|vrnd<|d<||||gg|dH<d|vr…|dH  |d¡|j  |¡d;S)Ia 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ÚvalidaterÍr8ÚsourceÚminimumÚmaximumÚ ignore_blankÚdropdownÚ show_inputÚ input_titleÚ input_messageÚ show_errorÚ error_titleÚ error_messageÚ error_typeZ other_cellsz+Unknown parameter '%s' in data_validation()r$z5Parameter 'validate' is required in data_validation()ÚnoneÚwholeÚdecimalrxrrÚ textLengthÚcustom) Úanyz any valuez whole numberráÚintegerrârxrrz text lengthÚlengthräzJUnknown validation type '%s' for parameter 'validate' in data_validation()Úbetweenz5Parameter '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' criteriarrrc)ÚstopÚwarningÚ informationzJUnknown criteria type '%s' for parameter 'error_type' in data_validation()ú%.16gé z6Length of input title '%s' exceeds Excel's limit of 32z6Length of error title '%s' exceeds Excel's limit of 32éÿz9Length of input message '%s' exceeds Excel's limit of 255z9Length of error message '%s' exceeds Excel's limit of 255zSLength of list items '%s' exceeds Excel's limit of 255, use a formula range insteadÚcells)r%ÚcopyÚkeysrr—rr[rr r rxÚ _csv_joinr0rÖrz) r"rMrNrOrPrœÚvalid_parametersÚ param_keyÚ valid_typesZcriteria_typesZ error_typesÚ date_timer7r(r(r)Údata_validationAsŽÿþýüûúùø ÷ ö õ ô óòñð  þ  ô ÿ  ÿ þ  ÿ þÿþýüûúùø ÷ ö õ ô óòñðÿ ÿ ýý  ÿ     ÿ ÿ ÿ ÿ ÿ ÿ þ      zWorksheet.data_validationcCsj | ||dd¡r dS| ||dd¡rdS|duri}n| ¡}idd“dd“dd“dd“dd“d d“d d“d d“d d“d d“dd“dd“dd“dd“dd“dd“dd“idd“dd“dd“dd“dd“dd“dd“dd“dd“dd“dd“d d“d!d“d"d“d#d“d$d“d%d“¥ddd&œ¥}| ¡D]}||vr¡td'|ƒd(Sq’d|vr¬td)ƒd(Sid*d+“d,d,“d-d-“d.d/“d0d1“d2d3“d4d5“d6d5“d7d7“d8d9“d:d;“dd?“d@dA“dBdB“dCdC“dDdE“dFdGdHœ¥}|d|vrötdI|dƒd(S|dd6krd6|dJ<||d|d<idKdK“dLdM“dNdO“dPdO“dQdO“dRdS“dTdS“dUdS“dVdW“dXdW“dYdZ“d[dZ“d\d]“d^d]“d_d`“dad`“dbdc“dddedfdgdhdidjdkdldmdndodldodpœ¥} d|vrc|d| vrc| |d|d<|dd,ksq|dd-krÒd+|d<d|vr”t|dƒs‡tdqƒd(S| |d¡} dr| |d<d|vr³t|dƒs¦tdsƒd(S| |d¡} dr| |d<d |vrÒt|d ƒsÅtdtƒd(S| |d ¡} dr| |d <idudv“dwdx“dydz“d{d|“d}d~“dd€“dd‚“dƒd„“d…d†“d‡dˆ“d‰dŠ“d‹dŒ“ddŽ“dd“d‘d’“d“d”“d•d–“} |ddGkr^| d$¡std—ƒd˜S|d$| vr+td™|d$ƒd(S| |d$|d$<dš|d›<|d$ dœ¡rDd|d›<n |d$ dž¡rPdŸ|d›<| | d›¡| d ¡¡|d <||krh||}}||krr||}}t ||||ƒ} t ||ƒ} d|vr|d} |   d¡d¢¡} d|vrŸ|drŸ|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¥<|dd7krf|ddckrdc|d<d¦|d| f|d§<nT|dddkr(d¨|d<d©|d| f|d§<n>|ddekrCde|d<dª| t|dƒ|df|d§<n#|ddfkr^df|d<d«| t|dƒ|df|d§<ntd¬|dƒ|dd9kr|ddgkr{d­| |d§<n—|ddhkr‰d®| |d§<n‰|dd¯kr—d°| |d§<n{|ddikr§d±| | f|d§<nk|ddjkr·d²| | f|d§<n[|ddkkrÇd³| | f|d§<nK|ddlkr×d´| | f|d§<n;|ddmkrèdµ| | | f|d§<n*|ddnkrød¶| | f|d§<n|ddokr d·| | | | f|d§<ntd¸|dƒ|dd;krd¹| |d§<|dd=kr,dº| |d§<|dd?kr9d»| |d§<|ddAkrFd¼| |d§<|ddBkr‘d½|d<d|d<d|d <d|d<| d d¾¡| d d¿¡| ddÀ¡| ddÀ¡| ddÁ¡| dd¡t|dƒ|d<t|dƒ|d<|ddCkrñd½|d<d|d<| d d¾¡| d dá| d d¿¡| ddÀ¡| ddÀ¡| ddÄ¡| ddÅ¡| ddÆ¡t|dƒ|d<t|dƒ|d<t|dƒ|d<d|vrñdÇ|d<|ddEkr¤d|d<| d ¡s d¾|d <dÈ|dÉ<n|d |dÉ<| d ¡s d¿|d <dÊ|dË<n|d |dË<| ddÀ¡| ddÀ¡| ddÌ¡| d|d¡| d"dÍ¡| ddÍ¡| ddÍ¡| dd¢¡| ddΡ| ddΡ| ddÍ¡| ddÍ¡| d d¢¡| d!dÏ¡t|dƒ|d<t|dƒ|d<t|d!ƒ|d!<t|dƒ|d<t|dƒ|d<| d¥¡rÕdÐ|_|d d¾kr¿|ddÀkr¿d|d<|d d¿krÑ|ddÀkrÑd|d<| |dÑ<z |d dP¡|d<Wn ttfyìYnwz |d dP¡|d<Wn ttfyYnwz |d dP¡|d<Wn ttfyYnw| |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#Nr r@rÍr8rÕrÖÚ stop_if_trueÚmin_typeÚmid_typeÚmax_typeÚ min_valueÚ mid_valueÚ max_valueÚ min_colorÚ mid_colorÚ max_colorÚ min_lengthÚ max_lengthZ multi_rangeÚ bar_colorÚbar_negative_colorÚbar_negative_color_sameÚ bar_solidÚbar_border_colorÚbar_negative_border_colorÚbar_negative_border_color_sameÚ bar_no_borderÚ bar_directionÚbar_axis_positionÚbar_axis_colorÚbar_onlyZ data_bar_2010Ú icon_styleÚ reverse_icons)Ú icons_onlyÚiconsz.Unknown parameter '%s' in conditional_format()r$z4Parameter 'type' is required in conditional_format()ÚcellÚ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)r7Zicon_setz?Unknown value '%s' for parameter 'type' in conditional_format()Ú directionrèrérêrërìrõrírîrïrðrñròrórôrõrör÷rørùrúrûrürýZ containingÚ containsTextZ notContainsÚ beginsWithÚendsWithÚ yesterdayÚtodayZ last7DaysZlastWeekZthisWeekZnextWeekZ lastMonthZ thisMonthZ nextMonth)znot containingz begins withz ends withrBrCz last 7 daysz last weekz this weekz next weekz last monthz this monthz next monthz continue weekzcontinue monthz5Conditional format 'value' must be a datetime object.rz7Conditional format 'minimum' must be a datetime object.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_ratingsZ5Ratingz^The 'icon_style' parameter must be specified when 'type' == 'icon_set' in conditional_format()rkz/Unknown icon_style '%s' in conditional_format()rFÚ total_iconsÚ4rÉÚ5rÈr(ú$rGÚpriorityrÚis_data_bar_2010zNOT(ISERROR(SEARCH("%s",%s)))r7Ú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))Ú colorScaleÚminÚmaxrz#FF7128z#FFEF9CÚ percentilez#F8696Bz#FFEB84z#63BE7Bé2ÚautoMinÚ x14_min_typeÚautoMaxÚ x14_max_typez#638EC6Fz#FF0000z#000000éÚrW)r%rrrrr[r—rúÚ_set_icon_propsrrrnÚ_get_dxf_indexrÚrÙrÚ setdefaultrrZÚlstripÚKeyErrorÚAttributeErrorr×rz)r"rMrNrOrPrœÚvalid_parameterr Z valid_typeZ criteria_typer Z valid_iconsrYÚ 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>||}}ddddddddddddœ }| ¡D]} | |vr_td| ƒdSqP| d d¡|d <| d d¡|d <| d d¡|d <||} |d r„| d 8} | d krŽtdƒdS| dd¡|d<| dd¡|d<| d d¡|d<| dd¡|d<| d d ¡|d<| dd¡|d<d|vr|d} | |d<d| vrÙtdt| ƒƒdSt d| tj ¡rçt d| ¡rñtdt| ƒƒdSt d | ¡rtd!t| ƒƒdSt d"| ¡st d#| ¡rtd$t| ƒƒdSd%|vr;|d%|d%<|d%dur0d&|d%<|d%  dd&¡|d%<nd'|d%<|} |} | d ¡rM| d 7} | d¡rW| d 8} t ||||ƒ|d(<t ||| |ƒ|d)<|d srd |d <|d r}|d)|d <d }g|d*<i}t ||d ƒD]#}|d+t |ƒd&d&d d&ddd,œ}d*|vr“|t|d*ƒkrµ|d*|d }nd}|r“| d-d¡}| d.¡rÌ|d.|d<|d}| ¡} | |vrätd/t| ƒƒdSd|| <| d0¡|d1<d2|vr%|d2r%|d2}| d3¡r| d3¡}|  d4d5¡}||d2<t | | d ƒD] }| ||||¡q| d6¡ri|d6}| ¡}|  d7d&¡}|  dd&¡}|d8krFd9}|d:krMd;}||d6<| ||d¡}| d|vr |d>}d }t | | d ƒD]F}d }t ||d ƒD]5}|t|ƒkrþ|t||ƒkrþ|||}||vrö| |||||¡n| |||d¡|d 7}qÎ|d 7}qÃ|j |¡d S)?aY 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: Not supported in constant_memory mode. -2: Row or column is out of worksheet bounds. -3: Incorrect parameter or option. Nz5add_table() isn't supported in 'constant_memory' moder#Tr$) rÅÚbanded_columnsÚ banded_rowsÚcolumnsrŠÚ first_columnÚ header_rowÚ last_columnrSÚstyleÚ total_rowz%Unknown parameter '%s' in add_table()rkr`rcrÅrrz1Must have at least one data row in in add_table()rbFZshow_first_colrdZ show_last_colZshow_row_stripesr_Zshow_col_stripesZheader_row_countrfZtotals_row_shownrSú 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]?[0-9]+$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()rerGZTableStyleMedium9rWZa_rangeraÚColumn)ÚidrSÚ total_stringÚtotal_functionÚ total_valuer7r@Ú name_formatr@rvz*Duplicate header name in add_table(): '%s'Z header_formatrmr7rõú@z [#This Row],rkr:Z countnumsÚ countNumsZstddevÚstdDevrlrjrŠ)rrWrr%rr—r rýrþÚUNICODErnrrWrrÚlowerrúrYrûÚ_table_function_to_formularrWrzr rÊ)r"rMrNrOrPrœr¥rºr\r Znum_rowsrSZfirst_data_rowZ last_data_rowÚcol_idZ seen_namesÚcol_numZcol_dataÚ user_dataZxformatÚ header_namer7rÚfunctionr8rjrŠÚiÚjr8rr(r(r)Ú add_table sn  õ  þ ÿ ÿÿÿ ÿÿ    ÿÿ    ø     ÿ        ÿÿ  ÿ  ÿ    ÿ        zWorksheet.add_tablec Cs6| ||dd¡r dSdt||ƒgi}|duri}idd“dd“dd“dd“d d“d d“d d“d d“d d“dd“dd“dd“dd“dd“dd“dd“dd“ddddddddddœ ¥}| ¡D]}||vrltd|ƒdSq]d|vrwtdƒdS| dd¡}|dvr‡tdƒdS|dkrd}||d<d|vr«t|dƒtur¤|d|d<n|dg|d<t|dƒturº|d|d<n|dg|d<t|dƒ}t|dƒ} || kr×td ƒdSt|dƒ|d!<t|j ƒ} g} |dD]} |   d"d#¡} |   d$¡} d%| vr| d%| } |   | ¡qê| |d<g} |dD]}|  d"d#¡}|   |¡q| |d<| d¡|d&<| d ¡|d'<| d ¡|d(<| d ¡|d)<| d ¡|d*<| d ¡|d <| d+¡|d+<| d,¡|d,<| d-¡|d-<| d.¡|d.<| d/¡|d0<| d1¡|d1<| d2d#¡}|d3kr‰d4|d5<n|d6kr“d7|d5<nd8|d5<| d9¡}|rªd%|vrª| d%|}||d9<| dd4¡}t |ƒ}|d:|d<|d(|d<|d |d<|d)|d<|d*|d<|d&|d<|d'|d<| ||d¡| ||d¡| ||d¡| ||d¡| ||d¡| ||d¡| ||d¡|j  |¡d4S);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ÚlocationrWr Z high_pointZ low_pointZnegative_pointsZ first_pointZ last_pointÚmarkersreÚ series_colorÚnegative_colorÚ markers_colorÚ first_colorÚ last_colorÚ high_colorÚ low_color) rNrMÚaxisÚreverseÚ empty_cellsÚ show_hiddenZ plot_hiddenÚ date_axisÚweightz)Unknown parameter '%s' in add_sparkline()z0Parameter 'range' is required in add_sparkline()r$Úline)rŒÚcolumnÚwin_losszJParameter 'type' must be 'line', 'column' or 'win_loss' in add_sparkline()rŽZstackedÚrangeszMMust have the same number of location and range parameters in add_sparkline()ÚcountrHrGrõú!ÚhighÚlowÚnegativeÚfirstÚlastrMrNr†r‡r‰rer‹rˆÚzerorÚemptyÚconnectÚspanÚgaprŠZseries)r%rrrr—r rxrrrSrnrYrzrÚ_set_spark_colorrË)r"rr8rœÚ sparklinerr Z spark_typeZ range_countZlocation_countÚ sheetnameZ new_rangesÚ spark_rangeZ new_locationsr}r˜Z date_rangeÚstyle_idrer(r(r)Ú add_sparkline5 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)rrrd)r"rMrNrOrPÚpaneÚ active_cellÚsqrefr(r(r)Ú set_selectionò s   zWorksheet.set_selectionrcCs"||_||_||_||_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)rh)r"rr8Útop_rowÚleft_colÚ pane_typer(r(r)Ú freeze_panes, s 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. rcN)r¬)r"ÚxÚyr©rªr(r(r)Ú split_panesC szWorksheet.split_panesrKcCs.|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 <= 400rKN)rr r’)r"r’r(r(r)Úset_zoomU s zWorksheet.set_zoomcCr¦)zš Display the worksheet right to left for some versions of Excel. Args: None. Returns: Nothing. rN)r•ròr(r(r)Ú right_to_leftg r¨zWorksheet.right_to_leftcCr¦)z Hide zero values in worksheet cells. Args: None. Returns: Nothing. rN)r–ròr(r(r)Ú hide_zerot r¨zWorksheet.hide_zerocCst|ƒ|_dS)z“ Set the color of the worksheet tab. Args: color: A #RGB color index. Returns: Nothing. N)rrg©r"Úcolorr(r(r)Ú set_tab_color s zWorksheet.set_tab_colorrGcCsÆ|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. rGÚ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_passwordrrr)r"rÈrœÚdefaultsÚkeyr(r(r)ÚprotectŽ sZ ÿþýüûúùø ÷ ö õ ô óòñðï  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#rõrHrGrÚRange)rrYrnrrrÉrŽrz©r"rYÚ 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#Nrr)r%rÚ_button_paramsr°rzr¨)r"rr8rœÚbuttonr(r(r)Ú insert_buttonà s zWorksheet.insert_buttoncCr¯)z Set the page orientation as landscape. Args: None. Returns: Nothing. rTN©rmrkròr(r(r)Ú set_landscapeó zWorksheet.set_landscapecCr¯)z€ Set the page orientation as portrait. Args: None. Returns: Nothing. rTNrÔròr(r(r)Ú set_portraitrÖzWorksheet.set_portraitcCr¦)zr Set the page view mode. Args: None. Returns: Nothing. rN)rÛròr(r(r)Ú set_page_view r¨zWorksheet.set_page_viewcCs|r ||_d|_dSdS)z˜ Set the paper type. US Letter = 1, A4 = 9. Args: paper_size: Paper index. Returns: Nothing. TN)rlrk)r"rlr(r(r)Ú set_paper-s  þzWorksheet.set_papercCr¯)zx Center the page horizontally. Args: None. Returns: Nothing. TrN)rnroròr(r(r)Úcenter_horizontally<rÖzWorksheet.center_horizontallycCr¯)zv Center the page vertically. Args: None. Returns: Nothing. TrN)rnrpròr(r(r)Úcenter_verticallyJrÖzWorksheet.center_verticallyrHrIcCs||_||_||_||_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~rr€)r"ÚleftÚrightr0r2r(r(r)Ú set_marginsXs 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]ú&GrzCHeader 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_docrJT)rnrrrrrrzr—rzrrxryrvrrur©)r"rvrœrâZ header_origÚplaceholder_countÚ image_countr(r(r)Ú set_headerkó^   € þ þ þ  þ   ÿ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árzCFooter string cannot be longer than Excel's limit of 255 charactersNrârãräZLFråræZCFrçrèZRFzONumber of footer images (%s) doesn't match placeholder count (%s) in string: %srérêrJT)rnrrrrrr{r—rzrrxryrwr‚rur©)r"rwrœrâZ footer_origrërìr(r(r)Ú set_footer·rîzWorksheet.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. Nrz$%d:$%dr‘)rrSrƒ)r"rMrOrÃržr(r(r)Ú repeat_rowss   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. Nrr-r‘)rrrSr„)r"rNrPrÃ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. rrTN)rqrrrn)r"Úoptionr(r(r)Úhide_gridlines8s    zWorksheet.hide_gridlinescCsd|_d|_dS)z¢ Set the option to print the row and column headers on the printed page. Args: None. Returns: Nothing. TN)rsrnròr(r(r)Úprint_row_col_headersPrÖzWorksheet.print_row_col_headerscCr¦)zž Set the option to hide the row and column headers on the worksheet. Args: None. Returns: Nothing. TN)rtròr(r(r)Úhide_row_col_headers^r¨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. rrN)r\r]rÂr…)r"rMrNrOrPrÃr(r(r)Ú print_areaks ÿ þÿzWorksheet.print_areacCr¯)z„ Set the order in which pages are printed. Args: None. Returns: Nothing. rTN)r†rkròr(r(r)Ú print_acrossŠrÖ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. rTN)rˆr‰rŠrk)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)rrˆr r”rk)r"Úscaler(r(r)Úset_print_scale·s    zWorksheet.set_print_scalecCrª)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ÜrrT)r"rSr(r(r)Ú set_vba_nameçs zWorksheet.set_vba_namec Cs^|durdS| ¡}ddddddddddœ }| ¡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#T) Únumber_stored_as_textÚ eval_errorÚformula_differsÚ formula_rangeÚformula_unlockedÚempty_cell_referenceÚlist_data_validationÚcalculated_columnÚtwo_digit_text_yearz)Unknown parameter '%s' in ignore_errors()r)rrrrï)r"rœrr r(r(r)Ú ignore_errorsøs( ÷  þzWorksheet.ignore_errorscCs4|d|_|d|_|d|_|d|_|d|_|d|_|d|_|d|_|d |_|d |_ |d |_ |d |_ |d |_ |d|_ |d|_|d|_|d|_|j rvd|_d|_d|_d|_d|_d|_d|_d|_d|_d|_|jr˜tj|jd\}}t |¡||_t  !|dd¡|_"|j"|_#dSdS)NrSrTrUrérWrXrÝrßrâràrárãrär[rårærñg€)@érIrçà?F)Údirzw+úutf-8)$rSrTrUrérWrXrÝrßrâràrárãrär[rårærñržrŸr r}r~rr€rr‚rxÚtempfileÚmkstempr˜ÚcloserçÚcodecsÚopenrèr)r"Z init_dataÚfdr›r(r(r)Ú _initialize'sF                   ÷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_colsrWÚ_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~Z _xml_closeròr(r(r)Ú_assemble_xml_fileRsD   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")r\r]rWrÕr_r`rarb)r"rr8r·r¸r(r(r)r%¶s$ zWorksheet._check_dimensionscCst||j|jƒS©N)rrÝrå)r"Zdt_objr(r(r)r[×sþ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)NrGrrrHr-r‘)rrr\r]rrS)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ÿ)ÚsetÚremoverxrÅr)r"rýZ breaks_setZ breaks_listZmax_num_breaksr(r(r)Ú_sort_pagebreakss   zWorksheet._sort_pagebreakscCsp|sgSt d¡}| |¡}g}|D]#}| d¡r|dd…}| d¡r*|dd…}| dd¡}| |¡q|S)Nz"(?:[^"]|"")*"|\S+ú"rr#z"")rýÚcompileÚfindallrúrürnrz)r"r<Ztoken_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µrFz(and|&&)rz (or|\|\|)rz?Token '%s' is not a valid conditional in filter expression '%s'rÉ)rrýrþrÚ_parse_filter_tokens)r"r<rZ conditionalZ expression_1Z expression_2r(r(r)rË@s   ÿ 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)NrcrÈrrFrÉé) rírõz=~Úeqrðz!~Únerñr÷rýrôrúz top|bottomriôz?The value '%d' in expression '%s' must be in the range 1 to 500Úitemsú%z>The type '%s' in expression '%s' must be either 'items' or '%'r0érz}|d@}|d@}|dL}||B}| |¡q d}|D]} || N}q0||N}|dN}d|S)NrrrEi€ÿ?rLiKÎz%X)rÚordrz) r"Ú plaintextryrÚdigitsÚcharZlow_15Zhigh_15Z password_hashÚdigitr(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|}nt  dd |¡}t   d!|¡rö|  d!d¡}d}|dur&t|ƒ|jkrtd"t|ƒ|jfƒn|j |¡s|j |||g¡| |¡|d<|j | ¡s=|j d#d$t|ƒd%|g¡| | ¡|d<dS)&NrcgX@r é5%rú/drawingú../drawings/drawingú.xmlr Ú dimensionsr¶r¼r”ÚshaperrÚ rel_indexÚ url_rel_indexr`r•ú /hyperlinkÚExternalr÷ú^mailto:rdrGrgú%23rhrirjrerbú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ÁrzrÚ_add_drawing_objectrýrþrornrTrrærr rÎr—rÆÚ_get_drawing_rel_index)r"rTÚimage_idÚ drawing_idr¶r¼rSÚ image_typeÚx_dpiÚy_dpiÚdigestÚ drawing_typerr8r:rŽrrr‘r_r`rr”r•rOrÍÚ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ƒ}|jsatƒ}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<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!t|ƒ|jfƒdS|j |¡s|j  |||g¡| |¡|d<dSdSdS)"NrFr¶r¼r=r rKrrLrMrNZrectZTextBoxr rOr”rPrrrQrRr`r•r_rSrTr÷rUrdrjrgrVrbrW)rÌr—r¢r r[r rÍrr\rÁrzrrrŸr]rýrþrornrrærr rÎrÆr^)r"rTr`rerr8rŽrrr‘rŸrrœr¶r¼rOrÍrPrfr_rgrhrir(r(r)Ú_prepare_shape*sŠ ÿ  ÿÿþý               þ ÿ ÿázWorksheet._prepare_shapec Csbt dd|¡}|j | ¡s|j ddt|ƒd|g¡| | ¡} |j ||||||| g¡dS)Nz\..*$rGrXrYrZ) rýrTrÐr—rÇrzrÚ_get_vml_drawing_rel_indexr|) r"r_r¶r¼rSraÚpositionrbrcrdZref_idr(r(r)Ú_prepare_header_image~s ÿÿþÿ  ÿzWorksheet._prepare_header_imagecCs$|j ddt|ƒd|g¡dS)NrXrYrZ)rÅrzr)r"r_rar(r(r)Ú_prepare_background‘sÿÿþ ÿzWorksheet._prepare_backgroundc Cs(d}|j|\}}}}} } } } |d|_td|j| ƒ} td|j| ƒ}| |||| | || ¡}|j}|jsOtƒ}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)Nrr rLrMrNr rOr¶r¼r”rPrrQrrRr`r•z/chartz../charts/chart)rÈrir r¶r¼r[Z chart_namerÍrr\rÁrzrr]r^rÆ)r"rTZchart_idr`rerr8r¢rŽrrr‘rr¶r¼rOrSrÍrfr(r(r)Ú_prepare_chart˜sRÿ  ÿÿþÿ ÿþ ÿzWorksheet._prepare_chartc Cs¢| |||||||¡\ }}}}}} } } } } tdd|ƒ}tdd|ƒ}tdd| ƒ} tdd| ƒ} tdd| ƒ} tdd| ƒ} |||||| | | | | f S)Nr rK)Ú_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»rWr¢r¼r )r"rrrsrtrur¶r¼rrzr{rtZrow_idrvrwrxryr(r(r)rqsjþþ ÿ ÿþþþþÿz!Worksheet._position_object_pixelscCsˆd}d}d}||jvr?|j|d}|j|d}|r#|dkr#d}|S|dkr3t|||dƒ}|St||dƒ|}|S|j}|S)NrµrÈrrrÉr )r¸r r¢)r"r8rÚmax_digit_widthÚpaddingÚpixelsr¶rer(r(r)r|ds   ùüþzWorksheet._size_colcCs`d}||jvr'|j|d}|j|d}|r|dkrd}|Std|ƒ}|Std|jƒ}|S)NrrrÉgUUUUUUõ?)r¹r rŸ)r"rrr€r¼rer(r(r)r}s   üþzWorksheet._size_rowcCs0d}d}|dkr|||}|S|||}|S)Ng@g@é r()r"r€r~rr¶r(r(r)rº”s  þzWorksheet._pixels_to_widthcCsd|S)NrIr()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#ffffe1rZTahomaérc)r«r¶r]Ú start_colÚ start_rowr§r¶r¼rŽrrr‘Ú font_nameÚ font_sizeÚ font_familyr¶r¼r¶Úffrgr]r†r…rFrµr=rÈréér°rÉrŽé1rLrr‘r r«r§r‡rˆr‰) rrrrrnrr\r]r rqrz)r"rr8rrœÚ 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¡| 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)rr8ÚfontÚcaptionz Button %dr•Úmacroz[0]!z[0]!Button%d_Clickr¶r¼rŽrrr‘r r†r…r“) r r¢rr°rr—r rqrz) r"rr8rœrrŽrZ button_numberrÒrrËr–r“r(r(r)rÑ sB      þ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ÉrrFú /vmlDrawingú../drawings/vmlDrawingú.vmlz /commentsz ../commentsrNrPz%s,%d)Úsortedr«rr”r®r­rzrÃrrªr¬rÂrrWr rêr¯)r"rêr¯Úvml_drawing_idZ comment_idr«Úrow_numsrÚcol_numsr8Ú user_optionsrrZ start_data_idryr(r(r)Ú_prepare_vml_objects`sL òÿþÿÿþÿzWorksheet._prepare_vml_objectscCs&||_|j ddt|ƒdg¡dS)Nr˜r™rš)r±rÃrzr)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) NrirSÚTablez2Duplicate name '%s' used in worksheet.add_table().Tz/tablez../tables/tablerNr)rÊr—rrrrrÄrz)r"Ztable_idÚseenr¥rSr(r(r)Ú_prepare_tabless*  ÿÿÿþÿ êzWorksheet._prepare_tablesc Cs‚d}t dd|¡}t dd|¡}t dd|¡}t dd |¡}d d d d dddddœ}||vr9||}d||f}|Std|ƒ|S)NrGú'z''rgz'#ú]z']z\[z'[éeéfégéhéiékémén)r+rorrNrMrpÚsumÚvarzSUBTOTAL(%s,[%s])z(Unsupported function '%s' in add_table())rýrTr)r"rxZcol_namer7Z subtotalsZfunc_numr(r(r)rs·s(ø   þz$Worksheet._table_function_to_formulacCs$||vrdSdt||ƒi||<dS)NÚrgbr)r"rrœZ user_colorr(r(r)rœÔszWorksheet._set_spark_colorc Cs|jrdSg}t||dƒD]p}||jvr| d¡qt||dƒD][}||j|vrx|j||}t|ƒj} | dkrD| d|j¡q"| dkrW|j} |j  | ¡} | | ¡q"| dks_| dkrn|j } | durhd} | | ¡q"| d krw| d ¡q"| d¡q"q|S) Nr(rr>rr=rBrCrr?rG) rWrWr¥rzr Ú__name__r,rrUZ_get_shared_stringr8) r"rsrrrwrvrŠÚrow_numrur)Útype_cell_namerTrr8r(r(r)Ú_get_range_dataÛs<     ÿ  € Þ$zWorksheet._get_range_datacGsdd„|Dƒ}d |¡S)NcSs"g|] }t|tƒs t|ƒn|‘qSr()rr r)r7Úitemr(r(r)r9sÿz'Worksheet._csv_join..ú,)Újoin)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}rAz%25r9z%22rgz%20r÷z%3crôz%3eú[z%5br¦z%5dú^z%5eú`z%60rFz%7bröz%7d)rýrGrn)r"r_r(r(r)ros            zWorksheet._escape_urlcCsR|dur|jd7_|jS|j |¡r|j|S|jd7_|j|j|<|jS©Nr)rÏrÎr—©r"rgr(r(r)r^0s   z Worksheet._get_drawing_rel_indexcCs6|j |¡r |j|S|jd7_|j|j|<|jSr¼)rÐr—rÑr½r(r(r)rl<s   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ÚbryÚstrikeÚoutlineZshadowrZ superscriptrcZ subscriptÚszÚvalr#ÚthemeZindexedr±ZrFontÚfamilyZCalibriÚscheme)rÔr{Ú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)r|KsH               ÿzWorksheet._write_fontcCsDg}|dkr dg}n|dkrdg}n|dkrdg}|j d|¡dS)Nrc)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"rSr8r†r(r(r)rΖrÖzWorksheet._write_rstring_colorcCs$|ddkr |dd…}d| ¡S)NrrgrZFF)Úupperrµr(r(r)rÍœs   zWorksheet._get_palette_colorcCs|js |j ¡d|_dSdS)NT)rërèrròr(r(r)Ú _opt_close£s  þzWorksheet._opt_closecCs2|jr|j}t |dd¡|_d|_|j|_dSdS)Nza+rF)rërçrrrè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Ír8r rFéCr8rÑrrÉéKrPércrÈéPé<é(rMrõr )rÜrOr,r7zOUnknown icon property type '%s' for sub-property 'type' in conditional_format()r,ÚnumrÍrôT) rWrzrr—rr rúrYr) r"rEZ user_propsÚpropsr:Zmax_dataryÚtmpr rÍr(r(r)rV±sT  þ            þ   €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:rrUzxmlns:mcz xmlns:x14ac)z mc:IgnorableZx14acr)rZrzr{)r"ÚschemaræZxmlns_rZxmlns_mcZ ms_schemaZ xmlns_x14acr†r(r(r)rüsþ  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¢rr-Ú dimensionrÄ)r_rarbrr`rÇ)r"rÄr1r2r(r(r)rs      ÿ zWorksheet._write_dimensioncCs | d¡| ¡| d¡dS)NZ sheetViews)r{Ú_write_sheet_viewr~ròr(r(r)r6s zWorksheet._write_sheet_viewscCsþg}|js | d¡|jr| d¡|js| d¡|jr"| d¡|jr*| d¡|js2| d¡|jr:| d¡|jdkrU|jsU| d |jf¡|j rU| d |jf¡| d ¡|j sbt |j ƒrw|  d |¡| ¡| ¡| d ¡dS| d |¡dS) N)Z showGridLinesr)ZshowRowColHeadersr)Z showZerosr©Ú rightToLeftr)Z tabSelectedr©ZshowOutlineSymbolsr)ÚviewZ pageLayoutrKZ zoomScaleZzoomScaleNormal)ZworkbookViewIdrZ sheetView)rrrzrtr–r•rjrœrÛr’r“rhrrdr{Ú _write_panesÚ_write_selectionsr~rÇ©r"r†r(r(r)ré?s6          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 zeroHeightrZoutlineLevelRowZoutlineLevelColrU©zx14ac:dyDescentz0.25Z sheetFormatPr)rŸr—r˜ržrzr£rZrÇ)r"rŸZ row_levelZ col_levelr†r(r(r)rps      z Worksheet._write_sheet_format_prcCsF|jsdS| d¡t|j ¡ƒD] }| |j|¡q| d¡dS)NÚcols)rcr{r›rÚ_write_col_infor~)r"r8r(r(r)rˆs  zWorksheet._write_colscCs8|\}}}}}}}d} d} |r| ¡} |dur!|sd}d} n d}n|dkr'd} |dkr\d} d} |dkrHtt|| | dƒt| ƒdƒd}ntt|| dƒ| t| ƒdƒd}d|dfd |dfd d |fg} | rv|  d | f¡|r}|  d ¡| r„|  d¡|r|  d|f¡|r”|  d¡| d| ¡dS)NrrrNrµrÈr gp@rMrNr¶rre)rer6)Z customWidthr6Ú outlineLevel)r³r6r8)Ú _get_xf_indexr rrzrÇ)r"Zcol_infoÚcol_minr’r¶rrer´r³Z custom_widthÚxf_indexr~rr†r(r(r)rô–s^ ÿÿÿÿÿÿÿ   ý   zWorksheet._write_col_infocCs8|jdur | d¡dS| d¡| ¡| d¡dS)NÚ sheetData)r_rÇr{Ú _write_rowsr~ròr(r(r)rÍs  zWorksheet._write_sheet_datacCs‚|jdur | d¡dS| d¡d}|j d¡|j |¡}|r/|j |¡|j |¡}|s!|j ¡t   |j ¡|  d¡dS)Nrùir) r_rÇr{rèÚseekÚreadrr rr˜Úunlinkrçr~)r"Z buff_sizerŠr(r(r)rØs      þ  z%Worksheet._write_optimized_sheet_datacCsDd|jfd|jfd|jfd|jfd|jfd|jfg}| d|¡dS)NrÜrÝr0r2rvrwZ pageMargins)r}r~rr€rr‚rÇrðr(r(r)r(ðsúzWorksheet._write_page_marginscCsHg}|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 ¡|jd krl| d ¡|j r†|j rz| d |j f¡|j r…| d|j f¡n|j r‘| d|j f¡|j rœ| d |j f¡|  d|¡dS)NZ paperSizerKrúrZ fitToWidthZ fitToHeight)Z pageOrderZ overThenDownZfirstPageNumber)rmZportrait)rmZ landscaper)ZuseFirstPageNumberr6Z horizontalDpiZ verticalDpiZ pageSetup)rkrlrzr”rˆr‰rŠr†r‡rmrYrírìrÇrðr(r(r)r)üs>       €zWorksheet._write_page_setupcCs^g}|jsdS|jr| d¡|jr| d¡|jr| d¡|jr'| d¡| d|¡dS)N)ZhorizontalCenteredr)ZverticalCenteredr)Zheadingsr)Z gridLinesrZ printOptions)rnrorzrprsrqrÇrðr(r(r)r'Fs    zWorksheet._write_print_optionscCszg}|js | d¡|js| d¡|jr0| d|¡|jr"| ¡|jr)| ¡|  d¡dS|j r;|  d|¡dSdS)N)Z scaleWithDocr)ZalignWithMarginsrZ headerFooter) ryrzrxrur{rvÚ_write_odd_headerrwÚ_write_odd_footerr~r[rÇrðr(r(r)r*_s   ÿzWorksheet._write_header_footercCó| d|j¡dS)NZ oddHeader)r}rvròr(r(r)rþsózWorksheet._write_odd_headercCr)NZ oddFooter)r}rwròr(r(r)rÿwrzWorksheet._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)Nrr‹r)Ú_calculate_spansrWr_r`r‘r«r¥r r§Ú _write_rowrarbÚ _write_cellr~Ú_write_empty_row)r"r³Ú span_indexršruÚcol_refr(r(r)rú{s8ÿ     €  ÿÿ€ß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)Nrr) rÕr‘r«r¥rrWrarbrr~rÚclear)r"Zcurrent_row_numr³ršrurr(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)Nrr‹rz%s:%s) rWr_r`r¥rarbr«r r§)r"ÚspansZspan_minZspan_maxr³rurr(r(r)rÉsJ €   ÿ€ € 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)NNrrrrsrr Ús)Z customFormatrZhtz%g)rerrñrõ)r³rrUròr)rŸrörzržrZZ_xml_empty_tag_unencodedZ_xml_start_tag_unencoded) r"rr Ú propertiesÚ empty_rowrør¼rrer´r³r†r(r(r)rús<        zWorksheet._write_rowcCs|j|||dddS)NT)r )r)r"rr r r(r(r)r-szWorksheet._write_empty_rowcCst||ƒ}d|fg}|jr|j ¡}| d|f¡n0||jvr7|j|dr7|j|d}| d| ¡f¡n||jvrJ|j|}| d| ¡f¡t|ƒj} | dkr\| |j |¡dS| dkrÍ|j } |j sn|  | |¡dSt  dd| ¡} t  dd d „| ¡} tjd d krŽtd ƒ} tdƒ} nd} d} t  | d| ¡} t  | d| ¡} t  d| ¡r´t  d| ¡r´| | |¡dSd } t  d| ¡sÂt  d| ¡rÄd} | | | |¡dS| dkr|j}t|jƒtkrê| d¡|jrçd}n#d }n t|jtƒr d}|jdkrùn|j|vr| d¡n| d¡| |j||¡dS| dkrV|jdkr$| d¡zt|jƒWnty:| d¡Ynw| d |¡| |j|j ¡| !|j¡| "d ¡dS| d!krc| #d |¡dS| d"kr€| d¡| d |¡| !|j$¡| "d ¡dSdS)#Nrsr rr>r=z(_x[0-9a-fA-F]{4}_)z_x005F\1z([\x00-\x08\x0B-\x1F])cSsdt| d¡ƒS)Nz_x%04X_r)rFÚgroup)rþr(r(r)ÚZs ÿz'Worksheet._write_cell..rrciþÿiÿÿu￾uï¿¿Z_xFFFE_Z_xFFFF_z^z$rtrurB)rwr¾)r0z#N/Az#NAME?z#NULL!r/z#REF!z#VALUE!rG)rwÚe)rwrrCrR)ÚcmrÚcr?rA)%rr@rörzr‘rºr r²Z_xml_number_elementr,rrWZ_xml_string_elementrýrTrrÚunichrrGZ_xml_rich_inline_stringZ_xml_inline_stringr8rrr Z_xml_formula_elementr7rXrr!r{Ú_write_cell_array_formularWÚ_write_cell_valuer~rÇr\)r"rr8r)rYr†røZrow_xfZcol_xfr´rZ non_char1Z non_char2rvr8Z error_codesr(r(r)r1sŽ      þ          ÿ       ûzWorksheet._write_cellcCs|durd}| d|¡dS)NrGÚv©r})r"r8r(r(r)r©szWorksheet._write_cell_valuecCsdd|fg}| d||¡dS)N)rwÚarrayrÄrr)r"r7rYr†r(r(r)r°sþ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 filterModerZsheetPr) rˆrµrgrrÜrzr{Ú_write_tab_colorÚ_write_outline_prÚ_write_page_set_up_prr~rÇrðr(r(r)r¹s4ÿþýü ÿþ zWorksheet._write_sheet_prcCs |jsdSdg}| d|¡dS)N)Z fitToPagerZ pageSetUpPr)rˆrÇrðr(r(r)rÕszWorksheet._write_page_set_up_prcCs(|j}|sdSd|fg}| d|¡dS)Nr±ZtabColor)rgrÇ)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 summaryRightrrìZ outlinePr)rr™rzršr›rœrÇrðr(r(r)rès    zWorksheet._write_outline_prcCó\| |j¡}|s dSt|ƒ}d|fd|fg}| d|¡|D]}| |d¡q| d¡dS)NrÚmanualBreakCountZ rowBreaksiÿ?)r8r‹rr{Ú _write_brkr~)r"Ú page_breaksrr†r³r(r(r)r+úó þ zWorksheet._write_row_breakscCr)NrrZ colBreaksiÿÿ)r8rŒrr{rr~)r"rrr†rur(r(r)r,rzWorksheet._write_col_breakscCs"d|fd|fdg}| d|¡dS)NrirN)ÚmanrZbrk©rÇ)r"Zbrk_idZbrk_maxr†r(r(r)r$s ýzWorksheet._write_brkcCóN|j}t|ƒ}|s dSd|fg}| d|¡|D]}| |¡q| d¡dS)NrZ mergeCells)r¦rr{Ú_write_merge_cellr~)r"Z merged_cellsrr†Ú merged_ranger(r(r)r#-ó   zWorksheet._write_merge_cellsc CsF|\}}}}t||ƒ}t||ƒ}|d|}d|fg} | d| ¡dS)Nr-rÄZ mergeCell)rrÇ) r"r$Zrow_minr÷r‘r’r1r2rÄr†r(r(r)r#@s     zWorksheet._write_merge_cellc Cs`g}d}t|j ¡ƒ}|sdS|D]u}t|j| ¡ƒ}|D]g}|j||}|d}|jrL|j|rL|j||rL|j||} t| ƒjdkrL|d}|dkrt|jd7_| ||||j|d||dg¡|j d|ddg¡q| ||||d|d|dg¡qq|  d ¡|D]} |   d ¡}|dkrŸ|j | ŽqŽ|d kr¨|j | ŽqŽ|  d ¡dS) Nrmr=r_rrr`rSrTrÞrrc)r›rÞrr¥r r²r½rzrÀr{ryÚ_write_hyperlink_externalÚ_write_hyperlink_internalr~) r"r¿Údisplayrr³ržruÚlinkrmr)r#r(r(r)r&Ms`ÿ þú ÿûá '   €zWorksheet._write_hyperlinksc Csxt||ƒ}dt|ƒ}d|fd|fg} |dur|  d|f¡|dur)|  d|f¡|dur4|  d|f¡| d| ¡dS)NÚrIdrÄúr:idr}r(ÚtooltiprÏ)rrrzrÇ) r"rr8Zid_numr}r(r,rÄÚr_idr†r(r(r)r&”s  þz#Worksheet._write_hyperlink_externalcCsNt||ƒ}d|fd|fg}|dur| d|f¡| d|f¡| d|¡dS)NrÄr}r,r(rÏ)rrzrÇ)r"rr8r}r(r,rÄr†r(r(r)r'§s þz#Worksheet._write_hyperlink_internalcCsN|jsdSd|jfg}|jr| d|¡| ¡| d¡dS| d|¡dS)NrÄÚ autoFilter)r³rµr{Ú_write_autofiltersr~rÇrðr(r(r)r"¶s  zWorksheet._write_auto_filtercCsT|j\}}t||dƒD]}||jvrq |j|}|j|}| ||||¡q dSr¼)r´rWr¶r·Ú_write_filter_column)r"Zcol1Zcol2r8rr·r(r(r)r/Çs    özWorksheet._write_autofilterscCsBd|fg}| d|¡|dkr| |¡n| |¡| d¡dS)NZcolIdZ filterColumnr)r{Ú_write_filtersÚ_write_custom_filtersr~)r"rtr·rÒr†r(r(r)r0Ø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)r4)rrr)r7Úfilterr(r(r)r9és ÿz,Worksheet._write_filters..)r3rrrrÒ)rrÇr{r›Ú _write_filterr~)r"rÒZ non_blanksr†rÅr(r(r)r1çs   zWorksheet._write_filterscCód|fg}| d|¡dS)NrÂr3r!rÕr(r(r)r4üó zWorksheet._write_filtercCsŽt|ƒdkr| d¡|j|Ž| d¡dSg}|ddkr#dg}ndg}| d|¡| |d|d¡| |d|d¡| d¡dS) NrcZ customFiltersr)Úandr)r7rrrFrÉ)rr{Ú_write_custom_filterr~)r"rr†r(r(r)r2s     zWorksheet._write_custom_filterscCsng}ddddddddœ}||dur||}ntd|ƒ|dks(| d |f¡| d |f¡| d |¡dS) Nrörìrürórïrù)rrcrFrÉrÈr=rCzUnknown operator = %srErÂZ customFilter)rrzrÇ)r"rErÂr†rDr(r(r)r8s ù  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¸rr¹)r¹rrº)rºrr»)r»rr¼)Z formatCellsrr½)Z formatColumnsrr¾)Z formatRowsrr¿)Z insertColumnsrrÀ)Z insertRowsrrÁ)ZinsertHyperlinksrrÂ)Z deleteColumnsrrÃ)Z deleteRowsrrÄ)ZselectLockedCellsrrÅ)rÅrrÅ)r.rrÆ)Z pivotTablesrrÇ)ZselectUnlockedCellsrZsheetProtection)rrzrÇ)r"r†rœr(r(r)r4sR                 z!Worksheet._write_sheet_protectioncCsF|jdkrdS| d¡|jD] \}}}| |||¡q| d¡dS)NrZprotectedRanges)rr{rŽÚ_write_protected_ranger~rÎr(r(r)r ds  z!Worksheet._write_protected_rangescCsBg}|r | d|f¡| d|f¡| d|f¡| d|¡dS)NrÈr¥rSZprotectedRange©rzrÇ)r"rYrÏrÈr†r(r(r)r9ps 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)Nr*r+rÍ©rrÇ)r"r`r-r†r(r(r)r;„s  zWorksheet._write_drawingcCó@|jsdS|jd7_dt|jƒ}d|fg}| d|¡dS)Nrr*r+Z legacyDrawing)r¨r½rrÇ©r"r-r†r(r(r)r/Œó  zWorksheet._write_legacy_drawingcCr=)Nrr*r+ZlegacyDrawingHF)r©r½rrÇr>r(r(r)r0™r?z"Worksheet._write_legacy_drawing_hfcCr=)Nrr*r+Zpicture)rÒr½rrÇr>r(r(r)r1¦r?zWorksheet._write_picturecCr")NrZdataValidations)rÖrr{Ú_write_data_validationr~)r"rÖrr†Z validationr(r(r)r%³r%z!Worksheet._write_data_validationsc Csôd}g}|dD]+}|dkr|d7}|\}}}}||kr!||}}||kr*||}}|t||||ƒ7}q|ddkrR| d|df¡|ddkrR| d |df¡d |vrl|d d kra| d ¡|d d krl| d¡|dru| 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)#NrGrrgrÓràr rÍrèrErßr)Ú errorStylerÿrc)rArr×)Z allowBlankrrØ)Z showDropDownrrÙ)ZshowInputMessagerrÜ)ZshowErrorMessagerrÝZ errorTitlerÞrSrÚZ promptTitlerÛÚpromptr¥ZdataValidationr8rÖ)rrzrÇr{Ú_write_formula_1Ú_write_formula_2r~) r"rœr¥r†rZ row_firstrÏZrow_lastrÐr(r(r)r@ÆsX                 z Worksheet._write_data_validationcCsdt|ƒtur|j|Ž}d|}nzt|ƒWnty)| d¡r'| d¡}Ynw| d|¡dS)Nz"%s"rõZformula1)r rxrrr!rúrYr}rUr(r(r)rCs       €ýzWorksheet._write_formula_1cCóDzt|ƒWnty| d¡r| d¡}Ynw| d|¡dS)NrõZformula2©rr!rúrYr}rUr(r(r)rD"ó    €ýzWorksheet._write_formula_2cCs6t|j ¡ƒ}|s dS|D] }| ||j|¡q dSr5)r›r×rÚ_write_conditional_formatting)r"rÚ cond_ranger(r(r)r$/sÿÿz$Worksheet._write_conditional_formatscCs8d|fg}| d|¡|D]}| |¡q | d¡dS)Nr¥ZconditionalFormatting)r{Ú_write_cf_ruler~)r"rIrr†Úparamr(r(r)rH: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 r@ZdxfIdrIr )Z stopIfTruerr*rErÍZcfRulerÕrÖr8r,Zbelow)r,rrì)Z equalAveragerz [123] std devz([123]) std devrprr1rA)rÜrr>)r2rr°Úrankr-r/r?rKr@rArŸr7r3r5r6r8r9rLr;rJr<r=) rzr—r{Ú_write_formula_elementr~rýrGr rÇÚ_write_color_scaleÚ_write_data_barÚ_write_data_bar_extÚ_write_icon_set)r"rr†rþrLr(r(r)rJCs¢              ÿ þ ý   ÿ þ ý          ýzWorksheet._write_cf_rulecCrE)Nrõr7rFrUr(r(r)rM«rGz Worksheet._write_formula_elementcCsœ| d¡| |d|d¡|ddur| |d|d¡| |d|d¡| d|d ¡|d dur?| d|d ¡| d|d ¡| d¡dS) NrLrrrrrrr±rrr)r{Ú _write_cfvorÌr~)r"rKr(r(r)rN¸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)NrÚ minLengthrÚ maxLengthr$©Z showValuerr;rrrrr±r)r—rzr{rRrÌr~)r"rKr†r(r(r)rOÍs     zWorksheet._write_data_barcCsp|jd}t|jƒd}d||f}||d<|j |¡| d¡| d¡| d|¡| d¡| d¡dS)Nrz{DA7ABA51-AAAA-BBBB-%04X-%012X}ÚguidÚextLstz&{B025F937-C7B1-47D3-B67F-A62EFF666E3E}zx14:idÚext)rTrrØrzr{Ú _write_extr}r~)r"rKZworksheet_countZdata_bar_countrVr(r(r)rPäs ÿ     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%rDr=r'rUr&)r‡rr(r r8rÍ)r—rzr{ÚreversedrRr~)r"rKr†Úiconr(r(r)rQ÷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)rRs  zWorksheet._write_cfvocCs||fg}| d|¡dSr×r!rØr(r(r)rÌr6zWorksheet._write_colorcCs|jD]}|j|ŽqdSr5)rdÚ_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Érc)rhrÚ_write_split_panesÚ_write_freeze_panes)r"rhr(r(r)rî6s  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)NrGrÚ bottomRightÚtopRightÚ bottomLeftÚfrozenrZ frozenSplitr/ÚxSplitÚySplitÚ topLeftCellÚ activePaneÚstater£)rrdrzrÇ)r"rr8r©rªr«r†Úy_splitÚx_splitÚ top_left_cellrirhr¤r¥r:Úrow_cellÚcol_cellr(r(r)r_BsH   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)NrrGrrMi,r rLé†rFrÉrOr`rarbrdrrerfrgr£)rdr Ú_calculate_x_split_widthrrzrÇ)r"rr8r©rªr«r†Z has_selectionrir¤r¥rirjr:rkrlrmr(r(r)r^zsT     zWorksheet._write_split_panescCsZd}d}|dkrt|||dƒ}n t||dƒ|}|dd}|d}|d}|S) NrµrÈrr rFrÉrMrn)r )r"r¶r~rr€ZpointsZtwipsr(r(r)roÁs z"Worksheet._calculate_x_split_widthcCs^|j}t|ƒ}|s dSd|fg}| d|¡|D]}|jd7_| |j¡q| d¡dS)NrZ tablePartsr)rÊrr{r½Ú_write_table_partr~)r"rÊrr†r:r(r(r)r2Øs  zWorksheet._write_table_partscCs&dt|ƒ}d|fg}| d|¡dS)Nr*r+Z tablePartr<r>r(r(r)rpís  zWorksheet._write_table_partcCsPt|jƒ}t|jƒ}|s|sdS| d¡|r| ¡|r!| ¡| d¡dS)NrW)rrØrËr{Ú_write_ext_list_data_barsÚ_write_ext_list_sparklinesr~)r"Z has_data_barsZhas_sparklinesr(r(r)r3ös   zWorksheet._write_ext_listcCsB| d¡| d¡|jD]}| |¡q | d¡| d¡dS)Nz&{78C0D931-6437-407d-A8EE-F0AAD7539E65}zx14:conditionalFormattingsrX)rYr{rØÚ"_write_conditional_formatting_2010r~)r"r:r(r(r)rq s     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:conditionalFormattingrRrrTrr rrrrrr"ràr#ú x14:dataBarú x14:cfRuleúxm:sqrefrW) 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_colorr~r})r"r:Úxmlns_xmr†r(r(r)rss2    ÿÿÿ   z,Worksheet._write_conditional_formatting_2010cCs,d}|d}d|fd|fg}| d|¡dS)Nr;rVr rirw©r{)r"r:Ú rule_typerVr†r(r(r)ryDszWorksheet._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)NrrKrSrTr )Úborderrr)Zgradientrr!rÜ)r>Z leftToRightrÝ)r>rër)ZnegativeBarColorSameAsPositiverr)Z$negativeBarBorderColorSameAsPositiverr"Úmiddle)Ú axisPositionr„rà)r…ràrv)rzr{)r"r:rrr†r(r(r)rzLs0þ       ÿ     zWorksheet._write_x14_data_barcCsHd|fg}|dvr| d|¡dS| d|¡| d|¡| d¡dS)Nr )rMrNrQrSzx14:cfvoúxm:f)rÇr{r}r~)r"r‚r8r†r(r(r)r{qs   zWorksheet._write_x14_cfvocCr5)Nr±zx14:borderColorr!©r"r±r†r(r(r)r||ó z!Worksheet._write_x14_border_colorcCr5)Nr±zx14:negativeFillColorr!r‡r(r(r)r}rˆz(Worksheet._write_x14_negative_fill_colorcCr5)Nr±zx14:negativeBorderColorr!r‡r(r(r)r~†rˆz*Worksheet._write_x14_negative_border_colorcCr5)Nr±z x14:axisColorr!r‡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}rr€rr‚rƒr„r…rŠr†úx14:sparklineGroupúx14:sparklineGroupsrX)rYÚ_write_sparkline_groupsrZrËÚ_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~)r"rr(r(r)rrs$     z$Worksheet._write_ext_list_sparklinescCsn| d¡t|dƒD]$}|d|}|d|}| d¡| d|¡| d|¡| d¡q | d¡dS)Nzx14:sparklinesrrr|z x14:sparkliner†rx)r{rWr}r~)r"rryrŸ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ÚurirXr)r"r–rçZ xmlns_x14r†r(r(r)rYÐs þzWorksheet._write_extcCsd}d|fg}| d|¡dS)NrtrurŠr)r"r€r†r(r(r)r‹Ü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˜rNr Zcust_maxZ manualMaxrärMZcust_minZ manualMinr rŒr‹Z lineWeightrŠ)ZdateAxisrZdisplayEmptyCellsAsr~)r~rr’)r’rr“)r“rr•)r•rr–)r–rr”)r”rr†)Z displayXAxisrre)Z displayHiddenrZ minAxisTypeZ maxAxisTyper‡rêr‰)r—rzr{)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—rzrÇ)r"Úelementr¶r†r(r(r)Ú_write_spark_color>s   zWorksheet._write_spark_colorcCó| d|¡dS)Nzx14:colorSeries©r˜rµr(r(r)rMózWorksheet._write_color_seriescCr™)Nzx14:colorNegativeršrµr(r(r)rŽQr›zWorksheet._write_color_negativecCs| dddi¡dS)Nz x14:colorAxisr±ZFF000000ršròr(r(r)rUszWorksheet._write_color_axiscCr™)Nzx14:colorMarkersršrµr(r(r)rYr›zWorksheet._write_color_markerscCr™)Nzx14:colorFirstršrµr(r(r)r‘]r›zWorksheet._write_color_firstcCr™)Nz x14:colorLastršrµr(r(r)r’ar›zWorksheet._write_color_lastcCr™)Nz x14:colorHighršrµr(r(r)r“er›zWorksheet._write_color_highcCr™)Nz x14:colorLowršrµr(r(r)r”ir›zWorksheet._write_color_lowcCsddg}| d|¡dS)N)ZfontIdÚ0)r Z noConversionZ phoneticPrr!rðr(r(r)r!msþ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 ignoredErrorsrZnumberStoredAsTextrZ evalErrorrr7rZ formulaRangerZunlockedFormularZemptyCellReferencerZlistDataValidationrZcalculatedColumnr ZtwoDigitTextYear)rïr{r—Ú_write_ignored_errorr~)r"rWr(r(r)r-vs>                            zWorksheet._write_ignored_errorscCs d|f|dfg}| d|¡dS)Nr¥rZ ignoredErrorr!)r"r rWr†r(r(r)r£sþzWorksheet._write_ignored_errorr5)Nr)NrrL)NNN)F)NF)rrrr)NNr)NN)rK)rGN)rHrHrIrI)rGNN)r)FF)r)êr²Ú __module__Ú __qualname__Ú__doc__rRrr,r r r rr-rr4rùr9rûr5rQrHrJrIrZrr]rrarÿrqrprˆ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ÚrÛrÞrírïrðrñrórôrõrör÷rørùrûrþrÿrr rr4r%r[rÂr8rÊrËr<rÉrjrkrnrorpr[rqr|r}rºr¾r”rÑr r¡r¤rsrœrµrror^rlr|rÊrËrÎrÍrÚrÛrVrrrrérrrôrrr(r)r'r*rþrÿrúr'rrrrrrrrrrr+r,rr#r#r&r&r'r"r/r0r1r4r2r8rr r9r.r;r/r0r1r%r@rCrDr$rHrJrMrNrOrPrQrRrÌrïr\rîr_r^ror2rpr3rqrsryrzr{r|r}r~rrrr•rYr‹rŒr˜rrŽrrr‘r’r“r”r!r-rÚ __classcell__r(r(rór)rD–sD W# V    *ÿ)þ* þ.  ÿ ÿg p.$<#  ÿJÿ  = ÿ6 ;(ÿmÿhÿ"= " ÿ   3#    L L    /+ d!(!RbT2: `  |@4 8  7     K  $ 1   7  J    ( &13  x        Gÿÿ         0    K  h       8 G     -  %     /   Z          -rD)3rrr˜rýrrÚ collectionsrrÚmathrrÚwarningsrÚ compatibilityrr r r rGr r@r rÍrrPrrZutilityrrrrrrrrrrÚ exceptionsrr,r5r<r(r1r5r^rKrVrDr(r(r(r)ÚsT                            ÿ