How to save XLSM file with Macro, using openpyxl

by

For me this worked, together with version openpyxl==2.3.0-b2

wb = load_workbook(filename="original.xlsm", read_only=False, keep_vba=True)
..
wb.save('outfile.xlsm')

It is also mentioend in the documentation here: http://openpyxl.readthedocs.org/en/latest/usage.html?highlight=keep_vba#write-a-workbook-from-xltm-as-xlsm

More Related Contents:

  1. Extract the data and modify an existing excel with openpyxl
  2. Read Excel cell value and not the formula computing it -openpyxl
  3. Save list of DataFrames to multisheet Excel spreadsheet
  4. Editing workbooks with rich text in openpyxl
  5. Iterate over Worksheets, Rows, Columns
  6. Pandas: Looking up the list of sheets in an excel file
  7. How to access the real value of a cell using the openpyxl module for python
  8. copy cell style openpyxl
  9. Openpyxl 1.8.5: Reading the result of a formula typed in a cell using openpyxl
  10. How to concatenate three excels files xlsx using python?
  11. How to copy worksheet from one workbook to another one using openpyxl?
  12. Is there a way to auto-adjust Excel column widths with pandas.ExcelWriter?
  13. Modify an existing Excel file using Openpyxl in Python
  14. Copy pandas dataframe to excel using openpyxl
  15. how to write to a new cell in python using openpyxl
  16. openpyxl – adjust column width size
  17. Python openpyxl data_only=True returning None
  18. Insert row into Excel spreadsheet using openpyxl in Python
  19. openpyxl load_workbook() on a legit .xlsx file leads to a zipfile.BadZipFile error
  20. getting the row and column numbers from coordinate value in openpyxl
  21. Get cell color from .xlsx
  22. How to write a list to Excel column?
  23. “@” symbol appearing after inserting IF formula into excel using Openpyxl
  24. Is it possible to get an Excel document’s row count without loading the entire document into memory?
  25. Openpyxl check for empty cell
  26. python: update dataframe to existing excel sheet without overwriting contents on the same sheet and other sheets
  27. How to write to an existing excel file without breaking formulas with openpyxl?
  28. Openpyxl max_row and max_column wrongly reports a larger figure
  29. Get sheet by name using openpyxl
  30. Setting styles in Openpyxl

Leave a Comment