Class SpreadsheetFactory

Builds an empty (or filled) spreadsheet in one call: column letters, row numbers, a sparse body (a million rows cost only their filled cells) and the options of the spreadsheet preset – Excel-style editing, copy and paste, undo, cell formulas, the fill handle and a range selection with the active cell on A1.

Example

const { tableModel, tableOptions } = SpreadsheetFactory.create({
  data: [["Product", "Price", "Qty", "Total"], ["Laptop", 1299, 2, "=B2*C2"]],
});
Copy

Since

1.1.99