Detect Tampered XLSX: HotXLS Agile dataIntegrity HMAC
Verify Agile-encrypted XLSX packages in Delphi with HotXLS: HMAC-SHA-512 dataIntegrity, constant-time verifier checks and the classic write reservation records
Software Development Blog
HotXLS Delphi Component
HotXLS Delphi Component tutorials for generating and reading Excel spreadsheets in Delphi
Read Agile-Encrypted Excel Files in Delphi with HotXLS
How HotXLS reads Agile-encrypted XLSX in Delphi: OpenEncrypted parses EncryptionInfo, runs SHA-512 spin-count key derivation, then decrypts AES-CBC segments
Partitioning Anchored Conditional Formats in HotXLS
How HotXLS splits conditional formatting and data validation rules into prioritised rule objects when row or column edits divide their range in Delphi
BIFF Record Length Drift in a Delphi XLS Writer
A HotXLS pivot emitter declared a 24-byte BIFF body and wrote 26, so chart sheets vanished on reopen. The fix, and how to find that drift yourself
BIFF SupBook and XTI External Link Classification in Delphi
How HotXLS classifies BIFF SupBook and XTI records in Delphi, why same-sheet, add-in and DDE or OLE links cannot be guessed from a self flag or empty URL
Reading Excel 2.0 to 4.0 Files in Delphi with HotXLS
HotXLS opens pre-OLE Excel 2.0, 3.0 and 4.0 workbooks from Delphi, reading raw BIFF streams, per-generation cell records and cached formula results
BIFF8 Chart Secondary Axis Groups in Delphi with HotXLS
How HotXLS writes BIFF8 secondary axis groups in Delphi: AXESUSED, two AxisParent blocks, and why the chart group lives inside each axis group
Embedding Chart Objects on Worksheets with HotXLS
HotXLS anchors a BIFF8 chart substream to a worksheet as an OBJ type-5 host control, so the chart sits beside the data instead of occupying its own sheet
Writing BIFF8 PivotTables in Delphi: SXDB and SXLI
PivotTables are the most intricate structure in the .xls binary format. See how HotXLS builds a self-contained pivot cache and packs SXDBB records in Delphi
BIFF8 XLUnicodeString Decoding in Delphi: cch and fHigh
How HotXLS decodes BIFF8 XLUnicodeString payloads in Delphi: GetWideString counts bytes, fHigh 0 needs GetString, and a wrong pairing fails silently
Bond and Treasury Formulas in Delphi with HotXLS
HotXLS evaluates PRICE, YIELD, DURATION, coupon-date and treasury-bill functions from Delphi, with all five day-count bases and no Excel installed
Replaying Untrusted EMF and WMF Safely in HotXLS
HotXLS decodes worksheet metafile pictures into a bounded command scene instead of handing the bytes to GDI playback, with budgets and fail-closed parsing
Read Excel Cached Formula Values in Delphi Without Recalc
HotXLS reads Excel formula cached values in Delphi without triggering recalculation, keeping ETL runs fast and source workbooks byte for byte unchanged
Excel Camera Objects from Delphi: Live Snapshots
HotXLS creates Excel camera objects from Delphi, placing a live picture of a cell range that Excel re-renders on load, with round-trip preservation of the link
Export an Excel Cell Range as One Image With HotXLS
TXLSCellImageExporter renders any XLS or XLSX cell rectangle to one PNG or JPEG with no pagination, explicit pixel and byte budgets and an atomic replace
Implementing the CF_HTML Clipboard Format in Delphi
Build a CF_HTML clipboard payload in Delphi with HotXLS so Excel ranges paste into Word or a browser with styling intact, using precise byte offsets
Excel Waterfall and Treemap Charts in Delphi with HotXLS
Create Excel waterfall and treemap charts from Delphi with HotXLS: cx chartSpace parts, layoutId series types, cx pt caches and the AlternateContent anchor
HotXLS Charts and Images: Excel Drawings in Delphi
How to add Excel charts, images, and shapes from Delphi with HotXLS: chart sheets in XLS, embedded charts and pictures in XLSX, EMU sizing, and anchor traps
Excel Column Width and Max Digit Width (MDW) in Delphi
Excel column width is measured in Max Digit Width units, so a non-Calibri Normal font shifts every column boundary. How HotXLS measures MDW in Delphi
Excel Comments and Hyperlinks in Delphi with HotXLS
Write cell comments with authors, external URLs, and in-workbook links from Delphi using HotXLS, including the XLSX internal-link API and XLS comment quirks
Read OLE2 Compound Files in Delphi Without COM IStorage
HotXLS parses Compound File Binary v3 containers in pure Pascal: header signature, in-header DIFAT, FAT chains, MiniFAT and the directory tree, no ole32.dll
Excel Conditional Format Evaluation in Delphi with HotXLS
How HotXLS evaluates Excel conditional formatting rules in Delphi outside Excel, and the Top 10 percent, above average and duplicate cases Excel 16 tests pinned
HotXLS Conditional Formatting and Rich Text in Delphi
Apply cellIs rules, data bars, icon sets, and rich text runs from Delphi with HotXLS, avoiding the dxf style and font pool index traps in XLSX files
HotXLS Crash-Safe Saves: Staged Temp Files in Delphi
HotXLS saves XLSX, ODS, and XLS in Delphi through a staged temp file and an atomic Windows rename, so an interrupted save cannot corrupt the workbook
Delphi Cross-Compiler Build Matrix: HotXLS Since XE5
Five compiler rejections that fire only on Delphi XE5, and why a build script exercising just the newest compiler let the HotXLS build matrix rot in silence
HotXLS Cross-Workbook Copy and Formula Rebinding in Delphi
HotXLS AddCopy copies Excel worksheets between workbooks in Delphi, rebinding formulas, chart references, and font indexes for the destination workbook
Live Cross-Workbook Formulas in Delphi with HotXLS
HotXLS evaluates formulas referencing another workbook against a live in-memory object in Delphi, falling back to the external-link cache when unregistered
Export Excel to CSV, TSV, and HTML in Delphi (HotXLS)
Export Excel sheets to CSV, TSV, and HTML from Delphi with HotXLS. Covers RFC 4180 quoting, UTF-8 BOM, and why formulas need Calculate before export
A Custom Spreadsheet Grid in Delphi with HotXLS
HotXLS TXLSWorkbookViewer renders Excel workbooks as a Delphi grid: merged-cell hit testing, scroll sync, cell selection, and hyperlink and comment events
HotXLS Data Validation, AutoFilter and Tables in Delphi
Add dropdown validation, AutoFilter criteria, and Excel tables from Delphi with HotXLS, including server-side filter preview and the 0-based column ID trap
Exporting Delphi Datasets to Excel Reports with HotXLS
Export TDataset results to Excel from Delphi with HotXLS: TDataToXLS grouping and paging, the VCL dependency trap, XLSX conversion, and a service-safe loop
Excel Date Serials in Delphi: 1900 vs 1904 and numFmt
An Excel date is just a number until you know which epoch it counts from. See how the 1900 and 1904 systems differ by 1462 days and how numFmt flags a date
Auditing Excel Formula Caches with HotXLS Deep Recalc
HotXLS recalculates every formula in an isolated overlay and reports each cached value that disagrees, without writing to the workbook unless you ask for it
Defined Names and Cross-Sheet Formulas in Delphi (HotXLS)
Create workbook-scoped and sheet-scoped defined names with HotXLS in Delphi, write cross-sheet formulas that survive edits, and avoid _xlnm name conflicts
Dynamic Array Spill Formulas in Delphi with HotXLS
Evaluate Excel 365 dynamic array spill formulas from Delphi with HotXLS: XLOOKUP, FILTER, SORT, UNIQUE and SEQUENCE behaviour anchored by SetArrayFormula
Delphi Engineering Functions: Base Conversion, Complex Maths
Excel's DEC2BIN, HEX2DEC and IMSUM functions hide ten-bit two's complement and string-encoded complex maths. See how HotXLS implements them in Delphi
HotXLS File Monitor Callback Deadlock in Delphi
HotXLS fires TXLSFileMonitor events on the main thread while the worker waits, so stopping the monitor within OnFileChanged deadlocks without thread ownership
HotXLS Formula Engine and Custom Functions in Delphi
Evaluate Excel formulas in Delphi with HotXLS: the Calculate engine, OnUserFunction custom functions, array formulas, and why CSV export needs computed values
Trace Excel Formula Evaluation Step by Step in Delphi
Excel can evaluate a formula one step at a time. See how HotXLS reproduces that step-by-step reduction for auditing and debugging spreadsheets in Delphi
Formula References When Inserting Rows in HotXLS
How HotXLS shifts A1 formula references when you insert or delete rows and columns in Delphi: relative and absolute refs, range endpoints, and #REF! rules
HotXLS on Free Pascal: Unicode, COM Slots and zlib
Building HotXLS under Free Pascal needs DELPHIUNICODE, CORBA interfaces with explicit COM slots and a Pascal AES path in place of the Delphi OMF objects
Excel Chart Theme Colours in Delphi: HotXLS GelFrame
How HotXLS writes theme-coloured chart fills into binary XLS: the GelFrame record, the OfficeArt scheme index in the red byte, and the MSOTINT payload
HotXLS Image Geometry in Delphi: EMU, cm, and Scaling
Size embedded XLSX images by physical dimensions in Delphi with HotXLS: EMU units explained, centimetre and point geometry, aspect-locked scaling, cm margins
Reading GIF, BMP and JPEG Header Geometry in HotXLS
HotXLS reads true pixel dimensions from GIF, BMP and JPEG headers so AddPicture writes real geometry rather than a 100x100 fallback that stretches images
Incremental Formula Recalculation in HotXLS for Delphi
HotXLS Workbook.Recalculate builds a formula dependency graph in Delphi to re-evaluate only dirty cells: volatile functions, topological order, cycle handling
Patch One Worksheet in a Large XLSX from Delphi
HotXLS rewrites one worksheet inside an existing XLSX package from Delphi while every untouched part crosses over with its compressed bytes verbatim
Iterative Calculation for Circular References in Delphi
Resolve intentional circular references in Delphi with HotXLS: iterative calculation via Iterate, IterateCount and IterateDelta, and how the cycle converges
LAMBDA and LET in Delphi: HotXLS Formula Closures
Evaluate Excel LAMBDA closures and complete LET semantics in Delphi with HotXLS: named lambdas, lexical capture, shadowing rules and comma separators
Large Excel Workbook Performance in Delphi with HotXLS
Practical HotXLS performance tuning for large Excel files in Delphi: StreamingWrite saves, style pool reuse, row callbacks, and faster read-only loads
HotXLS Lookup Scans and False Circular References
Why VLOOKUP over a column containing the formula itself is legal in Excel, and how HotXLS separates scan edges from ordering edges to stop false cycles
Lossless XLSX Round-Trip in Delphi: Theme, extLst, calcChain
How HotXLS preserves custom themes, unknown extLst blocks, and calcChain when Delphi code edits one cell in an XLSX file, and where round-trip fidelity ends
HotXLS Merged Cells and Report Template Layout in Delphi
How HotXLS handles merged cells in Delphi report templates: anchor-cell semantics, InsertRows shifting rules, merge audits, and HTML and RTF export behaviour
Metadata-Only and Selective XLSX Loading with HotXLS
Open a large XLSX in Delphi without parsing every sheet: HotXLS MetadataOnly discovery, SelectedSheets loading, on-demand LoadSheet and raw-part saves
Open and Save ODS Files in Delphi with HotXLS
HotXLS opens and saves OpenDocument Spreadsheet files from Delphi: SaveAsODS export options, the lightweight ODS import path, and what survives a round trip
Why Excel Rejects Your Encrypted Workbook: ECB and RC4
Two encryption bugs where the password is right but Excel reports corruption. See how an ECB versus CBC mix-up and an RC4 re-key drift break interop in Delphi
Generate Excel Files in Delphi Without Office Automation
Build XLS and XLSX workbooks from Delphi services without installing Excel: native BIFF and OOXML writers, stream output to HTTP responses, COM-free
Parallel XLSX Parsing in Delphi: Memory Manager Bottleneck
Why adding threads made XLSX parsing slower in Delphi, and how HotXLS cut heap allocations from 20 to 9.1 per cell to reach a 1.90x parallel speedup
Export Excel Workbooks to PDF/A from Delphi
HotXLS exports spreadsheets to archival PDF/A from Delphi with an embedded sRGB output intent, pdfaid metadata and the font rules an archive validator checks
Framing BIFF PivotCache Records with HotXLS in Delphi
The BIFF PivotCache substream frames SXDB, SXDBB and SXFDB by body layout rather than record number, and HotXLS latches the dialect from the first record
Build and Refresh Excel Pivot Tables in Delphi with HotXLS
Build XLSX pivot tables in Delphi with HotXLS: AddPivotTable, calculated items and fields, showDataAs value displays, date grouping, and in-process refresh
Editing Excel Charts Without Losing ChartML in HotXLS
HotXLS preserves the original ChartML of an imported Excel chart while you edit titles, series and axes in Delphi, and builds combination charts with two axes
HotXLS: Sheet Protection, Page Setup, and Printing in Delphi
Protect worksheets, keep input ranges editable, and control print layout in Delphi with HotXLS: Locked flags, page setup, scaling, and header codes
Pull Row Cursor for XLS, XLSX, ODS and CSV in Delphi
HotXLS unifies XLS, XLSX, ODS and CSV streaming reads behind one pull row cursor in Delphi: explicit state machine, idempotent Cancel and borrowed row views
R1C1 Formula Notation in Delphi with HotXLS
Compile R1C1 formulas in Delphi with HotXLS: GetCompiledFormulaR1C1 resolves R2C3, R[-1]C[2] and RC per cell, so one relative formula fills a column
Row-Block Cell Storage and Streamed XLSX Saves in HotXLS
How HotXLS keeps large Delphi workbooks small in memory: 256-row cell blocks, interval style overlays that never materialise empty cells, and streamed saves
List Sheet Names Fast in Delphi with HotXLS GetSheetNames
Read worksheet names from XLS, XLSX, and ODS files in Delphi without loading cell data: HotXLS GetSheetNames, encrypted-file detection, intake triage
Excel Sparklines in Delphi: HotXLS and the x14 Extension
Create Excel sparklines in Delphi with HotXLS: line, column and win/loss groups, ARGB colour slots, and the x14 extLst block Excel 2010 and later render
Excel Statistical Functions in Delphi: NORM, CHISQ, BETA
Excel's NORM, CHISQ and BETA functions hide real numerical analysis. See how HotXLS computes them with regularised gamma and beta in Delphi, and one Log bug
Stream Huge XLSX Files in Delphi Without Loading Them
A million-row XLSX need not fit in memory. See how HotXLS scans worksheet parts with a no-DOM streaming reader at near-constant memory in Delphi
Write Million-Row XLSX in Delphi at Constant Memory
Generating a giant XLSX should not grow with row count. See how HotXLS streams OOXML with inline strings and no shared-string table in Delphi
HotXLS Streaming Writes for Delphi Server Batch Jobs
Keep large XLSX exports inside memory limits with HotXLS StreamingWrite, row-level write callbacks, style pool reuse, and per-thread batch workbook jobs
Writing ISO 29500 Strict XLSX Files from Delphi
HotXLS writes ISO/IEC 29500 Strict workbooks from Delphi, translating every package part to purl vocabularies and refusing the features Strict forbids
Structured Diagnostics Instead of Boolean Results in HotXLS
HotXLS replaces boolean Save and Open results with structured diagnostics: stable error codes, severity levels, and sheet context for Delphi apps
Excel Structured Table References in Delphi with HotXLS
Evaluate Table[Column] structured references in Delphi with HotXLS: item specifiers, column spans, verbatim round-trip and the unsupported current-row form
SUBTOTAL and AGGREGATE Hidden Rows in Delphi with HotXLS
Why SUBTOTAL 109 and SUBTOTAL 9 return the same total in HotXLS before v2.197.0, and how a row-hidden callback fixes AGGREGATE hidden rows in Delphi
Excel Table Slicers in Delphi: HotXLS Round-Trip
Create Excel table slicers in Delphi with HotXLS: the eight parts that must agree, why the slicer cache is always rebuilt, and how rid chains stay stable
Tagged PDF Figures From Excel Images With HotXLS
How HotXLS turns worksheet pictures carrying alternative text into independent PDF Figure structure elements, and why one MCID allocator per page is mandatory
Template-Based Excel Report Generation in Delphi with HotXLS
Fill Excel report templates from Delphi with HotXLS: locate placeholders with FindText, clone detail rows, insert rows safely, and recalculate before saving
Threaded Comments in Excel Files with Delphi and HotXLS
Write Excel 365 threaded comments from Delphi with HotXLS: AddThreadedComment reply chains, the threadedComments and person parts, and legacy note differences
TrueType Font Subsetting via fontsub.dll in Delphi
HotXLS subsets embedded PDF fonts via the Windows fontsub.dll CreateFontPackage API, keeping only the glyphs a Delphi worksheet export actually used
Unicode-Safe Spreadsheet Export in Delphi: RTF and HTML
Non-ASCII text can collapse to question marks across RTF, HTML, CSV and ZIP exports. See how HotXLS keeps Unicode intact on every export path in Delphi
HotXLS: Preserve VBA Macros and External Links in Delphi
How HotXLS preserves VBA projects and external links when Delphi code edits XLS and XLSX workbooks: macro-enabled saves, link targets, and round-trip limits
Rewriting VBA Source and Recompressing MS-OVBA in Delphi
HotXLS lets Delphi developers rewrite VBA module source code and recompress it with the MS-OVBA algorithm, then write the macros back into XLS or XLSM files
HotXLS: Workbook Audit and Format Conversion in Delphi
Audit unknown Excel files from Delphi with HotXLS: count charts, formulas, macros, and protection, then convert XLS, XLSX, and ODS with known fidelity limits
Diff Two Excel Workbooks in Delphi with HotXLS
HotXLS compares two workbooks from Delphi and reports sheet, cell, formula and merge differences as a structured list and a readable report, no Excel
Setting Excel Document Properties in Delphi with HotXLS
Set and read Excel document properties from Delphi with HotXLS: title, author, company, and keywords across BIFF SummaryInformation and OOXML docProps parts
HotXLS Read Leases and Write Guards for Delphi Workbooks
How HotXLS coordinates workbook reads and writes in Delphi using O(1) read leases, fail-fast write guards, reentrant transactions and a generation counter
Export Excel Worksheets to PDF in Delphi Without Office
HotXLS renders Excel worksheets to paginated PDF in Delphi and C++Builder through SaveAsPDF, with no Office installed, using the built-in Helvetica font
XLOOKUP and XMATCH Binary Search Modes in Delphi
How HotXLS evaluates XLOOKUP and XMATCH in Delphi: legal match and search modes, O(log n) binary descent, duplicate key edges, and why wildcards get rejected
Encrypt XLSX Files with AES in Delphi using HotXLS
Write AES-encrypted XLSX files from Delphi with HotXLS SaveAsEncrypted: ECMA-376 Standard Encryption, password handling, and the write-only decryption limit
XLSX OPC Relationship Resolution in Delphi Parsers
Why hardcoding xl/worksheets/sheet1.xml breaks valid XLSX files, and how HotXLS resolves OPC relationship targets against the source part in Delphi
XLSX Shared Formula si Expansion in Delphi: Pitfalls
How HotXLS expands XLSX shared formula followers in Delphi: find the si master, shift relative references, and survive self-closing f elements
XLSX Sheet Protection in Delphi: 15 Allow Options
Set per-action XLSX sheet protection in Delphi with HotXLS: 15 AllowOption permission bits, the OOXML omit-equals-allow rule, and round-trip-safe parsing
Clone an XLSX Worksheet in Delphi with HotXLS
Clone a styled XLSX worksheet in Delphi with HotXLS Duplicate and CopyFrom: what deep-copies, what stays shallow, and how to rebuild charts on the copy
ZIP EOCD Validation for Untrusted XLSX Files in Delphi
How HotXLS validates the ZIP end of central directory record with four cross checks so a forged EOCD hidden in a ZIP comment cannot fool your Delphi parser
Concurrent ZIP Inflate in Delphi: HotXLS Read Gate
How HotXLS inflates many XLSX worksheets concurrently from one shared ZIP package stream in Delphi using a read gate that locks only the seek and read pair
HotXLS, zlib-ng CRC32, and Stack Overflow in Delphi Threads
HotXLS worksheet CRC32 checksums can overflow a 1 MB worker thread stack when zlib-ng selects its Chorba path; feeding data in 64 KB chunks avoids the crash