a
    …Ï?eå  ã                   @   s   d Z ddlmZ dd„ ZdS )z
Load spreadsheets
é    )Úload_workbookc           
      K   s|   t | ƒ}t|ƒd }d}tƒ }|D ]T}|du r>dd„ |D ƒ}q"dd„ t||ƒD ƒ}dd„ | ¡ D ƒ}	|	sl qx| |¡ q"|S )zÓLoad spreadsheet

    Return array of objects.

    Each object is a row with keys associated to columns, and named
    based on first non-empty row.

    Note, follows the same pattern as moo.csvio.load().
    r   Nc                 S   s   g | ]}|j  ¡ ‘qS © )ÚvalueÚstrip)Ú.0Úcr   r   úJ/home/yuhw/wc/wire-cell-python/wcpy/lib/python3.9/site-packages/moo/xls.pyÚ
<listcomp>   ó    zload.<locals>.<listcomp>c                 S   s   i | ]\}}||j “qS r   )r   )r   ÚkÚvr   r   r   Ú
<dictcomp>   r
   zload.<locals>.<dictcomp>c                 S   s   g | ]}|r|‘qS r   r   )r   r   r   r   r   r	      r
   )r   ÚlistÚzipÚvaluesÚappend)
ÚfilenameÚpathsÚkwdsÚwbZsheetÚheadÚretÚrowZoneZhaver   r   r   Úload   s    r   N)Ú__doc__Úopenpyxlr   r   r   r   r   r   Ú<module>   s   