Live Data Stream

Create live data streams for spreadsheets.

To access this command...

Choose Data – Streams

This feature is experimental and may produce errors or behave unexpectedly. To enable it anyway, choose Tools - Options - Office - Advanced and select Enable experimental features checkbox.

This help page needs further work for correctness and completion. Please join the Office project and help us out to write the missing information. Visit our web page on writing Help contents.

Data streaming is the continuous flow of data generated by various sources. In Office Calc, data streams can be processed, stored, analysed, and acted upon as it's generated in real-time.

Some real-life examples of streaming data include use cases in every industry, including real-time stock trades, up-to-the-minute retail inventory management, social media feeds, multiplayer game interactions, and ride-sharing apps.

Source stream

URL

URL of the source document in the local file system or internet.

Interpret stream data as

• value1,value2,...,valueN, and fill into range:
• address,value:

Empty lines trigger UI refresh

When new data arrives

There are three features of this option:

• Move existing data down: the existing data is moved down in index and the empty space is filled by arriving data. In short, we deal in fix range of indexes.
• Move the range down: the arriving data is appended at the end of existing data and range of indexes to be processed is shifted.
• Overwrite existing data: the arriving data overrides the existing data.

Maximal Amount of Rows

Limit the maximum numbers of rows to a specified value or leave undefined, but limited to the Office Calc row limit.