Advertisement
dartie

Write Spreadsheet with openpyxl

Jan 23rd, 2020
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.80 KB | None | 0 0
  1. def write_spreadsheet(xls_file, record_list, overwrite=True):
  2.     """
  3.    
  4.    :param xls_file: output filename
  5.    :param record_list: [ [ 'r1f1', 'r1f2' ], [ 'r2f1', 'r2f2' ] ]
  6.    :param overwrite: Flag for overwriting the output file in case it exists, or appending records
  7.    :return:
  8.    """
  9.     if overwrite:
  10.         add_record_xls_workbook = openpyxl.Workbook()
  11.     else:
  12.         if os.path.exists(xls_file):
  13.             add_record_xls_workbook = openpyxl.load_workbook(xls_file)
  14.         else:
  15.             add_record_xls_workbook = openpyxl.Workbook()
  16.  
  17.     # grab the active worksheet
  18.     active_sheet = add_record_xls_workbook.active
  19.  
  20.     # append row
  21.     for row in record_list:
  22.         active_sheet.append(row)
  23.  
  24.     # Save the file
  25.     add_record_xls_workbook.save(xls_file)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement