mR\@sddlmZddlZddlmZddlZddlZddZdejddZ dejdd Z dejd d Z d d Z dejddZ edkrddZeejdkreejdnejdZejdZejdZeejdZxzejeD]fZejeZedkrre eeeq>edkre eeeq>e eeeeq>WndS))print_functionN)REPRcCskd|ko|jknr=d|t|j|fS|dkrMdS|d kr]dSdt|S) Nrzsheet #%d (%r)Globalz Macro/VBAzUnknown scope value (%r))Znsheetsr sheet_names)bookscoper A/var/www/dbchiro/venv/build/xlrd/xlrd/examples/xlrdnameAPIdemo.pyscope_as_strings  rcCsyt|}WnVtk rh|dkr5d}n/|jj|}td||fd|YnXxB|jD]7}|dks|j|krst||||qsqsWdS)N*z%r => %dfile)int ValueErrorr indexprintZ name_obj_listr show_name_object)r scope_strg show_contentsfZqscopenobjr r r do_scope_querys   rcCsd|j}|jj|}|s<td|d|dSx!|D]}t||||qCWdS)z book -- Book object obtained from xlrd.open_workbook(). name -- The name that's being investigated. show_contents -- 0: Don't; 1: Non-empty cells only; 2: All cells f -- Open output file handle. z%r: unknown namerN)lowerZname_mapgetrr)r namerr name_lcaseZ nobj_listrr r r show_name_details(s  rc Csyt|}WnAtk rS|jj|}td||fd|YnX|j}x\|jj||f}|rPntdt||fd||dkrdSd}qcWtdt||fd|t ||||dS)Nz%r => %drzName %s not found in scope %drzName %s found in scope %drr) rrr rrrZname_and_scope_maprrr)r rrrrr rrr r r show_name_details_in_scope7s       r cCs|tjkrlytj||}Wqtjk rh}zdt|j|f}WYdd}~XqXn1|tjkrtjj|d|}n|}|S)Nz%s:%sz) xlrdZ XL_CELL_DATEZxldate_as_tupleZ XLDateErrortype__name__Z XL_CELL_ERRORZerror_text_from_coder)ZcelltypeZ cellvaluedatemodeZshowvaler r r showable_cell_valueLs/ r&c Cstdt|jt|jt||jfd||j}tdt|d||dkrndS|j}|j}|dkrn0|tj krxt t |D]H}||}td|t|j ttj ||fd|qWn|tjkrxt t |D]}||}td|t|j ttj||fd||svq"n|j} x6t |j|jD]} |j| } td| | jfd|t|j| j} t|j| j} xt |j| D]}xt |j| D]}| j||}|tjkrV|dkrVqn| j||}t||| }td||tj||t|fd|qWqWqWq"WndS) Nz Name: %s, scope: %s (%s)rzFormula eval result: %srzRange %d: %s ==> %sz Sheet #%d (%s)rz (%3d,%3d) %-5s: %s) rrrr rresultkindvaluer!ZoRELrangelenZcoordsZrangename3drelZoREFZ rangename3dr$ZshtxloZshtxhiZsheet_by_indexminZrowxhiZnrowsZcolxhiZncolsZrowxloZcolxloZ cell_typeZ XL_CELL_EMPTYZ cell_valuer&Zcellname)r rrrresr(r)iZref3dr$ZshxshZrowlimZcollimZrowxZcolxZctycvalZsvalr r r rYsF5      ? 8 r__main__cCsd}tjj|dS)Na usage: xlrdnameAIPdemo.py glob_pattern name scope show_contents where: "glob_pattern" designates a set of files "name" is a name or '*' (all names) "scope" is -1 (global) or a sheet number or a sheet name or * (all scopes) "show_contents" is one of 0 (no show), 1 (only non-empty cells), or 2 (all cells) Examples (script name and glob_pattern arg omitted for brevity) [Searching through book.name_obj_list] * * 0 lists all names * * 1 lists all names, showing referenced non-empty cells * 1 0 lists all names local to the 2nd sheet * Northern 0 lists all names local to the 'Northern' sheet * -1 0 lists all names with global scope [Initial direct access through book.name_map] Sales * 0 lists all occurrences of "Sales" in any scope [Direct access through book.name_and_scope_map] Revenue -1 0 checks if "Revenue" exists in global scope )sysstdoutwrite)textr r r usagesr6rrr) __future__rr!Zxlrd.timemachinerr2globrr3rrr r&rr#r6r+argvexitZ arg_patternZarg_nameZ arg_scoperZarg_show_contentsfnameZ open_workbookr r r r r  s4     )