Excel
Using the Sheets API From Python to Read and Write Data
Use the Google Sheets API from Python: create a service account, share the sheet, read and write ranges in batches, set value options and handle quota errors.
7 min read
Tag
spreadsheets
45 posts
Excel
Importing Google Sheets Data Into a Database Reliably
Import Google Sheets data into a database reliably: read with a service account, pad rows, check the contract, load through staging and report rejected rows.
7 min read
ExcelGuide
Google Sheets Alongside Databases Without the Mess
Run Google Sheets beside a database without chaos: import and publish data, use the API, compare QUERY with SQL, respect limits, plan the exit.
17 min read
XML
Why Excel Complains About an XML Source Having No Schema
When Excel says the XML source has no schema, it infers one. What the guess means, why it breaks on optional and repeating data, and how to supply a schema.
5 min read
XML
Reading Excel XML Spreadsheet 2003 Files With Python
The old Excel XML Spreadsheet 2003 format is plain XML with Worksheet, Row, Cell and Data elements. Read it with lxml, handle Index gaps and types.
7 min read
XML
Flattening Hierarchical XML for Excel Users With Python
Turn orders with repeating items into a workbook a spreadsheet user can filter: one sheet per level linked by order id, or one wide sheet, plus the checks.
6 min read
XML
Opening XML Files in Excel Without Mangled Data or Loss
What happens when you open an XML file in Excel, the choices it offers, why leading zeros and long numbers change, and a safer route that keeps text as text.
5 min read
XML
Exporting Excel Data as XML With a Schema and What Blocks It
Excel exports XML only through an XML map built from a schema. The 65,536 row cap, the constructs that block export, and a script that does the same job.
6 min read
XML
Importing XML Into Excel With an XML Map Step by Step
How Excel maps XML elements to cells with an XML map, what the XML Source pane does, how append and overwrite work, and why repeating data is the hard part.
6 min read