ASP tables to Excel

I am using ASP to generate an HTML table
from a database. I use FSO to output a file
with an XLS extension then open it.

I can set the column width and row height;
I can set the font family, size, and weight.
I know I can include formulas in a "cell".

What else can I do when I generate the table that
will take effect when the file is opened in Excel?

I'd like to do things like autofit and sorting.

The client does allow Office Automation on
the server so I can't write to Excel directly.

Thanks in advance for any advice or links.