numbers_create
Create a Numbers spreadsheet from grid data, with the first row as headers. Handles formulas like =SUM and parses numbers in any common format.
Instructions
Create a Numbers sheet from a grid of values. First row = headers.
A cell starting with = is inserted as a REAL formula and computed by the
app: =SUM(B2:B10) works. That is the reason to use this instead of writing
a CSV.
The result is laid out, not merely filled: one header row, no phantom header
column, and column widths fitted to the content. Numbers written in any
common convention (1360.5, 1360,5, 1.360,00, 1,360.00) go in as real
numbers you can sum over.
Args:
rows: grid of values; every row must have the same length.
save_in: path to a .numbers file to save to. If empty it is only opened.
table_name: name for the table and the sheet. Defaults to the file name.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | ||
| save_in | No | ||
| table_name | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |