'Excel vba macro unavailable in a sheet exported using pandas
So, I have an xlsx file that is generated using pandas ExcelWriter.The exact piece of code being
writer=pd.ExcelWriter(r'Workbook.xlsx', engine='xlsxwriter')
writer.save()
Parallely I have an excel macro that is generated to be available for all excel workbooks. The macros are available when I open excel and create an empty workbook. When I open the workbook exported using pandas, the excel macros are not even listed.
This is the file I created manually
This is the file generated using the python code
Does anyone have an idea what I am doing wrong?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|