433
社区成员
发帖
与我相关
我的任务
分享使用python检测空白Excel单元格
我编写了一个python代码,用于将数据从多个excel文件转换为单个csv文件,但它无法正常工作.我在以下程序中尝试使用XL_CELL_EMPTY或XL_CELL_BLANK代替None.但没有任何工作.它给出了以下错误
Traceback (most recent call last):
File "Excel_to_CSV_1.py", line 35, in <module>
while Sh_B1.cell(i,j).value != None :
File "/usr/lib/pymodules/python2.7/xlrd/sheet.py", line 245, in cell
self._cell_types[rowx][colx],
IndexError: array index out of range
这是该计划：
import xlrd
import os.path
from xlrd import open_workbook,empty_cell
book1 = xlrd.open_workbook("Excel_1.xls")
Sh_B1 = book1.sheet_by_index(0)
book2 = xlrd.open_workbook("Excel_2.xls")
Sh_B2 = book2.sheet_by_index(0)
i = 1
j = 1
file = open("Output.txt", "w")
while Sh_B1.cell(i,j).value != None :
while Sh_B1.cell(i,j).value != None :
D1 = Sh_B1.cell(i,j).value
D2 = Sh_B2.cell(i,j).value
DB1 = str(D1)+ "," + str(D2)
file.write("".join(DB1+ "\n"))
j = j + 1
j = 1
print "j=1"
i = i + 1
file.close
我哪里错了？
...全文
请发表友善的回复…
发表回复
weixin_38104241 2019-09-12
- 打赏
- 举报
xlrd的Sheetobject有一个nrows和一个ncols属性,可以迭代单元格.
import xlrd
book = xlrd.open_workbook("my_file.xls")
sheet = book.sheet_by_index(0) # or: sheet_by_name(Sheet 1")
for row_index in xrange(sheet.nrows):
for col_index in xrange(sheet.ncols):
value = sheet.cell(rowx=row_index,colx=col_index).value
