U
    7h$	                  
   @   s  d dl Z d dlmZmZ dd ZdZdZee jdkrBe jd Z	ne
d e   zPee	d	Zeee e
d
e  de e kreee e
d
e  W n ek
r Z ze
dee  e   W 5 dZ[X Y n ek
r* Z z.e
dee  e
de	 d e   W 5 dZ[X Y n ek
rv Z z.e
dee de	 d e
d e   W 5 dZ[X Y n> ek
r Z ze
dee  e   W 5 dZ[X Y nX dS )    N)
BadZipFileZipFilec                 C   s.   |  d| }t|d}|| |  d S )Nxl/wb)readopenwriteclose)xlsm_zipfilenamedatafile r   R/var/www/formularioweb/env/lib/python3.8/site-packages/../../../bin/vba_extract.pyextract_file   s    

r   zvbaProject.binzvbaProjectSignature.bin   a(  
Utility to extract a vbaProject.bin binary from an Excel 2007+ xlsm macro file for insertion into an XlsxWriter file.
If the macros are digitally signed, extracts also a vbaProjectSignature.bin file.

See: https://xlsxwriter.readthedocs.io/working_with_macros.html

Usage: vba_extract file.xlsm
rzExtracted: r   zFile error: z+File may not be an Excel xlsm macro file: ''z: 'z)File may not be an Excel xlsm macro file.)syszipfiler   r   r   Zvba_filenameZvba_signature_filenamelenargvZ	xlsm_fileprintexitr
   namelistIOErrorestrKeyError	Exceptionr   r   r   r   <module>   s>   



