All integrations

Handsontable

Connect a live Handsontable spreadsheet to OpenUI so agent tools can analyze and update its data.

How it connects to OpenUI

The maintained example shares table state between Handsontable and a custom OpenUI SpreadsheetTable component. Tool calls update the server-side data, and the rendered component synchronizes those results back into the live grid.

Integration steps

  1. 1

    Share the table state

    Keep the table in a server-side store that both the grid and the chat route use. Edits made in Handsontable sync back to the server through POST /api/table.

  2. 2

    Give the model spreadsheet tools

    Expose tools such as get_table_data, update_cells, add_rows, and set_formula. After a write, the model responds with a SpreadsheetTable component.

  3. 3

    Sync results into the grid

    The Renderer draws SpreadsheetTable from the custom library, and the useSpreadsheetSync hook pushes the new data into the live Handsontable instance.