我正在使用Python(Canopy)
中的openpyxl
包来使用Excel文件。我们可以在这个链接中找到这个教程:LINK
you can also use the openpyxl.worksheet.Worksheet.iter_rows() method:
>>> tuple(ws.iter_rows('A1:C2'))
((<Cell Sheet1.A1>, <Cell Sheet1.B1>, <Cell Sheet1.C1>),
(<Cell Sheet1.A2>, <Cell Sheet1.B2>, <Cell Sheet1.C2>))
>>> for row in ws.iter_rows('A1:C2'):
... for cell in row:
... print cell
<Cell Sheet1.A1>
<Cell Sheet1.B1>
<Cell Sheet1.C1>
<Cell Sheet1.A2>
<Cell Sheet1.B2>
<Cell Sheet1.C2>
我们如何在Python中导入openpyxl.worksheet.Worksheet.iter_rows()
方法?我使用了以下代码:
import openpyxl as op
ms = op.load_workbook('mtest.xlsx')
ws = ms.active
op.worksheet.Worksheet.iter_rows()
这段代码返回:
type object 'Worksheet' has no attribute 'iter_rows'
问题是什么?
iter_rows()
方法。 - Charlie Clark