1 views collected around this technical thread.
This tutorial explains the core concepts of openpyxl—including workbooks, sheets, and cells—demonstrates how to create, open, read, write, style, merge, and manipulate Excel files with Python, and provides complete code examples for generating 2D and 3D charts.
This article introduces a comprehensive set of Excel functions—including CONCATENATE, LEN, COUNTA, DAYS, NETWORKDAYS, SUMIFS, AVERAGEIFS, VLOOKUP, FIND/SEARCH, IFERROR, COUNTIFS, LEFT/RIGHT, RANK, MINIFS, MAXIFS, and SUMPRODUCT—explaining their purpose, syntax, and practical examples for effective data analysis and reporting.
This tutorial demonstrates how to use the Python openpyxl library to create, open, edit, and save Excel workbooks, covering worksheets, cells, ranges, formulas, merging, iteration, and file handling for both small and large spreadsheets.
This article traces the history of spreadsheet software—from the 1977 invention of VisiCalc, through Lotus 1‑2‑3’s dominance, to Microsoft’s strategic development of Excel, highlighting key innovations like LAMBDA that made Excel a Turing‑complete programming language and its lasting impact on computing.
This tutorial introduces PhpSpreadsheet, a pure‑PHP library for handling Excel files, covering Composer installation, namespace imports, reading and writing worksheets, applying styles, and various cell operations with complete code examples for building and formatting spreadsheets.
This article examines the challenges of web‑based spreadsheet reporting, evaluates cloud‑document and control‑type solutions, and demonstrates how SpreadJS addresses concurrency, Excel compatibility, flexible layouts, formula calculation, and workflow integration through performance‑optimized rendering, a robust calculation engine, and rich styling capabilities.