Converts an Excel buffer into a JSON object where each worksheet becomes a property.
Parameters
buffer: Buffer
The Buffer containing Excel file data
Returns Promise<Record<string,any>>
Promise resolving to a Record object where:
- Keys are worksheet names
- Values are arrays of objects representing rows, with:
- Flattened structure
- Empty rows filtered out
- '@' symbols removed from headers
Throws
Will throw an error if the buffer cannot be parsed as an Excel file
Converts an Excel buffer into a JSON object where each worksheet becomes a property.