o ûÐ,h^Bã@sÚddlZddlZddlZddlZddlZddlmZmZddlm Z ddl m Z ddl m Z ddlmZddlmZmZddlmZdd lmZdd lmZdd lmZmZdd lmZd dlmZd dlm Z m!Z!m"Z"d dl#m$Z$m%Z%d dl&m'Z'd dl(m)Z)d dl*m+Z+m,Z,m-Z-m.Z.m/Z/m0Z0m1Z1m2Z2m3Z3m4Z4m5Z5m6Z6d dlm7Z7e 8dej9¡Z:dd„Z;dd„ZeddƒZ?ed d!ƒZ@ed"d#ƒZAed$d%ƒZBed&d'ƒZCed(d!ƒZDed)d*ƒZEed+d,ƒZFGd-d.„d.ej7ƒZGdS)/éN)Ú defaultdictÚ namedtuple)ÚDecimal)ÚFraction©Úwraps)ÚStringIO)ÚisinfÚisnan)Úwarn)Ú CommentType)ÚImage)ÚUrlÚUrlTypes)Ú ButtonTypeé)Ú xmlwriter)ÚDrawingÚ DrawingInfoÚ DrawingTypes)ÚDuplicateTableNameÚOverlappingRange)ÚFormat)ÚShape) Ú_datetime_to_excel_datetimeÚ_get_sparkline_styleÚ_preserve_whitespaceÚ_supported_datetimeÚ _xl_colorÚquote_sheetnameÚxl_cell_to_rowcolÚxl_col_to_nameÚxl_pixel_widthÚxl_rangeÚxl_rowcol_to_cellÚxl_rowcol_to_cell_fast)Ú XMLwriteraÌ \bANCHORARRAY\( | \bBYCOL\( | \bBYROW\( | \bCHOOSECOLS\( | \bCHOOSEROWS\( | \bDROP\( | \bEXPAND\( | \bFILTER\( | \bHSTACK\( | \bLAMBDA\( | \bMAKEARRAY\( | \bMAP\( | \bRANDARRAY\( | \bREDUCE\( | \bSCAN\( | \bSEQUENCE\( | \bSINGLE\( | \bSORT\( | \bSORTBY\( | \bSWITCH\( | \bTAKE\( | \bTEXTSPLIT\( | \bTOCOL\( | \bTOROW\( | \bUNIQUE\( | \bVSTACK\( | \bWRAPCOLS\( | \bWRAPROWS\( | \bXLOOKUP\(cótˆƒ‡fdd„ƒ}|S)zn Decorator function to convert A1 notation in cell method calls to the default row/col notation. csZz |r |d}t|ƒWnty!t|ƒ}||dd…}Ynwˆ|g|¢Ri|¤ŽS©Nrr)ÚintÚ ValueErrorr )ÚselfÚargsÚkwargsÚ first_argÚnew_args©Úmethod©úJ/var/www/html/rh/venv/lib/python3.10/site-packages/xlsxwriter/worksheet.pyÚ cell_wrapperds€ ýz'convert_cell_args..cell_wrapperr©r1r4r2r0r3Úconvert_cell_args]s r6cr')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_2Úrow_1Úcol_1Úrow_2Úcol_2r/r0r2r3r4|s  €     ôz(convert_range_args..cell_wrapperrr5r2r0r3Úconvert_range_argsusrAcr')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)Ú1r2)Ú.0Úcolr2r2r3Ú ¤sz?convert_column_args..column_wrapper..r7rr8) r+r,r-r;r<Ú_r>r@r/r0r2r3Úcolumn_wrapperœs €   ù z+convert_column_args..column_wrapperr)r1rGr2r0r3Úconvert_column_args•srHÚBlankÚformatÚErrorzerror, format, valueÚNumberznumber, formatÚStringzstring, formatÚBooleanzboolean, formatÚFormulazformula, format, valueÚDatetimeÚ RichStringzstring, format, raw_stringÚ ArrayFormulaz$formula, format, value, range, atypecs2 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"„Zed#d$„ƒZ  %dîd&d'„Zedëd(d)„ƒZdëd*d+„Zedëd,d-„ƒZdëd.d/„Zedïd0d1„ƒZdïd2d3„Zed4d5„ƒZd6d7„Zd8d9„Z edëd:d;„ƒZ!edëdd?„ƒZ#edëd@dA„ƒZ$edëdBdC„ƒZ%edëdDdE„ƒZ&edëdFdG„ƒZ'dHdI„Z(dídJdK„Z)dLdM„Z*dNdO„Z+dPdQ„Z,dRdS„Z-dTdU„Z.dVdW„Z/dXdY„Z0e1 dïdZd[„ƒZ2e1 dïd\d]„ƒZ3dðd_d`„Z4dïdadb„Z5dïdcdd„Z6dñdedf„Z7e dëdgdh„ƒZ8edidj„ƒZ9dkdl„Z:dmdn„Z;edëdodp„ƒZedëdudv„ƒZ?edwdx„ƒZ@edòdydz„ƒZA dód|d}„ZBedôd~d„ƒZCedõd€d„ƒZDdödƒd„„ZEd…d†„ZFd‡dˆ„ZGd‰dŠ„ZHd÷dŒd„ZIdõdŽd„ZJedëdd‘„ƒZKedëd’d“„ƒZLd”d•„ZMd–d—„ZNdød˜d™„ZOdšd›„ZPdœd„ZQdždŸ„ZRd d¡„ZSdùd¤d¥„ZTdúd¦d§„ZUdúd¨d©„ZVdëdªd«„ZWe1dëd¬d­„ƒZXdød®d¯„ZYd°d±„ZZd²d³„Z[ed´dµ„ƒZ\d¶d·„Z]d¸d¹„Z^dºd»„Z_d¼d½„Z`d¾d¿„ZadÀdÁ„ZbdÂdÄZcdëdÄdÅ„ZddëdÆdÇ„ZedÈdÉ„ZfdÊdË„ZgdûdÌdÍ„ZhdÎdÏ„ZidÐdÑ„ZjdÒdÓ„ZkdÔdÕ„ZldÖdׄZmdØdÙ„ZndÚdÛ„ZodëdÜdÝ„ZpdÞeqdßerdàerfdádâ„Zsdãdä„Ztdådæ„Zudçdè„Zvdédê„Zwdëdì„Zxdídî„Zydüdïdð„Zzdüdñdò„Z{dódô„Z|dõdö„Z}d÷e~fdødù„Zdúe€fdûdü„Zdýdþ„Z‚dÿd„Zƒdd„Z„dd„Z…dd„Z†dd„Z‡d d „Zˆd d „Z‰dëd d„ZŠdëdd„Z‹dd„ZŒdd„Zdd„ZŽdd„Zdd„Zdd„Z‘dd„Z’dëdd „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„Zd5d6„Zžd7d8„ZŸd9d:„Z d;d<„Z¡d=d>„Z¢d?d@„Z£düdAdB„Z¤dCdD„Z¥dñdEdF„Z¦dë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²d_d`„Z³dadb„Z´dcerdderdeerdfeµfdgdh„Z¶dcerdderdfeµfdidj„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’„ZËd“d”„ZÌd•d–„ZÍd—d˜„ZÎd™dš„ZÏd›dœ„ZÐddž„ZÑdŸd „ZÒdë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ð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. csHtƒ ¡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 |_/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|_[d|_\i|_]g|_^tFtGƒ|__g|_`i|_ai|_bi|_cd|_dd|_ed|_ftFtGƒ|_gg|_hd|_id|_jd|_kg|_ld|_md|_nd|_oddg|_pd|_qi|_ri|_si|_ti|_ud|_vd|_wd |_xd|_yd|_zg|_{g|_|g|_}g|_~g|_g|_€g|_g|_‚g|_ƒg|_„g|_…g|_†g|_‡g|_ˆi|_‰d|_Ši|_‹d|_Œi|_d|_Žd|_d|_d|_‘g|_’i|_“g|_”d|_•d |_–d|_—d|_˜d|_™tFtGƒ|_šd|_›d |_œd|_d |_žd|_Ÿd|_ d|_¡d|_¢d|_£d|_¤d|_¥d|_¦d|_§d|_¨d|_kd|_¥d|_¦d|_©d|_ªd|_«i|_¬d|_­d|_®d|_¯d|_°d|_±dS)z Constructor. NrFi×ii@éÿÚérTçffffffæ?çè?ç333333Ó?édééç\Âõ(Ü @é@éDéé i)²ÚsuperÚ__init__ÚnameÚindexÚ str_tableÚpaletteÚconstant_memoryÚtmpdirÚ is_chartsheetÚ ext_sheetsÚ fileclosedÚ excel_versionÚexcel2003_styleÚ xls_rowmaxÚ xls_colmaxÚ xls_strmaxÚ dim_rowminÚ dim_rowmaxÚ dim_colminÚ dim_colmaxÚcol_infoÚ selectionsÚhiddenÚactiveÚ 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_whiteÚ draft_qualityÚprint_commentsÚ page_startÚfit_pageÚ fit_widthÚ fit_heightÚhbreaksÚvbreaksÚprotect_optionsÚprotected_rangesÚnum_protected_rangesÚset_colsrÚdictÚset_rowsÚzoomÚzoom_scale_normalÚ print_scaleÚis_right_to_leftÚ show_zerosÚ 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ÚnamesÚ 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_changedÚ 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ÚshapesÚ shape_hashÚdrawingÚ drawing_relsÚdrawing_rels_idÚvml_drawing_relsÚvml_drawing_rels_idÚbackground_imageÚ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Údefault_checkbox_formatÚworkbook_add_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Úembedded_images©r+©Ú __class__r2r3rcÓsd       zWorksheet.__init__cGs>|dkr|j||g|¢RŽS|jr | d¡r |j||g|¢RŽS| d¡r4| d¡r4|j||g|¢RŽSd|vr]|jr]t d|¡sSt d|¡sSt d|¡sSt d |¡r]|j||g|¢RŽS|j r•z!t |ƒ}|j spt |ƒs€t |ƒs€|j|||g|d d…¢RŽWSWn tyŠYnw|j||g|¢RŽS|j||g|¢RŽS) NrUú=z{=ú}r7z(ftp|http)s?://zmailto:z(in|ex)ternal:zfile://r)Ú _write_blankrÿÚ startswithÚ_write_formulaÚendswithrýÚreÚmatchÚ _write_urlrüÚfloatrþr r Ú _write_numberr*Ú _write_string)r+ÚtokenÚrowrDr,Úfr2r2r3Ú_write_token_as_string¯s:ÿ ý ü û ú  € þ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+r#rDr,r2r2r3ÚwriteÕszWorksheet.writec Gs4|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ŽSt|tƒrÊ|j||g|¢RŽSzt|ƒ}|j |||g|dd…¢RŽWStyçYnty÷tdt|ƒ›dƒ‚wzt |ƒ|j||g|¢RŽWStytdt|ƒ›dƒ‚w)Nz,write() takes at least 4 arguments (3 given)rrzUnsupported type z in write())Ú TypeErrorrr rÚboolÚ_write_booleanrr)rrr Ústrr%ÚdatetimeÚdateÚtimeÚ timedeltaÚ_write_datetimeÚ isinstancerrrr*Útyper!) r+r#rDr,r"Ú token_typeÚ write_handlerÚfunction_returnr$r2r2r3r(ésb  ü      ÿÿ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+r#rDÚstringÚ cell_formatr2r2r3Ú write_string>ózWorksheet.write_stringcCs~d}| ||¡r dSt|ƒ|jkr|d|j…}d}|js$|j |¡}n|}|jr3||jkr3| |¡t||ƒ|j ||<|S©Nréÿÿÿÿéþÿÿÿ) Ú_check_dimensionsÚlenrqrhrfÚ_get_shared_string_indexròÚ_write_single_rowÚCellStringTuplerÀ)r+r#rDr:r;Ú str_errorÚ string_indexr2r2r3r!Rs  zWorksheet._write_stringcCr9)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+r#rDÚnumberr;r2r2r3Ú write_numbermózWorksheet.write_numbercCsÈt|ƒst|ƒr:|jr6t|ƒr| ||d|d¡S|tjkr&| ||d|d¡S|tj kr5| ||d|d¡Sntdƒ‚|jturCt |ƒ}|  ||¡rKdS|j rX||j krX|  |¡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Úinfr+rrrrArhròrDÚCellNumberTuplerÀrHr2r2r3r €s(  ÿÿ   zWorksheet._write_numbercCr9)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+r#rDÚblankr;r2r2r3Ú write_blank¡r=zWorksheet.write_blankcCsL|durdS| ||¡rdS|jr||jkr| |¡t|ƒ|j||<dS)Nrr?)rArhròrDÚCellBlankTuplerÀ)r+r#rDrFr;r2r2r3rµ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+r#rDÚformular;Úvaluer2r2r3Ú 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?rUzFormula can't be None or emptyú{rr)rAr Úre_dynamic_functionÚsearchÚwrite_dynamic_array_formularrÚ_write_array_formulaÚ_prepare_formularhròrDÚCellFormulaTuplerÀrTr2r2r3rÝ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)rYrZr[r\)r+Ú first_rowÚ first_colÚlast_rowÚlast_colrUr;rVr2r2r3Ú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)r\r) r+r`rarbrcrUr;rVÚerrorr2r2r3r[*sø 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(=NrXrrrr?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+rUÚexpand_future_functionsr2r2r3r]XsT       ÿÿzWorksheet._prepare_formulacCsdd|vr|Sg}d}|D] }|dkr| }|r| |¡q |dkr'| d¡q | |¡q d |¡S)Nú@Fú"z [#This Row],rU)ÚappendÚjoin)rUÚescaped_formulaÚin_string_literalÚcharr2r2r3Ú_prepare_table_formulas    z Worksheet._prepare_table_formular_c 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?r7rr) rAr$r]rhròrDÚCellArrayFormulaTuplerÀÚranger ) r+r`rarbrcrUr;rVÚatypeÚ cell_ranger#rDr2r2r3r\-s<     ÿþÿ   ÿ€þzWorksheet._write_array_formulacCr9)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. )r3)r+r#rDr0r;r2r2r3Úwrite_datetimecrKzWorksheet.write_datetimecCsZ| ||¡rdS|jr||jkr| |¡| |¡}|dur!|j}t||ƒ|j||<dS)Nr?r)rArhròrDÚ_convert_date_timerÚCellDatetimeTuplerÀ)r+r#rDr0r;rIr2r2r3r3vs   zWorksheet._write_datetimecCr9)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+r#rDÚbooleanr;r2r2r3Ú write_boolean‹rKzWorksheet.write_booleancCsP| ||¡rdS|jr||jkr| |¡|rd}nd}t||ƒ|j||<dS)Nr?rr)rArhròrDÚCellBooleanTuplerÀ)r+r#rDryr;rVr2r2r3r-ž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+r#rDÚurlr;r:Útipr2r2r3Ú write_url¹szWorksheet.write_urlcCs¾| ||¡rdSt|tƒst|ƒ}|dur||_|dur||_|jd7_|jdkr6td|j›dƒdS|dur=|j}|j sV|j rM||j krM|  |¡|  |||j|¡||j||<dS)Nr?riúÿzIgnoring URL 'z>' since it exceeds Excel's limit of 65,530 URLs per worksheet.éüÿÿÿr)rAr4rÚ_textÚ_tiprÛr Ú _original_urlrrrhròrDr!Útextrûr|r2r2r3rÏ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_stringr)r2r2r3Ú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)NrrUr?rJézfYou 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().r€r:zaExcel doesn't allow 2 consecutive formats in rich strings. Ignoring input in write_rich_string().éýÿÿÿrÚ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@)ÚlistrAr4rÚpoprr&rñÚ_set_filehandlerBr rkÚ_xml_start_tagÚ _write_fontrÚ_xml_data_elementÚ _xml_end_tagÚfhÚgetvaluerqrhrfrCròrDÚCellRichStringTuplerÀ)r+r#rDr,Útokensr;rGÚ raw_stringr”ÚdefaultÚ fragmentsÚpreviousÚposr"Ú attributesr:r2r2r3r…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+Ú user_typeÚ user_functionr2r2r3Ú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. rrr'©r+r#rDÚdatar;r"rfr2r2r3Ú 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. rrr'r¡r2r2r3Ú write_column°r¤zWorksheet.write_columncCs\| ||dd¡rtd|›d|›dƒdS| ||¡}||_||_| |¡|j |¡dS)a° Insert an image with its top-left corner in a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). source: Filename, BytesIO, or Image object. options: Position, scale, url and data stream of the image. Returns: 0: Success. -1: Row or column is out of worksheet bounds. TzCannot insert image at (ú, ú).r?r)rAr Ú_image_from_sourceÚ_rowÚ_colÚ_set_user_optionsrærk)r+r#rDÚsourceÚoptionsÚimager2r2r3Ú insert_imageÇs   zWorksheet.insert_imagecCs¬| ||¡rtd|›d|›dƒdS|duri}| ||¡}| |¡| dd¡}|jrC|dur4|j}d|_| |||j|¡d|_|j   |¡}t d ||ƒ|j ||<d S) a… Embed an image in a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). source: Filename, BytesIO, or Image object. options: Url and data stream of the image. Returns: 0: Success. -1: Row or column is out of worksheet bounds. zCannot embed image at (r¦r§r?Nr;TFú#VALUE!r) rAr r¨r«Úgetr}rrrrÚget_image_indexÚCellErrorTuplerÀ)r+r#rDr¬r­r®r;Ú image_indexr2r2r3Ú embed_imageçs"     zWorksheet.embed_imagec Cs¼| ||dd¡rtd|›d|›dƒdS|durd}|dur!i}| dd ¡}| d d ¡}| d d ¡}| d d ¡}| dd ¡} | dd¡} | dd¡} |j |||||||| || | g ¡d S)a† Insert an textbox with its top-left corner in a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). text: The text for the textbox. options: Textbox options. Returns: 0: Success. -1: Row or column is out of worksheet bounds. TzCannot insert textbox at (r¦r§r?NrUÚx_offsetrÚy_offsetÚx_scalerÚy_scaleÚobject_positionÚ descriptionÚ decorativeF)rAr r±rérk) r+r#rDr„r­r¶r·r¸r¹Úanchorr»r¼r2r2r3Úinsert_textboxs:       õÿzWorksheet.insert_textboxc Cs| ||dd¡rtd|›d|›dƒdS|duri}|js%|jr+|jjr+tdƒdSd|_|jr5d|j_| d d ¡}| d d ¡}| d d ¡}| dd ¡}| dd ¡} | dd¡} | dd¡} |jd krg|j}|jd kro|j}|jru|j}|jr{|j}|j   |||||||| | | g ¡d S)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. TzCannot insert chart at (r¦r§r?Nz7Chart cannot be inserted in a worksheet more than once.r@r¶rr·r¸rr¹rºr»r¼F) rAr Úalready_insertedÚcombinedr±r¸r¹r¶r·rårk) r+r#rDÚchartr­r¶r·r¸r¹r½r»r¼r2r2r3Ú insert_chartHsP         öÿzWorksheet.insert_chartcCsN| ||¡rdSt|ƒ|jkrdSd|_d|_t||||ƒ}||j||<dS)až Write a comment to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). comment: Cell comment. Str. options: Comment formatting options. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: String longer than 32k characters. r?r@Tr)rArBrqrÅrÇr rÈ)r+r#rDÚcommentr­r2r2r3Ú write_comments zWorksheet.write_commentcCó d|_dS)z† Make any comments in the worksheet visible. Args: None. Returns: Nothing. TN)rËrr2r2r3Ú show_comments±ó zWorksheet.show_commentscCs | |¡}||_|rtdƒdS)zú Set a background image for a worksheet. Args: source: Filename, BytesIO, or Image object. is_byte_stream: Deprecated. Use a BytesIO object instead. Returns: 0: Success. zƒThe `is_byte_stream` parameter in `set_background()` is deprecated. This argument can be omitted if you are using a BytesIO object.r)r¨rðr )r+r¬Úis_byte_streamr®r2r2r3Ú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+Úauthorr2r2r3Úset_comments_author×rÇzWorksheet.set_comments_authorcCs|jS)zw Retrieve the worksheet name. Args: None. Returns: Nothing. )rdrr2r2r3Úget_nameäs 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)rxr~rerÚ activesheetrr2r2r3Ú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. rrN)r~rxrr2r2r3Úselects zWorksheet.selectcCrÐ)zv Hide the current worksheet. Args: None. Returns: Nothing. rrN©rxr~rr2r2r3Úhideó zWorksheet.hidecCrÐ)z˜ Hide the current worksheet. This can only be unhidden by VBA. Args: None. Returns: Nothing. r‡rNrÒrr2r2r3Ú 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)rxrerÚ firstsheetrr2r2r3Úset_first_sheet5szWorksheet.set_first_sheetc CsÚ|duri}||kr||}}d}| dd¡}| dd¡}| dd¡} |s)|r,|r,d} nd} | d||| ¡r8dS| d||| ¡rBdSt| dƒ} t| d ƒ} t|j| ƒ|_t||d ƒD] } |||| |dg|j| <qZd|_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. NTrxFÚ collapsedÚlevelrr?ér)r±rAÚmaxÚminr±rrrvr×) r+rarcÚwidthr;r­Ú ignore_rowrxrØrÙÚ ignore_colrDr2r2r3Ú set_columnGs,       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+rarcrÝr;r­r2r2r3Úset_column_pixels…s zWorksheet.set_column_pixelséþcCsÂ|jr tdƒdS|jdurdSi}t| |¡dƒ}t|jj|jjjd}t |j |jdƒD]Í}|j   |¡s7q.t |j |jdƒD]º}||j |vrú|j ||}|jj}d}|dvr„|dkrf|j} || } n|j} d | vrrt| ƒ}nj|  d ¡D] } t| ƒ} t|| ƒ}qwnX|d kr’d tt|jƒƒ}nJ|d krš|j}nB|d kr§|jr¤d}n8d}n5|dvrÜt|jttfƒrÂ|jdkrÁd tt|jƒƒ}nt|jtƒrÎt|jƒ}nt|jtƒrÜ|jrÚd}nd}|j   ||f¡rì|dkrì|d7}|  |d¡} || krú|||<q@q.| !¡D]^\}} | | d ¡}t||ƒ}|j"  |¡rR|j"  |¡}|d}|d}|durB|sB||kr@||j"|d<d|j"|d<q||j"|d<d|j"|d<q|dddddg|j"|<qdS)zÔ Simulate autofit based on the data, and datatypes in each column. Args: max_width (optional): max column width to autofit, in pixels. Returns: Nothing. z1Autofit is not supported in constant_memory mode.Ngào@)Úkeyrr©rMrQrMÚ rLrÚrPrNéé$©rOrRééTF)#rhr rsrÜráÚsortedrfÚ string_tableÚ __getitem__rrrrrÀr±rtrurÚ__name__r:r˜r"r9rÛrBr.rIr¼ryr4rVrr)r,rÕÚitemsrv)r+Ú max_widthÚ col_width_maxÚstringsÚrow_numÚcol_numÚcellÚ cell_typeÚlengthÚ string_idr:Ú seg_lengthÚ width_maxÚ pixel_widthrÝrvÚ user_widthrxr2r2r3ÚautofitžsŽ  ÿ    þ €    €®U   €çzWorksheet.autofitc CsÄ|duri}|jdur|j}nd}| ||¡rdS|dur |j}| dd¡}| dd¡}| dd¡}|dkr;d}|j}t|dƒ}t|d ƒ}t|j|ƒ|_|||||g|j|<d |_||g|j |<dS) aš Set the width, and other properties of a row. Args: row: Row number (zero-indexed). height: Row height. (optional). cell_format: Row cell_format. (optional). options: Dict of options such as hidden, level and collapsed. Returns: 0: Success. -1: Row number is out of worksheet bounds. Nrr?rxFrØrÙrrÚT) rtrAr¸r±rÛrÜr°r©rØrÖ) r+r#Úheightr;r­Úmin_colrxrØrÙr2r2r3Úset_row3s,       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+r#rÿr;r­r2r2r3Úset_row_pixelsms 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ÿÚhide_unused_rowsr2r2r3Úset_default_rows   ÿzWorksheet.set_default_rowc Cs‚||kr||krtdƒdS||kr||}}||kr ||}}| ||¡r(dS| ||¡r0dSt||||ƒ}t||dƒD]I}t||dƒD]?} |j || f¡rd|j || f¡} td|›d| ›dƒ‚|j || f¡r|j || f¡} td|›d| ›dƒ‚||j|| f<qGq>|j  ||||g¡|  ||||¡t||dƒD]}t||dƒD]} ||krµ| |krµqª|  || d|¡qªq¡d S) a3 Merge a range of cells. Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. data: Cell data. cell_format: Cell Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. other: Return value of write(). zCan't merge single cellr?rz Merge range 'ú!' overlaps previous merge range 'ú'.ú!' overlaps previous table range 'rUr) r rAr#rrrÂr±rrÃrÁrkr(r) r+r`rarbrcr¢r;rtr#rDÚprevious_ranger2r2r3Ú merge_range˜sN    ÿÿÿÿñýzWorksheet.merge_rangec CsÄ||kr ||}}||kr||}}| ||||¡}t||||ƒ}||_||_||g|_t||dƒD],}|j ||f¡rV|j ||f¡\}} |dkrVtd|›d| ›dƒ‚d|f|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. rrÀzWorksheet autofilter range 'z,' overlaps previous Table autofilter range 'rÚ worksheetN) Ú_convert_name_arear#rÏrÐrÑrrrÕr±r) r+r`rarbrcÚareaÚrefrDrÔrÑr2r2r3Ú autofilterås(   ÿÿözWorksheet.autofiltercCsf|js tdƒdSzt|ƒWn#ty2|}t|dƒ\}}||jkr0td|›dƒYdSYnw|j\}}||ks@||krPtd|›d|›d|›d ƒdS| |¡}t|ƒd vrctd |›dƒ|  ||¡}t|ƒd kr|d d kr|  ||dg¡n/t|ƒdkr¤|d d kr¤|d dkr¤|dd kr¤|  ||d|dg¡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()NrBúInvalid column 'ú'úColumn 'ú%' outside autofilter() column range (r¦ú))rVrÚz(Incorrect number of tokens in criteria 'r‡rrrërVé)rÏr r)r*r rprÑÚ_extract_filter_tokensrBÚ_parse_filter_expressionÚfilter_column_listrÓrÔrÒ)r+rDÚcriteriaÚ col_letterrFÚ col_firstÚcol_lastr—r2r2r3Ú filter_column sD    þû ÿÿÿ   0   zWorksheet.filter_columncCs¾|js tdƒdSzt|ƒWn#ty2|}t|dƒ\}}||jkr0td|›dƒYdSYnw|j\}}||ks@||krPtd|›d|›d|›d ƒdS||j|<d |j|<d |_ dS) zî Set the column filter criteria in Excel 2007 list style. Args: col: Filter column (zero-indexed). filters: List of filter criteria to match. Returns: Nothing. rNrBrrrrú,rr) rÏr r)r*r rprÑrÓrÔrÒ)r+rDÚfiltersrrFrrr2r2r3rK s4    þû ÿÿÿ   zWorksheet.filter_column_listc CsÚ| ||dd¡r dS| ||dd¡rdS|duri}n| ¡}hd£}| ¡D]}||vr8td|›dƒdSq'd|vrC|d|d <d |vrM|d |d <d |vrWtd ƒdSd d dddddddddddœ }|d |vrxtd|d ›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“d d!“d"d!“d#d!“d$d%“d&d%“d'd%“d(d)“d*d)“d+d,“d-d,“d.d/“d0d/“d1d2“d3d2“} |d| vrþtd4|d›d5ƒdS| |d|d<|ddks|ddkr d|vrtd6ƒdSnd|d<d7d8d9d:œ} d;|vr4d7|d;<n|d;| vrGtd4|d;›d<ƒdS| |d;|d;<|d d=vrˆ|d rˆt|d ƒrˆ| |d ¡} | d>›|d <|drˆt|dƒrˆ| |d¡} | d>›|d<| d¡r£t|dƒd?kr£td@|d›dAƒdS| dB¡r¾t|dBƒd?kr¾tdC|dB›dAƒdS| d¡rÙt|dƒdDkrÙtdE|d›dFƒdS| dG¡rôt|dGƒdDkrôtdH|dG›dFƒdS|d dkrt|d t ƒr|j |d Ž} t| ƒdDkrtdI| ›dJƒdSdK|vr$d8|dK<dL|vr-d8|dL<dM|vr6d8|dM<dN|vr?d8|dN<||||gg|dO<dP|vrV|dO  |dP¡dQ|vre|dQ  dRdS¡|dQ<|j  |¡d7S)Ta Add a data validation to a worksheet. Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. options: Data validation options. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: Incorrect parameter or option. Tr?N>rVr¬ÚmaximumÚminimumrÚdropdownÚvalidateÚ error_typeÚ show_errorÚ show_inputÚ error_titleÚ input_titleÚ multi_rangeÚ other_cellsÚ ignore_blankÚ error_messageÚ input_messageúUnknown parameter 'z' in data_validation()r@r¬rVr"r$z5Parameter 'validate' is required in data_validation()ÚnoneÚwholeÚdecimalrr0r1Ú textLengthÚcustom) Úanyz any valuez whole numberr1Úintegerr2rr0r1z text lengthrør4zUnknown validation type 'z/' for parameter 'validate' in data_validation()r)r.Úbetweenrr!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ú<=zUnknown criteria type 'z/' for parameter 'criteria' in data_validation()zcParameter 'maximum' is required in data_validation() when using 'between' or 'not between' criteriarrr‡)ÚstopÚwarningÚ informationr%z' for parameter 'error_type'.©r0r1ú.16gé zLength of input title 'z' exceeds Excel's limit of 32r(zLength of error title 'éÿzLength of input message 'z' exceeds Excel's limit of 255r-zLength of error message 'zLength of list items 'z;' exceeds Excel's limit of 255, use a formula range insteadr,r#r'r&Úcellsr+r*ú$rU)rAÚcopyÚkeysr r±rrvrBr4rÚ _csv_joinr:Úreplacerórk) r+r`rarbrcr­Úvalid_parametersÚ param_keyÚ valid_typesÚcriteria_typesÚ error_typesÚ date_timerUr2r2r3Údata_validationu sD þ  ô ÿ    ÿþýüûúùø ÷ ö õ ô óòñð ÿ ÿûý  ÿÿ þ  ÿÿÿÿ ÿ       zWorksheet.data_validationcCs( | ||dd¡r dS| ||dd¡rdS|duri}n| ¡}hd£}| ¡D]}||vr8td|›dƒdSq'd|vrCtd ƒdSid 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'd(œ¥}|d|vrtd)|d›d*ƒdS|ddkr™d|d+<||d|d<id,d,“d-d.“d/d0“d1d0“d2d0“d3d4“d5d4“d6d4“d7d8“d9d8“d:d;“d“d?d>“d@dA“dBdA“dCdD“dEdFdGdHdIdJdKdLdMdNdOdPdMdPdQœ¥} dR|vrù|dR| vrù| |dR|dR<dS|vrt|dStƒrt|dSƒ ¡|dS<|ddTvrxd |d<dS|vr:t|dSƒs-tdUƒdS|  |dS¡} | dV›|dS<dW|vrYt|dWƒsLtdXƒdS|  |dW¡} | dV›|dW<dY|vrxt|dYƒsktdZƒdS|  |dY¡} | dV›|dY<id[d\“d]d^“d_d`“dadb“dcdd“dedf“dgdh“didj“dkdl“dmdn“dodp“dqdr“dsdt“dudv“dwdx“dydz“d{d|“} |dd'kr|  d}¡sÀtd~ƒdS|d}| vrÓtd€|d}›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‰|vr5|d‰} |  dŠd‹¡} dŒ|vrG|dŒrG|dŒ ¡|dŒ<|j|d<|jdŽ7_|js™|  d¡s™|  d¡s™|  d‘¡s™|  d’¡s™|  d“¡s™|  d”¡s™|  d•¡s™|  d–¡s™|  d—¡s™|  d˜¡s™|  d™¡rd|dš<|ddkr|dS}t|ƒ}|dR}|dRdDkrÇdD|d<d›|›dœ| ›d|dž<nS|dRdEkrÞdŸ|d<d |›dœ| ›d¡|dž<n<|dRdFkrødF|d<d¢| ›d£|›d¤|›d¥|dž<n"|dRdGkrdG|d<d¦| ›d£|›d¤|›d¥|dž<ntd§|›dƒ|ddkré|dRdHkr1d¨| ›d©|dž<n¸|dRdIkrAd¨| ›dª|dž<n¨|dRd«krQd¨| ›d¬|dž<n˜|dRdJkrdd­| ›d®| ›d¯|dž<n…|dRdKkrwd°| ›d±| ›d²|dž<nr|dRdLkrŠd°| ›d³| ›d´|dž<n_|dRdMkrdµ| ›d¶| ›d·|dž<nL|dRdNkr³d¸| ›d¹| ›dº| ›d»|dž<n6|dRdOkrÆd¸| ›d¼| ›d½|dž<n#|dRdPkrßd¸| ›d¾| ›dº| ›d¿| ›dÀ |dž<n tdÁ|dR›dƒ|ddkrødÂ| ›dÃ|dž<|ddkrdÂ| ›dÄ|dž<|ddkrdÅ| ›dÆ|dž<|dd!kr%dÇ| ›d¡|dž<|dd"krpdÈ|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‹¡| d’dä¡| d”dä¡| d“dã¡| 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Ìkrž|dÏdÐkržd|dÏ<|dÍdÎkr°|dÑdÐkr°d|dÑ<| |dç<z |dÏ d1¡|dÏ<Wn ttfyËYnwz |dÚ d1¡|dÚ<Wn ttfyãYnwz |dÑ d1¡|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>$r5ÚiconsrVrJr!r"Úbar_onlyrÚmax_typeÚmid_typeÚmin_typeÚ bar_colorÚ bar_solidÚ max_colorÚ max_valueÚ mid_colorÚ mid_valueÚ min_colorÚ min_valueÚ icon_styleÚ icons_onlyÚ max_lengthÚ min_lengthr*Ú stop_if_trueÚ bar_directionÚ bar_no_borderÚ data_bar_2010Ú reverse_iconsÚbar_axis_colorÚbar_border_colorÚbar_axis_positionÚbar_negative_colorÚbar_negative_color_sameÚbar_negative_border_colorÚbar_negative_border_color_samer/z' in conditional_format()r@r5z4Parameter 'type' is required in conditional_format()röÚcellIsr0r1ÚaverageÚ aboveAverageÚ duplicateÚduplicateValuesÚuniqueÚ uniqueValuesÚtopÚtop10Úbottomr„Ú time_periodÚ timePeriodÚblanksÚcontainsBlanksÚ no_blanksÚnotContainsBlanksÚerrorsÚcontainsErrorsÚ no_errorsÚnotContainsErrorsÚ 2_color_scaleÚ 3_color_scaleÚdata_barÚdataBarÚ expressionÚiconSet)rUÚicon_setzUnknown value 'z.' for parameter 'type' in conditional_format()Ú directionr7r8r9r:r;rr<r=r>r?r@rArBrCrDrErFrGrHrIrJrKrLÚ containingÚ containsTextÚ notContainsÚ beginsWithÚendsWithÚ yesterdayÚtodayÚ last7DaysÚlastWeekÚthisWeekÚnextWeekÚ lastMonthÚ thisMonthÚ nextMonth)znot containingz begins withz ends withrŸr z last 7 daysz last weekz this weekz next weekz last monthz this monthz next monthz continue weekzcontinue monthrrVrPz5Conditional format 'value' must be a datetime object.rQr"z7Conditional format 'minimum' must be a datetime object.r!z7Conditional format 'maximum' must be a datetime object.Ú3_arrowsÚ3ArrowsÚ3_flagsÚ3FlagsÚ3_traffic_lights_rimmedÚ3TrafficLights2Ú3_symbols_circledÚ3SymbolsÚ4_arrowsÚ4ArrowsÚ4_red_to_blackÚ 4RedToBlackÚ4_traffic_lightsÚ4TrafficLightsÚ 5_arrows_grayÚ 5ArrowsGrayÚ 5_quartersÚ 5QuartersÚ 3_arrows_grayÚ 3ArrowsGrayÚ3_traffic_lightsÚ3TrafficLightsÚ3_signsÚ3SignsÚ 3_symbolsÚ 3Symbols2Ú 4_arrows_grayÚ 4ArrowsGrayÚ 4_ratingsÚ4RatingÚ5_arrowsÚ5ArrowsÚ 5_ratingsÚ5Ratingrnz_The 'icon_style' parameter must be specified when 'type' == 'icon_set' in conditional_format().r‰zUnknown icon_style 'z' in conditional_format().rVÚ total_iconsÚ4rÚ5rërar*rUrUrJÚpriorityrrurgrxrzr{r|r}rtryrwrsÚis_data_bar_2010zNOT(ISERROR(SEARCH("z",z)))rUÚnotContainsTextzISERROR(SEARCH("z))zLEFT(rz)="rjzRIGHT(zInvalid text criteria 'zFLOOR(z ,1)=TODAY()-1z ,1)=TODAY()Útomorrowz ,1)=TODAY()+1zAND(TODAY()-FLOOR(z ,1)<=6,FLOOR(z ,1)<=TODAY())zAND(TODAY()-ROUNDDOWN(z*,0)>=(WEEKDAY(TODAY())),TODAY()-ROUNDDOWN(z,0)<(WEEKDAY(TODAY())+7))z",0)<=WEEKDAY(TODAY())-1,ROUNDDOWN(z ,0)-TODAY()<=7-WEEKDAY(TODAY()))zAND(ROUNDDOWN(z+,0)-TODAY()>(7-WEEKDAY(TODAY())),ROUNDDOWN(z",0)-TODAY()<(15-WEEKDAY(TODAY())))z AND(MONTH(z)=MONTH(TODAY())-1,OR(YEAR(z)=YEAR(TODAY()),AND(MONTH(z)=1,YEAR(A1)=YEAR(TODAY())-1)))z)=MONTH(TODAY()),YEAR(z)=YEAR(TODAY()))z)=MONTH(TODAY())+1,OR(YEAR(z )=12,YEAR(z)=YEAR(TODAY())+1)))zInvalid time_period criteria 'z LEN(TRIM(z))=0z))>0zISERROR(rz NOT(ISERROR(Ú colorScalerdrjrerÜrcrÛrmrrirlz#FF7128rhz#FFEF9CÚ percentilez#F8696Bz#FFEB84z#63BE7Brké2ÚautoMinÚ x14_min_typeÚautoMaxÚ x14_max_typerfz#638EC6rbFz#FF0000z#000000éÚrr)rArVrWr r4r,r.Úupperrrvr±rÚ_set_icon_propsr#r$rYÚ_get_dxf_indexr÷rörBÚ setdefaultrrmÚlstripÚKeyErrorÚAttributeErrorrôrk)r+r`rarbrcr­Úvalid_parameterr[Ú valid_typeÚ criteria_typer_Ú valid_iconsrtÚ start_cellrVrørr2r2r3Úconditional_formatx s (þÿþýüûúùø ÷ ö õ ô óòñðïí ÿ ÿþýüûúùø ÷ ö õ ô óòñðïà$      ÿþýüûúùø ÷ ö õ ô óòñðï ÿÿ ÿ        ÿþýüûúùø ÷ ö õ ôÿÿÿÿÿÿÿÿÿþÿÿÿÿþýÿÿ                                  ÿ ÿÿÿ  þzWorksheet.conditional_formatc& Csªi}i}|dur i}n| ¡}|jrtdƒdS| ||dd¡r"dS| ||dd¡r,dS||kr5||}}||kr>||}}t||||ƒ}t||dƒD]I} t||dƒD]?} |j | | f¡rr|j | | f¡} td|›d| ›d ƒ‚|j  | | f¡r|j  | | f¡} td|›d | ›d ƒ‚||j| | f<qUqLhd £} |  ¡D]} | | vr¯td | ›d ƒdSqž| dd¡|d<| dd¡|d<| dd¡|d<||}|drÔ|d8}|dkrÞtdƒdS| dd¡|d<| dd¡|d<| dd¡|d<| dd¡|d<| dd¡|d<| dd¡|d<d|vrm|d}||d<d |vr*td!|›d"ƒdSt   d#|t j ¡r:t   d$|¡rDtd%|›d&ƒdSt   d'|¡rUtd(|›d&ƒdSt   d)|¡sct   d*|¡rmtd+|›d,ƒdSd-|vrŽ|d-|d-<|d-durƒd.|d-<|d- d d.¡|d-<nd/|d-<|}|}| d¡r |d7}| d¡rª|d8}t||||ƒ|d0<t||||ƒ|d1<|dsÅd|d<|drÐ|d1|d<d}g|d2<i}t||dƒD]}|d3t|ƒd.d.d.dd.ddd4œ }d2|vrá|t|d2ƒkr |d2|d}nd}|rá| d5d¡}| d6¡r |d6|d<|d}| ¡}||vr8td7|›d&ƒdSd||<| d8¡|d9<d:|vrk|d:rk|d:}| d;¡r\| d;¡}| |¡}| |d¡}||d:<| d<¡r·|d<}|d=kr|d>}|d?krƒd@}tgdA¢ƒ}||vr—| ||d¡}n | |d¡}||dB<dC}||d<<| dDd¡}| |||||¡n| dE¡rÐ|dE}||dE<| |||| d5¡¡|durÛ| ¡|d5<|||d<|d2 |¡|drù| |||d|d9¡|d7}qßdF|vrX|dF}d}t||dƒD]F} d} t||dƒD]5} |t|ƒkrL| t||ƒkrL||| }!| |vrD| | | |!|| ¡n| | | |!d¡| d7} q|d7}qtt||dƒƒD]/\}}|d2|}"|"r|"d:r| |¡}#|"d:}t||dƒD] } | | |||#¡qƒqa|j |¡|drÓt||dƒD]/} |j || f¡rÈ|j || f¡\}$}%|$dGkrÈtdH|›dI|%›d ƒ‚dJ|f|j|| f<q£dS)KaY Add an Excel table to a worksheet. Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. options: Table format options. (Optional) Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: Incorrect parameter or option. -3: Not supported in constant_memory mode. Nz5add_table() isn't supported in 'constant_memory' moder‰Tr?rz Table range 'rrr> r¢rdÚstyleÚcolumnsÚ total_rowrÚ header_rowÚ banded_rowsÚ last_columnÚ first_columnÚbanded_columnsr/ú' in add_table()r@rêrérrz1Must have at least one data row in in add_table()rìFÚshow_first_colrëÚ show_last_colÚshow_row_stripesríÚshow_col_stripesÚheader_row_countrèÚtotals_row_shownrdú zName 'z&' in add_table() cannot contain spacesz^[\w\\][\w\\.]*$z^\dz*Invalid Excel characters in add_table(): 'rz^[a-zA-Z][a-zA-Z]?[a-dA-D]?\d+$z-Name looks like a cell name in add_table(): 'z^[rcRC]$z^[rcRC]\d+[rcRC]\d+$zInvalid name 'z#' like a RC cell ref in add_table()rærUÚTableStyleMedium9rrÚa_rangerçÚColumn) ÚidrdÚ total_stringÚtotal_functionÚ custom_totalÚ total_valuerUrJÚ name_formatrJrŠz'Duplicate header name in add_table(): 'Ú header_formatrþrUrrûÚ count_numsÚ countNumsÚstd_devÚstdDev©rrÚcountrÛrÜrÚsumÚvarrür4rýrúr¢r zTable autofilter range 'z0' overlaps previous Worksheet autofilter range 'rÀ) rVrhr rAr#rrrÃr±rrÂrWrrÚUNICODErYr.rBÚlowerrrÝrpr]ÚsetÚ_table_function_to_formularr!rÛrkr(Ú enumeraterçrÕ)&r+r`rarbrcr­rÀÚ col_formatsrtr#rDr ràr[Únum_rowsrdÚfirst_data_rowÚ last_data_rowÚcol_idÚ seen_namesrõÚcol_dataÚ user_dataÚxformatÚ header_namerUÚfunctionÚ subtotalsrVrúr¢ÚiÚjr"Ú column_dataÚformula_formatrÔrÑr2r2r3Ú add_tableo s†  ÿÿÿÿñ þ  ÿ        ÷            ÿ ÿ   ÿ    ÿ         €   ÿÿzWorksheet.add_tablecCs¸| ||dd¡r dSdt||ƒgi}|duri}hd£}| ¡D]}||vr1td|›dƒdSq d|vrrÛrÜÚaxisr5rrræÚweightÚmarkersÚreverseÚlocationÚ date_axisÚ low_colorÚ low_pointÚ high_colorÚ high_pointÚ last_colorÚ last_pointÚ empty_cellsÚ first_colorÚ first_pointÚ plot_hiddenÚ show_hiddenÚ series_colorÚ markers_colorÚnegative_colorÚnegative_pointsr/z' in add_sparkline()rrz0Parameter 'range' is required in add_sparkline()r@r5Úline)r4ÚcolumnÚwin_losszJParameter 'type' must be 'line', 'column' or 'win_loss' in add_sparkline()r6Ústackedr#ÚrangeszMMust have the same number of location and range parameters in add_sparkline()rrUrUrú!r(Úhighr&Úlowr3Únegativer-Úfirstr*Úlastr!rÜrÛrr"r/rxr r+ÚzerorÚemptyÚconnectÚspanÚgapr$ræÚseriesr0r2r1r,r)r'r%)rAr$rWr r±r4rrBrrdrYrÝrkrÚ_set_spark_colorrè)r+r#rDr­Ú sparklinerZr[Ú spark_typeÚ range_countÚlocation_countÚ sheetnameÚ new_rangesÚ spark_rangeÚ new_locationsr#r@Ú date_rangeÚstyle_idrær2r2r3Ú 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)r$r#rw)r+r`rarbrcÚpaneÚ active_cellÚsqrefr2r2r3Ú 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)r$r{)r+r#rDr2r2r3Úset_top_left_cell¨s zWorksheet.set_top_left_cellrcCs"||_||_||_||_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+ÚvisibleÚ symbols_belowÚ symbols_rightÚ auto_styler2r2r3Ú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)r|)r+r#rDÚtop_rowÚleft_colÚ pane_typer2r2r3Ú 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. r‡N)r_)r+ÚxÚyr\r]r2r2r3Ú split_panesészWorksheet.split_panesrZcCs2|dks|dkrtd|›dƒd}t|ƒ|_dS)zš Set the worksheet zoom factor. Args: zoom: Scale factor: 10 <= zoom <= 400. Returns: Nothing. é éz Zoom factor 'z"' outside range: 10 <= zoom <= 400rZN)r r)rª)r+rªr2r2r3Úset_zoomûs zWorksheet.set_zoomcCrÅ)zš Display the worksheet right to left for some versions of Excel. Args: None. Returns: Nothing. TN)r­rr2r2r3Ú right_to_left rÇzWorksheet.right_to_leftcCrÅ)z Hide zero values in worksheet cells. Args: None. Returns: Nothing. rN)r®rr2r2r3Ú hide_zerorÇzWorksheet.hide_zerocCst|ƒ|_dS)z“ Set the color of the worksheet tab. Args: color: A #RGB color index. Returns: Nothing. N)rrz©r+Úcolorr2r2r3Ú set_tab_color's zWorksheet.set_tab_colorrUcCsÊ|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|›dƒ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. rUÚ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: 'rÚpasswordN)Ú_encode_passwordrWr r¤)r+r{r­Údefaultsrär2r2r3Úprotect4sZ ÿþýüûúùø ÷ ö õ ô óòñðï  zWorksheet.protectcCsr|dur tdƒdS| d¡}| dd¡}|jd7_|dur'dt|jƒ}|r.| |¡}|j |||f¡d S) aU 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: 0: Success. -1: Parameter error. Nz1Cell range must be specified in unprotect_range()r?rrUrUrÚRanger)r rÝrYr¦r.r|r¥rk©r+rtÚ range_namer{r2r2r3Úunprotect_rangegs   zWorksheet.unprotect_rangecCsx| ||dd¡rtd|›d|›dƒdS|duri}|j}|j}dt|jƒ}t||||||ƒ}|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. TzCannot insert button at (r¦r§r?Nrr) rAr r¹r»rBrÍrrkrÅ)r+r#rDr­rÿrÝÚ button_numberÚbuttonr2r2r3Ú insert_button‰s zWorksheet.insert_buttoncCsF|r |js | ¡|s|js| ¡|_|j ¡|j}| ||||¡S)a¦ Insert a boolean checkbox in a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). boolean: The boolean value to display as a checkbox. cell_format: Cell Format object. (optional) Returns: 0: Success. -1: Row or column is out of worksheet bounds. )ÚcheckboxÚ set_checkboxrrr-rxr2r2r3Úinsert_checkbox­s   zWorksheet.insert_checkboxcCrÐ)z Set the page orientation as landscape. Args: None. Returns: Nothing. rTN©rrrr2r2r3Ú set_landscapeÑó zWorksheet.set_landscapecCrÐ)z€ Set the page orientation as portrait. Args: None. Returns: Nothing. rTNr‰rr2r2r3Ú 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+Úviewr2r2r3Ú set_page_viewís zWorksheet.set_page_viewcCrÅ)zr Set the page view mode. Args: None. Returns: Nothing. r‡Nrrr2r2r3Úset_pagebreak_viewürÇ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)r€r)r+r€r2r2r3Ú set_paper s  þzWorksheet.set_papercCrÐ)zx Center the page horizontally. Args: None. Returns: Nothing. TrN)r‚rƒrr2r2r3Úcenter_horizontallyr‹zWorksheet.center_horizontallycCrÐ)zv Center the page vertically. Args: None. Returns: Nothing. TrN)r‚r„rr2r2r3Úcenter_vertically&r‹zWorksheet.center_verticallyrWrXcCs||_||_||_||_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Úrightr…r‡r2r2r3Ú set_margins4s zWorksheet.set_marginscCóª|}| dd¡}t|ƒdkrtdƒdS|dur"t|tƒs!d|i}ni}| ¡}|dur0||d<g|_| d¡rQ| d¡|d <| | d¡|¡}d |_ |j  |¡| d ¡ro| d ¡|d <| | d ¡|¡}d |_ |j  |¡| d¡r| d¡|d <| | d¡|¡}d|_ |j  |¡|  d¡}t|jƒ}||kr­td|›d|›d|›ƒg|_dSd|vr¶|d|_ d|vr¿|d|_ ||_| dd¡|_d|_|rÓd|_dSdS)zù Set the page header caption and optional margin. Args: header: Header string. margin: Header margin. options: Header options, mainly for images. Returns: Nothing. ú &[Picture]ú&GrSzCHeader string cannot be longer than Excel's limit of 255 charactersNÚmarginÚ image_leftÚimage_data_leftÚ image_dataÚLHÚ image_centerÚimage_data_centerÚCHÚ image_rightÚimage_data_rightÚRHúNumber of footer images 'ú#' doesn't match placeholder count 'ú ' in string: Úalign_with_marginsÚscale_with_docrYT)rYrBr r4r¨rVrŽr±r¨Ú_header_positionrkrrŒrrŠr•r‰rÆ)r+rŠr­ršÚ header_origr®Úplaceholder_countÚ image_countr2r2r3Ú set_headerGóf   €        ÿÿÿ   ÿ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™rSzCFooter string cannot be longer than Excel's limit of 255 charactersNršr›rœrÚLFrŸr ÚCFr¢r£ÚRFr¥r¦r§r¨r©rYT)rYrBr r4r¨rVrr±r¨rªrkrrŒrr‹r–r‰rÆ)r+r‹r­ršÚ footer_origr®r¬r­r2r2r3Ú set_footer–r¯zWorksheet.set_footercCsH|dur|}|d7}|d7}d|›d|›}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. NrrUz:$r9)rrdr—)r+r`rbr rJr2r2r3Ú 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. Nrr7r9)r!rrdr˜)r+rarcr rJr2r2r3Úrepeat_columnsÿs     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)r…r†r‚)r+Úoptionr2r2r3Úhide_gridliness    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‡r‚rr2r2r3Úprint_row_col_headers2r‹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ˆrr2r2r3Ú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. rrr?)rorpr r™)r+r`rarbrcr r2r2r3Ú print_areaMszWorksheet.print_areacCrÐ)z„ Set the order in which pages are printed. Args: None. Returns: Nothing. rTN)ršrrr2r2r3Ú print_acrossnr‹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¡r)r+rÝrÿr2r2r3Ú 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+Ú start_pager2r2r3Úset_start_pageŽrÇzWorksheet.set_start_pagecCs>|dks|dkrtd|›dƒdSd|_t|ƒ|_d|_dS)z§ Set the scale factor for the printed page. Args: scale: Print scale. 10 <= scale <= 400. Returns: Nothing. rcrdz Print scale 'z#' outside range: 10 <= scale <= 400NrT)r rŸr)r¬r)r+Úscaler2r2r3Ú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)r›rrr2r2r3Ú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+Úbreaksr2r2r3Ú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Är2r2r3Ú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. NÚSheetr)rùr.re)r+rdr2r2r3Ú set_vba_nameÙs zWorksheet.set_vba_namecCsR|durdS| ¡}hd£}| ¡D]}||vr#td|›dƒ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?> Ú eval_errorÚ formula_rangeÚformula_differsÚformula_unlockedÚcalculated_columnÚtwo_digit_text_yearÚempty_cell_referenceÚlist_data_validationÚnumber_stored_as_textr/z' in ignore_errors()r)rVrWr r)r+r­rZr[r2r2r3Ú ignore_errorsês  þzWorksheet.ignore_errorscCsH|d|_|d|_|d|_|d|_|d|_|d|_|d|_|d|_|d |_|d |_ |d |_ |d |_ |d |_ |d|_ |d|_|d|_|d|_|d|_|d|_|jr€d|_d|_d|_d|_d|_d|_d|_d|_d|_d|_|jr¢tj|jd\}}t  |¡||_!t"|ddd|_#|j#|_$dSdS)Nrdrerfrrhrirúrürÿrýrþrrrrnrrrrg€)@érXrçà?F)Údirzw+úutf-8©ÚmodeÚencoding)%rdrerfrrhrirúrürÿrýrþrrrrnrrrrr·r¸r¹r‘r’r“r”r•r–rŒÚtempfileÚmkstempÚosÚcloserÚopenrr”)r+Ú init_dataÚfdÚfilenamer2r2r3Ú _initializesJ                     özWorksheet._initializecCs| ¡| ¡| ¡| ¡| ¡| ¡| ¡|js$| ¡n|  ¡|  ¡|  ¡|j r7|  ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡|  d¡| !¡dS)Nr )"Ú_xml_declarationÚ_write_worksheetÚ_write_sheet_prÚ_write_dimensionÚ_write_sheet_viewsÚ_write_sheet_format_prÚ _write_colsrhÚ_write_sheet_dataÚ_write_optimized_sheet_dataÚ_write_sheet_protectionÚ_write_protected_rangesrnÚ_write_phonetic_prÚ_write_auto_filterÚ_write_merge_cellsÚ_write_conditional_formatsÚ_write_data_validationsÚ_write_hyperlinksÚ_write_print_optionsÚ_write_page_marginsÚ_write_page_setupÚ_write_header_footerÚ_write_row_breaksÚ_write_col_breaksÚ_write_ignored_errorsÚ_write_drawingsÚ_write_legacy_drawingÚ_write_legacy_drawing_hfÚ_write_pictureÚ_write_table_partsÚ_write_ext_listr“Ú _xml_closerr2r2r3Ú_assemble_xml_fileGsD   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>)rorprhròrrrsrtru)r+r#rDrÞrßr2r2r3rA«s$ zWorksheet._check_dimensionscCst||j|jƒS©N)rrúr)r+Údt_objr2r2r3rvÌó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)NrUrrrUr7r9)r!r.rorprrd)r+Ú row_num_1Ú col_num_1Ú row_num_2Ú col_num_2Úrange1Úrange2r Ú row_col_onlyÚ col_char_1Ú col_char_2Ú row_char_1Ú row_char_2rJr2r2r3r Ðs0      zWorksheet._convert_name_areacCsR|sgSt|ƒ}d|vr| d¡t|ƒ}| ¡d}t|ƒ|kr'|d|…}|S)Nriÿ)r ÚremoverrxrB)r+rÅÚ breaks_setÚ breaks_listÚmax_num_breaksr2r2r3Ú_sort_pagebreaksøs   zWorksheet._sort_pagebreakscCsp|sgSt d¡}| |¡}g}|D]#}| d¡r|dd…}| d¡r*|dd…}| dd¡}| |¡q|S)Nz"(?:[^"]|"")*"|\S+rjrr?z"")rÚcompileÚfindallrrrYrk)r+r–Útoken_rer—Ú new_tokensr"r2r2r3rs         z Worksheet._extract_filter_tokenscCst|ƒdkrB|d}t d|¡rd}nt d|¡rd}n td|›d|›d ƒ| ||dd…¡}| ||d d…¡}||g|S| ||¡S) NrÚrVz(and|&&)rz (or|\|\|)rúToken 'z3' is not a valid conditional in filter expression 'rr)rBrrr Ú_parse_filter_tokens)r+r–r—Ú conditionalÚ expression_1Ú expression_2r2r2r3r3s   ÿÿ z"Worksheet._parse_filter_expressionc Csˆdddddddddddddœ }| |dd¡}|d}t d|d  ¡¡rlt|dƒ}|dks3|d kr>td |›d |›d ƒ| ¡}|dvrQtd|›d |›dƒ|d  ¡dkr\d}nd}|ddkrh|d7}t|ƒ}|s|d rtd|d ›d|›dƒt d| ¡¡r´|dvr˜td|d›d |›dƒ| ¡}|dkr§|dkr¦d}n |dkr°d}d}nd}d}|dkrÀt d|¡rÀd}||gS) Nr‡rërrVré) r<rz=~Úeqr?z!~Úner@rFrLrCrIz top|bottomriôz The value 'z' in expression 'z' must be in the range 1 to 500)rðú%z The type 'z ' must be either 'items' or '%%'r…érRr#rz0' is not a valid operator in filter expression 'rzblanks|nonblanks)r‡rëzThe operator 'z0' is not valid in relation to Blanks/NonBlanks'.rŠrõz[*?]é)r±rrr r)r r.rZ)r+r–r—Ú operatorsÚoperatorr"rVr2r2r3rPspô ÿÿ   ÿÿÿ€zWorksheet._parse_filter_tokenscCspd}|ddd…D]}|d?d@|d>d@B}|t|ƒN}q |d?d@|d>d@B}|t|ƒN}|dN}|d›S)Nrr?érrTiKÎÚX)ÚordrB)r+r{Údigestror2r2r3r|§s zWorksheet._encode_passwordcCsFt|tƒr |}|S|dur| d¡rt|dƒ}||_|St|ƒ}|S)Nr)r4r r±Ú image_name)r+r¬r­r®r2r2r3r¨¸s ú þzWorksheet._image_from_sourcer®Úimage_idÚ drawing_idc Cs¤|j|j}|j|j}|d|j9}|d|j9}| |j|j|j |j |||j ¡}t d|dƒ}t d|dƒ}|j sVtƒ}d|_||_ |j ddt|ƒddg¡n|j }tƒ}tj|_||_|j|_||_||_d|_|j |_ d|_|j|_|jdur„|j|_|jr¬|j} |  ¡} |   ¡} |j! "| j#¡s¢|j$ d | | g¡| %| j#¡| _| |_|j! "|j&¡sÄ|j$ d d t|ƒd |j'g¡| %|j&¡|_| (|¡dS) NgX@rÕé5%rú/drawingú../drawings/drawingú.xmlrú /hyperlinkú/imageú../media/imageÚ.))Ú_widthÚ_x_scaleÚ_heightÚ_y_scaleÚ_x_dpiÚ_y_dpiÚ_position_object_emusrªr©Ú _x_offsetÚ _y_offsetÚ_anchorr)rërÚembeddedrÞrkr.rrÚIMAGEÚ _drawing_typeÚ _dimensionsr,Ú _descriptionÚ_shapeÚ _rel_indexÚ _decorativer»Ú_urlÚ_targetÚ _target_moderìr±Ú_linkrãÚ_get_drawing_rel_indexÚ_digestÚ_image_extensionÚ_add_drawing_object) r+r®r-r.rÝrÿÚ dimensionsrëÚdrawing_objectr}ÚtargetÚ target_moder2r2r3Ú_prepare_imageÆsf ù ÿ þÿzWorksheet._prepare_imagec Csx|j|\ }}}}}}} } } } } |  d|jd¡}|  d|jd¡}||9}||9}| ||||||| ¡}td|dƒ}td|dƒ}|jsatƒ}d|_||_|j   dd t |ƒd dg¡n|j}t d d | ƒ}| |_ tƒ}tj|_||_||_||_| |_||_| |_d |_| |_t | ¡}|rµ| ¡}| ¡}|j |j¡s«|j   d||g¡| !|j¡|_||_"| #|¡dS)NrÝrVrÿr rÕr/rr0r1r2ÚrectÚTextBoxrr3)$rér±r»r¹r=r)rërrArÞrkr.rr„rrÚSHAPErCrDr7r9rErFr@rGrHrÚ from_optionsrJrKrìrLrãrMrIrP)r+rer.r#rDr¶r·r¸r¹r„r½r­r»r¼rÝrÿrQrëÚshaperRr}rSrTr2r2r3Ú_prepare_shapesfôÿÿ  zWorksheet._prepare_shapecCs`t dd|j¡|_|j |j¡s!|j ddt|ƒd|j g¡|  |j¡|_ |j  |¡dS)Nz\..*$rUr4r5r6) rrgr,rîr±rNrärkr.rOÚ_get_vml_drawing_rel_indexÚ_ref_idr)r+r-r®r2r2r3Ú_prepare_header_imageYsþÿzWorksheet._prepare_header_imagecCs$|j ddt|ƒd|g¡dS)Nr4r5r6)rârkr.)r+r-Úimage_extensionr2r2r3Ú_prepare_backgroundksÿzWorksheet._prepare_backgroundc Cs|j|\ }}}}}} } } } } |d|_td|j| ƒ}td|j| ƒ}| ||||||| ¡}|j}|jsOtƒ}d|_ ||_|j   ddt |ƒdg¡n|j}t ƒ}tj|_||_||_||_||_d|_| |_| ¡|_| |_| |_| |¡|j  ddt |ƒdg¡dS)NrrÕr0r1r2z/chartz../charts/chart)rårùr)rÝrÿr=Ú chart_namerërrArÞrkr.rrÚCHARTrCrDr7r9Ú_namerFr@rMrGrErHrPrã)r+reÚchart_idr.r#rDrÁr¶r·r¸r¹r½r»r¼rÝrÿrQrdrërRr2r2r3Ú_prepare_chartqsT õ ÿÿ  ÿzWorksheet._prepare_chartc Cs¢| |||||||¡\ }}}}}} } } } } tdd|ƒ}tdd|ƒ}tdd| ƒ} tdd| ƒ} tdd| ƒ} tdd| ƒ} |||||| | | | | f S)NrÕr/)Ú_position_object_pixelsr))r+Ú col_startÚ row_startÚx1Úy1rÝrÿr½Úcol_endÚrow_endÚx2Úy2Úx_absÚy_absr2r2r3r=«s*ÿõzWorksheet._position_object_emusc Cs:d}d} |dkr!|dkr!|| |d¡7}|d8}|dkr!|dks |dkr>|dkr>|| |d¡7}|d8}|dkr>|dks)td|ƒ}td|ƒ}|jrZt|ƒD] } || | ¡7}qOn||j|7}||7}|jrwt|ƒD] } | | | ¡7} qln| |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Ûr×rrr»rØr¹)r+rgrhrirjrÝrÿr½rorprÚrow_idrkrlrmrnr2r2r3rfïsbþþ   ÿ ÿþþþþ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ërr‡rrrÕ)rvrºr)r»)r+rDr½Úmax_digit_widthÚpaddingÚpixelsrÝrxr2r2r3rqMs$  ùüþzWorksheet._size_colcCs`d}||jvr'|j|d}|j|d}|r|dkrd}|Std|ƒ}|Std|jƒ}|S)NrrrgUUUUUUõ?)rÖr)r¸)r+r#r½rvrÿrxr2r2r3rrks   üþzWorksheet._size_rowcCs0d}d}|dkr|||}|S|||}|S)Ng@g@é r2)r+rvrtrurÝr2r2r3rá€s  þzWorksheet._pixels_to_widthcCsd|S)NrXr2)r+rvr2r2r3rŒszWorksheet._pixels_to_heightrÃc CóBd}| |j|j|j|j|j|j|¡}| |j¡| |j¡|S©Nr)rfÚ start_colÚ start_rowr¶r·rÝrÿrk)r+rÃr½Úverticesr2r2r3Ú_comment_verticesóù zWorksheet._comment_verticesr„c Crxry)rfrDr#r¶r·rÝrÿrk)r+r„r½r|r2r2r3Ú_button_vertices£r~zWorksheet._button_verticescCs(g}t|j ¡ƒ}|D]4}t|j| ¡ƒ}|D]&} |j|| } | | ¡| _| jdur0|j| _| jdur9|j| _|  | ¡qq |j D]} |  | ¡| _qC|j   ddt |ƒdg¡|jrn||_|j  ddt |ƒdg¡t|ƒ} |} tt| dƒƒD]}| |d}|›d |›}q|||_||_| S) Nú /vmlDrawingú../drawings/vmlDrawingú.vmlz /commentsz ../commentsr2r`rr)rìrÈrWr}r|Ú is_visiblerËrËrÊrkrÍrràr.rÇrÉrßrBrrr)r rÌ)r+r rÌÚvml_drawing_idÚ comment_idrÈÚrow_numsr#Úcol_numsrDrÃr„rÚ start_data_idrÚdata_idr2r2r3Ú_prepare_vml_objects¶s>    ô ÿÿ zWorksheet._prepare_vml_objectscCs&||_|j ddt|ƒdg¡dS)Nr€rr‚)rÎràrkr.)r+rÎr„r2r2r3Ú_prepare_header_vml_objectsësÿz%Worksheet._prepare_header_vml_objectscCsŠ|jD]?}||d<| d¡durdt|ƒ|d<|d ¡}||vr,td|d›dƒ‚d||<|j ddt|ƒd g¡|d 7}qdS) NrùrdÚTablezDuplicate name 'z ' used in worksheet.add_table().Tz/tablez../tables/tabler2r)rçr±r.r rrárk)r+Útable_idÚseenrÀrdr2r2r3Ú_prepare_tablesôs  ÿÿ ëzWorksheet._prepare_tablesc Cs„d}| dd¡}| dd¡}| dd¡}| dd ¡}d d d d dddddœ}||vr8||}d|›d|›d}|Std|›dƒ|S)NrUrz''ú#z'#ú]z']ú[z'[éeéfégéhéiékéménrz SUBTOTAL(z,[z])zUnsupported function 'rî)rYr )r+rÚcol_namerUrÚfunc_numr2r2r3r  s(    ø þz$Worksheet._table_function_to_formulacCs$||vrdSdt||ƒi||<dS)NÚrgb)r)r+rFr­Ú user_colorr2r2r3rE*szWorksheet._set_spark_colorc Csø|jrdSg}t||dƒD]k}||jvr| d¡qt||dƒD]V}||j|vrs|j||}|jj} | dvrC| |jd›¡q"| dkrV|j} |j  | ¡} | | ¡q"| dvri|j } | durcd} | | ¡q"| dkrr| d ¡q"| d¡q"q|S) Nr2r©rLrPrQrMrérrIrU) rhrrrÀrkrrïrIr:rfÚ_get_shared_stringrV) r+rhrgrlrkr¢rôrõrör÷rer:rVr2r2r3Ú_get_range_data1s8      € á!zWorksheet._get_range_datacGsdd„|Dƒ}d |¡S)NcSs"g|] }t|tƒs t|ƒn|‘qSr2)r4r.)rCÚitemr2r2r3rEjs"z'Worksheet._csv_join..r)rl)r+rðr2r2r3rXfs 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}r#z%25rjz%22rõz%20rFz%3crCz%3er’z%5br‘z%5dú^z%5eú`z%60rXz%7brz%7d)rrZrY)r+r}r2r2r3Ú _escape_urlns            zWorksheet._escape_urlcCsR|dur|jd7_|jS|j |¡r|j|S|jd7_|j|j|<|jS©Nr)rírìr±©r+rSr2r2r3rM‚s   z Worksheet._get_drawing_rel_indexcCs6|j |¡r |j|S|jd7_|j|j|<|jSr¦)rîr±rïr§r2r2r3r\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)NÚrPrÚbrÚstrikeÚoutlineÚshadowrÚ superscriptr‡Ú subscriptÚszÚvalr?ÚthemeÚindexedrÚrFontÚfamilyÚCalibriÚscheme)rñrÚboldÚ_xml_empty_tagÚitalicÚfont_strikeoutÚ font_outlineÚ font_shadowÚ underlineÚ_write_underlineÚ font_scriptÚ_write_vert_alignÚ font_sizer±Ú _write_colorÚ color_indexedÚ font_colorÚ_get_palette_colorÚ_write_rstring_colorÚ font_nameÚ font_familyÚ hyperlinkÚ font_schemer“)r+Ú xf_formatÚ xml_writerrir2r2r3r‘žsD              zWorksheet._write_fontcCsDg}|dkr dg}n|dkrdg}n|dkrdg}|j d|¡dS)Nr‡)r°Údoubleé!)r°ÚsingleAccountingé")r°ÚdoubleAccountingÚu©rñr¸)r+r½rr2r2r3r¾ÔszWorksheet._write_underlinecCsd|fg}|j d|¡dS)Nr°Ú vertAlignrÓ©r+r°rr2r2r3rÀâó zWorksheet._write_vert_aligncCs||fg}|j d|¡dS©NrirÓ©r+rdrVrr2r2r3rÆèrÖzWorksheet._write_rstring_colorcCs$|ddkr |dd…}d| ¡S)NrrrÚFF)rÙrhr2r2r3rÅîs   zWorksheet._get_palette_colorcCs|js |j ¡d|_dSdS)NT)r rrÞrr2r2r3Ú _opt_closeõs  þzWorksheet._opt_closecCs2|jr|j}t|ddd|_d|_|j|_dSdS)Nza+r×rØF)r rrßrr”)r+râr2r2r3Ú _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]w}|| d¡dur”||d||d<||d}t|tƒr”| d¡r”| d¡||d<|| d¡rÊd}||d|vr²td||d›dƒn||d||d<||ddkrÊd||d<|| d¡} | rÝ| dkrÝd||d<qf|S)NFrÚpercent)rrVr5rVéCrVrÎrréKrÓér‡rëéPé<é(r\rr5)rÜrÒrIrUzUnknown icon property type 'z2' for sub-property 'type' in conditional_format().rIÚnumrrCT) rrrkrBr±r4r.rrÝr ) r+rÊÚ user_propsÚpropsrFÚmax_datarÚtmpr\rr2r2r3rÚsN            ÿ   €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:rrØzxmlns:mcz xmlns:x14ac)z mc:IgnorableÚx14acr )rmrkr)r+ÚschemarèÚxmlns_rÚxmlns_mcÚ ms_schemaÚ xmlns_x14acrr2r2r3råIs  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)NrQrr7Ú dimensionr)rrrtrur$rsr¸)r+rr;r<r2r2r3rç]s    zWorksheet._write_dimensioncCs | d¡| ¡| d¡dS)NÚ sheetViews)rÚ_write_sheet_viewr“rr2r2r3rè€s zWorksheet._write_sheet_viewscCsfg}|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–|j r«|  d|¡| ¡| ¡| d¡dS| d|¡dS)N)Ú showGridLinesr)ÚshowRowColHeadersr)Ú showZerosr©Ú rightToLeftr)Ú tabSelectedr©ÚshowOutlineSymbolsrr)rŽÚ pageLayoutr‡)rŽÚpageBreakPreviewrUÚ topLeftCellrZÚ zoomScalerÚzoomScaleNormalÚzoomScalePageLayoutViewÚzoomScaleSheetLayoutView)ÚworkbookViewIdrÚ sheetView)r†rkrˆr®r­r~rµrør{rªr«r|rwrÚ _write_panesÚ_write_selectionsr“r¸©r+rr2r2r3rñ‰sD                 zWorksheet._write_sheet_viewcCsŠ|j}|j}|j}d|fg}|j|jkr| d¡|jr!| d¡|r*| d|f¡|r3| d|f¡|jdkr=| d¡| d|¡dS) NÚdefaultRowHeight©Ú customHeightr)Ú zeroHeightrÚoutlineLevelRowÚoutlineLevelColrØ©zx14ac:dyDescentz0.25Ú sheetFormatPr)r¸r°r±r·rkr½rmr¸)r+r¸Ú row_levelÚ col_levelrr2r2r3réÄ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)rvrrìrWÚ_write_col_infor“)r+rarcÚprev_col_optionsÚ deleted_colÚdeleted_col_optionsrDÚ col_optionsr2r2r3rêÜ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)Nrrr]rÚrërÕgp@rÜrÛrÝrQræ)rxrB)ÚbestFitrB)Ú customWidthrBÚ outlineLevel)rØrBrD)Ú _get_xf_indexr)rrkr¸)r+Úcol_minÚcol_maxrvrÝr;rxrÙrØrþÚ custom_widthÚxf_indexrtrurr2r2r3rsjÿþÿûÿ ÿþÿûÿ  ý    zWorksheet._write_col_infocCs8|jdur | d¡dS| d¡| ¡| d¡dS)NÚ sheetData)rrr¸rÚ _write_rowsr“rr2r2r3rëHs  zWorksheet._write_sheet_datacCs‚|jdur | d¡dS| d¡d}|j d¡|j |¡}|r/|j |¡|j |¡}|s!|j ¡t   |j ¡|  d¡dS)Nrir) rrr¸rrÚseekÚreadr”r*rÞrÝÚunlinkrr“)r+Ú buff_sizer¢r2r2r3rìRs      þ  z%Worksheet._write_optimized_sheet_datacCsDd|jfd|jfd|jfd|jfd|jfd|jfg}| d|¡dS)Nr”r•r…r‡rŠr‹Ú pageMargins)r‘r’r“r”r•r–r¸rr2r2r3röjsú 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)NÚ paperSizerZrÁrÚ fitToWidthÚ fitToHeight)Ú pageOrderÚ overThenDownÚfirstPageNumber)rÚportrait)rÚ landscape)Ú blackAndWhiterBr)ÚuseFirstPageNumberrBÚ horizontalDpiÚ verticalDpiÚ pageSetup)rr€rkr¬rŸr r¡ršržrr›rjr r r¸rr2r2r3r÷wsB        €zWorksheet._write_page_setupcCs^g}|jsdS|jr| d¡|jr| d¡|jr| d¡|jr'| d¡| d|¡dS)N)ÚhorizontalCenteredr)ÚverticalCenteredr)Úheadingsr)Ú gridLinesrÚ printOptions)r‚rƒrkr„r‡r…r¸rr2r2r3rõÅs    zWorksheet._write_print_optionscCszg}|js | d¡|js| d¡|jr0| d|¡|jr"| ¡|jr)| ¡|  d¡dS|j r;|  d|¡dSdS)N)Ú scaleWithDocr)ÚalignWithMarginsrÚ headerFooter) rrkrŒr‰rrŠÚ_write_odd_headerr‹Ú_write_odd_footerr“rnr¸rr2r2r3røÞs   ÿzWorksheet._write_header_footercCó| d|j¡dS)NÚ oddHeader)r’rŠrr2r2r3r:òózWorksheet._write_odd_headercCr<)NÚ oddFooter)r’r‹rr2r2r3r;ö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)Nrrêr#)Ú_calculate_spansrrrrrsr©rÈrÀr)rÄÚ _write_rowrtruÚ _write_cellr“Ú_write_empty_row)r+rôÚ span_indexrBrõÚcol_refr2r2r3rú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)Nrr#) ròr©rÈrÀrArrrtrurBr“rCÚclear)r+Úcurrent_row_numrôrBrõrEr2r2r3rD"s   € zWorksheet._write_single_rowcCs8i}d}d}t|j|jdƒD]‡}||jvr   €   € € zWorksheet._calculate_spansc Cs>d}|r |\}}}} } nd\}}}} } |dur|j}d|dfg} |r'| ¡}|r0|  d|f¡|r9|  d|f¡|r@|  d¡||jksO||jkrX||jkrX|  d|d ›f¡|r_|  d ¡||jksn||jkrs||jkrs|  d ¡| r||  d | f¡| rƒ|  d ¡|jdkr|  d¡|r—| d| ¡dS| d| ¡dS)Nr)NNrrrrŠrrHÚs)Ú customFormatrÚhtÚg)rxrrr)rØrrØr r#)r¸rrkr·rmÚ_xml_empty_tag_unencodedÚ_xml_start_tag_unencoded) r+r#rHÚ propertiesÚ empty_rowrrÿr;rxrÙrØrr2r2r3rArs@        zWorksheet._write_rowcCs|j|||dddS)NT)rR)rA)r+r#rHrQr2r2r3rC©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)NrŠrKrrŸråzzrO)rŒr©r)rMz#N/Az#NAME?z#NULL!rLz#REF!r°rU)rŒÚe)rŒr.rRre)ÚcmrÚcrIrNrKÚvm)$r%rJrrkr©rvrrïÚ_xml_number_elementrIr:rhÚ_xml_string_elementÚ_escape_control_charactersrrÚ_xml_rich_inline_stringrÚ_xml_inline_stringrVr4r,r.Ú_xml_formula_elementrUrsrr*rÚ_write_cell_array_formularrÚ_write_cell_valuer“r¸ryrf)r+r#rDrörtrrÚrow_xfÚcol_xfÚtype_cell_namer:r‹rVÚ error_codesr2r2r3rB­s‚                ÿ           úzWorksheet._write_cellcCs|durd}| d|¡dS)NrUÚv©r’)r+rVr2r2r3r^#szWorksheet._write_cell_valuecCsdd|fg}| d||¡dS)N)rŒÚarrayrr$rd)r+rUrtrr2r2r3r]*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)NÚcodeName)Ú filterModerÚsheetPr) rŸrÒrzr¶rùrkrÚ_write_tab_colorÚ_write_outline_prÚ_write_page_set_up_prr“r¸rr2r2r3ræ0s.ÿþýüû  zWorksheet._write_sheet_prcCs |jsdSdg}| d|¡dS)N)Ú fitToPagerÚ pageSetUpPr)rŸr¸rr2r2r3rkLszWorksheet._write_page_set_up_prcCs(|j}|sdSd|fg}| d|¡dS)NrÚtabColor)rzr¸)r+rirr2r2r3riTs  zWorksheet._write_tab_colorcCs^g}|jsdS|jr| d¡|js| d¡|js| d¡|js'| d¡| d|¡dS)N)Ú applyStylesr)Ú summaryBelowr)Ú summaryRightrrøÚ outlinePr)r¶r²rkr³r´rµr¸rr2r2r3rj_s    zWorksheet._write_outline_prcCó\| |j¡}|s dSt|ƒ}d|fd|fg}| d|¡|D]}| |d¡q| d¡dS)NrÚmanualBreakCountÚ rowBreaksiÿ?)rr¢rBrÚ _write_brkr“)r+Ú page_breaksrrrôr2r2r3rùqó þ zWorksheet._write_row_breakscCrs)NrrtÚ colBreaksiÿÿ)rr£rBrrvr“)r+rwrrrõr2r2r3rú†rxzWorksheet._write_col_breakscCs"d|fd|fdg}| d|¡dS)NrùrÛ)ÚmanrÚbrk©r¸)r+Úbrk_idÚbrk_maxrr2r2r3rv›szWorksheet._write_brkcCóN|j}t|ƒ}|s dSd|fg}| d|¡|D]}| |¡q| d¡dS)NrÚ mergeCells)rÁrBrÚ_write_merge_cellr“)r+rÂrrÚ merged_ranger2r2r3rñ¡ó   zWorksheet._write_merge_cellsc CsF|\}}}}t||ƒ}t||ƒ}|d|}d|fg} | d| ¡dS)Nr7rÚ mergeCell)r$r¸) r+r‚Úrow_minrÚrow_maxrr;r<rrr2r2r3r³s     zWorksheet._write_merge_cellcCsøt|j ¡ƒ}|s dS| d¡|D]b}t|j| ¡ƒ}|D]T}|j||}|jrG|j|rG|j||rG|j||}|jjdkrGd|_|jt j t j fvrl|j d7_ |  |||j |¡|j d| ¡dg¡q| |||¡qq| d¡dS)NrûrMTrr3ÚExternal)rìrûrWrrÀrrïÚ_is_object_linkÚ _link_typerÚURLÚEXTERNALrÚÚ_write_hyperlink_externalrÝrkrJÚ_write_hyperlink_internalr“)r+r†rôr‡rõr}rör2r2r3rôÀs.   ÿ ÿçzWorksheet._write_hyperlinksr#rDÚid_numr}cCsxt||ƒ}dt|ƒ}d|fd|fg}|jr| d|jf¡|jr)| d|jf¡|jr4| d|jf¡| d|¡dS)NÚrIdrúr:idr#ÚdisplayÚtooltiprÉ)r$r.r@rkrˆrr‚r¸)r+r#rDrŽr}rÚr_idrr2r2r3rŒòs  z#Worksheet._write_hyperlink_externalcCsRt||ƒ}d|fd|jfg}|jr| d|jf¡| d|jf¡| d|¡dS)Nrr#r’r‘rÉ)r$rLr‚rkrr¸)r+r#rDr}rrr2r2r3rs z#Worksheet._write_hyperlink_internalcCsN|jsdSd|jfg}|jr| d|¡| ¡| d¡dS| d|¡dS)NrÚ autoFilter)rÐrÒrÚ_write_autofiltersr“r¸rr2r2r3rðs  zWorksheet._write_auto_filtercCsT|j\}}t||dƒD]}||jvrq |j|}|j|}| ||||¡q dSr¦)rÑrrrÓrÔÚ_write_filter_column)r+Úcol1Úcol2rDr—rÔr2r2r3r•"s    özWorksheet._write_autofilterscCsBd|fg}| d|¡|dkr| |¡n| |¡| d¡dS)NÚcolIdÚ filterColumnr)rÚ_write_filtersÚ_write_custom_filtersr“)r+rrÔr rr2r2r3r–3s    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)rŠ)r.r )rCÚfilterr2r2r3rEDs z,Worksheet._write_filters..)rQrrrr )rBr¸rrìÚ _write_filterr“)r+r Ú non_blanksrrr2r2r3r›Bs   zWorksheet._write_filterscCód|fg}| d|¡dS)Nr°rr|rÕr2r2r3ržVó zWorksheet._write_filtercCsŽt|ƒdkr| d¡|j|Ž| d¡dSg}|ddkr#dg}ndg}| d|¡| |d|d¡| |d|d¡| d¡dS) Nr‡Ú customFiltersr)Úandr)r£rrrVr)rBrÚ_write_custom_filterr“)r+r—rr2r2r3rœ\s     zWorksheet._write_custom_filterscCspg}ddddddddœ}||dur||}ntd|›ƒ|dkr)| d |f¡| d |f¡| d |¡dS) NrEr;rKrBr>rH)rr‡rVrrër r%zUnknown operator = r'r°Ú customFilter)r rkr¸)r+r'r°rr&r2r2r3r¤ss ù 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{rk)rkrrl)rlrrm)rmrrn)rnrro)Ú formatCellsrrp)Ú formatColumnsrrq)Ú formatRowsrrr)Ú insertColumnsrrs)Ú insertRowsrrt)ÚinsertHyperlinksrru)Ú deleteColumnsrrv)Ú deleteRowsrrw)ÚselectLockedCellsrrx)rxrr)r”rry)Ú pivotTablesrrz)ÚselectUnlockedCellsrÚsheetProtection)r¤rkr¸)r+rr­r2r2r3ríŽsR                 z!Worksheet._write_sheet_protectioncCsF|jdkrdS| d¡|jD] \}}}| |||¡q| d¡dS)NrÚprotectedRanges)r¦rr¥Ú_write_protected_ranger“r€r2r2r3rî¾s  z!Worksheet._write_protected_rangescCsBg}|r | d|f¡| d|f¡| d|f¡| d|¡dS)Nr{rTrdÚprotectedRange©rkr¸)r+rtrr{rr2r2r3r³Ês z Worksheet._write_protected_rangecCs(|jsdS|jd7_| |j¡dSr¦)rërÚÚ_write_drawingrr2r2r3rüÖszWorksheet._write_drawingscCs&dt|ƒ}d|fg}| d|¡dS)Nrrrë©r.r¸)r+r.r“rr2r2r3r¶Þs  zWorksheet._write_drawingcCó@|jsdS|jd7_dt|jƒ}d|fg}| d|¡dS)NrrrÚ legacyDrawing)rÅrÚr.r¸©r+r“rr2r2r3rýæó  zWorksheet._write_legacy_drawingcCr¸)NrrrÚlegacyDrawingHF)rÆrÚr.r¸rºr2r2r3rþór»z"Worksheet._write_legacy_drawing_hfcCr¸)NrrrÚpicture)rðrÚr.r¸rºr2r2r3rÿr»zWorksheet._write_picturecCr)NrÚdataValidations)rórBrÚ_write_data_validationr“)r+rórrÚ validationr2r2r3ró rƒz!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)$NrUrTrõr*r$r0r5rr7r'r%r)Ú errorStylerNr‡)rÁrOr,)Ú allowBlankrr#)Ú showDropDownrr')ÚshowInputMessagerr&)ÚshowErrorMessagerr(Ú errorTitler-rfr)Ú promptTitler.ÚpromptrTÚdataValidationrVr!)r#r±rkr¸rÚ_write_formula_1Ú_write_formula_2r“) r+r­rTrrTÚ row_firstrÚrow_lastrr2r2r3r¿s\                  z Worksheet._write_data_validationcCsft|tƒr|j|Ž}d|›d}nzt|ƒWnty*| d¡r(| d¡}Ynw| d|¡dS)NrjrÚformula1)r4rrXrr*rrÝr’©r+rUr2r2r3rÊls      €ýzWorksheet._write_formula_1cCóDzt|ƒWnty| d¡r| d¡}Ynw| d|¡dS)NrÚformula2©rr*rrÝr’rÏr2r2r3rË}ó    €ýzWorksheet._write_formula_2cCs6t|j ¡ƒ}|s dS|D] }| ||j|¡q dSr)rìrôrWÚ_write_conditional_formatting)r+r8Ú cond_ranger2r2r3ròŠs ÿÿz$Worksheet._write_conditional_formatscCs8d|fg}| d|¡|D]}| |¡q | d¡dS)NrTÚconditionalFormatting)rÚ_write_cf_ruler“)r+rÕÚparamsrÚparamr2r2r3rÔ–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)0Nr5rJÚdxfIdrÍrr)Ú stopIfTruerr~r'rÚcfRuler"r!rVr€Úbelow)r€rr;)Ú equalAveragerz [123] std devz([123]) std devrrr†r#)rÜrr™)r‡rrcÚrankr‚r„r›rÏrržr„rUr‰r‹rrr‘rÑr•rÎr–r—) rkr±rÚ_write_formula_elementr“rrZÚgroupr¸Ú_write_color_scaleÚ_write_data_barÚ_write_data_bar_extÚ_write_icon_set)r+rØrrrßr2r2r3rןs–                         ýzWorksheet._write_cf_rulecCrÐ)NrrUrÒrÏr2r2r3rà rÓz Worksheet._write_formula_elementcCsœ| d¡| |d|d¡|ddur| |d|d¡| |d|d¡| d|d ¡|d dur?| d|d ¡| d|d ¡| d¡dS) NrÑrermrdrkrcrirrlrjrh)rÚ _write_cfvorÂr“)r+rÙr2r2r3râs   zWorksheet._write_color_scalecCsžg}d|vr| d|df¡d|vr| d|df¡| d¡r&| d¡| d|¡| |d|d ¡| |d |d ¡| d |d ¡| d¡dS)NrqÚ minLengthrpÚ maxLengthrb©Ú showValuerr•rermrcrirrf)rkr±rrærÂr“)r+rÙrr2r2r3rã-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)rerBrõrkrÚ _write_extr’r“)r+rÙÚworksheet_countÚdata_bar_countrër2r2r3räDs       zWorksheet._write_data_bar_extcCsŒg}|ddkrd|dfg}| d¡r| d¡| d¡r#| d¡| d|¡t|dƒD]}| |d |d |d ¡q/| d¡dS) Nrnr½r—rorérv)r"rrar5rVr)r±rkrÚreversedrær“)r+rÙrÚiconr2r2r3råVs      zWorksheet._write_icon_setcCs>d|fg}|dur| d|f¡|r| d¡| d|¡dS)Nr5r°)ÚgterÚcfvorµ)r+Úcf_typer°rrr2r2r3ræls  zWorksheet._write_cfvocCs||fg}| d|¡dSr×r|rØr2r2r3rÂxr¡zWorksheet._write_colorcCs|jD]}|j|ŽqdSr)rwÚ_write_selection)r+Ú selectionr2r2r3r~s  ÿzWorksheet._write_selectionscCsJg}|r | d|f¡|r| d|f¡|r| d|f¡| d|¡dS)NrRÚ activeCellrTr÷rµ)r+rRrSrTrr2r2r3röƒszWorksheet._write_selectioncCs6|j}|sdS|ddkr|j|ŽdS|j|ŽdS)Nrr‡)r|Ú_write_split_panesÚ_write_freeze_panes)r+r|r2r2r3r’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)NrUrÚ bottomRightÚtopRightÚ bottomLeftÚfrozenrÚ frozenSplitr9ÚxSplitÚySplitrüÚ activePaneÚstaterR)r$rwrkr¸)r+r#rDr\r]r^rÚy_splitÚx_splitr{r}rrSrTrFÚrow_cellÚcol_cellr2r2r3rúžsH   zWorksheet._write_freeze_panescCs¢g}d}d}d} d} |} |} |jr|jd\}} } g|_d}| r(td| dƒ} | r/| | ¡} ||krS||krStd| dddƒ}td| d dd 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®| d| d›f¡| r¹| d| d›f¡| d| f¡|rÉ| d|f¡| d|¡dS)NFrUrTr\i,rÕr[é†rVrr^rûrürýrrQrrürrR)rwr)Ú_calculate_x_split_widthr$rkr¸)r+r#rDr\r]rFrÚ has_selectionr}rSrTrrr{rrr2r2r3rùÖsT     zWorksheet._write_split_panescCsZd}d}|dkrt|||dƒ}n t||dƒ|}|dd}|d}|d}|S) NrÚrërrÕrVrr\r)r))r+rÝrtrurvÚpointsÚtwipsr2r2r3r s z"Worksheet._calculate_x_split_widthcCs^|j}t|ƒ}|s dSd|fg}| d|¡|D]}|jd7_| |j¡q| d¡dS)NrÚ tablePartsr)rçrBrrÚÚ_write_table_partr“)r+rçrrrFr2r2r3r4sþÿ zWorksheet._write_table_partscCs&dt|ƒ}d|fg}| d|¡dS)NrrÚ tablePartr·rºr2r2r3rMs þÿzWorksheet._write_table_partcCsPt|jƒ}t|jƒ}|s|sdS| d¡|r| ¡|r!| ¡| d¡dS)Nrì)rBrõrèrÚ_write_ext_list_data_barsÚ_write_ext_list_sparklinesr“)r+Ú has_data_barsÚhas_sparklinesr2r2r3r[s   zWorksheet._write_ext_listcCsB| d¡| d¡|jD]}| |¡q | d¡| d¡dS)Nz&{78C0D931-6437-407d-A8EE-F0AAD7539E65}zx14:conditionalFormattingsrí)rîrrõÚ"_write_conditional_formatting_2010r“)r+r”r2r2r3rns     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:conditionalFormattingrÕrmr×rirtrxr{rzr}r|ryr0rwú x14:dataBarú x14:cfRuleúxm:sqrefrr) 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_xmrr2r2r3r|s,    ÿþ   z,Worksheet._write_conditional_formatting_2010cCs,d}|d}d|fd|fg}| d|¡dS)Nr•rër5rùr©r)r+r”Ú rule_typerërr2r2r3r©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)NrrZrçrèrt)Úborderrrg)Úgradientrrsr”)r™Ú leftToRightr•)r™rör{)ÚnegativeBarColorSameAsPositiverr})Ú$negativeBarBorderColorSameAsPositiverryÚmiddle)Ú axisPositionr)r0)r*r0r)rkr)r+r”rqrprr2r2r3r±s2þ       ÿþ     zWorksheet._write_x14_data_barcCsHd|fg}|dvr| d|¡dS| d|¡| d|¡| d¡dS)Nr5)rÜrÛrÔrÖzx14:cfvoúxm:f)r¸rr’r“)r+r#rVrr2r2r3rØs   zWorksheet._write_x14_cfvocCr )Nrzx14:borderColorr|©r+rrr2r2r3rãó z!Worksheet._write_x14_border_colorcCr )Nrzx14:negativeFillColorr|r,r2r2r3rèr-z(Worksheet._write_x14_negative_fill_colorcCr )Nrzx14:negativeBorderColorr|r,r2r2r3rír-z*Worksheet._write_x14_negative_border_colorcCr )Nrz x14:axisColorr|r,r2r2r3r ò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}r0r2r1r,r)r'r%r$r+úx14:sparklineGroupúx14:sparklineGroupsrí)rîÚ_write_sparkline_groupsrñrèÚ_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+rFr2r2r3r÷s$     z$Worksheet._write_ext_list_sparklinescCsn| d¡t|dƒD]$}|d|}|d|}| d¡| d|¡| d|¡| d¡q | d¡dS)Nzx14:sparklinesrr8rz x14:sparkliner+r)rrrr’r“)r+rFrrLr#r2r2r3r:%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êÚ xmlns_x14rr2r2r3rî6s þzWorksheet._write_extcCsd}d|fg}| d|¡dS)Nrrr/r")r+r!rr2r2r3r0Bs 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@rÛráÚcust_maxÚ manualMaxr4rÜÚcust_minÚ manualMinr5r4r Ú lineWeightr$)ÚdateAxisrÚdisplayEmptyCellsAsr!)r!rr:)r:rr;)r;rr=)r=rr>)r>rr<)r<rr)Ú displayXAxisrrx)Ú displayHiddenrÚ minAxisTypeÚ maxAxisTyper"rõr.)r±rkr)r+r­r@rr2r2r3r1JsV                             z Worksheet._write_sparkline_groupcCshg}| d¡r| d|df¡| d¡r| d|df¡| d¡r,| d|df¡| ||¡dS)Nrr±Útint)r±rkr¸)r+Úelementrirr2r2r3Ú_write_spark_color£s   zWorksheet._write_spark_colorcCó| d|¡dS)Nzx14:colorSeries©rJrhr2r2r3r2²rzWorksheet._write_color_seriescCrK)Nzx14:colorNegativerLrhr2r2r3r3¶rzWorksheet._write_color_negativecCs| dddi¡dS)Nz x14:colorAxisrÚFF000000rLrr2r2r3r4ºszWorksheet._write_color_axiscCrK)Nzx14:colorMarkersrLrhr2r2r3r5¾rzWorksheet._write_color_markerscCrK)Nzx14:colorFirstrLrhr2r2r3r6ÂrzWorksheet._write_color_firstcCrK)Nz x14:colorLastrLrhr2r2r3r7ÆrzWorksheet._write_color_lastcCrK)Nz x14:colorHighrLrhr2r2r3r8ÊrzWorksheet._write_color_highcCrK)Nz x14:colorLowrLrhr2r2r3r9ÎrzWorksheet._write_color_lowcCsddg}| d|¡dS)N)ÚfontIdÚ0)r5Ú noConversionÚ phoneticPrr|rr2r2r3rïÒ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)NÚ ignoredErrorsrÒÚnumberStoredAsTextrÊÚ evalErrorrÌrUrËÚ formulaRangerÍÚunlockedFormularÐÚemptyCellReferencerÑÚlistDataValidationrÎÚcalculatedColumnrÏÚtwoDigitTextYear)rrr±Ú_write_ignored_errorr“)r+Ú ignored_ranger2r2r3rûÛs>                            zWorksheet._write_ignored_errorscCs d|f|dfg}| d|¡dS)NrTrÚ ignoredErrorr|)r+r%r\rr2r2r3r[ sþzWorksheet._write_ignored_errorrry)F)Nrr_)NNN)rã)NF)rr)rrrr)NNr)NN)rZ)rUN)r)rWrWrXrX)rUNN)FF)r)ùrïÚ __module__Ú __qualname__Ú__doc__rcr%r6r*r(r<r!rJr rRrrWrrArdr[r]Ú staticmethodrpr\rur3rzr-rrr†r…r r£r¥r¯rµr¾rÂrÄrÆrÉrÌrÍrÏrÑrÓrÕr×rHràrârþrrrr rrrr`rårrPrUrVr[r_rbrerfrgrjr~r‚r…rˆrŠrŒrrr‘r’r“r–r®r´rµr¶r¸rºr»r¼r½r¾rÀrÂrÃrÆrÇrÉrÓrãrrArvr rrrrr|r¨r r)rUr[r^r`rer=rfrqrrrárr r}rrrŠr‹rr rEr¡rXr¥rMr\r‘r¾rÀrÆrÅrÚrÛrÚrårçrèrñrérêrrërìrör÷rõrør:r;rrDr@rArCrBr^r]rærkrirjrùrúrvrñrrôrrŒ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Ârrörrúrùr rrrrrrrrrrrr rr:rîr0r1rJr2r3r4r5r6r7r8r9rïrûr[Ú __classcell__r2r2rr3rSÇsZ ]& U  !   ø,ø -8 $ ÷6   * y,3F!  ÿ=ÿ   : ÿL )<*ÿyW@ " ÿ   3"##     O O     /. d!(!W þý üNE:D ^   5    5   6      E  # ;  ( D  N    ( %+7  v          &2         0    M  l       8 G      -  '     .   Y          -rS)Hr/rNrÝrrÛÚ collectionsrrr2rÚ fractionsrÚ functoolsrÚiorr r Úwarningsr Úxlsxwriter.commentsr Úxlsxwriter.imager Úxlsxwriter.urlrrÚxlsxwriter.vmlrrUrrërrrÚ exceptionsrrrJrrZrÚutilityrrrrrrr r!r"r#r$r%r&rÚVERBOSErYr6rArHrSr³rPrEr{r^rwr–rqrSr2r2r2r3ÚsT            8 á(       ÿ