Snippet that shows saving multiple database table to a tabbed excel spreadsheet.

pandas_multi_sheet_output.py

import sqlite3
import pandas as pd

conn = sqlite3.connect("database.db")

writer = pd.ExcelWriter('order_inv_output.xlsx', engine='xlsxwriter')
pd.read_sql_query('select * from tbl_1', conn).to_excel(writer, sheet_name='Sheet 1', index=False)
pd.read_sql_query('select * from tbl_2', conn).to_excel(writer, sheet_name='Sheet 2', index=False)
pd.read_sql_query('select * from tbl_3', conn).to_excel(writer, sheet_name='Sheet 3', index=False)
writer.save()