J]c@sGddlZddlZddlZddlZddlmZddlmZddlmZm Z m Z m Z ddl m Z ddlmZmZmZmZddlmZdd lmZdd lmZdd lmZdd lmZdd lmZddlm Z ddl!m"Z"ddl#m$Z$ddl%m&Z&ddl'm(Z(ddl)m*Z*ddl+m,Z,ddl-m.Z.ddl/m0Z0ddl1m2Z2ddl3m4Z4ddl3m5Z5ddl3m6Z6ddl3m7Z7ddl3m8Z8ddl3m9Z9ddl3m:Z:dej;fd YZ<d!e=fd"YZ>dS(#iN(twarn(tdatetime(tZipFiletZipInfot ZIP_DEFLATEDt LargeZipFile(tunpacki(t int_typest num_typest str_typest force_unicode(t xmlwriter(t Worksheet(t Chartsheet(tSharedStringTable(tFormat(tPackager(txl_cell_to_rowcol(t ChartArea(tChartBar(t ChartColumn(t ChartDoughnut(t ChartLine(tChartPie(t ChartRadar(t ChartScatter(t ChartStock(tInvalidWorksheetName(tDuplicateWorksheetName(tReservedWorksheetName(tUndefinedImageSize(tUnsupportedImageFormat(tFileCreateError(t FileSizeErrortWorkbookcBsEeZdZeZeZd:d:dZdZ dZ d:d:dZ d:d:dZ d:dZ dZedZd Zd Zd:d Zd Zd:d Zd:dZdZdZdZdZdZd:dZdZdZd:dZedZ dZ!dZ"dZ#dZ$dZ%dZ&dZ'd Z(d!Z)d"Z*d#Z+d$Z,d%Z-d&Z.d'Z/d(Z0d)Z1d*Z2d+Z3d,Z4d-Z5d.Z6d/Z7d0Z8d1Z9d2Z:d3Z;d4Z<d5Z=d6Z>d7Z?d8Z@d9ZARS(;s= A class for writing the Excel XLSX Workbook file. cCs{|dkri}ntt|j||_|jdd|_|jdt|_|jdt|_ |jdt |_ |jdt |_ |jdt|_ |jdd|_|jdt|_|jd t|_|jd t|_|jd t|_|jd i|_t|_d |_d |_d|_d |_d|_d|_d |_d |_g|_g|_g|_ i|_!g|_"g|_#i|_$g|_%i|_&g|_'d |_(d |_)g|_*g|_+g|_,i|_-g|_.t/j0|_1d |_2d |_3d|_4d|_5d|_6d|_7d|_8t9|_:d|_;t|_<d|_=i|_>g|_?d |_@d |_Ad |_Bd|_Ct |_Dt|_Ed|_F|jrt|_n|jr|jGid d6d d6n|jGid d6|jGit d6|_H|jdk rw|jGi|jd6|_ndS(s Constructor. ttmpdirt date_1904tstrings_to_numberststrings_to_formulaststrings_to_urlstnan_inf_to_errorstdefault_date_formattconstant_memoryt in_memorytexcel2003_styletremove_timezonetdefault_format_propertiesitSheettChartiii>i%iXtautoigtxf_indext font_familyt hyperlinkt num_formatN(ItNonetsuperR"t__init__tfilenametgetR#tFalseR$R%tTrueR&R'R(R)R*R+R,R-R.t WorksheetMetatworksheet_metatselectedt fileclosedt filehandlet internal_fht sheet_namet chart_nametsheetname_counttchartname_counttworksheets_objstchartstdrawingst sheetnamestformatst xf_formatstxf_format_indicest dxf_formatstdxf_format_indicestpalettet font_counttnum_format_countt defined_namest named_rangest custom_colorstdoc_propertiestcustom_propertiesRtutcnowt createtimet num_vml_filestnum_comment_filestx_windowty_windowt window_widtht window_heightt tab_ratioRt str_tablet vba_projectt vba_is_streamt vba_codenamet image_typestimagest border_countt fill_countt drawing_countt calc_modet calc_on_loadt allow_zip64tcalc_idt add_formattdefault_url_format(tselfR9toptions((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyR8=s                                                    cCs|S(s0Return self object to use with "with" statement.((Rp((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyt __enter__scCs|jdS(s-Close workbook when exiting "with" statement.N(tclose(Rpttypetvaluet traceback((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyt__exit__scCs+|dkr|j}n|j|d|S(s Add a new worksheet to the Excel workbook. Args: name: The worksheet name. Defaults to 'Sheet1', etc. Returns: Reference to a worksheet object. tworksheet_classN(R6Rxt _add_sheet(RptnameRx((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyt add_worksheets  cCs+|dkr|j}n|j|d|S(s Add a new chartsheet to the Excel workbook. Args: name: The chartsheet name. Defaults to 'Sheet1', etc. Returns: Reference to a chartsheet object. RxN(R6tchartsheet_classRy(RpRzR|((s2lib/python2.7/site-packages/xlsxwriter/workbook.pytadd_chartsheets  cCsx|jj}|jr6idd6dd6dd6}n|rL|j|nt||j|j}|jj||S( s Add a new Format to the Excel Workbook. Args: properties: The format properties. Returns: Reference to a Format object. tArialt font_namei t font_sizeiitthemei( R.tcopyR,tupdateRRMRORKtappend(Rpt propertiestformat_propertiest xf_format((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyRns    cCs|jd}|dkr)tddS|dkrDt|}n|dkr_t|}n|dkrzt|}n|dkrt|}n|dkrt|}n~|d krt|}nc|d krt |}nH|d krt |}n-|d krt |}ntd |dSd|krJ|d|_ nt |_|j|_|j|_|jj||S(s Create a chart object. Args: options: The chart type and subtype options. Returns: Reference to a Chart object. Rts)Chart type must be defined in add_chart()Ntareatbartcolumntdoughnuttlinetpietradartscattertstocks&Unknown chart type '%s' in add_chart()Rz(R:R6RRRRRRRRRRRDR<tembeddedR$R-RHR(RpRqt chart_typetchart((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyt add_charts>                cCsc| r2tjj| r2tdt|dS|jdkrMd|_n||_||_dS(s Add a vbaProject binary to the Excel workbook. Args: vba_project: The vbaProject binary file name. is_stream: vba_project is an in memory byte stream. Returns: Nothing. s'VBA project binary file '%s' not found.it ThisWorkbookN( tostpathtexistsRR RdR6RbRc(RpRbt is_stream((s2lib/python2.7/site-packages/xlsxwriter/workbook.pytadd_vba_projects   cCsg|jscy|jWn=tk r8}t|ntk rV}tdnXt|_ndS(s Call finalization code and close file. Args: None. Returns: Nothing. sBFilesize would require ZIP64 extensions. Use workbook.use_zip64().N(R@t_store_workbooktIOErrorR RR!R<(Rpte((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyRs)s cCsV|r t|dd|_n d|_|rIt|dd|_n d|_dS(s Set the size of a workbook window. Args: width: Width of the window in pixels. height: Height of the window in pixels. Returns: Nothing. ii`i>i%N(tintR^R_(Rptwidththeight((s2lib/python2.7/site-packages/xlsxwriter/workbook.pytset_size@s  cCsP|dkrdS|dks(|dkr9td|nt|d|_dS(s Set the ratio between worksheet tabs and the horizontal slider. Args: tab_ratio: The tab ratio, 0 <= tab_ratio <= 100 Returns: Nothing. Niids-Tab ratio '%d' outside: 0 <= tab_ratio <= 100i (R6RRR`(RpR`((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyt set_tab_ratioWs cCs ||_dS(s Set the document properties such as Title, Author etc. Args: properties: Dictionary of document properties. Returns: Nothing. N(RV(RpR((s2lib/python2.7/site-packages/xlsxwriter/workbook.pytset_propertiesjs cCs4|d ks|d kr&tddS|d krt|trJd}qt|trbd}qt|trzd}qt|trd}qd}n|dkr|jd}n|dkrt|d krtd t |nt|d krtd t |n|j j |||fd S( s' Set a custom document property. Args: name: The name of the custom property. value: The value of the custom property. property_type: The type of the custom property. Optional. Returns: Nothing. sGThe name and value parameters must be non-None in set_custom_property()itbooltdatet number_inttnumberttexts%Y-%m-%dT%H:%M:%SZisbLength of 'value' parameter exceeds Excel's limit of 255 characters in set_custom_property(): '%s'saLength of 'name' parameter exceeds Excel's limit of 255 characters in set_custom_property(): '%s'N( R6Rt isinstanceRRRRtstrftimetlenR RWR(RpRzRut property_type((s2lib/python2.7/site-packages/xlsxwriter/workbook.pytset_custom_propertyws,         cCsO||_|dkr!t|_n|dkr9d|_n|rK||_ndS(s Set the Excel calculation mode for the workbook. Args: mode: String containing one of: * manual * auto_except_tables * auto Returns: Nothing. tmanualtauto_except_tablest autoNoTableN(RjR;RkRm(RptmodeRm((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyt set_calc_modes     cCstd}d}|jdr-|jd}ntjd}|j|}|r|jd}|jd}|j|}|dkrtdt |dSnd}tjd|tj  stjd |rtd t |dStjd |rtd t |dStjd |s<tjd|rTtdt |dS|j j |||t gdS(s Create a defined name in the workbook. Args: name: The defined name. formula: The cell or range that the defined name refers to. Returns: Nothing. tt=s ^(.*)!(.*)$iis)Unknown sheet name '%s' in defined_name()is^[\w\\][\w\\.]*$s^\ds0Invalid Excel characters in defined_name(): '%s's"^[a-zA-Z][a-zA-Z]?[a-dA-D]?[0-9]+$s3Name looks like a cell name in defined_name(): '%s's^[rcRC]$s^[rcRC]\d+[rcRC]\d+$s6Invalid name '%s' like a RC cell ref in defined_name()N(R6t startswithtlstriptretcompiletmatchtgroupt_get_sheet_indexRR tUNICODERSRR;(RpRztformulat sheet_indext sheetnamet sheet_partsR((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyt define_names< cCs|jS(s Return a list of the worksheet objects in the workbook. Args: None. Returns: A list of worksheet objects. (RG(Rp((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyt worksheetss cCs|jj|S(s Return a worksheet object in the workbook using the sheetname. Args: name: The name of the worksheet. Returns: A worksheet object or None. (RJR:(RpRz((s2lib/python2.7/site-packages/xlsxwriter/workbook.pytget_worksheet_by_names cCs|jS(s Get the default url format used when a user defined format isn't specified with write_url(). The format is the hyperlink style defined by Excel for the default theme. Args: None. Returns: A format object. (Ro(Rp((s2lib/python2.7/site-packages/xlsxwriter/workbook.pytget_default_url_formats cCs t|_dS(s Allow ZIP64 extensions when writing xlsx file zip container. Args: None. Returns: Nothing. N(R<Rl(Rp((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyt use_zip64$s cCs%|dk r||_n d|_dS(s Set the VBA name for the workbook. By default the workbook is referred to as ThisWorkbook in VBA. Args: name: The VBA name for the workbook. Returns: Nothing. RN(R6Rd(RpRz((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyt set_vba_name1s  cCsu|j|j|j|j|j|j|j|j|j|j d|j dS(Ntworkbook( t_prepare_format_propertiest_xml_declarationt_write_workbookt_write_file_versiont_write_workbook_prt_write_book_viewst _write_sheetst_write_defined_namest_write_calc_prt _xml_end_tagt _xml_close(Rp((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyt_assemble_xml_fileHs          c Csy%t|jddtd|j}Wntk r@}|nXt}|jsc|jn|jj dkrd|j d_ d|j d_ nx5|jD]'}|j |jj krd|_qqW|jrx3|jD]"}|jdkr|jqqWn|j|j|j|j|j|j|j||j|j|j|j|j}d}x)t|D]\}}|\}} } |jrt | d } |j!| _"| r|j#| |j$q|j#| |j$j%dqt&j'd } t(j)|| | fy!|j*|| t(j+|Wqt,k r}x6t-|t.|dD]} t(j+|| dqW|qXqW|j/dS( Ntwt compressiont allowZip64iiisutf-8ii(iiiiii( iiiiiiiii(0RR9RRlRRRR{R>t activesheetRGR?thiddentindextactiveRbRdR6Rt_prepare_sst_string_datat _prepare_vmlt_prepare_defined_namest_prepare_drawingst_add_chart_datat_prepare_tablest _add_workbookt _set_tmpdirR#t_set_in_memoryR+t_create_packaget enumerateRRt compress_typetwritestrtgetvaluetencodettimetmktimeRtutimetwritetremoveRtrangeRRs(Rpt xlsx_fileRtpackagertsheett xml_filestfile_idt file_datat os_filenamet xml_filenamet is_binarytzipinfot timestampti((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyRls`                 cCs |r|}n |j}t|j}|j|t|t}i|d6|d6|jd6|jd6|jd6|j d6|j d6|j d6|j d 6|j d 6|jd 6|jd 6|jd 6|jd6|jd6}|j||jj|||j|<|S(NRzRRaR>R*R#R$R%R&R'R(R)RoR,R-(RxRRGt_check_sheetnameRR RaR>R*R#R$R%R&R'R(R)RoR,R-t _initializeRRJ(RpRzRxt worksheetRt init_data((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyRys2                 cCshtjd}|r'|jd7_n|jd7_|dksN|dkr|rm|jt|j}q|jt|j}nt|dkrt d|n|j |rt d|n|j ds|j drt d|n|j d krtd nxB|jD]4}|j |jj kr,td |q,q,W|S( Ns [\[\]:*?/\\]iRis.Excel worksheet name '%s' must be <= 31 chars.s4Invalid Excel character '[]:*?/\' in sheetname '%s'.t's7Sheet name cannot start or end with an apostrophe "%s".thistorys-Worksheet name 'History' is reserved by Excels5Sheetname '%s', with case ignored, is already in use.(RRRFRER6RDtstrRCRRtsearchRtendswithtlowerRRRzR(RpRt is_chartsheett invalid_charR((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyRs:    cCs6|j|j|j|j|jdS(N(t_prepare_formatst_prepare_fontst_prepare_num_formatst_prepare_borderst_prepare_fills(Rp((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyR#s     cCsg}g}xO|jD]D}|jdk r;|j|n|jdk r|j|qqWdgt||_dgt||_x$|D]}|j}||j|R(RRRHRftshapest header_imagest footer_imagesR;R<Rt_prepare_chartt_get_image_propertiest_prepare_imaget_prepare_shapet_prepare_header_imagetdrawingRIRRBRtsortedRi(Rpt chart_ref_idt image_ref_idt drawing_idRt chart_countt image_countt shape_counttheader_image_counttfooter_image_countt has_drawingRR9t image_datat image_typeRRRztx_dpity_dpitpositionRLR((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyRGsl    $ $  $   cCsd}d}d}d}|s<t|d}|j}n |j}tjj|} td|dd!d} td|d d} td |d d} td |d d} td |d d !d}d}d}d}| |krt|jd<|j |\}}}}}n| dkrYt|jd<|j |\}}}}}n| |krt|jd<|j |\}}}n| dkrt|jd<|j |\}}}}}nV| dkr ||kr t|jd<|j |\}}}}}ntd|| s+| r>td|n|jj|||g|sj|jn|dkrd}n|dkrd}n|||| ||fS(Nii`trbt3siis>Hit2ssIii itbiig F%u?Rb(RR;RR<(RpRptoffsett data_lengtht end_markerRRRYRZt marker_ihdrt marker_physt marker_iendtlengthtmarkert x_densityt y_densitytunits((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyRjs8 "" "% """   cCsd}t|}t}d}d}d}d}x| r ||kr td||d|d!d} td||d|d!d} | d@dkr| dkr| d kr| d krtd||d |d !d}td||d |d !d}n| dkrtd||d|d!d} td||d|d!d} td||d|d!d} | dkr| }| }n| dkr| d}| d}n|dkrd}n|dkrd}qn| dkrt}q3n|| d}q3Wd||||fS(Niii`s>Hiiiiiiiii iRzi i iiigRQ@iRc(RR;RR<(RpRpR{R|R}RRRYRZRRRRR((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyRksF ""   "% """          cCsAtd|dd!d}td|dd!d}d||fS(Nst firstsheetRR(RpRR((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyRs   cCs^|jdd}x7|jD])}|j|j||j|d7}q W|jddS(Ntsheetsi(RRt _write_sheetRzRR(Rptid_numR((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyRs  cCs_d|fd|fg}|r.|jdn|jddt|f|jd|dS( NRztsheetIdtstateRsr:idtrIdR(RR(RRR(RpRztsheet_idRR((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyRs  cCsd|jfg}|jdkrG|jd|jf|jd n(|jdkro|jd|jfn|jr|jd n|jd |dS( NtcalcIdRtcalcModet calcOnSaveRRtfullCalcOnLoadt1tcalcPr(RR(RR(RmRjRRkR(RpR((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyRs cCsL|js dS|jdx|jD]}|j|q$W|jddS(Nt definedNames(RSRt_write_defined_nameR(RpR@((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyRs   cCs|d}|d}|d}|d}d|fg}|dkrY|jd|fn|ro|jd n|jd ||dS( NiiiiRzit localSheetIdRt definedName(Ri(Rt_xml_data_element(RpR@RzRR8RR((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyRs     N(Bt__name__t __module__t__doc__R R|R RxR6R8RrRwR{R}RnRR;RRsRRRRRRRRRRRRRRyRRRRR R R R RR6RRHRjRkRlRmRnR7RRRRRRRRRRRRRRRR(((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyR".sx\    4     .  =   $ _ % 3     +  ; )  [ H - 5   "  /  J $        R=cBseZdZdZRS(s] A class to track worksheets data such as the active sheet and the first sheet. cCsd|_d|_dS(Ni(RR(Rp((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyR8s (RRRR8(((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyR=s(?RRR;RtwarningsRRtzipfileRRRRtstructRt compatibilityRRR R RR RR t chartsheetR t sharedstringsRtformatRRRtutilityRt chart_areaRt chart_barRt chart_columnRtchart_doughnutRt chart_lineRt chart_pieRt chart_radarRt chart_scatterRt chart_stockRt exceptionsRRRRRR R!t XMLwriterR"tobjectR=(((s2lib/python2.7/site-packages/xlsxwriter/workbook.pyt sN    ""