python的excel里单元格为空白_Python openpyxl读取Excel文件并为空白单元格设置null

from openpyxl import load_workbook

import json

wb = load_workbook(filename='Deployment Plan_2015.xlsx',read_only=True)

ws = wb['Deployment Plan']

x = 4

data = []

for row in ws.rows:

for cell in row:

if not cell.value:

print('null')

x = x+1

else:

print(ws['A'+str(x)].value)

data.append(ws['A'+str(x)].value)

x = x+1

print(json.JSONEncoder(data).encode(data))

它只读取第一个第一个单元格（项目1之后还有4个项目），然后将所有内容打印为null：

^{pr2}$

它继续几个空的结尾是：Traceback (most recent call last):

File "C:\Users\Maynor\Documents\Python\projects\DPprojectlister.py", line 15, in

print(ws['A'+str(x)].value)

File "C:\Python34\lib\site-packages\openpyxl-2.2.2-py3.4.egg\openpyxl\worksheet\worksheet.py", line 400, in __getitem__

return self._get_cell(key)

File "C:\Python34\lib\site-packages\openpyxl-2.2.2-py3.4.egg\openpyxl\worksheet\iter_worksheet.py", line 168, in _get_cell

cell = tuple(self.get_squared_range(col, row, col, row))[0]

IndexError: tuple index out of range

假设在JSON编码的数据到达列的末尾后打印它