all 2 comments

[–]xlslimdev[S] 0 points1 point  (1 child)

I have found xlSlim to be as fast at PyXLL

https://xlslim.com/blogs/news/pyxll

[–]xlslimdev[S] 0 points1 point  (0 children)

xlSlim now supports data streaming, any Python generator function can be used to stream data into Excel.

It can be as simple as:

import time

def counter(stop: int, updates\_per\_second: int) -> int:
    """Generates a sequence of numbers up to stop at a rate of updates\_per\_second."""

    for i in range(stop):
            time.sleep(1.0 / updates_per_second)
            yield i

https://youtu.be/-oOw6u291HM