Excel
Exporting SQL Server Query Output to an Excel File
Export SQL Server query results to XLSX with pyodbc and pandas, and see what SSMS, bcp and the Import and Export Wizard give you instead.
7 min read
Topic
SQL Server
T-SQL craft for Microsoft's database: execution plans, tempdb, deadlocks and the maintenance jobs that earn their keep.
Excel
Writing a DataFrame to Excel With Formatting in pandas
Format a pandas DataFrame in Excel with XlsxWriter: header style, number and date formats, auto-fit widths, a table with banding and conditional formatting.
7 min read
Excel
Exporting a Query to Excel From PostgreSQL With Python
Run a PostgreSQL query from Python and write an Excel file with correct types, converting timestamptz, numeric and ids so the workbook opens cleanly.
7 min read
ExcelGuide
Sending Database Results to Excel Properly Every Time
Export SQL results to Excel that open cleanly: keep types and dates, carry formatting, use several sheets, resist formula injection and run on a schedule.
18 min read
Get new articles by email
We send one email when a new article is published. No spam.