.iTUddlmZddlmZmZmZmZddlmZmZm Z ddl m Z ddl m Z erddlmZmZddlmZmZmZmZmZeezezezezezezezZded <Gd d e d Zy )) annotations)datedatetimetime timedelta) TYPE_CHECKINGAny TypeAlias)import_optional_dependency)BaseExcelReader) CalamineSheetCalamineWorkbook)FilePathNaTType ReadBufferScalarStorageOptionsr _CellValueceZdZ d d fd Zed dZ d dZed dZd dZddZ d ddZ xZ S)CalamineReaderc@tdt| |||y)a Reader using calamine engine (xlsx/xls/xlsb/ods). Parameters ---------- filepath_or_buffer : str, path to be parsed or an open readable stream. storage_options : dict, optional Extra options that make sense for a particular storage connection, e.g. host, port, username, password, etc. For HTTP(S) URLs the key-value pairs are forwarded to ``urllib.request.Request`` as header options. For other URLs (e.g. starting with "s3://", and "gcs://") the key-value pairs are forwarded to ``fsspec.open``. Please see ``fsspec`` and ``urllib`` for more details, and for more examples on storage options refer `here `_. engine_kwargs : dict, optional Arbitrary keyword arguments passed to excel engine. python_calamine)storage_options engine_kwargsN)r super__init__)selffilepath_or_bufferrr __class__s W/var/www/app/trading-bot/venv/lib/python3.12/site-packages/pandas/io/excel/_calamine.pyrzCalamineReader.__init__%s)2 ##45  +'  cddlm}|S)Nr)r)rr)rrs r _workbook_classzCalamineReader._workbook_classEs 4r!c ddlm}||fi|S)Nr) load_workbook)rr%)rrrr%s r r%zCalamineReader.load_workbookKs 2    r!cddlm}|jjDcgc]'}|j|j k(r |j )c}Scc}w)Nr) SheetTypeEnum)rr'booksheets_metadatatyp WorkSheetname)rr'sheets r sheet_nameszCalamineReader.sheet_namesUsG122 yyM333 JJ   s,AcZ|j||jj|SN)raise_if_bad_sheet_by_namer(get_sheet_by_name)rr,s r r2z CalamineReader.get_sheet_by_name_s% ''-yy**400r!cZ|j||jj|Sr0)raise_if_bad_sheet_by_indexr(get_sheet_by_index)rindexs r r5z!CalamineReader.get_sheet_by_indexcs% ((/yy++E22r!c dd}|jd|}|Dcgc]}|Dcgc] }|| c}}}}|Scc}wcc}}w)Nct|trt|}||k(r|S|St|ttfr|St|t r+t|j |j|jSt|tr|S|Sr0) isinstancefloatintrrryearmonthdayr)valuevals r _convert_cellz4CalamineReader.get_sheet_data.._convert_celljss%'%j%<J LEHi#89 E4( EKKCCE4( Lr!F)skip_empty_areanrows)r?rreturnzScalar | NaTType | time) to_python)rr-file_rows_neededrArowsrowcelldatas r get_sheet_datazCalamineReader.get_sheet_datagsV $(-!)9(7( BFF#5t$5FF 6Fs A? AA)NN)rFilePath | ReadBuffer[bytes]rzStorageOptions | Nonerz dict | NonerDNone)rDztype[CalamineWorkbook])rrLrr rDr)rDz list[str])r,strrDr )r6r;rDr r0)r-r rFz int | NonerDz#list[list[Scalar | NaTType | time]]) __name__ __module__ __qualname__rpropertyr#r%r.r2r5rK __classcell__)rs@r rr$s26%)  8 / #    @   "> OR    13 DH"6@ ,r!rrN) __future__rrrrrtypingrr r pandas.compat._optionalr pandas.io.excel._baser rr rpandas._typingrrrrrr;r:rNboolr__annotations__rr!r r\sx"  ?1 e c)D047$>IIU IU]_%78]r!