i% BddlZddlmZmZdZdZdZeejdkrejdZ ne dej  ee dZ ee ee d ed eze vree ee d edSdS#e$r1Ze d eeej YdZ[dSdZ[we$r@Ze d eee d e d ej YdZ[dSdZ[we$r@Ze d eede d e dej YdZ[dSdZ[we$r1Ze d eeej YdZ[dSdZ[wwxYw)N) BadZipFileZipFilec|d|z}t|d}|||dS)Nxl/wb)readopenwriteclose)xlsm_zipfilenamedatafiles P/srv/django_bis/venv311/lib/python3.11/site-packages/../../../bin/vba_extract.py extract_filersL ==) * *D $  DJJtJJLLLLLzvbaProject.binzvbaProjectSignature.bina( 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: rz File error: z+File may not be an Excel xlsm macro file: ''z: 'z)File may not be an Excel xlsm macro file.)syszipfilerrr vba_filenamevba_signature_filenamelenargv xlsm_fileprintexitr namelistIOErrorestrKeyError Exceptionrrr&s '''''''' 23sx==1 II E )    CHJJJ wy#&&HL<((( E & & &''' %%):):)<)<<< X5666 424455555=<  E !Q ! !""" CHJJJJJJJJJ E !Q ! !""" E D D D DEEE CHJJJJJJJJJ E 0Q 0 0I 0 0 0111 E 5666 CHJJJJJJJJJ E !Q ! !""" CHJJJJJJJJJs=AB..F3&CF'5D""F*5E%%F-&FF