Advertisement
Guest User

XlsxWriter merge cell issue

a guest
Jul 28th, 2016
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.37 KB | None | 0 0
  1. import xlsxwriter
  2.  
  3. workbook = xlsxwriter.Workbook('test.xlsx', {'constant_memory': True})
  4.  
  5. worksheet = workbook.add_worksheet()
  6.  
  7. HEADERS = [('A1:A3', 'SKU Number'),('B1:B3', 'UPC')]
  8.  
  9. merge_format = workbook.add_format({'align': 'center', 'valign': 'vcenter', 'bold': 1})
  10.  
  11. for range, data in HEADERS:
  12.     worksheet.merge_range(range, data, merge_format)
  13.  
  14. workbook.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement