Build 5.0.0.54 of xlsgen adds support for 11 functions in the calculation engine (read/write was already supported) :

- TEXTAFTER(text;delimiter;[instance_num]; [match_mode]; [match_end]; [if_not_found])
Returns text that is after a delimit character

- TEXTBEFORE(text;delimiter;[instance_num]; [match_mode]; [match_end]; [if_not_found])
Returns text that is before a delimit character

- TEXTSPLIT(text;col_delimiter;[row_delimiter];[ignore_empty]; [match_mode]; [pad_with])
Splits text into rows or columns according using delimit characters

- XOR(logical1; [logical2],…)
Returns a logical exclusive OR of all arguments

- IFNA(value; value_if_na)
Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression

- DAYS(end_date; start_date)
Returns the number of days between two dates

- EDATE(start_date; months)
Returns the serial number of the date that is the indicated number of monts before or after the start date

- EOMONTH(start_date; months)
Returns the serial number of the last day of the month before or after a specified number of months

- ISOWEEKNUM(date)
Returns the number of the ISO week number of the year for a given date

- WEEKNUM(serial_number;[return_type])
Returns the week number in the year

- NETWORKDAYS(start_date; end_date; [holidays])
Returns the number of workdays between two dates with custom weekend parameters