excel - C4D python openpyxl cannot save .xlsm, but raises TypeError in zipfile.py -


this first post, , i've been searching diligently answer, please bear me!

i want able modify existing .xslm file fill motion data i've extracted within cinema-4d via python.

i did try keep_vba=true suggested here, still got error described below. macro-enable workbook excel 2013, functioning macro wrote. working code is:

import os openpyxl import load_workbook  homedir = os.path.expanduser('~')  openname = 'timing_chart.xlsm' openpath = os.path.dirname(__file__) + "\\" + openname savename = raw_input('please enter save name: ') savepath = homedir+'\\desktop\\'+savename+'.xlsm'  wb = load_workbook(openpath, keep_vba = true) ws = wb.active  ws['b10'].value = 'loader'  #just test ws['d10'].value = 25  wb.save(savepath)

when run code via enthought canopy environment (python 2.7.6 64-bit) works expected--fantastic. when try run same code in same python version used in cinema-4d installation (python 2.6.4 64-bit) works until wb.save() command. whole pile of errors:

traceback (most recent call last):   file "<pyshell#14>", line 1, in <module>     wb.save(savepath)   file "c:\python26\lib\site-packages\openpyxl-2.3.2-py2.6.egg\openpyxl\workbook\workbook.py", line 263, in save     save_workbook(self, filename)   file "c:\python26\lib\site-packages\openpyxl-2.3.2-py2.6.egg\openpyxl\writer\excel.py", line 239, in save_workbook     writer.save(filename, as_template=as_template)   file "c:\python26\lib\site-packages\openpyxl-2.3.2-py2.6.egg\openpyxl\writer\excel.py", line 222, in save     self.write_data(archive, as_template=as_template)   file "c:\python26\lib\site-packages\openpyxl-2.3.2-py2.6.egg\openpyxl\writer\excel.py", line 68, in write_data     archive.writestr(arc_root_rels, write_root_rels(self.workbook))   file "c:\python26\lib\site-packages\openpyxl-2.3.2-py2.6.egg\openpyxl\writer\workbook.py", line 88, in write_root_rels     arc = fromstring(workbook.vba_archive.read(arc_root_rels))   file "c:\python26\lib\zipfile.py", line 831, in read     return self.open(name, "r", pwd).read()   file "c:\python26\lib\zipfile.py", line 594, in read     bytes = self.fileobj.read(bytestoread) typeerror: integer argument expected, got 'long'

it wasn't until writing post (and testing out statements go along make sure i'm saying accurate), discovered difference between working/failing python v2.7.6 in enthought canopy vs. python v2.6.4 in windows , cinema-4d.

originally thought specific c4d, since c4d running python 2.6.4 well, i'm hopeful can narrowed down fixable issue python version... or learn sure it's impossible python 2.6.4.

any help/advice appreciated!

okay, did not realize difference in python version have effect... little more digging in arena revealed openpyxl stopped supporting python 2.5 after version 1.7. i'm assuming similar happened python 2.6 between openpyxl 1.8 current 2.4.

i installed openpyxl v1.8.6 c4d python 2.6.4 library location (along setuptools-0.9.6-py2.6, because didn't openpyxl-1.8.6-py2.6.egg otherwise) , modified 1 line of code in c4d. update, code worked in c4d python v2.6.4 install charm!

import os openpyxl import load_workbook  homedir = os.path.expanduser('~')  openname = 'timing_chart.xlsm' openpath = os.path.dirname(__file__) + "\\" + openname savename = raw_input('please enter save name: ') savepath = homedir+'\\desktop\\'+savename+'.xlsm'  wb = load_workbook(openpath, keep_vba = true) ws = wb.active  ws['b10'].value = 'loader'  #just test ws['d10'].value = 25  wb.save(savepath)

when writing values cells of new .xlsm file, openpyxl v.2.4 had line:

ws.cell(column = curcol, row = currow, value = eachkey)

which had changed to:

ws.cell(column = curcol, row = currow).value = eachkey

i hope can in future!


Comments

Post a Comment

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

Image
i have page in each contest shown in row. each row contains contest id , link other model names have foreign key contest. news model: class news(models.model): title = models.charfield(max_length=50, null=true) description = models.textfield() time = models.timefield( default= datetime.datetime.now().time()) contest = models.foreignkey(contest) i want use admin adding , changing these models. want when user clicks on 'news' has foreign key contest id=1, shows list of news value foreign key. use {% instance in instances %} <tr class="{% cycle 'row1' 'row2' %}"> <td>{{ instance.title }}</td> <td>{{ instance.starttime }}</td> <td>{{ instance.timespan }}</td> <td>{{ instance.date }}</td> <td><a href="/adm...
Read more

css - Make div keyboard-scrollable in jQuery Mobile? -

from can tell, although jquery-mobile-powered pages can contain divs overflow set scroll or auto, , these divs can scrolled one-screen bar or mouse wheel, cannot scrolled using arrow keys, page-up/page-down, or home/end. instead, official "page" div (with data-role="page") absorbs input. perhaps other divs can't acquire focus, i'm not sure. is there way around this? edit: jsfiddle of simple example: https://jsfiddle.net/qogz0shx/ <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"> </script> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"/> <style> #outer { overflow:scroll; height: 50vh; width: 50vw; } #inner { height: 500vh; width: 500vw; } ...
Read more

android - Keyboard hides my half of edit-text and button below it even in scroll view -

i having trouble keyboard covers edit-text , half of button in scroll view. here's layout , please tell me how should resolve problem. many questions on topic none of them s working me. <?xml version="1.0" encoding="utf-8"?> <linearlayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:background="@drawable/bg" android:layout_height="match_parent"> <scrollview android:layout_width="match_parent" android:fillviewport="true" android:layout_height="match_parent"> <relativelayout android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="vertical"> <linearlayout android:layout_width="match_parent" android:layout_height="w...
Read more