37,721
社区成员
发帖
与我相关
我的任务
分享
from openpyxl import load_workbook
data1 = load_workbook('C:\\Users\\Administrator\\Desktop\\test.xlsx')
sheetnames = data1.get_sheet_names()
ws = data1.get_sheet_by_name(sheetnames[0])
print(ws.max_row)
print(ws.max_column)
data_dic = {}
for rx in range(2, ws.max_row + 1):
temp_list = []
pid = rx
w1 = ws.cell(row=rx, column=1).value
w2 = ws.cell(row=rx, column=2).value
w3 = ws.cell(row=rx, column=3).value
w4 = ws.cell(row=rx, column=4).value
w5 = w3*w4
temp_list = [w1, w2, w3, w4,w5]
data_dic[pid] = temp_list
print(data_dic[2])
print(data_dic[3])
[/quote][/quote]
python版本:3.5.2
openpyxl 版本 :2.4.1
[/quote]
意思是需要我改变版本?
[/quote]
大神,我搞定了。谢谢你啦,麻烦你一天了。感谢感谢
from openpyxl import load_workbook
data1 = load_workbook('C:\\Users\\Administrator\\Desktop\\test.xlsx')
sheetnames = data1.get_sheet_names()
ws = data1.get_sheet_by_name(sheetnames[0])
print(ws.max_row)
print(ws.max_column)
data_dic = {}
for rx in range(2, ws.max_row + 1):
temp_list = []
pid = rx
w1 = ws.cell(row=rx, column=1).value
w2 = ws.cell(row=rx, column=2).value
w3 = ws.cell(row=rx, column=3).value
w4 = ws.cell(row=rx, column=4).value
w5 = w3*w4
temp_list = [w1, w2, w3, w4,w5]
data_dic[pid] = temp_list
print(data_dic[2])
print(data_dic[3])
[/quote][/quote]
python版本:3.5.2
openpyxl 版本 :2.4.1
[/quote]
意思是需要我改变版本?
from openpyxl import load_workbook
data1 = load_workbook('C:\\Users\\Administrator\\Desktop\\test.xlsx')
sheetnames = data1.get_sheet_names()
ws = data1.get_sheet_by_name(sheetnames[0])
print(ws.max_row)
print(ws.max_column)
data_dic = {}
for rx in range(2, ws.max_row + 1):
temp_list = []
pid = rx
w1 = ws.cell(row=rx, column=1).value
w2 = ws.cell(row=rx, column=2).value
w3 = ws.cell(row=rx, column=3).value
w4 = ws.cell(row=rx, column=4).value
w5 = w3*w4
temp_list = [w1, w2, w3, w4,w5]
data_dic[pid] = temp_list
print(data_dic[2])
print(data_dic[3])
[/quote][/quote]
python版本:3.5.2
openpyxl 版本 :2.4.1
from openpyxl import load_workbook
data1 = load_workbook('C:\\Users\\Administrator\\Desktop\\test.xlsx')
sheetnames = data1.get_sheet_names()
ws = data1.get_sheet_by_name(sheetnames[0])
print(ws.max_row)
print(ws.max_column)
data_dic = {}
for rx in range(2, ws.max_row + 1):
temp_list = []
pid = rx
w1 = ws.cell(row=rx, column=1).value
w2 = ws.cell(row=rx, column=2).value
w3 = ws.cell(row=rx, column=3).value
w4 = ws.cell(row=rx, column=4).value
w5 = w3*w4
temp_list = [w1, w2, w3, w4,w5]
data_dic[pid] = temp_list
print(data_dic[2])
print(data_dic[3])
[/quote]
from openpyxl import load_workbook
data1 = load_workbook('C:\\Users\\Administrator\\Desktop\\test.xlsx')
sheetnames = data1.get_sheet_names()
ws = data1.get_sheet_by_name(sheetnames[0])
print(ws.max_row)
print(ws.max_column)
data_dic = {}
for rx in range(2, ws.max_row + 1):
temp_list = []
pid = rx
w1 = ws.cell(row=rx, column=1).value
w2 = ws.cell(row=rx, column=2).value
w3 = ws.cell(row=rx, column=3).value
w4 = ws.cell(row=rx, column=4).value
w5 = w3*w4
temp_list = [w1, w2, w3, w4,w5]
data_dic[pid] = temp_list
print(data_dic[2])
print(data_dic[3])
[/quote]运行的时候会这样子,运行不了,,不过我改了下路径,改成了我当前的目录
from openpyxl import load_workbook
data1 = load_workbook('C:\\Users\\Administrator\\Desktop\\test.xlsx')
sheetnames = data1.get_sheet_names()
ws = data1.get_sheet_by_name(sheetnames[0])
print(ws.max_row)
print(ws.max_column)
data_dic = {}
for rx in range(2, ws.max_row + 1):
temp_list = []
pid = rx
w1 = ws.cell(row=rx, column=1).value
w2 = ws.cell(row=rx, column=2).value
w3 = ws.cell(row=rx, column=3).value
w4 = ws.cell(row=rx, column=4).value
w5 = w3*w4
temp_list = [w1, w2, w3, w4,w5]
data_dic[pid] = temp_list
print(data_dic[2])
print(data_dic[3])