# -*- coding: utf-8 -*-
"""
Created on Mon Jun 20 15:30:01 2022
"""
import openpyxl
import os
#from openpyxl.utils import get_column_letter
from openpyxl.styles import Alignment,Border,Side
#,Border,Side,Font
#from openpyxl.utils.cell import get_column_letter
pth = r'\Python\compress'
for folder in os.listdir(pth):
if os.path.isdir(os.path.join(pth,folder)):
sourcefolder = os.path.join(pth,folder)
for file in os.listdir(sourcefolder):
if file.split('(')[0]=='name':
sourcefile = os.path.join(sourcefolder,file)
newname = file.split('(')[0] + file.split('(')[1][0:7] + '.xlsx'
newfile = os.path.join(sourcefolder,newname)
print(newfile)
wb = openpyxl.load_workbook(sourcefile)
wb.sheetnames
sheet = wb["sheet"]
alignment = Alignment(horizontal='center', vertical='center', text_rotation=0, wrap_text=True)
border = Border(left=Side(style='thin'),bottom=Side(style='thin'),right=Side(style='thin'),top=Side(style='thin'))
sheet['A2'] = '1'
sheet['A3'] = '2'
sheet['A4'] = '3'
sheet['A5'] = '4'
sheet['A6'] = '5'
sheet['B3'] = '3213'
sheet['B4'] = '4532523'
sheet['B5'] = '32131'
sheet['B6'] = '643534'
sheet['C3'] = 'erwqwe'
sheet['C4'] = 'sfsd'
sheet['C5'] = 'gfdgds'
sheet['C6'] = 'rewrw'
sheet['D3'] = 'xxx'
sheet['D4'] = 'yyy'
sheet['D5'] = 'zzz'
sheet['D6'] = 'mmm'
for r in sheet:
# print(r)
# sheet.row_dimensions[r].height = int(58)
for c in r:
# print(c)
c.alignment=openpyxl.styles.Alignment(wrapText=True,horizontal='center', vertical='center')
alignment = Alignment(horizontal='center', vertical='center', text_rotation=0, wrap_text=True)
sheet['A6'].border =border
sheet['B6'].border =border
sheet['C6'].border =border
sheet['D6'].border =border
# newfile = os.path.join(pth,file.split('(')[0]
#print(newfile)
wb.save(newfile)