Binary Magic

Component library

What MagiXells gives your apps

MagiXells is a pixel-perfect Excel-compatible spreadsheet component, built from scratch and written in native Delphi for VCL and FMX. High-fidelity XLSX/XLS/ODS I/O, a full formula engine, charts, and a spreadsheet AI agent API. Compiles into your .exe. No DLL or redistributable required.

Drop TMagiXells / TFmxMagiXells on a form, link the packages into your EXE, and ship Excel-compatible files, formulas, pivots, charts, print/PDF, and an optional AI agent API inside your application.

Platforms and packaging

Shared Core workbook engine plus VCL and FMX host controls you place on your forms. IDE packages register on the palette and compile into your application EXE - no MagiXells DLL and nothing for end users to install beside your app.

  • VCL control: TMagiXells for Windows desktop hosts (Win32, Win64, and WinARM64EC)
  • FMX control: TFmxMagiXells, multiplatform: Windows (including ARM), Linux, and Android (iOS and macOS coming soon)
  • IDE support: Delphi / C++Builder 10.3, 10.4, 11, 12, and 13 (separate Setup per IDE)
  • Windows targets: Win32 and Win64 in each Setup; WinARM64EC (Windows on ARM) with Delphi 13+
  • C++Builder: same packages and public API via generated .hpp headers
  • Native Delphi spreadsheet: written in native Delphi (Object Pascal); pixel-perfect Excel-compatible visual fidelity for layouts, fonts, fills, charts, and drawings
  • Built-from-scratch spreadsheet: not built on a third-party grid component, and not on stock TGrid, TCustomGrid, or TDrawGrid

Files and I/O

Load and save from your code so host apps can open the workbooks their customers already have. Format is inferred from the extension for common paths; streams can take an explicit format.

  • XLSX: Excel Open XML import/export with styles, merges, column/row sizing, freeze panes, rich text, themes, drawings, and related sheet structure
  • XLS: Excel 97-2003 (BIFF8) import/export; 65,536x256 grid; basic styles, formulas, and merges
  • ODS: OpenDocument spreadsheet round-trip for LibreOffice / OpenOffice-style files
  • .mgx: native MagiXells JSON workbook format for full format parity in your own pipelines
  • CSV: delimited text import/export for simple data interchange
  • PDF export: multi-page spreadsheet export for sharing and archives
  • LoadFromFile / SaveToFile: same APIs on VCL and FMX hosts

Formula engine

A dependency-aware calculator with a large Excel-compatible builtin set - enough for finance, lookups, logic, text, dates, and modern array formulas.

  • ~500 builtins: math, aggregate, text, date/time, logical, lookup, financial, and more
  • Dependency graph: recalculation driven by cell relationships
  • Dynamic arrays: FILTER, SEQUENCE, UNIQUE, SORT, and spill behavior
  • LAMBDA / LET family: modern Excel-style named formula constructs
  • Lookups: VLOOKUP, HLOOKUP, XLOOKUP, INDEX/MATCH, and related helpers
  • Financial: PMT, NPV, IRR, FV, PV, NPER, RATE, and similar
  • Named ranges: defined names usable in formulas
  • Hyperlinks: internal sheet jumps and external URLs

Grid, editing, and structure

An interactive spreadsheet control for the forms you build: data entry, navigation, and workbook structure - not a standalone viewer app.

  • Sparse workbook model: efficient storage for large, mostly-empty sheets
  • Selection & navigation: keyboard and mouse editing with formula bar support
  • Undo / redo: workbook actions are undoable (including many structural edits)
  • Merged cells: create and preserve merges across load/save
  • Row / column sizing: manual widths/heights and autosize-oriented workflows
  • Freeze panes: frozen headers while scrolling, plus MagiXells footer and right freeze
  • Split: Excel-like split inside one control (two or four panes). Freeze and Split clear each other
  • Excel-style tables: list objects with totals row support
  • Data validation: lists, whole/decimal/date, and text-length rules with prompts
  • Comments: cell notes and annotation workflows
  • Sheet tabs: multi-sheet workbooks with add/activate/rename-style host UX

Formatting and presentation

Pixel-perfect Excel-compatible cell appearance so workbooks you load keep looking like the originals your application's users expect.

  • Fonts & fills: family, size, bold/italic/underline, colors, solid fills
  • Font effects: outline and shadow (WordArt-style chart titles and related rich text runs)
  • Borders & alignment: edges, horizontal/vertical align, indent, wrap, rotation
  • Number formats: general, number, currency, accounting, percent, fraction, scientific, date/time, custom
  • Rich text: mixed runs inside a single cell (style spans)
  • Themes & styles: workbook theme colors and style sheet concepts preserved where supported
  • Conditional formatting: highlight rules, data bars, color scales, and icon sets
  • Merged & wrapped layout: paint and edit paths for multi-line and merged content

Charts, shapes, and images

Visuals stay with the sheet: imported from XLSX/ODS and creatable via API when you build reporting or dashboard UI in your host.

  • Chart types: column, bar, line, pie, area, scatter, doughnut, radar, bubble, combo, stock, waterfall, funnel, treemap, sunburst, histogram, pareto, box and whisker
  • 3D charts: 3D column, bar, pie, line, and area variants (paint and XLSX round-trip)
  • Chart chrome: titles (including font effects), axes, legends, series defaults, and Excel-style data tables where present
  • Floating images: PNG and related pictures anchored on the grid
  • Shapes & drawings: rectangles, ovals, arrows, text boxes, connectors; select/move/resize
  • Ink: paint and round-trip support for ink annotations
  • XLSX / ODS round-trip: drawings and charts preserved through load/save paths

PivotTables and analytics surfaces

Summarize fact tables inside the embedded control - useful when your app needs region/category reports or interactive analysis without opening Excel.

  • PivotTables: rows, columns, values, and report filters from a source range
  • Field List: interactive field placement and refresh
  • GETPIVOTDATA: formula access into pivot results
  • GROUPBY / PIVOTBY: modern aggregation helpers where supported
  • Slicers / timelines / PivotCharts API: host and API surfaces for interactive filtering and charting
  • Undoable pivot filters: filter/sort changes can be undone with Ctrl+Z

Print, preview, and PDF

Expose print and PDF from the same workbook your host edits on screen - APIs and preview UI you wire into your own menus.

  • Print engine: page layout for spreadsheet content
  • Print preview: margins, orientation, scale, and sheet options (VCL and FMX)
  • Page setup: headers/footers and page geometry settings
  • PDF export: multi-page output for income statements, dashboards, and archives
  • RTL print preview: mirrored print chrome for right-to-left sheets

Right-to-left and localization-ready layout

Sheets can display right-to-left for Arabic/Hebrew-style workbooks, including chrome that mirrors with the sheet.

  • Sheet RTL: grid columns and layout oriented for RTL content
  • Mirrored chrome: sheet tabs, scrollbars, and print preview adapt for RTL
  • RTL samples: demo workbooks with Arabic executive layouts and regional KPIs
  • Demo toggle: View → Right-to-Left in the VCL/FMX sample apps for quick testing

Spreadsheet AI agent API

MagiXells provides the agent tools and undo integration; you own the chat UI and provider credentials.

  • Providers: OpenAI-compatible endpoints and Anthropic
  • Tool loop: edit cells, format ranges, build tables/charts, filter, comments, conditional formatting, pictures, and more
  • Host-owned UI: ship your own panel; MagiXells does not force a fixed chat chrome
  • Code tips: ask for Delphi or C++Builder snippets to recreate sheet work
  • Demo panels: sample AI panels in the VCL/FMX demos under View → AI Agent

Developer API and authoring

Automate workbooks from Delphi or C++Builder with a consistent SheetAPI on the active sheet.

  • SheetAPI: cells, ranges, formulas, fonts, fills, number formats, borders, alignment
  • Workbook / worksheet model: create sheets, switch active sheet, recalculate
  • Same APIs on VCL and FMX: load/save and authoring patterns mirror across hosts
  • Host options: control UI and behavior from the embedding application
  • Developer docs: HTML guide covering API, formulas, I/O, charts, and more
  • Feature showcase workbook: sample sheets for formulas, finance, charts, pivots, and formatting
uses MagiXells.SheetAPI;

var
 S: TAuthoringSheet;
begin
 S := MagiXells1.Workbook.UseActiveSheet;
 S.Cell['A1'].Text := 'Revenue';
 S.Cell['B1'].AsNumber := 125000;
 S.Cell['B2'].Formula := '=B1*1.08';
 S.Range('B1:B2').NumberFormat := '$#,##0.00';
 MagiXells1.Recalculate;
end;

Roadmap

MagiXells is a Delphi-first component library today. Planned expansions keep the same Core engine for more host stacks.

  • FMX iOS and macOS: coming soon (Windows, Linux, and Android already supported)
  • Native DLL: C, C++, and C# bindings on the same engine
  • ActiveX control: for classic Windows embedding scenarios
Download trial See screenshots Quick start