Because I'm old and it still works, I use vb6 to create excel (from SQL stored procedures) and format within the vb code.

I've been sending various reports to people in my agency this way for years and they love it.

We have a dedicated machine that runs the vb.exe file when scheduled.