U ª…7h^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\(cstˆƒ‡fdd„ƒ}|S)zn Decorator function to convert A1 notation in cell method calls to the default row/col notation. csVz|r|d}t|ƒWn,tk rDt|ƒ}||dd…}YnXˆ|f|ž|ŽS©Nrr)ÚintÚ ValueErrorr )ÚselfÚargsÚkwargsZ first_argÚnew_args©Úmethod©úN/var/www/formularioweb/env/lib/python3.8/site-packages/xlsxwriter/worksheet.pyÚ cell_wrapperds z'convert_cell_args..cell_wrapperr©r/r2r0r.r1Úconvert_cell_args]s r4cstˆƒ‡fdd„ƒ}|S)zo Decorator function to convert A1 notation in range method calls to the default row/col notation. c s®z|rt|dƒWnˆtk rœd|dkr\|d d¡\}}t|ƒ\}}t|ƒ\}}nt|dƒ\}}||}}||||g} |  |dd…¡| }YnXˆ|f|ž|ŽS)Nrú:r©r(r)Úsplitr Úextend) r*r+r,Úcell_1Úcell_2Zrow_1Úcol_1Zrow_2Úcol_2r-r.r0r1r2|s     z(convert_range_args..cell_wrapperrr3r0r.r1Úconvert_range_argsusr=cstˆƒ‡fdd„ƒ}|S)zq Decorator function to convert A1 notation in columns method calls to the default row/col notation. c sŒz|rt|dƒWnftk rzdd„|d d¡Dƒ\}}t|ƒ\}}t|ƒ\}}||g}| |dd…¡|}YnXˆ|f|ž|ŽS)NrcSsg|] }|d‘qS)Ú1r0)Ú.0Úcolr0r0r1Ú ¤sz?convert_column_args..column_wrapper..r5rr6) r*r+r,r9r:Ú_r;r<r-r.r0r1Úcolumn_wrapperœs   z+convert_column_args..column_wrapperr)r/rCr0r.r1Úconvert_column_args•srDÚBlankÚformatÚErrorzerror, format, valueÚNumberznumber, formatÚStringzstring, formatÚBooleanzboolean, formatÚFormulazformula, format, valueÚDatetimeÚ RichStringzstring, format, raw_stringÚ ArrayFormulaz$formula, format, value, range, atypecsþ 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„Zedïdd„ƒZedðdd„ƒZdñd!d"„Zed#d$„ƒZdò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(ddJdK„Z)dLdM„Z*dNdO„Z+dPdQ„Z,dRdS„Z-dTdU„Z.dVdW„Z/dXdY„Z0e1ddZd[„ƒZ2e1dd\d]„ƒZ3dd_d`„Z4ddadb„Z5ddcdd„Z6ddedf„Z7eddgdh„ƒZ8edidj„ƒZ9dkdl„Z:dmdn„Z;eddodp„ƒZed dudv„ƒZ?edwdx„ƒZ@ed dydz„ƒZAd d|d}„ZBedd~d„ƒZCedd€d„ƒZDddƒd„„ZEd…d†„ZFd‡dˆ„ZGd‰dŠ„ZHddŒd„ZIddŽd„ZJeddd‘„ƒZKedd’d“„ƒZLd”d•„ZMd–d—„ZNdd˜d™„ZOdšd›„ZPdœd„ZQdždŸ„ZRd d¡„ZSdd¤d¥„ZTdd¦d§„ZUdd¨d©„ZVddªd«„ZWe1dd¬d­„ƒZXdd®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ÄZcddÄdÅ„ZdddÆdÇ„ZedÈdÉ„ZfdÊdË„ZgddÌdÍ„ZhdÎdÏ„ZidÐdÑ„ZjdÒdÓ„ZkdÔdÕ„ZldÖdׄZmdØdÙ„ZndÚdÛ„ZoddÜdÝ„ZpeqererdÞœdß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}e~dõœdöd÷„Ze€døœdùdú„Zdûdü„Z‚dýdþ„Zƒdÿd„Z„dd„Z…dd„Z†dd„Z‡dd„Zˆd d „Z‰d"d d „ZŠd#d d„Z‹dd„ZŒdd„Zdd„ZŽdd„Zdd„Zdd„Z‘dd„Z’d$dd„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/d0„Zœd1d2„Zd3d4„Zžd5d6„ZŸd7d8„Z d9d:„Z¡d;d<„Z¢d=d>„Z£d%d?d@„Z¤dAdB„Z¥d&dCdD„Z¦d'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³d_d`„Z´ererereµdaœdbdc„Z¶erereµddœdedf„Z·dgdh„Z¸didj„Z¹dkdl„Zºdmdn„Z»dodp„Z¼dqdr„Z½dsdt„Z¾dudv„Z¿dwdx„ZÀdydz„ZÁd{d|„ZÂd}d~„ZÃdd€„ZÄdd‚„ZÅdƒd„„ZÆd…d†„ZÇd‡dˆ„ZÈd‰dŠ„ZÉd‹dŒ„ZÊddŽ„ZËdd„ZÌd‘d’„ZÍd“d”„ZÎd•d–„ZÏd—d˜„ZÐd™dš„ZÑd›dœ„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­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_chartsheetZ ext_sheetsZ fileclosedÚ excel_versionÚexcel2003_styleÚ xls_rowmaxÚ xls_colmaxÚ xls_strmaxÚ dim_rowminÚ dim_rowmaxÚ dim_colminÚ dim_colmaxÚcol_infoÚ selectionsÚhiddenZactiveÚ tab_colorÚ top_left_cellÚpanesÚ active_paneÚselectedÚpage_setup_changedÚ paper_sizeÚ orientationÚprint_options_changedÚhcenterÚvcenterÚprint_gridlinesÚscreen_gridlinesÚ print_headersÚrow_col_headersÚheader_footer_changedÚheaderÚfooterÚheader_footer_alignsÚheader_footer_scalesÚ header_imagesÚ footer_imagesÚheader_images_listÚ margin_leftÚ margin_rightÚ margin_topÚ margin_bottomÚ margin_headerÚ margin_footerÚrepeat_row_rangeÚrepeat_col_rangeÚprint_area_rangeÚ page_orderÚ black_whiteZ draft_qualityZprint_commentsÚ page_startÚfit_pageÚ fit_widthÚ fit_heightÚhbreaksÚvbreaksÚprotect_optionsÚprotected_rangesÚnum_protected_rangesZset_colsrÚdictÚset_rowsÚzoomÚzoom_scale_normalÚ print_scaleÚis_right_to_leftÚ show_zerosZ leading_zerosÚoutline_row_levelÚoutline_col_levelÚ outline_styleÚ outline_belowÚ outline_rightÚ outline_onÚoutline_changedÚoriginal_row_heightÚdefault_row_heightÚdefault_row_pixelsÚdefault_col_widthÚdefault_col_pixelsÚdefault_date_pixelsÚdefault_row_zeroedÚnamesZ write_matchÚtableÚmergeÚ merged_cellsÚ table_cellsÚ row_spansÚhas_vmlÚhas_header_vmlÚ has_commentsÚcommentsÚ comments_listÚcomments_authorÚcomments_visibleÚ vml_shape_idÚ buttons_listÚ vml_header_idÚautofilter_areaÚautofilter_refÚ filter_rangeÚ filter_onÚ filter_colsÚ filter_typeÚ filter_cellsÚ row_sizesÚcol_size_changedÚrow_size_changedZ last_shape_idÚ rel_countÚ hlink_countZ 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Ú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__r0r1r_Ósd      zWorksheet.__init__cGs6|dkr|j||f|žŽS|jr<| d¡r<|j||f|žŽS| d¡rb| d¡rb|j||f|žŽSd|kr²|jr²t d|¡s t d|¡s t d|¡s t d |¡r²|j||f|žŽS|j r$z@t |ƒ}|j sÚt |ƒsøt |ƒsø|j|||f|d d…žŽWSWntk rYnX|j||f|žŽS|j||f|žŽS) NrQú=z{=Ú}r5z(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Úrowr@r+Úfr0r0r1Ú_write_token_as_string¯s8ÿþ ü û ú ù "z Worksheet._write_token_as_stringcGs|j||f|žŽS)aÎ Write data to a worksheet cell by calling the appropriate write_*() method based on the type of data being passed. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). *args: Args to pass to sub functions. Returns: 0: Success. -1: Row or column is out of worksheet bounds. other: Return value of called method. ©Ú_write©r*rr@r+r0r0r1ÚwriteÕszWorksheet.writec Gs:|s tdƒ‚|d}|j}||jkrN|j|}||||f|žŽ}|dkrJn|S|dkrh|j||f|žŽS|tkr‚|j||f|žŽS|tttt fkr¤|j ||f|žŽS|t krÀ|j |||f|žŽS|t j t jt jt jfkrê|j||f|žŽSt|tttt fƒr|j ||f|žŽSt|t ƒr0|j |||f|žŽSt|tƒrN|j||f|žŽSt|ƒrj|j||f|žŽSt|tƒrˆ|j||f|žŽSz&t|ƒ}|j |||f|dd…žŽWStk rÄYn*tk rìtdt|ƒ›dƒ‚YnXzt |ƒ|j||f|žŽWStk r4tdt|ƒ›dƒ‚YnXdS)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*rr@r+rÚ token_typeZ write_handlerZfunction_returnrr0r0r1rés^  ü    zWorksheet._writeNcCs| ||||¡S)a› Write a string to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). string: Cell data. Str. format: An optional cell Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: String truncated to 32k characters. )r)r*rr@ÚstringÚ cell_formatr0r0r1Ú write_string>szWorksheet.write_stringcCs~d}| ||¡rdSt|ƒ|jkr4|d|j…}d}|jsH|j |¡}n|}|jrf||jkrf| |¡t||ƒ|j ||<|S©Nréÿÿÿÿéþÿÿÿ) Ú_check_dimensionsÚlenrkrdrbÚ_get_shared_string_indexrãÚ_write_single_rowÚCellStringTupler´)r*rr@r'r(Z str_errorÚ string_indexr0r0r1rRs  zWorksheet._write_stringcCs| ||||¡S)a„ Write a number to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). number: Cell data. Int or float. cell_format: An optional cell Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. )r©r*rr@Únumberr(r0r0r1Ú write_numbermszWorksheet.write_numbercCsÈt|ƒst|ƒrt|jrlt|ƒr0| ||d|d¡S|tjkrL| ||d|d¡S|tj krt| ||d|d¡Sntdƒ‚|jtkr†t |ƒ}|  ||¡r–dS|j r°||j kr°|  |¡t||ƒ|j||<dS)Nú#NUM!z1/0ú#DIV/0!z-1/0zUNAN/INF not supported in write_number() without 'nan_inf_to_errors' Workbook() optionr+r)r r rïr ÚmathÚinfrrrrr-rdrãr0ÚCellNumberTupler´r3r0r0r1r€s&  ÿ   zWorksheet._write_numbercCs| ||||¡S)aè Write a blank cell with formatting to a worksheet cell. The blank token is ignored and the format only is written to the cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). blank: Any value. It is ignored. cell_format: An optional cell Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. )r )r*rr@Úblankr(r0r0r1Ú write_blank¡szWorksheet.write_blankcCsL|dkr dS| ||¡rdS|jr6||jkr6| |¡t|ƒ|j||<dS)Nrr+)r-rdrãr0ÚCellBlankTupler´)r*rr@rBr(r0r0r1r µs  zWorksheet._write_blankrcCs| |||||¡S)aô Write a formula to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). formula: Cell formula. cell_format: An optional cell Format object. value: An optional value for the formula. Default is 0. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: Formula can't be None or empty. )r ©r*rr@Úformular(Úvaluer0r0r1Ú write_formulaÇszWorksheet.write_formulac Cs´| ||¡rdS|dks |dkr,tdƒdSt |¡rL| |||||||¡S| d¡rv| d¡rv| |||||||¡S| |¡}|j rš||j krš|  |¡t |||ƒ|j ||<dS)Nr+rQzFormula can't be None or emptyÚ{rr)r-r Úre_dynamic_functionÚsearchÚwrite_dynamic_array_formular r Ú_write_array_formulaÚ_prepare_formulardrãr0ÚCellFormulaTupler´r>r0r0r1r Ý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)rCrDrErF)r*Ú first_rowÚ first_colÚlast_rowÚlast_colr?r(r@r0r0r1Úwrite_array_formulaýs( ÿøzWorksheet.write_array_formulac Cs*| |||||||d¡}|dkr&d|_|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)rFr) r*rJrKrLrMr?r(r@Úerrorr0r0r1rE*sø z%Worksheet.write_dynamic_array_formulaFcCsX | d¡r|dd…}| d¡r,|dd…}| d¡rB|dd…}d|krN|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(=NrBrrrr+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()r r r Úsubr)r*r?Zexpand_future_functionsr0r0r1rGXs\      ÿÿzWorksheet._prepare_formulacCsdd|kr |Sg}d}|D]@}|dkr*| }|r:| |¡q|dkrN| d¡q| |¡qd |¡S)Nú@Fú"z [#This Row],rQ)ÚappendÚjoin)r?Zescaped_formulaZin_string_literalÚcharr0r0r1Ú_prepare_table_formulas   z Worksheet._prepare_table_formularIc Cs ||kr||}}||kr$||}}| ||¡r4dS| ||¡rDdS||kr`||kr`t||ƒ} nt||ƒdt||ƒ} | |¡}|jrœ||jkrœ| |¡t|||| |ƒ|j||<|jst||dƒD]8} t||dƒD]$} | |ksò| |krÞ|  | | d|¡qÞqÌdS)Nr+r5rr) r-r$rGrdrãr0ÚCellArrayFormulaTupler´Úranger) r*rJrKrLrMr?r(r@ÚatypeÚ cell_rangerr@r0r0r1rF-s@      ÿþÿ  ÿzWorksheet._write_array_formulacCs| ||||¡S)aŽ Write a date or time to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). date: Date and/or time as a datetime object. cell_format: A cell Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. )r#)r*rr@r r(r0r0r1Úwrite_datetimecszWorksheet.write_datetimecCsZ| ||¡rdS|jr*||jkr*| |¡| |¡}|dkrB|j}t||ƒ|j||<dS)Nr+r)r-rdrãr0Ú_convert_date_timerñÚCellDatetimeTupler´)r*rr@r r(r4r0r0r1r#vs   zWorksheet._write_datetimecCs| ||||¡S)aˆ Write a boolean value to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). boolean: Cell data. bool type. cell_format: An optional cell Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. )r©r*rr@Úbooleanr(r0r0r1Ú write_boolean‹szWorksheet.write_booleancCsP| ||¡rdS|jr*||jkr*| |¡|r4d}nd}t||ƒ|j||<dS)Nr+rr)r-rdrãr0ÚCellBooleanTupler´)r*rr@r`r(r@r0r0r1rž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*rr@Úurlr(r'Ztipr0r0r1Ú write_url¹szWorksheet.write_urlcCs¾| ||¡rdSt|tƒs>t|ƒ}|dk r0||_|dk r>||_|jd7_|jdkrltd|j›dƒdS|dkrz|j}|j s¬|j rš||j krš|  |¡|  |||j|¡||j||<dS)Nr+riúÿzIgnoring URL 'z>' since it exceeds Excel's limit of 65,530 URLs per worksheet.éüÿÿÿr)r-r$rÚ_textÚ_tiprÎr Z _original_urlròrrdrãr0rÚtextrìrcr0r0r1rÏs,    ÿ zWorksheet._write_urlcGs|j||f|žŽS)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_stringrr0r0r1Úwrite_rich_stringùszWorksheet.write_rich_stringcGs t|ƒ}d}d}d}| ||¡r$dSt|dtƒr:| ¡}tƒ}tƒ|_|j |¡tƒ} g} d} d} t |ƒdkr~t dƒdS|D]Ž} t| tƒsÜ| dkr®|   | ¡|   | ¡n |   | ¡| dkrÎt dƒd S|| 7}d } n,| dkrú| dkrút d ƒd S|   | ¡d} | d 7} q‚t| dtƒs.|j  d¡| D]^} t| tƒrZ|j  d¡|  | ¡n4g}t| ƒrr|  d¡|j d| |¡|j d¡q2|jj ¡}t |ƒ|jkrºt dƒdS|jsÐ|j |¡}n|}|jrò||jkrò| |¡t|||ƒ|j||<dS)NrrQr+rFé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().rfr'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,)Úlistr-r$rÚpoprr&râZ_set_filehandler.r rTÚ_xml_start_tagÚ _write_fontrÚ_xml_data_elementÚ _xml_end_tagÚfhÚgetvaluerkrdrbr/rãr0ÚCellRichStringTupler´)r*rr@r+Útokensr(r2Ú raw_stringrxÚdefaultÚ fragmentsÚpreviousÚposrÚ attributesr'r0r0r1rjsŠ   ÿ    ÿÿ         ÿ ÿ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_functionr0r0r1Ú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*rr@Údatar(rrPr0r0r1Ú write_row™s  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„r0r0r1Ú write_column°s  zWorksheet.write_columncCs\| ||dd¡r*td|›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)r-r Ú_image_from_sourceÚ_rowÚ_colÚ_set_user_optionsrØrT)r*rr@ÚsourceÚoptionsÚimager0r0r1Ú insert_imageÇs   zWorksheet.insert_imagecCs¬| ||¡r&td|›d|›dƒdS|dkr2i}| ||¡}| |¡| dd¡}|jr†|dkrh|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) r-r rŠrÚgetrdròrrerZget_image_indexÚCellErrorTupler´)r*rr@rŽrrr(Z image_indexr0r0r1Ú embed_imageçs"     zWorksheet.embed_imagec Cs¼| ||dd¡r*td|›d|›dƒdS|dkr6d}|dkrBi}| 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+NrQÚx_offsetrÚy_offsetÚx_scalerÚy_scaleÚobject_positionÚ descriptionÚ decorativeF)r-r r“rÛrT) r*rr@rirr–r—r˜r™Úanchorr›rœr0r0r1Úinsert_textboxs:       õÿzWorksheet.insert_textboxc Cs| ||dd¡r*td|›d|›dƒdS|dkr6i}|jsJ|jrV|jjrVtdƒdSd|_|jrjd|j_| d d ¡}| d d ¡}| d d ¡}| dd ¡}| dd ¡} | dd¡} | dd¡} |jd krÎ|j}|jd krÞ|j}|jrê|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) r-r Zalready_insertedÚcombinedr“r˜r™r–r—r×rT) r*rr@Úchartrr–r—r˜r™rr›rœr0r0r1Ú insert_chartHsP         öÿzWorksheet.insert_chartcCsN| ||¡rdSt|ƒ|jkr"dSd|_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)r-r.rkr¹r»r r¼)r*rr@Úcommentrr0r0r1Ú write_comments zWorksheet.write_commentcCs d|_dS)z† Make any comments in the worksheet visible. Args: None. Returns: Nothing. TN)r¿rr0r0r1Ú show_comments±s 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ŽZis_byte_streamrr0r0r1Úset_background¾s ÿzWorksheet.set_backgroundcCs ||_dS)z¦ Set the default author of the cell comments. Args: author: Comment author name. String. Returns: Nothing. N)r¾)r*Úauthorr0r0r1Úset_comments_author×s zWorksheet.set_comments_authorcCs|jS)zw Retrieve the worksheet name. Args: None. Returns: Nothing. )r`rr0r0r1Ú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)rrrwrarùZ activesheetrr0r0r1ÚactivateòszWorksheet.activatecCsd|_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)rwrrrr0r0r1ÚselectszWorksheet.selectcCsd|_d|_dS)zv Hide the current worksheet. Args: None. Returns: Nothing. rrN©rrrwrr0r0r1Úhides zWorksheet.hidecCsd|_d|_dS)z˜ Hide the current worksheet. This can only be unhidden by VBA. Args: None. Returns: Nothing. rlrNr«rr0r0r1Ú very_hidden%s 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)rrrarùZ firstsheetrr0r0r1Úset_first_sheet5szWorksheet.set_first_sheetc CsÚ|dkr i}||kr||}}d}| dd¡}| dd¡}| dd¡} |sR|rX|rXd} nd} | d||| ¡rpdS| d||| ¡r„dSt| dƒ} t| d ƒ} t|j| ƒ|_t||d ƒD]} |||| |dg|j| <q´d|_dS) a Set the width, and other properties of a single column or a range of columns. Args: first_col: First column (zero-indexed). last_col: Last column (zero-indexed). Can be same as first_col. width: Column width. (optional). cell_format: Column cell_format. (optional). options: Dict of options such as hidden and level. Returns: 0: Success. -1: Column number is out of worksheet bounds. NTrrFÚ collapsedÚlevelrr+ér)r“r-ÚmaxÚminr¦rYrprË) r*rKrMÚwidthr(rÚ ignore_rowrrr¯r°Ú ignore_colr@r0r0r1Ú set_columnGs,       zWorksheet.set_columncCs$|dk r| |¡}| |||||¡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*rKrMr´r(rr0r0r1Úset_column_pixels…s zWorksheet.set_column_pixelséþcCsÜ|jrtdƒdS|jdkr dSi}t| |¡dƒ}t|jj|jjjd}t |j |jdƒD]¶}|j   |¡spq\t |j |jdƒD]Ž}||j |kr‚|j ||}|jj}d}|dkr|dkrÒ|j} || } n|j} d | krêt| ƒ}n"|  d ¡D]} t| ƒ} t|| ƒ}qônÄ|d kr,d tt|jƒƒ}n¦|d kr>|j}n”|d kr\|jrVd}nd}nv|dkrÒt|jttfƒr˜|jdkrÒd tt|jƒƒ}n:t|jtƒr²t|jƒ}n t|jtƒrÒ|jrÎd}nd}|j   ||f¡rö|dkrö|d7}|  |d¡} || kr‚|||<q‚q\| !¡D]¸\}} | | d ¡}t||ƒ}|j"  |¡r¾|j"  |¡}|d}|d}|dk r |s ||kr¼||j"|d<d|j"|d<n||j"|d<d|j"|d<n|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©rIrMrIÚ rHr±rLrJéé$©rKrNééTF)#rdr rmr³r¸ÚsortedrbZ string_tableÚ __getitem__rYrlr´r“rnrorÚ__name__r'r|r"r7r²r.rr4r±r`r$r@rr(rrÉÚitemsrp)r*Ú max_widthZ col_width_maxÚstringsÚrow_numÚcol_numÚcellÚ cell_typeÚlengthZ string_idr'Z seg_lengthZ width_maxZ pixel_widthr´rpZ user_widthrrr0r0r1Úautofitžs„  ÿ               zWorksheet.autofitc CsÄ|dkr i}|jdk r|j}nd}| ||¡r2dS|dkr@|j}| dd¡}| dd¡}| dd¡}|dkrvd}|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+rrFr¯r°rr±T) rnr-r­r“r²r³r¥rŸrÌrÊ) r*rÚheightr(rZmin_colrrr¯r°r0r0r1Úset_row3s,       zWorksheet.set_rowcCs"|dk r| |¡}| ||||¡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Ïr(rr0r0r1Úset_row_pixelsms zWorksheet.set_row_pixelscCs2|dkr|j}||jkr$d|_||_|r.d|_dS)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_rowsr0r0r1Úset_default_rows  zWorksheet.set_default_rowc CsŽ||kr||krtdƒdS||kr.||}}||kr@||}}| ||¡rPdS| ||¡r`dSt||||ƒ}t||dƒD]”}t||dƒD]€} |j || f¡rÈ|j || f¡} td|›d| ›dƒ‚|j || f¡r|j || f¡} td|›d| ›dƒ‚||j|| f<qŽq||j  ||||g¡|  ||||¡t||dƒD]D}t||dƒD].} ||krr| |krrqV|  || d|¡qVqDd 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 'rQr) r r-r#rYr¶r“rr·rµrTrr ) r*rJrKrLrMr…r(r[rr@Úprevious_ranger0r0r1Ú merge_range˜sB    ÿÿzWorksheet.merge_rangec CsÄ||kr||}}||kr$||}}| ||||¡}t||||ƒ}||_||_||g|_t||dƒD]X}|j ||f¡r¬|j ||f¡\}} |dkr¬td|›d| ›dƒ‚d|f|j||f<qfdS)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ÅrYrÉr“r) r*rJrKrLrMÚareaÚrefr@rÈrÅr0r0r1Ú autofilterås"   ÿzWorksheet.autofiltercCst|jstdƒdSz t|ƒWnHtk rf|}t|dƒ\}}||jkrbtd|›dƒYdSYnX|j\}}||ks‚||kr¢td|›d|›d|›d ƒdS| |¡}t|ƒd krÈtd |›dƒ|  ||¡}t|ƒd kr|d d kr|  ||dg¡nft|ƒdkrV|d d krV|d dkrV|dd krV|  ||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()Nr>úInvalid column 'ú'úColumn 'ú%' outside autofilter() column range (rˆú))rRr±z(Incorrect number of tokens in criteria 'rlrrrÂrRé)rÃr r(r)r rjrÅÚ_extract_filter_tokensr.Ú_parse_filter_expressionÚfilter_column_listrÇrÈrÆ)r*r@ÚcriteriaÚ col_letterrBÚ col_firstÚcol_lastr{r0r0r1Ú filter_column s8     ÿ   8  zWorksheet.filter_columncCsÀ|jstdƒdSz t|ƒWnHtk rf|}t|dƒ\}}||jkrbtd|›dƒYdSYnX|j\}}||ks‚||kr¢td|›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. rÞNr>rßràrárâú,rãr) rÃr r(r)r rjrÅrÇrÈrÆ)r*r@ÚfiltersrérBrêrër0r0r1rçK s(     ÿ  zWorksheet.filter_column_listc CsÌ| ||dd¡rdS| ||dd¡r(dS|dkr6i}n| ¡}dddddd d d d d dddddddh}| ¡D]"}||krltd|›dƒdSqld|kr¤|d|d<d|kr¸|d|d<d|krÌtdƒdSdddddddddddd d!œ }|d|krtd"|d›d#ƒdS||d|d<|ddkrR| d ¡dkrR| d¡dkrRdS|ddks||ddks||dd krŒd$|d<d|d <d|kr¢td%ƒdSd$d&d'd'd'd(d(d(d)d)d*d*d+d+d,d,d-œ} |d| krîtd.|d›d/ƒdS| |d|d<|dd$ks|dd&kr2d |kr:td0ƒdSnd|d <d1d2d3d4œ} d|krZd1|d<n6|d| kr€td.|d›d5ƒdS| |d|d<|dd6kr|drt|dƒr| |d¡} | d7›|d<|d rt|d ƒr| |d ¡} | d7›|d <| d ¡r8t|d ƒd8kr8td9|d ›d:ƒdS| d¡rnt|dƒd8krntd;|d›d:ƒdS| d¡r¤t|dƒdƒdS| d¡rÚt|dƒdƒdS|ddkr(t|dt ƒr(|j |dŽ} t| ƒdú greater thanú>ú less thanú<úgreater than or equal toú>=úless than or equal toú<=zUnknown criteria type 'z/' for parameter 'criteria' in data_validation()zcParameter 'maximum' is required in data_validation() when using 'between' or 'not between' criteriarrrl)ÚstopÚwarningÚ informationz' for parameter 'error_type'.©r r!ú.16gé zLength of input title 'z' exceeds Excel's limit of 32zLength of error title 'éÿzLength of input message 'z' exceeds Excel's limit of 255zLength of error message 'zLength of list items 'z;' exceeds Excel's limit of 255, use a formula range insteadÚcellsú$rQ)r-ÚcopyÚkeysr r“rr]r.r$rrÚ _csv_joinr8ÚreplacerärT) r*rJrKrLrMrÚvalid_parametersÚ param_keyÚ valid_typesZcriteria_typesZ error_typesÚ date_timer?r0r0r1Údata_validationu sPï   ôÿ ÿ þ ý ÿ þ ý ðÿ ÿý  ÿ ÿþ ý  ÿÿÿÿ ÿ       zWorksheet.data_validationc$Cs® | ||dd¡rdS| ||dd¡r(dS|dkr6i}n| ¡}dddddd d d d d ddddddddddddddddddd d!d"d#d$d%d&d'h$}| ¡D]"}||kr’td(|›d)ƒd*Sq’d|krÊtd+ƒd*Sd,d-d.d/d0d1d2d2d3d4d5d6d7d8d9d:d;dœ}|d|krtd?|d›d@ƒd*S|ddAkr2dA|dB<||d|d<dCdDdEdEdEdFdFdFdGdGdHdHdIdIdJdJdKdLdMdNdOdPdQdRdSdTdUdVdWdTdWdXœ} d|kr®|d| kr®| |d|d<d|krÜt|dtƒrÜt|dƒ ¡|d<|ddYkr¬d,|d<d|kr0t|dƒstdZƒd*S|  |d¡} | d[›|d<d|krnt|dƒsTtd\ƒd*S|  |d¡} | d[›|d<d |kr¬t|d ƒs’td]ƒd*S|  |d ¡} | d[›|d <d^d_d`dadbdcdddedfdgdhdidjdkdldmdndoœ} |dd=kr†|  d$¡sútdpƒdqS|d$| kr tdr|d$›dsƒd*S| |d$|d$<dt|du<|d$  dv¡rRdw|du<n|d$  dx¡rjdy|du<|  |  du¡|  d'¡¡|d'<||krš||}}||kr®||}}t ||||ƒ} t||ƒ} d|krä|d} |  dzd{¡} d|kr|dr|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¡r´d|d~<|dd3kr®|d}t|ƒ}|d}|ddKkrdK|d<d|›d€| ›d|d‚<n¦|ddLkr6dƒ|d<d„|›d€| ›d…|d‚<nx|ddMkrjdM|d<d†| ›d‡|›dˆ|›d‰|d‚<nD|ddNkrždN|d<dŠ| ›d‡|›dˆ|›d‰|d‚<ntd‹|›d)ƒ|dd4krT|ddOkrÞdŒ| ›d|d‚<nv|ddPkrdŒ| ›dŽ|d‚<nT|ddkr"dŒ| ›d|d‚<n2|ddQkrJd‘| ›d’| ›d“|d‚<n |ddRkrpd”| ›d•| ›d–|d‚<nä|ddSkr–d”| ›d—| ›d˜|d‚<n¾|ddTkr¼d™| ›dš| ›d›|d‚<n˜|ddUkrèdœ| ›d| ›dž| ›dŸ|d‚<nl|ddVkrdœ| ›d | ›d¡|d‚<nF|ddWkr@dœ| ›d¢| ›dž| ›d£| ›d¤ |d‚<ntd¥|d›d)ƒ|dd5krrd¦| ›d§|d‚<|dd6krd¦| ›d¨|d‚<|dd7kr®d©| ›dª|d‚<|dd8krÌd«| ›d…|d‚<|dd9krbd¬|d<d|d<d|d <d|d<| d d­¡| d d®¡| dd¯¡| dd¯¡| dd°¡| dd±¡t|dƒ|d<t|dƒ|d<|dd:k r"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|k r"d¶|d<|dd;k rˆd|d<|  d ¡ sVd­|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­k r¾|dd¯k r¾d|d<|d d®k râ|dd¯k râd|d<| |dÀ<z|d dÁ¡|d<Wnttfk rYnXz|d dÁ¡|d<Wnttfk rLYnXz|d dÁ¡|d<Wnttfk r~YnX| |jk rž|j|  |¡n |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%rFrèr@rð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_lengthrûÚ 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Úiconsrüz' in conditional_format()r,z4Parameter 'type' is required in conditional_format()ÚcellIsr r!Ú aboveAverageÚduplicateValuesÚ uniqueValuesÚtop10riÚ timePeriodÚcontainsBlanksÚnotContainsBlanksÚcontainsErrorsÚnotContainsErrorsÚ 2_color_scaleÚ 3_color_scaleÚdataBarÚ expressionÚiconSet)rËr r!ÚaverageZ duplicateÚuniqueÚtopÚbottomriZ time_periodÚblanksZ no_blanksÚerrorsZ no_errorsrRrSÚdata_barr?Zicon_setzUnknown value 'z.' for parameter 'type' in conditional_format()rZÚ directionrrrrrr r r Ú containsTextZ notContainsÚ beginsWithÚendsWithÚ yesterdayÚtodayZ last7DaysZlastWeekZthisWeekZnextWeekZ lastMonthZ thisMonthZ nextMonth)rr r rrrrrrrrrrrrrZ containingznot containingz begins withz ends withrbrcz last 7 daysz last weekz this weekz next weekz last monthz this monthz next monthz continue weekzcontinue monthrz5Conditional format 'value' must be a datetime object.rz7Conditional format 'minimum' must be a datetime object.z7Conditional format 'maximum' must be a datetime object.Z3ArrowsZ3FlagsZ3TrafficLights2Z3SymbolsZ4ArrowsZ 4RedToBlackZ4TrafficLightsZ 5ArrowsGrayZ 5QuartersZ 3ArrowsGrayÚ3TrafficLightsZ3SignsZ 3Symbols2Z 4ArrowsGrayZ4RatingZ5ArrowsZ5Rating)Z3_arrowsZ3_flagsZ3_traffic_lights_rimmedZ3_symbols_circledZ4_arrowsZ4_red_to_blackZ4_traffic_lightsZ 5_arrows_grayZ 5_quartersZ 3_arrows_grayZ3_traffic_lightsZ3_signsZ 3_symbolsZ 4_arrows_grayZ 4_ratingsZ5_arrowsZ 5_ratingsz_The 'icon_style' parameter must be specified when 'type' == 'icon_set' in conditional_format().rnzUnknown icon_style 'z' in conditional_format().rRÚ total_iconsÚ4räÚ5rÂr"rQÚpriorityrÚis_data_bar_2010zNOT(ISERROR(SEARCH("z",z)))r?ÚnotContainsTextzISERROR(SEARCH("z))zLEFT(ríz)="rSzRIGHT(zInvalid text criteria 'zFLOOR(z ,1)=TODAY()-1z ,1)=TODAY()Ztomorrowz ,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(rãz NOT(ISERROR(Ú colorScaler³r²rz#FF7128z#FFEF9CÚ percentilez#F8696Bz#FFEB84z#63BE7Bé2ÚautoMinÚ x14_min_typeÚautoMaxÚ x14_max_typez#638EC6Fz#FF0000z#000000éÚrYr)r-r#r$r r$rrÚupperrr]r“r Ú_set_icon_propsr#r$r&Ú_get_dxf_indexrèrçr.Ú setdefaultrrgÚlstripÚKeyErrorÚAttributeErrorrårT)r*rJrKrLrMrÚvalid_parameterr(Z valid_typeZ criteria_typer*Z valid_iconsr[Z start_cellr@rÍrèr0r0r1Úconditional_formatx s¾Ü( íÿà$      ï ÿÿ ÿ        ÿþýüûúùø ÷ ö õ ôÿ ÿÿÿÿÿÿÿ                                  ÿ   zWorksheet.conditional_formatc& CsÒi}i}|dkri}n| ¡}|jr0tdƒdS| ||dd¡rDdS| ||dd¡rXdS||krj||}}||kr|||}}t||||ƒ}t||dƒD]”} t||dƒD]€} |j | | f¡rä|j | | f¡} td|›d| ›d ƒ‚|j  | | f¡r|j  | | f¡} td|›d | ›d ƒ‚||j| | f<qªq˜d d d ddddddddh } |  ¡D]&} | | krPtd| ›dƒdSqP| d d¡|d <| dd¡|d<| d d¡|d <||}|drÂ|d8}|dkrØtdƒdS| dd¡|d<| dd¡|d<| d d¡|d<| d d¡|d<| dd¡|d <| dd¡|d!<d|krö|d}||d<d"|krptd#|›d$ƒdSt   d%|t j ¡rt   d&|¡r¤td'|›d(ƒdSt   d)|¡rÆtd*|›d(ƒdSt   d+|¡sât   d,|¡rötd-|›d.ƒdSd|kr8|d|d<|ddkr"d/|d<|d d"d/¡|d<nd0|d<|}|}| d¡r\|d7}| d¡rp|d8}t||||ƒ|d1<t||||ƒ|d2<|ds¦d|d <|d r¼|d2|d <d}g|d<i}t||dƒD]H}|d3t|ƒd/d/d/dd/ddd4œ }d|krê|t|dƒkr.|d|d}nd}|rê| d5d¡}| d6¡r\|d6|d<|d}| ¡}||krŒtd7|›d(ƒdSd||<| d8¡|d9<d:|krò|d:rò|d:}| d;¡rÔ| d;¡}| |¡}| |d¡}||d:<| d<¡r–|d<}|d=krd>}|d?kr"d@}tdAd>dBdCdDd@dEdFgƒ}||krV| ||d¡}n| |d¡}||dG<dH}||d<<| dId¡}| |||||¡n2| dJ¡rÈ|dJ}||dJ<| |||| d5¡¡|dk rÞ| ¡|d5<|||d<|d |¡|dr| |||d|d9¡|d7}qÚd|krØ|d}d}t||dƒD]Œ} d} t||dƒD]j} |t|ƒkrÀ| t||ƒkrÀ||| }!| |kr°| | | |!|| ¡n| | | |!d¡| d7} q`|d7}qJtt||dƒƒD]^\}}|d|}"|"rê|"d:rê| |¡}#|"d:}t||dƒD]} | | |||#¡q.qê|j |¡|d rÎt||dƒD]^} |j || f¡r¸|j || f¡\}$}%|$dKkr¸tdL|›dM|%›d ƒ‚dN|f|j|| f<qndS)OaY 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' modernTr+rz Table range 'rÖrÕrÔrÝZbanded_columnsZ banded_rowsÚcolumnsr…Ú first_columnÚ header_rowÚ last_columnr`ÚstyleZ total_rowrüú' in add_table()r,rz1Must have at least one data row in in add_table()FZshow_first_colZ show_last_colZshow_row_stripesZshow_col_stripesZheader_row_countZtotals_row_shownú zName 'z&' in add_table() cannot contain spacesz^[\w\\][\w\\.]*$z^\dz*Invalid Excel characters in add_table(): 'ràz^[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()rQZTableStyleMedium9rYZa_rangeÚColumn) Úidr`Ú total_stringÚtotal_functionÚ custom_totalÚ total_valuer?rFÚ name_formatrFrƒz'Duplicate header name in add_table(): 'Z header_formatr‰r?rr†Z count_numsÚ countNumsZstd_devÚstdDevrWÚcountr²r³ÚsumÚvarr‡rrˆr…rÙzTable autofilter range 'z0' overlaps previous Worksheet autofilter range 'r´) r#rdr r-r#rYr·r“rr¶r$r rÚUNICODEr&rr.Úlowerr rwrWrGÚsetÚ_table_function_to_formular rrurTrÚ enumeraterÙrÉ)&r*rJrKrLrMrr´Z col_formatsr[rr@r×rzr(Znum_rowsr`Zfirst_data_rowZ last_data_rowÚcol_idZ seen_namesrÊZcol_dataÚ user_dataZxformatÚ header_namer?ÚfunctionÚ subtotalsr@r…r…ÚiÚjrZ column_dataZformula_formatrÈrÅr0r0r1Ú add_tableo sª  ÿÿõ       ÿ        ÷            øÿ ÿ   ÿ    ÿ            ÿzWorksheet.add_tablecCsö| ||dd¡rdSdt||ƒgi}|dkr0i}ddddd d d d d dddddddddddddddddh}| ¡D]"}||krptd|›d ƒdSqpd|kr¨td!ƒd"S| dd#¡}|d$krÈtd%ƒd"S|d&krÔd'}||d<d|krt|dtƒr|d|d<n|dg|d<t|dtƒr0|d|d(<n|dg|d(<t|d(ƒ}t|dƒ} || krltd)ƒd"St|dƒ|d*<t|j ƒ} g} |d(D]<} |   d+d,¡} |   d-¡} d.| krÂ| d.| } |   | ¡q’| |d(<g} |dD]}|  d+d,¡}|   |¡qä| |d<| d¡|d/<| d ¡|d0<| d ¡|d1<| d ¡|d2<| d ¡|d3<| d ¡|d <| d¡|d<| d¡|d<| d¡|d<| d¡|d<| d¡|d4<| d¡|d<| dd,¡}|d5krÒd6|d7<n|d8kræd9|d7<nd:|d7<| d¡}|rd.|kr| d.|}||d<| dd6¡}t |ƒ}|d;|d<|d1|d<|d |d<|d2|d<|d3|d<|d/|d<|d0|d<| ||d¡| ||d¡| ||d¡| ||d¡| ||d¡| ||d¡| ||d¡|j  |¡d6S)|dks|dkr$td|›dƒdSd|_t|ƒ|_d|_dS)z§ Set the scale factor for the printed page. Args: scale: Print scale. 10 <= scale <= 400. Returns: Nothing. rÎrÏz Print scale 'z#' outside range: 10 <= scale <= 400NrT)r r–r(r¢rx)r*Úscaler0r0r1Úset_print_scale›s  zWorksheet.set_print_scalecCsd|_d|_dS)z” Set the option to print the worksheet in black and white. Args: None. Returns: Nothing. TN)r”rxrr0r0r1Úprint_black_and_white±s zWorksheet.print_black_and_whitecCs ||_dS)z¿ Set the horizontal page breaks on a worksheet. Args: breaks: List of rows where the page breaks should be added. Returns: Nothing. N)r™©r*Úbreaksr0r0r1Úset_h_pagebreaks¿s zWorksheet.set_h_pagebreakscCs ||_dS)z Set the horizontal page breaks on a worksheet. Args: breaks: List of columns where the page breaks should be added. Returns: Nothing. N)ršrr0r0r1Úset_v_pagebreaksÌs zWorksheet.set_v_pagebreakscCs(|dk r||_ndt|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êrra)r*r`r0r0r1Ú set_vba_nameÙs zWorksheet.set_vba_namec Cs`|dkr dS| ¡}ddddddd d d h }| ¡D]"}||kr2td |›d ƒdSq2||_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+Únumber_stored_as_textÚ eval_errorÚformula_differsÚ formula_rangeÚformula_unlockedÚempty_cell_referenceÚlist_data_validationÚcalculated_columnÚtwo_digit_text_yearrüz' in ignore_errors()r)r#r$r rÿ)r*rr'r(r0r0r1Ú 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|_|jrd|_d|_d|_d|_d|_d|_d|_d|_d|_d|_|jrDtj|jd\}}t  |¡||_!t"|ddd|_#|j#|_$dS)Nr`rarbrùrdrerërírðrîrïrñròrôrhrõrörrg€)@érTrçà?F)Údirzw+úutf-8©ÚmodeÚencoding)%r`rarbrùrdrerërírðrîrïrñròrôrhrõrörrr¬r­r®rŠr‹rŒrrŽrr…ÚtempfileÚmkstempÚosÚcloser÷Úopenrørx)r*Z init_dataÚfdÚfilenamer0r0r1Ú _initializesH                    zWorksheet._initializecCs| ¡| ¡| ¡| ¡| ¡| ¡| ¡|jsH| ¡n|  ¡|  ¡|  ¡|j rn|  ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡| ¡|  d¡| !¡dS)NrÙ)"Z_xml_declarationÚ_write_worksheetÚ_write_sheet_prÚ_write_dimensionÚ_write_sheet_viewsÚ_write_sheet_format_prÚ _write_colsrdÚ_write_sheet_dataÚ_write_optimized_sheet_dataÚ_write_sheet_protectionÚ_write_protected_rangesrhÚ_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_listrwZ _xml_closerr0r0r1Ú_assemble_xml_fileGsD  zWorksheet._assemble_xml_filecCs¼|dks|dkrdS||jks(||jkr,dS|sH|sH|jrH||jkrHdS|s€|jdks`||jkrf||_|jdksz||jkr€||_|s¸|jdks˜||jkrž||_|jdks²||jkr¸||_dSr*)rirjrdrãrlrmrnro)r*rr@rµr¶r0r0r1r-«s$ zWorksheet._check_dimensionscCst||j|jƒS©N)rrërõ)r*Zdt_objr0r0r1r]ÌszWorksheet._convert_date_timecCsÔd}d}d}d}t|dƒ} t|dƒ} dt|dƒ} dt|dƒ} |dkrh||jdkrh| }| }d}n4|dkrŒ||jdkrŒ| }| }d}n| | }| | }||kr®|s®|}n |d|}t|jƒ} | d|}|S)NrQrrr"r5r®)r!rrirjrr`)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»r0r0r1rÚÐs0      zWorksheet._convert_name_areacCsR|sgSt|ƒ}d|kr"| d¡t|ƒ}| ¡d}t|ƒ|krN|d|…}|S)Nriÿ)r‘Úremoverrrãr.)r*r Z breaks_setZ breaks_listZmax_num_breaksr0r0r1Ú_sort_pagebreaksøs   zWorksheet._sort_pagebreakscCsp|sgSt d¡}| |¡}g}|D]F}| d¡r>|dd…}| d¡rT|dd…}| dd¡}| |¡q$|S)Nz"(?:[^"]|"")*"|\S+rSrr+z"")r ÚcompileÚfindallr r r&rT)r*rUZtoken_rer{Z new_tokensrr0r0r1rås         z Worksheet._extract_filter_tokenscCst|ƒdkr„|d}t d|¡r&d}n(t d|¡r8d}ntd|›d|›d ƒ| ||dd…¡}| ||d d…¡}||g|S| ||¡S) Nr±rRz(and|&&)rz (or|\|\|)rúToken 'z3' is not a valid conditional in filter expression 'ràrä)r.r rr Ú_parse_filter_tokens)r*rUr{Z conditionalZ expression_1Z expression_2r0r0r1ræ3s   ÿz"Worksheet._parse_filter_expressionc Cs–dddddddddddddœ }| |dd¡}|d}t d|d  ¡¡rØt|dƒ}|dksf|d kr|td |›d |›d ƒ| ¡}|dkr¢td|›d |›dƒ|d  ¡dkr¸d}nd}|ddkrÐ|d7}t|ƒ}|sþ|d rþtd|d ›d|›dƒt d| ¡¡rr|dkr4td|d›d |›dƒ| ¡}|dkrV|dkrrd}n|dkrjd}d}nd}d}|dkrŽt d|¡rŽd}||gS) NrlrÂrrRräé) rrz=~Úeqrz!~Únerrrrrz 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 '%%'rYérrer`z0' is not a valid operator in filter expression 'rÕzblanks|nonblanks)rlrÂzThe operator 'z0' is not valid in relation to Blanks/NonBlanks'.r[r‚z[*?]é)r“r rrr(r rrD)r*rUr{Ú operatorsÚoperatorrr@r0r0r1raPsjô ÿÿ  ÿ ÿ   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+érrPiKÎÚX)Úordr.)r*ræÚdigestrVr0r0r1rç§s zWorksheet._encode_passwordcCsBt|tƒr|}n.|dk r6| d¡r6t|dƒ}||_nt|ƒ}|S)Nr)r$r r“Ú image_name)r*rŽrrr0r0r1rŠ¸s  zWorksheet._image_from_source)rÚ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 s¬tƒ}d|_||_ |j ddt|ƒddg¡n|j }tƒ}tj|_||_|j|_||_||_d|_|j |_ d|_|j|_|jdk r |j|_|jr^|j} |  ¡} |   ¡} |j! "| j#¡sJ|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Ú.))Ú_widthZ_x_scaleÚ_heightZ_y_scaleZ_x_dpiZ_y_dpiÚ_position_object_emusrŒr‹Z _x_offsetZ _y_offsetÚ_anchorr(rÜrÚembeddedrÐrTrrrZIMAGEÚ _drawing_typeÚ _dimensionsrnÚ _descriptionÚ_shapeÚ _rel_indexÚ _decorativer›Ú_urlÚ_targetÚ _target_moderÝr“Ú_linkrÕÚ_get_drawing_rel_indexÚ_digestÚ_image_extensionÚ_add_drawing_object) r*rrorpr´rÏÚ dimensionsrÜÚdrawing_objectrdÚtargetÚ target_moder0r0r1Ú_prepare_imageÆsf  ù ÿ þÿzWorksheet._prepare_imagec Cs||j|\ }}}}}}} } } } } |  d|jd¡}|  d|jd¡}||9}||9}| ||||||| ¡}td|dƒ}td|dƒ}|jsÂtƒ}d|_||_|j   dd t |ƒd dg¡n|j}t d d | ƒ}| |_ tƒ}tj|_||_||_||_| |_||_| |_d |_| |_t | ¡}|rn| ¡}| ¡}|j |j¡sZ|j   d||g¡| !|j¡|_||_"| #|¡dS)Nr´rRrÏrbr/rqrrrrsrtÚrectZTextBoxrru)$rÛr“r°r®r{r(rÜrr}rÐrTrrrirrZSHAPEr~rryrzr€rr|r‚rƒrZ from_optionsr…r†rÝr‡rÕrˆr„r‹)r*rarprr@r–r—r˜r™rirrr›rœr´rÏrŒrÜÚshaperrdrŽrr0r0r1Ú_prepare_shapesrôÿÿ  zWorksheet._prepare_shapecCs`t dd|j¡|_|j |j¡sB|j ddt|ƒd|j g¡|  |j¡|_ |j  |¡dS)Nz\..*$rQrvrwrx) r rQrnrßr“r‰rÖrTrrŠÚ_get_vml_drawing_rel_indexZ_ref_idr‰)r*rorr0r0r1Ú_prepare_header_imageYsþÿzWorksheet._prepare_header_imagecCs$|j ddt|ƒd|g¡dS)Nrvrwrx)rÔrTr)r*roZimage_extensionr0r0r1Ú_prepare_backgroundksÿzWorksheet._prepare_backgroundc Cs|j|\ }}}}}} } } } } |d|_td|j| ƒ}td|j| ƒ}| ||||||| ¡}|j}|jsžtƒ}d|_ ||_|j   ddt |ƒdg¡n|j}t ƒ}tj|_||_||_||_||_d|_| |_| ¡|_| |_| |_| |¡|j  ddt |ƒdg¡dS)Nrr/rrrsrtz/chartz../charts/chart)r×r„r(r´rÏr{Z chart_namerÜrr}rÐrTrrrZCHARTr~rryrzÚ_namerr|rˆr‚r€rƒr‹rÕ)r*raZchart_idrprr@r r–r—r˜r™rr›rœr´rÏrŒr`rÜrr0r0r1Ú_prepare_chartqs` õ ÿÿ  ÿzWorksheet._prepare_chartc Cs¢| |||||||¡\ }}}}}} } } } } tdd|ƒ}tdd|ƒ}tdd| ƒ} tdd| ƒ} tdd| ƒ} tdd| ƒ} |||||| | | | | f S)Nr/rq)Ú_position_object_pixelsr()r*Ú col_startÚ row_startÚx1Úy1r´rÏrÚcol_endÚrow_endÚx2Úy2Úx_absÚy_absr0r0r1r{«s6ÿõzWorksheet._position_object_emusc Csöd}d} |dkr4|dkr4|| |d¡7}|d8}q|dkr`|dkr`|| |d¡7}|d8}q4td|ƒ}td|ƒ}|jr˜t|ƒD]} || | ¡7}q‚n||j|7}||7}|jrÒt|ƒD]} | | | ¡7} q¼n| |j|7} | |7} || ||¡kr|| |¡8}|d7}qè|| ||¡kr>|| |¡8}|d7}q|} |} | ||¡dkr`||}| ||¡dkrz||}|| | |¡kr¨|| | |¡8}| d7} qz|| | |¡krÖ|| | |¡8}| d7} q¨|}|}||||| | |||| g Sr')Ú _size_colÚ _size_rowr²rËrYr°rÌr®)r*ršr›rœrr´rÏrr¢r£r”Zrow_idržrŸr r¡r0r0r1r™ïsR          z!Worksheet._position_object_pixelscCsd}d}d}||jkr†|j|d}|j|d}|dkr@|j}|rR|dkrRd}qŒ|dkrpt|||dƒ}qŒt||dƒ|}n|j}|S)Nr±rÂrrlrärr/)rpr¯r(r°)r*r@rÚmax_digit_widthÚpaddingÚpixelsr´rrr0r0r1r¤Ms  zWorksheet._size_colcCs\d}||jkrJ|j|d}|j|d}|r<|dkr.rí)rU)r*rÆr0r0r1r%fszWorksheet._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}rez%25rSz%22r‚z%20rz%3crz%3er»z%5brºz%5dú^z%5eú`z%60rBz%7brz%7d)r rDr&)r*rdr0r0r1Ú _escape_urlns            zWorksheet._escape_urlcCsR|dkr|jd7_|jS|j |¡r2|j|S|jd7_|j|j|<|jS©Nr)rÞrÝr“©r*rŽr0r0r1rˆ‚s   z Worksheet._get_drawing_rel_indexcCs6|j |¡r|j|S|jd7_|j|j|<|jSrË)rßr“ràrÌr0r0r1r”s    z$Worksheet._get_vml_drawing_rel_indexcCsr|j}| d¡|jr | d¡|jr0| d¡|jr@| d¡|jrP| d¡|jr`| d¡|jrr|  |j¡|j dkr†|  d¡|j d krš|  d ¡| d d |j fg¡|j d krºnZ|j rÐ| d|j ¡nD|jræ| d|j¡n.|jr| |j¡}| d|¡n | dd¡| dd |jfg¡| dd |jfg¡|jdkrd|jsd| dd |jfg¡| d¡dS)NZrPrÚbr™ÚstrikeÚoutlineZshadowrZ superscriptrlZ subscriptÚszÚvalr+ÚthemeZindexedrÄZrFontÚfamilyZCalibriÚscheme)rârtÚboldÚ_xml_empty_tagÚitalicZfont_strikeoutZ font_outlineZ font_shadowÚ underlineÚ_write_underlineZ font_scriptÚ_write_vert_alignZ font_sizerÒÚ _write_colorZ color_indexedZ font_colorÚ_get_palette_colorÚ_write_rstring_colorZ font_nameZ font_familyÚ hyperlinkZ font_schemerw)r*Z xf_formatZ xml_writerrÔr0r0r1ružsD              zWorksheet._write_fontcCsDg}|dkrdg}n|dkr$dg}n|dkr2dg}|j d|¡dS)Nrl)rÑÚdoubleé!)rÑZsingleAccountingé")rÑZdoubleAccountingÚu©rârÖ)r*rØrr0r0r1rÙÔszWorksheet._write_underlinecCsd|fg}|j d|¡dS)NrÑZ vertAlignrã©r*rÑrr0r0r1rÚâs zWorksheet._write_vert_aligncCs||fg}|j d|¡dS©NrÔrã©r*r`r@rr0r0r1rÝès zWorksheet._write_rstring_colorcCs$|ddkr|dd…}d| ¡S)Nrr¹rZFF)rsrÓr0r0r1rÜîs  zWorksheet._get_palette_colorcCs|js|j ¡d|_dS)NT)rûrør8rr0r0r1Ú _opt_closeõs zWorksheet._opt_closecCs.|jr*|j}t|ddd|_d|_|j|_dS)Nza+r1r2F)rûr÷r9rørx)r*r;r0r0r1Ú _opt_reopenûs zWorksheet._opt_reopenc CsÎg}t|ƒD]}| ddddœ¡q |dkrDd|dd<d|d d<|d krpd |dd<d |d d<d |dd<|dkr¨d|dd<d|d d<d|dd<d|dd<|rÊt|ƒ}||krÆ|d }t|ƒD]ú}|| d¡dk r0||d||d<||d}t|tƒr0| d¡r0| d¡||d<|| d¡r¢d}||d|krptd||d›dƒn2||d||d<||ddkr¢d||d<|| d¡} | rÎ| dkrÎd||d<qÎ|S)NFrÚpercent)rèr@r%rRéCr@ràrräéKrmérlrÂéPé<é(rXrr%)rérlr4r?zUnknown icon property type 'z2' for sub-property 'type' in conditional_format().r4ÚnumrèrT) rYrTr.r“r$rr rwr ) r*reZ user_propsÚpropsrBZmax_datar™Útmpr)rèr0r0r1rtsL            ÿ  zWorksheet._set_icon_propscCsxd}|d}|d}|d}d}|d}d|fd|fg}|jd krh| d |f¡| d |f¡| d ¡| d |¡dS)Nz"http://schemas.openxmlformats.org/zspreadsheetml/2006/mainz!officeDocument/2006/relationshipszmarkup-compatibility/2006zhttp://schemas.microsoft.com/zoffice/spreadsheetml/2009/9/acÚxmlnszxmlns:rrrzxmlns:mcz xmlns:x14ac)z mc:IgnorableZx14acrÙ)rgrTrt)r*ÚschemaróZxmlns_rZxmlns_mcZ ms_schemaZ xmlns_x14acrr0r0r1r=Is  zWorksheet._write_worksheetcCsÔ|jdkr|jdkrd}n¤|jdkrn|jdk rn|j|jkrHtd|jƒ}q¾td|jƒ}td|jƒ}|d|}nP|j|jkr–|j|jkr–t|j|jƒ}n(t|j|jƒ}t|j|jƒ}|d|}| dd|fg¡dS)Nr¿rr5Ú dimensionrÜ)rlrnror$rmrÖ)r*rÜr9r:r0r0r1r?]s    zWorksheet._write_dimensioncCs | d¡| ¡| d¡dS)NZ sheetViews)rtÚ_write_sheet_viewrwrr0r0r1r@€s zWorksheet._write_sheet_viewscCslg}|js| d¡|jr$| d¡|js4| d¡|jrD| d¡|jrT| d¡|jsd| d¡|jdkrz| d¡n|jd krŽ| d ¡|jd kr¨| d |jf¡|j d kr| d|j f¡|jdkrä|j rä| d|j f¡|jdkrþ| d|j f¡|jd kr| d|j f¡| d¡|j s4|j r\|  d|¡| ¡| ¡| d¡n | d|¡dS)N)Z showGridLinesr)ZshowRowColHeadersr)Z showZerosr©Ú rightToLeftr)Z tabSelectedr©ZshowOutlineSymbolsrr)rõZ pageLayoutrl)rõZpageBreakPreviewrQÚ topLeftCellrVZ zoomScalerZzoomScaleNormalZzoomScalePageLayoutViewZzoomScaleSheetLayoutView)ZworkbookViewIdrZ sheetView)rrTrr¤r£rwrªrértr r¡rurqrtÚ _write_panesÚ_write_selectionsrwrÖ©r*rr0r0r1rö‰sD                 zWorksheet._write_sheet_viewcCsŠ|j}|j}|j}d|fg}|j|jkr2| d¡|jrB| d¡|rT| d|f¡|rf| d|f¡|jdkrz| d¡| d|¡dS) NZdefaultRowHeight©Z customHeightr)Z zeroHeightrZoutlineLevelRowZoutlineLevelColrr©zx14ac:dyDescentz0.25Z sheetFormatPr)r­r¥r¦r¬rTr²rgrÖ)r*r­Z row_levelZ col_levelrr0r0r1rAÄs      z Worksheet._write_sheet_format_prcCs¼|js dS| d¡t|j ¡ƒd}|}|j|}|j|=|}|}t|j ¡ƒD]B}|j|}||dkrz||krz|}qR| |||¡|}|}|}qR| |||¡||j|<| d¡dS)NÚcolsrr)rprtrÃr$Ú_write_col_inforw)r*rKrMZprev_col_optionsZ deleted_colZdeleted_col_optionsr@Z col_optionsr0r0r1rBÜs(    zWorksheet._write_colscCsL|\}}}}}} d} d} |r$| ¡} |dkr@|s:d}d} qLd}n |dkrLd} |dkr¶d} d} |dkrŽtt|| | dƒt| ƒdƒd}n(tt|| dƒ| t| ƒdƒd}d|dfd |dfd |d ›fg}| rê| d | f¡|rø| d ¡| r| d¡| r| d¡|r,| d|f¡|r<| d¡| d|¡dS)NrrrYr±rÂr/gp@r³r²r´rr€)rrr>)ZbestFitr>)Z customWidthr>Ú outlineLevel)r¯r>r@)Ú _get_xf_indexr(rrTrÖ)r*Úcol_minÚcol_maxrpr´r(rrr°r¯rÎZ custom_widthÚxf_indexr¦r§rr0r0r1rsjÿþÿûÿ ÿþÿûÿ   ý    zWorksheet._write_col_infocCs6|jdkr| d¡n| d¡| ¡| d¡dS)NÚ sheetData)rlrÖrtÚ _write_rowsrwrr0r0r1rCHs    zWorksheet._write_sheet_datacCs~|jdkr| d¡nd| d¡d}|j d¡|j |¡}|rZ|j |¡|j |¡}q<|j ¡t   |j ¡|  d¡dS)Nrir) rlrÖrtrøÚseekÚreadrxrr8r7Úunlinkr÷rw)r*Z buff_sizer…r0r0r1rDRs        z%Worksheet._write_optimized_sheet_datacCsDd|jfd|jfd|jfd|jfd|jfd|jfg}| d|¡dS)NrûrürYrZrƒr„Z pageMargins)rŠr‹rŒrrŽrrÖrýr0r0r1rNjsú zWorksheet._write_page_marginscCsbg}|jsdS|jr$| d|jf¡|jdkr>| d|jf¡|jr^|jdkr^| d|jf¡|jr~|jdkr~| d|jf¡|jrŽ| d¡|jdkr¨| d|jf¡|j rº| d ¡n | d ¡|j rÔ| d ¡|jd krè| d ¡|j r"|j r| d|j f¡|j rR| d|j f¡n0|j r:| d|j f¡|j rR| d|j f¡| d|¡dS)NZ paperSizerVrrZ fitToWidthZ fitToHeight)Z pageOrderZ overThenDownZfirstPageNumber)rzZportrait)rzZ landscape)Z blackAndWhiter>r)ZuseFirstPageNumberr>Z horizontalDpiZ verticalDpiZ pageSetup)rxryrTr¢r–r—r˜r“r•rzr”rfrýrürÖrýr0r0r1rOws@        zWorksheet._write_page_setupcCs^g}|jsdS|jr| d¡|jr.| d¡|jr>| d¡|jrN| d¡| d|¡dS)N)ZhorizontalCenteredr)ZverticalCenteredr)Zheadingsr)Z gridLinesrZ printOptions)r{r|rTr}r€r~rÖrýr0r0r1rMÅs    zWorksheet._write_print_optionscCstg}|js| d¡|js$| d¡|jr^| d|¡|jrD| ¡|jrR| ¡|  d¡n|j rp|  d|¡dS)N)Z scaleWithDocr)ZalignWithMarginsrZ headerFooter) r†rTr…r‚rtrƒÚ_write_odd_headerr„Ú_write_odd_footerrwrhrÖrýr0r0r1rPÞs    zWorksheet._write_header_footercCs| d|j¡dS)NZ oddHeader)rvrƒrr0r0r1r òszWorksheet._write_odd_headercCs| d|j¡dS)NZ oddFooter)rvr„rr0r0r1r öszWorksheet._write_odd_footercCs$| ¡t|j|jdƒD]}||jks>||jks>|j|rt|dƒ}||jkr`|j|}nd}|j|rè||jkr†|  ||¡n|  |||j|¡t|j |j dƒD].}||j|kr¬|j||}|  |||¡q¬|  d¡q||jkr | |||j|¡q| |||j|¡qdS)NrrÁr)Ú_calculate_spansrYrlrmrŸr¼r´r(r¸Ú _write_rowrnroÚ _write_cellrwÚ_write_empty_row)r*rÉÚ span_indexr·rÊÚcol_refr0r0r1rús0ÿþý       zWorksheet._write_rowscCsÔ|j}||_||jks*||jks*|j|rÆd}|j|r²||jkrP| ||¡n| |||j|¡t|j|jdƒD].}||j|krv|j||}| |||¡qv|  d¡n|  |||j|¡|j  ¡dS)Nrr) rãrŸr¼r´rrYrnrorrwrÚclear)r*Zcurrent_row_numrÉr·rÊrr0r0r1r0"s   zWorksheet._write_single_rowcCs:i}d}d}t|j|jdƒD]}||jkrzt|j|jdƒD]8}||j|kr@|dkrd|}|}q@t||ƒ}t||ƒ}q@||jkrÚt|j|jdƒD]B}||jkr–||j|kr–|dkrÄ|}|}q–t||ƒ}t||ƒ}q–|dddksô||jkrt |dƒ}|dk r|d7}|d7}|›d|›||<d}q||_ dS)NrrÁrr5) rYrlrmr´rnror³r²r¼r(r¸)r*ÚspansZspan_minZspan_maxrÉrÊrr0r0r1rGs8       zWorksheet._calculate_spansc CsBd}|r|\}}}} } nd\}}}} } |dkr4|j}d|dfg} |rN| ¡}|r`|  d|f¡|rr|  d|f¡|r€|  d¡||jksž||jkr°||jkr°|  d|d ›f¡|r¾|  d ¡||jksÜ||jkræ||jkræ|  d ¡| rø|  d | f¡| r|  d ¡|jdkr|  d¡|r2| d| ¡n | d| ¡dS)Nr)NNrrrrorrÚs)Z customFormatrZhtÚg)rrrrþr)r¯rrrrÿr)r­rrTr¬rgZ_xml_empty_tag_unencodedZ_xml_start_tag_unencoded) r*rrÚ propertiesÚ empty_rowrrÏr(rrr°r¯rr0r0r1rrsL  ÿÿ  ÿÿ    zWorksheet._write_rowcCs|j|||dddS)NT)r)r)r*rrrr0r0r1r©szWorksheet._write_empty_rowcCsàt||ƒ}d|fg}|jr4|j ¡}| d|f¡nl||jkrn|j|drn|j|d}| d| ¡f¡n2||jkr |j|d}|dk r | d| ¡f¡|jj} | dkrÂ| |j |¡n| dkr0|j } |j sæ|  | |¡nF|  | ¡} |  d¡r|  d¡r| | |¡nt| ƒ} | | | |¡n¬| dkrÂ|j} t|jtƒrl| d ¡|jrfd} nd } nBt|jtƒr®d } |jd krŒn"|j| kr¤| d ¡n | d¡| |j| |¡n| dkrF|jdkrâ| d¡zt|jƒWn tk r| d¡YnX| d|¡| |j|j¡| |j¡|  d¡n–| dkr^| !d|¡n~| dkr–| d ¡| d|¡| |j"¡|  d¡nF| dkrÜ| d ¡| d|jf¡| d|¡| |j#¡|  d¡dS)NrorrrÅr¼zzrK)rqrÍr)r7z#N/Az#NAME?z#NULL!r6z#REF!r’rQ)rqÚe)rqrrNrO)ÚcmrÚcrErJrGÚvm)$r%rFrrTrŸrprrÅZ_xml_number_elementr4r'rdZ_xml_string_elementZ_escape_control_charactersr r Z_xml_rich_inline_stringrZ_xml_inline_stringr@r$rrZ_xml_formula_elementr?rZrr)rtÚ_write_cell_array_formularYÚ_write_cell_valuerwrÖr`rP)r*rr@rËr[rrZrow_xfZcol_xfZtype_cell_namer'rpr@Z error_codesr0r0r1r­s~                            zWorksheet._write_cellcCs|dkr d}| d|¡dS)NrQÚv©rv)r*r@r0r0r1r#szWorksheet._write_cell_valuecCsdd|fg}| d||¡dS)N)rqÚarrayrÜrr!)r*r?r[rr0r0r1r*s z#Worksheet._write_cell_array_formulacCsžg}|js&|js&|js&|js&|js&dS|jr<| d|jf¡|jrL| d¡|js^|js^|jrŽ| d|¡| ¡| ¡|  ¡|  d¡n |  d|¡dS)NZcodeName)Z filterModerZsheetPr) r–rÆrsr«rêrTrtÚ_write_tab_colorÚ_write_outline_prÚ_write_page_set_up_prrwrÖrýr0r0r1r>0s.ÿþýüû   zWorksheet._write_sheet_prcCs |js dSdg}| d|¡dS)N)Z fitToPagerZ pageSetUpPr)r–rÖrýr0r0r1r%LszWorksheet._write_page_set_up_prcCs(|j}|sdSd|fg}| d|¡dS)NrÄZtabColor)rsrÖ)r*rÔrr0r0r1r#Ts  zWorksheet._write_tab_colorcCs^g}|jsdS|jr| d¡|js.| d¡|js>| d¡|jsN| d¡| d|¡dS)N)Z applyStylesr)Z summaryBelowr)Z summaryRightrrùZ outlinePr)r«r§rTr¨r©rªrÖrýr0r0r1r$_s    zWorksheet._write_outline_prcCs\| |j¡}|sdSt|ƒ}d|fd|fg}| d|¡|D]}| |d¡q<| d¡dS)NrŒÚmanualBreakCountZ rowBreaksiÿ?)r]r™r.rtÚ _write_brkrw)r*Ú page_breaksrŒrrÉr0r0r1rQqs þ zWorksheet._write_row_breakscCs\| |j¡}|sdSt|ƒ}d|fd|fg}| d|¡|D]}| |d¡q<| d¡dS)NrŒr&Z colBreaksiÿÿ)r]ršr.rtr'rw)r*r(rŒrrÊr0r0r1rR†s þ zWorksheet._write_col_breakscCs"d|fd|fdg}| d|¡dS)Nr„r²)ÚmanrZbrk©rÖ)r*Zbrk_idZbrk_maxrr0r0r1r'›szWorksheet._write_brkcCsN|j}t|ƒ}|sdSd|fg}| d|¡|D]}| |¡q0| d¡dS)NrŒZ mergeCells)rµr.rtÚ_write_merge_cellrw)r*r¶rŒrÚ merged_ranger0r0r1rI¡s   zWorksheet._write_merge_cellsc CsF|\}}}}t||ƒ}t||ƒ}|d|}d|fg} | d| ¡dS)Nr5rÜZ mergeCell)r$rÖ) r*r,Zrow_minrZrow_maxrr9r:rÜrr0r0r1r+³s      zWorksheet._write_merge_cellcCsøt|j ¡ƒ}|sdS| d¡|D]Ä}t|j| ¡ƒ}|D]¨}|j||}|jrŽ|j|rŽ|j||rŽ|j||}|jjdkrŽd|_|jt j t j fkrØ|j d7_ |  |||j |¡|j d| ¡dg¡q>| |||¡q>q$| d¡dS)NrìrITrruZExternal)rÃrìr$rtr´rrÅÚ_is_object_linkZ _link_typerÚURLZEXTERNALrÍÚ_write_hyperlink_externalrÏrTr…Ú_write_hyperlink_internalrw)r*r²rÉr³rÊrdrËr0r0r1rLÀs2  ÿ ÿzWorksheet._write_hyperlinks)rr@Úid_numrdcCsxt||ƒ}dt|ƒ}d|fd|fg}|jr<| d|jf¡|jrR| d|jf¡|jrh| d|jf¡| d|¡dS)NÚrIdrÜúr:idrÚdisplayÚtooltiprÞ)r$rr|rTr-rgrhrÖ)r*rr@r1rdrÜÚr_idrr0r0r1r/òs  z#Worksheet._write_hyperlink_external)rr@rdcCsRt||ƒ}d|fd|jfg}|jr2| d|jf¡| d|jf¡| d|¡dS)NrÜrr5r4rÞ)r$r‡rhrTrgrÖ)r*rr@rdrÜrr0r0r1r0s  z#Worksheet._write_hyperlink_internalcCsL|js dSd|jfg}|jr<| d|¡| ¡| d¡n | d|¡dS)NrÜÚ autoFilter)rÄrÆrtÚ_write_autofiltersrwrÖrýr0r0r1rHs   zWorksheet._write_auto_filtercCsT|j\}}t||dƒD]6}||jkr(q|j|}|j|}| ||||¡qdSrË)rÅrYrÇrÈÚ_write_filter_column)r*Zcol1Zcol2r@r{rÈr0r0r1r8"s    zWorksheet._write_autofilterscCsBd|fg}| d|¡|dkr*| |¡n | |¡| d¡dS)NZcolIdZ filterColumnr)rtÚ_write_filtersÚ_write_custom_filtersrw)r*r”rÈrîrr0r0r1r93s     zWorksheet._write_filter_columncCs€dd„|Dƒ}g}t|ƒt|ƒkr(dg}t|ƒdkrNt|ƒdkrN| d|¡n.| d|¡t|ƒD]}| |¡qb| d¡dS)NcSs g|]}t|ƒ ¡dkr|‘qS)r[)rr)r?Úfilterr0r0r1rADsz,Worksheet._write_filters..)r;rrrrî)r.rÖrtrÃÚ _write_filterrw)r*rîZ non_blanksrrÝr0r0r1r:Bs   zWorksheet._write_filterscCsd|fg}| d|¡dS)NrÑr<r*rär0r0r1r=Vs zWorksheet._write_filtercCsŒt|ƒdkr,| d¡|j|Ž| d¡n\g}|ddkrDdg}ndg}| d|¡| |d|d¡| |d|d¡| d¡dS) NrlZ customFiltersr)Úandr)r>rrrRrä)r.rtÚ_write_custom_filterrw)r*r{rr0r0r1r;\s      zWorksheet._write_custom_filterscCspg}ddddddddœ}||dk r.||}ntd|›ƒ|dkrR| d |f¡| d |f¡| d |¡dS) Nr rr rrr )rrlrRrärÂrbrgzUnknown operator = rirÑZ customFilter)r rTrÖ)r*rirÑrrhr0r0r1r?ss ù  zWorksheet._write_custom_filtercCs|g}|jsdS|j}|dr.| d|df¡|dr@| d¡|drR| d¡|dsd| d¡|dsv| d ¡|d rˆ| d ¡|d rš| d ¡|dr¬| d¡|dr¾| d¡|drÐ| d¡|drâ| d¡|drô| d¡|dr| d¡|ds| d¡|dr0| d¡|drD| d¡|d rX| d!¡|d"sl| 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Ý)r7rrä)Z pivotTablesrrå)ZselectUnlockedCellsrZsheetProtection)r›rTrÖ)r*rrr0r0r1rEŽsR                       z!Worksheet._write_sheet_protectioncCsF|jdkrdS| d¡|jD]\}}}| |||¡q| d¡dS)NrZprotectedRanges)rrtrœÚ_write_protected_rangerwrër0r0r1rF¾s   z!Worksheet._write_protected_rangescCsBg}|r| d|f¡| d|f¡| d|f¡| d|¡dS)NrærÂr`ZprotectedRange©rTrÖ)r*r[rìrærr0r0r1r@Ês z Worksheet._write_protected_rangecCs(|js dS|jd7_| |j¡dSrË)rÜrÍÚ_write_drawingrr0r0r1rTÖszWorksheet._write_drawingscCs&dt|ƒ}d|fg}| d|¡dS)Nr2r3rÜ©rrÖ)r*rpr6rr0r0r1rBÞs  zWorksheet._write_drawingcCs@|js dS|jd7_dt|jƒ}d|fg}| d|¡dS)Nrr2r3Z legacyDrawing)r¹rÍrrÖ©r*r6rr0r0r1rUæs  zWorksheet._write_legacy_drawingcCs@|js dS|jd7_dt|jƒ}d|fg}| d|¡dS)Nrr2r3ZlegacyDrawingHF)rºrÍrrÖrDr0r0r1rVós  z"Worksheet._write_legacy_drawing_hfcCs@|js dS|jd7_dt|jƒ}d|fg}| d|¡dS)Nrr2r3Zpicture)rárÍrrÖrDr0r0r1rWs  zWorksheet._write_picturecCsN|j}t|ƒ}|sdSd|fg}| d|¡|D]}| |¡q0| d¡dS)NrŒZdataValidations)rär.rtÚ_write_data_validationrw)r*rärŒrZ validationr0r0r1rK s   z!Worksheet._write_data_validationsc Csd}g}|dD]V}|dkr$|d7}|\}}}}||krB||}}||krT||}}|t||||ƒ7}q| d¡rz|d}|ddkr¶| d|df¡|dd kr¶| d |df¡d |krê|d d krÔ| d ¡|d dkrê| d¡|drþ| d¡|ds| d¡|dr&| d¡|dr:| d¡d|krV| d|df¡d|krr| d|df¡d|krŽ| d|df¡d|krª| d|df¡| d |f¡|ddkrÔ| d!|¡n@| d!|¡| |d"¡|d#dk r | |d#¡| d!¡dS)$NrQr!r‚rûrïrýr%rèrrirúr)Ú errorStylerrl)rFrrò)Z allowBlankrró)Z showDropDownrrô)ZshowInputMessagerr÷)ZshowErrorMessagerrøZ errorTitlerùrPrõZ promptTitleröÚpromptrÂZdataValidationr@rñ)r#r“rTrÖrtÚ_write_formula_1Ú_write_formula_2rw) r*rrÂrr!Z row_firstrêZrow_lastrër0r0r1rEs\                        z Worksheet._write_data_validationcCsht|tƒr"|j|Ž}d|›d}n6z t|ƒWn(tk rV| d¡rR| d¡}YnX| d|¡dS)NrSrZformula1)r$rrr%rr)r rwrv©r*r?r0r0r1rHls    zWorksheet._write_formula_1cCsFz t|ƒWn(tk r4| d¡r0| d¡}YnX| d|¡dS)NrZformula2©rr)r rwrvrJr0r0r1rI}s   zWorksheet._write_formula_2cCs6t|j ¡ƒ}|sdS|D]}| ||j|¡qdSr[)rÃrår$Ú_write_conditional_formatting)r*r­Ú cond_ranger0r0r1rJŠsÿz$Worksheet._write_conditional_formatscCs8d|fg}| d|¡|D]}| |¡q| d¡dS)NrÂZconditionalFormatting)rtÚ_write_cf_rulerw)r*rMÚparamsrÚparamr0r0r1rL–s    z'Worksheet._write_conditional_formattingcCs d|dfg}d|kr4|ddk r4| d|df¡| d|df¡| d¡rZ| d¡|ddkrÎ| d|d f¡| d |¡d |kr²d |kr²| |d ¡| |d ¡n| |d ¡| d ¡n8|ddkrXt d|d ¡rö| d¡t d|d ¡r| d¡t d|d ¡rHt d|d ¡}| d| d¡f¡| d |¡n®|ddkrÈd |krˆ|d dkrˆ| d¡d|krœ| d¡|d p¨d}| d|f¡| d |¡n>|ddkræ| d |¡n |ddkr| d |¡n|dd ks<|dd!ks<|dd"ks<|dd#krˆ| d|d f¡| d$|d f¡| d |¡| |d%¡| d ¡n~|dd&krÐ| d&|d f¡| d |¡| |d%¡| d ¡n6|dd'ks|dd(ks|dd)ks|dd*kr.| d |¡| |d%¡| d ¡nØ|dd+kr^| d |¡|  |¡| d ¡n¨|dd,kr¤| d |¡|  |¡| d-¡r˜|  |¡| d ¡nb|dd.krØ| d |¡| |d ¡| d ¡n.|dd/kr| d |¡|  |¡| d ¡dS)0Nr%rFZdxfIdrhr,)Z stopIfTruerrHrirèZcfRulerðrñr@rIZbelow)rIrr)Z equalAveragerz [123] std devz([123]) std devr‹rrLre)rérr^)rZrrÎÚrankrJrKr_rjr`rarir?rMrNrOrPrQrkrTrirUrV) rTr“rtÚ_write_formula_elementrwr rDÚgrouprÖÚ_write_color_scaleÚ_write_data_barÚ_write_data_bar_extÚ_write_icon_set)r*rOrrrQr0r0r1rNŸs¤          ÿ þ ý ü   ÿ þ ý ü              zWorksheet._write_cf_rulecCsFz t|ƒWn(tk r4| d¡r0| d¡}YnX| d|¡dS)Nrr?rKrJr0r0r1rR s   z Worksheet._write_formula_elementcCsœ| d¡| |d|d¡|ddk r>| |d|d¡| |d|d¡| d|d ¡|d dk r~| d|d ¡| d|d ¡| d¡dS) Nrkr-r0r.r1r/r2rÄr3r4r5)rtÚ _write_cfvorÛrw)r*rPr0r0r1rTs   zWorksheet._write_color_scalecCsžg}d|kr| d|df¡d|kr8| d|df¡| d¡rL| d¡| d|¡| |d|d ¡| |d |d ¡| d |d ¡| d¡dS)Nr6Ú minLengthr7Ú maxLengthrC©Z showValuerrTr-r0r/r2rÄr8)rTr“rtrXrÛrw)r*rPrr0r0r1rU-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)rar.rærTrtÚ _write_extrvrw)r*rPZworksheet_countZdata_bar_countr\r0r0r1rVDs       zWorksheet._write_data_bar_extcCsŒg}|ddkrd|dfg}| d¡r2| d¡| d¡rF| d¡| d|¡t|dƒD]}| |d |d |d ¡q^| d¡dS) NrDrdrVrFr[rE)r§rrGr%r@rè)r“rTrtÚreversedrXrw)r*rPrÚiconr0r0r1rWVs      zWorksheet._write_icon_setcCs>d|fg}|dk r | d|f¡|r.| d¡| d|¡dS)Nr%rÑ)ZgterZcfvorA)r*Zcf_typerÑrèrr0r0r1rXls   zWorksheet._write_cfvocCs||fg}| d|¡dSrår*rær0r0r1rÛxs zWorksheet._write_colorcCs|jD]}|j|ŽqdSr[)rqÚ_write_selection)r*Ú selectionr0r0r1rü~s zWorksheet._write_selectionscCsJg}|r| d|f¡|r(| d|f¡|r:| d|f¡| d|¡dS)NrÀZ activeCellrÂrcrA)r*rÀrÁrÂrr0r0r1rbƒszWorksheet._write_selectioncCs4|j}|sdS|ddkr&|j|Žn |j|ŽdS)Nrärl)ruÚ_write_split_panesÚ_write_freeze_panes)r*rur0r0r1rû’s   zWorksheet._write_panescCsLg}|}|}t||ƒ} d} d} d} d} |jrB|jd\}} } g|_|rš|ršd} t|dƒ}td|ƒ}|j d||g¡|j d||g¡|j d| | g¡n2|r¶d} |j d| | g¡nd} |j d| | g¡|dkrÚd} n|dkrèd} nd } |rþ| d |f¡|r| d |f¡| d | f¡| d | f¡| d| f¡| d|¡dS)NrQrÚ bottomRightÚtopRightÚ bottomLeftÚfrozenrZ frozenSplitr7ÚxSplitÚySplitrúÚ activePaneÚstaterÀ)r$rqrTrÖ)r*rr@rÇrÈrÉrÚy_splitÚx_splitrtrvrmrÁrÂrBÚrow_cellÚcol_cellr0r0r1režsH   zWorksheet._write_freeze_panescCs®g}d}d}d} d} |} |} |jr<|jd\}} } g|_d}| rPtd| dƒ} | r^| | ¡} ||kr¦||kr¦td| dddƒ}td| d dd d d ƒ}t||ƒ} |s¼| } | } |r|rd }t|dƒ}td|ƒ}|j d||g¡|j d||g¡|j d | | g¡n4|r6d}|j d| | g¡nd}|j d| | g¡| rd| d| d›f¡| r|| d| d›f¡| d| f¡|rž| d|f¡| d|¡dS)NFrQrTrXi,r/rWé†rRrärZrfrgrhrjrrkrúrlrÀ)rqr(Ú_calculate_x_split_widthr$rTrÖ)r*rr@rÇrÈrBrZ has_selectionrvrÁrÂrnrortrprqr0r0r1rdÖsT      zWorksheet._write_split_panescCsZd}d}|dkr&t|||dƒ}nt||dƒ|}|dd}|d}|d}|S) Nr±rÂrr/rRrärXrr)r()r*r´r¦r§r¨ZpointsZtwipsr0r0r1rss z"Worksheet._calculate_x_split_widthcCs^|j}t|ƒ}|sdSd|fg}| d|¡|D]}|jd7_| |j¡q0| d¡dS)NrŒZ tablePartsr)rÙr.rtrÍÚ_write_table_partrw)r*rÙrŒrrBr0r0r1rX4sþÿ zWorksheet._write_table_partscCs&dt|ƒ}d|fg}| d|¡dS)Nr2r3Z tablePartrCrDr0r0r1rtMs  þÿzWorksheet._write_table_partcCsPt|jƒ}t|jƒ}|s |s dS| d¡|r6| ¡|rB| ¡| d¡dS)Nr])r.rærÚrtÚ_write_ext_list_data_barsÚ_write_ext_list_sparklinesrw)r*Z has_data_barsZhas_sparklinesr0r0r1rY[s   zWorksheet._write_ext_listcCsB| d¡| d¡|jD]}| |¡q| d¡| d¡dS)Nz&{78C0D931-6437-407d-A8EE-F0AAD7539E65}zx14:conditionalFormattingsr^)r_rtræÚ"_write_conditional_formatting_2010rw)r*r]r0r0r1runs      z#Worksheet._write_ext_list_data_barscCsìd}d|fg}| d|¡| |¡| |¡| |d|d¡| |d|d¡|dsl| |d ¡|d s‚| |d ¡|ds |d s | |d ¡|ddkrº| |d¡| d¡| d¡|  d|d¡| d¡dS)Nú3http://schemas.microsoft.com/office/excel/2006/mainúxmlns:xmzx14:conditionalFormattingror0rqr2r?r<r:r9r>r=rArýrBú x14:dataBarú x14:cfRuleúxm:sqrefrY) rtÚ_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_colorrwrv)r*r]Úxmlns_xmrr0r0r1rw|s,    ÿþ   z,Worksheet._write_conditional_formatting_2010cCs,d}|d}d|fd|fg}| d|¡dS)NrTr\r%r„r{©rt)r*r]Ú rule_typer\rr0r0r1r}©szWorksheet._write_x14_cf_rulecCsÐd}d}d|fd|fg}|ds*| d¡|dr<| d¡|d d krR| d ¡|d d krh| d ¡|drz| d¡|ds”|ds”| d¡|ddkrª| d¡|ddkrÀ| d¡| d|¡dS)NrrVrYrZr?)Úborderrr;)Zgradientrr@rû)r^Z leftToRightrü)r^rør:)ZnegativeBarColorSameAsPositiverr>)Z$negativeBarBorderColorSameAsPositiverrAÚmiddle)Ú axisPositionrˆrý)r‰rýrz)rTrt)r*r]r6r7rr0r0r1r~±s2þ       ÿþ     zWorksheet._write_x14_data_barcCsFd|fg}|dkr | d|¡n"| d|¡| d|¡| d¡dS)Nr%)r³r²rnrpzx14:cfvoúxm:f)rÖrtrvrw)r*r†r@rr0r0r1rØs    zWorksheet._write_x14_cfvocCsd|fg}| d|¡dS)NrÄzx14:borderColorr*©r*rÄrr0r0r1r€ãs z!Worksheet._write_x14_border_colorcCsd|fg}| d|¡dS)NrÄzx14:negativeFillColorr*r‹r0r0r1rès z(Worksheet._write_x14_negative_fill_colorcCsd|fg}| d|¡dS)NrÄzx14:negativeBorderColorr*r‹r0r0r1r‚ís z*Worksheet._write_x14_negative_border_colorcCsd|fg}| d|¡dS)NrÄz x14:axisColorr*r‹r0r0r1rƒòs zWorksheet._write_x14_axis_colorcCsÚ| d¡| ¡t|jƒD]¤}| |¡| |d¡| |d¡| ¡| |d¡|  |d¡|  |d¡|  |d¡|  |d¡|d r¬|  d |d ¡| |¡| d ¡q| d ¡| d ¡dS)Nz&{05C60535-1F16-4fd2-B633-F4F36F0B64E0}rŸr r¡r¢r£r¤r¥r¨rŠúx14:sparklineGroupúx14:sparklineGroupsr^)r_Ú_write_sparkline_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_lowrvÚ_write_sparklinesrw)r*rºr0r0r1rv÷s$     z$Worksheet._write_ext_list_sparklinescCsn| d¡t|dƒD]H}|d|}|d|}| d¡| d|¡| d|¡| d¡q| d¡dS)Nzx14:sparklinesrŒr­rœz x14:sparklinerŠr|)rtrYrvrw)r*rºr™r¼rr0r0r1r˜%s       zWorksheet._write_sparklinescCs,d}|d}d|fd|fg}| d|¡dS)Nz$http://schemas.microsoft.com/office/zspreadsheetml/2009/9/mainz xmlns:x14Úurir^r…)r*r™rôZ xmlns_x14rr0r0r1r_6s þzWorksheet._write_extcCsd}d|fg}| d|¡dS)Nrxryrr…)r*r„rr0r0r1rŽBs z!Worksheet._write_sparkline_groupscCsú| d¡}g}| d¡dk rL|ddkr2d|d<n| d|df¡d|d<| d¡dk rŠ|ddkrpd|d<n| d |df¡d|d<|d d kr¨| d |d f¡| d ¡rÄ| d |d f¡| d¡rØ| d¡|rê| d|f¡| d¡rþ| d¡| d¡r| d¡| d¡r*| d¡| d¡r@| d¡| d¡rV| d¡| d¡rl| d¡| d¡r‚| d¡| d¡r˜| d ¡| d¡r¶| d!|df¡| d¡rÔ| d"|df¡| d#¡rê| d$¡| d%|¡dS)&Nrµr²rSZcust_maxZ manualMaxrr³Zcust_minZ manualMinr%rªr©Z lineWeightr¨)ZdateAxisrZdisplayEmptyCellsAsrž)ržrr¯)r¯rr°)r°rr²)r²rr³)r³rr±)r±rr¦)Z displayXAxisrrr)Z displayHiddenrZ minAxisTypeZ maxAxisTyper§r÷rŒ)r“rTrt)r*rrµrr0r0r1rJsV                             z Worksheet._write_sparkline_groupcCshg}| d¡r | d|df¡| d¡r<| d|df¡| d¡rX| d|df¡| ||¡dS)NrÄrÒZtint)r“rTrÖ)r*ÚelementrÔrr0r0r1Ú_write_spark_color£s   zWorksheet._write_spark_colorcCs| d|¡dS)Nzx14:colorSeries©r›rÓr0r0r1r²szWorksheet._write_color_seriescCs| d|¡dS)Nzx14:colorNegativerœrÓr0r0r1r‘¶szWorksheet._write_color_negativecCs| dddi¡dS)Nz x14:colorAxisrÄZFF000000rœrr0r0r1r’ºszWorksheet._write_color_axiscCs| d|¡dS)Nzx14:colorMarkersrœrÓr0r0r1r“¾szWorksheet._write_color_markerscCs| d|¡dS)Nzx14:colorFirstrœrÓr0r0r1r”ÂszWorksheet._write_color_firstcCs| d|¡dS)Nz x14:colorLastrœrÓr0r0r1r•ÆszWorksheet._write_color_lastcCs| d|¡dS)Nz x14:colorHighrœrÓr0r0r1r–ÊszWorksheet._write_color_highcCs| d|¡dS)Nz x14:colorLowrœrÓr0r0r1r—ÎszWorksheet._write_color_lowcCsddg}| d|¡dS)N)ZfontIdÚ0)r%Z noConversionZ phoneticPrr*rýr0r0r1rGÒsþzWorksheet._write_phonetic_prcCsZ|js dS| d¡|j d¡r6|jd}| d|¡|j d¡rX|jd}| d|¡|j d¡rz|jd}| d|¡|j d¡rœ|jd}| d |¡|j d ¡r¾|jd }| d |¡|j d ¡rà|jd }| d |¡|j d¡r|jd}| d|¡|j d¡r(|jd}| d|¡|j d¡rL|jd}| d|¡| d¡dS)NZ ignoredErrorsr$ZnumberStoredAsTextr%Z evalErrorr&r?r'Z formulaRanger(ZunlockedFormular)ZemptyCellReferencer*ZlistDataValidationr+ZcalculatedColumnr,ZtwoDigitTextYear)rÿrtr“Ú_write_ignored_errorrw)r*Ú ignored_ranger0r0r1rSÛs>                         zWorksheet._write_ignored_errorscCs d|f|dfg}| d|¡dS)NrÂrZ ignoredErrorr*)r*rúrŸrr0r0r1rž sþzWorksheet._write_ignored_error)N)N)N)N)N)N)Nr)Nr)Nr)Nr)F)NrrI)N)N)N)N)NNN)NNN)N)N)N)N)N)N)N)F)NNN)NNN)rº)NNN)NNN)NF)N)N)N)N)N)rr)rrrr)NNr)NN)rV)rQN)NN)N)N)r)rSrSrTrT)rQNN)rQNN)N)N)r)N)N)FF)N)r)r)N)N)N)r)NF)N)N)ùrÅÚ __module__Ú __qualname__Ú__doc__r_rr4rrr)rr5rr<r rAr r=rNrErGÚ staticmethodrWrFr\r#rarrerrkrjrƒr†r‡r‘r•ržr¡r£r¤r¥r§r¨r©rªr¬r­r®rDr·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ýrrrrrrrrrrrrrr!r"r#r-r<rZr-r]rÚr]rårærarçrŠr r(rr“r•r–r˜r{r™r¤r¥r¸rÑr r¬rr­r´rµr¸r’r¹rÆr%rÊrˆr”rurÙrÚrÝrÜrçrèrtr=r?r@rörArBrrCrDrNrOrMrPr r rr0rrrrrrr>r%r#r$rQrRr'rIr+rLrr/r0rHr8r9r:r=r;r?rErFr@rTrBrUrVrWrKrErHrIrJrLrNrRrTrUrVrWrXrÛrürbrûrerdrsrXrtrYrurwr}r~rr€rr‚rƒrvr˜r_rŽrr›rr‘r’r“r”r•r–r—rGrSržÚ __classcell__r0r0rr1rOÇs` ]& 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          -rO)Hrr8r7r r5Ú collectionsrrrÿrÚ fractionsrÚ functoolsrÚiorr r Úwarningsr Zxlsxwriter.commentsr Zxlsxwriter.imager Zxlsxwriter.urlrrZxlsxwriter.vmlrrQrrÜrrrÚ exceptionsrrrFrr’rZutilityrrrrrrr r!r"r#r$r%r&r^ÚVERBOSErCr4r=rDr=r”r:r1rbrHr^rzrXrOr0r0r0r1Ú sT           8 á(         ÿ