rjm dddlZddlZddlZddlZddlmZddlmZmZm Z m Z m Z m Z m Z mZmZmZddlmZmZmZddlmZddlTddlmZmZdd lmZdd lmZm Z m!Z!d d d ddddZ"dZ#e$e%ee%e#Z&ddZ'dej(ddddddddf dZ)ej(dfdZ*ej(fdZ+dS)N) timemachine) XL_CELL_BLANKXL_CELL_BOOLEAN XL_CELL_DATE XL_CELL_EMPTY XL_CELL_ERRORXL_CELL_NUMBER XL_CELL_TEXT XLRDErrorbiff_text_from_numerror_text_from_code)Bookcolnameopen_workbook_xls) SIGNATURE)*) __VERSION__ __version__) empty_cell) XLDateErrorxldate_as_datetimexldate_as_tuplez Excel xlszExcel 2007 xlsb filezExcel xlsx filezOpenoffice.org ODS filezUnknown ZIP filezUnknown file type)xlsxlsbxlsxodszipNsPKc|r|dt}natj|}t |d5}|t}dddn #1swxYwY|trdS|tr\tj |rtj |n|}d| D}d|vrdSd|vrdSd |vrd Sd SdS) a\ Inspect the content at the supplied path or the :class:`bytes` content provided and return the file's type as a :class:`str`, or ``None`` if it cannot be determined. :param path: A :class:`string ` path containing the content to inspect. ``~`` will be expanded. :param content: The :class:`bytes` content to inspect. :returns: A :class:`str`, or ``None`` if the format cannot be determined. The return value can always be looked up in :data:`FILE_FORMAT_DESCRIPTIONS` to return a human-readable description of the format found. Nrbrc`i|]+}|dd|,S)\/)replacelower).0names ;C:\Projects\DSCons\.venv\Lib\site-packages\xlrd\__init__.py z"inspect_format..HsD666# <<c2288::D666zxl/workbook.xmlrzxl/workbook.binrz content.xmlrr) PEEK_SIZEospath expanduseropenread startswith XLS_SIGNATURE ZIP_SIGNATUREzipfileZipFilerBYTES_IOnamelist)r-contentpeekfzfcomponent_namess r(inspect_formatr=&s^$%z z"w!!$'' $   %66)$$D % % % % % % % % % % % % % % % }%%u }%% _gO[1':::4 P P 66'){{}}666  / /6  / /6 O + +5usA))A-0A-TFc t||} | r#| dkrtt| dzt||||||||||  } | S)a Open a spreadsheet file for data extraction. :param filename: The path to the spreadsheet file to be opened. :param logfile: An open file to which messages and diagnostics are written. :param verbosity: Increases the volume of trace material written to the logfile. :param use_mmap: Whether to use the mmap module is determined heuristically. Use this arg to override the result. Current heuristic: mmap is used if it exists. :param file_contents: A string or an :class:`mmap.mmap` object or some other behave-alike object. If ``file_contents`` is supplied, ``filename`` will not be used, except (possibly) in messages. :param encoding_override: Used to overcome missing or bad codepage information in older-version files. See :doc:`unicode`. :param formatting_info: The default is ``False``, which saves memory. In this case, "Blank" cells, which are those with their own formatting information but no data, are treated as empty by ignoring the file's ``BLANK`` and ``MULBLANK`` records. This cuts off any bottom or right "margin" of rows of empty or blank cells. Only :meth:`~xlrd.sheet.Sheet.cell_value` and :meth:`~xlrd.sheet.Sheet.cell_type` are available. When ``True``, formatting information will be read from the spreadsheet file. This provides all cells, including empty and blank cells. Formatting information is available for each cell. Note that this will raise a NotImplementedError when used with an xlsx file. :param on_demand: Governs whether sheets are all loaded initially or when demanded by the caller. See :doc:`on_demand`. :param ragged_rows: The default of ``False`` means all rows are padded out with empty cells so that all rows have the same size as found in :attr:`~xlrd.sheet.Sheet.ncols`. ``True`` means that there are no empty cells at the ends of rows. This can result in substantial memory savings if rows are of widely varying sizes. See also the :meth:`~xlrd.sheet.Sheet.row_len` method. :param ignore_workbook_corruption: This option allows to read corrupted workbooks. When ``False`` you may face CompDocError: Workbook corruption. When ``True`` that exception will be ignored. :returns: An instance of the :class:`~xlrd.book.Book` class. rz; not supported) filenamelogfile verbosityuse_mmap file_contentsencoding_overrideformatting_info on_demand ragged_rowsignore_workbook_corruption)r=r FILE_FORMAT_DESCRIPTIONSr) r?r@rArBrCrDrErFrGrH file_formatbks r( open_workbookrLTs|d!=99KQ{e++0=>OOPPP #+'#=   B Ir*cddlm}t}|||||j|j|jd||dS)a For debugging: dump an XLS file's BIFF records in char & hex. :param filename: The path to the file to be dumped. :param outfile: An open file, to which the dump is written. :param unnumbered: If true, omit offsets (for meaningful diffs). r) biff_dumpr?r@rN)biffhrNr biff2_8_loadmembase stream_len)r?outfile unnumberedrNrKs r(dumprWs[!     BOOXwO999 Ibfbgr}a*EEEEEr*cddlm}t}|||||j|j|j|dS)a For debugging and analysis: summarise the file's BIFF records. ie: produce a sorted file of ``(record_name, count)``. :param filename: The path to the file to be summarised. :param outfile: An open file, to which the summary is written. r)biff_count_recordsrON)rPrYrrQrRrSrT)r?rUrYrKs r( count_recordsrZsX*))))) BOOXwO999rvrw w?????r*)NN),r,pprintsysr4rrPrrrrr r r r r rbookrrrcompdocrr2formulainforrsheetrxldaterrrrIr3maxlenr+r=stdoutrLrWrZr*r(rhs$  3222222222//////********DDDDDDDDDD  "  $    CM""CC $6$6 7 7 ++++\ * $$("'!#-2eeeeP:% F F F F%(J @ @ @ @ @ @r*