!hcddlZddlZddlZddlZddlZddlmZddlmZddlm Z ddl m Z ddl m Z ddlmZddlmZdd lmZdd lmZd d lmZd d lmZd dlmZd dlmZd dlmZd dlmZd dlmZd dlm Z d dlm!Z!d dlm"Z"d dlm#Z#d dlm$Z$d dlm%Z%d dlm&Z&d dlm'Z'd dlm(Z(d dlm)Z)d dlm*Z*d dl+m,Z,d dl+m-Z-ej.d ej/Z0d!Z1d"Z2d#Z3ed$d%Z4ed&d'Z5ed(d)Z6ed*d+Z7ed,d-Z8ed.d'Z9ed/d0Z:ed1d2Z;ed3d4Z<Gd5d6ejZ=dS)7N) defaultdict) namedtuple)Decimal)Fractionwraps)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)xl_pixel_width)get_sparkline_style)supported_datetime)datetime_to_excel_datetime)get_image_properties)preserve_whitespace)quote_sheetname)DuplicateTableName)OverlappingRangea \bANCHORARRAY\( | \bBYCOL\( | \bBYROW\( | \bCHOOSECOLS\( | \bCHOOSEROWS\( | \bDROP\( | \bEXPAND\( | \bFILTER\( | \bHSTACK\( | \bLAMBDA\( | \bMAKEARRAY\( | \bMAP\( | \bRANDARRAY\( | \bREDUCE\( | \bSCAN\( | \bSEQUENCE\( | \bSINGLE\( | \bSORT\( | \bSORTBY\( | \bSWITCH\( | \bTAKE\( | \bTEXTSPLIT\( | \bTOCOL\( | \bTOROW\( | \bUNIQUE\( | \bVSTACK\( | \bWRAPCOLS\( | \bWRAPROWS\( | \bXLOOKUP\(c<tfd}|S)zn Decorator function to convert A1 notation in cell method calls to the default row/col notation. c |r|d}t|n,#t$rt|}||ddz}YnwxYw|g|Ri|SNrr )int ValueErrorr)selfargskwargs first_argnew_argsmethods Nc:\xampp_lite_8_4\www\timesheet\venv\Lib\site-packages\xlsxwriter/worksheet.py cell_wrapperz'convert_cell_args..cell_wrapper_s '  G I ' ' '(33Hd122h&DDD ' vd,T,,,V,,,s&AArr-r/s` r.convert_cell_argsr1Xs6 6]] - - - -] - c<tfd}|S)zo Decorator function to convert A1 notation in range method calls to the default row/col notation. c |rt|dn#t$rd|dvrC|dd\}}t|\}}t|\}}nt|d\}}||}}||||g} | |dd| }YnwxYw |g|Ri|S)Nr:r r&r'splitrextend) r(r)r*cell_1cell_2row_1col_1row_2col_2r,r-s r.r/z(convert_range_args..cell_wrapperws  DG    d1g~~!%as!3!3088 u088 uu0a99 u$euueU3H OODH % % %DDD vd,T,,,V,,,sBB65B6rr0s` r.convert_range_argsr?ps6 6]]----]-* r2c<tfd}|S)zq Decorator function to convert A1 notation in columns method calls to the default row/col notation. cL |rt|dn#t$rrd|ddD\}}t|\}}t|\}}||g}||dd|}YnwxYw |g|Ri|S)Nrcg|]}|dzS)1).0cols r. z?convert_column_args..column_wrapper..sFFFCcCiFFFr2r5r r6) r(r)r*r9r:_r<r>r,r-s r.column_wrapperz+convert_column_args..column_wrappers  DG    FF47==3E3EFFFNFF(00HAu(00HAuu~H OODH % % %DDD vd,T,,,V,,,sA9BBr)r-rIs` r.convert_column_argsrJs6 6]]----]- r2Stringzstring, formatNumberznumber, formatBlankformatBooleanzboolean, formatFormulazformula, format, valueDatetime ArrayFormulaz$formula, format, value, range, atype RichStringzstring, format, raw_stringErrorzerror, format, valuecJeZdZdZfdZdZedZdZeddZ ddZ edd Z dd Z edd Z dd ZeddZddZe ddZe ddZddZ ddZeddZddZeddZddZeddZddZedZdZdZeddZedd Z edd!Z!edd"Z"edd#Z#edd$Z$edd%Z%d&Z&dd'Z'd(Z(d)Z)d*Z*d+Z+d,Z,d-Z-d.Z.e/ dd/Z0e/ dd0Z1d1Z2dd2Z3dd3Z4dd4Z5e dd5Z6ed6Z7d7Z8d8Z9edd9Z:e dd:Z;edd;Zedd>Z? dd@Z@eddAZAeddBZBddDZCdEZDdFZEdGZFddIZGddJZHeddKZIdLZJdMZKddNZLddOZMdPZNdQZOdRZPddUZQddVZRddWZSddXZTe/ddYZUddZZVd[ZWd\ZXed]ZYd^ZZd_Z[d`Z\daZ]dbZ^dcZ_ddZ`ddeZaddfZbdgZcdhZdddiZedjZfdkZgdlZhdmZidnZjdoZkdpZldqZmdrZndsZodtZpduZqdvZrdwZsddxZtddyZudzZvd{Zwd|Zxd}Zyd~ZzdZ{dZ|dZ}dZ~dZdZdZddZddZdZdZdZdZdZdZdZddZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZddZdZddZddZdZdZdZdZdZdZdZdZdZdZdZdZdZ ddZ ddZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZd„ZdÄZdĄZdńZdƄZdDŽZdȄZdɄZdʄZd˄Zd̄Zd̈́Zdd΄ZdτZdЄZdфZd҄ZdӄZdԄZdՄZdքZdׄZd؄ZdلZdڄZdۄZd܄Zd݄ZdބZd߄ZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZxZS( Worksheetz= A class for writing the Excel XLSX Worksheet file. cx 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|_>d|_?d|_@g|_Ag|_Bi|_Cg|_Dd|_Ei|_Ftt|_Id|_Jd |_Kd|_Ld|_Md |_Nd|_Od|_Pd|_Qd|_Rd |_Sd |_Td |_Ud|_Vd|_Wd|_Xd|_Yd|_Zd|_[d|_\d|_]i|_^g|__tt|_`g|_ai|_bi|_ci|_dd|_ed|_fd|_gtt|_hg|_id|_jd|_kd|_lg|_md|_nd|_od|_pg|_qd|_ri|_si|_ti|_ui|_vd|_wd|_xd |_yd|_zd|_{g|_|g|_}g|_~g|_g|_g|_g|_g|_g|_g|_g|_g|_g|_g|_i|_d|_i|_d|_i|_d|_d|_d|_d|_d|_g|_i|_g|_d|_d |_d|_d|_d|_tt|_d|_d |_d|_d |_d|_d|_d|_d|_d|_d|_d|_d|_d|_ld|_d|_d|_d|_d|_i|_d|_d|_d|_d|_dS)z Constructor. NrFiii@r Tffffff??333333?d\( @@Di)superrV__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_colmaxcol_info 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_date_pixelsdefault_row_zeroednames write_matchtablemerge merged_cells table_cells 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 filter_cells row_sizescol_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_functionsignore_write_string)r( __class__s r.rfzWorksheet.__init__s i'')))     "!$!     "'%*"  $ $"$%*"  $(!$(!"$!   " " "   ! "$%! #D))  !" !!"!"$#% "$"$!%"$#% "#  &&   #!#D)) ! ! !" % %$&!&(#&(#"$$&!)+&!#       "#$ $ %  "' %d++"'#!&#' #' "&$"!%" !%"' ""'$)!#(   r2c|dkr|j||g|RS|jr$|dr|j||g|RS|dr$|dr|j||g|RSd|vrU|jrNt jd|s*t jd|st jd|r|j||g|RS|j rm t|}|j st|s't|s|j|||g|d dRSn#t$rYnwxYw|j||g|RS|j||g|RS) NrY=z{=}r5(ftp|http)s?://mailto:z(in|ex)ternal:r ) _write_blankr startswith_write_formulaendswithrrematch _write_urlrfloatrr r _write_numberr' _write_string)r(tokenrowrFr)fs r._write_token_as_stringz Worksheet._write_token_as_strings B;;$4$S#5555 5  # 8(8(8(=(= 8&4&sC7$777 7   D ! ! 8ennS&9&9 8&4&sC7$777 7 5LL$ *E22 8Iu--  8,e44 #4?33d333 3  " 7 %LL)F%((F588F-4-c3EDHEEEE    &4%c36666 6&4%c36666 6sA D(( D54D5c |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(r%rFr)s r.writezWorksheet.writes "t{3+d++++r2cz|std|d}|j}||jvr|j|}||||g|R}|n|S||j||g|RS|tur|j||g|RS|t tttfvr|j ||g|RS|tur|j |||g|RS|tj tjtjtjfvr|j||g|RSt%|t tttfr|j ||g|RSt%|tr|j |||g|RSt%|tr|j||g|RSt'|r|j||g|RS t |}|j |||g|ddRS#t($rYn,t$r tdt+|zwxYw t||j||g|RS#t($r tdt+|zwxYw)Nz,write() takes at least 4 arguments (3 given)rr zUnsupported type %s in write()) TypeErrorrrrbool_write_booleanr!r&rrr"strr'datetimedatetime timedelta_write_datetime isinstancerr'typer#) r(r%rFr)r$ token_type write_handlerfunction_returnr&s r.r*zWorksheet._writes$ LJKK KQ_  , , , / ;M+mD#sBTBBBO &&& =$4$S#5555 5   &4&sC7$777 7 %gx8 8 8%4%c36666 6   .4.uc3FFFF F    M M      (4'S84888 8 eeS'8< = = 7%4%c36666 6 eS ! ! G.4.uc3FFFF F eT " " 8&4&sC7$777 7 e $ $ 9'4'S84888 8 Le A%4%c3=DH=== =    D L L L str_error string_indexs r.r#zWorksheet._write_stringEs   ! !#s + + 2 v;; ( (-do-.FI# ">BB6JJLL!L   (C$*;$;$;  " "3 ' ' ' 1{KK 3r2c2|||||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(r%rFnumberr>s r. write_numberzWorksheet.write_number`s !!#sFK@@@r2c t|st|r|jr|t|r|||d|dS|tjkr|||d|dS|tj kr|||d|dSnt d|||rdS|jr ||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() optionrBr) r r rrmathinfr.rDrkrrGcell_number_tuplerrLs r.r"zWorksheet._write_numberss4 == E&MM % ==Y..sC+wWWWtx''..sC YWWWy((..sCiXXX) D  ! !#s + + 2   (C$*;$;$;  " "3 ' ' ' 1EE 3qr2c2|||||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. )rr(r%rFblankr>s r. write_blankzWorksheet.write_blanks"  c5+>>>r2c|dS|||rdS|jr ||jkr||t ||j||<dS)NrrB)rDrkrrGcell_blank_tuplerrVs r.rzWorksheet._write_blanksy  1  ! !#s + + 2   (C$*;$;$;  " "3 ' ' ' 0 << 3qr2rc4||||||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. )rr(r%rFformular>values r. write_formulazWorksheet.write_formulas &""3Wk5IIIr2c |||rdS||dkrtddSt|r||||||||S|dr0|dr||||||||S||}|j r ||j kr| |t||||j ||<dS)NrBrYzFormula can't be None or empty{rr)rDr re_dynamic_functionsearchwrite_dynamic_array_formularr_write_array_formula_prepare_formularkrrGcell_formula_tuplerr\s r.rzWorksheet._write_formulas9  ! !#s + + 2 ?gmm 1 2 2 22  % %g . . 33S#sG[%    c " " w'7'7'<'< ,,S#sG[%  ''00   (C$*;$;$;  " "3 ' ' ' 2';NN 3qr2c t|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)rbrcrdre)r( first_row first_collast_rowlast_colr]r>r^s r.write_array_formulazWorksheet.write_array_formulast:  % %g . . 339h';PU ((           r2c X||||||||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)rer) r(rjrkrlrmr]r>r^errors r.rdz%Worksheet.write_dynamic_array_formulasI8))            A::&*D # r2Fc|dr |dd}|dr |dd}|dr |dd}d|vr|Stjdd|}tjd d |}tjd d |}tjd d|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd |}tjd!d"|}tjd#d$|}tjd%d&|}tjd'd(|}tjd)d*|}tjd+d,|}tjd-d.|}tjd/d0|}tjd1d2|}tjd3d4|}tjd5d6|}tjd7d8|}tjd9d:|}tjd;d<|}tjd=d>|}tjd?d@|}|js|s|StjdAdB|}tjdCdD|}tjdEdF|}tjdGdH|}tjdIdJ|}tjdKdL|}tjdMdN|}tjdOdP|}tjdQdR|}tjdSdT|}tjdUdV|}tjdWdX|}tjdYdZ|}tjd[d\|}tjd]d^|}tjd_d`|}tjdadb|}tjdcdd|}tjdedf|}tjdgdh|}tjdidj|}tjdkdl|}tjdmdn|}tjdodp|}tjdqdr|}tjdsdt|}tjdudv|}tjdwdx|}tjdydz|}tjd{d||}tjd}d~|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjd d |}tjd d |}tjd d|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd|}tjdd |}tjd!d"|}tjd#d$|}tjd%d&|}tjd'd(|}tjd)d*|}tjd+d,|}tjd-d.|}tjd/d0|}tjd1d2|}tjd3d4|}tjd5d6|}tjd7d8|}tjd9d:|}tjd;d<|}|S(=Nrar rrrBz_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()rrrsubr)r(r]expand_future_functionss r.rfzWorksheet._prepare_formulaFs   c " " "abbkG   c " " "abbkG   C  #crclG w  N&+-A7KK&~w??&~w??&*,?II&*,?II&mW==&AA&(=wGG&AA&AA&)+=wGG&\7;;&)+=wGG&AA&mW==&@@&*;WEE&&97CC&AA&AA&mW==&)+=wGG&~w??&~w??&AA&AA&*;WEE&*;WEE&)97CC( 1H N&~w??&mW==&)+=wGG&AA&+-A7KK&mW==&)+=wGG&*;WEE&02KWUU&*,?II&)+=wGG&AA&)+=wGG&~w??&)+=wGG&AA&,.CWMM&/1I7SS&-/EwOO&*,?II&,.CWMM&)+=wGG&*,?II&)97CC&AA&/1I7SS&,.CWMM&mW==&\7;;&,.CWMM&,.CWMM&mW==&\7;;&mW==&)97CC&+-A7KK&,.CWMM&*,?II&)+=wGG&AA&*;WEE&~w??&AA&)+=wGG&*,?II&-/EwOO& ')F  & +-NPW  &13MwWW&,.CWMM&/1I7SS&+-A7KK&*,?II&)+=wGG&/1I7SS&~w??&~w??&,.CWMM&mW==&\7;;&~w??&AA&~w??&AA&~w??&AA&~w??&AA&~w??&)+=wGG&)+=wGG&*,?II&\7;;&,.CWMM&+-A7KK&AA&AA&)+=wGG&)+=wGG&~w??&-/EwOO&)+=wGG&*;WEE&+-A7KK&*,?II&+-A7KK&)+=wGG&.0GQQ&.0GQQ&/1I7SS&/1I7SS&,.CWMM&\7;;&,.CWMM&,.CWMM&,.CWMM&+-A7KK&*;WEE&)97CC&\7;;&mW==&\7;;&AA&~w??&AA&)97CC&)97CC&)+=wGG&)+=wGG&AA&*;WEE&~w??&AA&)+=wGG&*,?II&*;WEE&)97CC&)97CC&+-A7KK&~w??&~w??&*,?II&,.CWMM&AA&\7;;&AAr2ric x||kr||}}||kr||}}|||rdS|||rdS||kr||krt||} n$t||dzt||z} ||}|jr ||jkr||t |||| ||j||<|jsPt||dzD]<} t||dzD]&} | |ks| |kr| | | d|'=dS)NrBr5r r) rDrrfrkrrGcell_arformula_tuplerranger") r(rjrkrlrmr]r>r^atype cell_ranger%rFs r.rezWorksheet._write_array_formulas x  "*IxI x  "*IxI  ! !)Y 7 7 2  ! !(H 5 5 2  Y(%:%:*9i@@JJ")Y77#Hh778 ''00   .I0A$A$A  " "9 - - -,@ [%U, ,  9i( # EY1 55 E E HqL99EECi''3)+;+;**3Q DDDEqr2c2|||||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. )r6)r(r%rFr3r>s r.write_datetimezWorksheet.write_datetime2s ##CdK@@@r2c|||rdS|jr ||jkr||||}||j}t |||j||<dS)NrBr)rDrkrrG_convert_date_timercell_datetime_tupler)r(r%rFr3r>rMs r.r6zWorksheet._write_datetimeEs  ! !#s + + 2   (C$*;$;$;  " "3 ' ' '((..  2K 36;GG 3qr2c2|||||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. )r0)r(r%rFbooleanr>s r. write_booleanzWorksheet.write_booleanZs ""3WkBBBr2c|||rdS|jr ||jkr|||rd}nd}t |||j||<dS)NrBr r)rDrkrrGcell_boolean_tupler)r(r%rFrr>r^s r.r0zWorksheet._write_booleanms  ! !#s + + 2   (C$*;$;$;  " "3 ' ' '  EEE 2%EE 3qr2c6|||||||S)a Write a hyperlink to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). url: Hyperlink url. format: An optional cell Format object. string: An optional display string for the hyperlink. tip: An optional tooltip. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: String longer than 32767 characters. -3: URL longer than Excel limit of 255 characters. -4: Exceeds Excel limit of 65,530 urls per worksheet. )r )r(r%rFurlr>r=tips r. write_urlzWorksheet.write_urls &sCk63GGGr2c|||rdS||}d}|dr.|dd}|dd}d}d}|drZ|dd}|dd }|dd}|dd }d }|d d}d } t||jkrt d dS|} |dkrd|vr|dd\}} nd} ||}| |s|| } tj d|stj d|rd|z}tj dd|}| pd} |j } t|| kst| | krt d|| fzdS|xj dz c_ |j dkrt d|zdS||j }|js?|jr ||jkr|||||||||| |d|j||<| S)NrBr internal:rYF external:/\TrrzFIgnoring URL since it exceeds Excel's string limit of 32767 charactersrC#\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_typerr1r)rDrreplacerErtr r7 _escape_urlrrrsrrrrrkrrGr#r) r(r%rFrr>r=rrexternalrIurl_str tmp_url_strmax_urls r.r zWorksheet._write_urls  ! !#s + + 2 >F  >>+ & & ++k2..C^^K44FI >>+ & & ++k2..C++c4((C^^K44F^^C..FH 2.. v;; ( ( #   2 >>czz"yya00 WW""3''C"8"**733x$$ '(<(< ' 3&&2s++Cm % s88g  [!1!1G!;!; EHKW~V   2 A  e # # -/23   2  1K' ># ,d.?(?(?&&s+++   sC = = =# % % S!r2c |j||g|RS)aI Write a "rich" string with multiple formats to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). string_parts: String and format pairs. cell_format: Optional Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: String truncated to 32k characters. -3: 2 consecutive formats used. -4: Empty string used. -5: Insufficient parameters. )_write_rich_stringr+s r.write_rich_stringzWorksheet.write_rich_string s!*'t&sC7$7777r2c0t|}d}d}d}|||rdSt|dtr|}t }t |_|j|t} g} d} d} t|dkrtddS|D]} t| tsf| dkr+| | | | n| | | dkrtdd S|| z }d } n5| dkr| dkrtd d S| | d} | d z } t| dts|j d| D]} t| tr0|j d| | Gg}t| r| d|jd| ||jd|jj}t||jkrtddS|js|j|}n|}|jr ||jkr||t3||||j||<dS)NrrYrBrNrzfYou 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().rr=zaExcel doesn't allow 2 consecutive formats in rich strings. Ignoring input in write_rich_string().rr r)z xml:spacepreservetzfString length must be less than or equal to Excel's limit of 32,767 characters in write_rich_string().rC)listrDr7rpopr rr_set_filehandlerEr append_xml_start_tag _write_fontr_xml_data_element _xml_end_tagfhgetvaluertrkrirFrrGcell_rich_string_tupler)r(r%rFr)tokensr>rJ raw_stringrdefault fragmentspreviousposr$ attributesr=s r.rzWorksheet._write_rich_string!sd     ! !#s + + 2 fRj& ) ) ' **,,KZZ {{  $$R(((((   v;;!   B   2" " EeV,, $x''$$W---$$U++++$$U+++B;;A22e# #x''C!GGJ22  '''# 1HCC)A,// - L ' ' , , , / /E%(( / ++C000  '''' &u--A%%&?@@@ ..sE:FFF ))#....))++ z??T_ , , ?   2# ">BB6JJLL!L   (C$*;$;$;  " "3 ' ' ' 6 +z   3qr2c||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_functions r.add_write_handlerzWorksheet.add_write_handlers*7I&&&r2cV|D]%}|||||}|r|cS|dz }&dS)a Write a row of data starting from (row, col). Args: row: The cell row (zero indexed). col: The cell column (zero indexed). data: A list of tokens to be written with write(). format: An optional cell Format object. Returns: 0: Success. other: Return value of write() method. r rr)r(r%rFdatar>r$rqs r. write_rowzWorksheet.write_rowK  EKKS%==E  1HCCqr2cV|D]%}|||||}|r|cS|dz }&dS)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 rr)rs r. write_columnzWorksheet.write_columnrr2c|||ddrtd||fzdS|i}|dd}|dd}|dd }|d d }|d d} |d d} |d d} |dd} |dd} |dd}|d| } | s3tj|std|zdS|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).rBNx_offsetry_offsetx_scaler y_scalerrobject_positionr image_data description decorativeF positioningImage file '%s' not found.)rDr getospathexistsrr)r(r%rFfilenameoptionsrrrrrranchorrrrs r. insert_imagezWorksheet.insert_images"  ! !#sD$ 7 7  3sCj@ A A A2 ?G;;z1--;;z1--++i++++i++kk%&&kk%&&.22[[t44 kk-66 [[u55 ]F33 "'..":":  -8 9 9 92     "qr2c|||rtd||fzdS|i}|dd}|dd}|dd}|dd}|dd} |d d } |s3tj|std |zdS|r1||j}d |_|||||d|d |_t||\} } } } } } } || || | g}|j || }td |||j ||<dS)a Embed an image in a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). filename: Path and filename for in supported formats. options: Url and data stream of the image. Returns: 0: Success. -1: Row or column is out of worksheet bounds. zCannot embed image at (%d, %d).rBNrrr>rrrFrT#VALUE!r)rDr rrrrrrrrembedded_imagesget_image_indexcell_error_tupler)r(r%rFrrrrr>rrr image_typerHdigestimage image_indexs r. embed_imagezWorksheet.embed_images"  ! !#s + +  2c3Z? @ @ @2 ?Gkk%&&kk%&&kk-66 [[t44 kk-66 [[u55  "'..":":  -8 9 9 92  -""5 '+D $ NN3S+tS A A A',D $ !: 6 6  :z; K*::5&II  0 ; TT 3qr2c |||ddrtd||fzdS|d}|i}|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).rBNrYrrrrr rrrrF)rDr rrr) r(r%rFtextrrrrrrrrs r.insert_textboxzWorksheet.insert_textboxRs"  ! !#sD$ 7 7  5c B C C C2 <D ?G;;z1--;;z1--++i++++i++.22kk-66 [[u55      qr2c |||ddrtd||fzdS|i}|js|jr|jjrtddSd|_|jr d|j_|dd}|dd}|d d }|d d }|d d } |d d} |dd} |jd kr|j}|jd kr|j}|jr|j}|jr|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).rBNz7Chart cannot be inserted in a worksheet more than once.rrrrr rrrrF) rDr already_insertedcombinedrrrrrrr) r(r%rFchartrrrrrrrrs r. insert_chartzWorksheet.insert_charts"  ! !#sD$ 7 7  3sCj@ A A A2 ?G  ! 7U^ 78W 7 J K K K F%)E "~ 726/;;z1--;;z1--++i++++i++.22kk-66 [[u55  =A  mG =A  mG > &~H > &~H   qr2c|i}|||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. NrBrCr r)rDrErtrrr)r(r%rFcommentrs r. write_commentzWorksheet.write_commentsw" ?G  ! !#s + + 2 w<<$/ ) )2 $'Wg"> c3qr2cd|_dS)z Make any comments in the worksheet visible. Args: None. Returns: Nothing. r N)rr(s r. show_commentszWorksheet.show_comments!"r2c|s3tj|std|zdS||_||_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. rrBN)rrrr rr)r(ris_byte_streams r.set_backgroundzWorksheet.set_backgroundsP bgnnX&>&>  -8 9 9 92 . (r2c||_dS)z Set the default author of the cell comments. Args: author: Comment author name. String. Returns: Nothing. N)r)r(authors r.set_comments_authorzWorksheet.set_comments_authors &r2c|jS)zw Retrieve the worksheet name. Args: None. Returns: Nothing. )rgrs r.get_namezWorksheet.get_names yr2cDd|_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)r{rrhr  activesheetrs r.activatezWorksheet.activate,s%  *.*'''r2c"d|_d|_dS)z Set current worksheet as a selected worksheet, i.e. the worksheet has its tab highlighted. Note: A selected worksheet cannot be hidden. Args: None. Returns: Nothing. r rN)rr{rs r.selectzWorksheet.select>s  r2c"d|_d|_dS)zv Hide the current worksheet. Args: None. Returns: Nothing. r rNr{rrs r.hidezWorksheet.hideO  r2c"d|_d|_dS)z Hide the current worksheet. This can only be unhidden by VBA. Args: None. Returns: Nothing. rrNrrs r. very_hiddenzWorksheet.very_hidden_rr2c6d|_|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)r{rhr  firstsheetrs r.set_first_sheetzWorksheet.set_first_sheetos )-&&&r2c|i}||kr||}}d}|dd}|dd}|dd} |s|r|rd} nd} |d||| rdS|d||| rdS| dkrd} | d krd } | |jkr| |_t||d zD]} |||| |dg|j| <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. NTr{F collapsedlevelrrBr )rrDrrwryr) r(rkrmwidthr>r ignore_rowr{rr ignore_colrFs r. set_columnzWorksheet.set_columnsO( ?G x  %-yY Xu--KK U33  GQ''  5 V JJJ  ! !!Xz: F F 2  ! !!Y J G G 2 199E 199E 4) ) )%*D "HqL11 W WC"'feYPU!VDM#  !%qr2cb|||}||||||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. )_pixels_to_widthr )r(rkrmrr>rs r.set_column_pixelszWorksheet.set_column_pixelss7(  ))%00Ey(E;PPPr2c|jrtddS|jdSi}t|jj|jjj}t|j|jdzD]}|j |st|j |j dzD]}||j |vr|j ||}|j j}d}|dvrb|dkr|j}||} n|j} d| vrt#| }n.| dD]} t#| } | |kr| }n|d kr%d t't)|jz}n|d kr|j}n|d kr |jrd }nd}n|dks|dkrt1|jt4t6fr0|jdkr$d t't)|jz}nUt1|jt(rt#|j}n&t1|jt8r |jrd }nd}|j ||fr |dkr|dz }| |d} || kr|||<|D]\}} || d z} | dkrd} |j |rv|j |}|d}|d}|)|s'| |kr | |j |d<d|j |d<| |j |d<d|j |d<| dddddg|j |<dS)z Simulate autofit based on the data, and datatypes in each column. Args: None. Returns: Nothing. z1Autofit is not supported in constant_memory mode.N)keyr rrKrSrK rLrrQrO$rPrRgo@TF)!rkr rvsortedri string_table __getitem__rwrurrrwrxr__name__r=rrr7rEr1rMrrr7r^r!r&r/ritemsr ry)r( col_width_maxstringsrow_numcol_numcell cell_typelength string_idr= seg_length width_max pixel_widthrry user_widthr{s r.autofitzWorksheet.autofits     D E E E F ? " F  N 'T^-H-T   T_do.ABBW 8W 8G:>>'**  $/A2EFFS 8S 8dj111:g.w7D $ 7IF $<<<%00(, I%,Y%7FF%)_Fv--%3F%;%;FF+1,,t*<*<88-;F-C-C #-#6#6-7F8 #h.."#ST[)9)9%:%:!:"j00 "&!9"i// <(%'FF%'FF"i//93N3N &dj5#,?? ,#zA~~)*STZ-A-A)A' C88,%3DJ%?%?FF' D99,#z,)+)+(,,gw-?@@%VaZZ" !. 1 1'1 = =I ))17 g.gS 8l%2$7$7$9$9 N N G[))+/::Eu}}}  )) N =,,W55%a[ !!)&)z))49 g.q148 g.q105DM'*1-04DM'*1--*/ua)M g&&5 N Nr2c|i}|j|j}nd}|||rdS||j}|dd}|dd}|dd}|dkr d}|j}|dkrd}|d krd }||jkr||_|||||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. NrrBr{Frrr rT)rwrDrrrrrr) r(r%heightr>rmin_colr{rrs r.set_rowzWorksheet.set_rowms ?G ? &oGGG  ! !#w / / 2 >,FXu--KK U33  GQ'' Q;;F,F 199E 199E 4) ) )%*D "%k65)L c!% &v.sqr2c`|||}|||||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. )_pixels_to_heightr*)r(r%r(r>rs r.set_row_pixelszWorksheet.set_row_pixelss5  ++F33F||Cg>>>r2c`||j}||jkrd|_||_|r d|_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(r(hide_unused_rowss r.set_default_rowzWorksheet.set_default_rowsO >,F T- - -$(D !&,D #  (&'D # # # ( (r2c ||kr||krtddS||kr||}}||kr||}}|||rdS|||rdSt||||}t||dzD]}t||dzD]} |j|| fr2|j|| f} t d|d| d|j|| fr2|j|| f} t d|d| d||j|| f<|j ||||g| ||||t||dzD]=}t||dzD]'} ||kr| |kr| || d |(>d S) a3 Merge a range of cells. Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. data: Cell data. cell_format: Cell Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. other: Return value of write(). zCan't merge single cellNrBr z Merge range '!' overlaps previous merge range ''.!' overlaps previous table range 'rYr) r rDrrwrrr"rrrr*r) r(rjrkrlrmrr>ryr%rFprevious_ranges r. merge_rangezWorksheet.merge_rangess2  Y(%:%: * + + + F x  %-yY x  %-yY  ! !)Y 7 7 2  ! !(H 5 5 2iHhGG HqL11 ? ?CY1 55 ? ?$((#s44 ?%)%6%:%:C:%F%FN**%::~~~7%))3*55?%)%5%9%93*%E%EN**%::~~~7 5?D%sCj11 ?" 9i8DEEE Iy$ <<<HqL11 = =CY1 55 = =)##y(8(8!!#sB <<<< = qr2c||kr||}}||kr||}}|||||}t||||}||_||_||g|_t ||dzD]}d|j||f<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. r TN)_convert_name_arearrrrrwr)r(rjrkrlrmarearefrFs r. autofilterzWorksheet.autofilter! s i  %-yY i  %-yY&&y)XxPPy)Xx@@#!&1HqL11 7 7C26D y#. / / 7 7r2cD|jstddS t|nG#t$r:|}t |dz\}}||jkrtd|zYdSYnwxYw|j\}}||ks||krtd|||fzdS||}t|dvrtd|z| ||}t|dkr*|d dkr| ||d gnpt|d krI|d dkr=|dd kr1|d dkr%| ||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()NrCInvalid column '%s'z6Column '%d' outside autofilter() column range (%d, %d))rZrz+Incorrect number of tokens in criteria '%s'rrr rrZ)rr r&r'rrsr_extract_filter_tokensrE_parse_filter_expressionfilter_column_listrrr)r(rFcriteria col_letterrH col_firstcol_lastrs r. filter_columnzWorksheet.filter_columnB s#  @ A A A F  HHHH   J(s33HQdo%%*Z7888&%  !% 1H ??cHnn H 8,-    F,,X66 v;;f $ $ >I J J J..x@@ v;;!  q Q  # #C&) 5 5 5 5 [[A  &)q..VAY!^^q UV  # #C&)VAY)? @ @ @ @%+D S !$%D S !*>A.-A.cv|jstddS t|nG#t$r:|}t |dz\}}||jkrtd|zYdSYnwxYw|j\}}||ks||krtd|||fzdS||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=NrCr>z5Column '%d' outside autofilter() column range (%d,%d)r ) rr r&r'rrsrrrr)r(rFfiltersrDrHrErFs r.rBzWorksheet.filter_column_list~ s#  @ A A A F  HHHH   J(s33HQdo%%*Z7888&%  !% 1H ??cHnn  )X67    F ' !rHc  |||ddrdS|||ddrdS|i}n|}hd}|D]}||vrtd|zdSd|vr |d|d<d |vr |d |d<d |vrtd dSd d d d d dddddddd }|d |vrtd|d zdS||d |d <|d d kr,|d|ddS|d d ks|d dks |d dkr d|d<d|d<d|vrtddSiddddddd dd!dd"d#d$d#d%d#d&d'd(d'd)d*d+d*d,d-d.d-d/d0d1d0} |d| vrtd2|dzdS| |d|d<|ddks |ddkrd|vrtd3dSnd|d<d4d5d6d7} d8|vrd4|d8<n5|d8| vrtd9|d8zdS| |d8|d8<|d d:vr|drxt |drc||d} d;| z|d<|dr8t |dr#||d} d;| z|d<|dr3t|ddr3t|d>dzdS|dr3t|dd@krtdA|dzdS|dBr3t|dBd@krtdC|dBzdS|d dkrRt|dtr7|j |d} t| d@krtdD| zdSdE|vrd5|dE<dF|vrd5|dF<dG|vrd5|dG<dH|vrd5|dH<||||gg|dI<dJ|vr!|dI |dJdK|vr|dK dLdM|dK<|j |d4S)Na Add a data validation to a worksheet. Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. options: Data validation options. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: Incorrect parameter or option. TrBN>r^sourcemaximumminimumrCdropdownvalidate error_type show_error show_input error_title input_title multi_range other_cells ignore_blank error_message input_messagez+Unknown parameter '%s' in data_validation()rCrLr^rNrPz5Parameter 'validate' is required in data_validation()nonewholedecimalrr3r4 textLengthcustom) anyz any valuez whole numberr\integerr]rr3r4z text lengthr r_zJUnknown validation type '%s' for parameter 'validate' in data_validation()rUrZbetweenrCrMz5Parameter '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 r)stopwarning informationrQzJUnknown criteria type '%s' for parameter 'error_type' in data_validation()r3r4%.16g z6Length of input title '%s' exceeds Excel's limit of 32rTz6Length of error title '%s' exceeds Excel's limit of 32z9Length of input message '%s' exceeds Excel's limit of 255rYz9Length of error message '%s' exceeds Excel's limit of 255zSLength of list items '%s' exceeds Excel's limit of 255, use a formula range insteadrXrOrSrRcellsrWrV$rY)rDcopykeysr rrr}rEr7r _csv_joinr8rrr) r(rjrkrlrmrvalid_parameters param_key valid_typescriteria_types error_types date_timer]s r.data_validationzWorksheet.data_validation s}$  ! !)Yd C C 2  ! !(HdD A A 2 ?GGllnnG   *!  I 000BYNOOOrr1 w  &x0GG    &y1GG  W $ $ H I I I2# '"   : k 1 1 24;J4GH   2"-gj.A"BGJ  J 6 ) ) M**2 O,,42 J 6 ) )z"f,,z"h.."+GJ !%GI  W $ $ H I I I2 y <      '  J   *  *  M        '(<  &  $%6 #! ( : n 4 4 24;J4GH   2"01D"EGJ  : ) + +wz/Bl/R/R''Er ("&GI    w & &$%GL ! ! \ "+ 5 5 ')0)>?   2$/ 0E$FGL ! J #3 3 3  4"77#344 4//0@AAI&2GG y! 9&89K&L&L 9 33GI4FGG %,y%8 " ;;} % % #gm.D*E*E*J*J H-()   2 ;;} % % #gm.D*E*E*J*J H-()   2 ;; ' ' C0H,I,IC,O,O K/*+   2 ;; ' ' C0H,I,IC,O,O K/*+   2 : & ( (Z8H$-O-O ($dngg&67G7||c!!79@Ar  ( (&'GN # W $ $"#GJ  w & &$%GL ! w & &$%GL !' 8XFG G # # G  # #GM$: ; ; ; G # #%,]%;%C%CC%L%LGM " (((qr2cD|||ddrdS|||ddrdS|i}n|}hd}|D]}||vrtd|zdSd|vrtddSid d d d d d d ddddddddddddddddddddd d!d!d"d"d#d$d%d&d'}|d|vrtd(|dzdS|ddkrd|d)<||d|d<id*d*d+d,d-d.d/d.d0d.d1d2d3d2d4d2d5d6d7d6d8d9d:d9d;d<d=d<d>d?d@d?dAdBdCdDdEdFdGdHdIdJdKdLdMdNdKdNdO} dP|vr|dP| vr| |dP|dP<|ddQvrd |d<dR|vrIt |dRstdSdS||dR} dT| z|dR<dU|vrIt |dUstdVdS||dU} dT| z|dU<dW|vrIt |dWstdXdS||dW} dT| z|dW<idYdZd[d\d]d^d_d`dadbdcdddedfdgdhdidjdkdldmdndodpdqdrdsdtdudvdwdxdydz} |dd&kr|d{std|d}S|d{| vrtd~|d{zdS| |d{|d{<d|d<|d{drd|d<n |d{drd|d<||d|d|d<||kr||}}||kr||}}t||||} t||} d|vr|d} | dd} d|vr%|dr|d |d<|j |d<|xj dz c_ |js|ds|ds|ds|ds|ds~|dsi|dsT|ds?|ds*|ds|drd|d<|ddkr|dPdBkrdB|d<d|dRd| d|d<n|dPdCkrd|d<d|dRd| d|d<n|dPdDkr*dD|d<d| t|dR|dRfz|d<nN|dPdEkr*dE|d<d| t|dR|dRfz|d<ntd|dPz|ddkr|dPdFkr d| z|d<n|dPdGkr d| z|d<n|dPdkr d| z|d<n|dPdHkr d| d| d|d<n|dPdIkr d| d| d|d<n|dPdJkr d| d| d|d<n|dPdKkr d| d| d|d<nl|dPdLkrd| d| d| d|d<nP|dPdMkr d| d| d|d<n7|dPdNkrd| d| d| d| d |d<ntd|dPz|ddkrd| z|d<|ddkrd| z|d<|ddkrd| z|d<|dd krd| z|d<|dd!krd|d<d|d<d|d<d|d<|ddæ|ddŦ|ddǦ|ddǦ|ddʦ|dd̦t#|d|d<t#|d|d<|dd"kr d|d<d|d<|ddæ|ddͦ|ddŦ|ddǦ|ddǦ|ddΦ|ddϦ|ddЦt#|d|d<t#|d|d<t#|d|d<d|vrd|d<|dd$kr d|d<|d¦s d|d<d|d<n |d|d<|dĦs d|d<d|d<n |d|d<|ddǦ|ddǦ|ddئ|d|d|ddڦ|ddڦ|ddڦ|dd|ddۦ|ddۦ|ddڦ|ddڦ|dd|ddܦt#|d|d<t#|d|d<t#|d|d<t#|d|d<t#|d|d<|drFd|_|ddkr|ddkrd|d<|ddkr|ddkrd|d<| |d< |dd/|d<n#t(t*f$rYnwxYw |dd/|d<n#t(t*f$rYnwxYw |dd/|d<n#t(t*f$rYnwxYw| |jvr!|j| |n |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. TrBN>$r8iconsr^rNrMrNbar_onlyrCmax_typemid_typemin_type bar_color bar_solid max_color max_value mid_color mid_value min_color min_value icon_style icons_only max_length min_lengthrV stop_if_true bar_direction bar_no_border data_bar_2010 reverse_iconsbar_axis_colorbar_border_colorbar_axis_positionbar_negative_colorbar_negative_color_samebar_negative_border_colorbar_negative_border_color_samez.Unknown parameter '%s' in conditional_format()rCr8z4Parameter 'type' is required in conditional_format()rcellIsr3r4average aboveAverage duplicateduplicateValuesunique uniqueValuestoptop10bottomr time_period timePeriodblankscontainsBlanks no_blanksnotContainsBlankserrorscontainsErrors no_errorsnotContainsErrors 2_color_scale 3_color_scaledata_bardataBar expressioniconSet)r]icon_setz?Unknown value '%s' for parameter 'type' in conditional_format() directionrbrcrdrerfrrgrhrirjrkrlrmrnrorprqrrrsrtrurvrw containing containsText notContains beginsWithendsWith yesterdaytoday last7DayslastWeekthisWeeknextWeek lastMonth thisMonth nextMonth)znot containingz begins withz ends withrrz last 7 daysz last weekz this weekz next weekz last monthz this monthz next monthz continue weekzcontinue monthrCr{r^z5Conditional format 'value' must be a datetime object.r|rNz7Conditional format 'minimum' must be a datetime object.rMz7Conditional 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_ratings5Ratingrz^The 'icon_style' parameter must be specified when 'type' == 'icon_set' in conditional_format()rz/Unknown icon_style '%s' in conditional_format()rZ total_icons4r?5rrrVrrYrNpriorityr rrrrrrrrrrris_data_bar_2010zNOT(ISERROR(SEARCH("z",z)))r]notContainsTextzISERROR(SEARCH("z))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()+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)))z9Invalid time_period criteria '%s' in conditional_format()zLEN(TRIM(%s))=0zLEN(TRIM(%s))>0z ISERROR(%s)zNOT(ISERROR(%s)) colorScalerrrminrmaxrrrrz#FF7128rz#FFEF9C percentilez#F8696Bz#FFEB84z#63BE7Br2autoMin x14_min_typeautoMax x14_max_typerz#638EC6rFz#FF0000z#000000rw)rDrrr rr}rr_set_icon_propsrrr_get_dxf_indexrrrE setdefaultrrplstripKeyErrorAttributeErrorrr)r(rjrkrlrmrvalid_parameterr valid_type criteria_typer valid_iconsry start_cells r.conditional_formatzWorksheet.conditional_format sp(  ! !)Yd C C 2  ! !(HdD A A 2 ?GGllnnG% % % P!  I//E QRRRrr0  G H H H2 H F  F  ~  *  n   7  g  F  <  &  ,  &  ,  _ _! "  # $$!'   . 6?* , , *,3FO<   2v(**'/ $(9GFO! y! <!  !   ! ' ! J !  *!  *!  M!  !  !  !  '(<!  &!  $%6! #!! " .#! $,'#$&###%%%')A! ! ! H  WZ%8M%I%I"/ 0C"DGJ  6?. . .&GFO'!!)''*:;;;PQQQ2 $ 7 78H I II'.':GG$G##)')*<===RSSS2 $ 7 7 8J K KI)09)&+ #*3''*1**=';;z** >&+ #*3''*1**='   {A . . .   {A . . .   {I 6 6 6   17;3G H H H   z5 1 1 1    6 6 6   {E 2 2 2    3 3 3   3Y ? ? ?   :I F F F   8% @ @ @   ? G G G   2B 7 7 7   / ; ; ;#+GK,@#A#AGK *27;M3N*O*OG& '(09I1J(K(KG$ %,4W=Q5R,S,SG( )3;3444G/ 0 ;;) * * *!%D z"e++ 0D0I0I'+ $z"e++ 0D0I0I'+ $)GG  #*;#7#>#>s#C#CGK .)    D  #*;#7#>#>s#C#CGK .)    D  #*;#7#>#>s#C#CGK .)    D  * * *  j ) 0 0 9 9 9 9-4ID j )qs6o&&o:9o:>pp10p15qq('q(c 8i}i}|i}n|}|jrtddS|||ddrdS|||ddrdS||kr||}}||kr||}}t ||||}t ||dzD]} t ||dzD]} |j| | fr2|j| | f} td|d| d |j | | fr2|j | | f} td|d | d ||j| | f<hd } | D]} | | vrtd | zd S|dd|d<|dd|d<|dd|d<||z }|dr|dz}|dkrtdd S|dd|d<|dd|d<|dd|d<|dd|d<|dd|d<|dd|d<d|vr|d}||d<d|vrtd |zd Stj d!|tj rtj d"|rtd#|zd Stj d$|rtd%|zd Stj d&|stj d'|rtd(|zd Sd)|vr8|d)|d)<|d)d*|d)<|d)dd*|d)<nd+|d)<|}|}|dr|dz }|dr|dz}t |||||d,<t |||||d-<|dsd|d<|dr |d-|d<d}g|d.<i}t ||dzD]}|d/t|zd*d*d*dd*ddd0 }d.|vrF|t!|d.kr|d.|dz }nd}|r|d1d}|d2r |d2|d<|d}|}||vrtd3|zd Sd||<|d4|d5<d6|vrk|d6rc|d6}|d7r|d7}|d8d9}||d}||d6<|d:r|d:}|d;krd<}|d=krd>}t+gd?}||vr|||d}n||d}||d@<dA}||d:<|dBd}||||||nM|dCr8|dC}||dC<|||||d1|||d1<|||dz <|d.||dr$||||d|d5|dz }dD|vr|dD}d}t ||dzD]} d} t ||dzD]|} |t!|krb| t!||krI||| }!| |vr|| | |!|| n|| | |!d| dz } }|dz }t9t ||dzD]h\}}|d.|}"|"rS|"d6rK||}#|"d6}t ||dzD]} || |||#i|j||dr"t ||dzD]} d|j|| f<dS)EaY 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' moderTrBr z Table range 'r4r3r2> rrgstylecolumns total_rowr; header_row banded_rows last_column first_columnbanded_columnsz%Unknown parameter '%s' in add_table()rCrrr;rz1Must have at least one data row in in add_table()rFshow_first_colr show_last_colshow_row_stripesrshow_col_stripesheader_row_countrtotals_row_shownrg z.Name '%s' in add_table() cannot contain spacesz^[\w\\][\w\\.]*$z^\dz-Invalid Excel characters in add_table(): '%s'z^[a-zA-Z][a-zA-Z]?[a-dA-D]?\d+$z0Name looks like a cell name in add_table(): '%s'z^[rcRC]$z^[rcRC]\d+[rcRC]\d+$z3Invalid name '%s' like a RC cell ref in add_table()rrYTableStyleMedium9rwa_rangerColumn) idrg total_stringtotal_function custom_total total_valuer]rN name_formatrNrz*Duplicate header name in add_table(): '%s' header_formatr*r]r@z [#This Row],r' count_nums countNumsstd_devstdDevrr.countrrr0sumvarr(r_r)r&r)rrkr rDrrwrrr"rrrrUNICODErr1rElowerrr rfset_table_function_to_formularr#rrr* enumeraterr)$r(rjrkrlrmrr col_formatsryr%rFr5r rnum_rowsrgfirst_data_row last_data_rowcol_id seen_namesrcol_data user_dataxformat header_namer]function subtotalsr^r&rijr$ column_dataformula_formats$ r. add_tablezWorksheet.add_table s $ ?GGllnnG    H I I I2  ! !)Yd C C 2  ! !(HdD A A 2 x  %-yY x  %-yYiHhGG HqL11 > >CY1 55 > >#''c 33 >%)%5%9%93*%E%EN**%::~~~7&**C:66>%)%6%:%:C:%F%FN**%::~~~7 4>D$c3Z00 >"    !  I//II $IW6'mmHd;;G!}}X..?+4X+>(#+6"2K&,,..Dz))IDPQQQ!rr+/ 4(.7mmO.L.LH]+!I--)I2F-"+I"6#--c22:&-nnS&9&9G#*//#~"F"F#'"7"7"F"F.5+!}}%566*#,-=#>#|33'2H#y00'/H$'    % % $y00&*&E&E ((6*:''GG'+&;&;Hd&K&KG7>H^4'/H5=!12 ) mQ ? ?++HgwQVWWWW"~66'0'@ 3?0**$g|Y]]8=T=T *-4-C-C-E-E*/6K + )  # #H - - -|$ ""w(8(=:Q aKFF W  6?DA^]Q->??   HqL99C3t99}}Sa\\)9)9 $Q  ++ KKS%QHHHH KKS%>>>FAAQ )y(Q,)G)GHH O OOFG *62K O{95 O!,!8!8%i0 1BCCOOC''Wg~NNNN 5!!! <  ;Y1 55 ; ;6:!9c"233qr2c |||ddrdSdt||gi}|i}hd}|D]}||vrtd|zdSd|vrtdd S|d d }|d vrtd d S|dkrd}||d <d|vr3t |dt r |d|d<n |dg|d<t |dt r |d|d<n |dg|d<t|d}t|d} || krtdd St|d|d<t|j } g} |dD]N} | dd} | d} d| vr| dz| z} | | O| |d<g} |dD]-}| dd}| |.| |d<|d|d<|d|d<|d|d<|d|d<|d |d!<|d"|d"<|d#|d#<|d$|d$<|d%|d%<|d&|d&<|d'|d(<|d)|d)<|d*d}|d+krd,|d-<n|d.krd/|d-<nd0|d-<|d1}|r d|vr| dz|z}||d1<|d2d,}t|}|d3|d4<|d|d5<|d"|d6<|d|d7<|d!|d8<|d|d9<|d|d:<|||d4|||d5|||d6|||d7|||d8|||d9|||d:|j |d,S);ap Add sparklines to the worksheet. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). options: Sparkline formatting options. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: Incorrect parameter or option. TrB locationsN>rraxisr8rwrweightmarkersreverselocation date_axis low_color low_point high_color high_point last_color last_point empty_cells first_color first_point plot_hidden show_hidden series_color markers_colornegative_colornegative_pointsz)Unknown parameter '%s' in add_sparkline()rwz0Parameter 'range' is required in add_sparkline()rCr8line)rbcolumnwin_losszJParameter 'type' must be 'line', 'column' or 'win_loss' in add_sparkline()rdstackedrQrangeszMMust have the same number of location and range parameters in add_sparkline()r2rrYr!rVhighrTlowranegativer[firstrXlastrOrrrMrPr]r{rNrYzeroremptyconnectspangaprRrseriesr^r`r_rZrWrUrS)rDrrr rr7rrEr rgrr rr_set_spark_colorr)r(r%rFr sparklinerr spark_type range_countlocation_count sheetname new_ranges spark_range new_locationsrQrn date_rangestyle_idrs r. add_sparklinezWorksheet.add_sparkline s$  ! !#sD$ 7 7 2 #4S##>#>"?@ ?G   <!  I 000@9LMMMrr1 ' ! ! C D D D2[[00 ; ; ; 3   2  # #"J& &  '*-t44 ?)0)< +&&*1**=)> +& gg& - - 5")'"2Ih  #*7#3"4Ih )H-.. Y{344 . ( ( 0   2!;!788 '$DI..  $X. + +K%--c266K&,,S11K+%%'#o ;   k * * * *( ( !+. + +H''R00H   * * * *!. +$KK 55 &";;{33 % ' ,= > > *$[[77 '#KK 55 &&{{955 )";;u-- %";;u-- %#KK// &&{{955 )%kk-88 (%kk(33 ( M2.. F??!"Ig   i  !'Ig  !&Ig [[--  6#Z//"S:5J!+ +;;w**#H--$)(O .!&+J&7 "#%*9%5 /"#(> - "'- ,"'- ,!&u + i.AAA i2BCCC i/BBB i-@@@ i,??? i,??? i+>>> y)))qr2cd}t||}||kr||}}||kr||}}t||||}|dkrdS|||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)rrrz)r(rjrkrlrmpane active_cellsqrefs r. set_selectionzWorksheet.set_selections|( 9==  x  %-yY x  %-yYIxBB D== F +u56r2cL|dkr|dkrdSt|||_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)rr~)r(r%rFs r.set_top_left_cellzWorksheet.set_top_left_cells2 !88q F.sC88r2r cL||_||_||_||_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_styles r.outline_settingszWorksheet.outline_settingss1""**'#r2c.||}||}|||||g|_dS)at Create worksheet panes and mark them as frozen. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). top_row: Topmost visible row in scrolling region of pane. left_col: Leftmost visible row in scrolling region of pane. Returns: 0: Nothing. N)r)r(r%rFtop_rowleft_col pane_types r. freeze_paneszWorksheet.freeze_paness/ ?G  H39= r2c8|||||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. rN)r)r(xyrrs r. split_paneszWorksheet.split_paness& !Q155555r2r^cn|dks|dkrtd|zd}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 <= 400r^N)r r&r)r(rs r.set_zoomzWorksheet.set_zoom.s? "99s BTI J J JDII r2cd|_dS)z Display the worksheet right to left for some versions of Excel. Args: None. Returns: Nothing. r N)rrs r. right_to_leftzWorksheet.right_to_left@rr2cd|_dS)z Hide zero values in worksheet cells. Args: None. Returns: Nothing. rN)rrs r. hide_zerozWorksheet.hide_zeroMsr2c.t||_dS)z Set the color of the worksheet tab. Args: color: A #RGB color index. Returns: Nothing. N)rr}r(colors r. set_tab_colorzWorksheet.set_tab_colorZs"%r2rYc8|dkr||}|si}iddddddddddd dd dd dd dd ddddddddddddddd}|D]$}||vr ||||<td|z%||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. rYsheetTcontentFobjects 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(rrdefaultsrs r.protectzWorksheet.protectgs^ r>>,,X66H G T u  u    E  e   5  e  5    e  5  "4  E  % E! " $T# *<<>> > >Ch '  6<==== ('r2c<|tddS|d}|dd}|xjdz c_|dt |jz}|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()rBrrrYr Range)r r rrr1rrrr(ry range_namers r.unprotect_rangezWorksheet.unprotect_ranges   D E E E2 &&s++ ''R00  !!Q&!!   3t'@#A#AAJ  7,,X66H $$j*h%GHHHHHr2c|||ddrtd||fzdS|i}||||}|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).rBNr r)rDr _button_paramsrrr)r(r%rFrbuttons r. insert_buttonzWorksheet.insert_buttons  ! !#sD$ 7 7  4SzA B B B2 ?G$$S#w77   ((( qr2c"d|_d|_dS)z Set the page orientation as landscape. Args: None. Returns: Nothing. rTNrrrs r. set_landscapezWorksheet.set_landscape"&r2c"d|_d|_dS)z Set the page orientation as portrait. Args: None. Returns: Nothing. r TNrrs r. set_portraitzWorksheet.set_portraitrr2c||_dS)z Set the page view mode. Args: 0: Normal view mode 1: Page view mode (the default) 2: Page break view mode Returns: Nothing. Nrr(views r. set_page_viewzWorksheet.set_page_viewsr2cd|_dS)zr Set the page view mode. Args: None. Returns: Nothing. rNrrs r.set_pagebreak_viewzWorksheet.set_pagebreak_viewsr2c*|r||_d|_dSdS)z Set the paper type. US Letter = 1, A4 = 9. Args: paper_size: Paper index. Returns: Nothing. TN)rr)r(rs r. set_paperzWorksheet.set_papers+  +(DO&*D # # # + +r2c"d|_d|_dS)zx Center the page horizontally. Args: None. Returns: Nothing. Tr N)rrrs r.center_horizontallyzWorksheet.center_horizontally$&*" r2c"d|_d|_dS)zv Center the page vertically. Args: None. Returns: Nothing. Tr N)rrrs r.center_verticallyzWorksheet.center_vertically2rr2r[r\c>||_||_||_||_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(leftrightrrs r. set_marginszWorksheet.set_margins@s) !#r2cZ|}|dd}t|dkrtddS|t|tsd|i}ni}|}|||d<g|_|drC|j|d|dd g|d rC|j|d |d d g|d rC|j|d |ddg| d}t|j}||kr!td|d|d|g|_dSd|vr |d|_ d|vr |d|_ ||_ |dd|_ d|_|r d|_dSdS)z Set the page header caption and optional margin. Args: header: Header string. margin: Header margin. options: Header options, mainly for images. Returns: Nothing. &[Picture]&Gr~zCHeader string cannot be longer than Excel's limit of 255 charactersNmargin image_leftimage_data_leftLH image_centerimage_data_centerCH image_rightimage_data_rightRHzNumber of header images (#) doesn't match placeholder count ( ) in string: align_with_marginsscale_with_docr]T)rrEr r7rrrrrr2rrrrrr)r(rrr header_origplaceholder_count image_counts r. set_headerzWorksheet.set_headerSt  d33 v;;   V W W W F  gt,, .#W-G,,..   &GH   ;;| $ $    % %\**GKK8I,J,JDQ    ;;~ & &    % %^,,gkk:M.N.NPTU    ;;} % %    % %]++W[[9K-L-LdS   #LL..$,--  + + D;; 1 1 1;;@    "$D  F 7 * *(/0D(ED % w & &(/0@(AD % $[[377%)"  '"&D    ' 'r2cZ|}|dd}t|dkrtddS|t|tsd|i}ni}|}|||d<g|_|drC|j|d|dd g|d rC|j|d |d d g|d rC|j|d |ddg| d}t|j}||kr!td|d|d|g|_dSd|vr |d|_ d|vr |d|_ ||_ |dd|_ d|_|r d|_dSdS)z Set the page footer caption and optional margin. Args: footer: Footer string. margin: Footer margin. options: Footer options, mainly for images. Returns: Nothing. rrr~zCFooter string cannot be longer than Excel's limit of 255 charactersNrrrLFrrCFrrRFzNumber of footer images (rrrrr]T)rrEr r7rrrrrr2rrrrrr)r(rrr footer_origrrs r. set_footerzWorksheet.set_footerrr2cr||}|dz }|dz }d||fz}t|j}|dz|z|_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:$%drg)r rgr)r(rjrlr9rxs r. repeat_rowszWorksheet.repeat_rowss\   H Q A Ix00$DI.. )C$ 6r2c||}t|d}t|d}|dz|z}t|j}|dz|z|_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 r5rg)rr rgr)r(rkrmr9rxs r.repeat_columnszWorksheet.repeat_columnssg   H#9a00 !(A..3)$DI.. )C$ 6r2c|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)rrr)r(options r.hide_gridlineszWorksheet.hide_gridlines"s` Q;;#$D $%D !)-D & & & q[[#$D $%D ! ! !#$D $%D ! ! !r2c"d|_d|_dS)z Set the option to print the row and column headers on the printed page. Args: None. Returns: Nothing. TN)rrrs r.print_row_col_headerszWorksheet.print_row_col_headers:s"%)"""r2cd|_dS)z Set the option to hide the row and column headers on the worksheet. Args: None. Returns: Nothing. TN)rrs r.hide_row_col_headerszWorksheet.hide_row_col_headersHs $r2c|dkr$|dkr||jdz kr||jdz krdS|||||}||_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)rrrsr8r)r(rjrkrlrmr9s r. print_areazWorksheet.print_areaUsg( NNQDOa///DOa/// F&&y)XxPP $qr2c"d|_d|_dS)z Set the order in which pages are printed. Args: None. Returns: Nothing. r TN)rrrs r. print_acrosszWorksheet.print_acrossvs"&r2c>d|_||_||_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)rrrr)r(rr(s r. fit_to_pageszWorksheet.fit_to_pagess'  "&r2c||_dS)z Set the start page number when printing. Args: start_page: Start page number. Returns: Nothing. N)r)r( start_pages r.set_start_pagezWorksheet.set_start_pages%r2c|dks|dkrtd|zdSd|_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&rr)r(scales r.set_print_scalezWorksheet.set_print_scalesS 2:: EM N N N F u::"&r2c"d|_d|_dS)z Set the option to print the worksheet in black and white. Args: None. Returns: Nothing. TN)rrrs r.print_black_and_whitezWorksheet.print_black_and_whites "&r2c||_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)rr(breakss r.set_h_pagebreakszWorksheet.set_h_pagebreaks r2c||_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)rrs r.set_v_pagebreakszWorksheet.set_v_pagebreaksrr2cZ| ||_dSdt|jdzz|_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 )rr1rh)r(rgs r. set_vba_namezWorksheet.set_vba_names9   $D    '#dj1n*=*= =D   r2c|dS|}hd}|D]}||vrtd|zdS||_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. NrB> eval_error formula_rangeformula_differsformula_unlockedcalculated_columntwo_digit_text_yearempty_cell_referencelist_data_validationnumber_stored_as_textz)Unknown parameter '%s' in ignore_errors()r)rrr r)r(rrrs r. ignore_errorszWorksheet.ignore_errorss ?2llnnG    !  I 000@9LMMMrr1&qr2c<|d|_|d|_|d|_|d|_|d|_|d|_|d|_|d|_|d |_|d |_ |d |_ |d |_ |d |_ |d|_ |d|_|d|_|d|_|d|_|j rFd|_d|_d|_d|_d|_d|_d|_d|_d|_d|_|jr]t9j|j\}}t=j|||_ tC|dd|_"|j"|_#dSdS)Nrgrhrir rkrlrrrrrrrrqrrrrg)@r\r ?F)dirzw+utf-8modeencoding)$rgrhrir rkrlrrrrrrrrqrrrrrrrrrrrrrrtempfilemkstemprcloseropenr r)r( init_datafdrs r. _initializezWorksheet._initialize!sf% w' ";/'(89():;) ";/"+,@"A#,-B#C ():;!*+>!?#,-B#C "+,@"A():;():;'(89$-.D$E!():;   .',D $&+D #&(D ##D  $D DO!"D !$D !$D (-D %   '&-$+>>>NR HRLLL%-D "#H4'JJJD &DGGG ' 'r2c&||||||||js|n| | | |j r| ||||||||||||||||||| d|!dS)N worksheet)"_xml_declaration_write_worksheet_write_sheet_pr_write_dimension_write_sheet_views_write_sheet_format_pr _write_colsrk_write_sheet_data_write_optimized_sheet_data_write_sheet_protection_write_protected_rangesrq_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_closers r._assemble_xml_filezWorksheet._assemble_xml_fileMs     !!! ##%%% # /  " " $ $ $ $  , , . . . $$&&& $$&&&   &  # # % % % !!! !!! ''))) $$&&&     !!###   """     !!###         ""$$$  ""$$$ %%'''  !!!  +&&& r2cR|dks|dkrdS||jks ||jkrdS|s|s|jr ||jkrdS|s2|j ||jkr||_|j ||jkr||_|s2|j ||jkr||_|j ||jkr||_dSrA)rrrsrkrrurvrwrx)r(r%rFrrs r.rDzWorksheet._check_dimensionss 77cAgg2 $/ ! !SDO%;%;2 * 1E T&&&r &&#*?*?"%&#*?*?"% &&#*?*?"%&#*?*?"%qr2c8t||j|jSN)rrr)r(dt_objs r.r}zWorksheet._convert_date_times)&$.$BVWWWr2cd}d}d}d}t|d} t|d} dt|dzz} dt|dzz} |dkr||jdz kr| }| }d}n%|dkr||jdz kr| }| }d}n | | z}| | z}||kr|s|}n|dz|z}t |j} | dz|z}|S)NrYrr rr5rg)rr1rrrsr rg)r( row_num_1 col_num_1 row_num_2 col_num_2range1range2r9 row_col_only col_char_1 col_char_2 row_char_1 row_char_2rxs r.r8zWorksheet._convert_name_areas $Iq11 #Iq11 3y1}--- 3y1}---  >>i4?Q+>>>FFLL !^^ T_q-@ @ @FFLL*,F*,F V  L DDC<&(D$DI.. 3% r2c|sdSt|}d|vr|dt|}|d}t ||kr |d|}|S)Nri)r7removerrrE)r(r breaks_set breaks_listmax_num_breakss r._sort_pagebreakszWorksheet._sort_pagebreakss  F[[ ??   a :&&  {  n , ,%o~o6Kr2c@|sgStjd}||}g}|D]k}|dr |dd}|dr |dd}|dd}||l|S)Nz"(?:[^"]|"")*"|\S+"r rBz"")rcompilefindallrrrr)r(rtoken_rer new_tokensr$s r.r@z Worksheet._extract_filter_tokenss I:344!!*--  % %E$$ "abb ~~c"" #crc MM$,,E   e $ $ $ $r2czt|dkr|d}tjd|rd}n.tjd|rd}ntd|d|d |||dd}|||d d}||gz|zS|||S) NrrZz(and|&&)rz (or|\|\|)r Token 'z3' is not a valid conditional in filter expression ''r?)rErrr _parse_filter_tokens)r(rr conditional expression_1 expression_2s r.rAz"Worksheet._parse_filter_expression9s v;;!  !)Kx K00  , 44  3>;; L  44Z!MML44Z!MML;-/,> >,,Z@@ @r2c ddddddddddddd }||dd}|d}tjd|d rt |d}|dks|d krt d ||fz|}|d kr|d krt d|d|d|d dkrd}nd}|dd kr|dz }t |}|s$|d rt d|d d|dtjd|rZ|dkr"|dkrt d|dd|d|}|dkr |dkrd}n|dkrd}d}nd}d}|dkrtjd|rd}||gS)Nrrr rZr?) rgrz=~eqrjz!~nerkrqrwrnrtz top|bottomriz?The value '%d' in expression '%s' must be in the range 1 to 500r%z The type 'z' in expression 'z' must be either 'items' or '%'rr}rpz0' is not a valid operator in filter expression 'rqzblanks|nonblankszThe operator 'z/' is not valid in relation to Blanks/NonBlanks'rr!z[*?])rrrr6r&r r1rc)r(rr operatorsoperatorr$r^s r.rrzWorksheet._parse_filter_tokensWsa    ==D11q  8L&)//"3"3 4 4 q NNEqyyECKK47 %d characters since it exceeds Excel's limit for URLS/image../media/image.)r_position_object_emusr&rrembeddedrrr1_add_drawing_objectrrrrrErr rrr_get_drawing_rel_index)r(rhimage_id drawing_idrr(rgrx_dpiy_dpir drawing_typer%rFrHrrrrrrrrrrrdrawing_objecttargetrel_type target_modes r._prepare_imagezWorksheet._prepare_images  K             ' $,// h%  C54<())SFTM*++| #iiG G "DL  ' . .2S__DvMtT    lG 4466!-v'1|$"'w#)x (,}%"&w#)x &'{#*+' #u'1|$  ",7N= ) % WF#H$Kx)3// /))#..x C(( /))#..x S)) 7["55))&11U338FF++7rxv/F/F7'&0FF#^^D#66Fx S)) #[#66" !v;;!444M 345  ,0055S*118V[2QRRR6:6Q6QRU6V6VN?3 $$V,,    % %+c(mm;cAJNO   '+&A&A&&I&I{###r2c d}|j|\ }}}}}} } } } } }| d|jdz}| d|jdz}||z}|| z}|||||||| }t d|dzz}t d|dzz}|jsMt}d|_||_|j dd t|zd zdgn|j}td d | }| |_ |}||d <||d<||d<||d<| |d<||d<| |d<d|d<d|d<| d|d<||d<| dd}|rcd}d}d}tjd|r||}tjd|r||}tjd|rA|dd}||}|dd}tjd |r|d d}d}|t'||jkrt+d!||jfzdS|j|s|j |||g|||d<dSdSdS)"NrZrr(rwr$rr rrrrectTextBoxr8rrrrrrrrrrrrrrrrrrrr)rrrrrr&rrrrrr1rrrrrrrrErr rrr)r(rhrrr%rFrrrrrrrrrrr(rrrrrrrrs r._prepare_shapezWorksheet._prepare_shape7s  K             GT%'BCC '// h%  C54<())SFTM*++| #iiG G "DL  ' . .2S__DvMtT    lGfi11  4466!-v'1|$"'w#)x (3}%"'w#)x &'{#*+' ' E 2 2u'1|$kk%&&  WF#H$Kx)3// /))#..x C(( /))#..x S)) 4[*==))&11U33x S)) #[#66" !v;;!444M 345  ,0055S*118V[2QRRR6:6Q6QRU6V6VN?333A W W*"!r2c 6tjdd|}|j| s2|jddt |zdz|zg|| } |j||||||| gdS)Nz\..*$rYrrr) rrsrrrrr1_get_vml_drawing_rel_indexr) r(rrr(rgrpositionrrrref_ids r._prepare_header_imagezWorksheet._prepare_header_images vhD))$((00   " ) )+c(mm;cAJNO   0088 && FD(E5& A     r2cj|jddt|zdz|zgdS)Nrrr)rrr1)r(rrs r._prepare_backgroundzWorksheet._prepare_backgroundsE &-- '#h--7#= J K     r2c d}|j|\ }}}}} } } } } }|dz |_td|j| zz}td|j| zz}||||| ||| }|j}|jsLt}d|_ ||_|j ddt|zdzgn|j}| }||d<||d<||d<||d <||d <d|d <| |d <||d <d|d<d|d<| |d<||d<|j ddt|zdzgdS)Nr r$rrrr8rrr(rgrrrrrrrrz/chartz../charts/chart)rr%r&rr(r chart_namerrrrrr1rrr)r(rhchart_idrrr%rFrrrrrrrrrr(rrgrrs r._prepare_chartzWorksheet._prepare_charts  K           a<C5;0122SEL72344// h%  | #iiG G "DL  ' . .2S__DvMN    lG 4466!-v'1|$"'w#)x !%v"&w#)x &*&A&A&C&C{#*+' $u(3}%'1|$ !! (3x==86A B     r2c b||||||||\ }}}}}} } } } } tdd|zz}tdd|zz}tdd| zz} tdd| zz} tdd| zz} tdd| zz} |||||| | | | | f S)Nr$r)_position_object_pixelsr&)r( col_start row_startx1y1rr(rcol_endrow_endx2y2x_absy_abss r.rzWorksheet._position_object_emuss(  ( ( y"b%             tby ! ! tby ! ! tby ! ! tby ! !C$,&''C$,&''9b"gwBuUUr2c Jd}d} |dkr2|dkr,|||dz z }|dz}|dkr|dk,|dkr2|dkr,|||dz z }|dz}|dkr|dk,|dkrd}|dkrd}|jr+t|D]} ||| z }n ||j|zz }||z }|jr+t|D]} | || z } n | |j|zz } | |z } ||||kr7|||z}|dz }||||k7||||kr7|||z}|dz }||||k7|} |} |||dkr||z}|||dkr||z}||| |kr8||| |z}| dz } ||| |k8||| |kr8||| |z}| dz } ||| |k8|}|}||||| | |||| g Sr%) _size_col _size_rowrrwrrr)r(rrrrrr(rrrr>row_idrrrrs r.rz!Worksheet._position_object_pixels/sK(1ffQ $..Q// /B NI1ffQ 1ffQ $..Q// /B NI1ffQ 66B 66B   9 ** 0 0/// 0 T,y8 8E     9 ** 0 0/// 0 T,y8 8E  DNN9f5555 $..++ +B NIDNN9f5555 DNN9f5555 $..++ +B NIDNN9f5555  >>)V , ,q 0 0BJE >>)V , ,q 0 0b[Ft~~gv6666 T^^GV44 4E qLGt~~gv6666 w7777 dnnWf55 5F qLGw7777  9b"gwBuUUr2cd}d}d}||jvrr|j|d}|j|d}||j}|r |dkrd}n?|dkrt|||zzdz}n t||zdz|z}n|j}|S)Nrrrrr?r r$)ryrr&r)r(rFrmax_digit_widthpaddingpixelsrr{s r.rzWorksheet._size_cols  $-  M#&q)E]3'*F}. F&A++Uo&?@3FGGU_4s:;;gE,F r2cd}||jvrD|j|d}|j|d}|r |dkrd}n*td|z}ntd|jz}|S)Nrr r?gUUUUUU?)rr&r)r(r%rrr(r{s r.rzWorksheet._size_rows  $. ^C(+F^C(+F 1&A++Y/00T%<<==F r2c<d}d}|dkr |||zz }n||z |z }|S)Ng@g@ rD)r(rrrrs r.r zWorksheet._pixels_to_widths: R<<o78EEg%8E r2c d|zS)Nr\rD)r(rs r.r,zWorksheet._pixels_to_heights f}r2c d}d}d}dddddd||dddddddd }|D] } || || <|d s||d <|d s||d <t|d |d <|d d dd|d <|d"t |d\} } | |d<| |d<|j} |j} |dJ|dkrd|d<n>|| dz kr | dz |d<n,|| dz kr | dz |d<n|| dz kr | dz |d<n|dz |d<|d>|dkrd|d<n2|| dz krd|d<n#|| dz krd|d<n|| dz krd|d<nd|d<|d>|| dz kr | dz |d<n,|| dz kr | dz |d<n|| dz kr | dz |d<n|dz|d<|d2|| dz krd|d<n#|| dz krd|d<n|| dz krd|d<nd|d<|dr|d |dz|d <|dr|d |dz|d <td |d z|d <td |d z|d <||d|d|d|d|d |d |}| |d | |d ||||d!|d"|d |d#|d$|d%g |gzS)&NJrz#ffffe1r Tahomar)rrr start_col start_rowrrr(rrrr font_name font_size font_familyrr(rffrrrrrZrrwrrrrrr?r1r_rrr$rrrrr) rrr6rrrrrsr&rr)r(r%rFr=r default_widthdefault_heightrparamsrrrrow_maxcol_maxverticess r._comment_paramszWorksheet._comment_paramssn "$!  (<<>> ' 'C!#,F3KKg ,+F7Oh .-F8 #6'?3399;;w!/11$Q??w ,  +%6vl7K%L%L "Y "+F; "+F;  // +  &axx&'{##! ##&-k{##! ##&-k{##! ##&-k{##&)Ag{# *  %axx%&z""! ##%'z""! ##%'z""! ##%'z""%'z" +  &gk!!&-k{##! ##&-k{##! ##&-k{##&)Ag{# *  %gk!!%'z""! ##%'z""! ##%'z""%'z" )  B$Woy0AAF7O )  D%h/&2CCF8 cF7O344wsVH%5566x// ;  ;  :  :  7O 8     w(((x()))    8  9  7O ;  ;  = !  J  r2c B|j}|j}d}dt|jz}||id}i} |D] } || | | <| d} | d|z} | |dd<| drd| dz|d<nd |z|d<| d |d <| d || d <| d || d <| d d| d <| dd| d<| d | ddz| d <| d | ddz| d <t d| d z| d <t d| d z| d <|| d<|| d<|| d| d| d | d| d | d |} | | d | | d | |d<|S)Nrr )r%rFfontcaptionz Button %drmacroz[0]!z[0]!Button%d_Clickrrr(rrrrr$rrr) rrrErrrr&rr) r(r%rFrrrr button_numberrrrrrs r.rzWorksheet._button_params[sg0/ C 1222 S"55<<>> ' 'C!#,F3KK**Y'' ?!M1G$+vy! ::g   C$vg6F7OO2]BF7O!' = 9 9}!**Wm<<w!::h??x$ZZ A66z#ZZ A66z!/FJJy!,D,DDw!(+fjjA.F.FFxcF7O344wsVH%5566x!{!{// ;  ;  :  :  7O 8     w(((x()))%z r2cg}t|j}|D]}t|j|}|D]} |j|| } |j| } | |j|| <|jr/|j|| dd|j|| d<|j|| d|j|j|| d<||j|| |jddt|zdzg|j r6||_ |j ddt|zd zgt|} |} tt| d z D]}d || |zdzfz}||_||_| S) Nr?r rZ /vmlDrawing../drawings/vmlDrawing.vmlz /commentsz ../commentsrrdz%s,%d)rrrrrrrrr1rrrrErwr&r r)r(r rvml_drawing_id comment_idrrow_numsr%col_numsrF user_optionsrr2 start_data_idrFs r._prepare_vml_objectszWorksheet._prepare_vml_objectss$-,,..// 9 9CdmC0557788H 9 9#}S1#6 --|<*0 c"3'(7}S)#.q1956 c*3/2=%c*1-5151EDM#&s+A. c 23 78888 9 && 4s>7J7JJVS T      !)D   ' . .mc*oo=FG   H # s54<(()) I IA![-!2Ca2G$HHKK&( r2cr||_|jddt|zdzgdS)Nrrr)rrrr1)r(rrs r._prepare_header_vml_objectsz%Worksheet._prepare_header_vml_objectssL+ && 4s>7J7JJVS T     r2cV|jD]}||d<|ddt|z|d<|d}||vrt d|dzd||<|jddt|zdzg|d z }dS) Nr%rgTablez2Duplicate name '%s' used in worksheet.add_table().Tz/tablez../tables/tablerr )rrr1r6r!rr)r(table_idseenrrgs r._prepare_tableszWorksheet._prepare_tabless[  E"E$Kyy  ( '#h-- 7f =&&((Dt||(H5QW=X"T   % , ,,s8}}.Vs1TTTd*T3"7"7ATTTTTr2,)join)r(rs r.rzWorksheet._csv_joinRs(UTeTTTxxr2ctjd|r|S|dd}|dd}|dd}|dd }|d d }|d d }|dd}|dd}|dd}|dd}|dd}|S)Nz%[0-9a-fA-F]{2}rzz%25rjz%22r!z%20rqz%3crnz%3erz%5brz%5d^z%5e`z%60raz%7brz%7d)rrcr)r(rs r.rzWorksheet._escape_urlZs 9& , , Jkk#u%%kk#u%%kk#u%%kk#u%%kk#u%%kk#u%%kk#u%%kk#u%%kk#u%%kk#u%%kk#u%% r2c||xjdz c_|jS|j|r |j|S|xjdz c_|j|j|<|jSNr )rrrr(rs r.rz Worksheet._get_drawing_rel_indexnsx >  A % ' '   " "6 * * ($V, ,  A % (,( +  % %c * * *   +  % %c * * *  # 0  % %h / / /  ! 1  % %i 0 0 0   0  % %h / / /   7  ! !)"5 6 6 6  A % %  " "= 1 1 1  A % %  " "; / / / !!$%1D)E(FGGG ?b  _ 2   gy 7 7 7 7  $ 2   i)@ A A A A  ! 2++I,@AAE  % %eU 3 3 3 3  % %gq 1 1 1 !!'UI4G,H+IJJJ!!(eY5J-K,LMMM  ) + +I4G +  % %h%9N1O0P Q Q Q&&&&&r2czg}|dkrdg}n|dkrdg}n |dkrdg}|jd|dS)Nr)rdouble!)rsingleAccounting")rdoubleAccountingurr%)r(r*rs r.r+zWorksheet._write_underlines^  >>+,JJ "__56JJ "__56J ##C44444r2cFd|fg}|jd|dS)Nr vertAlignr>r(rrs r.r-zWorksheet._write_vert_aligns+cl^  ##K<<<<r(rgr^rs r.r2zWorksheet._write_rstring_colors+Um_  ##GZ88888r2c\|ddkr |dd}d|zS)Nrrr FF)upperrs r.r1zWorksheet._get_palette_colors/ 8s??!""IEekkmm##r2cX|js"|jd|_dSdS)NT)r r r,rs r. _opt_closezWorksheet._opt_closes:& +   " " $ $ $&*D # # # + +r2cz|jr3|j}t|dd|_d|_|j|_dSdS)Nza+r&r'F)r rr-r r)r(rs r. _opt_reopenzWorksheet._opt_reopensL  " '-H#H4'JJJD &+D #&DGGG  ' 'r2cg}t|D]}|dddd|dkrd|dd<d|d d<|d kr!d |dd<d |d d<d |dd<|dkr,d|dd<d|d d<d|dd<d|dd<|rdt|}||kr|d z }t|D]9}||dm||d||d<||d}t |t r3|dr|d||d<||dred}||d|vrtd||dzn4||d||d<||ddkr d||d<||d} | r| dkr d||d<;|S)NFrpercent)rCr^r8rZCr^r9r r?KrrrP<(r`rr8)rMrrMr]zOUnknown icon property type '%s' for sub-property 'type' in conditional_format()rMnumrCrnT) rwrrErr7r1rr r ) r(r user_propspropsrHmax_datarFtmprrCs r.rzWorksheet._set_icon_propssw{## M MA LLeaKK L L L L !   "E!HW  "E!HW  !   "E!HW  "E!HW  "E!HW  !   "E!HW  "E!HW  "E!HW  "E!HW  # 0:H;&&&?8__ 0 0a=$$W--9(21 g(>E!HW% (7+C!#s++<s0C0C<,/JJsOOa)a=$$V,, 5"PK!!}V,K??F(mF34 ,6a=+@a( 8F+x77/4E!HV,&a=,,Z880C+/E!HZ( r2cd}|dz}|dz}|dz}d}|dz}d|fd|fg}|jd krC|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:Ignorablex14acr2)rprr)r(schemarZxmlns_rxmlns_mc ms_schema xmlns_x14acrs r.r4zWorksheet._write_worksheet4s622>>773 "BB &G(<=    % %   z84 5 5 5   }k: ; ; ;   7 8 8 8 K44444r2c|j |jd}n|j`|jY|j|jkrtd|j}ntd|j}td|j}|dz|z}nw|j|jkr+|j|jkrt|j|j}nCC _ $)D $/11'4?;;+1do>>*1do>>slV+ _ / /DOt4V4V#DOT_EECC'tHHF&tHHF3,'C K5#,88888r2c|d||ddS)N sheetViews)r_write_sheet_viewrrs r.r7zWorksheet._write_sheet_viewsksD L)))     ,'''''r2cg}|js|d|jr|d|js|d|jr|d|jr|d|js|d|jdkr|dn |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 st|j rU|d||||ddS|d|dS)N) showGridLinesr)showRowColHeadersr) showZerosr rightToLeftr ) tabSelectedr showOutlineSymbolsrr )r pageLayoutr)rpageBreakPreviewrY topLeftCellr^ zoomScalerzoomScaleNormalzoomScalePageLayoutViewzoomScaleSheetLayoutView)workbookViewIdr sheetView)rrrrrrrrr~rrrrErzr _write_panes_write_selectionsrr%r(rs r.rezWorksheet._write_sheet_viewts $ 4   2 3 3 3   8   6 7 7 7 0   . / / /   2   0 1 1 1 = 2   0 1 1 1 9   7 8 8 8 >Q     4 5 5 5 5 ^q   : ; ; ;   # #   }d.@A B B B 9     {DI6 7 7 7~""t'="!!#4di"@AAA~""!!#?  "d&> > >   1 2 2 2  " 1   / 0 0 0  >   0)< = = =  >   0)< = = =   % %   9 : : : OZ88888r2c|jsdS|dt|jd}|}|j|}|j|=|}|}t|jD]>}|j|}||dzkr ||kr|}!|||||}|}|}?||||||j|<|ddS)Ncolsrr )ryrrr_write_col_infor)r(rkrmprev_col_options deleted_coldeleted_col_optionsrF col_optionss r.r9zWorksheet._write_colss5}  F F###DM..001115 =3 M) $ .$-,,..// / /C-,Khl""{6F'F'F$$Y:JKKK $#.   Y2BCCC&9 k" &!!!!!r2c|\}}}}}} d} d} |r|} | |sd}d} n d}n|dkrd} |dkrd} d} |dkrr{rrr& custom_widthxf_indexrrrs r.rzWorksheet._write_col_infos'BJ? VUIw   3"0022H =   d]]L 199OGqyyUo&?@3FGG001   U_4s:;;gE001   GaK GaK go &  3   w1 2 2 2  /   o . . .  0   . / / /  4   2 3 3 3  7   ~u5 6 6 6  2   0 1 1 1 E:.....r2c|j|ddS|d||ddS)N sheetData)rur%r _write_rowsrrs r.r:zWorksheet._write_sheet_data3sd ? "    , , , , ,    , , ,         k * * * * *r2c|j|ddS|dd}|jd|j|}|r6|j||j|}|6|jtj |j | ddS)Nrir) rur%rr seekreadrr,r,runlinkrr)r( buff_sizers r.r;z%Worksheet._write_optimized_sheet_data=s ? "    , , , , ,    , , ,I   ! !! $ $ $#((33D 8 d###',,Y77 8   " " $ $ $ Id, - - -   k * * * * *r2cd|jfd|jfd|jfd|jfd|jfd|jfg}|d|dS)Nrrrrrr pageMargins)rrrrrrr%rzs r.rEzWorksheet._write_page_marginsUsjT% & d' ( DO $ t) * t) * t) *   M:66666r2cg}|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 rG|j r|d|j f|j r|d|j fnF|j r|d|j f|j r|d|j f|d|dS)N paperSizer^r r fitToWidth fitToHeight) pageOrder overThenDownfirstPageNumber)rportrait)r landscape) blackAndWhiterCr)useFirstPageNumberrC horizontalDpi verticalDpi pageSetup)rrrrrrrrrrrrmrr r%rzs r.rFzWorksheet._write_page_setupbsj& &  F ? >   {DO< = = =  s " "   w(89 : : : = >T^q00   |T^< = = = = @T_11   }do> ? ? ? ? =   ; < < < ?Q     0$/B C C C   <   9 : : : :   : ; ; ;   6   4 5 5 5 ?a     9 : : :   J" J!!?D4G"HIII  F!!=$2C"DEEE  F!!=$2C"DEEE" J!!?D4G"HIII K44444r2c(g}|jsdS|jr|d|jr|d|jr|d|jr|d|d|dS)N)horizontalCenteredr )verticalCenteredr )headingsr ) gridLinesr printOptions)rrrrrrr%rzs r.rDzWorksheet._write_print_optionss )  F < 9   7 8 8 8 < 7   5 6 6 6   /   o . . .   0   . / / / NJ77777r2cg}|js|d|js|d|jrc|d||jr||jr|| ddS|j r| d|dSdS)N) scaleWithDocr)alignWithMarginsr headerFooter) rrrrrr_write_odd_headerr_write_odd_footerrrqr%rzs r.rGzWorksheet._write_header_footers ( 3   1 2 2 2( 7   5 6 6 6  % <    ; ; ;{ )&&((({ )&&(((   n - - - - -  ! <    ; ; ; ; ; < *5DDD:g&Qdm336666t}W7MNNN#($/A:M#N#NHH"dj&999&*j&9'&BG ,,WgwGGG%%e,,,, --))'4w9OPPPP))'4w9OPPPE" Q" Qr2cV|j}||_||jvs||jvs |j|rd}|j|r||jvr|||n"||||j|t |j|jdzD];}||j|vr*|j||}||||<| dn"| |||j||j dS)Nr r%) rrrrrrwrwrxrrrclear)r(current_row_numrrprrs r.rGzWorksheet._write_single_row sE#+ dm # #w$-'?'?4:gCV'?Dz'" M$-//OOGT2222OOGT4=3IJJJ$T_do6IJJDDG$*W"555"&*W"5g">(('7CCC!!%((((%%gtT]75KLLL r2c0i}d}d}t|j|jdzD]}||jvrFt|j|jdzD](}||j|vr||}|}||kr|}||kr|})||jvrOt|j|jdzD]1}||jvr&||j|vr||}|}!||kr|}||kr|}2|dzdzdks ||jkr*t|dz }||dz }|dz }|d|||<d}||_dS)Nr rrr5) rwrurvrrwrxrr&r)r(spansspan_minspan_maxrrrs r.rzWorksheet._calculate_spans2s T_do.ABB" $" $G$*$$$T_do6IJJ 3 3G$*W"555#+'.H'.HH&11+2&11+2$-''$T_do6IJJ 3 3G$-//Gt}W?U4U4U#+'.H'.HH&11+2&11+21"a''Gt,F,F 2.. 'MHMH3;88XX(FE*%#Hr2cd}|r |\}}}} } nd\}}}} } ||j}d|dzfg} |r|}|r| d|f|r| d|f|r| d||jkr| dd |zf|r| d ||jkr| d | r| d | f| r| d |jdkr| d|r|d| dS|d| dS)Nr)NNrrrrr rs) customFormatr htz%g)r{r r}r)rr rrr%)rrrrrp_xml_empty_tag_unencoded_xml_start_tag_unencoded) r(r%r properties empty_rowrr(r>r{rrrs r.rzWorksheet._write_rowas  P,FC!Gn%   3"0022H  0   w. / / /  /   sHo . . .  3   1 2 2 2 T- - -   tTF]3 4 4 4  -   m , , , T- - -   1 2 2 2  7   ~u5 6 6 6  0   . / / /   % %   9 : : :  =  ) )% < < < < <  ) )% < < < < |j|d}|)|d|f|jj} | dvr||j |dS| dvr|j } |j s| | |dS| | } | dr-| dr|| |dSt#| } || | |dS| dkr|j} t)|jt*r"|d |jrd} n_d } n\t)|jt,rBd } |jd krn4|j| vr|d n|d||j| |dS| dkr|jdkr|d t5|jn%#t6$r|dYnwxYw|d|||j|j||j| ddS| dkr|!d|dS| dkr\|d |d|||j"| ddS| dkrx|d |d|jf|d|||j#| ddSdS)Nrrr rrzzrP)rrr)rQz#N/Az#NAME?z#NULL!rPz#REF!rrY)re)rr1rRrp)cmr crMrOrTvm)$rrNrrrryrr_xml_number_elementrMr=rk_xml_string_element_escape_control_charactersrr_xml_rich_inline_stringr_xml_inline_stringr^r7r/r1_xml_formula_elementr]rxr!r'r_write_cell_array_formularw_write_cell_valuerr%rrq)r(r%rFrryrrrow_xfcol_xftype_cell_namer=rr^ error_codess r.rzWorksheet._write_cells,C55 J'( ; A{0022H   sHo . . . . DM ! !dmC&8&; !]3'*F   sF$8$8$:$:; < < < < DM ! !]3'*F!!!3(<(<(>(>"?@@@0 3 3 3  $ $T[* = = = = = 7 7 7[F' J((<<<<< 88@@$$U++J0G0GJ00DDDDD 36::H++FHjIIIII y ( (JE$*d++ 4!!*---:EEEEDJ,, 4 :##Z;..%%j1111%%l333  % %dlE: F F F F F ~ - -zY&&!!),,, 0dj!!!! 0 0 0!!,///// 0   Z 0 0 0  * *4< D D D  " "4: . . .   c " " " " " w & &   Z 0 0 0 0 0 y ( (   j ) ) )   Z 0 0 0  " "4< 0 0 0   c " " " " " w & &   j ) ) )   tTZ0 1 1 1   Z 0 0 0  " "4: . . .   c " " " " " ' &s.KK%$K%c:|d}|d|dS)NrYvr)r(r^s r.rzWorksheet._write_cell_values( =E sE*****r2c@dd|fg}|d||dS)N)rarrayr:r&r)r(r]ryrs r.rz#Worksheet._write_cell_array_formulas/$uj&9:  sGZ88888r2cg}|js|js|js|js |jsdS|jr|d|jf|jr|d|js|js|jri|d|||| | ddS| d|dS)NcodeName) filterModer sheetPr) rrr}rrrr_write_tab_color_write_outline_pr_write_page_set_up_prrr%rzs r.r5zWorksheet._write_sheet_prs/   N N (   %   F   ?   z4+<= > > > > 1   / 0 0 0 = 7DN 7d.B 7    : 6 6 6  ! ! # # #  " " $ $ $  & & ( ( (   i ( ( ( ( (    : 6 6 6 6 6r2cJ|jsdSdg}|d|dS)N) fitToPager pageSetUpPr)rr%rzs r.rzWorksheet._write_page_set_up_pr7s5}  F&'  M:66666r2cR|j}|sdSd|fg}|d|dS)NrtabColor)r}r%)r(rrs r.rzWorksheet._write_tab_color?s>  Fen%  J 33333r2c(g}|jsdS|jr|d|js|d|js|d|js|d|d|dS)N) applyStylesr ) summaryBelowr) summaryRightrrm outlinePr)rrrrrrr%rzs r.rzWorksheet._write_outline_prJs #  F   2   0 1 1 1! 3   1 2 2 2! 3   1 2 2 2 9   7 8 8 8 K44444r2c||j}|sdSt|}d|fd|fg}|d||D]}||d|ddS)Nr2manualBreakCount rowBreaksi?)rhrrEr _write_brkr)r( page_breaksr2rrs r.rHzWorksheet._write_row_breaks\s++DL99   FK  e   ' K444" , ,G OOGU + + + + +&&&&&r2c||j}|sdSt|}d|fd|fg}|d||D]}||d|ddS)Nr2r colBreaksi)rhrrErrr)r(rr2rrs r.rIzWorksheet._write_col_breaksqs++DL99   FK  e   ' K444" . .G OOGW - - - - +&&&&&r2cDd|fd|fdg}|d|dS)Nr%r)manr brkr%)r(brk_idbrk_maxrs r.rzWorksheet._write_brks3Vnug&6 C  E:.....r2c|j}t|}|sdSd|fg}|d||D]}|||ddS)Nr2 mergeCells)rrEr_write_merge_cellr)r(rr2r merged_ranges r.r@zWorksheet._write_merge_cellssz L!!  F&'  L*555( 1 1L  " "< 0 0 0 0 ,'''''r2c|\}}}}t||}t||}|dz|z}d|fg} |d| dS)Nr5r: mergeCell)rr%) r(r row_minrrrr9r:r:rs r.r zWorksheet._write_merge_cellse/;,'7G#7G44"7G44slV#cl^  K44444r2c g}d}t|j}|sdS|D]7}t|j|}|D]}|j||}|d}|jrK|j|r>|j||r+|j||} | jjdkr|d}|dkra|xjdz c_|||||j|d||dg|jd|ddg|||||d|d|dg9| d |D]8} | d }|dkr |j | (|d kr |j | 9| d dS) NrrKrr r1rrrrrr)rrrrrrrrrrr_write_hyperlink_external_write_hyperlink_internalr) r(rdisplayrrrrlinkrrr)s r.rCzWorksheet._write_hyperlinkss@ $/..0011  F 0 0 Gdog6;;==>>H$+ + w/8 - :.$*W"5.$*W:Mg:V.:g.w7D~.(::"&u+>>NNa'NN%%%## N K# K   -44%tE{J? %%%## K K K     E+ \ L))) 6 6D IA~~..555a..55 ,'''''r2ct||}dt|z}d|fd|fg} || d|f|| d|f|| d|f|d| dS)NrIdr:r:idrQrtooltipr3)rr1rr%) r(r%rFid_numrQrrr:r_idrs r.rz#Worksheet._write_hyperlink_externals S))s6{{"clVTN3     z84 5 5 5     y'2 3 3 3     y'2 3 3 3 K44444r2ct||}d|fd|fg}||d|f|d|f|d|dS)Nr:rQrrr3)rrr%)r(r%rFrQrrr:rs r.rz#Worksheet._write_hyperlink_internal sz S))clZ$:;     y'2 3 3 39g./// K44444r2c|jsdSd|jfg}|jrA|d|||ddS|d|dS)Nr: autoFilter)rrr_write_autofiltersrr%rzs r.r?zWorksheet._write_auto_filters"  Fd123 > :    j 9 9 9  # # % % %   l + + + + +    j 9 9 9 9 9r2c|j\}}t||dzD]@}||jvr |j|}|j|}|||z ||AdSr)rrwrr_write_filter_column)r(col1col2rFrrs r.rzWorksheet._write_autofilters*s( ttax(( G GC$***%c*F*3/K  % %cDj+v F F F F G Gr2cd|fg}|d||dkr||n|||ddS)NcolId filterColumnr )r_write_filters_write_custom_filtersr)r(r>rrJrs r.r zWorksheet._write_filter_column;sw'(  NJ777 !      ( ( ( (  & &w / / / .)))))r2cd|D}g}t|t|krdg}t|dkr+t|dkr|d|dS|d|t|D]}|||ddS)Nc\g|])}t|dk'|*S)r)r1r6)rEfilters r.rGz,Worksheet._write_filters..Ls4VVVc&kk6G6G6I6IX6U6Uf6U6U6Ur2)rWr r rrJ)rEr%rr _write_filterr)r(rJ non_blanksrr;s r.r&zWorksheet._write_filtersJsVV7VVV  w<<3z?? * *&J w<<1  ZA!5!5    : 6 6 6 6 6    : 6 6 6$Z00 / / "":....   i ( ( ( ( (r2c<d|fg}|d|dS)Nrr*rrAs r.r+zWorksheet._write_filter^s)cl^  Hj11111r2ct|dkr6|d|j||ddSg}|ddkrdg}ndg}|d|||d|d||d|d|ddS) Nr customFiltersr)andr )r0rr rZr?)rEr_write_custom_filterr)r(rrs r.r'zWorksheet._write_custom_filtersds v;;!      0 0 0 %D %v . .   o . . . . .JayA~~(\ (\     < < <  % %fQi ; ; ;  % %fQi ; ; ;   o . . . . .r2cg}dddddddd}|| ||}ntd|z|dkr|d |f|d |f|d |dS) Nrprfrvrmrirs)r rrZr?rrwr|zUnknown operator = %sr~r customFilter)r rr%)r(r~rrr}s r.r1zWorksheet._write_custom_filter{s  #   X  * *HH (83 4 4 4 w     z84 5 5 55#,''' NJ77777r2czg}|jsdS|j}|dr|d|df|dr|d|dr|d|ds|d|ds|d |d r|d |d r|d |dr|d|dr|d|dr|d|dr|d|dr|d|dr|d|ds|d|dr|d|dr|d|d r|d!|d"s|d#|d$|dS)%Nrr)rr r)rr r)rr r)rr r) formatCellsrr) formatColumnsrr) formatRowsrr) insertColumnsrr) insertRowsrr)insertHyperlinksrr) deleteColumnsrr) deleteRowsrr)selectLockedCellsr r)rrr;)rrr) pivotTablesrr)selectUnlockedCellsr sheetProtection)rrr%)r(rrs r.r<z!Worksheet._write_sheet_protections #  F& :  A   z7:+>? @ @ @ 7  ,   l + + + 9  .   n - - -y! .   n - - -{# 0   . / / / > " 2   0 1 1 1 # $ 4   2 3 3 3 = ! 1   / 0 0 0 # $ 4   2 3 3 3 = ! 1   / 0 0 0 & ' 7   5 6 6 6 # $ 4   2 3 3 3 = ! 1   / 0 0 0,- 8   6 7 7 7 6? +   k * * * <  1   / 0 0 0 > " 2   0 1 1 1./ :   8 9 9 9 -z:::::r2c|jdkrdS|d|jD]\}}}|||||ddS)NrprotectedRanges)rrr_write_protected_rangerrs r.r=z!Worksheet._write_protected_rangess{  $ ) ) F -...040E J J ,J H  ' ' J I I I I +,,,,,r2cg}|r|d|f|d|f|d|f|d|dS)NrrrgprotectedRangerr%)r(ryrrrs r.rCz Worksheet._write_protected_rangesw  6   z84 5 5 57J/0006:./// ,j99999r2cl|jsdS|xjdz c_||jdSr)rr_write_drawingrs r.rKzWorksheet._write_drawingss=|  F ! DN+++++r2c`dt|z}d|fg}|d|dS)Nrrrr1r%)r(rrrs r.rHzWorksheet._write_drawings:s:&tn%  Iz22222r2c|jsdS|xjdz c_dt|jz}d|fg}|d|dS)Nr rr legacyDrawing)rrr1r%r(rrs r.rLzWorksheet._write_legacy_drawings_|  F !s4>***tn%  OZ88888r2c|jsdS|xjdz c_dt|jz}d|fg}|d|dS)Nr rrlegacyDrawingHF)rrr1r%rMs r.rMz"Worksheet._write_legacy_drawing_hfsa"  F !s4>***tn%  -z:::::r2c|jsdS|xjdz c_dt|jz}d|fg}|d|dS)Nr rrpicture)rrr1r%rMs r.rNzWorksheet._write_pictures`$  F !s4>***tn%  Iz22222r2c|j}t|}|sdSd|fg}|d||D]}|||ddS)Nr2dataValidations)rrEr_write_data_validationr)r(rr2r validations r.rBz!Worksheet._write_data_validationss& K    F&'  -z:::% 4 4J  ' ' 3 3 3 3 +,,,,,r2c<d}g}|dD]=}|dkr|dz }|\}}}}||kr||}}||kr||}}|t||||z }>|dr|d}|ddkrF|d|df|dd kr|d |dfd |vrB|d d kr|d |d dkr|d|dr|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#||d#|d!dS)$NrYrr!rVrPr[r8rCrbr~rQr ) errorStyleryr)rWrzrX) allowBlankr rO) showDropDownr rS)showInputMessager rR)showErrorMessager rT errorTitlerYrqrU promptTitlerZpromptrdataValidationr^rM)rrrr%r_write_formula_1_write_formula_2r) r(rrrr row_firstrErow_lastrFs r.rTz Worksheet._write_data_validation's< W% H HE{{ 9> 6Y 8X8##)19H8##)19H XiHhGG GEE ;;} % % +M*E : & ( (   vwz':; < < <z"i//!!:wz/B"CDDD 7 " "|$))!!";<<<|$))!!"?@@@ > " 1   / 0 0 0z" 3   1 2 2 2 <  7   5 6 6 6 <  7   5 6 6 6 G # #   |W]-CD E E E g % %   w(@A B B B G # #   }gm.DE F F F g % %   x)AB C C C7E*+++ : & ( (    0* = = = = =    0* = = =  ! !''"2 3 3 3y!-%%gi&8999   . / / / / /r2ct|tr|j|}d|z}nK t|n:#t$r-|dr|d}YnwxYw|d|dS)Nz"%s"rformula1)r7rrr!r'rr rr(r]s r.r`zWorksheet._write_formula_1ts gt $ $ 2$dng.Gw&GG 2g 2 2 2%%c**2%nnS11G 2 z733333s74A.-A.c t|n:#t$r-|dr|d}YnwxYw|d|dS)Nrformula2r!r'rr rrfs r.razWorksheet._write_formula_2sv . 'NNNN . . .!!#&& .!..-- . z7333334A A ct|j}|sdS|D]#}|||j|$dSrU)rrr_write_conditional_formatting)r(rf cond_ranges r.rAz$Worksheet._write_conditional_formatssn)..0011  F   J  . .D-j9      r2cd|fg}|d||D]}|||ddS)NrconditionalFormatting)r_write_cf_ruler)r(rmrrparams r.rlz'Worksheet._write_conditional_formattingsg +,  3Z@@@ ' 'E    & & & & 122222r2c d|dfg}d|vr%|d|d|df|d|df|dr|d|ddkr|d|d f|d |d |vr;d |vr7||d ||d n||d |d dS|ddkrt jd|d r|dt jd|d r|dt jd|d rEt jd|d }|d|df|d |dS|ddkrwd |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&kre|d&|d f|d |||d%|d dS|dd'ks$|dd(ks|dd)ks |dd*krH|d |||d%|d dS|dd+krB|d || ||d dS|dd,krl|d || ||d-r| ||d dS|dd.krH|d |||d |d dS|dd/krB|d || ||d dSdS)0Nr8rNdxfIdrr) stopIfTruer rr~rCcfRulerNrMr^rbelow)rrrf) equalAverager z [123] std devz([123]) std devr0r rrz)rMr r)rr rrankrrrrrrrr]rrrrrrrrrr) rrr_write_formula_elementrrrcgroupr%_write_color_scale_write_data_bar_write_data_bar_ext_write_icon_set)r(rrrrxs r.rpzWorksheet._write_cf_rulesavf~./ v  &"2">   wx(89 : : ::vj'9:;;; ::n % % 1   / 0 0 0 &>X % %   z6*+=> ? ? ?   * 5 5 5F""yF':':++F9,=>>>++F9,=>>>>++F7O<<<   h ' ' ' ' ' F^~ - -y&"455 7!!"5666y&"455 7!!"5666y&*<== > "3VJ5GHH!!8U[[^^"<===   * 5 5 5 5 5 F^w & &V##z(:c(A(A!!.111f$$!!-000'?(bD   vtn - - -   * 5 5 5 5 5 F^0 0 0   * 5 5 5 5 5 F^~ - -   * 5 5 5 5 5 6Nn , ,f~!222f~--f~++   z6*+=> ? ? ?   vvg7 8 8 8   * 5 5 5  ' 'y(9 : : :   h ' ' ' ' ' F^| + +   |VJ-?@ A A A   * 5 5 5  ' 'y(9 : : :   h ' ' ' ' ' 6N. . .f~!444f~!111f~!444   * 5 5 5  ' 'y(9 : : :   h ' ' ' ' ' F^| + +   * 5 5 5  # #F + + +   h ' ' ' ' ' F^y ( (   * 5 5 5   ( ( (zz,-- 1((000   h ' ' ' ' ' F^| + +   * 5 5 5  ' 'z(: ; ; ;   h ' ' ' ' ' F^y ( (   * 5 5 5   ( ( (   h ' ' ' ' ') (r2c t|n:#t$r-|dr|d}YnwxYw|d|dS)Nrr]rirfs r.ryz Worksheet._write_formula_elementsv . 'NNNN . . .!!#&& .!..-- . y'22222rjc|d||d|d|d"||d|d||d|d|d|d |d |d|d |d|d |ddS) Nrrrrrrrrrrr)r _write_cfvor.r)r(rqs r.r{zWorksheet._write_color_scale s L))) z*E+,>???   (   U:.k0B C C C z*E+,>??? %{!3444   )   eU;%7 8 8 8 %{!3444 ,'''''r2c<g}|dr|d|df|dr|d|df|dr|d|d|||d|d ||d |d |d |d |ddS)Nr minLengthr maxLengthr showValuerrrrrrrr)rrrrr.r)r(rqrs r.r|zWorksheet._write_data_bar5s#  99\ " " B   {E,,?@ A A A 99\ " " B   {E,,?@ A A A 99Z  0   . / / / Iz222 z*E+,>??? z*E+,>??? %{!3444 )$$$$$r2ch|jdz}t|jdz}d||fz}||d<|j||d|d|d||d|ddS)Nr z{DA7ABA51-AAAA-BBBB-%04X-%012X}guidextLstz&{B025F937-C7B1-47D3-B67F-A62EFF666E3E}zx14:idext)rhrErrr _write_extrr)r(rqworksheet_countdata_bar_countrs r.r}zWorksheet._write_data_bar_extLs*q.T011A50O^3TTf  ""5))) H%%% @AAA x... %    (#####r2cg}|ddkr d|dfg}|dr|d|dr|d|d|t|dD]+}||d |d |d ,|ddS) Nrrrrrr)rPr rr8r^rC)rrrreversedrr)r(rqricons r.r~zWorksheet._write_icon_set^s   "2 2 2$eL&9:;J 99\ " " 0   . / / / 99_ % % .   n - - - Iz222U7^,, L LD   T&\4=$z:J K K K K )$$$$$r2cd|fg}||d|f|r|d|d|dS)Nr8r)gtercfvorF)r(cf_typerrCrs r.rzWorksheet._write_cfvotsdw'( ?   ucl + + +  *   j ) ) ) FJ/////r2c<||fg}|d|dSrCrrDs r.r.zWorksheet._write_colors)Um_  GZ00000r2c.|jD] }|j| dSrU)rz_write_selection)r( selections r.ryzWorksheet._write_selectionss0 . .I !D !9 - - - . .r2cg}|r|d|f|r|d|f|r|d|f|d|dS)Nr activeCellrrrF)r(rrrrs r.rzWorksheet._write_selections  .   vtn - - -  ;   |[9 : : :  0   w. / / / K44444r2cz|j}t|sdS|ddkr |j|dS|j|dS)Nr?r)rrE_write_split_panes_write_freeze_panes)r(rs r.rxzWorksheet._write_panessU 5zz  F 8q== #D #U + + + + $D $e , , , ,r2c@g}|}|}t||} d} d} d} d} |jr|jd\}} } g|_|r||rzd} t|d}td|}|jd||g|jd||g|jd| | gnA|r d} |jd| | gnd} |jd| | g|dkrd} n |dkrd} nd } |r|d |f|r|d |f|d | f|d | f|d| f|d|dS)NrYr bottomRighttopRight bottomLeftfrozenr frozenSplitr7xSplitySplitrq activePanestater)rrzrr%)r(r%rFrrrry_splitx_splitr~rrrrrHrow_cellcol_cells r.rzWorksheet._write_freeze_paness  )'8<<    ? !&*oa&8 #Q U DO  G3 G'K(a00H(C00H O " "J(#C D D D O " "L(H#E F F F O " "M;#F G G G G  G$K O " "J U#C D D D D'K O " "L+u#E F F F >>EE !^^!EEE  3   x1 2 2 2  3   x1 2 2 2=-8999<56667E*+++ FJ/////r2cg}d}d}d} d} |} |} |jr|jd\} } } g|_d}| rtd| zdz} | r|| } ||krB||kr>h#oo#3" 4r 99::G3'C-2!5!9A!=!BBCCH)'8<<  "'K!E  G3 G'K(!44H(H55H O " "J(#C D D D O " "L(H#E F F F O " "M;#F G G G G  G$K O " "J U#C D D D D'K O " "L+u#E F F F  =   x7):; < < <  =   x7):; < < <=-8999  ;   |[9 : : : FJ/////r2cd}d}|dkrt|||zzdz}nt||zdz|z}|dzdz }|dz}|dz}|S) Nrrr r$rZr?r`r)r&)r(rrrrpointstwipss r.rz"Worksheet._calculate_x_split_width%s} 199/G"; 2 2 2 2 ,'''''r2c`dt|z}d|fg}|d|dS)Nrr tablePartrJrMs r.rzWorksheet._write_table_partUsFs4yy    K44444r2ct|j}t|j}|s|sdS|d|r||r||ddS)Nr)rErrr_write_ext_list_data_bars_write_ext_list_sparklinesr)r( has_data_barshas_sparkliness r.rPzWorksheet._write_ext_listcsD/00 T_-- ^  F H%%%  -  * * , , ,  .  + + - - - (#####r2c|d|d|jD]}|||d|ddS)Nz&{78C0D931-6437-407d-A8EE-F0AAD7539E65}zx14:conditionalFormattingsr)rrr"_write_conditional_formatting_2010r)r(rs r.rz#Worksheet._write_ext_list_data_barsvs @AAA 8999+ > >H  3 3H = = = = 6777 %     r2cd}d|fg}|d|||||||d|d||d|d|ds||d |d s||d |ds#|d s||d |ddkr||d|d|d| d|d|ddS)N3http://schemas.microsoft.com/office/excel/2006/mainxmlns:xmzx14:conditionalFormattingrrrrrrrrrrrr[r 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(rxmlns_xmrs r.rz,Worksheet._write_conditional_formatting_2010sH!8,-  7DDD )))   *** Xn5x 7LMMM Xn5x 7LMMM( G  ( (2D)E F F F12 P  / /9M0N O O O) Y=> Y  1 1(;V2W X X X ' (F 2 2  & &x0@'A B B B -((( ,''' z8G+<=== 566666r2cVd}|d}d|fd|fg}|d|dS)Nrrr8r%rr)r(r rule_typerrs r.rzWorksheet._write_x14_cf_rules@ y)D$<8  L*55555r2cJd}d}d|fd|fg}|ds|d|dr|d|d d kr|d |d d kr|d |dr|d|ds|ds|d|ddkr|d|ddkr|d|d|dS)Nrr^rrr)borderr r)gradientrrr)r leftToRightr)rrkr)negativeBarColorSameAsPositiver r)$negativeBarBorderColorSameAsPositiverrmiddle) axisPositionrr[)rr[r)rr)r(rrrrs r.rzWorksheet._write_x14_data_barsu  * % * % ( -   m , , , K  /   o . . . O $ . .   : ; ; ; O $ / /   : ; ; ; - . E   C D D D) K=> K   I J J J ' (H 4 4   8 9 9 9 ' (F 2 2   6 7 7 7 M:66666r2cd|fg}|dvr|d|dS|d||d||ddS)Nr8)rrrrzx14:cfvoxm:f)r%rrr)r(rr^rs r.rzWorksheet._write_x14_cfvos}y)* < < <    J 7 7 7 7 7    J 7 7 7  " "65 1 1 1   j ) ) ) ) )r2c<d|fg}|d|dS)Nrzx14:borderColorrr(rrs r.rz!Worksheet._write_x14_border_colors*cl^  -z:::::r2c<d|fg}|d|dS)Nrzx14:negativeFillColorrrs r.rz(Worksheet._write_x14_negative_fill_colors*cl^  3Z@@@@@r2c<d|fg}|d|dS)Nrzx14:negativeBorderColorrrs r.rz*Worksheet._write_x14_negative_border_colors*cl^  5zBBBBBr2c<d|fg}|d|dS)Nrz x14:axisColorrrs r.rzWorksheet._write_x14_axis_colors)cl^  OZ88888r2cF|d|t|jD]7}||||d||d|||d| |d| |d| |d| |d|d r| d |d |||d 9|d |d dS)Nz&{05C60535-1F16-4fd2-B633-F4F36F0B64E0}r^r`r_rZrWrUrSrRrx14: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(rts r.rz$Worksheet._write_ext_list_sparkliness @AAA $$&&&"$/22! 4! 4I  ' ' 2 2 2  $ $Y~%> ? ? ?  & &y1A'B C C C  " " $ $ $  % %i&@ A A A  # #Im$< = = =  " "9\#: ; ; ;  " "9\#: ; ; ;  ! !)K"8 9 9 9% G&&vy/EFFF  " "9 - - -   2 3 3 3 3 /000 %     r2cn|dt|dD]t}|d|}|d|}|d|d||d||du|ddS)Nzx14:sparklinesr2rfrLz x14:sparklinerr)rrwrr)r(rtrFrzrQs r.rzWorksheet._write_sparklines- s ,---y)** / /A#H-a0K -a0H    0 0 0  " "6; 7 7 7  " ":x 8 8 8   o . . . . *+++++r2cPd}|dz}d|fd|fg}|d|dS)Nz$http://schemas.microsoft.com/office/zspreadsheetml/2009/9/mainz xmlns:x14urirr)r(rr\ xmlns_x14rs r.rzWorksheet._write_ext> sH788 ) $ CL E:.....r2c@d}d|fg}|d|dS)Nrrrr)r(rrs r.rz!Worksheet._write_sparkline_groupsJ s1H!8,-  1:>>>>>r2c||d}g}|d4|ddkrd|d<n"|d|dfd|d<|d4|ddkrd|d<n"|d |dfd|d<|d d kr|d |d f|d r|d |d f|dr|d|r|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)&Nrnrrzcust_max manualMaxr_rcust_min manualMinr8rbrN lineWeightrR)dateAxisr displayEmptyCellsAsrO)rOr rh)rhr ri)rir rk)rkr rl)rlr rj)rjr rM) displayXAxisr r{) displayHiddenr minAxisType maxAxisTyperPrjr)rrr)r(rrnrs r.rz Worksheet._write_sparkline_groupR s]0 G$$ ;;u   )u~((&- ##!!;"?@@@&. # ;;u   )u~((&- ##!!;"?@@@&. # 6?f $ $   vwv7 8 8 8 ;;x  A   |WX->? @ @ @ ;;{ # # /   o . . .  >   4e< = = = ;;y ! ! .   n - - - ;;v   +   k * * * ;;u   *   j ) ) ) ;;w   ,   l + + + ;;v   +   k * * * ;;z " " /   o . . . ;;v   3   1 2 2 2 ;;x  4   2 3 3 3 ;;z " " D   }gj.AB C C C ;;z " " D   }gj.AB C C C ;;y ! ! 2   0 1 1 1 0*=====r2cbg}|dr|d|df|dr|d|df|dr|d|df|||dS)Nrrtint)rrr%)r(elementrrs r._write_spark_colorzWorksheet._write_spark_color s 99U   5   ueEl3 4 4 4 99W   9   wg7 8 8 8 99V   7   vuV}5 6 6 6 GZ00000r2c2|d|dS)Nzx14:colorSeriesrrs r.rzWorksheet._write_color_series s  1599999r2c2|d|dS)Nzx14:colorNegativerrs r.rzWorksheet._write_color_negative s  3U;;;;;r2c6|dddidS)Nz x14:colorAxisrFF000000rrs r.rzWorksheet._write_color_axis s# %1DEEEEEr2c2|d|dS)Nzx14:colorMarkersrrs r.rzWorksheet._write_color_markers s  2E:::::r2c2|d|dS)Nzx14:colorFirstrrs r.rzWorksheet._write_color_first s  0%88888r2c2|d|dS)Nz x14:colorLastrrs r.rzWorksheet._write_color_last  77777r2c2|d|dS)Nz x14:colorHighrrs r.rzWorksheet._write_color_high r r2c2|d|dS)Nz x14:colorLowrrs r.rzWorksheet._write_color_low s 66666r2c:ddg}|d|dS)N)fontId0)r8 noConversion phoneticPrrrzs r.r>zWorksheet._write_phonetic_pr s/  $ L*55555r2c|jsdS|d|jdr#|jd}|d||jdr#|jd}|d||jdr#|jd}|d||jdr#|jd}|d ||jd r#|jd }|d ||jd r#|jd }|d ||jdr#|jd}|d||jdr#|jd}|d||jdr#|jd}|d||ddS)N ignoredErrorsr numberStoredAsTextr evalErrorrr]r formulaRangerunlockedFormularemptyCellReferencerlistDataValidationrcalculatedColumnrtwoDigitTextYear)rrr_write_ignored_errorr)r( ignored_ranges r.rJzWorksheet._write_ignored_errors sy"  F O,,,   " "#: ; ; K /0GHM  % %&:M J J J   " "< 0 0 B / =M  % %k= A A A   " "#4 5 5 @ /0ABM  % %i ? ? ?   " "? 3 3 E /@M  % %nm D D D   " "#5 6 6 H /0BCM  % %&7 G G G   " "#9 : : K /0FGM  % %&:M J J J   " "#9 : : K /0FGM  % %&:M J J J   " "#6 7 7 I /0CDM  % %&8- H H H   " "#8 9 9 I /0EFM  % %&8- H H H /*****r2cBd|f|dfg}|d|dS)Nrr ignoredErrorr)r(r8rrs r.rzWorksheet._write_ignored_error!s8m $ 1I NJ77777r2rU)Nr)F)Nrri)NNN)NF)rr)r r r r)NNr)NN)r^)rYN)r )r[r[r\r\)rYNN)FF)r)r __module__ __qualname____doc__rfr'r1r,r*r?r#rNr"rXrr_rr?rnrdrfrer{r6rr0rr rrrrrrrrrrrrrrrrrrrrJr r r&r*r-r0r6r;rGrBrrrJr~rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr r rrrr!r0rRrDr}r8rhr@rArrrrrrrrrrrrr r,rrrrrr8rsrrrrrrr+r-r2r1rIrKrr4r6r7rer8r9rr:r;rErFrDrGrrrrGrrrrrrr5rrrrHrIrr@r rCrrr?rr r&r+r'r1r<r=rCrKrHrLrMrNrBrTr`rarArlrpryr{r|r}r~rr.ryrrxrrrrOrrPrrrrrrrrrrrrrrrrrrrrrrrr>rJr __classcell__)rs@r.rVrVsW)W)W)W)W)t#7#7#7J,,,&NLNLNL`AAAA&6AAAA$8????&$JJJJ*@* * * * X))))Zrrrrz4444lAAAA$*CCCC$6HHHH*iiiiV888.wwwr 7 7 7,,::::x;;;;z1111fDDDDL!!!!F " " "))))& & & &   555$"  444$IM>>>>@IMQQQQ0PNPNPNd;;;;z????(((((.JNIIIIV777@:::x(((T@@@@D@D~~~~@IIIIV }}}}~ 7 7 7D9999$GH$$$$0>>>>,6666"$ " " "    ) ) )1(1(1(1(fIIII>F ' ' ' ' ' '         + + +      $$$$&K'K'K'K'ZK'K'K'K'Z7777477774&&&&0 * * * $ $ $@ ' ' ''''$ % % %''', ' ' '      >>>>"((((^*'*'*'XbbbHBXXX&&&P4BAAA>>>L555(!9!9!9F(((999999v9990&"&"&"PB/B/B/H++++++0 7 7 7L5L5L5\8882<<<(999999&Q&Q&QP####J---^1=1=1=1=f@@@@t#t#t#l+++999 7778777 4 4 4555$'''*'''*/// ((($ 5 5 5L(L(L(^FJ5555&>B 5 5 5 5:::"GGG" * * *)))(222 ///.8886.;.;.;` - - - : : :,,,333 9 9 9 ; ; ; 3 3 3---$K0K0K0Z444" 4 4 4   333j(j(j(X 3 3 3(((*%%%.$$$$%%%, 0 0 0 0111 ... 5 5 5 - - -606060pE0E0E0N.(((2 5 5 5$$$& ! ! !+7+7+7Z666%7%7%7N * * *;;; AAA CCC 999 ,!,!,!\,,," / / /???W>W>W>r 1 1 1:::<<<FFF;;;999888888777666++++++Z8888888r2rV)>r2rRrrr* collectionsrrr]r fractionsr functoolsrior r r warningsr rYrrNrrrrrrutilityrrrrrrrrrrrrr exceptionsr!r"rkVERBOSErbr1r?rJrHrTrZrrgr~rvrrrVrDr2r.r,s ######"""""" &&&&&&++++++&&&&&&############((((((''''''//////))))))(((((($$$$$$******(((((( bj<J?  P0@@Jx)9::Jx)9:::gx00Z +<==Z +CDD j-=>>!z:$L2NOO:g'=>>UA8UA8UA8UA8UA8 #UA8UA8UA8UA8UA8r2