hChSSKrSSKrSSKrSSKrSSKrSSKJrJr SSKJ r SSK J r SSK J r SSKJr SSKJrJr SSKJr SS KJr SS KJr SS KJr SS KJrJr SS KJr SSKJ r SSK!J"r"J#r#J$r$ SSK%J&r&J'r' SSK(J)r) SSK*J+r+ SSK,J-r-J.r.J/r/J0r0J1r1J2r2J3r3J4r4J5r5J6r6J7r7 SSK J8r8 \Rr"S\Rt5r;Sr\"SS5r?\"SS5r@\"SS5rA\"S S!5rB\"S"S#5rC\"S$S%5rD\"S&S5rE\"S'S(5rF\"S)S*5rG"S+S,\ Rp5rHg)-N) defaultdict namedtuple)Decimal)Fractionwraps)StringIO)isinfisnan)warn)Color) CommentType)Image)UrlUrlTypes) ButtonType) xmlwriter)Drawing DrawingInfo DrawingTypes)DuplicateTableNameOverlappingRange)Format)Shape) _datetime_to_excel_datetime_get_sparkline_style_preserve_whitespace_supported_datetimequote_sheetnamexl_cell_to_rowcolxl_col_to_namexl_pixel_widthxl_rangexl_rowcol_to_cellxl_rowcol_to_cell_fast) XMLwritera \bANCHORARRAY\( | \bBYCOL\( | \bBYROW\( | \bCHOOSECOLS\( | \bCHOOSEROWS\( | \bDROP\( | \bEXPAND\( | \bFILTER\( | \bHSTACK\( | \bLAMBDA\( | \bMAKEARRAY\( | \bMAP\( | \bRANDARRAY\( | \bREDUCE\( | \bSCAN\( | \bSEQUENCE\( | \bSINGLE\( | \bSORT\( | \bSORTBY\( | \bSWITCH\( | \bTAKE\( | \bTEXTSPLIT\( | \bTOCOL\( | \bTOROW\( | \bUNIQUE\( | \bVSTACK\( | \bWRAPCOLS\( | \bWRAPROWS\( | \bXLOOKUP\(c0^[T5U4Sj5nU$)zb Decorator function to convert A1 notation in cell method calls to the default row/col notation. c>U(aUSn[U5 T"U/UQ70UD6$![a [W5nXASS-nN*f=fNrr)int ValueErrorr!)selfargskwargs first_argnew_argsmethods gC:\Users\julio\OneDrive\Documentos\Trabajo\Ideas Frescas\venv\Lib\site-packages\xlsxwriter/worksheet.py cell_wrapper'convert_cell_args..cell_wrapperds[ ' G I d,T,V,,  '(3H12h&D 's&AArr2r4s` r3convert_cell_argsr7]s# 6] - - c0^[T5U4Sj5nU$)zc Decorator function to convert A1 notation in range method calls to the default row/col notation. c4>U(a[US5 T "U/UQ70UD6$![ai SUS;a1USRS5up4[U5upV[U5upxO[US5upVXVpXVXx/n U R USS5 U nN~f=f)Nr:rr+r,splitr!extend) r-r.r/cell_1cell_2row_1col_1row_2col_2r1r2s r3r4(convert_range_args..cell_wrapper|s DG d,T,V,, d1g~!%as!308 08 u0a9 $ue3H OODH %D s$A0BBrr6s` r3convert_range_argsrFus# 6]--* r8c0^[T5U4Sj5nU$)ze Decorator function to convert A1 notation in columns method calls to the default row/col notation. c,>U(a[US5 T "U/UQ70UD6$![ae USRS5Vs/sHo3S-PM Os snfsnupE[U5upg[U5uphXx/n U R USS5 U nNzf=f)Nrr;1rr<) r-r.r/colr?r@_rBrDr1r2s r3column_wrapper+convert_column_args..column_wrappers DG d,T,V,, 377==3EF3ECCi3EFNF(0HA(0HA~H OODH %D s$ BA>BBr)r2rLs` r3convert_column_argsrNs# 6]-- r8BlankformatErrorzerror, format, valueNumberznumber, formatStringzstring, formatBooleanzboolean, formatFormulazformula, format, valueDatetime RichStringzstring, format, raw_string ArrayFormulaz$formula, format, value, range, atypec^\rSrSrSrU4SjrSr\S5rSr \SSj5r SSjr \SS j5r SS jr \SS j5rSS jr\SS j5rSSjr\SSj5r\SSj5rSSjr\S5rSSjr\SSj5rSSjr\SSj5rSSjr\SSj5rSSjr\S5rSr Sr!\SSj5r"\SSj5r#\SSj5r$\SS j5r%\SS!j5r&\SS"j5r'\SS#j5r(S$r)SS%jr*S&r+S'r,S(r-S)r.S*r/S+r0S,r1\2SS-j5r3\2SS.j5r4SS/jr5SS0jr6SS1jr7SS2jr8\SS3j5r9\S45r:S5r;S6r<\SS7j5r=\SS8j5r>\SS9j5r?\SS:j5r@\S;5rA\SS<j5rBSS=jrC\GSS>j5rD\GSS?j5rEGSS@jrFSArGSBrHSCrIGSSDjrJGSSEjrK\SSFj5rL\SSGj5rMSHrNSIrOGSSJjrPSKrQSLrRSMrSSNrTGSSOjrUGSSPjrVGSSQjrWSSRjrX\2SSSj5rYGSSTjrZSUr[SVr\\SW5r]SXr^SYr_SZr`S[raS\rbS]rcS^rdSS_jreSS`jrfSargSbrhGSScjriSdrjSerkSfrlSgrmShrnSiroSjrpSSkjrqSl\rSm\sSn\s4SojrtSpruSqrvSrrwSsrxStrySurzGSSvjr{GSSwjr|Sxr}Syr~Sz\4S{jrS|\4S}jrS~rSrSrSrSrSrSrSrSSjrSSjrSrSrSrSrSrSrSSjrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrGSSjrSrSSjrSSjrSrSrSrSrSrSrSrSrSrSrSrSrSrS\sS\sS\sS\4SjrS\sS\sS\4SjrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSSjrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrSrU=r$(  Worksheetz5 A class for writing the Excel XLSX Worksheet file. c< >[TU]5 SUlSUlSUlSUlSUlSUlSUl/Ul SUl SUl SUl SUl SUlSUlSUlSUlSUlSUl0Ul/UlSUlSUlSUlSUl/UlS UlSUlSUlSUlS UlSUl SUl!SUl"SUl#S Ul$SUl%SUl&SUl'SUl(SUl)S Ul*S Ul+/Ul,/Ul-/Ul.S Ul/S Ul0S Ul1S Ul2SUl3SUl4SUl5SUl6SUl7SUl8SUl9SUl:SUl;SUl<SUl=SUl>SUl?/Ul@/UlA0UlB/UlCSUlD0UlE[[5UlHSUlIS UlJSUlKSUlLS UlMSUlNSUlOSUlPSUlQS UlRS UlSS UlTSUlUSUlVSUlWSUlXSUlYSUlZSUl[SUl\0Ul]/Ul^[[5Ul_/Ul`0Ula0Ulb0UlcSUldSUleSUlf[[5Ulg/UlhSUliSUljSUlk/UllSUlmSUlnSUloSS/UlpSUlq0Ulr0Uls0Ult0UluSUlvSUlwS UlxSUlySUlz/Ul{/Ul|/Ul}/Ul~/Ul/Ul/Ul/Ul/Ul/Ul/Ul/Ul/Ul/Ul0UlSUl0UlSUl0UlSUlSUlSUlSUl/Ul0Ul/UlSUlS UlSUlSUlSUl[[5UlSUlS UlSUlS UlSUlSUlSUlSUlSUlSUlSUlSUlSUlSUlSUlkSUlSUlSUlSUlSUl0UlSUlSUlSUlSUlSUlg)z Constructor. NrFiii@rTffffff??333333?d\( @@D i)super__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_imagerstring 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_formatdefault_checkbox_formatworkbook_add_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_stringembedded_images)r- __class__s r3rlWorksheet.__init__st      "!$!     "'%*"  $ $"$%*"  $(!$(!"$!   " " "   ! "$%! #D)  !" %!"!"$#% "$"$!%"$#% "#  &   #!#D) ! % !"F % %$&!&(#&(#"$$&!)+&!#       "#$ $  "' %d+"'#!&#' #' "&'+$#' $"!%" !%"' ""'$)!#( #r8cUS:XaUR"X#/UQ76$UR(a)URS5(aUR"X#/UQ76$URS5(a)UR S5(aUR"X#/UQ76$SU;aUR (a[ R"SU5(dT[ R"SU5(d8[ R"SU5(d[ R"S U5(aUR"X#/UQ76$UR(ag[U5nUR(d [U5(d'[U5(dUR"X#U/US SQ76$UR "X#/UQ76$UR "X#/UQ76$![a N2f=f) Nr^=z{=}r;z(ftp|http)s?://zmailto:z(in|ex)ternal:zfile://r) _write_blankr startswith_write_formulaendswithrrematch _write_urlrfloatrr r _write_numberr, _write_string)r-tokenrowrJr.fs r3_write_token_as_string Worksheet._write_token_as_strings B;$$S55 5  # #(8(8(=(=&&s7$7 7   D ! !ennS&9&9&&s7$7 7 5L$$*E2288Iu--88,e4488Iu--??33d3 3  " " %L))%((588--cEDHEE %%c66 6!!#2T22  s?AF88 GGc(UR"X/UQ76$)av 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,rJr.s r3writeWorksheet.writes"{{3+d++r8c U(d [S5eUSnURnXPR;aURUnU"XU/UQ76nUcOU$UcUR"X/UQ76$U[LaUR "X/UQ76$U[ [[[4;aUR"X/UQ76$U[LaUR"XAU/UQ76$U[R[R[R[R 4;aUR""X/UQ76$[%U[ [[[45(aUR"X/UQ76$[%U[5(aUR"XAU/UQ76$[%U[5(aUR "X/UQ76$['U5(aUR""X/UQ76$[%U[(5(aUR*"X/UQ76$[ U5nUR"XU/USSQ76$![,a O%[a [S[/U5S35ef=f[U5 UR0"X/UQ76$![,a [S[/U5S35ef=f)Nz,write() takes at least 4 arguments (3 given)rrzUnsupported type z in write()) TypeErrorrrr!bool_write_booleanr(r+rrr)strr.datetimedatetime timedelta_write_datetime isinstancerrr'r,typer*) r-r,rJr.r+ token_type write_handlerfunction_returnr-s r3r2Worksheet._writesJK KQ__  ,, , // ;M+DsBTBO &&& =$$S55 5  &&s7$7 7 %gx8 8%%c66 6  ..u3FF F     MM MM      ''848 8 eeS'8< = =%%c66 6 eS ! !..u3FF F eT " "&&s7$7 7 u % %''848 8 eS ! !??33d3 3 Je A%%c=DH= =   J/U }KHI I J J J%%c66 6 J/U }KHI I Js8!H I&"I I**#J c&URXX45$)aC Write a string to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). string: Cell data. Str. format: An optional cell Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: String truncated to 32k characters. )r*)r-r,rJstring cell_formats r3 write_stringWorksheet.write_string>s"!!#F@@r8cSnURX5(ag[U5UR:aUSURnSnUR(dURR U5nOUnUR(a XR :aURU5 [Xd5URUU'U$Nr) _check_dimensionslenrzrqro_get_shared_string_indexr_write_single_rowCellStringTupler)r-r,rJrGrH str_error string_indexs r3r*Worksheet._write_stringRs   ! !# + + v; (-doo.FI##>>BB6JL!L   C*;*;$;  " "3 ' /|I 3r8c&URXX45$)a4 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,rJnumberrHs r3 write_numberWorksheet.write_numberms !!#F@@r8cj[U5(d[U5(aUR(av[U5(aURXSUS5$U[R :XaURXSUS5$U[R *:XaURXSUS5$O [ S5eUR[La [U5nURX5(agUR(a XR:aURU5 [X45URUU'g)N#NUM!z1/0#DIV/0!z-1/0zUNAN/INF not supported in write_number() without 'nan_inf_to_errors' Workbook() optionrMr)r r rr#mathinfr7rrr(rOrqrrRCellNumberTuplerrXs r3r)Worksheet._write_numbers  ==E&MM%%==..s+wWWTXX%..s YWWdhhY&..siXX' D   x '6]F  ! !# + +   C*;*;$;  " "3 ' /vC 3r8c&URXX45$)a Write a blank cell with formatting to a worksheet cell. The blank token is ignored and the format only is written to the cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). blank: Any value. It is ignored. cell_format: An optional cell Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. )r!)r-r,rJblankrHs r3 write_blankWorksheet.write_blanks"  5>>r8cUcgURX5(agUR(a XR:aURU5 [ U5UR UU'g)NrrM)rOrqrrRCellBlankTupler)r-r,rJrKrHs r3r!Worksheet._write_blanksa    ! !# + +   C*;*;$;  " "3 ' .k: 3r8c(URXX4U5$)a Write a formula to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). formula: Cell formula. cell_format: An optional cell Format object. value: An optional value for the formula. Default is 0. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: Formula can't be None or empty. )r#r-r,rJformularHvalues r3 write_formulaWorksheet.write_formulas&""3W5IIr8c URX5(agUbUS:Xa [S5 g[RU5(aUR XXX4U5$UR S5(a*UR S5(aURXXX4U5$URU5nUR(a XR:aURU5 [X4U5URUU'g)NrMr^zFormula can't be None or empty{r r)rOr re_dynamic_functionsearchwrite_dynamic_array_formular"r$_write_array_formula_prepare_formularqrrRCellFormulaTuplerrks r3r#Worksheet._write_formulas  ! !# + + ?gm 1 2  % %g . .33#G%    c " "w'7'7'<'<,,#G%  ''0   C*;*;$;  " "3 ' 0eL 3r8c [RU5(aURXX4XVU5$URUUUUUUUS5$)a 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)rrrsrtru)r- first_row first_collast_rowlast_colrlrHrms r3write_array_formulaWorksheet.write_array_formulas_:  % %g . .33h'PU ((          r8c PURUUUUUUUS5nUS:XaSUlU$)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)rur) r-r{r|r}r~rlrHrmerrors r3rt%Worksheet.write_dynamic_array_formula*sB8))           A:&*D # r8cvURS5(aUSSnURS5(aUSSnURS5(aUSSnSU;aU$[R"SSU5n[R"S S U5n[R"S S U5n[R"S SU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SS U5n[R"S!S"U5n[R"S#S$U5n[R"S%S&U5n[R"S'S(U5n[R"S)S*U5n[R"S+S,U5n[R"S-S.U5n[R"S/S0U5n[R"S1S2U5n[R"S3S4U5n[R"S5S6U5n[R"S7S8U5n[R"S9S:U5n[R"S;SU5n[R"S?S@U5nUR(d U(dU$[R"SASBU5n[R"SCSDU5n[R"SESFU5n[R"SGSHU5n[R"SISJU5n[R"SKSLU5n[R"SMSNU5n[R"SOSPU5n[R"SQSRU5n[R"SSSTU5n[R"SUSVU5n[R"SWSXU5n[R"SYSZU5n[R"S[S\U5n[R"S]S^U5n[R"S_S`U5n[R"SaSbU5n[R"ScSdU5n[R"SeSfU5n[R"SgShU5n[R"SiSjU5n[R"SkSlU5n[R"SmSnU5n[R"SoSpU5n[R"SqSrU5n[R"SsStU5n[R"SuSvU5n[R"SwSxU5n[R"SySzU5n[R"S{S|U5n[R"S}S~U5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SSU5n[R"SGSU5n[R"GSGSU5n[R"GSGSU5n[R"GSGSU5n[R"GSGSU5n[R"GS GS U5n[R"GS GS U5n[R"GS GSU5n[R"GSGSU5n[R"GSGSU5n[R"GSGSU5n[R"GSGSU5n[R"GSGSU5n[R"GSGSU5n[R"GSGSU5n[R"GSGSU5n[R"GSGS U5n[R"GS!GS"U5n[R"GS#GS$U5n[R"GS%GS&U5n[R"GS'GS(U5n[R"GS)GS*U5n[R"GS+GS,U5n[R"GS-GS.U5n[R"GS/GS0U5n[R"GS1GS2U5n[R"GS3GS4U5n[R"GS5GS6U5n[R"GS7GS8U5n[R"GS9GS:U5n[R"GS;GS Write a date or time to a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). date: Date and/or time as a datetime object. cell_format: A cell Format object. Returns: 0: Success. -1: Row or column is out of worksheet bounds. )r?)r-r,rJr<rHs r3write_datetimeWorksheet.write_datetimecs ##Cd@@r8c URX5(agUR(a XR:aURU5 UR U5nUc UR n[ XT5URUU'g)NrMr)rOrqrrR_convert_date_timer CellDatetimeTupler)r-r,rJr<rHrYs r3r?Worksheet._write_datetimevs{  ! !# + +   C*;*;$;  " "3 '((.  22K 1E 3r8c&URXX45$)a8 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. )r9r-r,rJbooleanrHs r3 write_booleanWorksheet.write_booleans ""3WBBr8cURX5(agUR(a XR:aURU5 U(aSnOSn[ XT5UR UU'g)NrMrr)rOrqrrRCellBooleanTupler)r-r,rJrrHrms r3r9Worksheet._write_booleansc  ! !# + +   C*;*;$;  " "3 ' EE 0C 3r8c(URXX4XV5$)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,rJurlrHrGtips r3 write_urlWorksheet.write_urls&s6GGr8cURX5(ag[U[5(dyURnSU;aUR SS5upOUnSn [ U5U:d[ U 5U:a[ SUSUS35 g[U5nUbXSlUbXclU=RS- sl URS :a[ SURS 35 g Uc URnUR(dNUR(a XR:aURU5 UR!XUR"U5 X0R$UU'g ) NrM#rr^zIgnoring URL 'z!' with link or location/anchor > z4 characters since it exceeds Excel's limit for URLs.iz>' since it exceeds Excel's limit of 65,530 URLs per worksheet.r)rOr@rrr=rPr _text_tipr _original_urlr rrqrrRr*textr) r-r,rJrrHrGrmax_urlurl_str anchor_strs r3r'Worksheet._write_urlsg  ! !# + +#s##))Gcz&)iiQ&7# 7|g%Z7)B$SE)J7)TJKc(C!"  A   e #  !2!2 34-.   11K''##.?.?(?&&s+   s; ?%(S!r8c(UR"X/UQ76$)a 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_stringr3s r3write_rich_stringWorksheet.write_rich_string s*&&s7$77r8c[U5nSnSnSnURX5(ag[US[5(aUR 5n[ 5n[ 5UlURRU5 [5n /n Sn Sn [U5S::a [S5 gUHn [U [5(dTU S:wa#U RU 5 U RU 5 OU RU 5 U S:Xa [S5 g X}- nS n O,U S:XaU S:a [S 5 g U RU 5 Sn U S - n M [U S[5(dURRS5 U Hn [U [5(a.URRS5 URU 5 MF/n[U 5(aURS5 URRSX5 URR!S5 M URR"R%5n[U5UR&:a [S5 gUR((dUR*R-U5nOUnUR((a XR.:aUR1U5 [3XeU5UR4UU'g)Nrr^rMrPzfYou 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().rrGzaExcel doesn't allow 2 consecutive formats in rich strings. Ignoring input in write_rich_string().rrr)z xml:spacepreservetzfString length must be less than or equal to Excel's limit of 32,767 characters in write_rich_string().rN)listrOr@rpopr r'r_set_filehandlerPr r_xml_start_tag _write_fontr_xml_data_element _xml_end_tagfhgetvaluerzrqrorQrrRCellRichStringTupler)r-r,rJr.tokensrHrU raw_stringrdefault fragmentspreviousposr+ attributesrGs r3rWorksheet._write_rich_string"sd     ! !# + + fRj& ) ) **,KZ {  $$R((   v;!  B EeV,,x'$$W-$$U+$$U+B;A# #x'C!GJ  '# 1HCEJ)A,// LL ' ' ,E%(( ++C0  ' '..%%&?@ ..sEF ))#. ))+ z?T__ , ? ##>>BB6JL!L   C*;*;$;  " "3 ' 3 z  3r8c X RU'g)z 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 r3add_write_handlerWorksheet.add_write_handlers*7I&r8cZUH%nURXXT5nU(aUs $US- nM' g)a6 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. rrr1r-r,rJdatarHr+rs r3 write_rowWorksheet.write_row4EKK%=E 1HC  r8cZUH%nURXXT5nU(aUs $US- nM' g)a9 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. rrr1rs r3 write_columnWorksheet.write_columnrr8cURXSS5(a[SUSUS35 gURX45nXlX%lUR U5 UR RU5 g)a` Insert an image with its top-left corner in a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). source: Filename, BytesIO, or Image object. options: Position, scale, url and data stream of the image. Returns: 0: Success. -1: Row or column is out of worksheet bounds. TzCannot insert image at (, ).rMr)rOr _image_from_source_row_col_set_user_optionsrr)r-r,rJsourceoptionsimages r3 insert_imageWorksheet.insert_imagess"  ! !#D$ 7 7 +C53%r: ;''8   ( 5!r8cURX5(a[SUSUS35 gUc0nURX45nURU5 UR SS5nUR (a:Uc UR nSUlURXUR U5 SUlURRU5n[S Xg5URUU'g ) a5 Embed an image in a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). source: Filename, BytesIO, or Image object. options: Url and data stream of the image. Returns: 0: Success. -1: Row or column is out of worksheet bounds. zCannot embed image at (rrrMNrHTF#VALUE!r) rOr rrgetrr rrrget_image_indexCellErrorTupler)r-r,rJrrrrH image_indexs r3 embed_imageWorksheet.embed_images"  ! !# + + *3%r#b9 : ?G''8 (kk-6 99""55 '+D $ NN3UYY <',D $**::5A  .iR 3r8c URXSS5(a[SUSUS35 gUcSnUc0nURSS 5nURS S 5nURS S 5nURS S 5nURSS 5n URSS5n URSS5n URR UUUUUUUU UU U / 5 g )a6 Insert an textbox with its top-left corner in a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). text: The text for the textbox. options: Textbox options. Returns: 0: Success. -1: Row or column is out of worksheet bounds. TzCannot insert textbox at (rrrMNr^x_offsetry_offsetx_scalery_scaleobject_position description decorativeF)rOr rrr) r-r,rJrrrrrranchorrrs r3insert_textboxWorksheet.insert_textbox%s"  ! !#D$ 7 7 -cU"SE< = <D ?G;;z1-;;z1-++i+++i+.2kk-6 [[u5    r8c rURXSS5(a[SUSUS35 gUc0nUR(d,UR(a'URR(a [S5 gSUlUR(aSURlUR S S 5nUR S S 5nUR S S 5nUR SS 5nUR SS 5n UR SS5n UR SS5n UR S :wa UR nUR S :wa UR nUR(a URnUR(a URnURRUUUUUUUU U U / 5 g )a4 Insert an chart with its top-left corner in a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). chart: Chart object. options: Position and scale of the chart. Returns: 0: Success. -1: Row or column is out of worksheet bounds. TzCannot insert chart at (rrrMNz7Chart cannot be inserted in a worksheet more than once.rNrrrrrrrrrF) rOr already_insertedcombinedrrrrrrr) r-r,rJchartrrrrrrrrs r3 insert_chartWorksheet.insert_chartYsy"  ! !#D$ 7 7 +C53%r: ; ?G  ! !U^^8W8W J K!% >>.2ENN +;;z1-;;z1-++i+++i+.2kk-6 [[u5  ==A mmG ==A mmG >>~~H >>~~H   r8cURX5(ag[U5UR:agSUlSUl[ XX45nX0R UU'g)aF 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. rMrNTr)rOrPrzrrrr)r-r,rJcommentrs r3 write_commentWorksheet.write_comments^$  ! !# + + w<$// )  c9") c3r8cSUlg)zV Make any comments in the worksheet visible. Args: None. Returns: Nothing. TN)rr-s r3 show_commentsWorksheet.show_comments !%r8cVURU5nX0lU(a [S5 g)z Set a background image for a worksheet. Args: source: Filename, BytesIO, or Image object. is_byte_stream: Deprecated. Use a BytesIO object instead. Returns: 0: Success. zThe `is_byte_stream` parameter in `set_background()` is deprecated. This argument can be omitted if you are using a BytesIO object.r)rrr )r-ris_byte_streamrs r3set_backgroundWorksheet.set_backgrounds0''/ %  R  r8cXlg)zv Set the default author of the cell comments. Args: author: Comment author name. String. Returns: Nothing. N)r)r-authors r3set_comments_authorWorksheet.set_comments_authors  &r8cUR$)zG Retrieve the worksheet name. Args: None. Returns: Nothing. )rmr s r3get_nameWorksheet.get_namesyyr8cVSUlSUlURURlg)z Set this worksheet as the active worksheet, i.e. the worksheet that is displayed when the workbook is opened. Also set it as selected. Note: An active worksheet cannot be hidden. Args: None. Returns: Nothing. rrN)rrrnr activesheetr s r3activateWorksheet.activates$  *.**'r8c SUlSUlg)z Set current worksheet as a selected worksheet, i.e. the worksheet has its tab highlighted. Note: A selected worksheet cannot be hidden. Args: None. Returns: Nothing. rrN)rrr s r3selectWorksheet.selects  r8c SUlSUlg)zF Hide the current worksheet. Args: None. Returns: Nothing. rrNrrr s r3hideWorksheet.hide&  r8c SUlSUlg)zh Hide the current worksheet. This can only be unhidden by VBA. Args: None. Returns: Nothing. rrNr$r s r3 very_hiddenWorksheet.very_hidden6r'r8cHSUlURURlg)a 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)rrnr firstsheetr s r3set_first_sheetWorksheet.set_first_sheetFs )-&r8cUc0nX:aX!p!SnURSS5nURSS5nURSS5n U(dU(a U(aSn OSn URSX&U 5(agURSXU 5(ag[U S5n [U S5n [URU 5Ul[ XS -5Hn X4XyUS/UR U 'M SUlg) 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. TrF collapsedlevelrrMr)rrOmaxminrrrr) r-r|r~widthrHr ignore_rowrr0r1 ignore_colrJs r3 set_columnWorksheet.set_columnXs( ?G  %- Xu-KK U3  GQ' 5VJJ  ! !!X: F F  ! !!YJ G GE1 E1 !$T%;%;U!CqL1C"'fYPU!VDMM# 2!%r8cPUbURU5nURXX4U5$)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_widthr8)r-r|r~r5rHrs r3set_column_pixelsWorksheet.set_column_pixelss-(  ))%0EyEPPr8cUR(a [S5 gURcg0n[UR U5S5n[ UR RUR RRS9n[URURS-5GHenURRU5(dM&[URURS-5GHnXPRU;dMURUUnURR nSnUS;afUS:XaUR"n X9n O UR$n S U ;a ['U 5nGOOU R)S 5Hn ['U 5n [+X5nM GOUS :Xa"S [-[/UR055-nOUS :Xa UR2nOUS :XaUR4(aSnOSnOUS;a[7UR8[:[<45(a2UR8S:a!S [-[/UR855-nOj[7UR8[.5(a['UR85nO5[7UR8[>5(aUR8(aSnOSnUR@RXE45(a US:aUS- nURUS5n X:dGMXU'GM GMh URC5Hup]UR U S -5n[X5nURDRU5(aURDRU5nUSnUSnUb4U(d-UU:a%XRDUS'SURDUS'MMXRDUS'SURDUS'MUSSSSS/URDU'M g)z Simulate autofit based on the data, and datatypes in each column. Args: max_width (optional): max column width to autofit, in pixels. Returns: Nothing. z1Autofit is not supported in constant_memory mode.Ngo@)keyrrrSrWrS rRr2rVrT$rUrXTF)#rqr r|r4r;sortedro string_table __getitem__rr{rrr}r~r__name__rGrr#r=r3rPr:rYrrr@rmr(r+r8ritemsr)r- max_width col_width_maxstringsrow_numcol_numcell cell_typelength string_idrG seg_length width_max pixel_widthr5r user_widthrs r3autofitWorksheet.autofits    D E  ?? "  --i8%@  NN ' 'T^^-H-H-T-T T__doo.ABG::>>'** $//A2EFjj11::g.w7D $ 7 7IF $<<%0(, I%,%7F%)__Fv-%3F%;F+1,,t*<-;F-C ),V)@+=#h."#ST[[)9%:!:"j0 "&!9!9"i/ <<%'F%'F"&AA &djj5#,??#zzA~)*STZZ-A)A' C88%3DJJ%?F' D99#zz)+)+((,,g-?@@VaZ" !. 1 1'1 =I)17g.eG Cr%2$7$7$9 G))+/:E)E}}  )) ==,,W5%a[ !!)&z)49 g.q148 g.q1*16MM'*1-04DMM'*1-*/ua)M g&3%:r8cUc0nURb URnOSnURX5(agUc URnURSS5nURSS5nURSS5nUS:XaSnURn[ US5n[ US5n[ UR U5UlX#XhU/URU'S UlX&/URU'g) aJ 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. rrMrFr0r1rr2T) r}rOrrr3r4rrrr) r-r,heightrHrmin_colrr0r1s r3set_rowWorksheet.set_rowDs ?G ?? &ooGG  ! !# / / >,,FXu-KK U3  GQ' Q;F,,FE1 E1 !$T%;%;U!C%6)L c!% &.sr8cNUbURU5nURXX45$)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\rHrs r3set_row_pixelsWorksheet.set_row_pixels~s+  ++F3F||C>>r8cxUc URnXR:wa SUlXlU(aSUlgg)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 r3set_default_rowWorksheet.set_default_rows> >,,F -- -$(D !&, # &'D # r8c ^X:XaX$:Xa [S5 gX:aX1p1X$:aXBpBURX5(agURX45(ag[XX45n[XS-5Hn[X$S-5Hn URR X45(a.URR X45n [ SUSU S35eURR X45(a.URR X45n [ SUSU S35eXpRX4'M M URRXX4/5 URXXV5 [XS-5H7n[X$S-5H"n X:XaX:XaMURXSU5 M$ M9 g ) a 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 cellrMrz Merge range '!' overlaps previous merge range ''.!' overlaps previous table range 'r^r) r rOr$rrrrrrrr2r!) r-r{r|r}r~rrHrr,rJprevious_ranges r3 merge_rangeWorksheet.merge_ranges2  Y%: * +  %-  %-  ! !) 7 7  ! !( 5 5iHG qL1CY1 5$$((#44%)%6%6%:%:C:%FN*' |4""0!15 ##'' 33%)%5%5%9%93*%EN*' |4""0!15 1;!!3*-62& 9DE I$<qL1CY1 5#(8!!#B <62 r8cX1:aX1p1XB:aXBpBURXX45n[XX45nXPlX`lX$/Ul[ X$S-5HlnUR RX45(a6UR RX45upUS:Xa[SUSU S35eSU4UR X4'Mn g)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. rrzWorksheet autofilter range 'z,' overlaps previous Table autofilter range 'rj worksheetN) _convert_name_arear$rrrrrrr) r-r{r|r}r~arearefrJrrs r3 autofilterWorksheet.autofilters  %-  %-&&yXPyX@#!&1qL1C  $$i%566,0,=,=,A,A9BR,S) ')*6se<33?.D 4?2DD  y. /2r8c UR(d [S5 g[U5 UR upVX:dX:a[SUSUSUS 35 gURU5n[U5S ;a[S US35 URX'5n[U5S :XaUS S :XaURXS/5 Oa[U5S:Xa5US S :Xa,US S:Xa#USS :XaURXSUS/5 OXpRU'S URU'SUl g![a6 Un[ US-5upAXR :a[SUS35 gGNDf=f)z Set the column filter criteria. Args: col: Filter column (zero-indexed). criteria: Filter criteria. Returns: Nothing. -Must call autofilter() before filter_column()NrIInvalid column ''Column '%' outside autofilter() column range (r))r_r2z(Incorrect number of tokens in criteria 'rrrrFr_)rr r+r,r!ryr_extract_filter_tokensrP_parse_filter_expressionfilter_column_listrrr)r-rJcriteria col_letterrK col_firstcol_lastrs r3 filter_columnWorksheet.filter_column s## @ A   H!% 1 1 ?cn 3% #Bxj3  ,,X6 v;f $ ;H:QG H..x@ v;! q Q  # #C) 5 [A &)q.VAY!^q UV  # #C)VAY)? @%+  S !$%D  S !O J(s3HQoo%' |156&  s D//:E/.E/c ~UR(d [S5 g[U5 UR upVX:dX:a[SUSUSUS 35 gX RU'S URU'S Ul g![a5 Un[ US-5upAXR :a[SUS35 gNf=f) 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. rwNrIrxryrzr{,r|r) rr r+r,r!ryrrrr)r-rJfiltersrrKrrs r3rWorksheet.filter_column_list\ s## @ A   H!% 1 1 ?cn 3% ;az,   ' !+ J(s3HQoo%' |156&  s A==:B<;B<c |URXSS5(agURX4SS5(agUc0nOUR5n1SknUR5HnXv;dM [SUS35 g SU;aUSUS 'S U;aUS US 'S U;a [S 5 gS S SSSSSSSSSSS. nUS U;a[SUS S35 gXS US 'US S :Xa%UR S5cUR S5cgUS S :XdUS S:Xd US S:Xa SUS'SUS'SU;a [S5 g0SS_SS_S S!_S"S!_S#S!_S$S%_S&S%_S'S%_S(S)_S*S)_S+S,_S-S,_S.S/_S0S/_S1S2_S3S2_n USU ;a[S4USS535 gXSUS'USS:Xd USS:XaSU;a [S65 gOSUS'S7S8S9S:.n S;U;aS7US;'O&US;U ;a[S4US;S<35 gXS;US;'US S=;apUS (af[ US 5(aSUR US 5n U S>US 'US(a.[ US5(aUR US5n U S>US'UR S5(a%[US5S?:a[S@USSA35 gUR SB5(a%[USB5S?:a[SCUSBSA35 gUR S5(a%[US5SD:a[SEUSSF35 gUR SG5(a%[USG5SD:a[SHUSGSF35 gUS S:XaI[US [5(a1UR"US 6n [U 5SD:a[SIU SJ35 gSKU;aS8USK'SLU;aS8USL'SMU;aS8USM'SNU;aS8USN'XX4//USO'SPU;aUSORUSP5 SQU;aUSQRSRSS5USQ'URRU5 g7)Ta Add a data validation to a worksheet. Args: first_row: The first row of the cell range. (zero indexed). first_col: The first column of the cell range. last_row: The last row of the cell range. (zero indexed). last_col: The last column of the cell range. options: Data validation options. Returns: 0: Success. -1: Row or column is out of worksheet bounds. -2: Incorrect parameter or option. TrMN>rmrmaximumminimumrdropdownvalidate error_type show_error show_input error_title input_title multi_range other_cells ignore_blank error_message input_messageUnknown parameter 'z' in data_validation()rNrrmrrz5Parameter 'validate' is required in data_validation()nonewholedecimalrr<r= textLengthcustom) anyz any valuez whole numberrintegerrrr<r=z text lengthrSrzUnknown validation type 'z/' for parameter 'validate' in data_validation()rrbetweenrrz5Parameter '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<=zUnknown criteria type 'z/' for parameter 'criteria' in data_validation()zcParameter 'maximum' is required in data_validation() when using 'between' or 'not between' criteriarrr)stopwarning informationrz' for parameter 'error_type'.r<r=.16g zLength of input title 'z' exceeds Excel's limit of 32rzLength of error title 'zLength of input message 'z' exceeds Excel's limit of 255rzLength of error message 'zLength of list items 'z;' exceeds Excel's limit of 255, use a formula range insteadrrrrcellsrr$r^)rOcopykeysr rrrrPr@r _csv_joinr>replacerr) r-r{r|r}r~rvalid_parameters param_key valid_typescriteria_types error_types date_timerls r3data_validationWorksheet.data_validation s:$  ! !)d C C  ! !(dD A A ?GllnG *!I0*9+5KLM( w &x0GG   &y1GG  W $ H I# '"  : k 1 +GJ,?+@A23 )**=>  J 6 ) M*2 O,4 J 6 )z"f,z"h."+GJ !%GI  W $ H I y <      '  J   *  *  M        '(<  &  $%6 #! ( : n 4 )'**=)>?23 ,Z-@A  : ) +wz/Bl/R'E ("&GI   w &$%GL ! \ "+ 5 )',*?)@A./ $/ 0E$FGL ! J #3 3 #GG$455//0@AI"+D!1GG y!&9'):L&M&M 33GI4FG (1$'7 " ;;} % %#gm.D*E*J )'-*@)AB./  ;;} % %#gm.D*E*J )'-*@)AB./  ;; ' 'C0H,IC,O +GO,D+EF/0  ;; ' 'C0H,IC,O +GO,D+EF/0  : & (Z8H$-O-Onngg&67G7|c!,WI678  (&'GN # W $"#GJ  w &$%GL ! w &$%GL !'8FG G # G  # #GM$: ; G #%,]%;%C%CC%LGM " (r8cURXSS5(agURX4SS5(agUc0nOUR5n1SknUR5HnXv;dM [SUS35 g SU;a [S 5 g0S S _S S _S S _SS_SS_SS_SS_SS_SS_SS_SS_SS_SS_S S!_S"S"_S#S#_S$S%_S&S'S(.EnUSU;a[S)USS*35 gUSS:XaSUS+'XSUS'0S,S,_S-S._S/S0_S1S0_S2S0_S3S4_S5S4_S6S4_S7S8_S9S8_S:S;_S_S?S>_S@SA_SBSA_SCSD_SESFSGSHSISJSKSLSMSNSOSPSMSPSQ.En SRU;aUSRU ;a XSRUSR'SSU;a7[ USS[ 5(a[ USS5R5USS'USST;aS US'SSU;a:[USS5(d [SU5 gURUSS5n U SVUSS'SWU;a:[USW5(d [SX5 gURUSW5n U SVUSW'SYU;a:[USY5(d [SZ5 gURUSY5n U SVUSY'0S[S\_S]S^_S_S`_SaSb_ScSd_SeSf_SgSh_SiSj_SkSl_SmSn_SoSp_SqSr_SsSt_SuSv_SwSx_SySz_S{S|_n USS':XaURS}5(d [S~5 gUS}U ;a[SUS}S35 gXS}US}'SUS'US}RS5(aSUS'OUS}RS5(aSUS'URURS5URS55US'X:aX1p1X$:aXBpB[XX45n [X5n SU;aUSn U RSS5n SU;a US(aUSR!5US'UR"US'U=R"S- slUR$(dURS5(dURS5(dURS5(dURS5(dURS5(dURS5(dnURS5(dXURS5(dBURS5(d,URS5(dURS5(aSUS'USS:XaUSSn['U5nUSRnUSRSD:XaSDUS'SUSU S3US'OfUSRSE:XaSUS'SUSU S3US'OKUSRSF:XaSFUS'SU SUSUS3US'O-USRSG:XaSGUS'SU SUSUS3US'O[SUS35 USS:XaUSRSH:Xa SU S3US'OUSRSI:Xa SU S3US'OUSRS:Xa SU S3US'OUSRSJ:Xa SU SU S3US'OUSRSK:Xa SU SU S3US'OUSRSL:Xa SU SU S3US'OsUSRSM:Xa SU SU S3US'O]USRSN:XaSU SU SU S3US'ODUSRSO:Xa SU SU S3US'O.USRSP:XaSU SU SU SU S3 US'O[SUSRS35 USS:Xa SU S3US'USS:Xa SU S3US'USS:Xa SU S3US'USS!:Xa SU S3US'USS":XaSUS'SUS'SUS'SUS'UR)SS5 UR)SS5 UR)SS5 UR)SS5 UR)S[+S55 UR)S[+S55 [*R,"US5US'[*R,"US5US'USS#:XGaSUS'SUS'UR)SS5 UR)SS5 UR)SS5 UR)SS5 UR)SS5 UR)S[+S55 UR)S[+S55 UR)S[+S55 [*R,"US5US'[*R,"US5US'[*R,"US5US'SU;aSUS'USS%:XGaSUS'URS5(d SUS'SUS'OUSUS'URS5(d SUS'SUS'OUSUS'UR)SS5 UR)SS5 UR)S[+S55 UR)SUS5 UR)SS5 UR)SS5 UR)SS5 UR)SS5 UR)S[+S55 UR)S[+S55 UR)SS5 UR)SS5 UR)SS5 UR)S[+S55 [*R,"US5US'[*R,"US5US'[*R,"US5US'[*R,"US5US'[*R,"US5US'URS5(a9SUlUSS:XaUSS:XaSUS'USS:XaUSS:XaSUS'XS'USR1S15US'USR1S15US'USR1S15US'XR6;aUR6U R9U5 gU/UR6U 'g![2[44a Nf=f![2[44a Nf=f![2[44a N}f=f)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. TrMN>$rAiconsrmrPrrbar_onlyrmax_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_lengthr 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_samerz' in conditional_format()rNrAz4Parameter 'type' is required in conditional_format()rQcellIsr<r=average aboveAverage duplicateduplicateValuesunique uniqueValuestoptop10bottomr time_period timePeriodblankscontainsBlanks no_blanksnotContainsBlankserrorscontainsErrors no_errorsnotContainsErrors 2_color_scale 3_color_scaledata_bardataBar expressioniconSet)rlicon_setzUnknown value 'z.' for parameter 'type' in conditional_format() directionrrrrrrrrrrrrrrrrrrrrrrr containing containsText notContains beginsWithendsWith yesterdaytoday last7DayslastWeekthisWeeknextWeek lastMonth thisMonth nextMonth)znot containingz begins withz ends withr r z last 7 daysz last weekz this weekz next weekz last monthz this monthz next monthz continue weekzcontinue monthrrmrz5Conditional format 'value' must be a datetime object.rrz7Conditional format 'minimum' must be a datetime object.rz7Conditional 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().rzUnknown icon_style 'z' in conditional_format().r_ total_icons4r}5rFrrrr^rPpriorityrrrrrrrrrrrris_data_bar_2010zNOT(ISERROR(SEARCH("z",z)))rlnotContainsTextzISERROR(SEARCH("z))zLEFT(rz)="rzRIGHT(zInvalid text criteria 'zFLOOR(z ,1)=TODAY()-1z ,1)=TODAY()tomorrowz ,1)=TODAY()+1zAND(TODAY()-FLOOR(z ,1)<=6,FLOOR(z ,1)<=TODAY())zAND(TODAY()-ROUNDDOWN(z*,0)>=(WEEKDAY(TODAY())),TODAY()-ROUNDDOWN(z,0)<(WEEKDAY(TODAY())+7))z",0)<=WEEKDAY(TODAY())-1,ROUNDDOWN(z ,0)-TODAY()<=7-WEEKDAY(TODAY()))zAND(ROUNDDOWN(z+,0)-TODAY()>(7-WEEKDAY(TODAY())),ROUNDDOWN(z",0)-TODAY()<(15-WEEKDAY(TODAY())))z AND(MONTH(z)=MONTH(TODAY())-1,OR(YEAR(z)=YEAR(TODAY()),AND(MONTH(z)=1,YEAR(A1)=YEAR(TODAY())-1)))z)=MONTH(TODAY()),YEAR(z)=YEAR(TODAY()))z)=MONTH(TODAY())+1,OR(YEAR(z )=12,YEAR(z)=YEAR(TODAY())+1)))zInvalid time_period criteria 'z LEN(TRIM(z))=0z))>0zISERROR(r|z NOT(ISERROR( colorScalerrrr4rr3rrrrz#FF7128rz#FFEF9C percentilez#F8696Bz#FFEB84z#63BE7Br2autoMin x14_min_typeautoMax x14_max_typerz#638EC6rFz#FF0000#000000r)rOrrr r@r8r:upperrrrr"_set_icon_propsr$r%r_get_dxf_indexrrrP setdefaultr _from_valuervlstripKeyErrorAttributeErrorrr)r-r{r|r}r~rvalid_parameterr valid_type criteria_typer valid_iconsr start_cellrmrSrs r3conditional_formatWorksheet.conditional_format s+(  ! !)d C C  ! !(dD A A ?GllnG% P!I/*9+5NOP(  G H H F  F  ~  *  n   7  g  F  <  &  ,  &  ,  _ _! "  # $$!' . 6?* , !'&/!23*+  6?h &#+GK $V_5! y! <!  !   ! ' ! J !  *!  *!  M!  !  !  !  '(<!  &!  $%6! #!! " .#! $,'#$&###%%%')A! H  WZ%8M%I"/ 0C"DGJ  g *WW-=t"D"D"77#34::>RS 33GI4FG (1$'7 "G#*79+=>>RS 33GI4FG (1$'7 "   x  &'8      m    0  ]  +  ]   0  x    ]    ! " # * 6?i ';;|,,D|$K7*7<+@*AB/0$/ 0E$FGL !&'GM "|$//44)* &&11#66)* &#33 M*GKK,@ GG   "*x  "*xiHG &y<  G # /J#++C4J w 78#4 ' 1 @ @ BGH #//  Q  # #{{?++{{;''{{-..{{/00{{455{{677{{;<<{{?++{{.//{{+,,{{?++*.G& ' 6?f $G$EZFz*Hz"n4"0';E7"ZLPS%T "$ 5"3'7wb B%O "$ 4".',ZL&UG1%M "$ 2",'-j\6(#eWA%N ".xj8QRS 6?l *z"k1'-j\%G "$/'-j\%E "$ 2'-j\%G "$ 3( 5'L 7 " $ 2,ZL9))3 4MO " $ 2,ZL9!!+ ,LN " $ 2$ZL1!!+ ,NP " $ 3  -)l+**45TV "$ 3  -&<'79 " $ 3  -)l+**46&<';= "4WZ5H4IJ./ 6?. .#,ZL!=GI  6?1 1#,ZL!=GI  6?. .#+JGI  6?o -*GFO!%GH #'GJ #'GK   z5 1   z5 1   {A .   {A .   {E),< =   {E),< =#(#4#4W[5I#JGK #(#4#4W[5I#JGK  6?o -*GFO!%GH    z5 1   z< 8   z5 1   {A .   {A .   {E),< =   {E),< =   {E),< =#(#4#4W[5I#JGK #(#4#4W[5I#JGK #(#4#4W[5I#JGK ')') $ 6?i ' $GH ;;z**&+ #*3'*1**=';;z**&+ #*3'*1**='   {A .   {A .   {E),< =   17;3G H   z5 1    6   {E 2    3   3U95E F   :E)#>s#CGK  #*;#7#>#>s#CGK  #*;#7#>#>s#CGK ** *   j ) 0 0 9.5ID  j )#.)   .)   .)   s6"n(:n>o(n;:n;>ooo'&o'c 0n0nUc0nOUR5nUR(a [S5 gURXSS5(agURX4SS5(agX:aX1p1X$:aXBpB[ XX45n[ XS-5Hn [ X$S-5Hn UR RX45(a.UR RX45n [SUSU S 35eURRX45(a.URRX45n [SUS U S 35eXR X4'M M 1S kn UR5Hn X;dM [S U S 35 g URSS5US'URSS5US'URSS5US'X1- nUS(aUS-nUS:a [S5 gURSS5US'URSS5US'URSS5US'URSS5US'URSS5US'URSS5US'SU;aUSnXS'S U;a[S!US"35 g[R"S#U[R5(a[R"S$U5(a[S%US&35 g[R"S'U5(a[S(US&35 g[R"S)U5(d[R"S*U5(a[S+US,35 gS-U;a,US-US-'US-cS.US-'US-RS S.5US-'OS/US-'UnUnURS5(aUS- nURS5(aUS-n[ XX45US0'[ XUU5US1'US(dSUS'US(aUS1US'Sn/US2'0n[ X$S-5GH\nUS3[U5-S.S.S.SS.SSS4. nS2U;GaU[!US25::a US2US- nOSnU(GaURS5S5nURS65(aUS6US'USnUR#5nUU;a[S7US&35 gSUU'URS85US9'S:U;a^US:(aTUS:nUR%S;5(aUR'S;5nUR)U5nUR+US5nUUS:'URS<5(aUS<nUS=:XaS>nUS?:XaS@n[-/SAQ5nUU;aUR/UUS5nOUR+US5nUUSB'SCnUUS<'URSDS5nUR1UUUUU5 OCURSE5(a-USEnUUSE'UR3UUUURS555 UbUR55US5'UUUS- 'US2R7U5 US(aUR3UUUSUS95 US- nGM_ SFU;aUSFnSn[ UUS-5H}n Sn [ X$S-5Han U[!U5:aJU [!UU5:a8UUU n!U U;aUR9XU!UU 5 OUR9XU!S5 U S- n Mc US- nM [;[ X$S-55HcunnUS2Un"U"(dMU"S:(dM#URU5n#U"S:n[ UUS-5Hn UR1U UUU#5 M Me UR<R7U5 US(a[ X$S-5Hmn UR>RX45(a7UR>RX45un$n%U$SG:Xa[SHUSIU%S 35eSJU4UR>X4'Mo g)Ka 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' moderTrMrz Table range 'rkrjri> rrmstylecolumns total_rowrt header_row banded_rows last_column first_columnbanded_columnsr' in add_table()rNr[rZrtrz1Must have at least one data row in in add_table()r]Fshow_first_colr\ show_last_colshow_row_stripesr^show_col_stripesheader_row_countrYtotals_row_shownrm zName 'z&' in add_table() cannot contain spacesz^[\w\\][\w\\.]*$z^\dz*Invalid Excel characters in add_table(): 'ryz^[a-zA-Z][a-zA-Z]?[a-dA-D]?\d+$z-Name looks like a cell name in add_table(): 'z^[rcRC]$z^[rcRC]\d+[rcRC]\d+$zInvalid name 'z#' like a RC cell ref in add_table()rWr^TableStyleMedium9ra_rangerXColumn) idrm total_stringtotal_function custom_total total_valuerlrP name_formatrPrz'Duplicate header name in add_table(): ' header_formatrorlrrl count_nums countNumsstd_devstdDevrrrcountr3r4rtsumvarrmrrnrkrrpzTable autofilter range 'z0' overlaps previous Worksheet autofilter range 'r) rrqr rOr$rrrrrrr%r&UNICODErr:rPlowerr"rLrrvset_table_function_to_formular#r*rIrr2 enumeraterr)&r-r{r|r}r~rr col_formatsrr,rJrlrOrnum_rowsrmfirst_data_row last_data_rowcol_id seen_namesrPcol_data user_dataxformat header_namerlfunction subtotalsrmrkrijr+ column_dataformula_formatrrs& r3 add_tableWorksheet.add_table sA $ ?GllnG    H I  ! !)d C C  ! !(dD A A  %-  %-iHG qL1CY1 5##'' 33%)%5%5%9%93*%EN*' |4((6'7r; $$((#44%)%6%6%:%:C:%FN*' |4((6'7r; 0:  #,62&  !I/*9+5EFG( ")]D!A  ' L$ ?  ' L$ ? ' < MH a< D E#*++ne"D!(]E!Bo$+KK u$E !$+KK0@%$H !$+KK a$@ !$+KK U$C ! W 6?D &Md{vdV#IJK88/rzzBBbhhGGA$qIJxx:DAADTF!LMxx T**bhh7NPT.U.U~dV+NOP g $W-E'NW~%!#g#7^33CI $I'mmHd;G!}}X..+4X+>(#+6"2K&,,.Dz)FtfANO!'+Jt$.7mmO.LH]+!I-)I2F"+I"6#--c22&-nnS&9G#'"="=g"F#'"7"7"F.5+!}}%566#,-=#>#|3'2H#y0'/H$'  % $y0&*&E&E ((6*:'G'+&;&;Hd&KG7>H^4'/H5=!12 ) mQ ?++HgwQVW"~66'0'@ 3?0**$g|Y]]8=T *-4-C-C-E*/6K + )  # #H -|$""w(8(=:Q aKFq6v W 6?DA^]Q->? qL9C3t9}Sa\)9 $Q  + KK%QH KK%>FA:Q@ )yQ,)GHOFG *62K{{955!,!8%i0 1BCC''Wg~ND I 5! < Y1 5$$(())9::040A0A0E0EyFV0W-K"k1.6zlC;;G.L 8? 6K!!9"236r8cURXSS5(agS[X5/0nUc0n1SknUR5HnXe;dM [SUS35 g SU;a [S5 g UR S S 5nUS ;a [S 5 g US:XaSnXtS 'SU;a*[ US[ 5(a USUS'O US/US'[ US[ 5(a USUS'O US/US'[US5n[US5n X:wa [S5 g [US5US'[UR5n /n USHEn U RSS5n U RS5n SU ;aU S-U -n U RU 5 MG XS'/n USH&nURSS5nU RU5 M( XS'UR S5US'UR S5US'UR S5US'UR S5US'UR S 5US!'UR S"5US"'UR S#5US#'UR S$5US$'UR S%5US%'UR S&5US&'UR S'5US('UR S)5US)'UR S*S5nUS+:XaS,US-'OUS.:XaS/US-'OS0US-'UR S15nU(aSU;aU S-U-nUUS1'UR S2S,5n[U5nUS3US4'USUS5'US"US6'USUS7'US!US8'USUS9'USUS:'URXCS45 URXCS55 URXCS65 URXCS75 URXCS85 URXCS95 URXCS:5 URRU5 g,);a  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. TrM locations>r3r4axisrArrWweightmarkersreverselocation 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_pointsrz' in add_sparkline()rz0Parameter 'range' is required in add_sparkline()rNrAline)rcolumnwin_losszJParameter 'type' must be 'line', 'column' or 'win_loss' in add_sparkline()rstackedrrangeszMMust have the same number of location and range parameters in add_sparkline()rvrr^r!rhighrlowrnegativerfirstrlastrr4r3rrrrrrzeroremptyconnectspangaprrWseriesrrrrrrr)rOr%rr rr@rrPr rmrrLrr_set_spark_colorr)r-r,rJr sparklinerr spark_type range_countlocation_count sheetname new_ranges spark_range new_locationsrr date_rangestyle_idrWs r3 add_sparklineWorksheet.add_sparkline s$  ! !#D$ 7 7 #4S#>"?@ ?G <!I0*9+5IJK( ' ! C D[[0 ; ; 3   #"J&&  '*-t44)0)< +&*1**=)> +& gg& - -")'"2Ih #*7#3"4Ih )H-. Y{34  ( 0 !;!78 '$DII.  $X.K%--c26K&,,S1K+%'#o ;   k */)( !+.H''R0H   */"/+$KK 5 &";;{3 % ' ,= > *$[[7 '#KK 5 &&{{95 )";;u- %";;u- %#KK/ &&{{95 )%kk-8 (%kk(3 ( M2. F?!"Ig  i !'Ig !&Ig [[- #Z/"S:5J!+ +;;w*$X.$)(O .!&+J&7 "#%*9%5 /"#(> - "'- ,"'- ,!&u + i.A i2BC i/B i-@ i,? i,? i+> y)r8ctSn[X5nX:aX1p1X$:aXBpB[XX45nUS:XagXVU//Ulg)aA 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)r%r$r)r-r{r|r}r~pane active_cellsqrefs r3 set_selectionWorksheet.set_selectionsT( =   %-  %-xB D=  u56r8c>US:XaUS:Xag[X5Ulg)z Set the first visible cell at the top left of a worksheet. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). Returns: 0: Nothing. rN)r%r)r-r,rJs r3set_top_left_cellWorksheet.set_top_left_cells! !8q .s8r8cBXlX lX0lX@lSUlg)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 r3outline_settingsWorksheet.outline_settingss#""**'#r8c,UcUnUcUnXX4U/Ulg)a, 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,rJtop_rowleft_col pane_types r3 freeze_panesWorksheet.freeze_paness' ?G  H9= r8c*URXX4S5 g)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 r3 split_panesWorksheet.split_paness !15r8c^US:dUS:a[SUS35 Sn[U5Ulg)zj Set the worksheet zoom factor. Args: zoom: Scale factor: 10 <= zoom <= 400. Returns: Nothing. z Zoom factor 'z"' outside range: 10 <= zoom <= 400rcN)r r+r)r-rs r3set_zoomWorksheet.set_zooms3 "9s =&HI JDI r8cSUlg)zj Display the worksheet right to left for some versions of Excel. Args: None. Returns: Nothing. TN)rr s r3 right_to_leftWorksheet.right_to_left rr8cSUlg)zO Hide zero values in worksheet cells. Args: None. Returns: Nothing. rN)rr s r3 hide_zeroWorksheet.hide_zero-s r8c:[R"U5Ulg)zc Set the color of the worksheet tab. Args: color: A #RGB color index. Returns: Nothing. N)r rKrr-colors r3 set_tab_colorWorksheet.set_tab_color:s**51r8c(US:waURU5nU(d0n0SS_SS_SS_SS_SS_S S_S S_S S_S S_S S_SS_SS_SS_SS_SS_SS_SS_nUR5HnXC;aX$X4'M[SUS35 M! XS'X0lg)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. r^sheetTcontentFobjects scenarios format_cellsformat_columns format_rowsinsert_columns insert_rowsinsert_hyperlinksdelete_columns delete_rowsselect_locked_cellssortrt pivot_tablesselect_unlocked_cellszUnknown protection object: 'rypasswordN)_encode_passwordrr r)r-rrdefaultsr?s r3protectWorksheet.protectGs4 r>,,X6HG T u  u    E  e   5  e  5    e  5  "4  E  % E! " $T# *<<>C '  3C5:; " ('r8c2Uc [S5 gURS5nURSS5nU=RS- slUcS[ UR5-nU(aUR U5nUR RXU45 g) a  Unprotect ranges within a protected worksheet. Args: cell_range: The cell or cell range to unprotect. range_name: An optional name for the range. password: An optional password string. (undocumented) Returns: 0: Success. -1: Parameter error. z1Cell range must be specified in unprotect_range()rMrrr^rRanger)r rLrrr:rrrr-r range_namers r3unprotect_rangeWorksheet.unprotect_rangezs   D E &&s+ ''R0  !!Q&!   3t'@'@#AAJ ,,X6H $$jh%GHr8c"URXSS5(a[SUSUS35 gUc0nURnURnS[ UR 5-n[ XXEXc5nUR RU5 SUlg)a Insert a button form object into the worksheet. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). options: Button formatting options. Returns: 0: Success. -1: Row or column is out of worksheet bounds. TzCannot insert button at (rrrMrr) rOr rrrPrrrr)r-r,rJrr\r5 button_numberbuttons r3 insert_buttonWorksheet.insert_buttons  ! !#D$ 7 7 ,SEC5; < ?G((''C 1 122 Cf]L   ( r8cU(a!UR(dUR5 U(dLUR(d/UR5UlURR5 URnUR XX45$)aV Insert a boolean checkbox in a worksheet cell. Args: row: The cell row (zero indexed). col: The cell column (zero indexed). boolean: The boolean value to display as a checkbox. cell_format: Cell Format object. (optional) Returns: 0: Success. -1: Row or column is out of worksheet bounds. )checkbox set_checkboxr r r9rs r3insert_checkboxWorksheet.insert_checkboxsj" {33  $ $ &///3/G/G/I,,,99;66K""3WBBr8c SUlSUlg)zQ Set the page orientation as landscape. Args: None. Returns: Nothing. rTNrrr s r3 set_landscapeWorksheet.set_landscape"&r8c SUlSUlg)zP Set the page orientation as portrait. Args: None. Returns: Nothing. rTNrr s r3 set_portraitWorksheet.set_portraitrr8cXlg)z Set the page view mode. Args: 0: Normal view mode 1: Page view mode (the default) 2: Page break view mode Returns: Nothing. Nr)r-views r3 set_page_viewWorksheet.set_page_views r8cSUlg)zB Set the page view mode. Args: None. Returns: Nothing. rNr r s r3set_pagebreak_viewWorksheet.set_pagebreak_views r8c.U(aXlSUlgg)zh Set the paper type. US Letter = 1, A4 = 9. Args: paper_size: Paper index. Returns: Nothing. TN)rr)r-rs r3 set_paperWorksheet.set_papers (O&*D # r8c SUlSUlg)zH Center the page horizontally. Args: None. Returns: Nothing. TrN)rrr s r3center_horizontallyWorksheet.center_horizontally+&*" r8c SUlSUlg)zF Center the page vertically. Args: None. Returns: Nothing. TrN)rrr s r3center_verticallyWorksheet.center_vertically9r-r8c4XlX lX0lX@lg)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 r3 set_marginsWorksheet.set_marginsGs !#r8cUnURSS5n[U5S:a [S5 gUb[U[5(dSU0nO0nUR 5nUbX2S'/UlURS5(aWURS5US 'URURS5U5nS Ul UR RU5 URS 5(aWURS 5US 'URURS 5U5nS Ul UR RU5 URS5(aWURS5US 'URURS5U5nSUl UR RU5 URS5n[UR 5nXg:wa[SUSUSU35 /UlgSU;a USUl SU;a USUl XlURSS5UlSUlU(aSUlgg)z Set the page header caption and optional margin. Args: header: Header string. margin: Header margin. options: Header options, mainly for images. Returns: Nothing. &[Picture]&GrzCHeader string cannot be longer than Excel's limit of 255 charactersNmargin image_leftimage_data_left image_dataLH image_centerimage_data_centerCH image_rightimage_data_rightRHNumber of footer images '#' doesn't match placeholder count ' ' in string: align_with_marginsscale_with_docrbT)rrPr r@rrrrr_header_positionrrvrrrrrr)r-rrr9 header_origrplaceholder_count image_counts r3 set_headerWorksheet.set_headerZ=  d3 v;  V W   gt,,#W-G,,.   &H   ;;| $ $$+KK0A$BGL !++GKK ,EwOE%)E "    % %e , ;;~ & &$+KK0C$DGL !++GKK,GQE%)E "    % %e , ;;} % %$+KK0B$CGL !++GKK ,FPE%)E "    % %e ,"LL.$,,-  + +K=9+,M+H "$D   7 *(/0D(ED % w &(/0@(AD % $[[37%)" "&D  r8cUnURSS5n[U5S:a [S5 gUb[U[5(dSU0nO0nUR 5nUbX2S'/UlURS5(aWURS5US 'URURS5U5nS Ul UR RU5 URS 5(aWURS 5US 'URURS 5U5nS Ul UR RU5 URS5(aWURS5US 'URURS5U5nSUl UR RU5 URS5n[UR 5nXg:wa[SUSUSU35 /UlgSU;a USUl SU;a USUl XlURSS5UlSUlU(aSUlgg)z Set the page footer caption and optional margin. Args: footer: Footer string. margin: Footer margin. options: Footer options, mainly for images. Returns: Nothing. r7r8rzCFooter string cannot be longer than Excel's limit of 255 charactersNr9r:r;r<LFr>r?CFrArBRFrDrErFrGrHrbT)rrPr r@rrrrrrIrrvrrrrrr)r-rrr9 footer_origrrKrLs r3 set_footerWorksheet.set_footerrOr8cvUcUnUS- nUS- nSUSU3n[UR5nUS-U-Ulg)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. Nrrz:$r)r rmr)r-r{r}rrrs r3 repeat_rowsWorksheet.repeat_rowssX   H Q A 9+Rz*$DII. )C$ 6r8cUcUn[US5n[US5nUS-U-n[UR5nUS-U-Ulg)z Set the columns to repeat at the left hand side of each printed page. Args: first_col: Start column for range. last_col: End column for range. Returns: Nothing. Nrr;r)r"r rmr)r-r|r~rrrs r3repeat_columnsWorksheet.repeat_columnssZ   H#9a0 !(A.3)$DII. )C$ 6r8cUS:XaSUlSUlSUlgUS:XaSUlSUlgSUlSUlg)z Set the option to hide gridlines on the screen and the printed page. Args: option: 0 : Don't hide gridlines 1 : Hide printed gridlines only 2 : Hide screen and printed gridlines Returns: Nothing. rrTN)rrr)r-options r3hide_gridlinesWorksheet.hide_gridlines-sJ Q;#$D $%D !)-D & q[#$D $%D !#$D $%D !r8c SUlSUlg)zr Set the option to print the row and column headers on the printed page. Args: None. Returns: Nothing. TN)rrr s r3print_row_col_headersWorksheet.print_row_col_headersEs"%)"r8cSUlg)zn Set the option to hide the row and column headers on the worksheet. Args: None. Returns: Nothing. TN)rr s r3hide_row_col_headersWorksheet.hide_row_col_headersSs  $r8cUS:Xa+US:Xa%X0RS- :XaX@RS- :XagURXX45nXPlg)as 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. rrrM)rxryrqr)r-r{r|r}r~rrs r3 print_areaWorksheet.print_area`sP( NQOOa//OOa//&&yXP $r8c SUlSUlg)zT Set the order in which pages are printed. Args: None. Returns: Nothing. rTN)rrr s r3 print_acrossWorksheet.print_acrosss"&r8c8SUlXlX lSUlg)z Fit the printed area to a specific number of pages both vertically and horizontally. Args: width: Number of pages horizontally. height: Number of pages vertically. Returns: Nothing. rTN)rrrr)r-r5r\s r3 fit_to_pagesWorksheet.fit_to_pagess  "&r8cXlg)zl Set the start page number when printing. Args: start_page: Start page number. Returns: Nothing. N)r)r- start_pages r3set_start_pageWorksheet.set_start_pages %r8cxUS:dUS:a[SUS35 gSUl[U5UlSUlg)zw Set the scale factor for the printed page. Args: scale: Print scale. 10 <= scale <= 400. Returns: Nothing. rrz Print scale 'z#' outside range: 10 <= scale <= 400NrT)r rr+rr)r-scales r3set_print_scaleWorksheet.set_print_scalesC 2: ='JK L  u:"&r8c SUlSUlg)zd Set the option to print the worksheet in black and white. Args: None. Returns: Nothing. TN)rrr s r3print_black_and_whiteWorksheet.print_black_and_whites "&r8cXlg)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 r3set_h_pagebreaksWorksheet.set_h_pagebreaks  r8cXlg)z Set the horizontal page breaks on a worksheet. Args: breaks: List of columns where the page breaks should be added. Returns: Nothing. N)rr|s r3set_v_pagebreaksWorksheet.set_v_pagebreaksrr8cXUbXlgS[URS-5-Ulg)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)rr:rn)r-rms r3 set_vba_nameWorksheet.set_vba_names*   $  '#djj1n*= =D r8cUcgUR5n1SknUR5HnX2;dM [SUS35 g Xlg)z 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. rM> eval_error formula_rangeformula_differsformula_unlockedcalculated_columntwo_digit_text_yearempty_cell_referencelist_data_validationnumber_stored_as_textrz' in ignore_errors()r)rrr r)r-rrrs r3 ignore_errorsWorksheet.ignore_errorssZ ?,,.  !I0*9+5IJK( &r8c USUlUSUlUSUlUSUlUSUlUSUlUSUlUSUlUS UlUS Ul US Ul US Ul US Ul USUl USUlUSUlUSUlUSUlUSUlUR(aFSUlSUlSUlSUlSUlSUlSUlSUlSUlSUlUR(a^[:R<"UR S9up#[>R@"U5 X0l![EUSSS9Ul#URFUl$gg)Nrmrnrorrqrrrrrrrr r r rwr rrrg)@rar?F)dirzw+utf-8modeencoding)%rmrnrorrqrrrrrrrr r r rwr rrrrrrrrrrrrrtempfilemkstemposcloseropenrr)r- init_datafdfilenames r3 _initializeWorksheet._initialize,sf% w' ";/'(89():;) ";/"+,@"A#,-B#C ():;!*+>!?#,-B#C "+,@"A#,-B#C ():;():;'(89$-.D$E!():;   ',D $&+D #&(D ##D  $D DO!"D !$D !$D (-D %   &--$++>NR HHRL%- "#H4'JD &&DG r8cLUR5 UR5 UR5 UR5 UR 5 UR 5 UR 5 UR(dUR5 OUR5 UR5 UR5 UR(aUR5 UR5 UR5 UR!5 UR#5 UR%5 UR'5 UR)5 UR+5 UR-5 UR/5 UR15 UR35 UR55 UR75 UR95 UR;5 UR=5 UR?5 URAS5 URC5 g)Nrp)"_xml_declaration_write_worksheet_write_sheet_pr_write_dimension_write_sheet_views_write_sheet_format_pr _write_colsrq_write_sheet_data_write_optimized_sheet_data_write_sheet_protection_write_protected_rangesrw_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_closer s r3_assemble_xml_fileWorksheet._assemble_xml_fileZs     ! ##% ##  " " $  , , . $$& $$&     # # % ! ! '') $$&   !!#   "   !!#     ""$  ""$ %%'  !  +& r8cUS:dUS:agXR:dX R:agU(d(U(d!UR(aXR:agU(dDURbXR:aXlUR bXR :aXlU(dDUR bX R :aX lURbX R:aX lgrL)rxryrqrr{r|r}r~)r-r,rJr6r7s r3rOWorksheet._check_dimensionss 7cAg // !SOO%;*1E1E&&&&#*?"%&#*?"%&#*?"%&#*?"%r8cB[XRUR5$N)rrr )r-dt_objs r3rWorksheet._convert_date_times*6>>4CWCWXXr8c~SnSnSnSn[US5n [US5n S[US-5-n S[US-5-n US:XaX0RS- :XaU nU nSnO'US:XaX@RS- :XaU nU nSnOX-nX-nXV:Xa U(dUnOUS-U-n[ UR 5n U S-U-nU$)Nr^rrrr;r)r"r:rxryr rm)r- row_num_1 col_num_1 row_num_2 col_num_2range1range2rr row_col_only col_char_1 col_char_2 row_char_1 row_char_2rs r3rqWorksheet._convert_name_areas $Iq1 #Iq1 3y1}-- 3y1}--  >i??Q+>>FFL !^ __q-@ @FFL,F,F  LDC<&(D$DII. 3% r8cU(d/$[U5nSU;aURS5 [U5nUR5 Sn[ U5U:aUSUnU$)Nri)r{removerrrP)r-r} breaks_set breaks_listmax_num_breakss r3_sort_pagebreaksWorksheet._sort_pagebreaks sfI[ ?   a :&  { n ,%o~6Kr8c.U(d/$[R"S5nURU5n/nUH\nURS5(aUSSnUR S5(aUSSnUR SS5nUR U5 M^ U$)Nz"(?:[^"]|"")*"|\S+rrrMz"")r%compilefindallr"r$rr)r-rtoken_rer new_tokensr+s r3r~ Worksheet._extract_filter_tokens%sI::34!!*- E$$ab ~~c""cr MM$,E   e $r8cL[U5S:XaUSn[R"SU5(aSnO1[R"SU5(aSnO[SUSUS 35 UR XSS5nUR XS S5nXC/-U-$UR X5$) Nr2r_z(and|&&)rz (or|\|\|)rToken 'z3' is not a valid conditional in filter expression 'ryr})rPr%r&r _parse_filter_tokens)r-rr conditional expression_1 expression_2s r3r"Worksheet._parse_filter_expressionFs v;! !)Kxx K00 , 44 k]+--7L;  44Z!ML44Z!ML-/,> >((<%>',/0E%  &ME r8rimage_id drawing_idc URUR-nURUR-nUSUR- -nUSUR - -nUR URURURURUUUR5n[SUS--5n[SUS--5nUR(dE[5nSUlXpl UR R#SS[%U5-S-S/5 O URn['5n[(R*UlXhlUR0UlXHlXXlSUlURUl SUlUR8UlUR:bUR:UlUR<(aUR<n U R?5n U RA5n URBREU RF5(dURHR#S X/5 URKU RF5U lXlURBREURL5(d9URHR#S S [%U5-S -URN-/5 URKURL5UlURQU5 g) NgX@r5%r/drawing../drawings/drawing.xmlr /hyperlink/image../media/image.))_width_x_scale_height_y_scale_x_dpi_y_dpi_position_object_emusrr _x_offset _y_offset_anchorr+rrembeddedrrr:rrIMAGE _drawing_type _dimensionsr _description_shape _rel_index _decorativer_url_target _target_moderr_linkr_get_drawing_rel_index_digest_image_extension_add_drawing_object) r-rrrr5r\ dimensionsrdrawing_objectrtarget target_modes r3_prepare_imageWorksheet._prepare_imagesr u~~-/  $$$%%// JJ JJ OO OO   MM C54<()SFTM*+||iG G "L  ' ' . .2S_DvMtT llG$'3'9'9$%/"&+&6&6# %!' $!&$%!%*%6%6"    (*/*;*;N ' ::**C[[]F**,K$$((33""))<*MN!88CCN"%   $$U]]33    % %$s8}4s:U=S=SS %)$?$? $N!##N3r8c HURUu nnnnnnn n n n n U RSURS-5nU RSURS-5nX-nX-nUR XCXVXU 5n[ SUS--5n[ SUS--5nUR (dF[5nSUlUUlURRSS [U5-S -S/5 O UR n[S S U 5nU Ul [5n[R UlUUlUUlUUlU UlUUlU UlS UlU Ul[4R6"U 5nU(aUR95nUR;5nUR<RUR>5(dUR@RSUU/5 URCUR>5UlUUl"URGU5 g)Nr5r_r\rrrrrrrrectTextBoxrr )$rrrrrr+rrrrrr:rrrrSHAPErrr rrrrrrr from_optionsr r!rr"rr#rr&)r-rnrr,rJrrrrrrrrrr5r\r'rshaper(rr)r*s r3_prepare_shapeWorksheet._prepare_shape's KK             GT%<%'>'BC // h% C54<()SFTM*+||iG G "DL  ' ' . .2S_DvMtT llGfi1 $'3'9'9$%/" %!'&1# %!'$%!%/"w' [[]F**,K$$((33""))<*MN!88CCN"%N ##N3r8c[R"SSUR5UlURR UR 5(d9UR RSS[U5-S-UR-/5 URUR 5Ul URRU5 g)Nz\..*$r^r r r ) r%rrrrr$rrr:r%_get_vml_drawing_rel_index_ref_idr)r-rrs r3_prepare_header_imageWorksheet._prepare_header_imagels66(B0@0@A$$((77  " " ) )$s8}4s:U=S=SS 77 F  &&u-r8cbURRSS[U5-S-U-/5 g)Nr r r )rrr:)r-rimage_extensions r3_prepare_backgroundWorksheet._prepare_background~s2 &&-- '#h-7#=O P r8c URUu nnnnnn n n n n US- Ul[SURU --5n[SURU --5nUR XTXxXU 5nUR nUR(dE[5nSUl UUlURRSS[U5-S-/5 O URn[5n[RUlUUlUUlUUlUUlSUlU UlUR/5UlU UlU UlUR7U5 UR8RSS[U5-S-/5 g)Nrrrrrz/chartz../charts/chart)rrjr+r5r\r chart_namerrrrrr:rrCHARTrrr r_namerrr#rrrr&r)r-rnchart_idrr,rJrrrrrrrrr5r\r'rmrr(s r3_prepare_chartWorksheet._prepare_charts KK           a<C5;;012SELL7234// h% ||iG G "DL  ' ' . .2S_DvMN llG$'3'9'9$%/" %!'# $!'$($?$?$A!&1#%/"##N3 !! (3x=86A B r8c URXX4XVU5u nnnnnn n n n n [SSU--5n[SSU--5n[SSU --5n [SSU --5n [SSU --5n [SSU --5n XX4XXX4 $)Nrr)_position_object_pixelsr+)r- col_start row_startx1y1r5r\rcol_endrow_endx2y2x_absy_abss r3rWorksheet._position_object_emuss(  ( ( "%            tby ! tby ! tby ! tby !C$,&'C$,&'bgUUr8c SnSn US:a/US:a)X0RUS- 5- nUS-nUS:aUS:aM)US:a/US:a)X@RUS- 5- nUS-nUS:aUS:aM)[SU5n[SU5nUR(a&[ U5Hn XRU 5- nM OXR U-- nX- nUR (a&[ U5Hn XRU 5- n M OXRU-- n X- n X0RX5:a.X0RU5-nUS- nX0RX5:aM.X@RX'5:a.X@RU5-nUS- nX@RX'5:aM.Un Un URX5S:aXS-nURX'5S:aXd-nXPRX5:a.XPRX5-nU S- n XPRX5:aM.X`RX5:a.X`RX5-nU S- n X`RX5:aM.UnUnXX4XXX/ $r*) _size_col _size_rowr3rrrrr)r-rGrHrIrJr5r\rrOrPrrow_idrKrLrMrNs r3rF!Worksheet._position_object_pixelssw(1fQ ..Q/ /B NI1fQ 1fQ ..Q/ /B NI1fQ BZ BZ   *//+ ,,y8 8E    *//+ ,,y8 8E NN955 ..+ +B NINN955 NN955 ..+ +B NINN955  >>) ,q 0JE >>) ,q 0~~g66 ^^G4 4E qLG~~g66 w77 nnW5 5F qLGw77  bgUUr8c2SnSnSnXR;auURUSnURUSnUc URnU(a US:waSnU$US:a[XcU--S-5nU$[Xc-S-5U-nU$URnU$)Nr2rFrrr}rr)rrr+r)r-rJrmax_digit_widthpaddingpixelsr5rs r3rSWorksheet._size_col`s  -- MM#&q)E]]3'*F}..&A+ U&?@3FG  U4s:;gE ,,F r8cSnXR;aFURUSnURUSnU(a US:waSnU$[SU-5nU$[SUR-5nU$)Nrrr}gUUUUUU?)rr+r)r-r,rrZr\rs r3rTWorksheet._size_row~s  .. ^^C(+F^^C(+F&A+  Y/0 T%<%<<=F r8c:SnSnUS::a XU-- nU$X- U- nU$)Ng@g@ )r-rZrXrYr5s r3r;Worksheet._pixels_to_widths; R<78E %8E r8c SU-$)Nrar`)r-rZs r3raWorksheet._pixels_to_heights f}r8r c SnURURURURURUR UR U5nURUR 5 URUR 5 U$Nr)rF start_col start_rowrrr5r\r)r-r rverticess r3_comment_verticesWorksheet._comment_verticesss//             MM NN    &'r8rc SnURURURURURUR UR U5nURUR 5 URUR 5 U$re)rFrJr,rrr5r\r)r-rrrhs r3_button_verticesWorksheet._button_verticessk// JJ JJ OO OO LL MM    % &r8cd/n[URR55nUHn[URUR55nUHxn URUU n URU 5U lU R cUR U lU RcURU lURU 5 Mz M URHn URU 5U lM URRSS[U5-S-/5 UR(a2XPlUR RSS[U5-S-/5 [#U5n Un [%['U S- 55HnX-S-nUS U3nM XlX lU $) N /vmlDrawing../drawings/vmlDrawing.vmlz /commentsz ../commentsrrirr)rGrrrirh is_visiblerrrrrrlrr:rrrrPrr+rr)r-rrvml_drawing_id comment_idrrow_numsr,col_numsrJr rrv start_data_idrdata_ids r3_prepare_vml_objectsWorksheet._prepare_vml_objectss$--,,./CdmmC05578H--,S1#'#9#9'#B %%-)-)>)>G&>>)%)%9%9GN( "''F"33F;FO( && 4s>7JJVS T    !)   ' ' . .mc*o=FG H # s54<()A#'!+G(M7)4K*'( r8chXlURRSS[U5-S-/5 g)Nrorprq)rrrr:)r-rrss r3_prepare_header_vml_objects%Worksheet._prepare_header_vml_objectss6+ && 4s>7JJVS T r8c6URHnXS'URS5cS[U5-US'USR5nXB;a[ SUSS35eSX$'UR R SS[U5-S -/5 US - nM g) NrjrmTablezDuplicate name 'z ' used in worksheet.add_table().Tz/tablez../tables/tablerr)rrr:rzrrr)r-table_idseenrrms r3_prepare_tablesWorksheet._prepare_tabless[[E"$Kyy ( '#h- 7f =&&(D|(&uV}o5UVDJ  % % , ,,s8}  A % '' '     ( ($$V, , !$($8$8&!###r8cURRU5(aURU$U=RS- slURURU'UR$r)rrrrs r3r6$Worksheet._get_vml_drawing_rel_indexs]  $ $V , ,((0 0   A% (,(@(@f%'''r8ctURnURS5 UR(aURS5 UR(aURS5 UR (aURS5 UR (aURS5 UR(aURS5 UR(aURUR5 URS:XaURS5 URS :XaURS 5 URS S UR4/5 URS :XaOUR(a URSSUR4/5 OUR(a URSSUR4/5 ObUR (a>UR nUR"(d URSUR%55 OURSS/5 URSS UR&4/5 URSS UR(4/5 UR&S:Xa0UR*(dURSS UR,4/5 UR/S5 g)NrPrbrstrikeoutlineshadowr superscriptr subscriptszvalrMrthemeindexed)rrrFontfamilyCalibrischeme)rrbold_xml_empty_tagitalicfont_strikeout font_outline font_shadow underline_write_underline font_script_write_vert_align font_sizer_write_rstring_color color_indexed font_color _is_automatic _attributes font_name font_family hyperlink font_schemer)r- xf_format xml_writerrs r3rWorksheet._write_fonts)\\ !!%( >>  % %c *     % %c *  # #  % %h /  ! !  % %i 0   % %h /     ! !)"5"5 6  A %  " "= 1  A %  " "; / !!$%1D1D)E(FG ??b  __  % %g)//0J/K L  $ $  % %gI !!'UI4G4G,H+IJ!!(eY5J5J-K,LM   ) +I4G4G  % %h%9N9N1O0P Q&r8cz/nUS:XaS/nOUS:XaS/nO US:XaS/nURRSU5 g)Nr)rdouble!)rsingleAccounting")rdoubleAccountingurr)r-rrs r3rWorksheet._write_underlinesJ  >+,J "_56J "_56J ##C4r8cFSU4/nURRSU5 g)Nr vertAlignrr-rrs r3rWorksheet._write_vert_aligns!cl^  ##KEHW% (7+C!#s++s0C0C,/JJsO)=$$V,,"PK!}V,K?::=;P:QROP ,6=+@( 8F+x7/4EHV,&=,,Z88C+/EHZ(9%< r8cSnUS-nUS-nUS-nSnUS-nSU4SU4/nURS :Xa7URS U45 URS U45 URS 5 URS U5 g)Nz"http://schemas.openxmlformats.org/zspreadsheetml/2006/mainz!officeDocument/2006/relationshipszmarkup-compatibility/2006zhttp://schemas.microsoft.com/zoffice/spreadsheetml/2009/9/acxmlnszxmlns:rrFzxmlns:mcz xmlns:x14ac)z mc:Ignorablex14acrp)rvrr)r-schemarxmlns_rxmlns_mc ms_schema xmlns_x14acrs r3rWorksheet._write_worksheetTs622>>773 "BB &G(<=     %   z84 5   }k: ;   7 8 K4r8cURcURcSnGOURcsURbfURUR:Xa[SUR5nO[SUR5n[SUR5nUS-U-nOURUR:Xa;URUR:Xa![URUR5nOH[URUR5n[URUR5nUS-U-nUR SSU4/5 g)Nrrr; dimensionrs)r{r}r~r%r|r)r-rsr?r@s r3rWorksheet._write_dimensionhs ?? "t'>C __ $)D $//1'4??;+1doo>*1doo>slV+ __ /DOOt4V#DOOT__EC'tHF&tHF3,'C K5#,8r8chURS5 UR5 URS5 g)N sheetViews)r_write_sheet_viewrr s r3rWorksheet._write_sheet_viewss, L)   ,'r8c/nUR(dURS5 UR(aURS5 UR(dURS5 UR(aURS5 UR (aURS5 UR (dURS5 URS:XaURS5 O!URS :XaURS 5 URS :waURS UR45 URS :waURSUR45 URS:Xa.UR(aURSUR45 URS:XaURSUR45 URS :XaURSUR45 URS5 UR(dUR(aDURSU5 UR5 UR5 UR!S5 gUR#SU5 g)N) showGridLinesr)showRowColHeadersr) showZerosr rightToLeftr) tabSelectedrshowOutlineSymbolsrr)r! pageLayoutr)r!pageBreakPreviewr^ topLeftCellrc zoomScalerzoomScaleNormalzoomScalePageLayoutViewzoomScaleSheetLayoutView)workbookViewIdr sheetView)rrrrrrrrrrrrrr _write_panes_write_selectionsrrr-rs r3rWorksheet._write_sheet_views $$   2 3      6 7   . /    0 1 ==   0 1   7 8 >>Q    4 5 ^^q   : ;    #   }d.@.@A B 99    {DII6 7~~"t'='=!!#4dii"@A~~"!!#?  " "d&>&> >   1 2  " "   / 0    0)< =    0)< =    %   9 : OZ8r8cUR(dgURS5 [URR55SnUnURUnURU UnUn[URR55H;nURUnXbS-:Xa Xs:XaUnM#UR XU5 UnUnUnM= UR XU5 XPRU'UR S5 g)Ncolsrr)rrrGr_write_col_infor)r-r|r~prev_col_options deleted_coldeleted_col_optionsrJ col_optionss r3rWorksheet._write_colss}}  F#DMM..0115 ==3 MM) $ .$--,,./C--,Kl"{'F$$Y:JK $#. 0 Y2BC&9 k" &!r8cUupEpgpSn Sn U(aUR5n UcU(dSnSn O SnOUS:XaSn US:agSn Sn US:a/[[XLU --S-5[U 5- S-5S- nO.[[XL-S-5U -[U 5- S-5S- nSUS-4S US-4S US 4/nU (aURS U 45 U(aURS 5 U (aURS5 U (aURS5 U(aURSU45 U(aURS5 UR SU5 g)Nrrrfr2rFrgp@r4r3r5rrW)rrI)bestFitrI) customWidthrI outlineLevel)r0rIrJ) _get_xf_indexr+r(rr)r-col_mincol_maxrr5rHrr1r0rY custom_widthxf_indexrXrYrs r3r'Worksheet._write_col_infosBJ?VI  "002H =  d]L 19OGqyU&?@3FG01   U4s:;gE01   GaK GaK t &    w1 2    o .    . /    2 3    ~u5 6    0 1 E:.r8cURcURS5 gURS5 UR5 UR S5 g)N sheetData)r{rr _write_rowsrr s r3rWorksheet._write_sheet_dataSsB ?? "    ,    ,       k *r8cURcURS5 gURS5 SnURR S5 URR U5nU(a?UR RU5 URR U5nU(aM?URR5 [R"UR5 URS5 g)Nr8ir) r{rrrseekreadrr4rrunlinkrr)r- buff_sizers r3r%Worksheet._write_optimized_sheet_data]s ?? "    ,    ,I    ! !! $##((3D d#'',,Y7$    " " $ IId,, -   k *r8cSUR4SUR4SUR4SUR4SUR4SUR 4/nUR SU5 g)Nr2r3rrrr pageMargins)rrrrrrrrs r3rWorksheet._write_page_marginsusoT%% & d'' ( DOO $ t)) * t)) * t)) *   M:6r8c/nUR(dgUR(aURSUR45 URS:waURSUR45 UR(a-UR S:waURSUR 45 UR(a-UR S:waURSUR 45 UR(aURS5 URS:aURSUR45 UR(aURS 5 OURS 5 UR(aURS 5 URS :waURS 5 UR(a]UR(aURSUR45 UR(aURSUR45 O\UR(aURSUR45 UR(aURSUR45 URSU5 g)N paperSizercrur fitToWidth fitToHeight) pageOrder overThenDownfirstPageNumber)rportrait)r landscape) blackAndWhiterIr)useFirstPageNumberrI horizontalDpi verticalDpi pageSetup)rrrrrrrrrrrrsrrrrs r3rWorksheet._write_page_setups& &&  ??   {DOO< =   s "   w(8(89 : ==T^^q0   |T^^< = ==T__1   }doo> ? ??   ; < ??Q    0$//B C      9 :   : ;      4 5 ??a    9 :   ""!!?D4G4G"HI  !!=$2C2C"DE  !!=$2C2C"DE""!!?D4G4G"HI K4r8c`/nUR(dgUR(aURS5 UR(aURS5 UR(aURS5 UR (aURS5 UR SU5 g)N)horizontalCenteredr)verticalCenteredr)headingsr) gridLinesr printOptions)rrrrrrrrs r3rWorksheet._write_print_optionss ))  <<   7 8 <<   5 6      o .      . / NJ7r8c/nUR(dURS5 UR(dURS5 UR(afUR SU5 UR (aUR 5 UR(aUR5 URS5 gUR(aURSU5 gg)N) scaleWithDocr)alignWithMarginsr headerFooter) rrrrrr_write_odd_headerr_write_odd_footerrrwrrs r3rWorksheet._write_header_footers ((   1 2((   5 6  % %    ;{{&&({{&&(   n -  ! !    ;"r8c<URSUR5 g)N oddHeader)rrr s r3r^Worksheet._write_odd_header {DKK8r8c<URSUR5 g)N oddFooter)rrr s r3r_Worksheet._write_odd_footerrdr8cvUR5 [URURS-5GHnXR;d%XR ;dUR U(dM8[US- 5nX R;aURUnOSnUR U(aXR;aURX5 OURXURU5 [URURS-5H;nX@R U;dMUR UUnURXU5 M= URS5 GM1XR ;a"URXURU5 GMbURXURU5 GM g)NrrEr,)_calculate_spansrr{r|rrrr+r _write_rowr}r~ _write_cellr_write_empty_row)r-rO span_indexrrPcol_refs r3r9Worksheet._write_rowssV T__doo.ABG==(mm+::g&&!2. />>*5DD::g&mm36t}}W7MN#($//A:M#N"jj&99&*jj&9'&BG ,,WwG$O %%e, -))'w9OP))'w9OPECr8cURnXlX R;d#X R;dURU(aSnURU(aX R;aUR X#5 OUR X#URU5 [ UR URS-5H;nX@RU;dMURUUnURX$U5 M= URS5 OURX#URU5 URR5 g)Nrr,) rrrrrjrr}r~rkrrlclear)r-current_row_numrOrrPrns r3rRWorksheet._write_single_row-s##+ mm #w--'?4::gCVDzz'"--/OOG2OOG4==3IJ$T__doo6IJG**W"55"&**W"5g">((7C K !!%(%%gT]]75KL r8c0nSnSn[URURS-5GH4nX@R;a][URUR S-5H6nXPRU;dMUcUnUnM [ X%5n[X55nM8 X@R;an[URUR S-5HGnX@R;dMXPRU;dM(UcUnUnM1[ X%5n[X55nMI US-S-S:XdX@R:XdGM [US- 5nUcGMUS- nUS- nUSU3X'SnGM7 Xl g)NrrErr;) rr{r|rr}r~r4r3rr+r)r-spansspan_minspan_maxrOrPrms r3riWorksheet._calculate_spansRsW T__doo.ABG**$$T__doo6IJG**W"55#+'.H'.H'*8'=H'*8'=H K--'$T__doo6IJG--/G}}W?U4U#+'.H'.H'*8'=H'*8'=H K1"a'G,F 2. 'MHMH+3*AhZ(@E%#H=C@r8cRSnU(aUupgpn OSupgpn Uc URnSUS-4/n U(aUR5nU(aU RSU45 U(aU RSU45 U(aU RS5 X`R:wdX`R:Xa$X`R:waU RSUS 45 U(aU RS 5 X`R:wdX`R:Xa X`R:waU RS 5 U (aU RS U 45 U (aU RS 5 URS:XaU RS5 U(aUR SU 5 gUR SU 5 g)Nr)NNrrrrrrus) customFormatrhtg)rrrr0)r0rrFr r,)rr1rrrv_xml_empty_tag_unencoded_xml_start_tag_unencoded) r-r,ru properties empty_rowr5r\rHrr1r0rs r3rjWorksheet._write_row}sy ,,FC!Gn%  "002H    w. /    sHo .    1 2 -- - .. .6=T=T3T   tqz3 4    m , -- - .. .6=T=T3T   1 2    ~u5 6    . /    %   9 :   ) )% <  ) )% zrU)rrr)r^z#N/Az#NAME?z#NULL!r]z#REF!rr^)re)rr:rXr)cmrcrOrTrQvm)$r&rPr1rrrrrJ_xml_number_elementrYrGrq_xml_string_element_escape_control_charactersr"r$_xml_rich_inline_stringr_xml_inline_stringrmr@r8r:_xml_formula_elementrlrr(r,r_write_cell_array_formular_write_cell_valuerrrr)r-r,rJrQrrr5row_xfcol_xftype_cell_namerGrrm error_codess r3rkWorksheet._write_cells,C5 J'( ;;{{002H   sHo . MM !dmmC&8&;]]3'*F   sF$8$8$:; < MM !]]3'*F!!!3(<(<(>"?@00 3 3  $ $T[[* = 7 7[[F''((< 88@$$U++0G0G00D 4F;H++FjI y (JJE$**d++!!*-::EEDJJ,, ::#ZZ;.%%j1%%l3  % %dllE F ~ -zzY&!!), 0djj!   Z 0  * *4<< D  " "4:: .   c " w &   Z 0 y (   j )   Z 0  " "4<< 0   c " w &   j )   tTZZ0 1   Z 0  " "4:: .   c " '+ 0!!,/ 0s P**Q Q c2UcSnURSU5 g)Nr^vr)r-rms r3rWorksheet._write_cell_value.s =E sE*r8c4SSU4/nURSX5 g)N)rarrayrsr-r)r-rlrrs r3r#Worksheet._write_cell_array_formula5s!$uj&9:  sG8r8c/nUR(dEUR(d4UR(d#UR(dUR(dgUR(aUR SUR45 UR(aUR S5 UR(d"UR(dUR(aTUR SU5 UR5 UR5 UR5 URS5 gURSU5 g)NcodeName) filterModersheetPr) rrrrrrr_write_tab_color_write_outline_pr_write_page_set_up_prrrrs r3rWorksheet._write_sheet_pr;s  NNNN((%%       z4+<+<= > >>   / 0 ==DNNd.B.B    : 6  ! ! #  " " $  & & (   i (    : 6r8cRUR(dgS/nURSU5 g)N) fitToPager pageSetUpPr)rrrs r3rWorksheet._write_page_set_up_prWs$}} &'  M:6r8clURnU(dgURSUR55 g)NtabColor)r _write_colorrrs r3rWorksheet._write_tab_color_s*  *e&7&7&9:r8c`/nUR(dgUR(aURS5 UR(dURS5 UR(dURS5 UR (dURS5 UR SU5 g)N) applyStylesr) summaryBelowr) summaryRightrr  outlinePr)rrrrrrrrs r3rWorksheet._write_outline_prhs ##       0 1!!   1 2!!   1 2   7 8 K4r8cURUR5nU(dg[U5nSU4SU4/nURSU5 UHnUR US5 M UR S5 g)NrvmanualBreakCount rowBreaksi?)rrrPr _write_brkr)r- page_breaksrvrrOs r3rWorksheet._write_row_breakszsy++DLL9  K e   ' K4"G OOGU +# +&r8cURUR5nU(dg[U5nSU4SU4/nURSU5 UHnUR US5 M UR S5 g)Nrvr colBreaksi)rrrPrrr)r-rrvrrPs r3rWorksheet._write_col_breakssy++DLL9  K e   ' K4"G OOGW -# +&r8c:SU4SU4S/nURSU5 g)Nrjr3)manrbrkr)r-brk_idbrk_maxrs r3rWorksheet._write_brks'Vnug&6 C  E:.r8cURn[U5nU(dgSU4/nURSU5 UHnURU5 M UR S5 g)Nrv mergeCells)rrPr_write_merge_cellr)r-rrvr merged_ranges r3rWorksheet._write_merge_cellss`zz L! &'  L*5(L  " "< 0) ,'r8cxUup#pE[X#5n[XE5nUS-U-nSU4/n URSU 5 g)Nr;rs mergeCell)r%r) r-rrow_minr2row_maxr3r?r@rsrs r3rWorksheet._write_merge_cellsK/;,7#74"74slV#cl^  K4r8cZ[URR55nU(dgURS5 UGHWn[URUR55nUGH&nURUUnUR(a^URU(aJURUU(a3URUUnUR R S:waSUlUR[R[R4;aaU=RS- sl URX$URU5 URRSUR!5S/5 GMUR#X$U5 GM) GMZ UR%S5 g)NrrSTrr External)rGrrrrrrJ_is_object_link _link_typerURLEXTERNALr_write_hyperlink_externalrrr _write_hyperlink_internalr)r-rurOrvrPrrQs r3rWorksheet._write_hyperlinkssV $//..01  L) Gdoog6;;=>H$oog.w7::$**W"5$**W:Mg:V::g.w7D~~..(:.2+>>hllH4E4E%FFNNa'N22$..# --44%s{{}jA 227SI3$  @ ,'r8r,rJid_numrc~[X5nS[U5-nSU4SU4/nUR(aURSUR45 UR(aURSUR 45 UR (aURSUR 45 URSU5 g)NrIdrsr:idrdisplaytooltipr)r%r:rrrrrr)r-r,rJrrrsr_idrs r3r#Worksheet._write_hyperlink_externals)s6{"clVTN3 ;;   z3;;7 8      y#))4 5 88   y#((3 4 K4r8c[X5nSU4SUR4/nUR(aURSUR45 URSUR45 UR SU5 g)Nrsrrrr)r%r"rrrr)r-r,rJrrsrs r3r#Worksheet._write_hyperlink_internal sh)clZ$;< 88   y#((3 49cii01 K4r8cUR(dgSUR4/nUR(a4URSU5 UR5 UR S5 gUR SU5 g)Nrs autoFilter)rrr_write_autofiltersrrrs r3rWorksheet._write_auto_filtersd"" d1123 >>    j 9  # # %   l +    j 9r8cURup[XS-5HFnX0R;aMURUnURUnUR X1- XT5 MH gr)rrrr_write_filter_column)r-col1col2rJrrs r3rWorksheet._write_autofilters+si(( ax(C***%%c*F**3/K  % %cj+ F)r8cSU4/nURSU5 US:XaURU5 OURU5 URS5 g)NcolId filterColumnr)r_write_filters_write_custom_filtersr)r-rrrrs r3rWorksheet._write_filter_column<sS'(  NJ7 !     (  & &w / .)r8cUVs/sH$n[U5R5S:wdM"UPM& nn/n[U5[U5:waS/n[U5S:Xa"[U5S:XaURSU5 gUR SU5 [ U5HnUR U5 M URS5 gs snf)Nr)rdrrrr)r:rzrPrrrG _write_filterr)r-rfilter non_blanksrrts r3rWorksheet._write_filtersKs+2V7c&k6G6G6IX6Uf7 V w<3z? *&J w<1 ZA!5    : 6    : 6$Z0 "":.1   i (!Ws !CCc2SU4/nURSU5 g)Nrrrrs r3rWorksheet._write_filter_scl^  Hj1r8cP[U5S:Xa2URS5 UR"U6 URS5 g/nUSS:XaS/nOS/nURSU5 URUSUS5 URUSUS5 URS5 g) Nr customFiltersr)andr)rrrr_r})rPr_write_custom_filterr)r-rrs r3rWorksheet._write_custom_filterses v;!     0  % %v .   o .JayA~(\ (\     <  % %fQi ;  % %fQi ;   o .r8c/nSSSSSSSS.nXAbXAnO[SU35 US:waURS U45 URS U45 URS U5 g) Nrrrrrr)rrr_r}rFrrzUnknown operator = rr customFilter)r rr)r-rrrrs r3rWorksheet._write_custom_filter|s  #    * *H &xj1 2 w    z84 55#,' NJ7r8c>/nUR(dgURnUS(aURSUS45 US(aURS5 US(aURS5 US(dURS5 US(dURS 5 US (aURS 5 US (aURS 5 US(aURS5 US(aURS5 US(aURS5 US(aURS5 US(aURS5 US(aURS5 US(dURS5 US(aURS5 US(aURS5 US (aURS!5 US"(dURS#5 URS$U5 g)%Nrr)rrr)rrr)rrr)rrr) formatCellsrr) formatColumnsrr) formatRowsrr) insertColumnsrr) insertRowsrr)insertHyperlinksrr) deleteColumnsrr) deleteRowsrr)selectLockedCellsrr)rrrt)rrr) pivotTablesrr)selectUnlockedCellsrsheetProtection)rrr)r-rrs r3r!Worksheet._write_sheet_protections ## && :    z7:+>? @ 7    l + 9    n -y!   n -{#   . / > "   0 1 # $   2 3 = !   / 0 # $   2 3 = !   / 0 & '   5 6 # $   2 3 = !   / 0,-   6 7 6?   k * <   / 0 > "   0 1./   8 9 -z:r8cURS:XagURS5 URHupnURXU5 M UR S5 g)NrprotectedRanges)rrr_write_protected_rangerr s r3r!Worksheet._write_protected_rangessY  $ $ )  -.040E0E ,JH  ' '  I1F +,r8c/nU(aURSU45 URSU45 URSU45 URSU5 g)NrrrmprotectedRangerr)r-rr rrs r3r Worksheet._write_protected_rangesT    z84 57J/06:./ ,j9r8cUR(dgU=RS- slURUR5 gr)rr_write_drawingr s r3rWorksheet._write_drawingss,||  ! DNN+r8cNS[U5-nSU4/nURSU5 g)Nrrrr:r)r-rrrs r3rWorksheet._write_drawings,s:&tn%  Iz2r8cUR(dgU=RS- slS[UR5-nSU4/nURSU5 g)Nrrr legacyDrawing)rrr:rr-rrs r3rWorksheet._write_legacy_drawingsK||  !s4>>**tn%  OZ8r8cUR(dgU=RS- slS[UR5-nSU4/nURSU5 g)NrrrlegacyDrawingHF)rrr:rrs r3r"Worksheet._write_legacy_drawing_hfsN""  !s4>>**tn%  -z:r8cUR(dgU=RS- slS[UR5-nSU4/nURSU5 g)Nrrrpicture)rrr:rrs r3rWorksheet._write_picture sM$$  !s4>>**tn%  Iz2r8cURn[U5nU(dgSU4/nURSU5 UHnURU5 M UR S5 g)NrvdataValidations)rrPr_write_data_validationr)r-rrvr validations r3r!Worksheet._write_data_validationssd&& K  &'  -z:%J  ' ' 3& +,r8c\Sn/nUSH0nUS:waUS- nUupVpxXW:aXupuXh:aXpU[XVXx5- nM2 URS5(aUSnUSS:wa5URSUS45 USS :waURS US45 S U;a4US S :XaURS 5 US S:XaURS5 US(aURS5 US(dURS5 US(aURS5 US(aURS5 SU;aURSUS45 SU;aURSUS45 SU;aURSUS45 SU;aURSUS45 URS U45 USS:XaURS!U5 gUR S!U5 UR US"5 US#bUR US#5 URS!5 g)$Nr^rrfrrrrArrrrr) errorStylerr)r+rr) allowBlankrr) showDropDownrr)showInputMessagerr)showErrorMessagerr errorTitlerrr promptTitlerpromptrdataValidationrmr)r$rrrr_write_formula_1_write_formula_2r) r-rrrr row_firstrrow_lastrs r3r' Worksheet._write_data_validation(sg W%E{ 9> 6Y8#)1H#)1H XiHG GE& ;;} % %M*E : & (   vwz':; <z"i/!!:wz/B"CD 7 "|$)!!";<|$)!!"?@ > "   / 0z"   1 2 <   5 6 <   5 6 G #   |W]-CD E g %   w(@A B G #   }gm.DE F g %   x)AB C7E*+ : & (    0* =    0* =  ! !''"2 3y!-%%gi&89   . /r8c[U[5(aUR"U6nSUS3nO [U5 URSU5 g![a* UR S5(aUR S5nNFf=f)Nrrformula1)r@rrr(r,r"rLrr-rls r3r4Worksheet._write_formula_1us{ gt $ $nng.G'!nG 2g z73  2%%c**%nnS1G 2s A 1A?>A?c[U5 UR SU5 g![a* URS5(aURS5nNFf=f)Nrformula2r(r,r"rLrr;s r3r5Worksheet._write_formula_2sQ . 'N z73  .!!#&&!..- . 1AAc[URR55nU(dgUH!nURX RU5 M# gr)rGrr_write_conditional_formatting)r-r cond_ranges r3r$Worksheet._write_conditional_formatssG))..01  J  . .--j9 !r8cSU4/nURSU5 UHnURU5 M URS5 g)NrconditionalFormatting)r_write_cf_ruler)r-rDparamsrparams r3rC'Worksheet._write_conditional_formattingsI +,  3Z@E    & 12r8c SUS4/nSU;aUSbURSUS45 URSUS45 URS5(aURS5 USS:XaURSUS 45 URS U5 S U;a/S U;a)URUS 5 URUS 5 OURUS 5 UR S 5 gUSS:Xa[ R "SUS 5(aURS5 [ R "SUS 5(aURS5 [ R "SUS 5(a<[ R "SUS 5nURSURS545 URS U5 gUSS:XakS U;aUS S:XaURS5 SU;aURS5 US =(d SnURSU45 URS U5 gUSS:XaURS U5 gUSS:XaURS U5 gUSS :XdUSS!:XdUSS":Xd USS#:XadURSUS 45 URS$US 45 URS U5 URUS%5 UR S 5 gUSS&:XaNURS&US 45 URS U5 URUS%5 UR S 5 gUSS':XdUSS(:XdUSS):Xd USS*:Xa8URS U5 URUS%5 UR S 5 gUSS+:Xa5URS U5 URU5 UR S 5 gUSS,:Xa\URS U5 URU5 URS-5(aURU5 UR S 5 gUSS.:Xa8URS U5 URUS 5 UR S 5 gUSS/:Xa5URS U5 URU5 UR S 5 gg)0NrArPdxfIdr:r) stopIfTruerrrrcfRulerrrmrbelow)rrr) equalAveragerz [123] std devz([123]) std devrtrrr)rrr)rrrrankrrrr<r r rrlrrrrrr>rr;rr) rrr_write_formula_elementrr%rsgroupr_write_color_scale_write_data_bar_write_data_bar_ext_write_icon_set)r-rIrr&rRs r3rHWorksheet._write_cf_rulesvf~./ v &"2">   wx(89 ::vj'9:; ::n % %   / 0 &>X %   z6*+=> ?   * 5F"yF':++F9,=>++F9,=>++F7O<   h ' F^~ -yy&"455!!"56yy&"455!!"56yy&*<== "3VJ5GH!!8U[[^"<=   * 5 F^w &V#z(:c(A!!.1f$!!-0'?(bD   vtn -   * 5 F^0 0   * 5 F^~ -   * 5 6Nn ,f~!22f~-f~+   z6*+=> ?   vvg7 8   * 5  ' 'y(9 :   h ' F^| +   |VJ-?@ A   * 5  ' 'y(9 :   h ' 6N. .f~!44f~!11f~!44   * 5  ' 'y(9 :   h ' F^| +   * 5  # #F +   h ' F^y (   * 5   (zz,--((0   h ' F^| +   * 5  ' 'z(: ;   h ' F^y (   * 5   (   h ')r8c[U5 UR SU5 g![a* URS5(aURS5nNFf=f)Nrrlr?r;s r3rS Worksheet._write_formula_elementsQ . 'N y'2  .!!#&&!..- .rAcURS5 URUSUS5 USbURUSUS5 URUSUS5 URSUS R55 US b#URSUS R55 URSUS R55 UR S5 g) Nr>rrrrrrrrrr)r _write_cfvorrr)r-rJs r3rUWorksheet._write_color_scale!s L) z*E+,>?   (   U:.k0B C z*E+,>? '5#5#A#A#CD   )   gu['9'E'E'G H '5#5#A#A#CD ,'r8c/nSU;aURSUS45 SU;aURSUS45 URS5(aURS5 URSU5 URUSUS 5 URUS US 5 UR S US R 55 UR S5 g)Nr minLengthr maxLengthr showValuerrrrrrrr)rrrr]rrr)r-rJrs r3rVWorksheet._write_data_bar6s  5   {E,,?@ A 5   {E,,?@ A 99Z   . / Iz2 z*E+,>? z*E+,>? '5#5#A#A#CD )$r8cHURS-n[UR5S-nSX#4-nXAS'URRU5 UR S5 UR S5 UR SU5 URS5 URS5 g)Nrz{DA7ABA51-AAAA-BBBB-%04X-%012X}guidextLstz&{B025F937-C7B1-47D3-B67F-A62EFF666E3E}zx14:idext)rnrPrrr _write_extrr)r-rJworksheet_countdata_bar_countrfs r3rWWorksheet._write_data_bar_extMs**q.T001A50O3TTf  ""5) H% @A x. %  (#r8cn/nUSS:waSUS4/nURS5(aURS5 URS5(aURS5 URSU5 [US5HnUR US US US 5 M! UR S5 g) Nrr*rrrbr)rrrrArmr)rrrreversedr]r)r-rJricons r3rXWorksheet._write_icon_set_s   "2 2$eL&9:;J 99\ " "   . / 99_ % %   n - Iz2U7^,D   T&\4=$z:J K- )$r8cSU4/nUbURSU45 U(aURS5 URSU5 g)NrAr)gtercfvor)r-cf_typerrrs r3r]Worksheet._write_cfvousGw'( ?   ucl +    j ) FJ/r8c&URX5 grrrs r3rWorksheet._write_colors D-r8cHURHnUR"U6 M gr)r_write_selection)r- selections r3rWorksheet._write_selectionssI  ! !9 -)r8c/nU(aURSU45 U(aURSU45 U(aURSU45 URSU5 g)Nr activeCellrrzr)r-rrrrs r3ryWorksheet._write_selectionsX    vtn -    |[9 :    w. / K4r8c|URnU(dgUSS:XaUR"U6 gUR"U6 g)Nr}r)r_write_split_panes_write_freeze_panes)r-rs r3rWorksheet._write_paness8   8q=  # #U +  $ $e ,r8c>/nUnUn[X45n Sn Sn Sn Sn UR(aURSupn /UlU(azU(asSn [US5n[SU5nURRSUU/5 URRSX/5 URRSX/5 OFU(a Sn URRSX/5 OSn URRSX/5 US:XaSn O US:XaSn OS n U(aURS U45 U(aURS U45 URS U 45 URS U 45 URSU 45 URSU5 g)Nr^r bottomRighttopRight bottomLeftfrozenr frozenSplitr=xSplitySplitr activePanestater)r%rrr)r-r,rJrrrry_splitx_splitrrrrrrKrow_cellcol_cells r3rWorksheet._write_freeze_paness )'<    ??&*ooa&8 #QU DO 3'K(a0H(C0H OO " "J(#C D OO " "L(#E F OO " "M;#F G $K OO " "J #C D'K OO " "L+#E F >E !^!EE    x1 2    x1 2=-89<567E*+ FJ/r8c/nSnSnSn Sn Un Un UR(aURSupYn /UlSnU (a[SU -S-5n U (aURU 5n X1:Xa9XB:Xa4[SU S- S- S- -5n[SU S - S- S - S -S - -5n[X45n U(dU n U n U(ayU(arS n[US5n[SU5nURR SX/5 URR SX/5 URR S X/5 OFU(a SnURR SX/5 OSnURR SX/5 U (aUR SU S45 U (aUR SU S45 UR SU 45 U(aUR SU45 UR SU5 g)NFr^rTrei,rrdr_r}rgrrrrrrrrr)rr+_calculate_x_split_widthr%rr)r-r,rJrrrKr has_selectionrrrrrrrrs r3rWorksheet._write_split_paness     ??&*ooa&8 #QU DO M "w,,-G 33Gho#3" 4r 99:G3'C-2!5!9A!=!BBCH)'< 'K!E 3'K(!4H(H5H OO " "J#C D OO " "L(#E F OO " "M;#F G $K OO " "J #C D'K OO " "L+#E F    xGD>; <    xGD>; <=-89    |[9 : FJ/r8cSnSnUS:a[XU--S-5nO[X-S-5U-nUS-S- nUS-nUS-nU$) Nr2rFrrr_r}rer)r+)r-r5rXrYrZpointstwipss r3r"Worksheet._calculate_x_split_width$so 19G";> 2 ,'r8cNS[U5-nSU4/nURSU5 g)Nrr tablePartrrs r3rWorksheet._write_table_partTs8s4y    K4r8c[UR5n[UR5nU(dU(dgURS5 U(aUR 5 U(aUR 5 UR S5 g)Nrg)rPrrr_write_ext_list_data_bars_write_ext_list_sparklinesr)r- has_data_barshas_sparkliness r3rWorksheet._write_ext_listbsdD//0 T__-^  H%   * * ,   + + - (#r8cURS5 URS5 URHnURU5 M UR S5 UR S5 g)Nz&{78C0D931-6437-407d-A8EE-F0AAD7539E65}zx14:conditionalFormattingsrh)rirr"_write_conditional_formatting_2010r)r-rs r3r#Worksheet._write_ext_list_data_barsus] @A 89++H  3 3H =, 67 % r8clSnSU4/nURSU5 URU5 URU5 URUSUS5 URUSUS5 US(dUR US 5 US (dUR US 5 US(dUS (dUR US 5 USS:waURUS5 URS5 URS5 URSUS5 URS5 g)N3http://schemas.microsoft.com/office/excel/2006/mainxmlns:xmzx14:conditionalFormattingrBrrDrrrrrrrrrr x14:dataBar x14:cfRulexm:sqrefr) 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 r3r,Worksheet._write_conditional_formatting_2010sCH!8,-  7D )   * Xn5x 7LM Xn5x 7LM(  ( (2D)E F12  / /9M0N O)=>  1 1(;V2W X ' (F 2  & &x0@'A B -( ,' z8G+<= 56r8cFSnUSnSU4SU4/nURSU5 g)NrrfrArjrr)r-r rule_typerfrs r3rWorksheet._write_x14_cf_rules4 y)D$<8  L*5r8cSnSnSU4SU4/nUS(dURS5 US(aURS5 US S :XaURS 5 US S :XaURS 5 US(aURS5 US(dUS(dURS5 USS:XaURS5 USS:XaURS5 URSU5 g)Nrrcr`rar)borderrr)gradientrrr2)r leftToRightr3)rrr)negativeBarColorSameAsPositiverr)$negativeBarBorderColorSameAsPositiverrmiddle) axisPositionrr)rrr)rr)r-rrrrs r3rWorksheet._write_x14_data_bars  * % * % (   m , K   o . O $ .   : ; O $ /   : ; - .   C D)=>   I J ' (H 4   8 9 ' (F 2   6 7 M:6r8cSU4/nUS;aURSU5 gURSU5 URSU5 URS5 g)NrA)r4r3rArCzx14:cfvoxm:f)rrrr)r-rrmrs r3rWorksheet._write_x14_cfvosVy)* < <    J 7    J 7  " "65 1   j )r8cDURSUR55 g)Nzx14:borderColorrrrs r3r!Worksheet._write_x14_border_colors +U->->-@Ar8cDURSUR55 g)Nzx14:negativeFillColorrrrs r3r(Worksheet._write_x14_negative_fill_colors 3U5F5F5HIr8cDURSUR55 g)Nzx14:negativeBorderColorrrs r3r*Worksheet._write_x14_negative_border_colors 5u7H7H7JKr8cDURSUR55 g)Nz x14:axisColorrrs r3rWorksheet._write_x14_axis_colors OU->->-@Ar8cURS5 UR5 [UR5HnUR U5 UR US5 UR US5 UR5 URUS5 URUS5 URUS5 URUS5 URUS5 US (aURS US 5 URU5 URS 5 M URS 5 URS 5 g)Nz&{05C60535-1F16-4fd2-B633-F4F36F0B64E0}rrrrrrrrrx14:sparklineGroupx14:sparklineGroupsrh)ri_write_sparkline_groupsrnr_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-rs r3r$Worksheet._write_ext_list_sparkliness= @A $$&"$//2I  ' ' 2  $ $Y~%> ?  & &y1A'B C  " " $  % %i&@ A  # #Im$< =  " "9\#: ;  " "9\#: ;  ! !)K"8 9%&&vy/EF  " "9 -   2 3C3F /0 % r8cURS5 [US5HYnUSUnUSUnURS5 URSU5 URSU5 URS5 M[ URS5 g)Nzx14:sparklinesrvrrz x14:sparklinerr)rrrr)r-rrrrs r3rWorksheet._write_sparklines(s ,-y)*A#H-a0K -a0H    0  " "6; 7  " ":x 8   o .+ *+r8cFSnUS-nSU4SU4/nURSU5 g)Nz$http://schemas.microsoft.com/office/zspreadsheetml/2009/9/mainz xmlns:x14urirhr)r-rr xmlns_x14rs r3riWorksheet._write_ext9s<788 ) $ CL E:.r8c6SnSU4/nURSU5 g)Nrrrr)r-rrs r3r!Worksheet._write_sparkline_groupsEs%H!8,-  1:>r8cURS5n/nURS5b*USS:XaSUS'OURSUS45 SUS'URS5b*USS:XaSUS'OURS US45 SUS'US S :waURS US 45 URS 5(aURS US 45 URS5(aURS5 U(aURSU45 URS5(aURS5 URS5(aURS5 URS5(aURS5 URS5(aURS5 URS5(aURS5 URS5(aURS5 URS5(aURS5 URS5(aURS 5 URS5(aURS!US45 URS5(aURS"US45 URS#5(aURS$5 URS%U5 g)&Nrr3rTcust_max manualMaxrr4cust_min manualMinrArr lineWeightr)dateAxisrdisplayEmptyCellsAsr)rrr)rrr)rrr)rrr)rrr)rrr) displayXAxisrr) displayHiddenr minAxisType maxAxisTyperrr)rrr)r-rrrs r3r Worksheet._write_sparkline_groupMs0 G$ ;;u  )u~(&- #!!;"?@&. # ;;u  )u~(&- #!!;"?@&. # 6?f $   vwv7 8 ;;x   |WX->? @ ;;{ # #   o .    4e< = ;;y ! !   n - ;;v     k * ;;u     j ) ;;w     l + ;;v     k * ;;z " "   o . ;;v     1 2 ;;x   2 3 ;;z " "   }gj.AB C ;;z " "   }gj.AB C ;;y ! !   0 1 0*=r8cRU(a URXR55 ggrr)r-tagrs r3_write_spark_colorWorksheet._write_spark_colors!    c#4#4#6 7 r8c(URSU5 g)Nzx14:colorSeriesrrs r3rWorksheet._write_color_seriess  159r8c(URSU5 g)Nzx14:colorNegativerrs r3rWorksheet._write_color_negatives  3U;r8c:URS[S55 g)Nz x14:colorAxisrE)rr r s r3rWorksheet._write_color_axiss y1ABr8c(URSU5 g)Nzx14:colorMarkersrrs r3rWorksheet._write_color_markerss  2E:r8c(URSU5 g)Nzx14:colorFirstrrs r3rWorksheet._write_color_firsts  0%8r8c(URSU5 g)Nz x14:colorLastrrs r3rWorksheet._write_color_last 7r8c(URSU5 g)Nz x14:colorHighrrs r3rWorksheet._write_color_highr r8c(URSU5 g)Nz x14:colorLowrrs r3rWorksheet._write_color_lows 6r8c0SS/nURSU5 g)N)fontId0)rA noConversion phoneticPrrrs r3rWorksheet._write_phonetic_prs#  $ L*5r8cUR(dgURS5 URRS5(a!URSnURSU5 URRS5(a!URSnURSU5 URRS5(a!URSnURSU5 URRS5(a!URSnURS U5 URRS 5(a!URS nURS U5 URRS 5(a!URS nURS U5 URRS5(a!URSnURSU5 URRS5(a!URSnURSU5 URRS5(a!URSnURSU5 UR S5 g)N ignoredErrorsrnumberStoredAsTextr evalErrorrrlr formulaRangerunlockedFormularemptyCellReferencerlistDataValidationrcalculatedColumnrtwoDigitTextYear)rrr_write_ignored_errorr)r- ignored_ranges r3rWorksheet._write_ignored_errorss-""  O,    " "#: ; ; //0GHM  % %&:M J    " "< 0 0 // =M  % %k= A    " "#4 5 5 //0ABM  % %i ?    " "? 3 3 //@M  % %nm D    " "#5 6 6 //0BCM  % %&7 G    " "#9 : : //0FGM  % %&:M J    " "#9 : : //0FGM  % %&:M J    " "#6 7 7 //0CDM  % %&8- H    " "#8 9 9 //0EFM  % %&8- H /*r8c8SU4US4/nURSU5 g)Nrr ignoredErrorr)r-rrrs r3rWorksheet._write_ignored_error s,m $ O NJ7r8)rrrrrrrrrrrrrrrrqrrr rrr rrrrr r~r}r|r{rrrrrrrrwrvrtrrrrrrrrurrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrnrsrrrrrrrrrrrrrmrrrrrrrrrrrrrrrrrprrrrrrrrrrrrr rrrrrrrrrrrrrrrrrrrrorrrrrrrrrrrrrrrrrrrrrrrr rrrryrxrzrrrre)F)Nrrz)NNN)i)NF)rr)rrrr)NNr)NN)rc)r^N)r)r`r`rara)r^NN)FF)r)rJ __module__ __qualname____firstlineno____doc__rlr.r7r4r2rIr*rZr)rer!rnr#rFrrtrv staticmethodrrurr?rr9rr'rrrrrrrrrr rrrrrr!r%r)r-rNr8r<rYr^rbrfrmrtrrrrTrrrrrrrrrrrrr rrrrr"r%r(r+r/r4rMrUrXr[r_rbrerhrkrnrrrvryr~rrrrrrOrrqrr~rrrrrr+r+r3r8r<rCrrFrSrTr;rarrirrlryr|rr|rrrrr#r6rrrrrrrHrrrrrrr'rrrrrrr^r_r9rRrirjrlrkrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr'r4r5rrCrHrSrUrVrWrXr]rrryrrrrrrrrrrrrrrrrrrrirrrrrrrrrrrrrr__static_attributes__ __classcell__)rs@r3rZrZsY$x$3L,,&SJjAA&6AA$B??&$JJ*@* * X))Zrn**H4lAA$*CC$6HH*9v88.wr 7,,>**X11fDDLB %2 & 5$"  4$IM;;zIMQQ0SNj8t?((.JNJJX'E'ER:x(T@@D@DvvpSSj }}~ 7 7D99$GH$0>>,66"$ %  21(f D!!FCCF ' '   +  $&M'^M'^74774&0 * $@ ''$ %', '  >"(^,'\bHBY&P4B=:U!n" L4L4L4 L4\C4J.$ 8 t VH\V|<* &z&3j 2:G3j( $(5'n 5= 6+ '=J5(!9F(99v90&"PB/H++0 7L5\82<(99&QP#J)V5=n@t#l+9 787;5$'*'*/ ($ 50(d5S5s5C5c5$ 5S 5s 5 5:"G" *)(2 /.86.;` - :,3 9 ; 3-$K0Z4" 4 3j(X 3(*%.$$%, 0.. 5 -60pE0N.(2 5$& !+7Z6%7N *BJLB,!\," /?W>r8 :<C;98876++Z88r8rZ)Ir;r_rr%r collectionsrrrr fractionsr functoolsrior r r warningsr xlsxwriter.colorr xlsxwriter.commentsrxlsxwriter.imagerxlsxwriter.urlrrxlsxwriter.vmlrr^rrrrr exceptionsrrrPrr2rutilityrrrrr r!r"r#r$r%r&r'rVERBOSErrr7rFrNrhrrarSrrwrrrrZr`r8r3r8s* /"+"(%77<    !jj<JJ? P0@@GX.G%;<X'78X'78i):;i)ABz+;< /KL":A}8 ##A}8r8