tjVdZddlmZddlmZmZmZddlmZm Z GddeZ dS)zLoads Microsoft Excel files.)Path)AnyListUnion)UnstructuredFileLoadervalidate_unstructured_versioncPeZdZdZ d deeefdedeffd Zde fdZ xZ S) UnstructuredExcelLoaderaLoad Microsoft Excel files using `Unstructured`. Like other Unstructured loaders, UnstructuredExcelLoader can be used in both "single" and "elements" mode. If you use the loader in "elements" mode, each sheet in the Excel file will be an Unstructured Table element. If you use the loader in "single" mode, an HTML representation of the table will be available in the "text_as_html" key in the document metadata. Examples -------- from langchain_community.document_loaders.excel import UnstructuredExcelLoader loader = UnstructuredExcelLoader("stanley-cups.xlsx", mode="elements") docs = loader.load() single file_pathmodeunstructured_kwargsc ~t|}tdtjd||d|dS)a4 Args: file_path: The path to the Microsoft Excel file. mode: The mode to use when partitioning the file. See unstructured docs for more info. Optional. Defaults to "single". **unstructured_kwargs: Keyword arguments to pass to unstructured. z0.6.7)min_unstructured_version)r r N)strrsuper__init__)selfr r r __class__s h/var/www/html/CA-Chatbot/venv/lib/python3.11/site-packages/langchain_community/document_loaders/excel.pyrz UnstructuredExcelLoader.__init__sL NN %wGGGGO94OO;NOOOOOreturnc6ddlm}|dd|ji|jS)Nr)partition_xlsxfilenamer)unstructured.partition.xlsxrr r)rrs r _get_elementsz%UnstructuredExcelLoader._get_elements1s4>>>>>>~RRt~R9QRRRr)r ) __name__ __module__ __qualname____doc__rrrrrrr __classcell__)rs@rr r s*PPd#PP # PPPPPP$StSSSSSSSSrr N) r"pathlibrtypingrrr1langchain_community.document_loaders.unstructuredrrr rrrr's""########## (S(S(S(S(S4(S(S(S(S(Sr