Skip to content

srslakshmi1997/python-data-export-to-excel-from-sqlite3

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 

Repository files navigation

python-data-export-to-excel-from-sqlite3

Application to export all the data in a sqlite3 DB into an excel sheet

This program reads the data from the sqlite3 database 'Quotedatabase.db' and writes all the data to the excel sheet 'Quotedb.xlsx'.

Packages :

xlsxwriter: This package is to create a workbook, sheet and write data to the excel.
sqlite3: This package is to establish a connection with the sqlite3 DB and read data from the same.

File Description:

DatabaseToExcel.py : Python code with the logic to perform read write.
Quotedatabase.db : Database file contating data to write.
Quotedb.xlsx : Exported excel file on running the appliation.

About

Application to export all the data in a sqlite3 DB into an excel sheet

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages