A guide to preserving table structure when copying from Excel to Microsoft Loop by using an HTML file as an intermediary step.
A tutorial on using Dremio and Docker to run SQL queries directly on Excel files from your local machine.
A benchmark comparison of several Python libraries for reading Excel files, focusing on speed, type handling, and correctness.
A developer's rant about Excel's frustrating limitations, including the 31-character worksheet name limit and unexpected numeric storage quirks.
A guide to embedding source notebook metadata in Excel reports using Python's pandas and xlsxwriter to simplify tracking and refreshing analyses.
A product manager discusses five essential skills for product and leadership roles: SQL, Excel, clear communication, storytelling, and prioritization.
A guide to using pandas and openpyxl to read and clean poorly structured Excel files, focusing on the usecols and header parameters.
A tutorial on importing data from an Excel spreadsheet to create a new SharePoint list, highlighting its integration benefits.
A guide to parsing Excel XLSX files in Swift using Codable protocols, explaining the file structure and providing a technical approach.
A critique of Excel's data handling flaws, showing how it silently corrupts timestamp data in CSV files upon saving.
A technical guide explaining the formula to convert Microsoft Excel date values into UNIX timestamp format.
A guide on converting UNIX timestamps to readable Excel dates using a simple formula, useful for analyzing log file data.
A guide to properly labeling time-based axes in Excel by understanding how Excel stores time as fractions of a day.
A programmer reflects on using VBA for Excel automation after starting with BASIC, discussing the language's quirks and suitability for data processing.
A technical guide showing how to get the UNIX timestamp for New Year's Day in MySQL, Excel, and Visual BASIC.
Exploring the implementation of Excel formula parsing and calculation within PHPExcel using a ported JavaScript expression parser.
A developer shares a set of PHP classes for generating Excel 2007 (.xlsx) files, supporting basic data types and formulas.
