origin_worksheet_read
Retrieve worksheet column data from Origin workbooks as lists, with row windows to avoid truncation and explicit handling of date/time values as Julian day numbers. Uses start_row and max_rows to read specific ranges accurately.
Instructions
Read worksheet columns as lists, with the format Origin holds them in.
A read that could not fit is refused rather than shortened, because a
silently truncated answer looks exactly like a short worksheet. Use
start_row and max_rows to take a window deliberately, and read
rows_in_sheet and rows_after_window -- named separately because a
single "rows available" count reads exactly like a short worksheet.
Date and time columns come back as Julian day numbers, not text. Converting them involves choices -- timezone, calendar, precision -- that belong to whoever knows what the data means.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| book | No | ||
| sheet | No | ||
| columns | No | ||
| max_rows | No | ||
| start_row | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||