(data, filename, log=True, convert_strings_to_urls=True)
| 369 | filename = filename + ".xlsx" |
| 370 | return filename |
| 371 | def write_excel(data, filename, log=True, convert_strings_to_urls=True): |
| 372 | |
| 373 | data = clean_data(data) |
| 374 | data = convert_nested_to_json_for_excel(data) |
| 375 | |
| 376 | try: |
| 377 | filename = fix_excel_filename(filename) |
| 378 | write_workbook(data, filename, convert_strings_to_urls) |
| 379 | |
| 380 | if log: |
| 381 | print(f"View written Excel file at {filename}") |
| 382 | except PermissionError: |
| 383 | prompt(f"{filename} is currently open in another application (e.g., Excel). Please close the the Application and press 'Enter' to save.") |
| 384 | return write_excel(data, filename, log, convert_strings_to_urls) |
| 385 | return filename |
| 386 | MAX_EXCEL_LINKS = 65528 |
| 387 | def write_workbook(data, filename, strings_to_urls = True): |
| 388 | import xlsxwriter |
no test coverage detected