grid.import.xlsx has no worksheet "{sheet}";...

Warnings reference › import.xlsx.sheet

Identifier

import.xlsx.sheet

Raised by

The grid (core)

Since

1.96.0

What happened

The sheet option named a worksheet the workbook does not have - by name or by a zero-based index past the end. The read is refused so a misspelled name cannot silently import the wrong sheet; the message lists every sheet the workbook does have.

The fix

Pass one of the listed names, or a zero-based index below the sheet count from grid.import.xlsxSheets(bytes).

The smallest fix

const sheets = await grid.import.xlsxSheets(bytes);
const records = await grid.import.xlsx(bytes, { sheet: sheets[1].name });

Reference

Covered in full at the API reference.