title: how to add border to a range of cells using xlsxwriter?
body: <p>I want to add border around a range of cells like this 
  <a href="https://i.stack.imgur.com/xIyHn.png" rel="noreferrer">image1</a>,
  but my output file looks like this when I applied "set_column" function
  <a href="https://i.stack.imgur.com/W9CvJ.png" rel="noreferrer">image2</a>.
  instead of "set_column", is there any other functions to use? </p>
  
  <pre><code>writer=pd.ExcelWriter('merge_'+name+'.xlsx',
                        engine='xlsxwriter')
  workbook  = writer.book
  data.to_excel(writer, sheet_name=SheetName,index=False,na_rep=0)
  worksheet = writer.sheets[SheetName]
  border_format=workbook.add_format({
                              'border':1,
                              'align':'left',
                              'font_size':10
                             })
  worksheet.set_column('A:D',12,border_format)
  </code></pre>
  
  <p>Thank you in advance,</p>