如題，我用xlwings洗掉了檔案里最后一行的資料，結果發現內容是洗掉了但程式還是會讀取到最后一行為空值。不知道該怎么辦
uj5u.com熱心網友回復：
這是我洗掉資料的代碼
# 資料還原
def m_button5OnButtonClick(self, event):
self.sheet = self.document.sheets['2003']
last_row = self.sheet.used_range.rows.count
number=last_row-2530
for i in range(number):
self.content_delete('A'+str(last_row))
self.content_delete('B' + str(last_row))
self.content_delete('C' + str(last_row))
self.content_delete('D' + str(last_row))
last_row=last_row-1
def content_delete(self,address):
self.sheet.range(address).clear()
uj5u.com熱心網友回復：
已經解決！！洗掉陳述句應該這么寫
# 資料還原
def m_button5OnButtonClick(self, event):
self.sheet = self.document.sheets['2003']
last_row = self.sheet.used_range.rows.count
number=last_row-2530
for i in range(number):
self.content_delete('A'+str(last_row))
# self.content_delete('B' + str(last_row))
# self.content_delete('C' + str(last_row))
# self.content_delete('D' + str(last_row))
last_row=last_row-1
def content_delete(self,address):
self.sheet.range(address).api.EntireRow.Delete()
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/80768.html