XEROF

xlsgen 4.5.0.44 : Excel 365 functions

Build 4.5.0.44 of xlsgen adds read and write support for Excel 365 functions related to the recently announced (by Microsoft) dynamic array functions, namely :

=RANDARRAY([rows],[columns]) : returns an array of random numbers between 0 and 1.
=SEQUENCE(rows,[columns],[start],[step]) : generates a list of sequential numbers in an array, such as 1, 2, 3, 4.
=FILTER(array,include,[if_empty]) : filters a range of data based on criteria you define.
=UNIQUE(array,[by_col],[occurs_once]) : returns a list of unique values in a list or range.
=SORT(array,[sort_index],[sort_order],[by_col]) : sorts the contents of a range or array.
=SORTBY(array, by_array1, [sort_order1], [[by_array2], [sort_order2]],…) : sorts the contents of a range or array based on the values in a corresponding range or array.
=SINGLE(value) : returns a single value using logic known as implicit intersection.