nh ddlZddlZddlZddlZddlZddlmZmZmZm Z m Z m Z mZddl m Z mZmZmZmZmZmZmZmZmZddlmZmZddlddlmZddlmZmZm Z dd l!m"Z"ejFjId rddl%Z% ddl&Z&dZ'e'Z)dejTde)ddd d d d f d Z+ejTd fd Z,ejTfdZ-y#e($rdZ'YCwxYw)N) __author__ __copyright__ __email__ __license____maintainer____maintainer_email__ __version__) 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)Bookcolname)*) empty_cell) XLDateErrorxldate_as_datetimexldate_as_tuple)X12Book IronPythonFc d} |r|d| } nEtjj|}t|d5} | j | } ddd dk(r|r)t j tj|} nt j |} | jDcic]}tj||}}|r'|jdtj||d|vr!ddlm}|j!| ||||||| }|Sd |vr t#d d |vr t#d t#dddlm}|j'||||||||||  }|S#1swYxYwcc}w)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:`~excelrd.sheet.Sheet.cell_value` and :meth:`~excelrd.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:`~excelrd.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:`~excelrd.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:`~excelrd.book.Book` class. NrbsPKzZIP component_names: zxl/workbook.xmlr)xlsx)logfile verbosityuse_mmapformatting_info on_demand ragged_rowszxl/workbook.binz#Excel 2007 xlsb file; not supportedz content.xmlz&Openoffice.org ODS file; not supportedz.ZIP file contents not a known type of workbook)book) filenamer"r#r$ file_contentsencoding_overrider%r&r'ignore_workbook_corruption)ospath expanduseropenreadzipfileZipFileioBytesIOnamelistrconvert_filenamewritepprintr!open_workbook_2007_xmlrr(open_workbook_xls)r)r"r#r$r*r+r%r&r'r,peekszpeekfzfnamecomponent_namesr!bkr(s v/var/www/html/SchoolMeal/SchoolMeal/pds_admin_SchoolMeal/Backend/venv/lib/python3.12/site-packages/excelrd/__init__.py open_workbookrE4sfFWf%77%%h/ (D ! "Q66&>D " } M!:;B*B MOKKMZD733D94?ZZ  MM2 3 MM/7 3  / ,,#! /#'- BI  /AB B O +DE EHII  #+'#= B Ie " "[sE 'E- E*cddlm}t}|j||||j|j |j d||y)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)biffhrGr biff2_8_loadmembase stream_len)r)outfile unnumberedrGrCs rDdumprPsE! BOObffbggr}}a*Ecddlm}t}|j||||j|j |j |y)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_recordsrHN)rIrSrrJrKrLrM)r)rNrSrCs rD count_recordsrTsA* BOOrvvrww w?rQ).r4r-r9sysr2r rrrrrr rIr r r rrrrrrrr(rrformulasheetrxldaterrrr!rversion startswith encodingsmmapMMAP_AVAILABLE ImportErrorUSE_MMAPstdoutrErPrTrQrDrbs      DD;;,'N  JJ $JZ::%F$%(JJ@INsCC  C