Excel
Using EPPlus or ClosedXML for Excel in C Sharp Projects
Choose between EPPlus and ClosedXML for reading and writing xlsx in C Sharp: licensing, API, performance, formulas and when to use the Open XML SDK instead.
8 min read
Topic
Excel
Where the business keeps its data. Reading workbooks, taming dates and formulas, and moving sheets to and from a database.
Excel
Reading and Writing Excel in Java With Apache POI Safely
Read and write Excel in Java with Apache POI: cell types, DataFormatter, formulas, streaming with SXSSF and event readers, and zip safety limits.
7 min read
Excel
Reading Excel in the Browser With SheetJS Without a Server
Parse an uploaded Excel file in the browser with SheetJS: read it, pick a sheet, convert to JSON, handle dates, limits and security, then export a workbook.
7 min read
Excel
Reading Excel Files in Node With exceljs Step by Step
Read and write xlsx in Node.js with exceljs: load a workbook, read typed cells, handle formulas and dates, stream large sheets and avoid common traps.
7 min read
Excel
Using Parameters in a Database Query From Excel Safely
Drive a database query from cells in Excel with Power Query parameters, bind values instead of pasting text, and avoid SQL injection and stale dates.
7 min read
Excel
Connecting Excel to SQL Server With Power Query and ODBC
Connect Excel to SQL Server with the built in connector or ODBC: choose Windows or SQL authentication, encryption, a native query and read only access.
6 min read
Excel
Connecting Excel to MySQL With the Official Connector
Connect Excel to MySQL with Connector/NET or Connector/ODBC, create a read only user, run a query with Power Query and fix authentication and SSL errors.
6 min read
Excel
Connecting Excel to PostgreSQL With ODBC Step by Step
Install the psqlODBC driver, create a data source, connect Excel to PostgreSQL with a read only role, run a query and fix the usual bitness and SSL problems.
7 min read
ExcelGuide
A Practical Guide to Connecting Excel Directly to a Database
Connect Excel to PostgreSQL, MySQL and SQL Server with connectors and ODBC, using read only accounts, parameters, safe credentials, refresh and speed checks.
16 min read
Excel
Access Versus SQLite Versus PostgreSQL for a Small App
Compare Microsoft Access, SQLite and PostgreSQL for a small team replacing a spreadsheet, by users, platform, interface, limits, safety and upgrade path.
7 min read
Excel
Audit Trails and History That Excel Cannot Give You
Excel cannot say who changed a cell and why. See what version history does, and build an audit trail in PostgreSQL with triggers or temporal tables.
8 min read
Excel
Shared Excel Files and the Lost Update Problem Explained
How two people editing the same Excel file lose each other's changes, what co-authoring and locks do about it, and how a database prevents lost updates.
7 min read
Get new articles by email
We send one email when a new article is published. No spam.