Home > other >  About xlwings call cell, a null value cell return different values
About xlwings call cell, a null value cell return different values

Time:02-21

The import OS, xlwings as xw
App=xw. App (visible=False, add_book=False)
App. Screen_updating=False
App. Display_alerts=False
Path2=r "C: \ Users \ \ Desktop \ 31370 kk \ XXXXXXXX XLSX"
Wb=app. Books. The open (path2)
SHT=wb. Sheets [0]

Kk=SHT. Range (" K5: AO5 "). The value

Print (kk)
In (" K5: AO5 "), in this area, there is no any data with multiple cell, I at home computer call value is kk, return null cell "None", in a unit of the computer, he returned to 0.0, and this is why ah, I am using pycharm, is to set up or what the reason,
  • Related