The SCAN function lives in a single cell and spills the results down the column, ensuring my totals are always structurally ...
Libxlsxwriter is a C library that can be used to write text, numbers, formulas and hyperlinks to multiple worksheets in an Excel 2007+ XLSX file.