我試圖從sheet除前三列和從坐標(biāo) (U - AA) 開始的所有列之外的所有填充行中刪除。除了最后的標(biāo)題，我必須刪除所有填寫的信息。如何刪除我不明白的列，但是當(dāng)我運行刪除行的腳本時，信息仍然存在，只刪除了樣式。如何正確執(zhí)行此類操作？class DownloadRfiExcelFile(APIView): """ Download rfi excel file to user """ def get(self, request, format=None, **kwargs): file = default_storage.url('test.xlsx') wb = load_workbook(filename=file) response = HttpResponse(content_type='application/vnd.ms-excel') response['Content-Disposition'] = 'attachment; filename="test.xlsx"' sheet = wb["RT"] for rowNum in range(3, 1114): sheet.delete_rows(rowNum) for col in sheet.iter_cols(): for cell in col: # delete from U to AA row wb.save(response) return response
1 回答
慕慕森
TA貢獻1856條經(jīng)驗 獲得超17個贊
要刪除rows并columns僅使用：
sheet.delete_rows({first_row}, {amount})sheet.delete_cols({first_col}, {amount})
因此，請閱讀openpyxl 文檔中的更多信息。請注意，列表示為整數(shù)A == 1, B ==2，依此類推。
import string
def col2num(col):
# Utility function to convert column letters to numbers
num = 0
for c in col:
if c in string.ascii_letters:
num = num * 26 + (ord(c.upper()) - ord('A')) + 1
return num
# Setting initial values for deletion
starting_row = 4
starting_col = col2num('U')
last_col = col2num('AA')
# Deleting rows and columns
sheet.delete_rows(starting_row, sheet.max_row-starting_row)
sheet.delete_cols(starting_col, last_col-starting_col)
添加回答
舉報
0/150
提交
取消