This article details how to ingest, parse, and query Excel files using Azure Databricks. It explains features like schema inference, reading specific sheets, and using Auto Loader for streaming. Key limitations include unsupported password protection and merged cells.

jsonriver is a lightweight JavaScript library designed for incremental JSON parsing from streams, allowing users to receive progressively complete data structures. It operates solely on standard JavaScript features, ensuring compatibility across environments, and mimics the behavior of JSON.parse while providing performance benefits in streaming scenarios. The library also includes specific behaviors for handling types and properties in JSON objects.