python excelファイルの操作

  python excel      
            openpyxl,     pip install openpyxl![         ](https://img-blog.csdnimg.cn/2021030116561097.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1lhbmJhZGFyZW4=,size_16,color_FFFFFF,t_70)
#      ，     openpyxl
import openpyxl

#   excel  
wb = openpyxl.load_workbook("yanba.xlsx")
#     sheet 
sh = wb["yanba"]
#   excel      ，   
data = sh.cell(row=1, column=2).value
#         
print(data)
![         ](https://img-blog.csdnimg.cn/20210301170249250.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1lhbmJhZGFyZW4=,size_16,color_FFFFFF,t_70)
#     
data1=sh.cell(row=5,column=2,value="      ")
#      
wb.save("yanba.xlsx")