
    4iT                        % S SK Jr  S SKJrJrJrJr  S SKJrJrJ	r	  S SK
Jr  S SKJr  \(       a  S SKJrJr  S SKJrJrJrJrJr  \\-  \-  \-  \-  \-  \-  \-  rS\S	'    " S
 S\S   5      rg)    )annotations)datedatetimetime	timedelta)TYPE_CHECKINGAny	TypeAlias)import_optional_dependency)BaseExcelReader)CalamineSheetCalamineWorkbook)FilePathNaTType
ReadBufferScalarStorageOptionsr
   
_CellValuec                     ^  \ rS rSr  S
       SU 4S jjjr\SS j5       r      SS jr\SS j5       rSS jr	SS jr
 S     SS jjrS	rU =r$ )CalamineReader$   c                :   > [        S5        [        TU ]	  UUUS9  g)aJ  
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
    <https://pandas.pydata.org/docs/user_guide/io.html?
    highlight=storage_options#reading-writing-remote-files>`_.
engine_kwargs : dict, optional
    Arbitrary keyword arguments passed to excel engine.
python_calamine)storage_optionsengine_kwargsN)r   super__init__)selffilepath_or_bufferr   r   	__class__s       [/var/www/html/dynamic-report/venv/lib/python3.13/site-packages/pandas/io/excel/_calamine.pyr   CalamineReader.__init__%   s)    2 	##45+' 	 	
    c                    SSK Jn  U$ )Nr   )r   )r   r   )r   r   s     r!   _workbook_classCalamineReader._workbook_classE   s    4r#   c                     SSK Jn  U" U40 UD6$ )Nr   )load_workbook)r   r(   )r   r   r   r(   s       r!   r(   CalamineReader.load_workbookK   s     	2

 	
r#   c                    SSK Jn  U R                  R                   Vs/ s H+  nUR                  UR
                  :X  d  M  UR                  PM-     sn$ s  snf )Nr   )SheetTypeEnum)r   r+   booksheets_metadatatyp	WorkSheetname)r   r+   sheets      r!   sheet_namesCalamineReader.sheet_namesU   sN    1 22
2yyM333 EJJ2
 	
 
s   AAc                Z    U R                  U5        U R                  R                  U5      $ N)raise_if_bad_sheet_by_namer,   get_sheet_by_name)r   r0   s     r!   r7    CalamineReader.get_sheet_by_name_   s%    ''-yy**400r#   c                Z    U R                  U5        U R                  R                  U5      $ r5   )raise_if_bad_sheet_by_indexr,   get_sheet_by_index)r   indexs     r!   r;   !CalamineReader.get_sheet_by_indexc   s%    ((/yy++E22r#   c           
         SS jnUR                  SUS9nU VVs/ s H  oU Vs/ s H
  oc" U5      PM     snPM     nnnU$ s  snf s  snnf )Nc                @   [        U [        5      (       a  [        U 5      nX:X  a  U$ U $ [        U [        [        45      (       a  U $ [        U [
        5      (       a+  [        U R                  U R                  U R                  5      $ [        U [        5      (       a  U $ U $ r5   )

isinstancefloatintr   r   r   yearmonthdayr   )valuevals     r!   _convert_cell4CalamineReader.get_sheet_data.<locals>._convert_cellj   s}    %''%j<J LEHi#899E4((

EKKCCE4((Lr#   F)skip_empty_areanrows)rF   r   returnzScalar | NaTType | time)	to_python)r   r1   file_rows_neededrH   rowsrowcelldatas           r!   get_sheet_dataCalamineReader.get_sheet_datag   s[    	$ (-!)9 (7 (
 BFF#5t$5F 6Fs   	AAAA )NN)r   FilePath | ReadBuffer[bytes]r   zStorageOptions | Noner   zdict | NonerL   None)rL   ztype[CalamineWorkbook])r   rV   r   r	   rL   r   )rL   z	list[str])r0   strrL   r   )r<   rB   rL   r   r5   )r1   r   rN   z
int | NonerL   z#list[list[Scalar | NaTType | time]])__name__
__module____qualname____firstlineno__r   propertyr%   r(   r2   r7   r;   rS   __static_attributes____classcell__)r    s   @r!   r   r   $   s     26%)	
8
 /
 #	

 

 
@    

">
OR
	
 
 
13
 DH"6@	, r#   r   r   N)
__future__r   r   r   r   r   typingr   r	   r
   pandas.compat._optionalr   pandas.io.excel._baser   r   r   r   pandas._typingr   r   r   r   r   rB   rA   rX   boolr   __annotations__r   rU   r#   r!   <module>rg      sx    "   ? 1
  ec)D047$>IIU
I U]_%78 ]r#   