ó }\c @s›ddlZddlZddlZddlZddlmZddlmZmZm Z m Z m Z m Z m Z mZmZmZddlmZmZddlTddlmZmZddlmZdd lmZmZmZdd lmZej j!d ƒrddl"Z"nyddl#Z#dZ$Wne%k rHd Z$nXe$Z&dej(d e&dde)e)e)d „ Z*ej(e)d„Z+ej(d„Z,dS(iÿÿÿÿNi(t timemachine( t XL_CELL_BLANKtXL_CELL_BOOLEANt XL_CELL_DATEt XL_CELL_EMPTYt XL_CELL_ERRORtXL_CELL_NUMBERt XL_CELL_TEXTt XLRDErrortbiff_text_from_numterror_text_from_code(tBooktcolname(t*(t __VERSION__t __version__(t empty_cell(t XLDateErrortxldate_as_datetimetxldate_as_tuple(tX12Bookt IronPythonic CsÙd} |r|| } n9tjj|ƒ}t|dƒ} | j| ƒ} WdQX| dkrƒ|rtjtj|ƒƒ} ntj|ƒ} t g| j ƒD]} t j | ƒ| f^qžƒ}|rè|j dƒtj||ƒnd|kr>ddlm}|j| |d |d |d |d |d |d|ƒ}|Sd|krYtdƒ‚nd|krttdƒ‚ntdƒ‚nddlm}|jd|d |d |d |d|d|d |d |d|ƒ }|S(sÉ 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. :returns: An instance of the :class:`~xlrd.book.Book` class. itrbNsPKsZIP component_names: sxl/workbook.xmli(txlsxtlogfilet verbositytuse_mmaptformatting_infot on_demandt ragged_rowssxl/workbook.bins#Excel 2007 xlsb file; not supporteds content.xmls&Openoffice.org ODS file; not supporteds.ZIP file contents not a known type of workbook(tbooktfilenamet file_contentstencoding_override(tostpatht expandusertopentreadtzipfiletZipFileRtBYTES_IOtdicttnamelistRtconvert_filenametwritetpprinttRtopen_workbook_2007_xmlRRtopen_workbook_xls(RRRRR R!RRRtpeeksztpeektftzftnametcomponent_namesRtbkR((s,lib/python2.7/site-packages/xlrd/__init__.pyt open_workbook!sXI  .       cCsUddlm}tƒ}|jd|d|ƒ||j|j|jd||ƒdS(s 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). i(t biff_dumpRRiN(tbiffhR:R t biff2_8_loadtmemtbaset stream_len(Rtoutfilet unnumberedR:R8((s,lib/python2.7/site-packages/xlrd/__init__.pytdump¢s cCsOddlm}tƒ}|jd|d|ƒ||j|j|j|ƒdS(s 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. i(tbiff_count_recordsRRN(R;RCR R<R=R>R?(RR@RCR8((s,lib/python2.7/site-packages/xlrd/__init__.pyt count_records°s (-R"R.tsysR'R/RR;RRRRRRRRR R RR R tformulatinfoRRtsheetRtxldateRRRRRtversiont startswitht encodingstmmaptMMAP_AVAILABLEt ImportErrortUSE_MMAPtNonetstdouttFalseR9RBRD(((s,lib/python2.7/site-packages/xlrd/__init__.pyts<    F      y