How To Guides
Got a job to do? Start here. Each guide picks one task and walks you through it, with code you can copy. If you want to know why SheetXL works the way it does, the Concepts section has that.
Cells and values
- Read and Write Values: get and set values, clear cells, and insert or delete rows and columns.
- Transform Values with IRange: reshape, fill, and compute over values before writing them back.
- Work with Sparse Data: visit only the cells that have something in them.
- Listen for Changes: react when cells change, in plain TypeScript or with React hooks.
Look and feel
- Style Cells: fonts, fills, borders, number formats, and finding the cells that have them.
- Theme the Spreadsheet: match your site's colors, light and dark.
- Resize and Hide Rows and Columns
- Drawing on the Grid: draw your own highlights, markers, and buttons on the sheet, as layers that scroll and zoom with it.
Files
- Load and Save Workbooks: JSON, xlsx, CSV, from the SDK or the command line.
- Configure a Backing Store: redirect where workbooks are read from and written to (a VS Code host, a backend, a database, …).
Code
- Write a Custom Function (UDF): add your own formula functions in TypeScript.
- Write a Runner Script: one script, run from the CLI, your own Node program, or an AI agent.
note
This section is growing. If there's a guide you'd like to see, let us know.