New in PyXLL 5.11
The following functions relate to PyXLL’s Least Recently Used function cache.
See Cached Functions for additional details.
Returns a dictionary of stats for the LRU cache.
When called with a function, a dictionary with the following keys is returned if a cache for that function is found:
maxsize - maximum number of cached reuslts, or 0 if unbounded
currsize - current number of cached results
hits - number of times a cached result has been returned
misses - number of times the function was called without finding a cached result
If called with no function, a dictionary of function names to dictionaries as described above is returned for cached functions.
function – Function to get cache info for, or None for all cached functions.
Clears cached result from the LRU cache.
When called with a function, cached results for that function only are cleared.
If called with no function, all cached results are cleared.
function – Function to clear cached results for, or None for all cached functions.
Hashable and comparable key object used for storing results in a custom function cache.
This is an opaque class with no public properties or methods.
See Alternative Caching Methods for details.
Value stored and returned by custom function caches.
This class wraps the actual Python value returned from cached function, but also contains other information to reduce the work required each time the value is returned to Excel.
The underlying returned value is available as the value property, unless the function failed in which
case the error is available using the exc_info property.
Both the value and exc_info objects should be considered immutable and modifying them in any way
may result in unexpected behaviour.