python自学练习-excel-电子表格翻转

from openpyxl.styles import Font
import openpyxl
from openpyxl.utils import get_column_letter,column_index_from_string
import sys




wb=openpyxl.load_workbook("D://project//test.xlsx")

sheet =wb['Sheet1']

maxcolumn=sheet.max_column
mydict={}
for j in range(int(maxcolumn)):
	list2=list(sheet.columns)[j]
	letter=get_column_letter(j+1)
	
	for cell in list2:
		rowdata=cell.row
		va=cell.value
		mydict[j,rowdata]=va
		cell.value=''
	j=j+1

keylist=list(mydict.keys())


for i in range(len(keylist)):
	x=keylist[i][0]
	y=keylist[i][1]

	value=mydict[x,y]
	
	let=get_column_letter(y)
	sheet[let+str(x+1)].value=value
wb.save('test_copy.xlsx')