3 Uéd¿ã@stddlmZddlmZmZiZdd„Zdd„Zdd„Zd d „Z d d „Z d d„Z dd„Z dd„Z dd„Zdd„ZdS)é)Úimport_optional_dependency)Ú is_integerÚ is_list_likecCs"t|ƒstdƒ‚|j}|t|<dS)z° Add engine to the excel writer registry.io.excel. You must use this method to integrate with ``to_excel``. Parameters ---------- klass : ExcelWriter z&Can only register callables as enginesN)ÚcallableÚ ValueErrorZengineÚ_writers)ÚklassÚ engine_name©r úI/var/www/html/virt/lib64/python3.6/site-packages/pandas/io/excel/_util.pyÚregister_writers r cCs0dddddœ}tdddd}|r(d|d <||S) zþ Return the default writer for the given extension. Parameters ---------- ext : str The excel file extension for which to get the default engine. Returns ------- str The default engine for the extension. ZopenpyxlZxlwtZodf)ÚxlsxZxlsmZxlsZodsÚ xlsxwriterFÚwarn)Zraise_on_missingZ on_versionr )r)ÚextZ_default_writersrr r r Ú_get_default_writers rcCsByt|Stk r<}ztd|›dƒ|‚WYdd}~XnXdS)NzNo Excel writer 'ú')rÚKeyErrorr)r Úerrr r r Ú get_writer4srcCshd}xZ|jƒjƒD]J}t|ƒ}|tdƒks6|tdƒkrDtd|›ƒ‚|d|tdƒd}qW|dS)ai Convert Excel column name like 'AB' to 0-based column index. Parameters ---------- x : str The Excel column name to convert to a 0-based column index. Returns ------- num : int The column index corresponding to the name. Raises ------ ValueError Part of the Excel column name was invalid. rÚAÚZzInvalid column name: éé)ÚupperÚstripÚordr)ÚxÚindexÚcÚcpr r r Ú _excel2num;sr!cCsbg}xX|jdƒD]J}d|krL|jdƒ}|jtt|dƒt|dƒdƒƒq|jt|ƒƒqW|S)a” Convert comma separated list of column names and ranges to indices. Parameters ---------- areas : str A string containing a sequence of column ranges (or areas). Returns ------- cols : list A list of 0-based column indices. Examples -------- >>> _range2cols('A:E') [0, 1, 2, 3, 4] >>> _range2cols('A,C,Z:AB') [0, 2, 25, 26, 27] ú,ú:rr)ÚsplitÚextendÚranger!Úappend)ZareasÚcolsÚrngr r r Ú _range2cols[s &r*cCs2|dkr |St|ƒrtdƒ‚t|tƒr.t|ƒS|S)a Convert `usecols` into a compatible format for parsing in `parsers.py`. Parameters ---------- usecols : object The use-columns object to potentially convert. Returns ------- converted : object The compatible format of `usecols`. Nz}Passing an integer for `usecols` is no longer supported. Please pass in a list of int from 0 to `usecols` inclusive instead.)rrÚ isinstanceÚstrr*)Zusecolsr r r Ú_maybe_convert_usecols|s r-cCs6|dk r2t|ƒdkr*tdd„|Dƒƒr*dStdƒ‚dS)Nécss|]}t|tƒVqdS)N)r+Úint)Ú.0Úitemr r r ú œsz)_validate_freeze_panes..TzLfreeze_panes must be of form (row, column) where row and column are integersF)ÚlenÚallr)Z freeze_panesr r r Ú_validate_freeze_panes™sr5cCs:x4t|ƒdkr4|ddks&|ddkr4|dd…}qW|S)NrÚr)r3)Úrowr r r Ú_trim_excel_headerªs&r8cCsj|d}xXtdt|ƒƒD]F}||s,||}||dksD||dkrN|||<qd||<||}qW||fS)aç Forward fill blank entries in row but only inside the same parent index. Used for creating headers in Multiindex. Parameters ---------- row : list List of items in a single row. control_row : list of bool Helps to determine if particular column is in same parent index as the previous value. Used to stop propagation of empty cells between different indexes. Returns ------- Returns changed row and control_row rrr6NF)r&r3)r7Z control_rowÚlastÚir r r Ú_fill_mi_header²s  r;cCsRt|ƒs |nt|ƒ}||}|dkr(dn|}||d|…dg||dd…fS)a• Pop the header name for MultiIndex parsing. Parameters ---------- row : list The data row to parse for the header name. index_col : int, list The index columns for our data. Assumed to be non-null. Returns ------- header_name : str The extracted header name. trimmed_row : list The original data row with the header name removed. r6Nr)rÚmax)r7Z index_colr:Ú header_namer r r Ú_pop_header_nameÓsr>N)Zpandas.compat._optionalrZpandas.core.dtypes.commonrrrr rrr!r*r-r5r8r;r>r r r r Ús  !!