Spaces:
Runtime error
Runtime error
File size: 1,877 Bytes
8a58cf3 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 |
#!C:\TrainGPT\myenv\Scripts\python.exe
##############################################################################
#
# vba_extract - A simple utility to extract a vbaProject.bin binary from an
# Excel 2007+ xlsm file for insertion into an XlsxWriter file.
#
# SPDX-License-Identifier: BSD-2-Clause
# Copyright 2013-2023, John McNamara, [email protected]
#
import sys
from zipfile import ZipFile
from zipfile import BadZipFile
# The VBA project file we want to extract.
vba_filename = "vbaProject.bin"
# Get the xlsm file name from the commandline.
if len(sys.argv) > 1:
xlsm_file = sys.argv[1]
else:
print(
"\nUtility to extract a vbaProject.bin binary from an Excel 2007+ "
"xlsm macro file for insertion into an XlsxWriter file."
"\n"
"See: https://xlsxwriter.readthedocs.io/working_with_macros.html\n"
"\n"
"Usage: vba_extract file.xlsm\n"
)
exit()
try:
# Open the Excel xlsm file as a zip file.
xlsm_zip = ZipFile(xlsm_file, "r")
# Read the xl/vbaProject.bin file.
vba_data = xlsm_zip.read("xl/" + vba_filename)
# Write the vba data to a local file.
vba_file = open(vba_filename, "wb")
vba_file.write(vba_data)
vba_file.close()
except IOError as e:
print("File error: %s" % str(e))
exit()
except KeyError as e:
# Usually when there isn't a xl/vbaProject.bin member in the file.
print("File error: %s" % str(e))
print("File may not be an Excel xlsm macro file: '%s'" % xlsm_file)
exit()
except BadZipFile as e:
# Usually if the file is an xls file and not an xlsm file.
print("File error: %s: '%s'" % (str(e), xlsm_file))
print("File may not be an Excel xlsm macro file.")
exit()
except Exception as e:
# Catch any other exceptions.
print("File error: %s" % str(e))
exit()
print("Extracted: %s" % vba_filename)
|