XEROF

xlsgen 4.9.0.27 : 14 new functions

Build 4.9.0.27 of xlsgen adds read and write support for 14 new functions, introduced in the subscription-based Excel version earlier in May 2022 by Microsoft.

TEXTBEFORE	Returns text that’s before delimiting characters
TEXTAFTER	Returns text that’s after delimiting characters
TEXTSPLIT	Splits text into rows or columns using delimiters
VSTACK	Stacks arrays vertically
HSTACK	Stacks arrays horizontally
TOROW	Returns the array as one row
TOCOL	Returns the array as one column
WRAPROWS	Wraps a row array into a 2D array
WRAPCOLS	Wraps a column array into a 2D array
TAKE	Returns rows or columns from array start or end
DROP	Drops rows or columns from array start or end
CHOOSEROWS	Returns the specified rows from an array
CHOOSECOLS	Returns the specified columns from an array
EXPAND	Expands an array to the specified dimensions