最近在用openpyxl编写EXCEL文件,希望能只取任意列,然后写入新表
例如:
sheet1 : A B C
1 2 3
4 5 8
但想只取A 、C列
直接写入 sheet2
wb = load_workbook(self.file)
sheets = wb.get_sheet_names()
sheet = sheets[0]
ws = wb[sheet]
rows = ws.max_row
result=[]
for i in range(1,rows+1):
avalue = ws.cell(row=i,column='A').value
cvalue = ws.cell(row=i,column='C').value
result.append((avalue, cvalue))
print(result)