o ȷe)@sddlZddlZddlZddlZddlmZddlmZddlmZddl m Z ddl m Z ddl mZddl mZdd lmZd d lmZd d lmZd d lmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlm Z d dlm!Z!d dlm"Z"d dlm#Z#d dlm$Z$d dlm%Z%d dlm&Z&d dl'm(Z(e)dZ*e)dZ+e)dej,Z-dd Z.d!d"Z/d#d$Z0ed%d&Z1ed'd(Z2ed)d*Z3ed+d,Z4ed-d.Z5ed/d0Z6Gd1d2d2ejZ7dS)3N) defaultdict) namedtuple)Decimal)Fraction)StringIO)isinf)isnan)warn) xmlwriter)Format)Drawing)Shape) XMLwriter)xl_rowcol_to_cell)xl_rowcol_to_cell_fast)xl_cell_to_rowcol)xl_col_to_name)xl_rangexl_color)get_sparkline_style)supported_datetime)datetime_to_excel_datetime)preserve_whitespace)quote_sheetname)DuplicateTableNamez(_x[0-9a-fA-F]{4}_)z([\x00-\x08\x0b-\x1f])z \bSORT\( | \bLET\( | \bLAMBDA\( | \bSINGLE\( | \bSORTBY\( | \bUNIQUE\( | \bXMATCH\( | \bFILTER\( | \bXLOOKUP\( | \bSEQUENCE\( | \bRANDARRAY\( | \bANCHORARRAY\(cfdd}|S)zn Decorator function to convert A1 notation in cell method calls to the default row/col notation. cs^zt|r |d}t|Wnty#t|}||dd}Ynw|g|Ri|SNrr )lenint ValueErrorr)selfargskwargs first_argnew_argsmethodK/var/www/ideatree/venv/lib/python3.10/site-packages/xlsxwriter/worksheet.py cell_wrapperIs z'convert_cell_args..cell_wrapperr)r(r+r)r'r*convert_cell_argsCs r-cr)zo Decorator function to convert A1 notation in range method calls to the default row/col notation. c sz t|r t|dWnCtyOd|dvr/|dd\}}t|\}}t|\}}n t|d\}}||}}||||g} | |dd| }Ynw|g|Ri|S)Nr:r rr r!splitrextend) r"r#r$cell_1cell_2row_1col_1row_2col_2r&r'r)r*r+`s       z(convert_range_args..cell_wrapperr)r,r)r'r*convert_range_argsZs r8cr)zq Decorator function to convert A1 notation in columns method calls to the default row/col notation. c sz t|r t|dWn2ty>dd|ddD\}}t|\}}t|\}}||g}||dd|}Ynw|g|Ri|S)NrcSsg|]}|dqS)1r)).0colr)r)r* sz?convert_column_args..column_wrapper..r.r r/) r"r#r$r2r3_r5r7r&r'r)r*column_wrappers     z+convert_column_args..column_wrapperr))r(r>r)r'r*convert_column_argsys r?Stringzstring, formatNumberznumber, formatBlankformatBooleanzboolean, formatFormulazformula, format, value ArrayFormulaz$formula, format, value, range, atypecs eZdZdZfddZddZeddZdd Zedd d Z dd dZ edddZ dddZ edddZ dddZedddZdddZe dddZe dddZd d!Z  "dd#d$Zedd%d&Zdd'd(Zedd)d*Zdd+d,Ze dd-d.Z dd/d0Zed1d2Zd3d4Zd5d6Zedd7d8Zedd9d:Z edd;d<Z!edd=d>Z"edd?d@Z#eddAdBZ$dCdDZ%ddFdGZ&dHdIZ'dJdKZ(dLdMZ)dNdOZ*dPdQZ+dRdSZ,e- ddTdUZ.e- ddVdWZ/ddXdYZ0ddZd[Z1dd\d]Z2e dd^d_Z3ed`daZ4dbdcZ5dddeZ6e ddfdgZ7e ddhdiZ8e ddjdkZ9eddldmZ:edndoZ;eddpdqZ< r ddsdtZ=eddudvZ>eddwdxZ?ddzd{Z@d|d}ZAd~dZBddZCdddZDdddZEedddZFddZGddZHddZIddZJddZKddZLdddZMdddZNdddZOdddZPe-dddZQdddZRddZSddZTeddZUddZVddZWddZXddZYddZZddZ[ddZ\dddZ]dddZ^ddZ_ddZ`dddZadd„ZbddĄZcddƄZdddȄZeddʄZfdd̄Zgdd΄ZhddЄZidd҄ZjddԄZkddքZldd؄ZmddڄZndd܄ZodddބZpdddZqddZrddZsddZtddZuddZvddZwddZxddZyddZzddZ{ddZ|ddZ}dddZ~dddZddZddZddZddZddZddZd d ZdӐd d Zd dZddZddZddZddZddZddZddZddZdd Zd!d"Zd#d$Zd%d&Zd'd(Zd)d*Zd+d,Zdd-d.Zd/d0Zdؐd1d2ZdӐd3d4Zd5d6Zd7d8Zd9d:Zd;d<Zd=d>Zd?d@ZdAdBZdCdDZdEdFZdGdHZdIdJZdKdLZdMdNZ d֐dOdPZ d֐dQdRZdSdTZdUdVZdWdXZdYdZZd[d\Zd]d^Zd_d`ZdadbZdcddZdedfZdgdhZdidjZdkdlZdmdnZdodpZdqdrZdsdtZdudvZdwdxZdydzZd{d|Zd}d~ZddZddZddZÐddZĐddZŐdӐddZƐddZǐddZȐddZɐddZʐddZːddZ̐ddZ͐ddZΐddZϐddZАddZѐddZҐddZӐddZԐddZՐddZ֐ddZאddZؐddZِddZڐddZېddZܐddZݐddZސddZߐddZddZdd„ZdÐdĄZdŐdƄZdǐdȄZdɐdʄZdːd̄Zd͐d΄ZdϐdЄZdѐd҄ZZS( Worksheetz= A class for writing the Excel XLSX Worksheet file. cs*tt|d|_d|_d|_d|_d|_d|_d|_ g|_ d|_ d|_ d|_ d|_d|_d|_d|_d|_d|_d|_i|_g|_d|_d|_d|_d|_g|_d |_d|_d|_d|_d |_ d|_!d|_"d|_#d|_$d |_%d|_&d|_'d|_(d|_)d|_*d |_+d |_,g|_-g|_.g|_/d |_0d |_1d |_2d |_3d|_4d|_5d|_6d|_7d|_8d|_9d|_:d|_;d|_d|_?d|_@g|_Ag|_Bi|_Cg|_Dd|_Ei|_FtGtH|_Id|_Jd |_Kd|_Ld|_Md |_Nd|_Od|_Pd|_Qd|_Rd |_Sd |_Td |_Ud|_Vd|_Wd|_Xd|_Yd|_Zd|_[d|_\i|_]g|_^tGtH|__g|_`i|_ad|_bd|_cd|_dtGtH|_eg|_fd|_gd|_hd|_ig|_jd|_kd|_ld|_mg|_nd|_oi|_pi|_qi|_ri|_si|_td|_ud|_vd |_wd|_xd|_yg|_zg|_{g|_|g|_}g|_~g|_g|_g|_g|_g|_g|_g|_g|_g|_i|_d|_i|_d|_i|_d|_d|_d|_d|_d|_g|_i|_g|_d|_d |_d|_d|_d|_tGtH|_d|_d |_d|_d |_d|_d|_d|_d|_d|_d|_d|_d|_d|_id|_d|_d|_d|_d|_i|_d|_d|_d|_dS)z Constructor. NrFiii@r Tffffff??333333?d\( @@i)superrG__init__nameindex str_tablepaletteconstant_memorytmpdir is_chartsheet ext_sheets fileclosed excel_versionexcel2003_style xls_rowmax xls_colmax xls_strmax dim_rowmin dim_rowmax dim_colmin dim_colmaxcolinfo selectionshiddenactive tab_color top_left_cellpanes active_paneselectedpage_setup_changed paper_size orientationprint_options_changedhcentervcenterprint_gridlinesscreen_gridlines print_headersrow_col_headersheader_footer_changedheaderfooterheader_footer_alignsheader_footer_scales header_images footer_imagesheader_images_list margin_left margin_right margin_top margin_bottom margin_header margin_footerrepeat_row_rangerepeat_col_rangeprint_area_range page_order black_white draft_qualityprint_comments page_startfit_page fit_width fit_heighthbreaksvbreaksprotect_optionsprotected_rangesnum_protected_rangesset_colsrdictset_rowszoomzoom_scale_normal print_scaleis_right_to_left show_zeros leading_zerosoutline_row_leveloutline_col_level outline_style outline_below outline_right outline_onoutline_changedoriginal_row_heightdefault_row_heightdefault_row_pixelsdefault_col_widthdefault_col_pixelsdefault_row_zeroednames write_matchtablemerge row_spanshas_vmlhas_header_vml has_commentscomments comments_listcomments_authorcomments_visible vml_shape_id buttons_list vml_header_idautofilter_areaautofilter_ref filter_range filter_on filter_cols filter_type col_sizes row_sizes col_formatscol_size_changedrow_size_changed last_shape_id rel_count hlink_count hlink_refsexternal_hyper_linksexternal_drawing_linksexternal_comment_linksexternal_vml_linksexternal_table_linksexternal_background_links drawing_linksvml_drawing_linkschartsimagestables sparklinesshapes shape_hashdrawing drawing_relsdrawing_rels_idvml_drawing_relsvml_drawing_rels_idbackground_imagebackground_bytesrstring previous_row validations cond_formatsdata_bars_2010use_data_bars_2010 dxf_priority page_view vba_codename date_1904 hyperlinksstrings_to_numbersstrings_to_urlsnan_inf_to_errorsstrings_to_formulasdefault_date_formatdefault_url_formatremove_timezonemax_url_lengthrow_data_filename row_data_fhworksheet_meta vml_data_idrow_data_fh_closed vertical_dpihorizontal_dpiwrite_handlersignored_errorshas_dynamic_arraysuse_future_functionsr" __class__r)r*rUsZ     zWorksheet.__init__cGsf|dkr|j||g|RS|jr |dr |j||g|RS|dr4|dr4|j||g|RSd|vrq|jrKtd|rK|j||g|RS|jr^td|r^|j||g|RS|jrqtd|rq|j||g|RS|j rz!t |}|j st |st |s|j|||g|d dRWSWn tyYnw|j||g|RS|j||g|RS) NrI=z{=}r.(ftp|http)s?://mailto:z(in|ex)ternal:r ) _write_blankr startswith_write_formulaendswithrrematch _write_urlrfloatrrr _write_numberr! _write_string)r"tokenrowr;r#fr)r)r*_write_token_as_strings8  z Worksheet._write_token_as_stringcG|j||g|RS)a Write data to a worksheet cell by calling the appropriate write_*() method based on the type of data being passed. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). *args: Args to pass to sub functions. Returns: 0: Success. -1: Row or column is out of worksheet bounds. other: Return value of called method. _writer"rr;r#r)r)r*writeszWorksheet.writec Gst|std|d}t|}||jvr+|j|}||||g|R}|dur)n|S|dur9|j||g|RS|turG|j||g|RS|ttt t fvrY|j ||g|RS|t urh|j |||g|RS|tjtjtjtjfvr~|j||g|RSt|ttt t fr|j ||g|RSt|t r|j |||g|RSt|tr|j||g|RSt|r|j||g|RSzt|}|j |||g|ddRWStyYntytdt|wzt ||j||g|RWSty tdt|w)Nz,write() takes at least 4 arguments (3 given)rr zUnsupported type %s in write())r TypeErrortyperrbool_write_booleanrr rrrstrrdatetimedatetime timedelta_write_datetime isinstancerr!r) r"rr;r#r token_type write_handlerfunction_returnrr)r)r*rs\       zWorksheet._writeNcC|||||S)a Write a string to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). string: Cell data. Str. format: An optional cell Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: String truncated to 32k characters. )r)r"rr;string cell_formatr)r)r* write_stringzWorksheet.write_stringcCs~d}|||r dSt||jkr|d|j}d}|js$|j|}n|}|jr3||jkr3||t|||j ||<|SNr) _check_dimensionsrrcrZrX_get_shared_string_indexr_write_single_rowcell_string_tupler)r"rr;r)r* str_error string_indexr)r)r*r"s  zWorksheet._write_stringcCr()a Write a number to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). number: Cell data. Int or float. cell_format: An optional cell Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. )rr"rr;numberr*r)r)r* write_number>zWorksheet.write_numbercCst|st|r*|jr&t|r|||d|dSt|r%|||d|dSntd|||r2dS|jr?||jkr?||t |||j ||<dS)N#NUM!z1/0#DIV/0!zUNAN/INF not supported in write_number() without 'nan_inf_to_errors' Workbook() optionr.r) rrrr rr0rZrr2cell_number_tuplerr6r)r)r*rQs(    zWorksheet._write_numbercCr()a Write a blank cell with formatting to a worksheet cell. The blank token is ignored and the format only is written to the cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). blank: Any value. It is ignored. cell_format: An optional cell Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. )rr"rr;blankr*r)r)r* write_blankmr,zWorksheet.write_blankcCsL|durdS|||rdS|jr||jkr||t||j||<dS)Nrr.)r0rZrr2cell_blank_tuplerr=r)r)r*rs  zWorksheet._write_blankrcCs||||||S)a Write a formula to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). formula: Cell formula. cell_format: An optional cell Format object. value: An optional value for the formula. Default is 0. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: Formula can't be None or empty. )r r"rr;formular*valuer)r)r* write_formulaszWorksheet.write_formulac Cs|||rdS|dus|dkrtddSt|r&||||||||S|dr;|dr;||||||||S||}|j rM||j krM| |t ||||j ||<dS)Nr.rIzFormula can't be None or empty{rr)r0r re_dynamic_functionsearchwrite_dynamic_array_formularr _write_array_formula_prepare_formularZrr2cell_formula_tuplerrAr)r)r*r s&     zWorksheet._write_formulac Cs8t|r||||||||S||||||||dS)an Write a formula to a worksheet cell/range. Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. formula: Cell formula. cell_format: An optional cell Format object. value: An optional value for the formula. Default is 0. Returns: 0: Success. -1: Row or column is out of worksheet bounds. static)rFrGrHrI)r" first_row first_collast_rowlast_colrBr*rCr)r)r*write_array_formulas  zWorksheet.write_array_formulac Cs*||||||||d}|dkrd|_|S)a| Write a dynamic array formula to a worksheet cell/range. Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. formula: Cell formula. cell_format: An optional cell Format object. value: An optional value for the formula. Default is 0. Returns: 0: Success. -1: Row or column is out of worksheet bounds. dynamicrT)rIr) r"rMrNrOrPrBr*rCerrorr)r)r*rHs z%Worksheet.write_dynamic_array_formulacCs|dr |dd}|dr|dd}|dr!|dd}d|vr'|Stdd|}td d |}td d |}td d|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}|js|Stdd |}td!d"|}td#d$|}td%d&|}td'd(|}td)d*|}td+d,|}td-d.|}td/d0|}td1d2|}td3d4|}td5d6|}td7d8|}td9d:|}td;d<|}td=d>|}td?d@|}tdAdB|}tdCdD|}tdEdF|}tdGdH|}tdIdJ|}tdKdL|}tdMdN|}tdOdP|}tdQdR|}tdSdT|}tdUdV|}tdWdX|}tdYdZ|}td[d\|}td]d^|}td_d`|}tdadb|}tdcdd|}tdedf|}tdgdh|}tdidj|}tdkdl|}tdmdn|}tdodp|}tdqdr|}tdsdt|}tdudv|}tdwdx|}tdydz|}td{d||}td}d~|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}tdd|}td d |}td d |}|S( NrEr rrr.z_xlfn.z\bLET\(z _xlfn.LET(z \bLAMBDA\(z _xlfn.LAMBDA(z \bSINGLE\(z _xlfn.SINGLE(z \bSORTBY\(z _xlfn.SORTBY(z \bUNIQUE\(z _xlfn.UNIQUE(z \bXMATCH\(z _xlfn.XMATCH(z\bSORT\(z_xlfn._xlws.SORT(z \bXLOOKUP\(z_xlfn.XLOOKUP(z \bSEQUENCE\(z_xlfn.SEQUENCE(z \bFILTER\(z_xlfn._xlws.FILTER(z \bRANDARRAY\(z_xlfn.RANDARRAY(z\bANCHORARRAY\(z_xlfn.ANCHORARRAY(z\bCOT\(z _xlfn.COT(z\bCSC\(z _xlfn.CSC(z\bIFS\(z _xlfn.IFS(z\bPHI\(z _xlfn.PHI(z\bRRI\(z _xlfn.RRI(z\bSEC\(z _xlfn.SEC(z\bXOR\(z _xlfn.XOR(z\bACOT\(z _xlfn.ACOT(z\bBASE\(z _xlfn.BASE(z\bCOTH\(z _xlfn.COTH(z\bCSCH\(z _xlfn.CSCH(z\bDAYS\(z _xlfn.DAYS(z\bIFNA\(z _xlfn.IFNA(z\bSECH\(z _xlfn.SECH(z \bACOTH\(z _xlfn.ACOTH(z \bBITOR\(z _xlfn.BITOR(z \bF.INV\(z _xlfn.F.INV(z \bGAMMA\(z _xlfn.GAMMA(z \bGAUSS\(z _xlfn.GAUSS(z \bIMCOT\(z _xlfn.IMCOT(z \bIMCSC\(z _xlfn.IMCSC(z \bIMSEC\(z _xlfn.IMSEC(z \bIMTAN\(z _xlfn.IMTAN(z \bMUNIT\(z _xlfn.MUNIT(z \bSHEET\(z _xlfn.SHEET(z \bT.INV\(z _xlfn.T.INV(z \bVAR.P\(z _xlfn.VAR.P(z \bVAR.S\(z _xlfn.VAR.S(z \bARABIC\(z _xlfn.ARABIC(z \bBITAND\(z _xlfn.BITAND(z \bBITXOR\(z _xlfn.BITXOR(z \bCONCAT\(z _xlfn.CONCAT(z \bF.DIST\(z _xlfn.F.DIST(z \bF.TEST\(z _xlfn.F.TEST(z \bIMCOSH\(z _xlfn.IMCOSH(z \bIMCSCH\(z _xlfn.IMCSCH(z \bIMSECH\(z _xlfn.IMSECH(z \bIMSINH\(z _xlfn.IMSINH(z \bMAXIFS\(z _xlfn.MAXIFS(z \bMINIFS\(z _xlfn.MINIFS(z \bSHEETS\(z _xlfn.SHEETS(z \bSKEW.P\(z _xlfn.SKEW.P(z \bSWITCH\(z _xlfn.SWITCH(z \bT.DIST\(z _xlfn.T.DIST(z \bT.TEST\(z _xlfn.T.TEST(z \bZ.TEST\(z _xlfn.Z.TEST(z \bCOMBINA\(z_xlfn.COMBINA(z \bDECIMAL\(z_xlfn.DECIMAL(z \bRANK.EQ\(z_xlfn.RANK.EQ(z \bSTDEV.P\(z_xlfn.STDEV.P(z \bSTDEV.S\(z_xlfn.STDEV.S(z \bUNICHAR\(z_xlfn.UNICHAR(z \bUNICODE\(z_xlfn.UNICODE(z \bBETA.INV\(z_xlfn.BETA.INV(z \bF.INV.RT\(z_xlfn.F.INV.RT(z \bNORM.INV\(z_xlfn.NORM.INV(z \bRANK.AVG\(z_xlfn.RANK.AVG(z \bT.INV.2T\(z_xlfn.T.INV.2T(z \bTEXTJOIN\(z_xlfn.TEXTJOIN(z \bAGGREGATE\(z_xlfn.AGGREGATE(z \bBETA.DIST\(z_xlfn.BETA.DIST(z \bBINOM.INV\(z_xlfn.BINOM.INV(z \bBITLSHIFT\(z_xlfn.BITLSHIFT(z \bBITRSHIFT\(z_xlfn.BITRSHIFT(z \bCHISQ.INV\(z_xlfn.CHISQ.INV(z \bF.DIST.RT\(z_xlfn.F.DIST.RT(z \bFILTERXML\(z_xlfn.FILTERXML(z \bGAMMA.INV\(z_xlfn.GAMMA.INV(z \bISFORMULA\(z_xlfn.ISFORMULA(z \bMODE.MULT\(z_xlfn.MODE.MULT(z \bMODE.SNGL\(z_xlfn.MODE.SNGL(z \bNORM.DIST\(z_xlfn.NORM.DIST(z \bPDURATION\(z_xlfn.PDURATION(z \bT.DIST.2T\(z_xlfn.T.DIST.2T(z \bT.DIST.RT\(z_xlfn.T.DIST.RT(z\bBINOM.DIST\(z_xlfn.BINOM.DIST(z\bCHISQ.DIST\(z_xlfn.CHISQ.DIST(z\bCHISQ.TEST\(z_xlfn.CHISQ.TEST(z\bEXPON.DIST\(z_xlfn.EXPON.DIST(z\bFLOOR.MATH\(z_xlfn.FLOOR.MATH(z\bGAMMA.DIST\(z_xlfn.GAMMA.DIST(z\bISOWEEKNUM\(z_xlfn.ISOWEEKNUM(z\bNORM.S.INV\(z_xlfn.NORM.S.INV(z\bWEBSERVICE\(z_xlfn.WEBSERVICE(z\bERF.PRECISE\(z_xlfn.ERF.PRECISE(z\bFORMULATEXT\(z_xlfn.FORMULATEXT(z\bLOGNORM.INV\(z_xlfn.LOGNORM.INV(z\bNORM.S.DIST\(z_xlfn.NORM.S.DIST(z\bNUMBERVALUE\(z_xlfn.NUMBERVALUE(z\bQUERYSTRING\(z_xlfn.QUERYSTRING(z\bCEILING.MATH\(z_xlfn.CEILING.MATH(z\bCHISQ.INV.RT\(z_xlfn.CHISQ.INV.RT(z\bCONFIDENCE.T\(z_xlfn.CONFIDENCE.T(z\bCOVARIANCE.P\(z_xlfn.COVARIANCE.P(z\bCOVARIANCE.S\(z_xlfn.COVARIANCE.S(z\bERFC.PRECISE\(z_xlfn.ERFC.PRECISE(z\bFORECAST.ETS\(z_xlfn.FORECAST.ETS(z\bHYPGEOM.DIST\(z_xlfn.HYPGEOM.DIST(z\bLOGNORM.DIST\(z_xlfn.LOGNORM.DIST(z\bPERMUTATIONA\(z_xlfn.PERMUTATIONA(z\bPOISSON.DIST\(z_xlfn.POISSON.DIST(z\bQUARTILE.EXC\(z_xlfn.QUARTILE.EXC(z\bQUARTILE.INC\(z_xlfn.QUARTILE.INC(z\bWEIBULL.DIST\(z_xlfn.WEIBULL.DIST(z\bCHISQ.DIST.RT\(z_xlfn.CHISQ.DIST.RT(z\bFLOOR.PRECISE\(z_xlfn.FLOOR.PRECISE(z\bNEGBINOM.DIST\(z_xlfn.NEGBINOM.DIST(z\bPERCENTILE.EXC\(z_xlfn.PERCENTILE.EXC(z\bPERCENTILE.INC\(z_xlfn.PERCENTILE.INC(z\bCEILING.PRECISE\(z_xlfn.CEILING.PRECISE(z\bCONFIDENCE.NORM\(z_xlfn.CONFIDENCE.NORM(z\bFORECAST.LINEAR\(z_xlfn.FORECAST.LINEAR(z\bGAMMALN.PRECISE\(z_xlfn.GAMMALN.PRECISE(z\bPERCENTRANK.EXC\(z_xlfn.PERCENTRANK.EXC(z\bPERCENTRANK.INC\(z_xlfn.PERCENTRANK.INC(z\bBINOM.DIST.RANGE\(z_xlfn.BINOM.DIST.RANGE(z\bFORECAST.ETS.STAT\(z_xlfn.FORECAST.ETS.STAT(z\bFORECAST.ETS.CONFINT\(z_xlfn.FORECAST.ETS.CONFINT(z\bFORECAST.ETS.SEASONALITY\(z_xlfn.FORECAST.ETS.SEASONALITY()rr r subrr"rBr)r)r*rJsL      zWorksheet._prepare_formularLc Cs||kr ||}}||kr||}}|||rdS|||r"dS||kr0||kr0t||} n t||dt||} ||}|jrN||jkrN||t|||| ||j||<|jst||dD]} t||dD]} | |ksx| |kr| | | d|qnqedS)Nr.r.r r) r0rrJrZrr2cell_arformula_tuplerranger) r"rMrNrOrPrBr*rCatype cell_rangerr;r)r)r*rIs<        zWorksheet._write_array_formulacCr()a Write a date or time to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). date: Date and/or time as a datetime object. cell_format: A cell Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. )r#)r"rr;r r*r)r)r*write_datetimer9zWorksheet.write_datetimecCsZ|||rdS|jr||jkr||||}|dur!|j}t|||j||<dS)Nr.r)r0rZrr2_convert_date_timerr<r)r"rr;r r*r7r)r)r*r#s   zWorksheet._write_datetimecCr()a Write a boolean value to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). boolean: Cell data. bool type. cell_format: An optional cell Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. )r)r"rr;booleanr*r)r)r* write_booleanr9zWorksheet.write_booleancCsP|||rdS|jr||jkr|||rd}nd}t|||j||<dS)Nr.r r)r0rZrr2cell_boolean_tupler)r"rr;r\r*rCr)r)r*rs  zWorksheet._write_booleancCs|||||||S)a Write a hyperlink to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). url: Hyperlink url. format: An optional cell Format object. string: An optional display string for the hyperlink. tip: An optional tooltip. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: String longer than 32767 characters. -3: URL longer than Excel limit of 255 characters. -4: Exceeds Excel limit of 65,530 urls per worksheet. )r )r"rr;urlr*r)tipr)r)r* write_url5szWorksheet.write_urlc Cs|||rdS|dur|}d}|dr#|dd}|dd}d}d}|drD|dd}|dd }|dd}|dd }d }|d d}d } t||jkrYtd dS|} |dkrd|vrl|dd\}} nd} ||}| dur~|s~|| } t d|st d|rd|}t dd|}| pd} |j } t|| kst| | krtd|| fdS|j d7_ |j dkrtd|dS|j r||jkr|||dur|j}|||||||| |d|j||<| S)Nr.r internal:rIF external:/\TrrzFIgnoring URL since it exceeds Excel's string limit of 32767 charactersr/#\w:\\file:///z^\.\\zfIgnoring URL '%s' with link or location/anchor > %d characters since it exceeds Excel's limit for URLSizNIgnoring URL '%s' since it exceeds Excel's limit of 65,530 URLS per worksheet.) link_typer_rr`)r0rreplacerrcr r0 _escape_urlr r rTrrrZrr2rrr) r"rr;r_r*r)r`rmexternalr4url_str tmp_url_strmax_urlr)r)r*r Lsp               zWorksheet._write_urlcGr)aI Write a "rich" string with multiple formats to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). string_parts: String and format pairs. cell_format: Optional Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: String truncated to 32k characters. -3: 2 consecutive formats used. -4: Empty string used. -5: Insufficient parameters. )_write_rich_stringrr)r)r*write_rich_stringszWorksheet.write_rich_stringcGst|}d}d}d}|||rdSt|dtr|}t}t|_|j|t} g} d} d} t |dkr?t ddS|D]I} t| tsp| dkrW| | | | n| | | dkrgt dd S|t | 7}d } n| dkr| dkrt d d S| | d} | d 7} qAt| dts|j d| D],} t| tr|j d| | qg}t| r| d|jd| ||jdq|jj}||jkrt ddS|js|j|}n|}|jr||jkr||t|||j||<dS)Nrr.rCrczfYou must specify more than 2 format/fragments for rich strings. Ignoring input in write_rich_string().rIzYExcel doesn't allow empty strings in rich strings. Ignoring input in write_rich_string().rlr)zaExcel doesn't allow 2 consecutive formats in rich strings. Ignoring input in write_rich_string().rkr r)z xml:spacepreservetzfString length must be less than or equal to Excel's limit of 32,767 characters in write_rich_string().r/)listr0r$r poprrr_set_filehandlerr append_xml_start_tag _write_fontr_xml_data_element _xml_end_tagfhgetvaluercrZrXr1rr2r3r)r"rr;r#tokensr* str_lengthr5rdefault fragmentspreviousposr attributesr)r)r)r*rtsr                  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_functionr)r)r*add_write_handler;s zWorksheet.add_write_handlercCs2|D]}|||||}|r|S|d7}qdS)a Write a row of data starting from (row, col). Args: row: The cell row (zero indexed). col: The cell column (zero indexed). data: A list of tokens to be written with write(). format: An optional cell Format object. Returns: 0: Success. other: Return value of write() method. r rrr"rr;datar*rrSr)r)r* write_rowJ  zWorksheet.write_rowcCs2|D]}|||||}|r|S|d7}qdS)a Write a column of data starting from (row, col). Args: row: The cell row (zero indexed). col: The cell column (zero indexed). data: A list of tokens to be written with write(). format: An optional cell Format object. Returns: 0: Success. other: Return value of write() method. r rrrr)r)r* write_columnarzWorksheet.write_columncCs|||ddrtd||fdS|duri}|dd}|dd}|dd }|d d }|d d} |d d} |d d} |dd} |dd} |dd}|d| } | sjtj|sjtd|dS|j|||||||| | | | | |g dS)a Insert an image with its top-left corner in a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). filename: Path and filename for in supported formats. options: Position, scale, url and data stream of the image. Returns: 0: Success. -1: Row or column is out of worksheet bounds. Tz Cannot insert image at (%d, %d).r.Nx_offsetry_offsetx_scaler y_scaler_r`object_positionrc image_data description decorativeF positioningImage file '%s' not found.)r0r getospathexistsrr})r"rr;filenameoptionsrrrrr_r`anchorrrrr)r)r* insert_imagexs0             zWorksheet.insert_imagec Cs|||ddrtd||fdS|durd}|duri}|dd}|dd}|d d }|d d }|d d } |d d} |dd} |j|||||||| || | g dS)a Insert an textbox with its top-left corner in a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). text: The text for the textbox. options: Textbox options. Returns: 0: Success. -1: Row or column is out of worksheet bounds. Tz"Cannot insert textbox at (%d, %d).r.NrIrrrrr rrrrF)r0r rrr}) r"rr;textrrrrrrrrr)r)r*insert_textboxs&        zWorksheet.insert_textboxc Cs|||ddrtd||fdS|duri}|js"|jr(|jjr(tddSd|_|jr2d|j_|dd}|dd}|d d }|d d }|d d } |d d} |dd} |jd krd|j}|jd krl|j}|jrr|j}|jrx|j}|j |||||||| | | g dS)a Insert an chart with its top-left corner in a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). chart: Chart object. options: Position and scale of the chart. Returns: 0: Success. -1: Row or column is out of worksheet bounds. Tz Cannot insert chart at (%d, %d).r.Nz7Chart cannot be inserted in a worksheet more than once.rrrrr rrrrF) r0r already_insertedcombinedrrrrrrr}) r"rr;chartrrrrrrrrr)r)r* insert_chartsF           zWorksheet.insert_chartcCsT|duri}|||rdSt||jkrdSd|_d|_||||g|j||<dS)a Write a comment to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). comment: Cell comment. Str. options: Comment formatting options. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: String longer than 32k characters. Nr.r/r r)r0rrcrrr)r"rr;commentrr)r)r* write_comments zWorksheet.write_commentcC d|_dS)z Make any comments in the worksheet visible. Args: None. Returns: Nothing. r N)rrr)r)r* show_comments3 zWorksheet.show_commentsFcCs0|stj|std|dS||_||_dS)z Set a background image for a worksheet. Args: filename: Path and filename for in supported formats. is_byte_stream: File is a stream of bytes. Returns: Nothing. rr.N)rrrr rr)r"ris_byte_streamr)r)r*set_background@s   zWorksheet.set_backgroundcC ||_dS)z Set the default author of the cell comments. Args: author: Comment author name. String. Returns: Nothing. N)r)r"authorr)r)r*set_comments_authorSrzWorksheet.set_comments_authorcCs|jS)zw Retrieve the worksheet name. Args: None. Returns: Nothing. )rVrr)r)r*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. rr N)rjrprWr activesheetrr)r)r*activatenszWorksheet.activatecCd|_d|_dS)z Set current worksheet as a selected worksheet, i.e. the worksheet has its tab highlighted. Note: A selected worksheet cannot be hidden. Args: None. Returns: Nothing. r rN)rprjrr)r)r*selects zWorksheet.selectcCr)zv Hide the current worksheet. Args: None. Returns: Nothing. r rN)rjrprr)r)r*hides zWorksheet.hidecCsd|_|j|j_dS)aJ Set current worksheet as the first visible sheet. This is necessary when there are a large number of worksheets and the activated worksheet is not visible on the screen. Note: A selected worksheet cannot be hidden. Args: None. Returns: Nothing. rN)rjrWr firstsheetrr)r)r*set_first_sheetszWorksheet.set_first_sheetc Cs|duri}||kr||}}d}|dd}|dd}|dd} |s)|r,|r,d} nd} |d||| r8dS|d||| rBdS| dkrHd} | d krNd } | |jkrV| |_|||||| |g|jd |<d|_|durn|j}t||d D]} ||g|j| <|r||j| <qudS) a Set the width, and other properties of a single column or a range of columns. Args: first_col: First column (zero-indexed). last_col: Last column (zero-indexed). Can be same as first_col. width: Column width. (optional). cell_format: Column cell_format. (optional). options: Dict of options such as hidden and level. Returns: 0: Success. -1: Column number is out of worksheet bounds. NTrjF collapsedlevelrr.z%05dr ) rr0rrhrrrWrr) r"rNrPwidthr*r ignore_rowrjrr ignore_colr;r)r)r* set_columnsD       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"rNrPrr*rr)r)r*set_column_pixelss   zWorksheet.set_column_pixelsc Cs|duri}|jdur|j}nd}|||rdS|dur |j}|dd}|dd}|dd}|dkr;d}|j}|dkrAd}|d krGd }||jkrO||_|||||g|j|<d |_||g|j|<dS) a Set the width, and other properties of a row. Args: row: Row number (zero-indexed). height: Row height. (optional). cell_format: Row cell_format. (optional). options: Dict of options such as hidden, level and collapsed. Returns: 0: Success. -1: Row number is out of worksheet bounds. Nrr.rjFrrr rT)rfr0rrrrrr) r"rheightr*rmin_colrjrrr)r)r*set_rows2      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"rrr*rr)r)r*set_row_pixelsWs 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 )rrrr)r"rhide_unused_rowsr)r)r*set_default_rowks   zWorksheet.set_default_rowc Cs||kr||krtddS||kr||}}||kr ||}}|||r(dS|||r0dS|j||||g|||||t||dD]}t||dD]}||kr]||kr]qR|||d|qRqIdS)a3 Merge a range of cells. Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. data: Cell data. cell_format: Cell Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. other: Return value of write(). zCan't merge single cellNr.r rIr)r r0rr}rrWr) r"rMrNrOrPrr*rr;r)r)r* merge_ranges(    zWorksheet.merge_rangecCs\||kr ||}}||kr||}}|||||}t||||}||_||_||g|_dS)a Set the autofilter area in the worksheet. Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. Returns: Nothing. N)_convert_name_arearrrr)r"rMrNrOrParearefr)r)r* autofilters  zWorksheet.autofiltercCs`|js tddSzt|Wn!ty0|}t|d\}}||jkr.td|YdSYnw|j\}}||ks>||krItd|||fdS||}t|dks`t|dks`td|| ||}t|d kr||d d kr|| ||d gn/t|d kr|d d kr|d d kr|dd kr| ||d |d gn ||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()Nr9Invalid column '%s'z6Column '%d' outside autofilter() column range (%d, %d)rJrz+Incorrect number of tokens in criteria '%s'rcrr )rr r r!rrbr_extract_filter_tokensr_parse_filter_expressionfilter_column_listrrr)r"r;criteria col_letterr= col_firstcol_lastrr)r)r* filter_columns>         $    zWorksheet.filter_columncCs|js tddSzt|Wn!ty0|}t|d\}}||jkr.td|YdSYnw|j\}}||ks>||krItd|||fdS||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. rNr9rz5Column '%d' outside autofilter() column range (%d,%d)r ) rr r r!rrbrrrr)r"r;filtersrr=rrr)r)r*rs,         zWorksheet.filter_column_listc Cs|||ddr dS|||ddrdS|duri}n|}iddddddddddd dd dd dd dd ddddddddddddd}|D]}||vrdtd|dSqUd|vro|d|d<d|vry|d|d<d|vrtddSddddddddddddd }|d|vrtd |ddS||d|d<|ddkr|d dur|ddurdS|ddks|ddks|ddkrd!|d<d|d <d|vrtd"dSid!d!d#d$d%d&d'd&d(d&d)d*d+d*d,d*d-d.d/d.d0d1d2d1d3d4d5d4d6d7d8d7} |d| vr'td9|ddS| |d|d<|dd!ks=|dd$krId |vrHtd:dSnd|d <d;d} d|vr]d;|d<n|d| vrntd?|ddS| |d|d<|ddks|ddkr|drt|dr||d} d@| |d<|d rt|d r||d } d@| |d <|d rt|d dAkrtdB|d dS|drt|ddAkrtdC|ddS|drt|ddDkrtdE|ddS|drt|ddDkrtdF|ddS|ddkr@t|dt ur@|j |d} t| dDkr@tdG| dSd |vrId<|d <d |vrRd<|d <d |vr[d<|d <d|vrdd<|d<||||gg|dH<d|vr{|dH |d|j |d;S)Ia Add a data validation to a worksheet. Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. options: Data validation options. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: Incorrect parameter or option. Tr.NvalidaterrCsourceminimummaximum ignore_blankdropdown show_input input_title input_message show_error error_title error_message error_type other_cellsz+Unknown parameter '%s' in data_validation()r/z5Parameter 'validate' is required in data_validation()nonewholedecimalrzr r! textLengthcustom) anyz any valuez whole numberrintegerrrzr r!z text lengthlengthrzJUnknown validation type '%s' for parameter 'validate' in data_validation()betweenz5Parameter 'criteria' is required in data_validation() not between notBetweenequal toequalr== not equal tonotEqual!=<> greater than greaterThan> less thanlessThan<greater than or equal togreaterThanOrEqual>=less than or equal tolessThanOrEqual<=zHUnknown criteria type '%s' for parameter 'criteria' in data_validation()zcParameter 'maximum' is required in data_validation() when using 'between' or 'not between' criteriarr rc)stopwarning informationzJUnknown criteria type '%s' for parameter 'error_type' in data_validation()%.16g z6Length of input title '%s' exceeds Excel's limit of 32z6Length of error title '%s' exceeds Excel's limit of 32z9Length of input message '%s' exceeds Excel's limit of 255z9Length of error message '%s' exceeds Excel's limit of 255zSLength of list items '%s' exceeds Excel's limit of 255, use a formula range insteadcells)r0copykeysr rrr[rrrz _csv_joinr1rr}) r"rMrNrOrPrvalid_parameters param_key valid_typescriteria_types error_types date_timerBr)r)r*data_validation:s                                   zWorksheet.data_validationcCsj |||ddr dS|||ddrdS|duri}n|}iddddddddddd dd dd dd dd dddddddddddddddiddddddddddddddddddddddd dd!dd"dd#dd$dd%dddd&}|D]}||vrtd'|d(Sqd|vrtd)d(Sid*d+d,d,d-d-d.d/d0d1d2d3d4d5d6d5d7d7d8d9d:d;dd?d@dAdBdBdCdCdDdEdFdGdH}|d|vrtdI|dd(S|dd6krd6|dJ<||d|d<idKdKdLdMdNdOdPdOdQdOdRdSdTdSdUdSdVdWdXdWdYdZd[dZd\d]d^d]d_d`dad`dbdcdddedfdgdhdidjdkdldmdndodldodp} d|vrc|d| vrc| |d|d<|dd,ksq|dd-krd+|d<d|vrt|dstdqd(S||d} dr| |d<d|vrt|dstdsd(S||d} dr| |d<d |vrt|d stdtd(S||d } dr| |d <idudvdwdxdydzd{d|d}d~dddddddddddddddddddddddd} |ddGkr^|d$stddS|d$| vr+td|d$d(S| |d$|d$<d|d<|d$drDd|d<n |d$drPd|d<||d|d|d<||krh||}}||krr||}}t ||||} t ||} d|vr|d} | dd} d|vr|dr|d |d<|j |d<|j d7_ |js|d#s|ds|ds|ds|ds|ds|ds|ds|d s|d!s|drd|d<|dd7krf|ddckrdc|d<d|d| f|d<nT|dddkr(d|d<d|d| f|d<n>|ddekrCde|d<d| t|d|df|d<n#|ddfkr^df|d<d| t|d|df|d<ntd|d|dd9kr|ddgkr{d| |d<n|ddhkrd| |d<n|ddkrd| |d<n{|ddikrd| | f|d<nk|ddjkrd| | f|d<n[|ddkkrd| | f|d<nK|ddlkrd| | f|d<n;|ddmkrd| | | f|d<n*|ddnkrd| | f|d<n|ddokr d| | | | f|d<ntd|d|dd;krd| |d<|dd=kr,d| |d<|dd?kr9d| |d<|ddAkrFd| |d<|ddBkrd|d<d|d<d|d <d|d<|d d|d d|dd|dd|dd|dd¡t|d|d<t|d|d<|ddCkrd|d<d|d<|d d|d dá|d d|dd|dd|ddġ|ddš|ddơt|d|d<t|d|d<t|d|d<d|vrd|d<|ddEkrd|d<|d s d|d <d|d<n|d |d<|d s d|d <d|d<n|d |d<|dd|dd|dd̡|d|d|d"d͡|dd͡|dd͡|dd|ddΡ|ddΡ|dd͡|dd͡|d d|d!dϡt|d|d<t|d|d<t|d!|d!<t|d|d<t|d|d<|drd|_|d dkr|ddkrd|d<|d dkr|ddkrd|d<| |d<z |ddP|d<Wn ttfyYnwz |ddP|d<Wn ttfyYnwz |ddP|d<Wn ttfyYnw| |jvr-|j| |dS|g|j| <dS)a# Add a conditional format to a worksheet. Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. options: Conditional format options. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: Incorrect parameter or option. Tr.NrrCrrCrr stop_if_truemin_typemid_typemax_type min_value mid_value max_value min_color mid_color max_color min_length max_length multi_range bar_colorbar_negative_colorbar_negative_color_same bar_solidbar_border_colorbar_negative_border_colorbar_negative_border_color_same bar_no_border bar_directionbar_axis_positionbar_axis_colorbar_only data_bar_2010 icon_style reverse_icons) icons_onlyiconsz.Unknown parameter '%s' in conditional_format()r/z4Parameter 'type' is required in conditional_format()cellcellIsr r!average aboveAverage duplicateduplicateValuesunique uniqueValuestoptop10bottomr time_period timePeriodblankscontainsBlanks no_blanksnotContainsBlankserrorscontainsErrors no_errorsnotContainsErrors 2_color_scale 3_color_scaledata_bardataBar expressioniconSet)rBicon_setz?Unknown value '%s' for parameter 'type' in conditional_format() directionrrrrrrrrrrrrrrrrrrrrrr r  containing containsText notContains beginsWithendsWith yesterdaytoday last7DayslastWeekthisWeeknextWeek 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 monthz5Conditional format 'value' must be a datetime object.rz7Conditional format 'minimum' must be a datetime object.z7Conditional format 'maximum' must be a datetime object.3_arrows3Arrows3_flags3Flags3_traffic_lights_rimmed3TrafficLights23_symbols_circled3Symbols4_arrows4Arrows4_red_to_black 4RedToBlack4_traffic_lights4TrafficLights 5_arrows_gray 5ArrowsGray 5_quarters 5Quarters 3_arrows_gray 3ArrowsGray3_traffic_lights3TrafficLights3_signs3Signs 3_symbols 3Symbols2 4_arrows_gray 4ArrowsGray 4_ratings4Rating5_arrows5Arrows 5_ratings5Ratingz^The 'icon_style' parameter must be specified when 'type' == 'icon_set' in conditional_format()rkz/Unknown icon_style '%s' in conditional_format()rJ total_icons4r5rr9$rIpriorityr is_data_bar_2010zNOT(ISERROR(SEARCH("%s",%s)))rBnotContainsTextzISERROR(SEARCH("%s",%s))zLEFT(%s,%d)="%s"zRIGHT(%s,%d)="%s"z2Invalid text criteria '%s' in conditional_format()zFLOOR(%s,1)=TODAY()-1zFLOOR(%s,1)=TODAY()tomorrowzFLOOR(%s,1)=TODAY()+1z0AND(TODAY()-FLOOR(%s,1)<=6,FLOOR(%s,1)<=TODAY())z]AND(TODAY()-ROUNDDOWN(%s,0)>=(WEEKDAY(TODAY())),TODAY()-ROUNDDOWN(%s,0)<(WEEKDAY(TODAY())+7))z\AND(TODAY()-ROUNDDOWN(%s,0)<=WEEKDAY(TODAY())-1,ROUNDDOWN(%s,0)-TODAY()<=7-WEEKDAY(TODAY()))z_AND(ROUNDDOWN(%s,0)-TODAY()>(7-WEEKDAY(TODAY())),ROUNDDOWN(%s,0)-TODAY()<(15-WEEKDAY(TODAY())))zdAND(MONTH(%s)=MONTH(TODAY())-1,OR(YEAR(%s)=YEAR(TODAY()),AND(MONTH(%s)=1,YEAR(A1)=YEAR(TODAY())-1)))z4AND(MONTH(%s)=MONTH(TODAY()),YEAR(%s)=YEAR(TODAY()))zeAND(MONTH(%s)=MONTH(TODAY())+1,OR(YEAR(%s)=YEAR(TODAY()),AND(MONTH(%s)=12,YEAR(%s)=YEAR(TODAY())+1)))z9Invalid time_period criteria '%s' in conditional_format()zLEN(TRIM(%s))=0zLEN(TRIM(%s))>0z ISERROR(%s)zNOT(ISERROR(%s)) colorScaleminmaxrz#FF7128z#FFEF9C percentilez#F8696Bz#FFEB84z#63BE7B2autoMin x14_min_typeautoMax x14_max_typez#638EC6Fz#FF0000z#000000rW)r0rrr rr[rr_set_icon_propsrrrn_get_dxf_indexrrr setdefaultrr_lstripKeyErrorAttributeErrorrr})r"rMrNrOrPrvalid_parameterr valid_type criteria_typer valid_iconsrY start_cellr)r)r*conditional_format& s      !"# '           #                                                                              zWorksheet.conditional_formatc Csi}i}|dur i}n|}|jrtddS|||ddr"dS|||ddr,dS||kr5||}}||kr>||}}dddddddddddd }|D]} | |vr_td| dSqP|d d|d <|d d|d <|d d|d <||} |d r| d 8} | d krtddS|dd|d<|dd|d<|d d|d<|dd|d<|d d |d<|dd|d<d|vr|d} | |d<d| vrtd| dStd| tjrtd| rtd| dStd | rtd!| dStd"| s td#| rtd$| dSd%|vr2|d%|d%<|d%dur'd&|d%<|d% dd&|d%<nd'|d%<|} |} |d rD| d 7} |drN| d 8} t |||||d(<t ||| ||d)<|d sid |d <|d rt|d)|d <d }g|d*<i}t ||d D]!}|d+t |d&d&d d&ddd,}d*|vr|t |d*kr|d*|d }nd}|r|d-d}|d.r|d.|d<|d}|} | |vrtd/| dSd|| <|d0|d1<d2|vr|d2r|d2}|d3r|d3}| d4d5}||d2<t | | d D] }|||||q|d6r^|d6}|}| d7d&}| dd&}|d8kr;d9}|d:krBd;}||d6<|||d}|d|vr|d>}d }t | | d D]F}d }t ||d D]5}|t |kr|t ||kr|||}||vr||||||n||||d|d 7}q|d 7}q|j|d S)?aY Add an Excel table to a worksheet. Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. options: Table format options. (Optional) Returns: 0: Success. -1: Not supported in constant_memory mode. -2: Row or column is out of worksheet bounds. -3: Incorrect parameter or option. Nz5add_table() isn't supported in 'constant_memory' moder.Tr/) rbanded_columns banded_rowscolumnsr first_column header_row last_columnrVstyle total_rowz%Unknown parameter '%s' in add_table()rkrrrr rz1Must have at least one data row in in add_table()rFshow_first_colr show_last_colshow_row_stripesrshow_col_stripesheader_row_countrtotals_row_shownrV z.Name '%s' in add_table() cannot contain spacesz^[\w\\][\w\\.]*$z^\dz-Invalid Excel characters in add_table(): '%s'z"^[a-zA-Z][a-zA-Z]?[a-dA-D]?[0-9]+$z0Name looks like a cell name in add_table(): '%s'z^[rcRC]$z^[rcRC]\d+[rcRC]\d+$z3Invalid name '%s' like a RC cell ref in add_table()rrITableStyleMedium9rWa_rangerColumn)idrV total_stringtotal_function total_valuerBrC name_formatrCr|z*Duplicate header name in add_table(): '%s' header_formatrrBr@z [#This Row],rr= countnums countNumsstddevstdDevrrr)rrZr r0rrr r UNICODErnrrWrrlowerrrr _table_function_to_formularrr}rr)r"rMrNrOrPrrrrrnum_rowsrVfirst_data_row last_data_rowcol_id seen_namescol_numcol_data user_dataxformat header_namerBrfunctionrCrrijr;rr)r)r* add_table sb                                                zWorksheet.add_tablec Cs6|||ddr dSdt||gi}|duri}iddddddddd dd dd dd dd ddddddddddddddddddddddddddd }|D]}||vrltd|dSq]d|vrwtddS|dd}|dvrtddS|dkrd}||d<d|vrt|dtur|d|d<n|dg|d<t|dtur|d|d<n|dg|d<t|d}t|d} || krtd dSt|d|d!<t|j } g} |dD]} | d"d#} | d$} d%| vr| d%| } | | q| |d<g} |dD]}| d"d#}| |q| |d<|d|d&<|d |d'<|d |d(<|d |d)<|d |d*<|d |d <|d+|d+<|d,|d,<|d-|d-<|d.|d.<|d/|d0<|d1|d1<|d2d#}|d3krd4|d5<n|d6krd7|d5<nd8|d5<|d9}|rd%|vr| d%|}||d9<|dd4}t |}|d:|d<|d(|d<|d |d<|d)|d<|d*|d<|d&|d<|d'|d<|||d|||d|||d|||d|||d|||d|||d|j |d4S);ap Add sparklines to the worksheet. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). options: Sparkline formatting options. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: Incorrect parameter or option. Tr. locationsNlocationrWr high_point low_pointnegative_points first_point last_pointmarkersr series_colornegative_color markers_color first_color last_color high_color low_color) rraxisreverse empty_cells show_hidden plot_hidden date_axisweightz)Unknown parameter '%s' in add_sparkline()z0Parameter 'range' is required in add_sparkline()r/line)rcolumnwin_losszJParameter 'type' must be 'line', 'column' or 'win_loss' in add_sparkline()rstackedrangeszMMust have the same number of location and range parameters in add_sparkline()countrrIr!highlownegativefirstlastrrrrrrjrrzeroremptyconnectspangaprseries)r0rrr rrrzrrrVrnrr}r_set_spark_colorr)r"rr;r sparklinerr spark_type range_countlocation_count sheetname new_ranges spark_range new_locationsrr date_rangestyle_idrr)r)r* add_sparkline* s                                   zWorksheet.add_sparklinecCs^d}t||}||kr||}}||kr||}}t||||}|dkr&dS|||gg|_dS)a Set the selected cell or cells in a worksheet Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. Returns: 0: Nothing. NA1)rrri)r"rMrNrOrPpane active_cellsqrefr)r)r* set_selection s   zWorksheet.set_selectioncCs$|dkr |dkr dSt|||_dS)z Set the first visible cell at the top left of a worksheet. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). Returns: 0: Nothing. rN)rrm)r"rr;r)r)r*set_top_left_cell s zWorksheet.set_top_left_cellr cCs"||_||_||_||_d|_dS)a Control outline settings. Args: visible: Outlines are visible. Optional, defaults to True. symbols_below: Show row outline symbols below the outline bar. Optional, defaults to True. symbols_right: Show column outline symbols to the right of the outline bar. Optional, defaults to True. auto_style: Use Automatic style. Optional, defaults to False. Returns: 0: Nothing. TN)rrrrr)r"visible symbols_below symbols_right auto_styler)r)r*outline_settings s  zWorksheet.outline_settingscCs,|dur|}|dur |}|||||g|_dS)at Create worksheet panes and mark them as frozen. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). top_row: Topmost visible row in scrolling region of pane. left_col: Leftmost visible row in scrolling region of pane. Returns: 0: Nothing. N)rn)r"rr;top_rowleft_col pane_typer)r)r* freeze_panes3 s zWorksheet.freeze_panescCs|||||ddS)a Create worksheet panes and mark them as split. Args: x: The position for the vertical split. y: The position for the horizontal split. top_row: Topmost visible row in scrolling region of pane. left_col: Leftmost visible row in scrolling region of pane. Returns: 0: Nothing. rcN)r)r"xyrrr)r)r* split_panesJ szWorksheet.split_panesrNcCs.|dks|dkrtd|d}t||_dS)z Set the worksheet zoom factor. Args: zoom: Scale factor: 10 <= zoom <= 400. Returns: Nothing. z/Zoom factor %d outside range: 10 <= zoom <= 400rNN)r r r)r"rr)r)r*set_zoom\ s zWorksheet.set_zoomcCr)z Display the worksheet right to left for some versions of Excel. Args: None. Returns: Nothing. r N)rrr)r)r* right_to_leftn rzWorksheet.right_to_leftcCr)z Hide zero values in worksheet cells. Args: None. Returns: Nothing. rN)rrr)r)r* hide_zero{ rzWorksheet.hide_zerocCst||_dS)z Set the color of the worksheet tab. Args: color: A #RGB color index. Returns: Nothing. N)rrlr"colorr)r)r* set_tab_color s zWorksheet.set_tab_colorrIcCs|dkr ||}|s i}iddddddddddd dd dd dd dd ddddddddddddddd}|D]}||vrS||||<qFtd|qF||d<||_dS)z Set the password and protection options of the worksheet. Args: password: An optional password string. options: A dictionary of worksheet objects to protect. Returns: Nothing. rIsheetTcontentFobjects scenarios format_cellsformat_columns format_rowsinsert_columns insert_rowsinsert_hyperlinksdelete_columns delete_rowsselect_locked_cellssortr pivot_tablesselect_unlocked_cellszUnknown protection object: '%s'passwordN)_encode_passwordrr r)r"r1rdefaultskeyr)r)r*protect sZ        zWorksheet.protectcCsr|dur tddS|d}|dd}|jd7_|dur'dt|j}|r.||}|j|||fdS) a0 Unprotect ranges within a protected worksheet. Args: cell_range: The cell or cell range to unprotect. range_name: An optional name for the range. password: An optional password string. (undocumented) Returns: Nothing. Nz1Cell range must be specified in unprotect_range()r.rrrIr Range)r rrnrrr2rr}r"rY range_namer1r)r)r*unprotect_range s    zWorksheet.unprotect_rangecCsT|||ddrtd||fdS|duri}||||}|j|d|_dS)aM Insert a button form object into the worksheet. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). options: Button formatting options. Returns: 0: Success. -1: Row or column is out of worksheet bounds. Tz!Cannot insert button at (%d, %d).r.Nr r)r0r _button_paramsrr}r)r"rr;rbuttonr)r)r* insert_button s zWorksheet.insert_buttoncCr)z Set the page orientation as landscape. Args: None. Returns: Nothing. rTNrsrqrr)r)r* set_landscape  zWorksheet.set_landscapecCr)z Set the page orientation as portrait. Args: None. Returns: Nothing. r TNr=rr)r)r* set_portraitr?zWorksheet.set_portraitcCr)zr Set the page view mode. Args: None. Returns: Nothing. r N)rrr)r)r* set_page_view'rzWorksheet.set_page_viewcCs|r ||_d|_dSdS)z Set the paper type. US Letter = 1, A4 = 9. Args: paper_size: Paper index. Returns: Nothing. TN)rrrq)r"rrr)r)r* set_paper4s  zWorksheet.set_papercCr)zx Center the page horizontally. Args: None. Returns: Nothing. Tr N)rtrurr)r)r*center_horizontallyCr?zWorksheet.center_horizontallycCr)zv Center the page vertically. Args: None. Returns: Nothing. Tr N)rtrvrr)r)r*center_verticallyQr?zWorksheet.center_verticallyrKrLcCs||_||_||_||_dS)z Set all the page margins in inches. Args: left: Left margin. right: Right margin. top: Top margin. bottom: Bottom margin. Returns: Nothing. N)rrrr)r"leftrightrBrDr)r)r* set_margins_s zWorksheet.set_marginscCf|}|dd}t|dkrtddS|dur"t|ts!d|i}ni}|}|dur0||d<g|_|drG|j|d|dd g|d r[|j|d |d d g|d ro|j|d |ddg| d}t|j}||krtd|||fg|_dSd|vr|d|_ d|vr|d|_ ||_ |dd|_ d|_|rd|_dSdS)z Set the page header caption and optional margin. Args: header: Header string. margin: Header margin. options: Header options, mainly for images. Returns: Nothing. &[Picture]&GrzCHeader string cannot be longer than Excel's limit of 255 charactersNmargin image_leftimage_data_leftLH image_centerimage_data_centerCH image_rightimage_data_rightRHzONumber of header images (%s) doesn't match placeholder count (%s) in string: %salign_with_marginsscale_with_docrMT)rnrr r$rrrrr}rr~rr|rr{r)r"r|rrK header_origplaceholder_count image_countr)r)r* set_headerr^           zWorksheet.set_headercCrH)z Set the page footer caption and optional margin. Args: footer: Footer string. margin: Footer margin. options: Footer options, mainly for images. Returns: Nothing. rIrJrzCFooter string cannot be longer than Excel's limit of 255 charactersNrKrLrMLFrOrPCFrRrSRFzONumber of footer images (%s) doesn't match placeholder count (%s) in string: %srUrVrMT)rnrr r$rrrrr}rr~rr}rr{r)r"r}rrK footer_origrXrYr)r)r* set_footerr[zWorksheet.set_footercCsD|dur|}|d7}|d7}d||f}t|j}|d||_dS)z Set the rows to repeat at the top of each printed page. Args: first_row: Start row for range. last_row: End row for range. Returns: Nothing. Nr z$%d:$%dr)rrVr)r"rMrOrrr)r)r* repeat_rows s   zWorksheet.repeat_rowscCsH|dur|}t|d}t|d}|d|}t|j}|d||_dS)z Set the columns to repeat at the left hand side of each printed page. Args: first_col: Start column for range. last_col: End column for range. Returns: Nothing. Nr r.r)rrrVr)r"rNrPrrr)r)r*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. rr TN)rwrxrt)r"optionr)r)r*hide_gridlines?s    zWorksheet.hide_gridlinescCd|_d|_dS)z Set the option to print the row and column headers on the printed page. Args: None. Returns: Nothing. TN)ryrtrr)r)r*print_row_col_headersWr?zWorksheet.print_row_col_headerscCr)z Set the option to hide the row and column headers on the worksheet. Args: None. Returns: Nothing. TN)rzrr)r)r*hide_row_col_headerserzWorksheet.hide_row_col_headerscCsJ|dkr|dkr||jdkr||jdkrdS|||||}||_dS)a Set the print area in the current worksheet. Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. Returns: 0: Success. -1: Row or column is out of worksheet bounds. rr N)rarbrr)r"rMrNrOrPrr)r)r* print_arearszWorksheet.print_areacCr)z Set the order in which pages are printed. Args: None. Returns: Nothing. r TN)rrqrr)r)r* print_acrossr?zWorksheet.print_acrosscCsd|_||_||_d|_dS)a Fit the printed area to a specific number of pages both vertically and horizontally. Args: width: Number of pages horizontally. height: Number of pages vertically. Returns: Nothing. r TN)rrrrq)r"rrr)r)r* fit_to_pagess  zWorksheet.fit_to_pagescCr)z Set the start page number when printing. Args: start_page: Start page number. Returns: Nothing. N)r)r" start_pager)r)r*set_start_pagerzWorksheet.set_start_pagecCs:|dks|dkrtd|dSd|_t||_d|_dS)z Set the scale factor for the printed page. Args: scale: Print scale. 10 <= scale <= 400. Returns: Nothing. rrz2Print scale '%d' outside range: 10 <= scale <= 400NrT)r rr rrq)r"scaler)r)r*set_print_scales    zWorksheet.set_print_scalecCre)z Set the option to print the worksheet in black and white. Args: None. Returns: Nothing. TN)rrqrr)r)r*print_black_and_whiter?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)rr"breaksr)r)r*set_h_pagebreaksrzWorksheet.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)rrpr)r)r*set_v_pagebreaksrzWorksheet.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. NSheetr )rrrW)r"rVr)r)r* set_vba_names zWorksheet.set_vba_namec Cs^|durdS|}dddddddddd }|D]}||vr)td|dSq||_dS)a Ignore various Excel errors/warnings in a worksheet for user defined ranges. Args: options: A dict of ignore errors keys with cell range values. Returns: 0: Success. -1: Incorrect parameter or option. Nr.T) number_stored_as_text eval_errorformula_differs formula_rangeformula_unlockedempty_cell_referencelist_data_validationcalculated_columntwo_digit_text_yearz)Unknown parameter '%s' in ignore_errors()r)rrr r)r"rrrr)r)r* ignore_errors s(   zWorksheet.ignore_errorscCs4|d|_|d|_|d|_|d|_|d|_|d|_|d|_|d|_|d |_|d |_ |d |_ |d |_ |d |_ |d|_ |d|_|d|_|d|_|j rvd|_d|_d|_d|_d|_d|_d|_d|_d|_d|_|jrtj|jd\}}t|||_t |ddd|_!|j!|_"dSdS)NrVrWrXrrZr[rrrrrrrr`rrrg)@rLr ?F)dirzw+utf-8modeencoding)#rVrWrXrrZr[rrrrrrrr`rrrrrrrrrrrrr~tempfilemkstemprcloseropenrr)r" init_datafdrr)r)r* _initialize<sF                   zWorksheet._initializecCs||||||||js$|n| | | |j r7| ||||||||||||||||||| d|!dS)N worksheet)"_xml_declaration_write_worksheet_write_sheet_pr_write_dimension_write_sheet_views_write_sheet_format_pr _write_colsrZ_write_sheet_data_write_optimized_sheet_data_write_sheet_protection_write_protected_rangesr`_write_phonetic_pr_write_auto_filter_write_merge_cells_write_conditional_formats_write_data_validations_write_hyperlinks_write_print_options_write_page_margins_write_page_setup_write_header_footer_write_row_breaks_write_col_breaks_write_ignored_errors_write_drawings_write_legacy_drawing_write_legacy_drawing_hf_write_picture_write_table_parts_write_ext_listr _xml_closerr)r)r*_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-)rarbrZrrdrerfrg)r"rr;rrr)r)r*r0s$ zWorksheet._check_dimensionscCst||j|jSN)rrr)r"dt_objr)r)r*r[szWorksheet._convert_date_timecCsd}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)NrIrr rr.r)rrrarbrrV)r" row_num_1 col_num_1 row_num_2 col_num_2range1range2r row_col_only col_char_1 col_char_2 row_char_1 row_char_2rr)r)r*rs0      zWorksheet._convert_name_areacCsR|sdSt|}d|vr|dt|}|d}t||kr'|d|}|S)Nri)setremoverzr.r)r"rq breaks_set breaks_listmax_num_breaksr)r)r*_sort_pagebreakss   zWorksheet._sort_pagebreakscCsp|sgStd}||}g}|D]#}|dr|dd}|dr*|dd}|dd}||q|S)Nz"(?:[^"]|"")*"|\S+"r r.z"")r compilefindallrr rnr})r"rStoken_rer new_tokensrr)r)r*r4s         z Worksheet._extract_filter_tokenscCst|dkr?|d}td|rd}ntd|rd}ntd||f|||dd}|||dd}||g|S|||S) NrrJz(and|&&)rz (or|\|\|)r z?Token '%s' is not a valid conditional in filter expression '%s'r)rr r r _parse_filter_tokens)r"rSr conditional expression_1 expression_2r)r)r*rUs    z"Worksheet._parse_filter_expressionc Csddddddddddddd }||dd}|d}td|d rjt|d}|dks3|d kr;td ||f|}|d krO|d krOtd||f|d dkrZd}nd}|dd krf|d7}t|}|sz|d rztd|d |ftd|r|dkr|dkrtd|d|f|}|dkr|dkrd}n |dkrd}d}nd}d}|dkrtd|rd}||gS)Nrcrr rJr) rrz=~eqrz!~nerrr rrz top|bottomriz?The value '%d' in expression '%s' must be in the range 1 to 500items%z?The type '%s' in expression '%s' must be either 'items' or '%%'rBrz}|d@}|d@}|dL}||B}||q d}|D]} || N}q0||N}|dN}d|S)Nrr rHi?rOiKz%X)rordr}) r" plaintextrrdigitscharlow_15high_15 password_hashdigitr)r)r*r2s"   zWorksheet._encode_passwordc  Csd} |j|\ } } }}}}}}}}}}}||9}||9}|d|9}|d| 9}|| | |||||}td|d}td|d}|js_t}d|_||_|jddt|ddgn|j}| }| |d <||d <||d <||d <||d <d|d<||d<d|d<d|d<||d<||d<|dur||d <|r#d}d}d}t d|r| |}t d|r| |}t d|r| dd}| |}| dd}t d|st d|rd|}n| d d!}t d"|r| d"d}d}|dur#t||jkr td#||jfn|j|s|j|||g|||d<|j| s:|jd$d%t|d&|g|| |d<dS)'NrcgX@r5%r /drawing../drawings/drawing.xmlr dimensionsrrrshaperr rel_index url_rel_indexr`r /hyperlinkExternalr^mailto:rdrIrg%23rhrirjrfrerbaIgnoring URL '%s' with link and/or anchor > %d characters since it exceeds Excel's limit for URLS/image../media/image.)r_position_object_emusr rr embeddedrr}r_add_drawing_objectr r rornrrr rrr_get_drawing_rel_index)r"rWimage_id drawing_idrrrV image_typex_dpiy_dpidigest drawing_typerr;r=rrrrr_r`rrrrrdrawing_objecttargetrel_type target_moder)r)r*_prepare_images                  zWorksheet._prepare_imagec CsBd}|j|\ }}}}}} } } } } }| d|jd}| d|jd}||9}|| 9}|||||||| }td|d}td|d}|jsct}d|_||_|j dd t |d dgn|j}t d d | }| |_ |}||d <||d<||d<||d<| |d<||d<| |d<d|d<d|d<| d|d<||d<| dd}|rd}d}d}td|r||}td|r||}td|r|dd}||}|dd}td |r|d d}d}|durt||jkrtd!||jfdS|j|s|j |||g|||d<dSdSdS)"NrJrrrrrr rrrrectTextBoxrrrrrrrrr`rr_rrrrrdrjrgrrbr)rrrrrr rr rrr}rrrrr r rornrrr rrr)r"rWrrrr;rrrrrrrrrrrrrrrr_rrrr)r)r*_prepare_shape?s                 zWorksheet._prepare_shapec Csbtdd|}|j| s|jddt|d|g|| } |j||||||| gdS)Nz\..*$rIrrr) r rTrrrr}r_get_vml_drawing_rel_indexr) r"rrrrVrpositionrrrref_idr)r)r*_prepare_header_images   zWorksheet._prepare_header_imagecCs$|jddt|d|gdS)Nrrr)rr}r)r"rrr)r)r*_prepare_backgrounds zWorksheet._prepare_backgroundc Cs4d}|j|\ }}}}} } } } } }|d|_td|j| }td|j| }||||| ||| }|j}|jsQt}d|_ ||_|j ddt |dgn|j}| }||d<||d<||d<||d <||d <d|d <| |d <||d <d|d<d|d<| |d<||d<|j ddt |dgdS)Nr rrrrrrrrrVrrrrrr`rrz/chartz../charts/chart)rrr rrr chart_namerr rrr}rrrr)r"rWchart_idrrrr;rrrrrrrrrrrrVrrr)r)r*_prepare_chartsV    zWorksheet._prepare_chartc Cs||||||||\ }}}}}} } } } } tdd|}tdd|}tdd| } tdd| } tdd| } tdd| } |||||| | | | | f S)Nrr)_position_object_pixelsr )r" col_start row_startx1y1rrrcol_endrow_endx2y2x_absy_absr)r)r*rs  zWorksheet._position_object_emusc Cs>d}d} |dkr!|dkr!|||d7}|d8}|dkr!|dks |dkr>|dkr>|||d7}|d8}|dkr>|dks)|dkrDd}|dkrJd}|jr\t|D] } ||| 7}qQn||j|7}||7}|jryt|D] } | || 7} qnn| |j|7} | |7} ||||kr|||8}|d7}||||ks||||kr|||8}|d7}||||ks|} |} |||dkr||}|||dkr||}||| |kr||| |8}| d7} ||| |ks||| |kr||| |8}| d7} ||| |ks|}|}||||| | |||| g Sr) _size_col _size_rowrrWrrr)r"rr r r rrrrrrrow_idr r rrr)r)r*rsj  z!Worksheet._position_object_pixelscCsd}d}d}||jvr?|j|d}|j|d}|r#|dkr#d}|S|dkr3t|||d}|St||d|}|S|j}|S)Nrrrr rr)rr r)r"r;rmax_digit_widthpaddingpixelsrrjr)r)r*rzs   zWorksheet._size_colcCs`d}||jvr'|j|d}|j|d}|r|dkrd}|Std|}|Std|j}|S)Nrr rgUUUUUU?)rr r)r"rrrrrjr)r)r*rs   zWorksheet._size_rowcCs0d}d}|dkr|||}|S|||}|S)Ng@g@ r))r"rrrrr)r)r*rs  zWorksheet._pixels_to_widthcCsd|S)NrLr))r"rr)r)r*rszWorksheet._pixels_to_heightcCsVd}d}d}dddddd||dddddddd }|D]} || || <q|d s-||d <|d s5||d <t|d |d <|d d dd|d <|ddur`t|d\} } | |d<| |d<|j} |j} |ddur|dkrud|d<n-|| dkr| d|d<n || dkr| d|d<n|| dkr| d|d<n|d|d<|ddur|dkrd|d<n%|| dkrd|d<n|| dkrd|d<n|| dkrd|d<nd|d<|ddur || dkr| d|d<n!|| dkr| d|d<n|| dkr| d|d<n|d|d<|ddur:|| dkrd|d<n|| dkr*d|d<n|| dkr6d|d<nd|d<|drI|d |d|d <|drX|d |d|d <td |d |d <td |d |d <||d|d|d|d|d |d |}| |d | |d ||||d!|d"|d |d#|d$|d%g |gS)&NJrz#ffffe1r Tahomarc)rrr start_col start_rowr rrrrrr font_name font_size font_familyrrrffrgrrrrJrrrrrrr1rOrrrrr rr r!) rrrrnrrarbr rr})r"rr;r)r default_widthdefault_heightrparamsr4rrrow_maxcol_maxverticesr)r)r*_comment_paramss                           zWorksheet._comment_paramsc Cs|j}|j}d}dt|j}||id}i} |D]} || | | <q| d} | dur1d|} | |dd<| drEd| d|d<nd ||d<| d |d <| d || d <| d || d <| d d| d <| dd| d<| d | dd| d <| d | dd| d <td| d | d <td| d | d <|| d<|| d<|| d| d| d | d| d | d |} | | d | | d | |d<|S)Nrr )rr;fontcaptionz Button %dr-macroz[0]!z[0]!Button%d_Clickrrrrrrrrrrr+) rrrrrrr rr}) r"rr;rr'r&r button_numberr;r(r4r.r+r)r)r*r:6sD      zWorksheet._button_paramscCsTg}t|j}|D]Y}t|j|}|D]K} |j|| } |j| } | |j|| <|jrD|j|| ddurDd|j|| d<|j|| ddurY|j|j|| d<||j|| qq |jddt|dg|j r||_ |j ddt|d gt |} |} t t| d D] }d || |df}q||_||_| S) Nrr rJ /vmlDrawing../drawings/vmlDrawing.vmlz /commentsz ../commentsrrSz%s,%d)sortedrrr,rrr}rrrrrrrWr rr)r"rrvml_drawing_id comment_idrrow_numsrcol_numsr; user_optionsr(r start_data_idrr)r)r*_prepare_vml_objectsysL zWorksheet._prepare_vml_objectscCs&||_|jddt|dgdS)Nr1r2r3)rrr}r)r"rr5r)r)r*_prepare_header_vml_objectss z%Worksheet._prepare_header_vml_objectscCs|jD]=}||d<|ddurdt||d<|d}||vr*td|dd||<|jddt|dg|d 7}qdS) NrrVTablez2Duplicate name '%s' used in worksheet.add_table().Tz/tablez../tables/tablerr )rrrrrrr})r"table_idseenrrVr)r)r*_prepare_tabless*   zWorksheet._prepare_tablesc Cszd}|dd}|dd}|dd}|dd }d d d d ddddd}||vr5||}d||f}|Std||S)NrI'z''rgz'#]z'][z'[efghikmn)r<rrrrrsumvarzSUBTOTAL(%s,[%s])z(Unsupported function '%s' in add_table())rnr )r"rcol_namerB subtotalsfunc_numr)r)r*rs(       z$Worksheet._table_function_to_formulacCs$||vrdSdt||i||<dS)Nrgbr)r"rr user_colorr)r)r*rszWorksheet._set_spark_colorc Cs|jrdSg}t||dD]p}||jvr|dqt||dD][}||j|vrx|j||}t|j} | dkrD|d|jq"| dkrW|j} |j | } || q"| dks_| dkrn|j } | durhd} || q"| d krw|d q"|dq"q|S) Nr)r rArr@rErFrrBrI) rZrWrr}r__name__r7r)rX_get_shared_stringrC) r"r rr r rrow_numrr:type_cell_namerWr)rCr)r)r*_get_range_datas:        $zWorksheet._get_range_datacGsdd|D}d|S)NcSs"g|] }t|ts t|n|qSr))r$r)r:itemr)r)r*r<0sz'Worksheet._csv_join..,)join)r"rr)r)r*r,s zWorksheet._csv_joincCstd|r|S|dd}|dd}|dd}|dd }|d d }|d d }|dd}|dd}|dd}|dd}|dd}|S)Nz%[0-9a-fA-F]{2}rz%25rz%22rz%20rz%3crz%3erCz%5brBz%5d^z%5e`z%60rEz%7brz%7d)r rGrn)r"r_r)r)r*ro5s            zWorksheet._escape_urlcCsR|dur|jd7_|jS|j|r|j|S|jd7_|j|j|<|jSNr )rrrr"rr)r)r*rIs   z Worksheet._get_drawing_rel_indexcCs6|j|r |j|S|jd7_|j|j|<|jSr])rrrr^r)r)r*rUs   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|jn|jr||j}|d|n|dd|dd |jfg|dd |jfg|jdkr|js|dd |jfg|ddS)NrPrbrstrikeoutlineshadowr superscriptrc subscriptszvalr.themeindexedrQrFontfamilyCalibrischeme)rr~bold_xml_empty_tagitalicfont_strikeout font_outline font_shadow underline_write_underline font_script_write_vert_alignr rh _write_color color_indexed font_color_get_palette_color_write_rstring_colorrr! hyperlink font_schemer)r" xf_format xml_writerrr)r)r*rdsH               zWorksheet._write_fontcCsDg}|dkr dg}n|dkrdg}n|dkrdg}|jd|dS)Nrc)rgdouble!)rgsingleAccounting")rgdoubleAccountingurro)r"rtrr)r)r*ruszWorksheet._write_underlinecCsd|fg}|jd|dS)Nrg vertAlignrr"rgrr)r)r*rw zWorksheet._write_vert_aligncCs||fg}|jd|dSNrrr"rVrCrr)r)r*r|rzWorksheet._write_rstring_colorcCs$|ddkr |dd}d|S)Nrrgr FF)upperrr)r)r*r{s   zWorksheet._get_palette_colorcCs|js |jd|_dSdS)NT)rrrrr)r)r* _opt_closes  zWorksheet._opt_closecCs2|jr|j}t|ddd|_d|_|j|_dSdS)Nza+rrF)rrrrr)r"rr)r)r* _opt_reopens  zWorksheet._opt_reopenc Csg}t|D] }|ddddq|dkr"d|dd<d|d d<|d kr8d |dd<d |d d<d |dd<|dkrTd|dd<d|d d<d|dd<d|dd<|rt|}||krb|d }t|D]u}||ddur||d||d<||d}t|tr|dr|d||d<||drd}||d|vrtd||dn||d||d<||ddkrd||d<||d} | r| dkrd||d<qf|S)NFrpercent)rrCrrJCrCrr rKrrcrP<(rPrr)rrr7rBzOUnknown icon property type '%s' for sub-property 'type' in conditional_format()r7numrrT) rWr}rrr$rrrr ) r"r user_propspropsr=max_datartmprrr)r)r*rsT                 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/acxmlnszxmlns:rrzxmlns:mcz xmlns:x14ac)z mc:Ignorablex14acr)r_r}r~)r"schemarxmlns_rxmlns_mc ms_schema xmlns_x14acrr)r)r*rs  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|fgdS)Nrrr. dimensionr)rdrfrgrrero)r"rr2r3r)r)r*r+s      zWorksheet._write_dimensioncCs |d||ddS)N sheetViews)r~_write_sheet_viewrrr)r)r*rOs zWorksheet._write_sheet_viewscCsg}|js |d|jr|d|js|d|jr"|d|jr*|d|js2|d|jr:|d|jdkrG|d |jf|j d krb|jsb|d |j f|j rb|d |j f|d |j sot |j r|d||||ddS|d|dS)N) showGridLinesr)showRowColHeadersr) showZerosr rightToLeftr ) tabSelectedr showOutlineSymbolsr)view pageLayoutrI topLeftCellrN zoomScalezoomScaleNormal)workbookViewIdr sheetView)rxr}rzrrrprrrmrrrnrrir~ _write_panes_write_selectionsrror"rr)r)r*rXs:           zWorksheet._write_sheet_viewcCs|j}|j}|j}d|fg}|j|jkr|d|jr!|d|r*|d|f|r3|d|f|jdkr=|d|d|dS) NdefaultRowHeight customHeightr ) zeroHeightr outlineLevelRowoutlineLevelColrzx14ac:dyDescentz0.25 sheetFormatPr)rrrrr}rr_ro)r"r row_level col_levelrr)r)r*rs      z Worksheet._write_sheet_format_prcCsF|jsdS|dt|jD] }||j|q|ddS)Ncols)rhr~r4r_write_col_infor)r"r;r)r)r*rs  zWorksheet._write_colscCs8|\}}}}}}}d} d} |r|} |dur!|sd}d} n d}n|dkr'd} |dkr\d} d} |dkrHtt|| | dt| dd}ntt|| d| t| dd}d|dfd |dfd d |fg} | rv| d | f|r}| d | r| d|r| d|f|r| d|d| dS)Nr rrQrrrgp@rrrrr)rjr9) customWidthr9 outlineLevel)rr9r;) _get_xf_indexr rr}ro)r"col_infocol_minr*rr*rjrr custom_widthxf_indexrrrr)r)r*rs^       zWorksheet._write_col_infocCs8|jdur |ddS|d||ddS)N sheetData)rdror~ _write_rowsrrr)r)r*rs  zWorksheet._write_sheet_datacCs|jdur |ddS|dd}|jd|j|}|r/|j||j|}|s!|jt |j | ddS)Nrir) rdror~rseekreadrrrrunlinkrr)r" buff_sizerr)r)r*rs        z%Worksheet._write_optimized_sheet_datacCsDd|jfd|jfd|jfd|jfd|jfd|jfg}|d|dS)NrErFrBrDr|r} pageMargins)rrrrrrrorr)r)r*r szWorksheet._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 fn|j r|d|j f|j r|d|j f|d|dS)N paperSizerNrmr fitToWidth fitToHeight) pageOrder overThenDownfirstPageNumber)rsportrait)rs landscape) blackAndWhiter9r)useFirstPageNumberr9 horizontalDpi verticalDpi pageSetup)rqrrr}rrrrrrrsrr\rrrorr)r)r*rsB        zWorksheet._write_page_setupcCs^g}|jsdS|jr|d|jr|d|jr|d|jr'|d|d|dS)N)horizontalCenteredr )verticalCenteredr )headingsr ) gridLinesr printOptions)rtrur}rvryrwrorr)r)r*rgs    zWorksheet._write_print_optionscCszg}|js |d|js|d|jr0|d||jr"||jr)|| ddS|j r;| d|dSdS)N) scaleWithDocr)alignWithMarginsr headerFooter) rr}r~r{r~r|_write_odd_headerr}_write_odd_footerrr`rorr)r)r*rs   zWorksheet._write_header_footercC|d|jdS)N oddHeader)rr|rr)r)r*rzWorksheet._write_odd_headercCr)N oddFooter)rr}rr)r)r*rrzWorksheet._write_odd_footercCs |t|j|jdD]}||jvs||jvs|j|rt|d}||jvr/|j|}nd}|j|rs||jvrB| ||n | |||j|t|j |j dD]}||j|vrl|j||}| |||qU| dq ||jvr||||j|q ||||j|q dS)Nr r#r)_calculate_spansrWrdrerrrr r _write_rowrfrg _write_cellr_write_empty_row)r"rU span_indexrrcol_refr)r)r*rs8       zWorksheet._write_rowscCs|j}||_||jvs||jvs|j|rcd}|j|rY||jvr(|||n ||||j|t|j|jdD]}||j|vrR|j||}||||q;| dn | |||j||j dS)Nr r) rrrrrrWrfrgrrrclear)r"current_row_numrUrrrr)r)r*r2s$   zWorksheet._write_single_rowcCs>i}d}d}t|j|jdD]}||jvr>t|j|jdD]}||j|vr=|dur1|}|}q||kr7|}||kr=|}q||jvrpt|j|jdD]#}||jvro||j|vro|durc|}|}qL||kri|}||kro|}qL|dddks}||jkrt|d}|dur|d7}|d7}d||f||<d}q||_dS)Nr r#rz%s:%s) rWrdrerrfrgrr r)r"spansspan_minspan_maxrUrrr)r)r*rsH     zWorksheet._calculate_spansc Csd}|r |\}}}} } nd\}}}} } |dur|j}d|dfg} |r'|}|r0| d|f|r9| d|f|r@| d||jkrN| dd |f|rU| d ||jkr_| d | rh| d | f| ro| d |jdkry| d|r|d| dS|d| dS)Nr)NNrrrrwr rs) customFormatr htz%g)rjr rr)rr rrr)rrr}rr__xml_empty_tag_unencoded_xml_start_tag_unencoded) r"rr properties empty_rowrrr*rjrrrr)r)r*rs<        zWorksheet._write_rowcCs|j|||dddS)NT)r)r)r"rrrr)r)r*rNszWorksheet._write_empty_rowcCst||}d|fg}|jr|j}|d|fn0||jvr7|j|dr7|j|d}|d|fn||jvrJ|j|}|d|ft|j} | dkr\||j |dS| dkr|j } |j sn| | |dSt d| } tdd| } | d d } | d d } | d r| dr|| |dSt| } || | |dS| dkr|j} t|jtkr|d|jrd} n!d} nt|jtrd} |jdkrn|j| vr|dn|d||j| |dS| dkr,|jdkr|dzt|jWnty|dYnw|d|| |j|j!|"|j|#ddS| dkr9|$d|dS| dkrV|d|d||"|j%|#ddSdS)Nrwrr rAr@z_x005F\1cSsdt|dS)Nz_x%04X_r )rgroup)r r)r)r*zs z'Worksheet._write_cell..u￾_xFFFE_u￿_xFFFF_zzrE)ryr`r)r;z#N/Az#NAME?z#NULL!r:z#REF!z#VALUE!rI)rye)ryrrFrR)cmr crBrD)&rrCrr}rrrrS_xml_number_elementr7r)rZ_xml_string_elementre_control_chars_1rTre_control_chars_2rnrr _xml_rich_inline_stringr_xml_inline_stringrCrr$r_xml_formula_elementrBrXrr!r~_write_cell_array_formularW_write_cell_valuerror\)r"rr;r:rYrrrow_xfcol_xfrVr)rxrC error_codesr)r)r*rRs~                          zWorksheet._write_cellcCs|durd}|d|dS)NrIvr)r"rCr)r)r*rszWorksheet._write_cell_valuecCsdd|fg}|d||dS)N)ryarrayrrr)r"rBrYrr)r)r*rsz#Worksheet._write_cell_array_formulacCsg}|js|js|js|js|jsdS|jr|d|jf|jr&|d|js/|js/|jrH|d|||| | ddS| d|dS)NcodeName) filterModer sheetPr) rrrlrrr}r~_write_tab_color_write_outline_pr_write_page_set_up_prrrorr)r)r*rs4  zWorksheet._write_sheet_prcCs |jsdSdg}|d|dS)N) fitToPager pageSetUpPr)rrorr)r)r*rszWorksheet._write_page_set_up_prcCs(|j}|sdSd|fg}|d|dS)NrQtabColor)rlro)r"rrr)r)r*rs  zWorksheet._write_tab_colorcCs^g}|jsdS|jr|d|js|d|js|d|js'|d|d|dS)N) applyStylesr ) summaryBelowr) summaryRightrr outlinePr)rrr}rrrrorr)r)r*rs    zWorksheet._write_outline_prcC\||j}|s dSt|}d|fd|fg}|d||D]}||dq|ddS)NrmanualBreakCount rowBreaksi?)rrrr~ _write_brkr)r" page_breaksrrrUr)r)r*r  zWorksheet._write_row_breakscCr#)Nrr$ colBreaksi)rrrr~r&r)r"r'rrrr)r)r*r%r(zWorksheet._write_col_breakscCs"d|fd|fdg}|d|dS)Nrr)manr brkro)r"brk_idbrk_maxrr)r)r*r&:s zWorksheet._write_brkcCN|j}t|}|s dSd|fg}|d||D]}||q|ddS)Nr mergeCells)rrr~_write_merge_cellr)r" merged_cellsrr merged_ranger)r)r*rC   zWorksheet._write_merge_cellsc CsF|\}}}}t||}t||}|d|}d|fg} |d| dS)Nr.r mergeCell)rro) r"r3row_minrr)r*r2r3rrr)r)r*r1Vs     zWorksheet._write_merge_cellc Cs`g}d}t|j}|sdS|D]u}t|j|}|D]g}|j||}|d}|jrL|j|rL|j||rL|j||} t| jdkrL|d}|dkrt|jd7_|||||j|d||dg|jd|ddgq|||||d|d|dgqq| d |D]} | d }|dkr|j | q|d kr|j | q| d dS) Nrmr@r_r rr`rrrrrc)r4rrrrrSrr}rr~r{_write_hyperlink_external_write_hyperlink_internalr) r"rdisplayr7rUr8rlinkrmr:r#r)r)r*rcs`   '   zWorksheet._write_hyperlinksc Csxt||}dt|}d|fd|fg} |dur| d|f|dur)| d|f|dur4| d|f|d| dS)NrIdrr:idrr9tooltipr})rrr}ro) r"rr;id_numrr9r=rr_idrr)r)r*r7s  z#Worksheet._write_hyperlink_externalcCsNt||}d|fd|fg}|dur|d|f|d|f|d|dS)Nrrr=r9r})rr}ro)r"rr;rr9r=rrr)r)r*r8s z#Worksheet._write_hyperlink_internalcCsN|jsdSd|jfg}|jr|d|||ddS|d|dS)Nr autoFilter)rrr~_write_autofiltersrrorr)r)r*rs  zWorksheet._write_auto_filtercCsT|j\}}t||dD]}||jvrq |j|}|j|}|||||q dSr])rrWrr_write_filter_column)r"col1col2r;rrr)r)r*rAs    zWorksheet._write_autofilterscCsBd|fg}|d||dkr||n|||ddS)NcolId filterColumnr )r~_write_filters_write_custom_filtersr)r"rrrrr)r)r*rBs    zWorksheet._write_filter_columncCsdd|D}g}t|t|krdg}t|dkr(t|dkr(|d|dS|d|t|D]}||q2|ddS)NcSs g|] }t|dkr|qS)rG)rr)r:filterr)r)r*r<sz,Worksheet._write_filters..)r>r r rr)rror~r4 _write_filterr)r"r non_blanksrrr)r)r*rGs   zWorksheet._write_filterscCd|fg}|d|dS)NrgrIr,rr)r)r*rJ zWorksheet._write_filtercCst|dkr|d|j||ddSg}|ddkr#dg}ndg}|d|||d|d||d|d|ddS) Nrc customFiltersr)andr )rOrr rJr)rr~_write_custom_filterr)r"rrr)r)r*rHs     zWorksheet._write_custom_filterscCsng}dddddddd}||dur||}ntd||dks(|d |f|d |f|d |dS) Nrrr rrr)r rcrJrrrrzUnknown operator = %srrg customFilter)r r}ro)r"rrgrrr)r)r*rP/s   zWorksheet._write_custom_filtercCspg}|jsdS|j}|dr|d|df|dr |d|dr)|d|ds2|d|ds;|d |d rD|d |d rM|d |drV|d|dr_|d|drh|d|drq|d|drz|d|dr|d|ds|d|dr|d|dr|d|d r|d!|d"s|d#|d$|dS)%Nr1r!)r!r r")r"r r#)r#r r$)r$r r%) formatCellsrr&) formatColumnsrr') formatRowsrr() insertColumnsrr)) insertRowsrr*)insertHyperlinksrr+) deleteColumnsrr,) deleteRowsrr-)selectLockedCellsr r.)r.rr)r@rr/) pivotTablesrr0)selectUnlockedCellsr sheetProtection)rr}ro)r"rrr)r)r*rJsR                 z!Worksheet._write_sheet_protectioncCsF|jdkrdS|d|jD] \}}}||||q|ddS)NrprotectedRanges)rr~r_write_protected_rangerr7r)r)r*rzs  z!Worksheet._write_protected_rangescCsBg}|r |d|f|d|f|d|f|d|dS)Nr1r rVprotectedRanger}ro)r"rYr8r1rr)r)r*r_s z Worksheet._write_protected_rangecCs(|jsdS|jd7_||jdSr])rr_write_drawingrr)r)r*rszWorksheet._write_drawingscCs&dt|}d|fg}|d|dS)Nr;r<rrro)r"rr?rr)r)r*rbs  zWorksheet._write_drawingcC@|jsdS|jd7_dt|j}d|fg}|d|dS)Nr r;r< legacyDrawing)rrrror"r?rr)r)r*r  zWorksheet._write_legacy_drawingcCrd)Nr r;r<legacyDrawingHF)rrrrorfr)r)r*rrgz"Worksheet._write_legacy_drawing_hfcCrd)Nr r;r<picture)rrrrorfr)r)r*rrgzWorksheet._write_picturecCr/)NrdataValidations)rrr~_write_data_validationr)r"rrr validationr)r)r*rr4z!Worksheet._write_data_validationsc Csd}g}|dD]+}|dkr|d7}|\}}}}||kr!||}}||kr*||}}|t||||7}q|ddkrR|d|df|ddkrR|d |dfd |vrl|d d kra|d |d d krl|d|dru|d|ds~|d|dr|d|dr|dd|vr|d|dfd|vr|d|dfd|vr|d|dfd|vr|d|df|d|f|ddkr|d |dS|d |||d!|d"dur||d"|d dS)#NrIrrrrrrrrrr ) errorStyler rc)rmr r) allowBlankr r) showDropDownr r)showInputMessager r)showErrorMessager r errorTitlerrSr promptTitlerpromptr dataValidationrCr)rr}ror~_write_formula_1_write_formula_2r) r"rr rr row_firstrrow_lastrr)r)r*rksX                 z Worksheet._write_data_validationcCsdt|tur|j|}d|}nzt|Wnty)|dr'|d}Ynw|d|dS)Nz"%s"rformula1)rrzrrr!rrrrUr)r)r*rv's       zWorksheet._write_formula_1cCDzt|Wnty|dr|d}Ynw|d|dS)Nrformula2rr!rrrrUr)r)r*rw8    zWorksheet._write_formula_2cCs6t|j}|s dS|D] }|||j|q dSr)r4rr_write_conditional_formatting)r"r cond_ranger)r)r*rEsz$Worksheet._write_conditional_formatscCs8d|fg}|d||D]}||q |ddS)Nr conditionalFormatting)r~_write_cf_ruler)r"rr(rparamr)r)r*rPs   z'Worksheet._write_conditional_formattingcCsd|dfg}d|vr|ddur|d|df|d|df|dr-|d|ddkrg|d|d f|d |d |vrYd |vrY||d ||d n||d |d dS|ddkrtd|d rz|dtd|d r|dtd|d rtd|d }|d|df|d |dS|ddkrd |vr|d dkr|dd|vr|d|d pd}|d|f|d |dS|ddkr|d |dS|ddkr|d |dS|dd ks|dd!ks|dd"ks|dd#kr:|d|d f|d$|d f|d |||d%|d dS|dd&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)0NrrCdxfIdrr) stopIfTruer r;rrcfRulerrrCr=below)r=rr) equalAverager z [123] std devz([123]) std devrr rCr)rr rV)rDr rrankr?rArXrrZr[rrBrFrHrJrLrNrrRrrSrT) r}rr~_write_formula_elementrr rGrro_write_color_scale_write_data_bar_write_data_bar_ext_write_icon_set)r"r(rr rr)r)r*rYs                         zWorksheet._write_cf_rulecCr{)NrrBr}rUr)r)r*rr~z Worksheet._write_formula_elementcCs|d||d|d|ddur||d|d||d|d|d|d |d dur?|d|d |d|d |ddS) Nrrr rr!rr"rQr#r$r%)r~ _write_cfvorxr)r"rr)r)r*rs   zWorksheet._write_color_scalecCsg}|dr|d|df|dr|d|df|dr(|d|d|||d|d ||d |d |d |d |ddS)Nr& minLengthr' maxLengthr4 showValuerrRrr rr"rQr))rr}r~rrxr)r"rrr)r)r*rs     zWorksheet._write_data_barcCsp|jd}t|jd}d||f}||d<|j||d|d|d||d|ddS)Nr z{DA7ABA51-AAAA-BBBB-%04X-%012X}guidextLstz&{B025F937-C7B1-47D3-B67F-A62EFF666E3E}zx14:idext)rWrrr}r~ _write_extrr)r"rworksheet_countdata_bar_countrr)r)r*rs      zWorksheet._write_data_bar_extcCsg}|ddkrd|dfg}|dr|d|dr#|d|d|t|dD]}||d |d |d q/|ddS) Nr6rzrTr8rr7)rr r9rrCr)rr}r~reversedrr)r"rriconr)r)r*r s      zWorksheet._write_icon_setcCs>d|fg}|dur|d|f|r|d|d|dS)Nrrg)gtercfvora)r"cf_typergrrr)r)r*r&s  zWorksheet._write_cfvocCs||fg}|d|dSrr,rr)r)r*rx2rMzWorksheet._write_colorcCs|jD]}|j|qdSr)ri_write_selection)r" selectionr)r)r*r8s  zWorksheet._write_selectionscCsJg}|r |d|f|r|d|f|r|d|f|d|dS)Nr activeCellr rra)r"rr r rr)r)r*r=szWorksheet._write_selectioncCs:|j}t|s dS|ddkr|j|dS|j|dS)Nrrc)rnr_write_split_panes_write_freeze_panes)r"rnr)r)r*rLs  zWorksheet._write_panescCsJg}|}|}t||} d} d} d} d} |jr!|jd\}} } g|_|rM|rMd} t|d}td|}|jd||g|jd||g|jd| | gn|r[d} |jd| | gn d} |jd| | g|dkrmd} n |dkrtd} nd } |r|d |f|r|d |f|d | f|d | f|d| f|d|dS)NrIr bottomRighttopRight bottomLeftfrozenr frozenSplitr0xSplitySplitr activePanestater)rrir}ro)r"rr;rrrry_splitx_splitrmrorr r r=row_cellcol_cellr)r)r*rXsH   zWorksheet._write_freeze_panescCsg}d}d}d} d} |} |} |jr|jd\} } } g|_d}| r(td| d} | r/|| } ||krS||krStd| ddd}td| ddd d d }t||}|s^|} |} |r|rd }t|d}td|}|jd ||g|jd||g|jd | | gn|rd }|jd | | gn d}|jd| | g| r|dd| f| r|dd| f|d|f|r|d|f|d|dS)NrrIr rPi,rrOrJrrRrrrrrrrrr)rir _calculate_x_split_widthrr}ro)r"rr;rrrr has_selectionror r rrr=rmrrr)r)r*rsT     zWorksheet._write_split_panescCsZd}d}|dkrt|||d}n t||d|}|dd}|d}|d}|S) Nrrr rrJrrPr)r )r"rrrrpointstwipsr)r)r*rs z"Worksheet._calculate_x_split_widthcCs^|j}t|}|s dSd|fg}|d||D]}|jd7_||jq|ddS)Nr tablePartsr )rrr~r_write_table_partr)r"rrrr=r)r)r*rs  zWorksheet._write_table_partscCs&dt|}d|fg}|d|dS)Nr;r< tablePartrcrfr)r)r*rs  zWorksheet._write_table_partcCsPt|j}t|j}|s|sdS|d|r||r!||ddS)Nr)rrrr~_write_ext_list_data_bars_write_ext_list_sparklinesr)r" has_data_barshas_sparklinesr)r)r*r s   zWorksheet._write_ext_listcCsB|d|d|jD]}||q |d|ddS)Nz&{78C0D931-6437-407d-A8EE-F0AAD7539E65}zx14:conditionalFormattingsr)rr~r"_write_conditional_formatting_2010r)r"rQr)r)r*rs     z#Worksheet._write_ext_list_data_barscCsd}d|fg}|d|||||||d|d||d|d|ds6||d |d sA||d |dsP|d sP||d |ddkr]||d|d|d| d|d|ddS)N3http://schemas.microsoft.com/office/excel/2006/mainxmlns:xmzx14:conditionalFormattingrr rr"r0r-r+r*r/r.r2rr3 x14:dataBar x14:cfRulexm:sqrefrW) r~_write_x14_cf_rule_write_x14_data_bar_write_x14_cfvo_write_x14_border_color_write_x14_negative_fill_color _write_x14_negative_border_color_write_x14_axis_colorrr)r"rQxmlns_xmrr)r)r*r-s2       z,Worksheet._write_conditional_formatting_2010cCs,d}|d}d|fd|fg}|d|dS)NrRrrrrr~)r"rQ rule_typerrr)r)r*rZszWorksheet._write_x14_cf_rulecCsd}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)NrrNrrr0)borderr r,)gradientrr1rE)rV leftToRightrF)rVrr+)negativeBarColorSameAsPositiver r/)$negativeBarBorderColorSameAsPositiverr2middle) axisPositionrr)rrr)r}r~)r"rQr&r'rr)r)r*rbs0            zWorksheet._write_x14_data_barcCsHd|fg}|dvr|d|dS|d||d||ddS)Nr)rrrrzx14:cfvoxm:f)ror~rr)r"rrCrr)r)r*rs   zWorksheet._write_x14_cfvocCrL)NrQzx14:borderColorr,r"rQrr)r)r*r z!Worksheet._write_x14_border_colorcCrL)NrQzx14:negativeFillColorr,rr)r)r*rrz(Worksheet._write_x14_negative_fill_colorcCrL)NrQzx14:negativeBorderColorr,rr)r)r*rrz*Worksheet._write_x14_negative_border_colorcCrL)NrQz x14:axisColorr,rr)r)r*rrzWorksheet._write_x14_axis_colorcCs|d|t|jD]R}||||d||d|||d| |d| |d| |d| |d|d rV| d |d |||d q|d |d dS)Nz&{05C60535-1F16-4fd2-B633-F4F36F0B64E0}rrrrrrrrrx14:sparklineGroupx14:sparklineGroupsr)r_write_sparkline_groupsrr_write_sparkline_group_write_color_series_write_color_negative_write_color_axis_write_color_markers_write_color_first_write_color_last_write_color_high_write_color_lowr_write_sparklinesr)r"rr)r)r*rs$     z$Worksheet._write_ext_list_sparklinescCsn|dt|dD]$}|d|}|d|}|d|d||d||dq |ddS)Nzx14:sparklinesrrrz x14:sparklinerr)r~rWrr)r"rrrrr)r)r*rs       zWorksheet._write_sparklinescCs,d}|d}d|fd|fg}|d|dS)Nz$http://schemas.microsoft.com/office/zspreadsheetml/2009/9/mainz xmlns:x14urirr)r"rr xmlns_x14rr)r)r*rs zWorksheet._write_extcCsd}d|fg}|d|dS)Nrrrr)r"rrr)r)r*rs z!Worksheet._write_sparkline_groupscCs|d}g}|ddur&|ddkrd|d<n |d|dfd|d<|ddurE|ddkr8d|d<n |d |dfd|d<|d d krT|d |d f|d rb|d |d f|drl|d|ru|d|f|dr|d|dr|d|dr|d|dr|d|dr|d|dr|d|dr|d|dr|d |dr|d!|df|dr|d"|df|d#r|d$|d%|dS)&Nrrrcust_max manualMaxrrcust_min manualMinrrr lineWeightr)dateAxisr displayEmptyCellsAsr)rr r)rr r)rr r)rr r)rr r)rr r) displayXAxisr rj) displayHiddenr minAxisType maxAxisTyperrr)rr}r~)r"rrrr)r)r*rsV                             z Worksheet._write_sparkline_groupcCshg}|dr|d|df|dr|d|df|dr,|d|df|||dS)NrQrhtint)rr}ro)r"elementrrr)r)r*_write_spark_colorTs   zWorksheet._write_spark_colorcC|d|dS)Nzx14:colorSeriesrrr)r)r*rczWorksheet._write_color_seriescCr)Nzx14:colorNegativerrr)r)r*rgrzWorksheet._write_color_negativecCs|dddidS)Nz x14:colorAxisrQFF000000rrr)r)r*rkszWorksheet._write_color_axiscCr)Nzx14:colorMarkersrrr)r)r*rorzWorksheet._write_color_markerscCr)Nzx14:colorFirstrrr)r)r*rsrzWorksheet._write_color_firstcCr)Nz x14:colorLastrrr)r)r*rwrzWorksheet._write_color_lastcCr)Nz x14:colorHighrrr)r)r*r{rzWorksheet._write_color_highcCr)Nz x14:colorLowrrr)r)r*rrzWorksheet._write_color_lowcCsddg}|d|dS)N)fontId0)r noConversion phoneticPrr,rr)r)r*rszWorksheet._write_phonetic_prcCsT|jsdS|d|jdr|jd}|d||jdr,|jd}|d||jdr=|jd}|d||jdrN|jd}|d ||jd r_|jd }|d ||jd rp|jd }|d ||jdr|jd}|d||jdr|jd}|d||jdr|jd}|d||ddS)N ignoredErrorsrvnumberStoredAsTextrw evalErrorrxrBry formulaRangerzunlockedFormular{emptyCellReferencer|listDataValidationr}calculatedColumnr~twoDigitTextYear)rr~r_write_ignored_errorr)r"rWr)r)r*rs>                            zWorksheet._write_ignored_errorscCs d|f|dfg}|d|dS)Nr r ignoredErrorr,)r"rrWrr)r)r*rszWorksheet._write_ignored_errorr)Nr)NrrL)NNN)F)NF)rr)r r r r)NNr)NN)rN)rIN)rKrKrLrL)rINN)r )FF)r)rS __module__ __qualname____doc__rUrr-rrr+rr8rr?rrDr r8rQrHrJrIrZr#r]rrar rurtrrrrrrrrrrrrrrrr?rrrrrrrrrrrrrr r rrrrrrr r5r9r<r>r@rArBrCrDrGrZr`rarbrdrfrgrhrirjrlrnrorrrsrurrrr0r[rrrrrr2rrrrrrrrrrrr,r:r;r<r@rrrWrrorrrrurwr|r{rrrrrrrrrrrrrrrrrrrr2rrrrrrrrrrrrr&rr1rr7r8rrArBrGrJrHrPrrr_rrbrrrrrkrvrwrrrrrrrrrrxrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr __classcell__r)r)rr*rGsJ X# N    * .   g p.'?#  J  = 6 ;(lh= "    3#    L L    /+ d!(!RbT3: `  |C4 8   7      K  $ 5   7  N    ( &13  m        G         0    K  h       8 G     -  %     /   Z          -rG)8rrr r collectionsrrrr fractionsriormathrrwarningsr rIr rCr rr rrrutilityrrrrrrrrrrr exceptionsrrr r VERBOSErFr-r8r?r3r<r@r^rKrVrGr)r)r)r*s\