How to create border for sme specific cells?

[databicky]

i tried some code to create border for excel sheet, for particular cell iam able to write but while i am trying with some set of cells means it is showing error.​

[Chaitanya_Raju · Accepted solution]

Hi @Mohammed sadamusean​ ,

Can you please try similar to below code using loops, I have implemented a similar use case that might be useful, please let me know if you need further

 top = Side(border_style = 'thin',color = '00000000')
 bottom = Side(border_style = 'thin',color = '00000000')
 left = Side(border_style = 'thin',color = '00000000')
right = Side(border_style = 'thin',color = '00000000')
border = Border(top = top,bottom = bottom,left = left,right = right)
 
for cell in sheet['C18:C56']:
      cell[0].fill = PatternFill("solid", start_color="00C0C0C0")
       cell[0].border = border

Happy Learning!!