#!/usr/bin/env python
# -*- coding: utf-8 -*-

import datetime
import mysql.connector
from openpyxl import Workbook

cnx = mysql.connector.connect(
        user='user',
        password='pwd',
        host='127.0.0.1',
        db='news')
cursor = cnx.cursor()

query = ("select article_id, title, meta_description," +
        "summary, text, url_news, url_source_news from article;")

cursor.execute(query,)

results = cursor.fetchall()
wb = Workbook()
ws = wb.create_sheet(0)
ws.title = "news"
ws.append(cursor.column_names)

for row in results:
    ws.append(row)

workbook_name = "news"
wb.save(workbook_name + ".xlsx")

cursor.close()
cnx.close()

Traceback (most recent call last):
  File "dbtoexcel.py", line 27, in <module>
    ws.append(row)
  File "C:UsersDellMiniconda3libsite-packagesopenpyxlworksheetworksheet.py", line 777, in append
    cell = Cell(self, row=row_idx, col_idx=col_idx, value=content)
  File "C:UsersDellMiniconda3libsite-packagesopenpyxlcellcell.py", line 115, in __init__
    self.value = value
  File "C:UsersDellMiniconda3libsite-packagesopenpyxlcellcell.py", line 299, in value
    self._bind_value(value)
  File "C:UsersDellMiniconda3libsite-packagesopenpyxlcellcell.py", line 196, in _bind_value
    value = self.check_string(value)
  File "C:UsersDellMiniconda3libsite-packagesopenpyxlcellcell.py", line 160, in check_string
    raise IllegalCharacterError
openpyxl.utils.exceptions.IllegalCharacterError