SDK
A vectorized, columnar, scriptable, embeddable spreadsheet.
A high-performance, embeddable spreadsheet engine designed for building data-driven applications and integrating
spreadsheet functionality into existing systems. It handles even extremely large and sparse datasets,
while providing a powerful calculation engine and a flexible API. As part of the
SheetXL eco system, it seamlessly integrates with ready-to-use UI components and data
import/export tools.
Learn more about SheetXL .
Feature
Excel API (JS/Python)
Google Sheets API
pandas
DuckDB
Jupyter Notebooks
NumPy
Sigma Computing
SheetXL π
Spreadsheet-Like?
β
Yes
β
Yes
β No UI (table-based)
β No UI
β No real spreadsheet UI
β No UI, array-based
β No true spreadsheet UI
β
Yes (Excel-like UI)
Vectorized Operations?
β Mostly scalar
β Mostly scalar
β
Fully vectorized
β
Columnar, vectorized
β
Can use pandas/NumPy
β
Fully vectorized
β SQL-based (not vectorized)
β
Fully vectorized, columnar
Embeddable?
β Not easily embeddable
β
Web-based
β Not embeddable
β
Can be embedded
β Not embeddable
β Not a spreadsheet
β
Cloud-based
β
Fully embeddable
Data Science Capabilities?
β οΈ Limited (Python only)
β No real data science
β
Strong data science
β
SQL-based analytics
β
Python data science
β
Scientific computing
β
BI analytics
β
Python & JS scripting
Advantages
The βHandoff Taxβ β IT departments rewrite spreadsheets into web apps, but they lack true spreadsheet functionality. SheetXL removes this tax.
Excelβs API is scalar β Most spreadsheet APIs are slow because they werenβt built for large-scale, vectorized calculations.
BI tools donβt let you βprogramβ the UI β Sigma, Looker, Tableau work for dashboards, but arenβt true programmable spreadsheets.
NumPy is fast, but has no spreadsheet UI β SheetXL gives NumPy performance inside a familiar spreadsheet.
Embeddability is a game-changer β Unlike Excel/Google Sheets, SheetXL is built for web apps, with seamless integration.
Namespaces AutoFill BufferUtils Calculation CommonMessages CommonUtils CoordUtils FormulaError GeomUtils IAnchored IAutoFill IAutoFilter IAutoSort IBorder ICalculation ICell ICellProtection ICellRange ICellRanges IChart ICollection IColor IConditionalFormat IConditionalFormatCollection IFill IFont IFontCollection IFunction IFunctionCollection IHistory IHyperlink IListener ImageUtils IModule IMovable IMovableCollection IMovableSelection INamed INamedCollection InternalClipboard IPicture IPrint IProperties IProtection IRange IRangeSelection IResource IResourceCollection IRichData IScript ISheet ISheetCollection ISheetProtection ISheetView ISort IStringCollection IStyle IStyleCollection IStyledFont ITable ITableCollection ITableStyle IText ITextBoxAlignment ITextFrame ITheme IThemeCollection ITransaction ITypes IWorkbook IWorkbookProtection IWorkbookView NumberFormat Picture ReferenceableClipboard Sort TextUtils Tuple TypedObject TypesUtils Classes Calculation ChainedError Color Deferred ExternalRangeClipboardItem InternalClipboard NotImplementedError NullNotAllowedError Observable OutOfBoundsError PartialError Picture RangeClipboardItem Resource ResourceCollection Sheet StringCollection StubbedFormulaContext StyleCollection Table Theme ThemeCollection TransactionStore TransactionUndoManager TypedError UndoManager UserError Workbook WorkbookView Interfaces Bounds CellCoords Dimensions DimensionsFlags EditMode FetchArgs IAnchored IAutoFilter IAutoSort IBorder ICalculation ICell ICellContainerOptions ICellProtection ICellRange ICellRanges IChart ICollection IColor IConditionalFormat IConditionalFormatCollection IFill IFormulaContext IFunction IFunctionCollection IHyperlink IModule IMovable IMovableCollection IMovableSelection INamed INamedCollection IPicture IProtection IRange IRangeSelection IReferenceRange IRepeatableOperation IResource IResourceCollection IRichData IRuntime IScript ISheet ISheetCollection ISheetProtection ISheetView IStringCollection IStyle IStyleCollection IStyledFont ITable ITableCollection ITableStyle ITextBoxAlignment ITextFrame ITheme IThemeCollection ITransaction IUndoOperation IWorkbook IWorkbookProtection IWorkbookView JSONSerializable JSONSerializableAsync Point RangeCoords RangedValue Rectangle ReferenceableClipboard RemoveListener RunCoords SelectionCoords Subscriber TaskProgress TextMeasurerOptions TopLeft TypedObject Type Aliases JSScalar JSScalarUpdate Scalar ScalarUpdate Variables AnchorLocation ClipboardUtils Direction FormulaContext LicenseManager MimeType RangeOrientation RangeOrientations ScalarType Functions JSONStableStringify