上传的excel文件在内存里就能打开操作。

<br /><br />for wiz in self.browse(cr,uid,ids):<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if not wiz.excel: continue<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; excel = xlrd.open_workbook(file_contents=base64.decodestring(wiz.excel))<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sh = excel.sheet_by_index(0)<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for rx in range(sh.nrows):<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; print &#039;processing line &#039;, rx<br />...<br /><br />

如果想生成excel文件并下载（参考下载翻译那个wizard一样，两个state: choose, get, 然后利用binary field，提供给用户下载的连接出来）：

<br /><br />#.....从数据库取数据，计算，blahblah<br /><br />&nbsp; &nbsp; &nbsp; &nbsp; book = xlwt.Workbook(encoding=&#039;utf-8&#039;)<br />&nbsp; &nbsp; &nbsp; &nbsp; sheet = book.add_sheet(u&#039;统计&#039;)<br /><br />&nbsp; &nbsp; &nbsp; &nbsp; buf=cStringIO.StringIO()<br />&nbsp; &nbsp; &nbsp; &nbsp; book.save(buf)<br />&nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; out=base64.encodestring(buf.getvalue())<br />&nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; self.write(cr, uid, ids, {&#039;state&#039;:&#039;get&#039;, &#039;data&#039;:out, &#039;name&#039;:this.name }, context=context)<br /><br /><br />

被贴了 就转图片为文字儿吧:
<br / https://pypi.python.org/pypi/python-stdnum br />

<br /><br />...<br />&gt;&gt;&gt; from stdnum.iso7064 import mod_11_2<br />&gt;&gt;&gt; mod_11_2.calc_check_digit(&#039;44022919890604423&#039;)<br />&#039;X&#039;<br />&gt;&gt;&gt; mod_11_2.validate(&#039;44022919890604423X&#039;)<br />&#039;44022919890604423X&#039;<br />&gt;&gt;&gt; mod_11_2.validate(&#039;440229198906044234&#039;)<br />Traceback (most recent call last):<br />&nbsp; File &quot;&lt;stdin&gt;&quot;, line 1, in &lt;module&gt;<br />&nbsp; File &quot;D:\Program Files\Python27\lib\site-packages\stdnum\iso7064\mod_11_2.py&quot;,<br /> line 65, in validate<br />&nbsp; &nbsp; raise InvalidChecksum()<br />stdnum.exceptions.InvalidChecksum: The number&#039;s checksum or check digit is inval<br />id.<br />&gt;&gt;&gt; mod_11_2.validate(&#039;440229198906044231&#039;)<br />Traceback (most recent call last):<br />&nbsp; File &quot;&lt;stdin&gt;&quot;, line 1, in &lt;module&gt;<br />&nbsp; File &quot;D:\Program Files\Python27\lib\site-packages\stdnum\iso7064\mod_11_2.py&quot;,<br /> line 65, in validate<br />&nbsp; &nbsp; raise InvalidChecksum()<br />stdnum.exceptions.InvalidChecksum: The number&#039;s checksum or check digit is inval<br />id.<br />&gt;&gt;&gt; mod_11_2.validate(&#039;440229198906044236&#039;)<br />Traceback (most recent call last):<br />&nbsp; File &quot;&lt;stdin&gt;&quot;, line 1, in &lt;module&gt;<br />&nbsp; File &quot;D:\Program Files\Python27\lib\site-packages\stdnum\iso7064\mod_11_2.py&quot;,<br /> line 65, in validate<br />&nbsp; &nbsp; raise InvalidChecksum()<br />stdnum.exceptions.InvalidChecksum: The number&#039;s checksum or check digit is inval<br />id.<br />&gt;&gt;&gt; mod_11_2.validate(&#039;44022919890605423X&#039;)<br />Traceback (most recent call last):<br />&nbsp; File &quot;&lt;stdin&gt;&quot;, line 1, in &lt;module&gt;<br />&nbsp; File &quot;D:\Program Files\Python27\lib\site-packages\stdnum\iso7064\mod_11_2.py&quot;,<br /> line 65, in validate<br />&nbsp; &nbsp; raise InvalidChecksum()<br />stdnum.exceptions.InvalidChecksum: The number&#039;s checksum or check digit is inval<br />id.<br />&gt;&gt;&gt;<br /><br />...<br />

应该先判断一下身份证格式对不对，不然这样出的数据应该报错吧。。

在收货（发货），
开票，
收款（付款）
都完成之后
状态就可以完成了，具体可以看 采购订单的 工作流


不过有些早期版本有bug，状态一直完成不了，
要在 设置 - 采购 - 发票生成方式 这里 修改 为 预先生成发票草稿。

谢谢分享。

如果是(Openerp非常牛逼的) create on the fly 是不是会绕过这个检查？

不推荐用这个，如果需求变更需要同时用attrs属性，states会失效，这是个坑。

官方已经逐步转入都用 modifier了，校长说这里也有坑，必须用双引号。注意一下就好了。

谢谢jeff大婶分享 🙂

虽然暂时还看不懂，谢谢楼主分享，继续哈 🙂

赞...... 很不错的经验.

不过, OE 似乎不太喜欢 Windows Only 的东西....

看起来不错

关注下

赞.... 在国内 自动催款还是有些突兀.... 还是手工发送比较好.....

我是在wizard执行的最后一步来执行client action的。
client action return false， wizard不会关闭的。

可以

<br /> return {&#039;type&#039;: &#039;ir.actions.act_window_close&#039;};<br />

problem solved.

谢谢，比如我在函数    fields_view_get 中如何获取这个呢