search

kennethreitz / records

SQL for Humans™
https://pypi.python.org/pypi/records/
ISC License
7.14k stars 570 forks source link

Export XLS error #206

Open zhonghai9967 opened 3 years ago

zhonghai9967 commented 3 years ago

import records db=records.Database('sqlite:///d:/a.db') rows=db.query('select * from tjb') with open('d:/a.xls', 'wb') as f: f.write(rows.export('xls'))

from openpyxl.reader.excel import ExcelReader, load_workbook ImportError: cannot import name 'ExcelReader' from 'openpyxl.reader.excel' (C:\Python38\lib\site-packages\openpyxl\reader\excel.py)

zhonghai9967 commented 3 years ago

with open('d:/a.xls', 'wb') as f: f.write(rows.export('xls'))

sqlalchemy.exc.ProgrammingError: (sqlite3.ProgrammingError) Cannot operate on a closed database. (Background on this error at: http://sqlalche.me/e/13/f405)