用wizard导入excel数据

[d_yang]

作为一个quick note吧。
OE里的csv导入数据功能形同摆设，通俗地说就是弱爆了。
今天尝试一下用excel文件来导入数据。

在python里读取excel格式的lib很多，这里我选用的是xlrd。
上代码先：

<br /># -*- coding: utf-8 -*-<br /><br />from osv import osv, fields<br />import time, xlrd, base64<br /><br /><br />class bank_bill_import(osv.osv_memory):<br />&nbsp; &nbsp; <br />&nbsp; &nbsp; _name = &quot;fg_account.bank_bill.import.wizard&quot;<br />&nbsp; &nbsp; _description = &quot;导入账单&quot;<br />&nbsp; &nbsp; <br />&nbsp; &nbsp; _columns = {<br />&nbsp; &nbsp; &nbsp; &nbsp; &#039;excel&#039;: fields.binary(&#039;excel文件&#039;, filters=&#039;*.xls&#039;),<br />&nbsp; &nbsp; }<br />&nbsp; &nbsp; <br />&nbsp; &nbsp; def import_bill(self, cr, uid, ids, context=None):<br />&nbsp; &nbsp; &nbsp; &nbsp; 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; <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; print sh.name, sh.nrows, sh.ncols<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for rx in range(sh.nrows):<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for ry in range(sh.ncols):<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; print sh.cell(rx, ry).value<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; #这里做爱做的事情<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; return {&#039;type&#039;: &#039;ir.actions.act_window_close&#039;}<br />

其实重点就在于：

excel = xlrd.open_workbook(file_contents=base64.decodestring(wiz.excel))

[mrshelly]

Good 多谢分享....

[pingwe]

这代码写在那里呢？

[Joshua]

回楼上的 就是一个wizard..