How to create border for sme specific cells?

databicky — Thu, 12 Jan 2023 12:06:31 GMT

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.

Re: How to create border for sme specific cells?

Chaitanya_Raju — Thu, 12 Jan 2023 17:09:31 GMT

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!!

topic Re: How to create border for sme specific cells? in Data Engineering

How to create border for sme specific cells?

Re: How to create border for sme specific cells?