origin_worksheet_write
Specify column formats explicitly and write data into an Origin worksheet, preventing type-guessing errors that cause silent column corruption.
Instructions
Write columns into a worksheet.
Each column is {"name": ..., "format": ..., "values": [...]}. The format
is stated rather than inferred: double, int, text, mixed, date,
time, complex. Guessing from the values is how columns get quietly
corrupted -- whole numbers are not necessarily an integer column, and one
empty cell can turn a numeric column into text.
Dates go in as Julian day numbers with format: "date".
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| book | No | ||
| sheet | No | ||
| columns | Yes | ||
| start_col | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||