I've seen spreadsheets with horribly complex, incomprehensible algorithms, that are so much easier and simpler to write in C++ or Python or any programming language.

BTW XLWare makes a great library LibXL to create genuine .XLSX files from a program.