api/aoa Functions
Functions exported from src/api/aoa.ts
addArrayToSheet
function addArrayToSheet(worksheet: WorkSheet | null, data: any[][], opts?: AOA2SheetOpts): WorkSheetParameters
| Name | Type | Description |
|---|---|---|
| worksheet | `WorkSheet | null` |
| data | any[][] | The array-of-arrays containing raw cell values |
| opts (optional) | AOA2SheetOpts | Optional settings (origin, dense, dateNF, cellDates, UTC, date1904, nullError, sheetStubs) |
Returns
WorkSheet
The updated or newly created worksheet
arrayToSheet
function arrayToSheet(data: any[][], opts?: AOA2SheetOpts): WorkSheetParameters
| Name | Type | Description |
|---|---|---|
| data | any[][] | The array-of-arrays containing raw cell values |
| opts (optional) | AOA2SheetOpts | Optional settings (same as addArrayToSheet) |
Returns
WorkSheet
A new worksheet populated with the given data