MagiXells is a Delphi / C++Builder component library, not an end-user spreadsheet product.
Drop TMagiXells / TFmxMagiXells on a form, link the packages into your EXE, and ship Excel-oriented files, formulas, pivots, charts, print/PDF, and an optional AI agent API inside your application - no MagiXells runtime for end users to install.
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.3, and 13.1 (separate Setup per IDE)
Windows targets: Win32 and Win64 in each Setup; WinARM64EC (Windows on ARM) with Delphi 13.1+
C++Builder: same packages and public API via generated .hpp headers
Written from scratch: 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
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-oriented 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
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
Excel-compatible cell appearance so workbooks you load keep looking like the originals your application's users expect.
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 calling out to 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
