I am only posting this with a disclaimer that I wrote this almost 3 years ago, but I thought that maybe someone might be able to use it. It creates a really old Excel file format, but it does support some text formatting and the freezing of panes, page headers, and page footers. With that said, this code will allow you to create an Excel spreadsheet without any knowledge of Excel.
The file information is written in binary so you could use this on an AS/400 or Linux or any other platform that Notes/Domino runs on.
In the attached zip file there are two lss files that are needed and a pdf explaining the code and how it came to be.