AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Aptana studio 3 switch to python32/20/2023 value = row 31 #save the csb file -> 32 wb. Wb = load_workbook(filename = dest, keep_vba=True) However, if the file is in xlsm format, even though I can open and edit it (loading with the keep_vba=True option), I get the error when I try to save it. I am able to open it, edit it and save it without any issue if the file is in xlsx format. I am facing a similar issue when trying to save an xlsm file. xlsm a different name but there were still some macros that were erroneous. I was able to successfully convert most of the vba when I gave the output. Zipfile.BadZipfile: File name in directory ".xml" and header "xl/sharedStrings.xml" differ. Wb= load_workbook("filepath.xlsm", keep_vba=True)įile "C:\Users\user\My Documents\Aptana Studio 3 Workspace\PyECAT27\userinput.py", line 441, in įile "build\bdist.win-amd64\egg\openpyxl\workbook.py", line 215, in saveįile "build\bdist.win-amd64\egg\openpyxl\writer\excel.py", line 163, in save_workbookįile "build\bdist.win-amd64\egg\openpyxl\writer\excel.py", line 146, in saveįile "build\bdist.win-amd64\egg\openpyxl\writer\excel.py", line 66, in write_dataįile "build\bdist.win-amd64\egg\openpyxl\writer\workbook.py", line 64, in write_content_typesįile "C:\Python27\lib\zipfile.py", line 931, in readįile "C:\Python27\lib\zipfile.py", line 976, in open After installing Python 2.7.5 and running the new version of openpyxl, I ran the following code: My apologies I was using 2.6 because of an ArcGIS 10 install on my cpu.
0 Comments
Read More
Leave a Reply. |