python - 如何在openpyxl中获取值以及单元格编号？

Question

下面是读取单元格值的代码。但我想打印一个字典，键作为单元格编号，值作为单元格的值。像 - {A1,value}。请帮帮我

from openpyxl import Workbook,load_workbook 
    
    wb = load_workbook('dds.xlsx')
    ws = wb.active
    
    cell_range_c = ws["c"]
    
    
    print(cell_range_c[0].value)

标签： pythonopenpyxl

Answer 1

ret = {x.coordinate: x.value for x in ws["c"]}