Answers for "win32com excel delete same cell"

0

win32com excel delete same cell

sh.Cells(1,1).Value =1             #A1 assignment is 1
sh.Cells(1,1).Font.Bold = True     # 
sh.Range(sh.Cells(1, 1),sh.Cells(1,5)).Font.Name = "Times New Roman"#Select the specified area
sh.Range(sh.Cells(1, 1), sh.Cells(1,5)).Font.Size = 10.5
sh.Cells(row, col).Name = "Arial"# 
sh.Rows(row).Delete()#    
sh.Columns(row).Delete()#  

sh.Range(sh.Cells(1,1),sh.Cells(1,1)).HorizontalAlignment = 
win32.constants.xlCenter # xlCenter

sh.SaveAs(path+'demo.xls')
ss.Close(False)
xl.Application.Quit()
1234567891011121314
Posted by: Guest on July-05-2021

Browse Popular Code Answers by Language